Abhishek Shelar
Navi Mumbai
Summary
Highly skilled and experienced data professional specializing in ETL development, SQL development, Power BI development, and data analysis. With over 3 years of experience, I have a proven track record of designing and optimizing ETL pipelines, SQL queries, data models, and BI reports. Proficient in PL/SQL, Power BI, Azure Data Factory, Informatica, and Data Warehousing. I have a strong foundation in automation, root cause analysis (RCA), and performance tuning. My expertise lies in transforming complex datasets into actionable insights that drive informed business decisions.
Overview
6
6
years of professional experience
1
1
Certification
Work History
ETL/PLSQL & Power BI Developer
Capgemini Engineering
01.2022 - Current
- Developed PL/SQL-based ETL pipelines for automating 80% of data workflows, reducing manual efforts
- Optimized SQL queries and stored procedures, improving database performance by 40%
- Integrated Azure Data Factory, Informatica, and AutoSys for seamless data transformation and scheduling
- Automated Root Cause Analysis (RCA) processes, reducing issue resolution time by 35%
- Designed ETL processes to transform and analyze carbon emissions data from transport and manufacturing
- Leveraged Power BI & SQL to create interactive dashboards, improving reporting efficiency by 50%
- Enhanced data integrity and consistency by implementing Data Integration (CDI) best practices
- Developed Power Apps & Power BI dashboards to track emissions and suggest sustainable strategies
- Transformed unstructured sustainability data into structured insights, leading to a 30% improvement in industry compliance tracking
- Collaborated with stakeholders to implement Data Warehousing (DWH) solutions, ensuring real-time data accuracy
C&I Engineer
IB Automation Pvt Ltd
12.2020 - 02.2022
- Company Overview: Worked at IB Automation Pvt Ltd, gaining expertise in Industrial & Building Automation, PLC, SCADA, and Instrumentation Systems
- Outsourced to Emerson as an Instrumentation Engineer, handling DCS, PLC programming, and control system integration
- Designed, programmed, and commissioned automation solutions, optimizing process control and electrical system efficiency
- Worked at IB Automation Pvt Ltd, gaining expertise in Industrial & Building Automation, PLC, SCADA, and Instrumentation Systems
GET
Afility Engineering Pvt Ltd
06.2019 - 05.2020
- Started as a GET at Afility Engineering Pvt Ltd, gaining expertise in EPC projects across engineering disciplines
- Outsourced to SNC-Lavalin as a C&I Engineer for Design & Detail Engineering
- Worked on automation, instrumentation design, and real-time data acquisition for system optimization
Education
Instrumentation Engineering - Engineering
SIGCE
05.2019
Science - Junior High Education
Swami Vivekananda Junior College of Science & Arts
06.2015
General Education -
Smt. Radhikabai Meghe Vidyala School
06.2013
Skills
- Big data technologies
- Dashboard creation
- Excellent communication
- Database management
- SQL development
- Business intelligence
- Data validation
- ETL processes
- Microsoft Excel
- Tableau
- SCADA systems
- Conservation and sustainability
Certification
- AWS CCP
- Power BI Developer
- Agile Software Development Methodology
- Modern Data Warehousing Analysis
Languages
English
Marathi (Marāṭhī)
Hindi
Football
Represented my college at Mumbai University Football Tournament
High School Football team captain
Runner up at DSO Football tournament
Timeline
ETL/PLSQL & Power BI Developer
Capgemini Engineering
01.2022 - Current
C&I Engineer
IB Automation Pvt Ltd
12.2020 - 02.2022
GET
Afility Engineering Pvt Ltd
06.2019 - 05.2020
- AWS CCP
- Power BI Developer
- Agile Software Development Methodology
- Modern Data Warehousing Analysis
Instrumentation Engineering - Engineering
SIGCE
Science - Junior High Education
Swami Vivekananda Junior College of Science & Arts
General Education -
Smt. Radhikabai Meghe Vidyala School
Similar Profiles
Stuti SinhaStuti Sinha
Lead Recruiter | Consultant at Capgemini EngineeringLead Recruiter | Consultant at Capgemini Engineering
Supriya AvadhaniSupriya Avadhani
Senior Test Engineer at Capgemini EngineeringSenior Test Engineer at Capgemini Engineering
Nishant SharmaNishant Sharma
Operations Manager at Capgemini EngineeringOperations Manager at Capgemini Engineering