About Candidate

Work & Experience

B
Business Intelligence And Demand Planning Analyst 08/02/2023 - Current
Healthy U Limited

-Developed Python scripts to automate stock distribution from the warehouse to retail stores, reducing reliance on manual Excel processes and improving efficiency. -Built a Python tool that provides recommendations for rotating stock between stores. -Created and amended departmental SOPs. -Led the department towards ISO certification - ISO 9001 -Represented the department in the SAP re-implementation strategic planning process, ensuring department needs were addressed. -Developed permissions management on dashboards and reports for all users on PowerBI. -Introduced cloud data storage (Big Query) for storing and processing of supermarkets data. -Established optimal minimum and maximum stocking levels across retail stores and warehouses to ensure efficient inventory management. -Rebalanced stock between warehouses, preventing overstocking and reducing inventory holding costs. -Managed short-expiry products proactively, minimizing losses and improving stock utilization. -Analyzed and reported on obsolescence, new product performance, brand performance, and departmental performance to guide strategic decision-making. -Led cross-functional strategy meetings with shop managers, zonal leaders, procurement, and retail teams to address sales strategies, slow-moving inventory, and stockout issues. -Developed data-driven reports for the marketing team, providing insights on slow-moving products, obsolescence trends, and new product performance.

S
Senior Business Analyst 01/2022 - 01/2023
Sama

-Prepared monthly client invoice and submitted it to the senior project manager for approval. -Developed revenue forecasting models, improving financial planning and decision-making. -Led meetings with project managers to discuss KPIs and project performance. -Coordinated with administration to streamline internet payments for remote reviewers, ensuring smooth operations. -Conducted data quality checks on analytical work from the team. -Represented Sama in meetings with Facebook where we discussed agent metrics like utilization and occupancy as well as challenges that affected operations. -Developed and maintained Google Apps Script for seamless data integration with BigQuery, enhancing analytics capabilities.

B
Business Analyst 03/2020 - 12/2021
Sama

-Created and maintained project dashboards on Google Sites. -Monitored agent performance metrics (utilization, occupancy) on Looker, identifying optimization opportunities. -Performed statistical analysis such as covariance and correlation with the aim of finding out the variables that affect agent metrics. -Visualized agent and annotation data on Looker and Google Data Studio -Prepared presentation decks for client meetings -Capacity planning. Allocated agents to sub-projects based on the needs and requirements of each workflow.

D
Data Analyst 06/2019 - 02/2020
Opera (Powerbets)

-Reconciled missing transactions on the payment wallet -Computed and submitted weekly regulatory returns to BCLB -Prepared weekly and monthly reports for the board - website promotions reports, call analysis reports, SMS ROI reports -Prepared list of users who felt disgruntled by the company’s services; they would later be contacted by the outbound team.

Skills

Microsoft Excel
95%
Python Programming
95%
Data Visualization - Power Bi, Google Data Studio
95%
SQL
90%
ERP - SAP
90%