Shivangi Srivastava

Project : HSBC

Role : Data Analyst

• Worked extensively on ESG client datasets of vendors like : MSCI , ClarityAI, Bloomberg , Morning star and S&P.
• Designed and developed Combined data assets on GCP using Pyspark and Python , 100% as per the Business requirement with overview of pre and post data comparison.
• Implemented and improvised Data control checks to check the accuracy of the data. Achieved 95 % more accurate results.
• Experience in migrating combined data assets from GCP to Hadoop.
• Created Master data assets for vendor data and performed validation to ensure accuracy.
• Build Global Data Assets (GDAs) Aligned to ESG themes with validation to ensure accuracy.
• Authored Data Asset Design document, ensuring clear documentation of data flows and transformation.
• Led end to end validation of business final use cases to ensure accuracy, compliance with business requirements.
• Acted as bridge between business stakeholders and external vendors gathering requirements, understanding business data and translating them into technical solution

Project 1 : Shell

Role : Data Engineer and Data Analyst

• Migrated data from SAP HANA to Azure cloud using ADF pipelines, ensuring seamless data transfer and automation.
• Conducted data analysis using SQL, validating migrated datasets and optimizing queries for optimal performance.

Project 2 : Thomson Reuters

Role : Data Analyst

• Conducted extensive analysis on their internal tool using SQL and pandas python library.
• Responsible to executing detailed analysis validation of on their tool

Project 3 : Anheuser-Bush

Role : Data Analyst

• Migrated financial reports from QlikView to PowerBI by developing data transformation logic using Spark SQL, ensuring accuracy and performance of migrated reports.
• Experience in working with spark eco system using Spark sql queries on different formats like Text, csv , avro and parquet.
• Experience in developing ERD diagrams and data lineage.
• Experience in making detailed functional required documents and business required documents for clients.

Project : Philips

Role : Data Analyst

• Developed ETL process from Data sources using different anlytical methods like descriptive, diagnostics and predictive analysis.
• Hands on experience in delivering custom data bases using my sql and postgre SQL to clients.