Apurva Vashisht

Experience

• 

  Cognizant

  Jan 2020 - Apr 2020

  Programming Analyst Intern
• 

  Cognizant

  Sept 2020 - Sept 2022

  • Analyzed work to generate logic for new systems, procedures and tests.• Created transformation logic in Hue, linked multiple tables through joins in Toad and performed SQL operations on the columns.• Analysed data using Python and Informatica Analyst• Utilizing Excel to create Mapping documents, Metadata sheet to be uploaded and linked through AnalytixDS• Developed mappings, workflows and tasks using Informatica Developer.

  • Programmer Analyst

    Sept 2021 - Sept 2022

  • Programmer Analyst Trainee

    Sept 2020 - Aug 2021
• 

  IBM

  Sept 2022 - Jul 2023

  Data Engineer

  • Primary account lead for managing 5 US-based clients & their healthcare and insurance databases using data warehousing, ETL, and effective communication.• Created data workflows, ingested new fields in a complex data feed by creating appropriate logical fields whilst maintaining the set data ingestion guidelines.• Effectively managed data maintained and tested the data pipeline and acted as a consultant on resolving multiple issues regarding database issues to avoid potential errors. • Mentored both new employees as well as peers in various areas such as analytic testing, data drops and data investigations to foster development.• Increased customer satisfaction by conducting a comprehensive data investigation and recommending solutions to remedy ongoing data reconciliation issues.• Worked with the automation team on streamlining and reducing time consumption on manual tasks. Show less

• 

  Merative

  Aug 2023 - Feb 2025

  Data Engineer

  IBM Watson Health is now Merative. I work in Data Engineering, Client Consulting, Data Management, and Analytics on US Healthcare data. Following is an overall summary of my day-to-day tasks. • Managing, optimizing, overseeing, and monitoring data retrieval, storage, and distribution throughout the organization for multiple healthcare clients.• Designing and operating data processing systems and ETL frameworks.Created data workflows, and ingested new fields in a complex data feed by creating appropriate logical fields while maintaining the set data ingestion guidelines.• Effectively managed data maintained and tested the data pipeline and acted as a consultant on resolving multiple issues regarding database issues to avoid potential errors. • Mentored both new employees as well as peers in various areas such as analytic testing, data drops, installing new feeds, and data investigations to foster development.• Increased customer satisfaction by conducting a comprehensive data investigation and recommending solutions to remedy ongoing data reconciliation issues.• Worked with the automation team on streamlining and reducing time consumption on manual tasks.• Created Python scripts to perform data acquisition, storage, retrieval, wrangling, and pipeline automation. Show less

• 

  SLK

  Feb 2025 - now

  Senior Software Engineer

  • Leading the development and optimization of ETL pipelines for efficient data processing and migration. • Managing AWS-based data workflows, including Glue, S3, Athena, and Snowflake, to ensure scalable and high-performance solutions. • Designing and implementing data architecture solutions to support business intelligence and analytics. • Enhancing performance tuning, automation, and security for large-scale data processing. • Collaborating with cross-functional teams to drive cloud adoption and data-driven decision-making. Show less