Mahesh Gupta

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.

• 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.

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.

• 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.

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.

• 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.

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.

• 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.

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.

• 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.

Served as a DBA at C-Net InfoTech India Pvt, developing and maintaining 20 online applications for various departments of Jabalpur Municipal Corporation.

• 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.

Recognized for leading the 'Swacch Bharat Mission 2017' project to achieve the 2nd rank across Jabalpur, demonstrating significant impact in civic initiatives.

Awarded for outstanding technical leadership in the 'Smart City Mission 2016' project, securing 7th rank nationally and 1st rank in Madhya Pradesh.