RUPESH SHARMA
Lead Data Engineer
Pune
Summary
Accomplished Azure Data Architect having over 20 years experience with building scalable data infrastructures, ensuring seamless data flow and integration. Utilizes advanced data engineering techniques to support business intelligence and analytics. Track record of leveraging team collaboration and technical acumen to drive data-driven decision-making.
Overview
20
20
years of professional experience
Work History
Lead Data Engineer
NewVision Software
06.2025 - Current
- Engineered a new Power BI semantic model to minimize technical debt and redundancy, directly improving the scalability and intuitiveness of client-facing self-service dashboards.
- Mentored junior engineers on best practices in data engineering, fostering a culture of continuous learning and improvement within the team.
- Created Dashboard Audit and Management App to view, audit, and manage the usage of the dashboard, permission-related history, and other important details.
- Mitigated data exposure risks by designing and deploying complex Row-Level Security (RLS) roles and data masking strategies, restricting access to sensitive information to authorized personnel only.
Sr. Specialist - Data Engineering
LTIMindtree
02.2021 - 06.2025
- Since last 4 years in this organization I have added totally new set of skillsets in my job profile related to cloud and BigData. Having worked with 2 retail clients and one software product client I got an opportunity to load and transform bigdata from Azure Data Lake and other sources into Azure SQL using ADF, ADB and Synapse. For coding used PySpark and SQL, for version control used Git for deployments used CICD pipelines and for data governance used Microsoft Purview.
- I learnt Microsoft Fabric in a 15 days classroom training and completed the certification. I also attended 15 days classroom training and appeared for Databricks Engineering Associate exam.
- Created pipelines and data flows in Azure Data Factory to migrate the entities from multiple sources to Azure SQL using ADF.
- Created new and modify existing Databricks notebooks for loading and transformation activities using PySpark and SQL
Sr. Consultant
ATOS Syntel Inc.
07.2018 - 02.2021
- I worked in this organisation for around 3 years on the same project throughout the tenure. It was and ETL and reporting work for an asset management company. I was playing a lead developer role where my responsibilities were to develop and modify Stored Procedures in SQL Server, SSIS packages, SSRS reports and cubes in SSAS.
- Worked on new ETL and reporting tools like MEDM, Vermillion and Jasper
- Participated in technical pre-sales calls & demos.
Sr. Technical Specialist
Zensar Technologies Ltd.
04.2013 - 07.2018
- I worked in this organization for more than 5 years. For 2 projects I was at onsite. 3 years in Vienna (Austria) and 1 year in Scotland (UK). All the projects were related to ETL and Reporting. I played a role of lead developer so was responsible for individual contribution as well as helping and mentoring the team. Majorly I used SQL Server, SSRS, SSIS, SSAS and PowerBI tools to do the development activities.
- Development done using T-SQL, SSRS, SSIS, Microsoft Projects for various projects.
- Lead the implementation of Actuarial data load from source to data mart.
Associate
Cognizant Technology Solutions Ltd.
06.2010 - 04.2013
- I worked in this organization for around 3 years and completed 2 projects both for Investment Banking client. My responsibility was to do the development for ETL and Reporting. I used SQL Server for database management, SSRS for reporting, SSIS for ETL, SSAS for creating cubes and TFS for version control. Here I received superstar of the month award to automate a manual process of data cleanup and readiness activity using Excel Macro.
- Worked on T-SQL, SSRS, SSIS, SSAS, MDX, MSCRM.
- Achieved key deliverables during data migrations and report customizations.
Sr. Software Engineer
L&T Infotech Ltd.
01.2010 - 06.2010
- It was a very short period of 6 months work in this organisation and I got an opportunity to work on ETL and Reporting work but most of the work was done in database objects itself.
- I was responsible for below mentioned work:
- Writing Stored Procedures, Triggers, Statistics etc. in Database
- Creating indexes, views, synonyms and creating staged ready scripts.
- Optimization of queries and hierarchy mapping with given xml docs. Tool used XML-Lite.
- Creating SSIS packages for TDS-ODS-DM data load.
Software Engineer
Satyam Computer Services Ltd.
04.2007 - 01.2010
- I worked on two projects during 2.5 years tenure in this organisation for investment banking clients. I learnt new skill set SSRS during this period and had created very complex reports and dashboards using it.
- Engaged in .NET, C#, T-SQL, SSRS development.
- Contributed to report generation and software enhancements.
Software Developer
NIIT Ltd.
02.2006 - 03.2007
- I joined this organisation as an International Corporate Trainer and was selected to go to Jiangsu province in China to provide training on C#, VB.Net and Asp.Net in engineering college. Later I worked on their internal project to improve the performance of the database side of implementation by introducing proper indexes updating statistics.
- Developed solutions using .NET, C#, T-SQL, SSRS.
- Measure and ensure performance using SQL Server Profiler and Database Tuning Advisor.
Education
PGDBM - Finance
IndSearch
Pune 04.2001 -
Master of Computer Applications - Computer Applications Development
IGNOU
New Delhi 04.2001 -
Bachelor of Computer Application - Computer Applications Development
IGNOU
New Delhi12-2005
Skills
Azure SQL
Azure Data Factory
Azure Databricks
Azure Synapse
Microsoft Fabric tools
Py-Spark for Data Engineering notebook
Dashboard development using Power BI and Databricks
SSRS, SSIS and SSAS expertise
Data quality assurance
Performance tuning
Big data processing
ETL development
Timeline
Lead Data Engineer
NewVision Software
06.2025 - Current
Sr. Specialist - Data Engineering
LTIMindtree
02.2021 - 06.2025
Sr. Consultant
ATOS Syntel Inc.
07.2018 - 02.2021
Sr. Technical Specialist
Zensar Technologies Ltd.
04.2013 - 07.2018
Associate
Cognizant Technology Solutions Ltd.
06.2010 - 04.2013
Sr. Software Engineer
L&T Infotech Ltd.
01.2010 - 06.2010
Software Engineer
Satyam Computer Services Ltd.
04.2007 - 01.2010
Software Developer
NIIT Ltd.
02.2006 - 03.2007
PGDBM - Finance
IndSearch
04.2001 -
Master of Computer Applications - Computer Applications Development
IGNOU
04.2001 -
Bachelor of Computer Application - Computer Applications Development
IGNOU