Hi, I'm Frank

Work Experience

• Analysed multi-store sales data across 12+ outlets to identify product performance and pricing opportunities, driving an 18% increase in top-selling SKUs.

• Developed automated Power BI dashboards and SQL data models to visualize category performance, outlet comparison, and supplier contributions in real time.

• Built DAX measures for margin, growth rate, and cost variance, improving financial accuracy and executive visibility.

• Forecasted weekly demand using SARIMA, Prophet, and XGBoost, reducing stockouts by 20% and optimizing replenishment cycles.

• Created churn prediction and customer segmentation models using Python to identify at-risk wholesale accounts, cutting attrition by 20%.

• Integrated multiple data sources (POS, supplier, inventory) using ETL workflows to ensure consistent and validated business reporting.

• Conducted profitability analysis by SKU, supplier, and store to maintain a consistent 25–30% profit margin group-wide.

• Evaluated campaign uplift through pre- and post-promotion analysis to measure effectiveness and ROI.

• Collaborated with management to design data-driven pricing and assortment strategies supporting $50M FY25 revenue targets.

• Gathered and analyzed client campaign performance data to evaluate ROI and conversion rates.

• Built Excel dashboards summarizing campaign KPIs, audience reach, and engagement trends for client presentations.

• Coordinated data collection between creative, media, and client teams to ensure accurate reporting on digital performance metrics.

• Conducted market research and competitor benchmarking to guide content and advertising strategy.

• Analyzed campaign performance across 15+ digital accounts using Excel and Power BI to identify ROI drivers.

• Delivered post-campaign insight reports with actionable recommendations, improving campaign effectiveness by 15%.

• Gathered and analyzed client campaign performance data to evaluate ROI and conversion rates.

• Built Excel dashboards summarizing campaign KPIs, audience reach, and engagement trends for client presentations.

• Coordinated data collection between creative, media, and client teams to ensure accurate reporting on digital performance metrics.

• Conducted market research and competitor benchmarking to guide content and advertising strategy.

• Analyzed campaign performance across 15+ digital accounts using Excel and Power BI to identify ROI drivers.

• Delivered post-campaign insight reports with actionable recommendations, improving campaign effectiveness by 15%.