Mahendra Kolhe

Data Engineer

Xcaliber Infotech•  May 2023 - Present•  Pune, India

Built real-time KPI dashboards using SQL SP and Tableau, improving decision-making efficiency. Developed a Python-based polling service to monitor and trigger ETL tools (SQL Jobs, Python ETL, ADLS Jobs), automating file processing and reducing latency by 50%. Automated missing file alerts and reconciliation, achieving 99.9% accuracy for 400,000+ daily transactions from the AS2 file server. Designed and implemented advanced data transformation pipelines using Azure Databricks and ADF, applying business rules and publishing outputs to Azure SQL DB, reducing processing time by 40%. Created a data lineage dashboard to visualize data flow from file to dashboard and vice versa, reducing file search time by 60%. Implemented SSIS transformations to enhance ETL efficiency.

Associate – Data Engineering

TeamLease Services Ltd•  January 2021 - February 2022•  Pune, India

Built data ingestion pipelines using SSIS to move flat files from email sources into SQL Server. Managed SQL Server database for employee records used by HR, ensuring availability and data integrity. Created stored procedures and triggers for automated birthday and anniversary notifications, reducing manual tracking by 50% using centralized config tables.

Freelance Data Engineer

Self-Employed•  July 2018 - December 2020•  Pune, India

Delivered custom ETL solutions and dashboards for small businesses using SQL and Python. Developed a finance tracker tool that extracted billing data from email files, performed ETL, and sent summary alerts via email, eliminating manual billing checks.