Ray Victor P. Bartolome
Birthday: Aug **, **** Mobile No.: 097*-***-****
Status: Single Email Ad.: adcg4o@r.postjobfree.com
COLLEGE: Polytechnic University of the Philippines, 2011
BSBA Marketing Management
HIGH SCHOOL: Batasan Hills National High School, 2007
Set the Sales Information and Demand Planning Processes in Ardent World Inc
Successfully headed projects that lowered down the penalty of URC to SM Group from 7M to 0 year-to-date March 2019
Pioneered and established the Sales Information system of Danone-URC
Led the Sales Integration Project of Philip Morris International and Fortune Tobacco Philippines on North Luzon and North Mindanao and awarded as the second best among the members as per annual evaluation result
Lead, Demand Planning and Sales Information
Ardent World Inc – Business Planning, April 2019 - September 2019
Led the Business Planning Group of the company covering Sales Information and Demand Planning
Managed and led internal meeting with the Demand Planning team in
a. Preparation of timely consolidated reports using historical data and inputs (qualitative and quantitative information) for analysis on actual vs forecast demand plan
b. Generate weekly and quarterly supply plans that meet financial objectives
c. Analyze product sales on a daily basis
Proactively trained and mentored the demand planning team to ensure that the group’s KPIs were consistently met.
Established relationships with Key Stakeholders across the organization and led demand review and S&OP meetings with Sales, Marketing and Senior Leadership
a. Reviewed recommended sales
b. Spearheaded the forecast demand, inventory, and multi-channel sell through
c. Ensured team release prompt advisory to Sales and Marketing regarding reallocation
d. Coordinated with Marketing and Product Development teams to set launch quantities of new product introductions and to ensure smooth product transitions
e. Evaluated risks
f. Monitored SKU levels and recommended SKU rationalization initiatives in the future
g. Provided analysis on business operations of assigned accounts (product lines, stores) to determine profitability and to create a baseline for action and operational changes
h. Planned and implement ed contingency plans to mitigate stock outs, non-moving stocks
i. Looked for opportunities and drove partner groups to approach action
Coordinated closely with Business Analytics team in ensuring
a. Consolidation of information from various data sources are considering in the analysis
b. Accuracy and completeness in Intel for a more accurate analysis and evaluation of sales and demand requirement
Coordinated and influenced the Sales and Supply Chain Teams to
a. Ensure supply plans meet sales requirements
b. Allocate constrained components, ensure raw material inventory targets are met
c. Minimize material obsolescence during product transition
Collaborated with Sales, Finance and Supply Chain to review Customer Performance in relation to company’s set goals on Sales Growth, Offtake, and Account and Area Sales Potential.
Presented product updates and recommended actions to Operations Executive Management Team on a weekly basis.
Identified improvement opportunities in the product planning process, marshalled resources, and drove projects to completion.
Allocated recommendations across affiliates using established priorities and protocols.
Sales Logistics Account Manager
Universal Robina Corporation – Supply Chain, December 2017 – March 2019
Provided superior customer service and support
Developed solid relationships with the accounts by providing them with excellent customer service
Lessened the penalty and improved ordered fill rates SM Group, Alfamart, and Waltermart.
Influenced and supported the external and internal customers to achieve the common the goals.
Complied with the account’s delivery documentary requirements to ensure acceptance of delivery and avoid floating account affecting succeeding orders.
Implemented URC Supply Chain Standards to RD warehouse operation to ensure the delivery of high-quality products up to the end consumer.
Managed the movement of goods, ensured that they are picked up, transported and delivered on time to the client’s satisfaction
Regularly monitored and verified Shipping Lines performance at the destination.
Managed NKAG Servicing via Regional Distributor or 3rd Party Logistics Provider.
Initiated projects for the improvement of RD delivery and warehouse operations.
Provided Supply Chain Training Module to RD Warehouse personnel.
Did joint forecasting with URC Sales Team.
Ensured that the inventory level of NK SLOCs is equivalent to 50% of the account’s forecast.
Ensured that each consolidator warehouse follows the delivery protocol prescribed by the account.
Sales Information and Demand Planner
Danone Universal Robina Beverages Inc – Sales, November 2014 – December 2017
Pioneered and continuously improved all reporting systems of the organization (DURBI)
Generated reports based on standard formats, processes, and procedures: Daily Sales Reports (SIV and STT), Regional Distributors Ending Inventory per SKU, Placement/Buying Report, Monthly Operations Review (MOR) Reports, Weekly/ Monthly Sales Reports, Sales Incentives Computation and Sales Business Planning (Business Review) Materials
Safeguarded the confidentiality and integrity of all Sales Information
Worked closely with URC SIPG and ISD in ensuring consistent and reliable data coming from Sales tools such as SAP, BARS and other information systems that could affect the function of SIDP
Maintained efficient Database Management
Practiced Market and Consumer Analysis
Employed Short/ Long Range Planning – Target Administration
Managed Sales Incentives
Led Demand Planning
a. Led discussion of Agreed Demand Plan to align volume forecasts across all functions
b. Managed development of baseline (3-Months-Moving-Average) per SKU per account per channel using a statistical model based on recent trends
c. Worked with sales and marketing teams to clean out outliers
d. Collaborated with sales and marketing teams to integrate assumptions and plans
e. Communicated and aligned demand plan with supply chain and finance
f. Quantified opportunities and risks to forecast and facilitate identification of gap-bridging activities
Field Operations and Planning Analyst
Philip Morris International – Special Projects, November 2012 – May 2014
Served as an executor which focuses on all Sales Projects on a National Scale initiated by the company.
Properly performed plans and strategies prepared by the management to all sales offices from Luzon to Mindanao.
Planned and defined project scope
Planned and sequenced activities and resources
Developed schedules and timeline estimates
Estimated project costs
Developed budget
Prepared accurate project documentation
Analyzed and managed risks and issues
Monitored and reported the progress of the project
Worked closely with business partners and other vendors
Executed post-project evaluation
Documentation Associate for Safmarine
A.P. Moller-Maersk Group – Sales, Product & Yield, August 2011 – October 2012
Interfaced with origin offices to resolve issues in daily operation.
Delivered performance on timeliness, accuracy, and productivity and ensure Global KPIs are met.
Did follow-ups daily jobs in Right-fax & MCS and ensure MODS processing as is per specific IOP.
Did follow-ups and reply emails in MCS, APM or phone calls courteously and professionally.
Worked closely with the team leader to meet Critical Success Factors.
Constantly reviewed standard working procedures within the team leader; ensured the new SOPs are understood and being followed; updated procedures whenever necessary
Advised team members of the new IOPs and make sure they are being followed
Effective Leadership Training
Universal Robina Corporation, Tera Tower, HR Training Room, June 07, 2018
SLAM WORKSHOP
URC MCD Conference Room, Bagumbayan, Libis Quezon City January 18-20 2018
Professional Image and Demeanor
JG Summit, 2016
Danone Acqua Indonesia Sales Immersion Program
Danone Acqua Indonesia, 2015
URC Sales Information and Demand Planning Group Immersion Program
Universal Robina Corporation Litton Mills, 2014
SALES INFORMATION AND DEMAND PLANNING PROCESSES (MAY 2019)
SM SNACKS EXCHANGE NEW DELIVERY SYSTEM (OCT 2018)
ALFAMART CHANGE SOURCING (AUG 2018)
SM DC ASINAN WAREHOUSE 4 TRANSFER (JUN 2018)
SM-SALES-CSS ROLES ALIGNMENT (FEB 2018)
DELIVERY ACCEPTANCE PROTOCOL FOR SM GROUP (JAN 2018)
BLUE BESHIE SQUADPACK, DURBI (AUG 2017)
DURBI – URC SALES SYNERGY WORKSHOP, DURBI (NOV 2016)
BLUE SUMMER FEELS SALES PROMOTION, DURBI (MAR 2016)
CUSTOMER MASTER LIST (GEN TRADE NATIONAL), DURBI (2015)
REPORTS TEMPLATES, DURBI (2015)
SALES INFORMATION AND DEMAND PLANNING PROCESS, DURBI (NOV 2014)
ROUTE-TO-MARKET PROJECT, PMI (2014)
NATIONAL TRADE CENSUS PROJECT DATA HUB, PMI (2014)
NATIONAL TRADE CENSUS BOOKLET, PMI (2014)
NATIONAL TRADE CENSUS PROJECT, PMI (2013)
PROJECT LUZON – ROUTE OPTIMIZATION, PMI (2013)
NATIONAL SALES INTEGRATION BOOK, PMI (2013)
NATIONAL SALES INTEGRATION PROJECT OF PMI & FTC, PMI (2012)
EDUCATIONAL
ATTAINMENT
ACHIEVEMENTS
WORK
EXPERIENCE
TRAININGS AND SEMINAR
PROJECTS HANDLED