Summary

Overview

Work History

Education

Skills

Timeline

KOMAL SINGH MAHESH

Chester Springs,PA

Summary

Senior Data Engineer with 15+ years of experience designing scalable enterprise data platforms and architecting cloud-based solutions across Azure. Proven track record in building robust, end-to-end data pipelines using Azure Data Factory, Synapse Analytics, Fabric, Data Lake, and Power BI. Adept at implementing data governance frameworks, leading cross-functional teams, and aligning technical solutions with business objectives. Skilled in developing model-ready datasets and supporting AI/ML initiatives with strong expertise in Python, SQL, and enterprise data warehousing.

Overview

years of professional experience

Work History

Senior BI Architect

JG Wentworth - Contract

Chesterbrook, PA

12.2025 - 03.2026

Designed and implemented a Microsoft Fabric-based lakehouse architecture for enterprise analytics; integrated Data Factory pipelines and real-time Power BI dashboards.
Developed scalable data ingestion framework in Azure Synapse, enabling automated ingestion of 100+ TB of data per month and improving SLA compliance to 99.8%.

Sr. Programmer Analyst, Business Intelligence

Automated Financial Systems Inc.

Exton, PA

06.2016 - 12.2025

Spearheaded the development and successful launch of our Data Analytics product – IRIS, by architecting scalable, enterprise-grade data solutions using Microsoft Azure services such as Azure Data Factory, Azure Databricks, Azure SQL Database, Synapse Analytics, and Data Lake Storage.
Designed and implemented dbt-based ETL pipelines to process over 10M+ rows, enhancing data reliability and operational efficiency through robust orchestration and automation.
Modeled multi-dimensional schemas (star/snowflake) for OLAP cubes to enable efficient querying and aggregation.
Worked as OLAP Data Architect and Data Modeler to design and optimize multidimensional data models for a cloud-based analytics platform for Portfolio Analysis.
Established data governance and security protocols in alignment with enterprise compliance needs, incorporating standards via Azure Purview and metadata management practices.
Led the design and development of centralized Data Warehousing solutions supporting scalable analytics and self-service BI using Power BI and SSAS.
Partnered with product managers and data scientists to ensure platform support for machine learning pipelines and advanced analytics use cases.
Monitored industry trends in cloud data engineering, prepared strategic evaluations of emerging Azure features (e.g., MS Fabric), and presented recommendations to executive leadership.
Designed and maintained data ingestion pipelines using Azure Data Factory, SSIS, and Python, enabling automated and secure data movement across cloud and on-premises systems.
Developed Python scripts using Pandas and NumPy for data transformation, cleansing, and preparation of model-ready datasets.
Designed and maintained data warehouses and OLAP cubes to support enterprise business intelligence and reporting needs.
Optimized complex SQL queries, improving performance by 80% using tools like SQL Profiler and Database Tuning Advisor.
Collaborated with analysts to develop SQL-based datasets and model-ready pipelines, supporting reporting, dashboards, and exploratory analysis.
Mentored a team of associate developers, providing technical guidance on data pipeline design, performance tuning, and quality assurance.

Sr. Data Engineer

Coldlight, a PTC Business

Wayne, PA

12.2013 - 06.2016

Managed large-scale data ingestion pipelines for marketing analytics, optimizing workflows and ensuring seamless data flow.
Developed model-ready datasets for machine learning, focusing on preprocessing, data cleaning, and feature engineering to support advanced analytics.
Conducted comprehensive data profiling and integrity checks, identifying data issues and ensuring high-quality, accurate data for analysis.
Created ad-hoc reports based on client requirements, using SQL and data visualization tools to deliver insights and business intelligence.
Worked closely with Data Scientists to support the development and fine-tuning of analytical models, ensuring alignment between technical and business objectives.
Leveraged advanced SQL to extract, aggregate, and transform large datasets, enhancing decision making and reporting processes.

SQL Developer

ConceptOne, LLC

New York

12.2009 - 12.2013

Involved in Risk Management processes i.e. processing client's portfolio and developing logic behind.
Developed ETL Process i.e. Extracting the client's position/Transactions files, Transforming/Cleansing the data, combining client's position data with market data and loading it in the centralized database.
Developed complex queries and stored procedures to process data, which includes pivoting, and un.
Involved in ETL process migration from SAS to SSIS Packages. Involved in troubleshooting bottlenecks, which comprise of data related issues from the client's file, risk.
Setting up new clients by understanding Analyst's
Business/Technical documents, which included Risk.
Involved in Architecting database layouts, which includes creation of Database objects, Normalizing.
Created Data Validation stored procedures for the Form PF module, which validates data on specific.

Graduate Assistant

West Chester University

01.2008 - 06.2008

Assisted faculty and students with IT issues and software installation.