Ankit Gupta

Experience

• 

  Wipro

  Mar 2011 - Jan 2014

  Project Engineer

  Domain :- Retail▪ Understanding the Requirement Document, HLD, LLD, Physical Data Models and ETL Mapping Documents▪ Implementing ETL Development solutions and preparing Development Implementation Plans and Solution Design Documents▪ Create briefs and presentations for Project Review explaining the impact analysis on dataattributes▪ Conducting Data Analysis and Data Profiling and using TDD (Test Driven Development) approach for SAS DI Development▪ Creating Migration Plan, Deployment Documents, Impact Analysis Documents▪ Conducting Code Reviews, Unit Testing, Creating SAS Packages and Package Deployment, Scheduling the Job Flow▪ Integrating the Semantic Data Layer of IBM DB2 with IBM Cognos Reporting tool to populate the correct data on the GUI front end, creating Reports and Dashboards and validating the same with the use of filters used in the SQL Query▪ Performing the data quality check by creating data profiling techniques by the use of aggregate functions of SQL and advanced Excel formulae to examine the sample record sets▪ Created data securable and did end-to-end implementation Show less

• 

  UnitedHealth Group

  Jan 2014 - Sept 2021

  Domain:- Lead Engineer responsible for end to end delivery of a project, provides datawarehouse solution and design using ETL tools, Python, Airflow , SQL, Perl, Teradata.Manages resources and connect with business users for requirement analysis.provide optimal and near real time solution to the users.

  • Data Engineering Lead

    Jan 2020 - Sept 2021

  • Senior Data Engineering Analyst

    Jan 2018 - Jan 2020

  • Senior IT Quality Analyst

    Jan 2014 - Dec 2017
• 

  Cognizant

  Sept 2021 - Jun 2022

  Manager-Projects

  Domain:- pharmaceutical Worked as Engineering Manager and responsible for end to end delivery of ETL application and administration , Connect with business users understand the business requirements and provide an optimal solution for business problems

• 

  EXL

  Jun 2022 - now

  Senior Manager- Analytics