Hiteshi Sharma

Client: Centers for Medicare & Medicaid Services (CMS), U.S. Government

CMS is a US Federal agency within the Department of Health & Human Services responsible for administering national healthcare programs. CMS oversees Medicare and Medicaid services, ensuring these programs provide access to quality, affordable health care while maintaining compliance with federal regulations.

Role and Responsibilities

• Developed and implemented end-to-end ETL pipelines, ensuring seamless data integration and delivery in alignment with Health Insurance Exchange (HIX) project requirements
• Continuously optimized and enhanced ETL processes to improve performance, scalability, and maintainability, resulting in increased efficiency and reduced latency
• Utilized Control M to create, schedule, and orchestrate ETL jobs and workflows, streamlining data processing and ensuring timely execution of production tasks
• Proactively monitored and managed ETL production runs, diagnosing and resolving issues promptly to minimize downtime and ensure data integrity and availability
• Conducted rigorous unit testing and debugging of ETL components and workflows to identify and rectify defects, ensuring the reliability and accuracy of data transformations and load operations
• Engaged closely with the business stakeholders for the information gathering as well as ensuring timely deliverables.
• Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
• Collaborated with system architects, design analysts and others to understand business and industry requirements.

• Actively engaged in learning foundational principles and concepts of data warehousing, including data modeling, ETL processes, data integration, and data governance
• Assisted in gaining proficiency in Informatica PowerCenter by participating in basic tasks such as mapping development, workflow creation, and session configuration under supervision
• Acquired knowledge in claims processes and data structures relevant to the HIX project, including understanding of claim adjudication, payment processing, and data requirements specific to healthcare insurance claims
• Developed skills in writing and executing complex SQL queries to extract, manipulate, and analyze data from relational databases, ensuring accuracy and efficiency in data retrieval.
• Collaborated with cross-functional teams to ensure timely project completion and seamless communication.