James R Andersen

**** **** *****, **** ****** NY 11554 H: 516-***-**** C: 516-***-**** adbvvl@r.postjobfree.com www.linkedin.com/in/jamesrandersen

Professional Summary

Dedicated, effective analyst who has over 20 years’ experience utilizing proven methods and cutting-edge technology to successfully cut costs, streamline operations, and increase productivity. Diversity gained in working in Healthcare, Banking, Proxy Voting, Warehousing, Construction, Wholesale, Retail, and Publishing industries. Heavy SQL experience and versed in Medicare and Medicaid procedures with over 12 years of analytical and supervisory background with Health Care companies. Professional, using exceptional technical and business exposure which enhanced effective collaboration between the IT Department, business units and stakeholders. Accomplishments

• Substantial BPM experience involved in designing of document management systems, workflow automation, 3-tiered applications.

• Led the replacement, upgrades, and parallel testing of several main healthcare systems.

• Perform data analysis to create intuitive Revenue Cycle applications and reports that saved a company $4 million.

• Created applications and financial reports for the Governor of Storm Recovery (GOSR) for New York State. Business Experience

Full software development lifecycle (SDLC) experience for projects in Finance, Billing, Direct Mail, Human Resource, budgeting, tracking programs, as well as Computer Operations systems automation. Client/Vendor relationships, Executive Team leadership. Core Qualifications

SERVERS OS PROGRAMMING

● Windows NT/Y2K## ● MVS/JES2 ● VBA, VBScript, VB6, C#, MVC, HTML, JAVA,

● MS SQL Server ● VSE/POWER SQL, TSQL, ADO.NET, JScript, API, HL7,

● Exchange Server ● Series1 Crystal Report Writer, SSRS, SSIS /ETL

● Pervasive DB, PKMS DB ● XP, WIN7, 8, AND 10 ● SourceSafe, Team foundation, GIT

● BES Express, ONBASE ● Macintosh OS, LINUX ● Familiar with: SCRUM, ITIL, AND AWS

● UNIX SCO, NOVELL, ORACLE ● Android, IPhone AND Blackberry

● CITRIX: XENAPP, VMware/Linux

SOFTWARE

● MS Office 365, Y2K## Suite ● GLMI (Ubiquity), McKesson (Horizon), ● Active Directory: (GPO, DHCP, DNS, WINS,

● MS Access, Tableau, Power BI Thornberry (NDOC) NPS RADIUS)

● ATB, Business Works, Kofax ● Visage (Imaging), Powerscribe (Dictation), ● MS Visio, Spiceworks, SCCM, Ghost,

● HR Softwaretech suite (Soft time, Primordial (Workflow), Synapse (PACS) ● Bit Locker, PGP HR Manager, Timekron) ● SQL Server Management Studio, Visual Studio Employment History

Randstad Technologies, Atlanta, GA (Contracted to Proxytrust, Islandia, NY) Oct 2019 – Dec 2019 IT Consultant / Project Manager

• Initiate, plan, and track the progress of application modifications and installations.

• Assess manual processes and convert the process into computer automated tasks utilizing VB6, C#.net and Excel.

• Build relational normalize databases, tables, triggers, views, functions, procedures, and queries.

• Escalate problems to the appropriate vendors, document and kept track of progress. Winsor Consult Group, New York, NY at the Governor’s Office of Storm Recovery Apr 2017 – May 2019 Financial Applications Programmer

• Conceptualize, develop and deploy integration solutions between major databases utilizing Oracle, OnBase and MS SQL Servers.

• Create relational normalize databases, tables, triggers, views, functions, procedures, and queries.

• Mentor members on the QA team to develop programs utilizing SQL and TSQL queries and serve as a knowledge base to the team.

• Develop reports employing MS Office 360 Suite, SharePoint, SSRS, Excel and MS Access; programing in VBA, C#, .NET framework.

• Create smart spreadsheets templates, input data files from various sources and matched data against these templates as a QA measure.

• Utilize MS Visio to further analyze existing business processes in order to perfect end user interfaces, and workflows.

• Perform comprehensive regression testing when application bugs were resolved.

• Analyze and document the workflow of a major application for State audit.

• Collect and develop content for monthly deliverable reports and presented to all hands’ monthly presentation. Zwanger-Pesiri Radiology Farmingdale, NY Apr 2016 – Apr 2017 RIS/PAC Application Support

• Support the Radiology applications (Powerscribe, Visage, Primordial, Synapse, and DICOM routing) in a clinical environment.

• Analyze clinical office workflow and how it is relates to the radiology applications and suggest improvements.

• Perform troubleshooting and ask probing questions to locate root cause of software, HL7 application errors and restored images.

