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%.

My Projects

Skills

Technical Skills

• Data Analysis Language: Python, R, SQL, DAX

• Data Visualisation Tool: Power BI, Tableau, Excel

• Databases: MySQL, Azure SQL, PostgreSQL

• Machine Learning: Prophet, SARIMA, XGBoost, Random Forest

• Other Tools: Power Query, Jira, Trello, ClickUp

Soft Skills

• Excellent attention to detail with diligence.

• Highly organised, with the ability to work to deadlines, multi-task, prioritise and re-prioritise workload as needed.

• Proactive, with the ability to work effectively within a fast-paced and high-pressure environment.

• Quickly adapt to cope with changing products, processes and procedures.

Business Domain

Retail Sales, Category Performance, Pricing, Inventory Optimization, Supplier Analysis

Education

Certificates

• PwC Power BI Job Simulation – Data Visualization & Customer Insights

• Accenture Data Analytics & Visualization – Data Cleaning, Modelling, Storytelling

• Quantium Data Analytics – Customer Segmentation & Uplift Testing

• TATA Group Data Visualization – Business Insights & Visual Communication

Get in touch