David Clinton

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

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

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

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