Deepa Bhat

Designed and implemented a multi-view Power BI dashboard for 5 key departments (sales, finance, supply chain), projected to scale business processes by 10%.

Transformed and wrangled over 1.8 million records from MySQL and Excel to build robust Power BI analytical models.

Optimized report efficiency by 30% and boosted performance by 10% through advanced DAX Studio techniques.

Managed stakeholder expectations and requirements, fostering collaborative decision-making and ensuring alignment across departments.

Developed a 4-year P&L Report for AtliQ Hardware, leveraging Excel Pivot Tables and DAX to reveal critical revenue insights.

Automated data cleaning processes using Power Query, saving approximately 4 hours of manual effort per report cycle.

Implemented advanced DAX measures, increasing calculation flexibility and user-friendliness by 25%.

Delivered executive-level reports highlighting dynamic trends in revenue, net profit percentage, and market share.

Spearheaded digital transformation during COVID-19, transitioning operations from manual to automated systems.

Designed and implemented an Excel-based inventory management system, improving stock accuracy and reducing shortages by 30%.

Developed a P&L reporting dashboard for real-time decision support, tracking revenue, margins, and category performance.

Analyzed sales trends and recommended product assortment changes, contributing to a 25% annual revenue growth.

Automated sales and inventory reporting, reducing manual work by 4 hours/week and significantly improving data reliability using SQL.

Designed and executed data-driven experiments, analyzing large experimental datasets with Python and statistical methods.

Authored and published 3 peer-reviewed scientific papers (PRE, ChemPhysChem), demonstrating strong analytical rigor and clear communication.

Automated data pipelines for experimental records, utilizing LaTeX for technical reporting and reproducible documentation.

Collaborated cross-functionally to interpret research findings, develop models, and propose process optimizations.

Performed advanced statistical analysis, including regression, ANOVA, and time series analysis, to derive meaningful insights.

Developed and delivered comprehensive Physics curriculum to college students, fostering foundational understanding of scientific principles.

Mentored and guided students in problem-solving and critical thinking, enhancing their academic performance and readiness for higher education.

Achieved positive student feedback for clear explanations and engaging teaching methods, contributing to an effective learning environment.