SAGAR NAYANA

adprbw@r.postjobfree.com 571-***-**** Fairfax, VA 22030

Summary

Reliable Database Analyst with more than 6 years of career in Healthcare IT. As an ETL team member, I was responsible for extracting legacy data from various data sources for large hospitals in the USA. Strong experience creating complex custom scripts and SSIS packages to support extraction and transformation from different legacy databases. Professional Experience:

• Thorough understanding of US Healthcare Workflows.

• Worked on multiple modules under the Healthcare domain such as Clinical, Patient Accounting, Laboratory Information System, Supply Chain Management.

• Expertise in Data extraction, conversion, and migration techniques.

• Experience in building ETL processes for legacy data conversion to Epic.

• Experience working with large databases

• Excellent T-SQL Programming skills.

• Hands-on experience in tuning mappings/queries, identifying and resolving performance bottlenecks at various extraction and transformation levels.

• Experience in analyzing redundant and inconsistent data.

• Experience in data warehousing techniques for Data Analysis, Data Profiling, Data Cleansing, and Transformation.

• Experience in implementing HL7 Interfaces using integration engines like GE ConnectR, Integration Buddy.

• Working knowledge of HL7 v2.x, ICD 9/10, RxNorm, SNOMED-CT.

• Experienced in handling simple to complex mappings performance and optimization issues involved with complex mappings, sessions, and workflows.

• Excellent team player with strong interpersonal communication.

• Ability to work on multiple tasks to meet strict deadlines in a fast-paced and demanding environment.

• Proactive and resourceful professional with a track record of success to ensure customer needs are met, and satisfaction remains high with every project.

• Provide accurate estimates to contribute to successful project planning and progress monitoring.

• Excellent time management with a significant focus on details.

• Adaptable and driven with a strong work ethic and ability to thrive in team-based settings and succeeds in high- pressure environments.

• Highly organized, proactive, and punctual with a team-oriented mentality. Skills

• Healthcare Interoperabilities: HL7 v2.x, ICD 9/10, RxNorm, SNOMED-CT.

• Healthcare Domain: Electronic Health Record (EHR), Electronic Medical Record (EMR).

• Databases: SQL Server, Oracle, InterSystems Cache, MySQL, PostgreSQL.

• Integration Engines: GE ConnectR, Integration Buddy.

• Business Intelligence Tools: SSIS

• HealthCare Applications: Allscripts TouchWorks EHR, Allscripts Enterprise Practice Management System,

Allscripts Netsmart Homecare, Allscripts Sunrise

Eclipsys, Allscripts ED, Allscripts EDIMS, GE-MUSE, GE- RIS, Cerner – Sparks, Cerner - Legacy, Cerner – EAD, Cerner – Signature, Cerner – Siemens, Athena, eClinical Works, Horizon Labs, Horizon Clinicals, WellSoft,

McKesson Paragon Material Management, McKesson

Paragon Supply Chain Management.

Experience

Creative Information Technology Inc

Database Analyst

04/2018 - Current

• Analyzed multiple source systems and, based on business requirements, build the transformation rules to extract, transform & load data into an archival application.

• Extracted Medical records from various heterogeneous sources like SQL Server, Oracle, InterSystems Cache, MySQL, PostgreSQL, and Flat Files.

• Worked on archiving legacy data for large hospitals across the USA.

• Worked on writing custom SQL queries for cleaning data from the source and populating it into staging tables, testing, and the Production environment.

• Hands-on experience in various modules like Clinical, Patient Accounting, Laboratory Information System, Supply Chain Management.

• Built SSIS packages to load files from various sources.

• Enhanced functionality and performance of several SQL scripts and stored procedures using UDF's and CTEs along with SQL Profiler.

• Provided excellent customer service to the functional team by pro-active follow-ups.

• Consistently met deadlines and requirements for all deliverables.

• Continuous improvement by utilizing new tools/scripts for optimal delivery and quality enhancement.

• Working closely with the new team members to help them understand and speed up with database scripts.

• Partnered with the project management team on the development of scope and timelines.

• Worked with ICD 9/10, CPT, SNOMED-CT, RxNorm Codes.

• Experience in working with large databases of more than 10 Terabytes in size.

• Experience in creating and managing millions of medical documents based on discrete clinical data using custom queries as per the clients' requirements.

• Involved in Azure data migration efforts to move static data to the cloud. Creative Information Technology Inc

Junior Database Analyst

01/2016 - 03/2018

• Experience in understanding US Healthcare Workflows.

• Worked in Data extraction, conversion, and migration projects.

• Built ETL processes for legacy data conversion to Epic.

• Worked on writing custom SQL queries for cleaning data from the source and populating it into staging tables, testing, and the Production environment.

• Extracted Medical records from various heterogeneous sources like SQL Server, InterSystems Cache, PostgreSQL, Flat Files.

• Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.

• Worked on Ad-Hoc queries to deliver the patient reports as per the clients' requirements.

• Worked on extracting discrete medical records data from various heterogeneous sources like SQL Server, InterSystems Cache, PostgreSQL.

• Wrote scripts and processes for data integration and bug fixes.

• Worked on creating and automating the SQL Jobs.

• Consistently met deadlines and requirements for all deliverables.

• Hands-on experience in various modules like Clinical, Patient Accounting, Laboratory Information System.

• Hands-On experience in ICD 9/10, CPT, SNOMED-CT, RxNorm Codes. Creative Information Technology Inc

Interface Analyst

12/2014 – 12/2015

• Hands-On experience in HL7 v2.x Interface Development.

• Experience in understanding US Healthcare Workflows.

• Hands-On experience in Integration Engines like GE ConnectR, Allscripts Interface Engine.

• Designed and installed different interfaces between Allscripts and vendors like EPIC.

• Worked with SSIS as a Business Intelligence tool to help with analysis.

• Supporting the TouchWorks EHR Application based on the requirements from providers.

• Wrote user manuals and other documentation for customer toll-out training sessions.

• Implemented unit and integration testing protocols to consistently deliver high-quality, functional features with minimal defects.

• Instrumental in modifying unit and integration tests to improve software quality and reliability.

• Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.

Education

Bachelor of Science in Computer Science Technology Training

• HIPAA Certification

• HealthCare Standards HL7.

• InterSystems Cache.

Certifications

• Oracle DBA Level - 1.

• Microsoft DP 900 – Azure Data Fundamentals

Contact this candidate