PROFESSIONAL SUMMARY:

Results - driven senior analyst offering demonstrated success in designing and developing automated systems, facilitating outcomes across multiple departments and disciplines, creating functional and secure electronic record tracking systems, maximizing margins and profit, and creating internal systems designed to achieve targeted outcomes.

TECHNICAL SKILLS:

Hardware: IBM PC s and Compatibles, VAX, AS400Operating System MS-DOS, Windows

Operating System: MS-DOS, Windows 9x/2000/NT/XP, Windows 7, Windows 10, UNIX, VAX, AS/400

Languages: T-SQL, Visual Basic, C, VBA, vbscript, jscript. PL/SQL, HL7

Software/Tools/Technologies: MS Visual Studio, MS SourceSafe, MS Office, ERWin,8, SQL Server Integration Services, Cognos, Precision Business Intelligence, ADO, RDD, OOAD, DAO, ETL, MS COM, ODBC, UML, GUI Design and Development, n-Tier architecture, Client Server

Database: MS SQL Server 2000/2005/2008/2012 , Oracle, Sybase, MS Access 2010

PROFESSIONAL HEALTHCARE IT EXPERIENCE:

Confidential

ETL/Data Conversions Analyst

Responsibilities:

• Participated in system conversion discovery and conversion implementation schedule
• Created complex T-SQL based data extracts for the following GE Centricity Enterprise and Allscripts Touchworks subject areas - Patient (encounters, active problems, histories (medical, social history, smoking), procedures, lab annotations, orders and results, point of care results, transcriptions, referrals, diagnosis, and appointments).
• Documented a process used to load the raw database, transform the data, populate the staging database, and transmit the Hl7 data from the Mirth Connect HL7 interface engine to the Epic Bridges HL7 interface engine.
• Assisted in the creation of the Raw and Staging Databases.
• USED T-SQL and SSIS to extract source system data and populate the raw and staging databases.
• Performed HL7 error troubleshooting
• Created validation scripts used to verify patient records for both small scale (30-50 records), and large scale ( records) testing.
• Created data element translation mappings from source system to Epic target system

Confidential

Senior Programmer Analyst

Responsibilities:

• Created ad-hoc T-SQL based reporting for ancillary legacy applications
• Completed hospital points-of-care conversion for hospital patient education video system
• Completed hospital patient education video scheduling
• Help Desk - Application support (daily and on-call)
• Provided level 2 and 3 support for daily production issues, maintaining documentation in the appropriate tracking systems while adhering to prescribed escalation procedures

Confidential

Senior Systems Analyst

Responsibilities:

• Claim form logic analysis, code, test, and maintenance for all insurances for new Alegent groups and existing Confidential groups
• Trouble shooting and resolution of payer claim rejections
• Maintenance and creation of existing and new Practice Management System and EHR (T-SQL and Analytics based) reports
• Completed shut down of daily Cardiology image download process
• Maintenance, monitoring, and error resolution of existing EHR interfaces
• Design, test, and build of new EHR interfaces
• Help Desk - Application support (daily and on-call)

Confidential

Interface Programmer/Analyst

Responsibilities:

• Analyzed functional requirements and coordinated technical aspects of design, development, testing, and implementation of HL7 interfaces. Worked with both internal and vendor resources.
• Designed, developed, tested, and implemented HL7 interfaces including Cardiology orders/results(Echo, Vascular, Nuclear Medicine), Radiology orders/results, ADT, and Charge
• Monitored and maintained existing interfaces on Connectr system
• Conducted research and resolution of interface errors. Trained resolution to non-technical personnel.
• Used T-SQL scripts and VBA code to identify and to provide resolution of error

Confidential

Interface Programmer/Analyst

Responsibilities:

• Architected and implemented an automated process used to extract patient Cardiology document images and insert into patient’s charts in the electronic health care record. This saved over $25,000 in outside vendor development costs.
• Constructed all T-SQL extract scripts using our current reporting data warehouse to support Meaningful Use criteria for government stimulus for electronic healthcare record adoption, saving thousands of dollars of outside vendor development costs.
• Designed and built an automated interface application that extracts, processes, and produces reporting of DIABETES MANAGEMENT data as required by the Nebraska UniNet state agency
• Analyzed functional requirements and coordinated technical aspects of design, development, testing, and implementation of EHR interfaces. Worked with both internal and vendor resources
• Designed, developed, tested, and implemented HL7 interfaces including lab and radiology orders/results, ADT, HIE, Charge, and Transcriptions
• Collaborated with EHR Support Specialists on interface error handling processes and procedures.
• Participated in design, documentation, and execution interface test plans.
• Monitored and maintained existing interfaces on ConnectR system.
• Performed data analysis, reverse engineering, and decryption of the Connectr interface SQL database engine to obtain metadata used for internal analysis and reporting
• Performed data analysis and reverse engineering of the Allscripts Touchworks EHR SQL database for ad-hoc T-SQL reporting. Types of reports include, but are not limited to orders, results, tasking, diabetes, patient reporting(demographics, active problems, past medical and surgical history, current medications, vitals, immunizations, allergies, referrals, and appointments)
• Designed and developed applications used to support current interface and EHR functionality
• Help Desk - Application support (daily and on-call)
• Troubleshooting issues and providing resolution

Confidential

Senior Programmer/Analyst

Responsibilities:

• Managed and developed entire month-end practice management reporting system in PBI Analytics using PBI worksheet objects, analysis objects, and custom report objects. Produced over 70 reporting objects
• Provided customer service, including tier 2/3 and request ticket support for GE-IDX Flowcast practice management system
• Reverse engineered practice management system data warehouse database to obtain source to destination data mappings
• Daily PL/SQL and T-SQL ad-hoc reporting
• Claim form logic analysis, code, test, and maintenance for all insurances
• Claim edit analysis, code, maintenance, and testing
• Automation of claim form edit reports - used by senior management, IT staff, and all claim follow up personnel. This application saved countless hours of claim edit research and has enabled thousands of dollars of claims to process. Used MS Access and VBA
• Extracted, formatted and provided all test data reports used for new medical practice management system (IDX) integration testing
• Help desk support
• Ad-hoc SQL query and design analysis
• Help Desk - Application support (daily and on-call)