Madhu Sudhan Rao Dommati P V
Hyderabad
Summary
- Data Architect/Data Engineer with 15 years of experience in designing, developing, and optimizing enterprise database applications, and large-scale data processing solutions. Around 7 years of experience in dimensional data modelling and building scalable BI and analytical reporting solutions using Power BI and other reporting platforms.
- Hands-on expertise in Microsoft Fabric including Lakehouse, Data Warehouse, Data Pipelines, Notebooks, and PySpark-based ETL/ELT processing. Strong experience in data ingestion, transformation, dimensional modelling, query optimization, performance tuning, and delivering scalable data solutions for analytics and reporting workloads.
- Proficient in SQL, T-SQL, PL/SQL, Python, and PySpark with strong analytical and problem-solving skills in building high-performance and business-driven data engineering solutions.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Data Architect
Evoke Technologies
Hyderabad
05.2025 - 12.2025
- Executed enterprise database migration from Microsoft SQL Server 2008 to SQL Server 2022, validating compatibility and optimising queries to enhance system performance.
- Designed and developed Dimensional Data Models using Star Schema and Fact/Dimension modeling for BI and analytical reporting.
- Built and optimised analytical data solutions for Power BI dashboards and KPI reporting, enabling informed business decision-making.
- Developed ETL/ELT pipelines with Microsoft Fabric Data Pipelines, Notebooks, and PySpark for efficient data ingestion and transformation.
- Performed SQL query optimization, indexing, and performance tuning for scalable reporting and analytics workloads.
Module Lead
Tech Mahindra
Hyderabad
12.2015 - 11.2024
- Executed comprehensive database development, including schema design, tables, views, stored procedures, triggers, indexing, and performance optimisation, to create robust data solutions.
- Designed and developed Dimensional Data Models including Fact and Dimension tables to support BI reporting and analytical solutions.
- Built and optimized complex SQL queries, data transformations, and analytical datasets for reporting and business analysis.
- Developed and supported ETL/ELT solutions using SSIS, Azure Data Factory, Microsoft Fabric Pipelines, Notebooks, and PySpark transformations, ensuring data was accurately processed for reporting.
- Worked closely with business and application teams to analyze requirements, validate data, and deliver scalable reporting solutions using Power BI.
- Performed production support and root cause analysis, conducted unit testing, and tuned performance for database and ETL applications, enhancing stability and reliability.
Assistant Manager
Karvy Computershare
Hyderabad
07.2014 - 12.2015
- Designed and developed database solutions and SQL scripts with focus on query optimization and performance tuning in Microsoft SQL Server.
- Created and maintained database objects including tables, views, stored procedures, functions, and triggers to ensure data integrity and efficient data access.
- Developed complex SQL queries, data transformations, and analytical datasets supporting reporting and business requirements.
- Managed SQL Server Agent jobs and ETL processes, ensuring timely execution and reliability of database applications.
- Resolved production issues and performed enhancements, enabling seamless end-user reporting and meeting data requirements.
Senior Software Engineer
Greater Hyderabad Municipal Corporation
Hyderabad
08.2011 - 07.2014
- Designed, developed, and maintained web applications using Classic ASP, ASP.Net, and Oracle Database.
- Developed and optimized database queries, stored procedures, and backend processes to improve application performance and efficiency.
- Performed query optimization and performance tuning for existing database applications and reporting processes.
- Collaborated with business and cross-functional teams to gather requirements, delivering tailored application solutions that meet user needs.
- Provided maintenance and production support for in-house applications, enhancing system stability and performance through proactive improvements.
- Resolved end-user issues while implementing application and database enhancements to align with business requirements.
Education
MCA -
Osmania University
Hyderabad, TG01-2000
BSc (computers) -
Osmania University
Hyderabad, TG01-1997
Skills
- Database languages
- Data engineering
- Dimensional modelling
- Python programming NumPy Pandas PySpark
- Power BI Azure Data Factory (ADF) SSIS SSRS
- C C Classic ASP 30 C#Net JavaScript VBScript
- Microsoft Excel PowerPoint
Certification
- PL-300 Microsoft Power BI Data Analyst - 2024
Accomplishments
POB Award for Training and Knowledge Sharing - Tech Mahindra
Acknowledged for exceptional training and development programs that enhanced colleague skills and knowledge
Cross Team Collaboration - Tech Mahindra
Certificate of Appreciation in recognition of Cross Team Collaboration
Initiatives - Tech Mahindra
Certificate of Appreciation in recognition of Technical Training Initiatives to the colleagues
Timeline
Data Architect
Evoke Technologies
05.2025 - 12.2025
Module Lead
Tech Mahindra
12.2015 - 11.2024
Assistant Manager
Karvy Computershare
07.2014 - 12.2015
Senior Software Engineer
Greater Hyderabad Municipal Corporation
08.2011 - 07.2014
MCA -
Osmania University
BSc (computers) -
Osmania University