JAMES ARNEL L. MUYCO
Bacolod City,NEC
Summary
With 18 years of experience in sales data analysis within one of the Philippines' largest conglomerates, I specialize in sales forecasting, data management, and business analytics. I have a proven track record of transforming complex data into actionable insights that drive strategic decisions and improve operational efficiency. Currently pursuing a Master's Degree in Data Science, my passion lies in leveraging advanced analytical techniques to enhance business performance. Alongside my technical skills, I am dedicated to fostering a collaborative environment by sharing knowledge through training and mentorship, contributing to our collective success.
Overview
18
18
years of professional experience
Work History
Supervisor - Sales Information Group
San Miguel Brewery Inc.
05.2024 - Current
- Reports directly to the Area Sales Manager & AVP of Sales in Visayas
- Prepares monthly sales forecast for all sales personnel for four regional offices using various forecasting techniques
- Facilitates Monthly Operations Reviews and prepares all presentations of the Area Sales Manager/Assistant Vice President in Microsoft PowerPoint
- Prepares 3-month rolling forecast of both alcoholic and non-alcoholic products to manage raw materials and full goods inventory
- Manages upkeep of sales database from various sources like SAP and Data Warehouse and automates the consolidation of data using VBA Programming in Excel.
Supervisor - Sales Information Group
San Miguel Brewery Inc.
08.2017 - 04.2024
- Prepared training module for Business Analytics from an SMB perspective and trained over 100 members of the Trade Marketing Group nationwide
- Introduced and taught SQL to team members for better database management
- Accomplished Annual Budget which included PESTEL Analysis, SWOT Analysis & Long Range Planning and Forecasting
- All other functions as detailed above for Supervisor in Visayas.
Supervisor - Sales Information Group
San Miguel Brewery Inc.
10.2015 - 07.2017
- Reported directly to the Key Accounts Group Manager
- Assisted the Sales Organization in the development of a new group catering only to big national chains (Key Accounts Group)
- Automated the handling and processing of sales data by taking advantage of Excel macros thereby shortening the processing time from 2 days to less than 2 hours
- All other functions as detailed above for Supervisor in GMA North.
Region Assistant - Sales Information Group
San Miguel Brewery Inc.
04.2012 - 09.2015
- Prepared daily, weekly, monthly, quarterly, semiannual, and annual sales updates per sales agent, per supervisor by month and by SKU using Microsoft Excel
- Forecasted sales targets per sales agent and dealer based on last year performance, average 3 months and seasonality
- Conducted fieldwork activities to randomly check the accuracy of submitted reports of sales supervisors, to verify market information, and to gather data needed for a specific study
- Prepared monthly presentation materials of the Regional Manager.
National Assistant - Sales Information Group
San Miguel Brewery Inc.
04.2010 - 03.2012
- Consolidated the Annual Budget Report from all 7 Areas all over the country
- Prepared standard Excel and PowerPoint templates and reports to be used in all 7 Areas
- Consolidated all volume and outlet-related reports for National Management decision-making.
Region Assistant - Sales Information Group
San Miguel Brewery Inc.
04.2006 - 03.2010
- Awarded Top 2 Sales Assistant after only 2 years in the position
- All other functions as detailed in Region Assistant for Panay Island, Philippines.
Education
Professional Science Master's Degree in Data Science -
Technological Institute of the Philippines
Bachelor of Science in Electronics and Communications Engineering - undefined
Technological University of the Philippines - Visayas
03.2004
High School - undefined
Trinity Christian School
03.1999
Elementary - undefined
Trinity Christian School
03.1995
Skills
- Sales Forecasting
- Microsoft Excel
- VBA Programming
- Microsoft PowerPoint
- Market Research Data Analysis
- Python and R Programming
Languages
English Proficient
Filipino Native
Hiligaynon Native
Visayan Proficient
Passions
- Automating repetitive tasks
- Traveling to new places
- Learning new languages
References
- Victor T. Vecera, Area Sales Manager, San Miguel Brewery Inc, 63 917 721 1553
- Jeremy G. Losbañes, Sales Manager, San Miguel Brewery Inc, 63 917 506 7931
- Christina E. Chu, Sales Information Head, San Miguel Brewery Inc, 63 917 563 3925
Training
- Predictive Analytics, National Engineering Center, UP Diliman, August 2023
- Business Analytics, Asian Institute of Management, Oct-Nov 2022
- Predictive Analytics for Data Driven Decisionmaking and Profit Maximization, Dataseer, July 2016
- Quantitative Techniques in Predictive Modeling and Statistical Report Writing, UP Diliman School of Statistics, June 2011
- Time Series Analysis and Forecasting, Philippine Statistical Association, June 2010
Interests
Working out, Travel, Languages, Yoga, Spirituality, Meditation
Timeline
Supervisor - Sales Information Group
San Miguel Brewery Inc.
05.2024 - Current
Supervisor - Sales Information Group
San Miguel Brewery Inc.
08.2017 - 04.2024
Supervisor - Sales Information Group
San Miguel Brewery Inc.
10.2015 - 07.2017
Region Assistant - Sales Information Group
San Miguel Brewery Inc.
04.2012 - 09.2015
National Assistant - Sales Information Group
San Miguel Brewery Inc.
04.2010 - 03.2012
Region Assistant - Sales Information Group
San Miguel Brewery Inc.
04.2006 - 03.2010
Professional Science Master's Degree in Data Science -
Technological Institute of the Philippines
Bachelor of Science in Electronics and Communications Engineering - undefined
Technological University of the Philippines - Visayas
High School - undefined
Trinity Christian School
Elementary - undefined
Trinity Christian School
Similar Profiles
OMAR POSADASOMAR POSADAS
Electrical Electronics Technician at San Miguel Brewery Inc.Electrical Electronics Technician at San Miguel Brewery Inc.
Jose Andres MartinezJose Andres Martinez
Territory Sales Supervisor at San Miguel Brewery IncTerritory Sales Supervisor at San Miguel Brewery Inc
Omar PosadasOmar Posadas
Electrical Technician at San Miguel Brewery Inc.Electrical Technician at San Miguel Brewery Inc.