Shweta Sharma
Kaiserslautern
Summary
Creative data enthusiast with 9 years of experience in Data Analytics and proven success of working in fast paced environments with critical timelines.
Good understanding of Business Intelligence and Data Warehousing terminologies with experience in wide range of Analytical tools and technologies.
Overview
10
10
years of professional experience
Work History
Senior Consultant
PwC Germany
04.2023 - Current
- Worked on Internal project extracting data from client system using Halo platform
- This data was then used for analysis for Auditing
- Build new data models for different clients defining extraction solutions for data analysis
- Created tickets on Azure DevOps, Created scripts on Python, Used Git Hub for code deployments.
Senior Data Engineer
Deloitte US India Consulting
11.2017 - 01.2023
- Designed and implemented ETL solutions using Cloud platforms , ETL tools , Reporting tools , SQL scripting.
- Tech Lead of ETL solution's for Covid vaccination database in Azure , Health insurance database in AWS , Multiple warehousing projects in Databricks , SQL Server, Tableau , SAP BODS, Oracle.
- Lead design and implementations , code reviews , code optimizations, share knowledge and mentor junior resources.
- Optimized long running stored procedures to reduce running time from 3 hours to 5 minutes for loading 10 million records in a target Data Warehouse having 2 billion records.
- Designed Archive database and developed loading strategy for 7 million history data using batch scripts , ETL jobs.
- Created ETL frameworks for upcoming projects and gave meaningful insights for leveraging client data in best possible way.
Senior ETL Developer
Tata Consultancy Services
03.2014 - 11.2017
- Designed , built and maintained data profiling and data quality solution using Informatica Scorecards , SQL scripts for manufacturing client database with more than 20+ sources and hundreds of attributes.
- Optimized and delivered 40+ Data Quality scorecards every month.
- Conducted data modeling, performance and integration testing for 10+ complex modules loading data from mainframes , Oracle to SAP using Legacy System Migration workbench (LSMW).
Education
Bachelors of Technology -
Shivaji University
India06.2013
Skills
- ETL Tools - SAP Business objects data services (BODS) , Informatica Power center , Informatica Data Quality
- Azure Synapse Analytics , Azure Data factory
- Python , Pandas , Spark
- Databricks
- Snowflake
- Postgres SQL
- SQL Server Integration Services (SSIS)
- Oracle SQL
- Understanding of Hadoop ecosystem and Big Data
- Data Extraction , Data Migration
- Leadership skills
- Team Member Development
- Critical Thinking
- Complex problem solver
https://www.linkedin.com/in/shwetarsharma10/
Languages
English
Bilingual or Proficient (C2)
German
Beginner (A1)
Timeline
Senior Consultant
PwC Germany
04.2023 - Current
Senior Data Engineer
Deloitte US India Consulting
11.2017 - 01.2023
Senior ETL Developer
Tata Consultancy Services
03.2014 - 11.2017
Bachelors of Technology -
Shivaji University
Similar Profiles
Laura FlorezLaura Florez
Associate Consultant at PwC GermanyAssociate Consultant at PwC Germany
Niklas WürteleNiklas Würtele
Manager Finance Transformation/Business Analytics at Pwc germanyManager Finance Transformation/Business Analytics at Pwc germany
Victor Binyi TumentaVictor Binyi Tumenta
Group Manager | Regional Service Delivery Manager at HCL Technologies Germany, , GermanyGroup Manager | Regional Service Delivery Manager at HCL Technologies Germany, , Germany