Mahesh Gupta
Senior ETL Developer | Database Administrator | Data Engineer
Flat 303A tirumala Town, chota bangarda, 452005, Indore, IN.About
Highly accomplished Senior ETL Developer and Database Administrator with over 5.5 years of experience in data cleansing, loading, and performance tuning across Power Distribution & Energy, BFSI, and Health sectors. Proven ability to lead technical initiatives, optimize database operations, and deliver complex data warehousing and ETL solutions using PySpark, SQL Server, Power BI, AWS, and GCP. Recognized for driving significant project outcomes, including achieving top rankings in national missions, and excelling in client communication and team leadership.
Work
→
Summary
Currently serving as an Assistant Consultant at TCS, spearheading ETL and Python development for a Canadian bank within the BFSI domain, focusing on data integration and quality assurance.
Highlights
Led end-to-end client communication, translating complex functional requirements into precise technical specifications for development teams.
Developed and optimized SQL code and ETL processes for importing data from diverse file sources, significantly enhancing data integrity and loading efficiency.
Utilized Python and PySpark for advanced data processing and worked with AWS Redshift clusters, monitoring ETL jobs to ensure seamless data flow and system performance.
Managed Jira tasks and actively participated in scrum calls, contributing to agile project delivery and improving team coordination and responsiveness.
→
Summary
Served as a Sr. Associate Level 2 Database professional at SmartData Enterprises, focusing on health insurance domain projects for HealthWare Systems, ensuring robust database operations and development.
Highlights
Ensured 24/7 database activity and health for MS SQL systems, proactively identifying and resolving issues to maintain critical application uptime.
Designed and optimized database architecture tables using normalization principles, enhancing data integrity and query efficiency for complex health insurance applications.
Gathered and translated business requirements into technical specifications for the development team, facilitating the creation of efficient ETL processes.
Developed and optimized stored procedures and ETL processes to streamline data ingestion from various file sources, improving data loading efficiency.
→
Summary
Functioned as a DBA, SSIS, and SSAS Developer at Tarsha Systems, managing a large-scale data warehouse project for MPPKVVCL state government, integrating data from diverse applications.
Highlights
Configured and monitored Disaster Recovery replication, failover clusters, and high availability for MSSQL Server and MySQL, ensuring continuous data accessibility.
Designed robust database architecture, including dimensions and fact tables with normalization, to support comprehensive data warehousing for CRM, ERP, and CCB applications.
Created SSAS Tabular models and cubes using star schema, deploying them on SSAS instances to enable advanced analytics and reporting capabilities.
Developed and published Power BI reports on Power BI cloud, providing critical insights for state government operations and decision-making.
→
Summary
Operated as a DBA at The Magnum Group, supporting a CRM project for MPPKVVCL that managed consumer complaints related to power supply and billing for the state government.
Highlights
Configured and monitored databases, including Disaster Recovery replication and high availability for MSSQL Server and MySQL, ensuring system reliability.
Implemented scheduled backups and verified data integrity, developing comprehensive maintenance plans to secure critical consumer complaint data.
→
Summary
Worked as a DBA with TCS at VSN INTERNATIONAL, supporting an ERP project for MPPKVVCL that involved migrating on-premises departmental application data to AWS cloud.
Highlights
Configured and monitored databases, including MSSQL, MySQL, and Oracle 12c, ensuring high availability and robust performance during cloud migration.
Managed data backups and verification processes, implementing maintenance plans to secure critical ERP data during transition to the cloud.
Created and published Power BI reports on Power BI cloud, providing actionable insights for departmental applications and migration progress.
→
Summary
Served as a DBA at C-Net InfoTech India Pvt, developing and maintaining 20 online applications for various departments of Jabalpur Municipal Corporation.
Highlights
Designed and optimized database architecture tables using normalization, supporting 20 online applications for diverse municipal departments (e.g., Lease, Law, Water).
Created SQL Server Agent jobs and cron jobs, scheduling critical database tasks for automated execution, improving operational efficiency.
Performed comprehensive database performance tuning and optimization, and developed query execution plans to enhance application responsiveness and efficiency.
Skills
Python /pyspark
ETL & Data Warehousing
ETL Development, Data Cleansing, Data Loading, Data Warehousing Concepts, Slowly Changing Dimensions, Dimensions and Fact Tables, Surrogate Key, SSIS Packages (SQL Versions 2017), Data Pipelines.
Database Administration & Development
MS SQL (2012, 2016), MySQL (5.5, 8), Oracle 12c, Database Administration, Disaster Recovery, Replication, Backup Recovery, Execution Plan, Maintenance Plan, Performance Tuning, Production Support, OLTP, SQL Server Integration Services (SSIS), MySQL Workbench, Microsoft SQL Server Data Tool, Microsoft SQL Server Management Studio, Sub-Queries, Complex Joins, Stored Procedures, Triggers, Functions, Normalization, SQL Server Agent Job, Cron Job.
Business Intelligence & Reporting
Power BI, Data Gateway, Scheduling Refresh Data, Publishing Reports, SSAS Concepts, SSAS Tabular Models, SSAS Cubes.
Cloud Platforms & Big Data
PySpark (2,3), HDFS, AWS (Glue, S3, Crawler, Redshift, IAM), GCP (BigQuery), AWS Redshift Cluster.
Programming & Scripting
Python, Spark.
Operating Systems & Tools
Windows Server 2012, CentOS, Putty, WinSCP, Jira, Microsoft SSDT.
Project Management & Soft Skills
Client Communication, Functional Requirements Gathering, Technical Specifications, Multi-tasking, Team Leadership, Team Player, Analytical Thinking, Detail-Oriented, Problem-Solving, Scrum Calls, Agile Methodologies.
Awards
2nd Rank in 'Swacch Bharat Mission 2017' Project (Jabalpur)
Awarded By
Government of India
Recognized for leading the 'Swacch Bharat Mission 2017' project to achieve the 2nd rank across Jabalpur, demonstrating significant impact in civic initiatives.
7th Rank in 'Smart City Mission 2016' Project (India) & 1st Rank (Madhya Pradesh)
Awarded By
Government of India / Madhya Pradesh
Awarded for outstanding technical leadership in the 'Smart City Mission 2016' project, securing 7th rank nationally and 1st rank in Madhya Pradesh.