Hi, I’m
Mayur Pawar
Sr. Azure Data Engineer
Mumbai
Summary
Self-motivated, peak-performing, with 7+ years of relevant experience in the Data engineering field, skilled in designing efficient data pipelines and optimizing database performance. Proven expertise in data migration and validation. Successfully automated reporting processes, enhancing data analysis. Proficient in Azure SQL and performance tuning techniques.
Overview
7
years of professional experience
2019
years of post-secondary education
2
Languages
Work History
LtiMindtree
Sr. Azure Data Enginner
11.2024 - Current
Job overview
- Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
IKS HealthCare
Sr. MS SQL Developer
08.2022 - 11.2024
Job overview
- Developed stored procedures, T-SQL scripts, functions, and triggers to support application requirements.
- Performed backup and recovery of databases on a regular basis.
- Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
- Optimized existing queries for better performance using SQL query tuning techniques.
- Implemented data migration from legacy systems to new databases.
- Worked on Dedlock issues in databases/server in real-time basis.
Nelito Software Solutions
SQL Developer
07.2021 - 08.2022
Job overview
- Configuring and using SQL Agent and other tools for constant, latest data updating and data processing, for giving accurate, live market data output on the front end.
- Developing and maintaining reports and menus on the front end.
- Creating DML and DDL queries for importing bulk data with high time efficiency.
- Performance tuning and error solving.
TechExcel Software Solution
SQL Developer
11.2020 - 07.2021
Job overview
- Database migration.
- Developing stored procedures for performing huge bulk data conversion from Fincraft CBS to Pinnacle CBS.
- Performance tuning and error solving.
- Catering and solving logic-based queries.
- Designed and developed complex SQL queries for data analysis and extraction to support business decisions.
Ugam Solutions
Data Analyst
01.2019 - 11.2020
Job overview
- Participated in software evaluation and selection, business requirements analysis, and application integration. Functional and technical document preparation.
- Database migration.
- Creating API based on client requirement.
Education
B.N. Bandodker College of ScienceMumbai
Bachelor of Science from Computer Science
Janana Sarita School And Jr ClgMumbai
HSC from Science Education
Raja Shivaji VidyaMandirThane
SSC
Skills
Relational databases
Data pipeline design
AzureSQL, Synapse, ADF
Data modeling
Data warehousing
Data migration
SQL expertise
Performance tuning
Data quality assurance
Real-time analytics
SQL and databases
SSIS,SSMS,SSRS
Database design
Accomplishments
- In IKS healthcare I received employee of the year award.
- In Nelito I received Pinnacle performer Award.
Timeline
Sr. Azure Data Enginner
LtiMindtree
11.2024 - Current
Sr. MS SQL Developer
IKS HealthCare
08.2022 - 11.2024
SQL Developer
Nelito Software Solutions
07.2021 - 08.2022
SQL Developer
TechExcel Software Solution
11.2020 - 07.2021
Data Analyst
Ugam Solutions
01.2019 - 11.2020
Janana Sarita School And Jr Clg
HSC from Science Education
04.2015
Raja Shivaji VidyaMandir
SSC
03.2013
B.N. Bandodker College of Science
Bachelor of Science from Computer Science
07.2018
Education and Training
other,other,other
Languages
5,C1,5,C1