Mahesh M.

About Mahesh M.

About MeResults-driven SQL Server Developer and Data Engineer with over 14 years of experience in database development, business intelligence (BI), and cloud-based data engineering. Adept at designing and implementing high-performance OLTP and OLAP solutions, ETL processes, data modeling, and performance tuning, with expertise in SQL Server (20••••22), SSIS, SSRS, SSAS, Azure Data Factory (ADF), Power BI, and Snowflake.I specialize in data pipeline optimization, real-time analytics, metadata management, data governance, and data quality assurance, ensuring accurate, reliable, and well-structured data solutions that empower business decision-making. My experience spans various industries, including financial services, manufacturing, and service-based businesses, where I have successfully led database development, data warehousing, and business intelligence initiatives.Technical ExpertiseI have a strong background in Microsoft SQL Server, with 9+ years of expertise in T-SQL programming, including stored procedures, views, triggers, user-defined functions, cursors, and complex queries. My ability to optimize SQL queries and tune performance ensures the efficiency of mission-critical applications.With 8+ years in ETL development, I design and implement robust SSIS packages to manage complex data transformations, migrations, and integrations. I also have 3+ years of experience in SSAS, designing and implementing MDX queries, OLAP architectures (MOLAP, ROLAP, HOLAP), and building performance-driven analytical models.In the cloud space, I leverage Azure technologies such as Azure Data Factory, Azure Data Lake, Azure Synapse, and Azure SQL DB to build scalable, cloud-native data pipelines and warehouse solutions. I am also proficient in Power BI, developing interactive dashboards, reports, and real-time analytics.Programming & AutomationBeyond SQL, I have experience in Python (Pandas, PySpark), PowerShell, C#, and VB.NET, allowing me to automate workflows, enhance performance, and integrate data solutions with various platforms. I utilize CI/CD pipelines, GitHub, TFS, and Azure DevOps to ensure efficient deployment and version control.Passion & ApproachI am passionate about data-driven decision-making and transforming raw data into meaningful insights. With strong problem-solving skills, an analytical mindset, and a deep understanding of Agile & Scrum methodologies, I collaborate effectively with cross-functional teams to deliver innovative data solutions.

Experience

1. Project Architect

   Persistent Systems

   Oct 2025 — Present · Pune, IN

   As a Project Architect, I am responsible for designing and delivering scalable, secure, and high-performing Azure cloud data architectures. My focus is on solution design, governance, and leadership across data engineering, integration, and DevOps streams, ensuring alignment with business objectives and technology roadmaps.Key Responsibilities • Architecture & Solution Design: • Defined end-to-end Azure Data Engineering & Integration architectures using ADF, Synapse, Databricks, Service Bus, and Logic Apps. • Designed hybrid and multi-cloud governance models across Azure & AWS, ensuring compliance, observability, and resilience. • Built secure pipeline orchestration frameworks leveraging ADF, Key Vault, and Terraform (IaC). • Project Execution & Delivery: • Led cloud migration initiatives from on-premises SQL Server to Azure SQL Database & Data Lake. • Established best practices for DevOps (CI/CD), using Azure DevOps pipelines for automated deployments. • Implemented observability strategies using Azure Monitor, Datadog, and Splunk for proactive issue management. • Leadership & Team Handling: • Mentored cross-functional teams (Data Engineers, DevOps, BI developers) to adopt Azure-native solutions. • Coordinated offshore–onsite team collaboration in Agile/Scrum delivery model. • Conducted architecture review sessions, technical training, and stakeholder communication. • Project Management: • Drove sprint planning, backlog prioritization, and risk management to ensure on-time and cost-effective delivery. • Partnered with business stakeholders and product owners to translate business needs into scalable technical solutions. • Managed project reporting, capacity planning, and resource allocation.Key Achievements • Promoted to Project Architect within Persistent for driving end-to-end Azure architecture solutions. • Successfully designed and delivered federated governance models across Azure.

Education

• Osmania University

  PGMIB, International Business

• Osmania University, Hyderabad

  Master of Business Administration - MBA, International Business

• CHANDIGARH UNIVERSITY

  Master of Computer Applications - MCA, Computer Software Engineering