Etl Engineer Resume
Lumberton North, CarolinA
SUMMARY:
A highly accomplished IT professional with experience in data extraction, business analysis, implementation, migration, interfacing, and software integration. Demonstrated success in meeting compressed deadlines with multiple projects. Recognized for the ability to work independently or collaborate with talented teams to develop scalable and lasting solutions to meet and exceed requirements.
COMPUTER SKILLS:
Databases: Microsoft SQL Server, SSIS, SSRS, Oracle, PL/SQL, LINQ, MySQL, Entity Framework, IBM Informix, Visual FoxPro
Programming: Visual Basic, C#, Java, C++
Web: HTML, PHP, CSS, LAMP, jQuery
Operating Systems: Windows Server, Unix/Linux, MacOS
Software: Microsoft Office, Crystal Reports, Team Foundation Server, Subversion, Visio
EXPERIENCE:
Confidential, Lumberton, North Carolina
ETL Engineer
Responsibilities:
- Developed complex SQL queries to validate, format, cleanse, and migrate data to Epic EMR.
- Developed C# .NET application to extract data and build HL7 messages.
- Identified and extracted progress notes, EKG results, spirometry reports, immunizations, labs, and legacy accounts receivable from eClinicalWorks EMR.
- Worked with stakeholders, production teams, and product vendors to resolve issues and discuss solution options.
Confidential, Winston - Salem, North Carolina
Data Integration Engineer
Responsibilities:
- Designed and coded SQL queries to migrate legacy systems to Epic EMR.
- Resolved performance issues through analyzation of execution plans and SQL tuning.
- Developed advanced scripts to extract clinical data from Allscripts TouchWorks.
- Worked closely with data integration team to follow data specification requirements.
Confidential, Greenville, South Carolina
Database Programmer
Responsibilities:
- Designed and coded SQL queries to transform and archive data from legacy systems.
- Contributed to team of personnel to analyze, troubleshoot, and resolve issues with connectivity and file specifications.
- Developed advanced queries to extract relevant measures from Allscripts Pro, Misys, and eClinicalWorks.
- Worked closely with clinic administration and IT departments throughout the data extraction process.
Confidential, Carlsbad, California
Data Extraction Engineer
Responsibilities:
- Designed, coded, documented, tested, debugged, and supported SQL queries to create structured flat files including Patient Problems, Medications, Vitals, Immunizations, Allergies, Medical Record Notes, Surgical History, Pathology Reports, and Radiology Narratives..
- Utilized Microsoft SSIS packages with C# .NET script tasks to control data flow and automate data extraction jobs.
- Contributed to team of personnel to analyze, troubleshoot, and resolve issues with file specifications.
- Developed advanced queries to extract relevant measures from Allscripts TouchWorks EHR.
- Worked closely with hospital administration and IT departments throughout the development process.
Confidential, Boxford, Massachusetts
Integration Engineer
Responsibilities:
- Designed, coded, documented, tested, debugged, and supported VB .NET extract applications to support PtAccess patient portal via HL7 messaging including Patient Problems, Medications, Vitals, Demographics, Appointments, Registration, Encounter Summaries, and Lab Reports.
- Utilized Application Programming Interface (API) techniques using VB .NET to script EMR client applications to generate required reports.
- Developed dashboards to present Stage 1 and Stage 2 meaningful use and clinical quality measures (CQM) for both large health care facilities and individual providers.
- Contributed to team of support personnel to analyze, troubleshoot, and resolve issues 24X7 on a rotating schedule.
- Developed complex queries to extract required clinical data from multiple EMR vendors including Meditech, Medhost, GE Centricity, Allscripts, McKesson, Epic, Cerner, Picis, and eClinicalWorks.
- Worked closely with hospital administration and IT departments throughout the development process.
- Created solutions to extract patient data and create HL7 messages for distribution across platforms.
- Supported patient portal and meaningful use dashboards through automated data extraction and interfacing, giving the patient a more informed and proactive experience.
- Performed research to ensure operational functionality and meet customer expectations.
Confidential, Knoxville, Tennessee
Software Development
Responsibilities:
- Leadership role in migration of legacy system to C# .NET platform to increase employee productivity.
- Administered requirements discovery, SQL Server database design and implementation to enforce validation rules and data integrity.
- Improved Windows forms interface design enhancing user experience and streamlining workflow.
- Delivered tools and solutions by accelerating workflow, streamlining process, and improving analytics to drive results.
Confidential, Knoxville, Tennessee
Systems Analyst Intern
Responsibilities:
- Performed systems analysis using AGILE methodologies engaging in detailed interviews and close interactions with stakeholders.
- Collaborated on database design and scripting enabling project managers to track budgets and manage teams.
- Maximized user interface design preserving existing functionality and implementing new requirements.
Confidential, Knoxville, Tennessee
Software Development
Responsibilities:
- Developed, implemented, and performed quality assurance for point of sale (POS) touch screen software using C# .NET framework achieving productivity gains through fewer interactions in the POS transaction timeline.
- Migrated Visual FoxPro code to C# .NET platform and SQL Server in order to improve performance, create new features, and enhance existing features.
- Negotiated contracts with vendors to establish marketing plans and sales targets.
- Worked closely with vendors to implement marketing programs and strategies.
- Authored a business plan and sales strategy in highly competitive retail environment.
Confidential, Knoxville, Tennessee
Software Development
Responsibilities:
- Migrated Visual FoxPro code to C# .NET platform and SQL Server in order to improve performance, create new features, and enhance existing features.
- Conducted in-depth analyses of product movement, identifying and tracking market trends.
- Presented findings to management in an effort to aid company in meeting and/or exceeding contractual obligations.
- Negotiated contracts with vendors to establish marketing plans and sales targets.
- Employed SSIS and SSRS to automate data and reporting requirements by customers, vendors, and state and federal regulatory agencies.
- Saved $40K in capital expenditures by implementing MSA data reporting capability.