Akshay Badgujar

AI-driven Data Engineer with 4+ years of experience across Data Engineering and Data Analysis, specializing in Python, MySQL/SQL, ETL/ELT, and Data Pipeline development for reporting and analytics. Skilled in extracting data from databases, APIs, and multiple file sources, transforming and validating it, and delivering it in optimized, structured formats for Power BI Reports, Dashboards, and Data Models. Proven track record building automated ETL/ELT pipelines with data validation, incremental loads, and scheduled processes — including 500K+ records processed at 99%+ accuracy, 25%+ faster query performance, and up to 40% reduction in reporting turnaround time.

Actively leverages AI coding assistants and GenAI tools (LLM APIs, RAG) to accelerate pipeline development, SQL generation/optimization, automation, troubleshooting, and documentation, while reviewing and validating AI-generated code for production use. Strong communicator experienced in cross-functional coordination with Business, Product, and Analytics teams to align data engineering work with organizational goals.

Data Analyst - Brain Vision Technology Pvt. Ltd. - Pune, India

(2026-01)

Rejoined Brain Vision Technology Pvt. Ltd. in a combined Data Analyst / Data Engineer capacity following a deputation assignment at Aligned Automation Services Pvt. Ltd.

• Design and maintain Python- and MySQL/SQL-based ETL/ELT data pipelines to extract, transform, and load data across business systems and APIs, building optimized datasets for Power BI Reports and Dashboards.
• Write complex, optimized SQL queries against MySQL, improving average query execution performance by 25%+.
• Implement data validation, quality checks, incremental loads, and scheduled processes to ensure pipeline reliability and data integrity.
• Automate recurring data-processing and reporting workflows using Python and Power Automate, saving 10+ hours of manual effort per week.
• Build interactive Power BI dashboards, Data Models, and DAX-based KPI reports with reliable data refresh, cutting manual reporting turnaround time by up to 30%+.
• Perform data reconciliation and root cause analysis, and troubleshoot pipeline and data quality issues to maintain accuracy across systems.
• Leverage AI coding assistants and GenAI tools to accelerate SQL generation/optimization, automation, debugging, and documentation, reviewing and validating AI-generated code before deployment.
• Built a Retrieval-Augmented Generation (RAG) solution using LLM APIs and vector embeddings, applying data engineering techniques to enable natural-language querying over internal datasets.
• Coordinate cross-functionally with Business, Product, and Analytics stakeholders to align data engineering objectives with organizational goals.

Associate Solution Engineer - Aligned Automation Services Pvt. Ltd. - Pune, India

(2024-10 - 2025-12)

Deputed by Brain Vision Technology Pvt. Ltd.; payroll and day-to-day engagement managed by Aligned Automation Services Pvt. Ltd. during this assignment.

• Performed data analysis and business reporting using Python, MySQL/SQL, Power BI, and Excel to support operational decision-making.
• Built Python- and SQL-based ETL/ELT workflows, integrating data from databases, APIs, and multiple file sources to extract, transform, and load data across business systems.
• Designed and maintained Power BI dashboards, reports, and data models for tracking KPIs and operational metrics.
• Automated data-processing and reporting workflows using Python and Excel, improving pipeline efficiency and reducing manual effort.
• Performed data validation, cleaning, and reconciliation to ensure data quality and integrity across systems.
• Collaborated cross-functionally with business stakeholders to gather requirements and deliver MIS and ad-hoc reports.

Trainee Analyst - Brain Vision Technology Pvt. Ltd. - Pune, India

(2022-11 - 2024-09)

• Developed SQL-based ETL workflows to extract, clean, validate, and transform data from multiple source systems.
• Built Power BI dashboards and KPI reports consolidating multi-source data for business stakeholders.
• Performed exploratory data analysis, data cleaning, validation, and trend analysis to generate actionable business insights.

Bachelor of Technology (B.Tech) - Information Technology - SVKM's Institute of Technology, Dhule, Maharashtra (2020 - 2023)