Hi, I’m
Megha Parmar
Summary
9+ years of experience in Data Engineering and Analytics using Azure Data Factory, Databricks, SQL, pySpark & Python. I have worked across Banking, Finance, Property Management & Supply Chain Domains, with expertise in designing, implementing, and optimizing critical business solutions.
Overview
10
years of professional experience
1
Certification
Work History
Shell India Private Limited
Data Engineer
09.2020 - Current
Job overview
- Involved in implementing Contract and Procurement Data Hub on Azure from scratch
- Played a key role in migrating eOSCAR reports from SAP HANA to the Azure platform, transitioning 40+ reports and delivering an estimated business value of approximately $10 Million, also improving performance by 60% and report generation time by 35%
- Designed data pipeline using ADF, transformed data using various pySpark functions in Databricks and store the data as Delta Table in ADLS
- Integrated ADC S4 HANA for the Canada Shales asset with CP Datahub, generating $2 million USD in business value
- Lead a team to deliver an end-to-end project Contingent Workforce Program, handling impact of IQN to SAP FieldGlass transition on CPDH
- Built models in Analysis Services to consume in Power BI
- Solely orchestrated a comprehensive report development and utilized CI/CD for deployment to Production
- Mentored new team members, providing guidance and support to ensure their successful integration and development within the team
- Above pointers includes my experience in Lancesoft as well, where I worked as contractor in Shell
Larsen & Toubro Infotech Limited
Senior Software Engineer
12.2018 - 09.2020
Job overview
- Developed an Agile data processing system for a global elevator company using Azure services, and optimized data loads with ADF, Databricks, ASQL and ADLS Gen2 for parquet storage
- Involved in implementing automated unit testing with PySpark, decreasing manual effort by 40% and boosting testing efficiency by 60%
Yardi Software Private Limited
Software Analyst
02.2017 - 12.2018
Job overview
- Worked in property management software, with expertise in custom SQL scripting(complex procedures and functions) for enhancements and client-specific reporting using SSRS, Crystal, and Yardi tools
HCL Technologies
Software Engineer
09.2014 - 09.2016
Job overview
- Provided L3 support by diagnosing and resolving critical database issues, modifying SQL procedures to ensure accuracy and reliability, and optimizing queries and indexing, achieving a 30% improvement in performance and minimizing downtime
Education
Bhilai Institute of TechnologyDurg, Chattisgarh
B.E. from Computer Science
05.2014
University Overview
GPA: 8.33
Skills
- Azure Databricks
- Azure Data Factory
- Azure SQL Database
- Azure Data Lake Storage
- Azure Analysis Services
- Delta Lake
- SQL
- Python
- PySpark
- Power BI
- Azure DevOps
- Visual Studio
- Data Modelling
- ETL
Accomplishments
- Special Recognition Award for ADC S4 HANA project at Shell
- Employee of the Month at Yardi Software Private Limited
Certification
Pursuing DP203 - Microsoft Azure Data Engineer Associate & Databricks Associate Certification.
Timeline
Data Engineer
Shell India Private Limited
09.2020 - Current
Senior Software Engineer
Larsen & Toubro Infotech Limited
12.2018 - 09.2020
Software Analyst
Yardi Software Private Limited
02.2017 - 12.2018
Software Engineer
HCL Technologies
09.2014 - 09.2016
Bhilai Institute of Technology
B.E. from Computer Science
Similar Profiles
Sivakumar JayaveluSivakumar Jayavelu
IT Project Manager at Shell India Private LimitedIT Project Manager at Shell India Private Limited
Dheerendra SinghDheerendra Singh
Researcher at Shell India Private LimitedResearcher at Shell India Private Limited
Subhashree SSubhashree S
BUSINESS ANALYST at Shell India Private LimitedBUSINESS ANALYST at Shell India Private Limited