• Assist members on the team to develop SQL queries for ad-hoc reports and served as a knowledge base.

• Develop departmental applications to increase productivity utilizing HTML, C#, Jscript, VBA, and MS Access. James R Andersen P a g e 2

• Robert Half, Garden City, NY (Contracted to Health Plus Management, Garden City, NY) Dec 2015 – Jan 2016 IT Programmer Consultant

• Create Ad-hoc financial reports utilizing VBA, Excel, Crystal reports, SSIS, and SSRS.

• Create an Arbitration tracking application utilizing MS Access.

• Initiate an in-depth regression test when application bugs were determined. Health Tech Resources, LLC, Phoenix, AZ (Contracted to CenterLight Health System, Bronx, NY) Jun 2015 – Sep 2015 IT Implementation Consultant

• Facilitate the implementation of the EMR Horizon home care software.

• Performing data cleansing using SSIS/ETL to ensure high confidence and data integrity was being passed to the new EMR system.

• Educate back office and clinical users on the use of the new EMR software both in an individual and classroom environment. Total Personal Service Administrative Group LLC, Garden City, NY Nov 2013 – May 2015 IT Programmer

• Analyze and refactored program coding in COBOL, utilization of CICS, JCL, DB2, VSAM and Endeavor source code management tool.

• Build applications utilizing COBOL, C#.net, VBScript, HTML, JScript, CSS.

• Oversee office automation utilizing Kofax document processing for scanned documents; utilize SSIS/ETL to transfer data into the financial system.

• Create reports utilizing COBOL, Excel, MS Access, and programmatically convert reports to PDF files.

• Implement VMware software and train the IT Department staff to configure the Operating System and install OS applications. VIP Certified Healthcare Services, Inc. Brooklyn, NY Feb 2012 - Oct 2013 IT Director/Programmer

• Primary point of contact and the overall account owner who maintained an effective working relationship with stakeholders.

• Create the Information Technology and Helpdesk departments.

• Perform capacity planning for the creation of a new Data Center utilizing Citrix, VMware, and Fiber optics for communications.

• Implement VMware software and train the IT Department staff to configure the Operating System and install OS applications.

• Draft guidelines, and policies for the IT Department and document applications and processes.

• Facilitate the implementation of new EMR McKesson Horizon home care system utilizing remote laptops for field nurses.

• Evaluate Conduct data cleansing from legacy system utilizing SSIS/ETL tools to ensure data integrity is being passed to the EMR system.

• Monitor equipment functionality to verify optimal performance and made initiative-taking adjustments to system controls.

• Execute operational test on new systems and equipment to reinforce proper processes and remedied malfunctions.

• Design financial applications and reports utilizing SQL, SSRS, Excel, MS Access, and VBA.

• Escalate communication, software, and software synchronization issues to the appropriate vendors, kept track of progress.

• Participated on the Implementation Software and Professional Advisory Committees. Family Care Certified Services, Inc., Hicksville, NY Sep 2001- Jan 2012 IT Director/Programmer

• Primary point of contact and overall account owner who maintained an effective working relationship with stakeholders.

• Capacity planning, as well as the data retention to insure proper operations of all systems in a multi-location environment.

• Improve the end-user experience by overhauling the Data Center’s communications to improve communications between remote sites.

• Recommend, and redesigning the data center utilizing SAN, Citrix XENAPP, and VMware to establish expandability for the future.

• Implement VMware software and train the IT Department staff to configure the Operating System and install OS applications.

• Establish the utilization of laptops for the field nurses.

• Manage the Data Entry department, encompassing staff of 15 associates

• Expand the IT Department to incorporate the Helpdesk, Network, and Data Security departments as well as interviewed and hired staff of 10.

• Analyzed workflow and design applications and PowerPoint presentations for the clinical department.

• Recuperate $4 million from Medicare, designed financial applications and reports utilizing SSRS, Excel, MS Access, and VBA coding.

• Maintenance of the EMR systems; utilizing SSMS to re-index, reorganize, backup, and restore databases as well as install upgrades.

• Educated staff on new applications and guided the financial team to develop SQL queries for ad-hoc reports and be a knowledge base.

• Escalate problems to appropriate vendors, kept track of progress. And draft guidelines, and policies for the IT Department. Certificates

Basic Xactimate Training Course DB2 Application programming CICS command level McKesson – Technical Administration of Laptop Device McKesson - System Administration Scrum the Basics Education

Queens College (City University of New York) ~ 93 credits towards bachelor’s degree State University of New York at Farmingdale, Associate Degree in Applied Science in Data Processing.

Contact this candidate