Demand Planner

Systems used

• Microsoft Word and Excel
• Pivot Tables
• Power BI
• DAX
• SAP

Career Summary

Current Employer – Wholesaler

Position – Supply Chain Analyst (Demand Planning and Demand Forecasting)

Dates – December 2022 – Present

• Working in a team of 6 and reporting into the Demand Planning Manager
• Optimised stock purchasing by analysing sales trends and demand forecasts, ensuring procurement decisions aligned with category plans and company objectives
• Led new product introductions by developing insightful demand forecasts and collaborating with internal stakeholders to facilitate smooth market launches and sustained product visibility
• Negotiated and reviewed supplier agreements, identifying cost-saving opportunities through vendor incentives and rebates, optimising procurement strategies for enhanced profitability
• Managed stock movement and logistics, coordinating with warehouses and third-party logistics providers to ensure efficient deliveries and minimal stock disruptions
• Analysed supplier/vendor price feeds, proactively identifying and resolving data discrepancies to maintain pricing accuracy and high data quality
• Developed sales forecasting models using advanced DAX formulas, enabling data-driven decision-making for seasonal and high-demand products
• Enhanced reporting efficiency, generating routine and ad-hoc reports on category spend, profitability, and performance, providing strategic insights to improve stock and demand planning
• Collaborated with internal teams, including procurement and product design, to resolve supply chain data issues and maintain compliance with purchasing policies
• Championed process improvements, automating data reconciliation and reporting in Power BI to support senior stakeholders with accurate and timely insights
• Supported purchasing teams by assisting with procurement-related tasks, ensuring seamless operations and alignment with category objectives

Previous Employer – Wellness Programme

Position – Data Business Analyst (Fixed Term Contract)

Dates – April 2022 – December 2022

•  Collaborated with customer-facing teams to determine and develop the critical metrics vital to measure and identify early- stage service level agreements, enabling our business and technical teams to proactively resolve client issues
• Engaged in proactive stakeholder management with a range of personalities during product development activities using the data available from business intelligence analytical platforms such as Metabase to help drive data-based decisions
• Maintained relationships with key people for various data sources internally
• Got hands-on with applications, data/integration tools, and databases to extract and analyse data to support decision-making and prototyping
• Generated insights by sourcing and joining data from multiple tables in relational databases using SQL queries such as Left join, inner join and rights join
• Supported the development of a new data warehouse solution by identifying data redundancy in database schema
• Developed a customer feedback report that calculated CSAT scores and Net Promoter Scores
• Gathered business requirements for building dashboards that distinguished between the number of programmes signed up to by staff members of each client. This was to create track records of programmes completed, on track and uncompleted for client relationship management meetings
• Developed and built data models to facilitate the delivery of data to all necessary aspects of the business, including third- party suppliers. Worked with users to understand their data requirements and translate them into logical data models
• Developed test plans and completed executed test cases to software product development

Previous Employer – Utilities contractor

Position – Data Business Analyst (Logistics)

Dates – March 2021 – April 2022

• Developed and managed a workflow of outbound stock orders across multiple processes, managing client experience while minimizing fulfilment costs with third-party supply chains
• Developed and delivered several MI Reports and Dashboards using various analytics tools, e.g., Excel
• Extracted data from multiple databases using T-SQL querying
• Executed a daily delta load in an ETL process to SQL Server database
• Analysed and built a stock reconciliation of serialized assets between third-party supply chains and the organization to reallocate stock in different pick locations within the end-to-end process in logistics
• Provided support to a SQL development team tasked with developing a data warehouse that is reliable and effective in raising orders for engineers in the field
• Captured and documented multiple sets of data and translated them into meaningful management information for reporting
• Managed the integrity of a stock reconciliation log to ensure the status of investigations of assets is kept accurate and up to date with reliable data
• Built a forecast rundown for clients, identifying actual and forecasted amounts of stock within different locations in the stock system

Previous Employer – Auto Chemistry Shop

Position – Business Data Analyst

Dates – November 2020 – March 2021

• Liaised with different stakeholders within the senior management team to prioritize and build management information for data analytics and reporting
• Filtered and cleansed data, reviewed computer reports, printouts, and performance indicators to locate and correct code problems as they arise
• Produced ad-hoc reports as requested by Operations and the management team
• Prioritized and built management information for data analytics and reporting, collaborating with stakeholders
• Monitored and delivered hourly KPIs to the management team
• Conducted data quality control and produced ad-hoc reports as requested

Previous Employer – Bank

Position – Junior Business Analyst

Dates – July 2017 – November 2020

• I was instrumental in providing support to the facilitation of workshops to capture functional requirements and non- functional requirements by managing stakeholders buy-in to requirement gathering and documentation
• Supported the lead business analyst in identifying and engaging with external stakeholders and subject matter experts to define and document business requirements through workshops and techniques
• Liaised with product owners and other external clients to gather high-level requirements for a new service management tool and an ecommerce website
• I translated business requirements and wireframes into user stories within an agile scrum environment
• Collaborated in facilitating walkthrough sessions to align acceptance criteria and requirement change management in an agile scrum project delivery
• Documented the business objective and value model for a new service management tool
• Liaised with developers and software testers in UAT plans to review software performance
• Responsible for developing management information and business as usual (BAU) reports to support field operations and senior stakeholders in making informed decisions
• Developed user acceptance test scripts for software updates to database management systems and ensured quality control