APOORVA SHARMA
Noida
Summary
Associate Consultant specializing in cloud migration and data engineering at Tata Consultancy Services. Proven track record of enhancing operational efficiency through Azure Cloud solutions. Expertise in developing ETL solutions and building CI/CD pipelines. Demonstrated leadership skills ensuring successful project execution and team collaboration.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Associate Consultant
Tata Consultancy Services
Noida
02.2022 - Current
- Led cloud migration and stabilization efforts for Humana's IDEA - Pharmacy team..
- Migrated on-premises processes to Azure Cloud, enhancing operational efficiency.
- Developed PySpark notebooks in Databricks for batch and streaming data processing.
- Created mapping documents and identified dependencies to facilitate migrations.
- Managed data loading and maintenance in Unity Catalog and Snowflake Database.
- Scheduled job processes using Databricks Workflows and Prefect YAML configurations.
- Established Git repositories and implemented SonarQube scans for code quality assurance.
- Configured CI/CD pipelines to automate deployment processes.
Assistant Consultant
Tata Consultancy Services Ltd
Louisville
12.2018 - 01.2022
- Provided technical leadership for pharmacy processes in Humana's IDEA - Pharmacy team.
- Created design documents and led requirement walkthroughs with offshore teams.
- Developed mission-critical pharmacy claims processes utilizing Oracle Database, Cloud(Azure, GCP), Informatica, and Mainframes.
- Established secure file transmission connections with CMS and external vendors for data sharing.
- Coordinated test data setups and validations with SIT and UAT partners.
- Built CI/CD pipelines in Azure DevOps.
Consultant
Atos Syntel Inc
Phoenix
07.2016 - 12.2018
- Worked for Global Merchant Data Layer(GMDL) team in American Express.
- Developed and implemented DB2 and Mainframe solutions using PL/SQL stored procedures.
- Documented business logic for DB2 to Cassandra migration projects.
- Delegated tasks to offshore team members and conducted code reviews.
- Provided level two production support, collaborating with teams for incident resolution.
- Trained and onboarded new resources.
Software Engineer
Atos Syntel Inc
Navi Mumbai
02.2012 - 07.2016
- Worked for Global Merchant Data Layer(GMDL) team in American Express.
- Developed PL/SQL stored procedures in DB2 to function as APIs for Cassandra and mainframe processes.
- Wrote COBOL/JCL programs for file processing, extract generation, and data loading.
- Implemented QUEUE REPLICATION for DB2 to DB2 copy.
- Deployed code and managed scheduling using Service Now and Control-M platforms.
Education
Bachelor of Technology -
NSUT, East Campus
New Delhi06.2011
Skills
- Azure Data Lake Storage and Databricks
- PySpark development
- Data ingestion for batch and streaming methods, such as Kafka
- Workflow orchestration with Prefect (YAML)
- Cloud migration strategies (on-prem to cloud)
- Data modeling, database design, and data governance
Cloud computing
Database management
- Snowflake, Oracle, and DB2 databases
- SQL and PL/SQL proficiency
- GitHub and Azure DevOps
- CI/CD pipeline implementation
- COBOL programming
- JCL jobs
DevOps practices
Mainframe technologies
Certification
- AZ900 - Azure Fundamentals
- DP203 - Data Engineer Associate
Timeline
Associate Consultant
Tata Consultancy Services
02.2022 - Current
Assistant Consultant
Tata Consultancy Services Ltd
12.2018 - 01.2022
Consultant
Atos Syntel Inc
07.2016 - 12.2018
Software Engineer
Atos Syntel Inc
02.2012 - 07.2016
Bachelor of Technology -
NSUT, East Campus
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Prashant KashyapPrashant Kashyap
Consultant at TATA CONSULTANCY SERVICESConsultant at TATA CONSULTANCY SERVICES