Madhav Khanzode
Boston,MA
Summary
Dynamic and results-driven database professional with extensive experience in performance monitoring, troubleshooting issues, and optimizing database environments. Strong analytical skills and exceptional problem-solving abilities complement a deep understanding of diverse database technologies and systems. Adept at thriving in independent and collaborative settings, leveraging excellent communication skills to convey complex information effectively. Committed to delivering high-quality solutions that enhance operational efficiency and drive organizational success.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Data Engineer
Genpact LLC
Boston, USA
01.2022 - Current
- Led the design and execution of RPA (Robotic Process Automation) strategies to automate manual processes, driving $350,000 in annual cost savings and significantly improving process accuracy.
- Built a Python-based Selenium automation framework to eliminate manual effort for reports, optimizing web interactions, and data extraction, resulting in a 60% reduction in process time.
- Enhanced Python Selenium automation by debugging scripts, improving execution reliability by 40%, and configuring Selenium WebDriver with robust frameworks for seamless test execution.
- Conducted user acceptance and end-to-end integration testing to ensure automation met requirements, while developing VBA-enabled automation for customer email notifications, resulting in a 40% improvement in task completion communication and enhanced customer satisfaction.
- Modernized a centralized solution for efficient data analysis and reporting using Power Automate and Power Apps to manage supply chain materials procurement logs. This automation resulted in a significant reduction, saving 1.5 Full-Time Equivalent (FTE) positions.
- Optimized reporting solutions by leveraging analytics and automation tools, boosting productivity by 45% and cutting annual costs by $100,000.
- Collaborated with automation analysts and stakeholders to translate raw data into actionable business insights and recommend tailored solutions, enhancing operational efficiency and addressing business challenges.
- Designed and productionized bronze/silver/gold ELT on Snowflake + Databricks to curate raw data into governed layers for BI and Advanced Analytics consumption.
- Built conformed data marts (star, SCD2 via Streams/Tasks + MERGE) that reduced ad-hoc SQL by >30% and improved dashboard refresh reliability.
- Migrated legacy reports and flat-file jobs to Snowflake/Databricks; executed parity validation (row-count, hash, domain constraints) with automated rollback and sign-off.
- Implemented data quality & observability (schema checks, drift alerts, lineage docs) and housekeeping/retention (pruning, clustering), reducing re-runs and storage/compute.
Business Intelligence Analyst
Robert Bosch LLC
Boston, USA
08.2020 - 04.2021
- Formed Power BI graphical and visualization solutions using business requirement documents to create interactive dashboards, leading to a 30% improvement in data accessibility and a 25% reduction in decision-making time.
- Fabricated over 100 SSRS reports and modified stored procedures, views, functions, and indexes to ensure accuracy, while delivering a Power BI solution for ETL, analytics, and reporting on SQL Server 2008, improving efficiency across 15 departments.
- Ensured accuracy of reports by resolving data discrepancies using Python for assigned reports and writing Stored Procedures, Triggers, Functions, and SQL Queries to capture updated and deleted data, streamlining the development of data pipelines and improving data integrity for over 50 reports.
- Built an ETL framework for daily reports using Alteryx, reducing processing time by 80% and enhancing workflow productivity.
- Created DAX functions for diverse fact calculations and developed computed columns to enhance data visualization in Power BI, leading to improved decision-making and a 30% increase in reporting efficiency.
- Implemented and delivered Power BI platform solution to develop and deploy ETL, analytical, and reporting on SQL Server 2008 using SSRS, SSAS, and SSIS.
BI Data Analyst
Ample Softtech
Pune, India
06.2017 - 01.2019
- Leveraged and analyzed over 5 million data points using Explanatory Data Analysis to develop insights, metrics, and parameters for customer analysis, resulting in a 30% improvement in customer targeting using Google Analytics.
- Converted over 2 million data records into actionable insights by predicting and modeling future outcomes in Python, driving a 25% increase in forecast accuracy.
Education
Master’s - Data Analytics
Northeastern University
Boston, USA09.2021
Skills
- Programming Languages: Python, R, SQL, VBA, Selenium, Statistical modeling, Data Visualization, Data Warehousing
- Data Engineering: Databricks, Snowflake, SQL(Advanced), ETL/ELT Pipelines, PostgreSQL, AWS Glue, S3, ETL development, Data warehousing, Spark framework, API development
- Data Analysis Tools: Tableau, Power BI, Alteryx, Advanced Excel, Google Analytics, SRS
- Reporting Platforms: SSRS, SSIS, SSAS, MS Power BI, Power Apps, Power Automate
- Other Tools & Technologies: AWS, Machine learning Algorithms, SAP, MS Azure, Alteryx, Kinaxis, AWS RDS
- Certification: Microsoft Certified Data Analyst, Kinaxis Rapid response Author 1 &2, Kinaxis Rapid response Author 2
Certification
- Microsoft Certified Data Analyst
- Kinaxis Rapid response Author 1
- Kinaxis Rapid response Author 2
Languages
English
Full Professional
Hindi
Native or Bilingual
Timeline
Data Engineer
Genpact LLC
01.2022 - Current
Business Intelligence Analyst
Robert Bosch LLC
08.2020 - 04.2021
BI Data Analyst
Ample Softtech
06.2017 - 01.2019
Master’s - Data Analytics
Northeastern University