We provide IT Staff Augmentation Services!

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.

Hire Now