Data Engineer Business Intelligence

KOMAL SINGH MAHESH

484-***-**** ************@*****.*** Chester Springs, PA

P R O F E S S I O N A L S U M M A R Y

• Results-driven Data Engineer with over 15 years of experience designing and optimizing scalable data ingestion pipelines and ETL workflows across cloud platforms.

• Skilled in Azure Data Factory, SSIS, and Python, with hands-on experience using libraries such as Pandas and NumPy for data transformation and cleansing.

• Familiar with preparing and supporting model-ready datasets for analytics and machine learning use cases.

• Experienced in both Azure and AWS ecosystems, with a strong background in building real- time and batch data solutions for structured and semi-structured data.

• Adept at collaborating with cross-functional teams, mentoring junior developers, and aligning technical solutions with business goals.

• Holds a Master’s degree in Computer Science and a strong track record of delivering impactful, production-grade data systems.

E X P E R I E N C E

Sr. Programmer Analyst, Business Intelligence Jun 2016 – Present Automated Financial Systems Inc.

Exton, PA

• Designed and maintained data ingestion pipelines using Azure Data Factory, SSIS, and Python, enabling automated and secure data movement across cloud and on-premise systems.

• Developed Python scripts using Pandas and NumPy for data transformation, cleansing, and preparation of model-ready datasets.

• Engineered ETL processes for 10M+ rows using SSIS, automating workflows and reducing manual effort by 40% monthly.

• 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 Dec 2013 - June 2016

Automated Financial Systems Inc.

Exton, PA

• 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 Dec 2013 - June 2016

ConceptOne, LLC New York

• 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 Jan 2008 - June 2008

West Chester University

• Assisted faculty and students with IT issues and software installation. E D U C A T I O N & C E R T I F I C A T I O N S

Master’s in computer science Aug’2007 to May’2009

West Chester University of Pennsylvania

Bachelor's Computer Science

Aurora's Technological & Research Institute, India SKILLS

SQL Server Tools: SSMS, SSIS, SSAS, Query Analyzer, Profiler, Database Tuning Advisor Reporting tools: SSRS, Tableau,

PowerBI

Programming Languages: SQL, Java, Python

Cloud Services: AWS (S3, Athena, Glue, Redshift, Data Pipeline, Lambda, Step Functions), Azure (ADLS, Data Factory, Synapse)

Contact this candidate