About Me
Data/Business Analyst with ~3 years of experience in SQL, Power BI, Excel, KPI reporting, business analysis, forecasting support, and data-driven decision making. Experienced in building dashboards, performing trend and …
Data/Business Analyst with ~3 years of experience in SQL, Power BI, Excel, KPI reporting, business analysis, forecasting support, and data-driven decision making. Experienced in building dashboards, performing trend and root cause analysis, supporting business forecasting discussions, and translating analytical insights into actionable business recommendations.
Experience
Data Analyst
<p>Designed and maintained Power BI dashboards against an Azure SQL reporting layer, transforming operational data into business information across 10+ KPIs.</p><p> Made dashboards readily accessible to account-facing stakeholders through weekly business reviews.</p><p> Wrote SQL queries against the reporting layer to build data validation queries supporting operational reporting and ad-hoc analysis for client-facing teams.</p><p> Identified and resolved data quality issues, including duplicate customer records and missing repair-orders.</p><p> Reduced reporting discrepancies and improved reliability.</p><p> Automated recurring reporting workflows using Power Query.</p><p> Reduced manual report preparation time and improved turnaround for stakeholders.</p>
Associate Data Analyst
<p>Analyzed 4M+ sales and inventory records using SQL, Tableau and Excel to identify demand patterns and sales trends.</p><p> Supported inventory planning and demand forecasting across retail and online channels.</p><p> Identified a bestseller stockout pattern across Tier-1 and Tier-2/3 markets using root cause analysis.</p><p> Surfaced a stale demand-forecast cycle that informed a shift to monthly forecast refresh and revised distribution SLAs.</p><p> Reduced stock shortages in metro stores and overstocking in smaller markets.</p><p> Identified a 30% product return rate through SQL-based root cause analysis.</p><p> Segmented returns by size variant and customer feedback.</p><p> Traced the issue to sizing inconsistencies in a new product line.</p><p> Collaborated with product and sales teams.</p><p> Delivered a 16% reduction in product returns and a 9% increase in sales for the affected products.</p><p> Designed and maintained dashboards tracking sales trends, product performance, inventory movement, and demand patterns.</p><p> Enabled stakeholders to monitor business performance and operational planning.</p>
PROJECTS
Automotive Retail Analytics
<p>- Designed and maintained Power BI dashboards against an Azure SQL reporting layer, transforming</p><p>operational data into business information across 10+ KPIs - repair order volume, technician efficiency, noshow</p><p>rate, etc, made readily accessible to account-facing stakeholders through weekly business reviews</p><p>- Wrote SQL queries against the reporting layer (customers, appointments, repair orders) to build data</p><p>validation queries supporting operational reporting and ad-hoc analysis for client-facing teams</p><p>- Identified and resolved data quality issues, including duplicate customer records, missing repair-orders,</p><p>reducing reporting discrepancies and improving reliability</p><p>- Automated recurring reporting workflows using Power Query, reducing manual report preparation time</p><p>and improving turnaround for stakeholders</p>