Data Analyst

Arnold Ocampo Jr.

Current Address: ***B I Lindayag St., Brgy Pineda, Pasig City

Permanent Address: Blk 14-707 Sto. Domingo St, Brgy. San Isidro, Mariveles, Bataan

Contact Number: 091*-***-****

Email Address: *****.********@*****.***

OBJECTIVE

Results driven individual currently in operations role and seeking a full-time data analyst position to leverage my expertise and passion in turning large datasets into insights. I have more than 5 years of experience in supply chain industry as a planner and analyst using MS excel on our daily activity.

SKILLS

Strong attention to details and organizational skill.

Technical and logical thinker.

Advance MS Excel user. (Vba-Macro, PowerQuery, Pivot Tables)

Able to handle large datasets and provide technical analysis. Templates and dashboard creation

5 yrs SAP-MM hands-on experience

Experience on relational database management & BI (PowerQuery, PowerBI)

SQL knowledgeable,

JOB EXPERIENCES

San Miguel Food Inc (May 2019 - Current)

100 Eulogio Rodriguez Jr. Ave., Brgy. Ugong, Pasig City

Demand Planner

●Responsible for balanced distribution of supply nationwide to support the demand based on sales rolling forecast.

●Maintain a constant relationship with the sales, marketing, finance, procurement to understand the demand forecasting drivers.

●Improve forecast accuracy with coordination actions and updates from supply planner and sales department.

●Ensures the target inventory stock level on external warehouses.

●Coordinating with procurement by providing the order volume whenever there’s a need on importation and to monitor the arrival on external warehouses.

●Planning of stock transfer based on monthly requirements. (Luzon to VisMin or Mindanao to Luzon)

Systems/Data Analyst

●Design and automate excel templates (using macro or complex formulas) to provide efficiency on daily activities.

●Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis.

●Devices effective data generation (actual data from SAP to Excel Templates) and presentation tools that will provide information on FG inventory, plant utilization and other relevant information in inter-department meetings and will serve as basis in the decision-making process during S&OP Demand and Supply Review Meetings.

●Collaborates with SAP Team to address discrepancies on the system.

National Book Store Head Office (Jan 2016 – May 2019)

Quad Alpha Centrum Bldg. 125 Pioneer St. Mandaluyong City

Supply and Demand Planner

●Prepares forecast and provide suggested order quantity considering factors such as historical sales, budget, target, minimum order quantity, size of the store, vendor delivery point, lead time.

●Assist on store concerns and everyday processing of PR (Purchase request) to ensure availability of stocks through STO/PO creation.

●Regular monitoring and creation of RPO for slow & nonmoving articles.

●Monitors and ensuring optimal inventory level.

●Monthly cleansing of created PO and STO.

●Suggest for store-to-store stock transfer for the excess inventory based on the desired sales to stock ratio (SSR) to lessen/deplete inventory, cost reduction and to improve cash flow.

Sales & Operations Analyst

●Collates and process large data (overall business inventory, overall sales, purchase orders, return orders, etc.) and generate deeper business insights.

●Involved in discussions and collecting data requirements in preparation for test script and test scenarios for User Acceptance Training (UAT) and provide Go Live and Post Live Support.

●Analyze and suggests action plans involving system discrepancies, overstock items, phased out items, non-moving articles.

●Ensures the alignment of all departments to deliver short to long term business goals through conducting weekly S&OP meetings.

Others

●Conducting Basic to Intermediate Excel Trainings on other departments.

American Home Appliances

San Francisco Del Monte, Quezon City

Field Auditor (Logistics) / Internal Audit

●Validates DR before loading and delivery.

●Checking of incoming shipments abroad before storing inside the warehouse

●Documenting the standard procedure on warehouse/logistics operations

●Ensuring that the standard process on warehouse/logistics is properly executed.

●Checking of time keep / payroll records of employees under agencies.

Mountaineering Instruments Corporation

AFAB, Mariveles, Bataan

Production IE

●Operations Breakdown

●Conduct Time and Motion Study

●Production Planning and Control

●Production Layout

●Troubleshooting delays and bottleneck around the production area

EDUCATIONAL ATTAINMENT

Bachelor of Science in Industrial Engineering

Polytechnic University of the Philippines

Bataan Campus

AFAB Mariveles, Bataan

CHARACTER REFERENCE

Emy A. Capila

Accenture Inc.

Business and Integration Arch Senior Analyst

Contact No. 091*-***-****

Angelo Buday

Transec BPO Solutions

Data Specialist

Contact No. 092*-***-****

I hereby certify that the above information is true and correct to the best of my knowledge.

ARNOLD T. OCAMPO JR.

Contact this candidate