Work Experience:
Sunpower Philippines Inc. – Shared Services Organization
100 East Main Ave., Laguna Technology
Park, Binan, Laguna
Business Analyst – Sales and Operations (North America, Europe, Australia)
(November 2009
-July 2011)
-Responsible in providing global management with timely operational and financial analysis to facilitate sound business decision
-Handle and maintain 54 Business Metrics of Sales and Operations covering different regions
-Prepare, analyze and present the following reports to the global management team
- Global Sales Demand Summary (weekly) – monitor the actual performance and the current quarter outlook against revenue target
- Sales and Operations Review (quarterly) – in depth analysis of sales performance, operation routine and market research of the solar industry
- Customer Dashboard (weekly) – screen the total dealer in the region, computes the total dealer with order and with shipment
- Product Margin Report (weekly) – display the margin performance, price per watt analysis and various key performance indicator of the solar industry.
-
Logistics Cost Tracking (weekly) – monitor the Logistics cost in all warehouses around the world
- Design different Ad hoc Reports as per request
- Handle / Support 13 Regional Sales Manager in North America on their day to day sales call such as Dealer performance update, generation of dealer growth plan and analyze data in their completed dealer visit sheet
- Conduct meeting regarding Business Analytics Group concerns
- Lead 2 projects focusing on process improvement in Sales and Operation. (Refinement in dealer growth plan model and supported dealer ordering and created process flow in operation)
- Support in documenting work instructions and business process required to hold the operations requirements
-Work with different business units in doing their data analysis
Coca-Cola Bottlers Philippines, Inc. (Canlubang Plant) Canlubang, Laguna
Key Accounts Executive – Region Key Accounts Group, Sales Department
(July 2007
-May 2009)
Area Coverage
Halang – Calamba City, Los Banos, Sta. Cruz up to Infanta, Quezon (February 2008- May 2009)
Puerto Princesa, Palawan
(July 2007 to January 2008)
-Aggressively selling in of CCBPI product portfolio in 94 key account outlets located in the above-mentioned area
- Consistently achieve periodic volume targets in both physical cases and unit cases sold for 2008
- Increased growth rate of average daily sales (ADS) by 18% in year 2008
-
Author of various monitoring template which leads in helping sales force to examine business parameters and execute proper action
- Created Twelve (12) local programs which include exclusivity of schools and food court, distinctiveness of Restaurants in adherence to CCPBI marketing policies and supermarket promos that boost sales and product availability
- 100% timely execution of all National programs in coordination with National Key Accounts Directorates
- Achieved DSO level by 30 days and 75% Accounts Receivable currency in year 2008
- Daily monitoring of actual sales performance through Business monitoring template and proper execution of daily Schedule Call List
- Implemented merchandising principles per channel, brand and package level
- Able to identify key business drivers and customer’s hot buttons during negotiation
- Conducted business review to customers when necessary
- Generates monthly business review presented in country level
Coca-Cola Bottlers Philippines, Inc. (Canlubang Plant) Canlubang, Laguna
Account Developer – Traditional Trade Group, Sales Department
(April 2007 – June 2007)
Area Coverage ( Brgy. Callo, Sta.Cruz, Laguna to Sta.Cruz Town Proper)
-Executed the outlet survey that serves as baseline in analyzing market
-Responsible for executing marketing plans at the point of purchase in 400 outlets in my territory, mostly Sari-sari store
-In charge of establishing rapport to the retail outlet as front liner of the Coca-Cola sales force
-Creator of the outlet survey template used by other territories in the country to easily capture result of market analysis survey
-Produced business presentation for various dealers in the territory
-Conducted training in fellow Account Developer in Basic Microsoft Office programs
DHL Global Forwarding (formerly Exel Philippines) No.3 Sta. Aguada St. Pascor Drive, Paranaque City
Statistics Specialist, Marketing & Sales Department
(October 2006 – March 2007)
- Solid experience in managing data and analyzing business performance
-Generates monthly Business Review for Marketing and
Sales
-Generates monthly commentary performance report on a per Customer/Tradelane/ Industry perspective
- Involved in various Global and Local Bid. Negotiate rates in Asia Pacific region for better pricing
- Played a major role in 2007 budget preparation
- Nominated as Employee of the 3rd and 4th quarter for 2006
- Driver of several continuous improvement initiatives
-
Created a template wherein you can analyze the performance of the Account Owner’s actual performance against budget
- Developed a model for effective pricing to help make quick decisions during bids
- Train employees on basic Microsoft Exel
- Develop a tool to manage critical numbers and production trends for management reporting
Exel Philippines, Inc. 8th-10th Floor, NOL Tower, Madrigal Business Park, Alabang, Muntinlupa, Metro Manila.
Finance Systems Executive, Finance Department
(March 2005 – September 2006)
- Generates and analyzes reports on a per business transactions
- Customer Profitability Report Analysis
- Account Ownership Report
- Airline/Shipping Sales Report
- Export Consolidated Report Analysis
- New Accounts Analysis
- Checks and monitor accuracy of operation work practice by setting up revenue and cost code in Operating System
- Checks and monitor all charge code to ensure the correct posting nature in Financial Book
- Creates Query report based on the format provided by the end user
- Develop and design programs that will provide information for Air, Sea and Logistic Operation
- Assist in trouble shooting of Operation and Accounting system
- Issue irregularity report for uncosted/unbilled shipment
Exel Philippines, Inc.
8th-10th Floor, NOL Towers, Madrigal
Business Park, Alabang, Muntinlupa, Metro Manila
Accounts Payable Specialist, Finance Department
(February 2003 – February 2005)
- Processing of Payments
- Ensures the accuracy of figure in payment request, review and examine all supporting documents
- Logging of payment request to PR monitoring sheet
- Encoding, printing of A/P set-up and distribute to the A/P Officer for checking
- Prepares journal vouchers
- Replenishment of revolving fund
- Validates the correctness of amount and the completeness of all supporting documents
- Voucher preparation
- Printing of documents for checking and filing
- Reconciliation of unpaid bills
- Check preparation
- Receiving and filing of vouchers (released check vouchers)
- Monitoring of Official Receipts
- Cash pay of dollar disbursement
Panasonic Communication Imaging Corporation of the Phils.
Carmelray 2, Calamba City, Laguna
Materials Accountant, Finance Department
(February to November 2002)
- Checks and updates of unit costs for proper valuation of all inventories
- Conducts inventory taking and audit of supplied materials at supplier’s side
- Analyzes variances and prepares report
- Checks and records all purchases (local and imported)
- Prepares summary of amount due to supplier
- Verifies local suppliers’ statement of accounts and requests payment
- Prepares related journal vouchers
Coca-Cola Bottlers Philippines, Inc (Calamba Plant) Calamba City, Laguna
Route Settlement Analyst (RSA), Finance, Sales Section
(March to December 2001)
- Encodes Route Settlement Report
- Prepares Journal Voucher
- Conducts Monthly Physical Inventory
- Conducts Audit in different settlement areas
- Analyzes Subsidiary Ledgers
- Encodes Journal Vouchers
Coca-Cola Bottlers Philippines, Inc. (Canlubang Plant) Canlubang, Laguna
Accounting Analyst (SAP; A/P and G/L Encoder), Finance, Administrative Section
(October 2000 to February 2001)
- Encodes PRM (Check Vouchers)
- Encodes Journal Vouchers
- Maintains Check and Journal Voucher files
- Prepares Schedules (Aging of Accounts)
Education: 1996–2000
Colegio de San Juan de Letran,
Calamba, Laguna
Bachelor of Science in Accountancy (BSA)
1992 – 1996
Liceo de Los Baños,
Los Baños, Laguna
Computer Literacy: Microsoft Office (Excel, Access, Word and PowerPoint), Visual Basic Application, Turbo Basic, Fox Pro for DOS, System Application Product (SAP), Oracle, QlikView, Web Based Application, E-mail, Internet
Onlinejobs.ph "ID Proof" indicates if "they are who they say they are".
It DOES NOT indicate skill level.
ID Proof scores are 0 - 99 with 99 being the best. It is calculated based on dozens of data points.
It's intended to help employers know who they're talking to is real, and not a fake identity.