Trade Promotion Planning

 

Demand & Supply Planning

 

Sales & Operations Planning

 
Our Projects

Oracle Demand Management and Supply Planning Cloud Consultant for a leader in secure AI driven networks. Implemented Oracle DM Cloud 1.0 and Oracle SP Cloud 2.0. Supported planners after go live

 

As US Coast Guard licensed captain sailed in Tahiti with crew from San Francisco – Raiatea – Tahaa – Bora Bora

 

 

Demand and Supply Planning Consultant in Oracle Cloud Supply Chain Planning implementation for privately held company specializing on indoor and outdoor plant growing, addressed very challenging business requirements of 12 year long planning horizon with very detailed level of planning – daily and weekly. Worked closely with Oracle Product Management and Product Development team on application issues and requirements.

Planning Lead in Oracle Cloud Supply Chain Management implementation in a privately held $4 billion company committed to offering high-quality, healthy brands and helping consumers make better choices, every day. Implemented Oracle Fusion Supply Chain Planning modules, configured to use the system for attribute based forecasting

Solution Architect of Phase 2 implementation of TPx (stands for Trade Promotion Management, Planning and Optimization) at the leading provider of packaged seafood. During this phase Customer and Product profitability measurements were configured for the past and future periods, Demantra PTP and DSM 12.2.3 was upgraded to 12.2.5 with the purpose to have both: Shipment and Consumption statistical forecasts. It allowed to bring forecast Weighted MAPE to 22% and Total % Error to 24%. Besides software upgrade this job required massive configuration and development:
1) Created repository, mapped and loaded Nielsen and IRI data;
2) Reconstructed historical retail promotions based Nielsen and IRI data loaded;
3) Re-configured Shipment based promotional system into Consumption & Shipment based promotional system;
4) Statistical engine tuned based on consumption data and historical retail promotions to estimate consumption demand for future promotions entered by sales team and brokers. Enabled Scenario planning and What If Analysis for different discounts and resulting ROI;
5) Retrained Sales team and brokers, that used Shipment based TPM system, to use Consumption based TPx system and Consumption Simulation. Enabled Demand planners to use Shipment Simulation

 

Solution Architect of S&OP implementation at the leading manufacturer of Asian/Ethnic foods and appetizers. Established a new enhanced S&OP process based on Oracle apps – Demantra, ASCP, APCC. Enabled VP of SCP, Demand and Supply planners to focus on business and data analysis, and not only transactions, improve forecast quality, optimize inventory level and improve customer service level. Worked together with Master Data management team on master data cleanup process establishment, worked with sales and marketing team to enable inter-team demand projection collaboration

 

Solution Architect of Retail Price Execution system implementation at the  retailer-owned cooperative serving retail member stores with a complete assortment of grocery, fresh meat, fresh produce, specialty foods, health care, and general merchandise items

Architect and project lead of Trade Promotion Management implementation at the leading provider of packaged seafood – gathered requirements; completed conceptual and functional design; configured Oracle Demantra PTP and DSM modules and integration with Oracle EBS and Account Review; created user adoption process; and supported after Go Live. The tool configured for 2 divisions – Retail and Foodservice, accommodating Foodservice main requirement to track payments by distributor opcos and operators. The planning tool configured based on weekly time buckets, with calendar month, and daily calculation of promotional volume and spend. The project won Supply & Demand Chain Executive’s 2016 Top 100 Supply Chain Projects Award

 

 

 

Subject matter expert at the private company which sells an eponymous brand of beverages and fruit extracts; improved TPx system to improve Sales planning process and tool

 

Architect and project lead of Trade Promotion Management system for the multinational food products corporation – the system designed and built based on Oracle Demantra PTP and DSM modules; configured integration with SAP modules – demand planning, AP and AR, order management; configured intuitive tool for New product introduction and product replacement; the trade planning tool built based on weekly time buckets with daily promotional volume and spend calculation; configured Scenario planning for account plan optimization, and one calendar for marketing, national, and account specific events, and improved deduction resolution process with settlement savings and decreased number of open deduction days

 

Technical Architect of Supply Chain system evaluation at the multinational brewing and beverage company – Master Data Management, Forecast Planning, Master Planning, and Production Planning modules  were evaluated to help client to make decision in critical situation; and answered a question if master data management and supply chain planning system were good enough

 

Architect/ Project lead/ Developer of Demand Management system at the American multinational telecommunications corporation – the existing system evaluation; gap analysis; solution creation to address demand and supply planners’ needs to increase forecast accuracy and enhance user adoption and experience; configured functionality that allow dynamic product hierarchy level re-structuring to generate statistical forecast for different data streams

Designed and configured accelerator layer based on CPG industry best practices in TPx. This configuration layer has been packaged and sold by consulting company as Express solution

Solution Architect and Technical Lead at the American packaged food company. Designed and implemented event planning, fund balance, and claim management process at one of the largest packaged food company, using PTP and DSM modules of Oracle Demantra application. Provided Post Go Live support for both modules, during it many enhancements suggested by planners and administrators were built and introduced to users

 

Demantra Advanced Forecasting and Demand Modeling Solution Architect at the Irish-American global diversified industrial company. Designed planning business processes for 2 divisions – Commercial Security Technology and Residential Solution; implemented Demand planning module for both divisions faster than estimated; configured Supply planning process with resources allocation used for S&OP process; tuned statistical forecast engine to achieve significant forecast accuracy improvement for both divisions

 

Configured Demo environment and Sales presentation for Trade planning and Deduction settlement process based on CPG industry best practices using Oracle Demantra tool

Played different roles of Solution Architect, Functional consultant, Technical consultant, team lead on more than 10 Oracle Demantra international implementations of all Demantra modules. Implemented custom and standard data integration modules between Demantra and other products (SAP, JDE, Web Concepts eVMI, I2, Siebel, Infor). Improved business planning processes, trained client core business teams, and successfully managed user adoption processes. Clients: Sony Entertainment, Schiff, Korbel, EA, Cisco, DeAcero, Sun, CARQUEST, Snyder’s of Hanover, Johnson & Johnson, etc

Irina Walker
Think Clarity Founder