About
Highly analytical and detail-oriented professional with 3+ years of research experience, complemented by hands-on expertise in retail analytics, data transformation, and business intelligence. Proficient in SQL, Excel, Python, and Power BI, Deepa excels at designing automated dashboards, validating data accuracy, and extracting actionable insights that drive business growth. Proven ability to manage high-impact projects, improve operational efficiency, and deliver strategic recommendations to stakeholders.
Work
Business Insight 360 – Brick Mortar and E-Commerce
|Business Intelligence Consultant
Bangalore, Karnataka, India
→
Summary
Led the design and implementation of a multi-view Power BI dashboard for 5 departments, scaling business processes by 10%.
Highlights
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.
AtliQ Hardware
|Data Analyst
Bangalore, Karnataka, India
→
Summary
Developed a comprehensive 4-year P&L Report for AtliQ Hardware, revealing key revenue and market share trends.
Highlights
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.
Family-Owned Grocery Store
|Operations & Data Analytics Lead
Bangalore, Karnataka, India
→
Summary
Led the digital transformation of a family-owned grocery store, automating operations and driving significant revenue growth.
Highlights
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.
Raman Research Institute
|Research Assistant
Bangalore, Karnataka, India
→
Summary
Conducted data-driven scientific experiments, analyzed large datasets, and published peer-reviewed papers at a leading research institute.
Highlights
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.
Sadvidya Composite Pre-University College
|Lecturer of Physics
Mysore, Karnataka, India
→
Summary
Taught Physics to college students, fostering a strong foundation in scientific principles and analytical thinking.
Highlights
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.
Education
University of Mysore
→
Master of Science
Physics
University of Mysore
→
Bachelor of Science
Physics, Mathematics, Chemistry
Languages
English
Native
Certificates
Excel: Mother of Business Intelligence
Issued By
Codebasics
Power BI Data Analytics for all levels 3.0
Issued By
Codebasics
Skills
Data Analysis & Business Intelligence Tools
Power BI, Microsoft Excel, DAX Studio, SQL, Power Query, Data Modelling, ETL (Extract, Transform & Load), Data Reporting, Automated Dashboards, Retail Analytics.
Programming & Data Science Libraries
Python, Pandas, NumPy, Scikit-Learn, Matplotlib.
Cloud & Methodologies
Azure, Power BI Embedded, Agile Methodologies.
Statistical Analysis
Statistics, Regression Analysis, Analysis of Variance (ANOVA), Time Series Analysis, Experimental Design.