Data Analyst / Sales Support Supervisor
Nestle
Total years of experience :17 years, 4 Months
• Lead the Sales Support department which is considered the backbone of the business and its operations.
• Responsible for information flow, performance reporting analytics and admin tasks for Nestlé Lebanon.
• Embrace the data driven mindset across the business. Improve the way the business sees data.
• Develop advanced tools such as monthly forecast and distributors IMS sell-out/TPS forecasting tools using advanced techniques in Excel.
• Develop interactive dashboards for the sales team through Tableau & Power BI.
• Roll-out the projects such as forecasting system, sales ordering system, pre-post evaluation tool.
• Build capabilities across the company by providing trainings in Excel and implemented tools.
• Monthly Business Planning Cycle; prepare and consolidate the forecasts per SKU per sub-channel in coordination with the Channel Managers, Category Managers, and Demand Planner.
• Generate timely and meticulous analysis for Trade Spent, Forecast, Real Internal Growth, Organic Growth, by Brand / SKU / Channel / Customer, Distributors IMS and Stock Cover, Incentives.
• Orchestrate the following year forecasting plan by creating the right tools and scheduling meetings.
• Ensure all trend spend in the system is accruing correctly; process the rebate payments per customer.
• Reporting directly to the GBM; support in ad-hoc requests, PPT presentations, dashboards, scorecards.
• Create simulation analysis on outlook for the top management by taking into consideration many factors.
• Report to the Regional Head Office the monthly requirements as per the standards.
• Consolidate all the data and information required for analysis or presentation from different internal and external stakeholders.
• Manage, coach and develop own team in the department.
• Ensure proper balanced control and the right delegation/rotation of work in the department.
• Lead the Compliance foundation in the Nestle Continuous Excellence.
• Handled the supply chain reporting, KPI’s, and analyses for the subsidiaries and countries.
• Audited the procurement and warehousing data and suggest for enhancement and best practices.
• Supported on the analysis and dissemination of information for strategic planning.
• Trained the end-users on how to enter correct data in the system when creating PR & PO, preventing GIGO.
• Categorized thousands of different purchased materials for effective insights, through data cleansing.
• Leverage on the untapped supply chain and procurement data to take better decision.
• Analysed data through advanced & powerful BI tools such as Tableau and Oracle Discoverer.
• Maintained the supplier and item code master data in Oracle system; ensured data consistency and quality.
• Coordinated with each market’s procurement heads for insights, data cleansing, and new data policies.
• Developed strategic objectives, KPIs, responsibility matrix, job descriptions, and system gap analysis.
• Supported in developing new policies and procedures manuals as a step towards centralization of supply chain department for all subsidiaries in GCC, Levant, and European countries.
• • Analysed the sales trends, performance, and distribution.
• Conducted timely and regular analysis and performance report to management.
• Collected and analysed data from multiple platforms. Inspected for data discrepancy in the system.
• Reported directly to the Sales Director; prepared sales meetings and supplier meetings analysis.
• Identified gaps and opportunities per SKU, salesperson, and channel. Compared actual sales vs. target.
• Handled the split and adjustment of the monthly sales targets per area, salesperson.
• Reassessed allocated target versus the agreed annual forecast per brand.
• Supported the IT department in proposing and developing blueprint of the required data and reports.
• Key member for the Oracle ERP system enhancement and issues.
• Provided analysis of programming and sales by creating technical templates in Excel and Access.
Worked for a few months as Supply Chain Officer:
• Studied consumption trends comparatively with forecast provided by sales and marketing.
• Coordinated on shipments and receipt of documents, clearing agents and warehouses for receipt of goods.
• Monitored stock level, SKUs expiries, and suggested orders to be placed and actions to be taken.
• Developed weekly reports related to current and forecasted inventory in pallets by item.
• Analyze the FMCG sales trends, performance, and distribution.
• Conduct timely and regular market analysis and performance report to management.
• Report directly to the Sales Director.
• Review monthly sales data and compare actual sales vs. target.
• Identify gaps and opportunities per SKU, salesperson, and channel.
• Analyse the allocation and adjustment of the monthly sales targets.
• Reassess allocated target versus the agreed forecasted annual budget per brand with finance.
• Assist the IT department in proposing and developing blueprint of the required data and reports.
• Inspect for data discrepancy in the system.
• Take part in frequent meetings concerning the Oracle system problems and issues.
• Provide analysis of programming and sales by creating technical template reports in Excel and Access.
• Report performance studies to the sales meetings and supplier meetings.
• Study the contracts of each top client and calculate volume rebates and discounts.
• Monitor the sales team and assure the company’s policies are being followed.
• Have a close working relationship with all the departments.
• Preserve confidential information.
• Handled sales coordinator position while vacant
Accomplished lecture sessions about Banque Du Liban departments and their operation.
Attended intensive course in computer networks and communication systems.
Explored network topology, layering and structure at LAN and WAN of the Banque Du Liban headquarter.
Assisted the database administrator.
Learned advanced techniques in SQL using Oracle.
Troubleshot employees’ systems and network.
Managed reports and system documentations.
Master in Business Administration