Maria Ofelia Aguanta

Category Merchandise Manager with 11 years’ experience in both retail and manufacturing industry inclusive of 7 years’ experience in merchandising and 4 years’ supply planning. Was also a part time Industrial Engineering instructor at the University of Cebu Main Campus handling research and project feasibility studies and was awarded as the “Best Teacher of the Year 2015”. Proficient in making various reports in MS Excel and other MS applications and using systems (SAP, JDA, Factory Planning, Oracle Retail Merchandising System, ARC Retail Performance Management (BI-Business Intelligence) and Retail Ideas 5.1, Aggregate Supply Planning Tool and Logility)

Cebu Atlantic Hardware, Inc.                                                                                    Aug 2021-present

80 B Aranas St., San Nicolas, Cebu City

Merchandising Department

Category Merchandise Manager

Primary Responsibilities:

• Responsible in the overall strategy of planning, ordering and selling of merchandise under assigned categories (Hardware & Industrial Tools & Equipment) to drive sales and achieve targets

• Review and monitor category assortment performance and implement action plans for improvement

• Effectively & efficiently manage buyers, merchandising coordinators and admin staff to better contribute to a category performance success

• Organize and maintain ideal inventory levels of stores and warehouses

Achievements:

• Developed a retail repacking monitoring and production quota plan for child SKUs

• Established a Business/Vendor Review template to review a supplier’s performance

• Made a standard Supplier Term Agreement, Vendor Application Form and Product Registration form

• Created a Marketing and Promotions One-Pager as prerequisite for any marketing initiative in-line with merchandising initiatives

• Created an OTB (Open-to-buy) template and Product Supply template as basis for budgeting and ordering

Accenture Inc.                                                                                                              Dec 2020- Aug 2021

Cebu e-block 3, IT Park Lahug Cebu City

Technical Services Department

Technical Support Analyst

Primary Responsibilities:

• Responsible for SAP & other systems (Arriba,etc) related processes and systems technical issues and problems by clients all over the globe

• Solve client’s technical issues related to their accounts & other concerns to support them in their daily task

English Central                                                                                                              July 2020-March 2021

Homebased Part-time ESL Online Teacher

Teach professional adults mostly from North and West Asia basic and business English

Rell & Renn Trading Corporation (Ultramart)                                                         Mar 2019-July 25, 2020

Jesa ITC Bldg, Mango Avenue,Cebu City

Merchandising Department

Category Planner Specialist for Pharma & Food to Go

Primary Responsibilities:

• Responsible in daily/weekly/monthly submission of performance, or as needed for the monitoring of sales, inventory and purchases per category assigned

• Responsible in coming up with an order plan of assigned category (Pharmaceuticals/Consumer/Food-to-Go) monthly, or as needed for replenishment of merchandise

• Responsible for Store-from-Warehouse and Store-to-Store Allocation of merchandise with the right quantity based on skewing and store demands

Achievements:

• Created PSP kits MS Excel template for Food to Go items with BOM as the new basis of ordering for FTG category

51Talk                                                                                                                          Oct 2018-Dec 2019

Homebased Part-time ESL Online Teacher

Teach Chinese kids aged 0-13 years old, Basic & Intermediate English to better hone their English-speaking skills.

TMX (Timex) Phils, Inc.                                                                                            Mar 2017-Aug 10, 2018

MEPZ 1, Lapu-lapu City

Supply Chain Department

Aggregate Supply Planner

Primary Responsibilities:

• Generates Monthly and Weekly aggregate plan for the factory for assigned set of Complete Watch Styles. Carries out rough cut capacity plan. Provides weekly demand and supply analyses thru the DEMAND & SUPPLY (DNS) Report in response to the business revenue plan.

• Incorporate pull orders in aggregate plan according to previously established business rules considering frozen horizon and lead times. Plan, schedule (work order), coordinate and monitor projected delivery dates based on factory promise dates.

• Create build plans for future promotions, product launches and end of life runs and input detailed information into Logility DRP system and Logility Aggregate planning tool. Ensures inclusion of demand changes in the plan thru uplift/simulation requests.

Achievements:

• Created a user manual for the new Demand and Supply Report Process using the new system (Logility). • Developed a Performance Evaluation tracker that is the basis for the yearly Performance Evaluation Review among Aggregate Planners.

TMX (Timex) Phils, Inc.                                                                                                Feb 2016- Mar 2017

MEPZ 1, Lapu-lapu City

Supply Chain Department

Master Production Scheduler

Primary Responsibilities:

• Responsible in releasing capacity plan and job scheduling of listed commodity’s plan in daily/weekly/monthly or as needed basis to ensure availability of finished items in accordance to customer’s need and on-time delivery yet respecting processing lead-time, material availability and production line’s installed capacity. With key responsibilies such as: 1) production planning & scheduling 2)work order releasing 3)inventory management and 4)process improvement and project support.

Achievements:

• Conducted a Quickwin Project to save on cost of manufacturing men’s watch using crown alternates.

• Created a consolidated monitoring Excel sheet template to expedite gating watch components.

Metro Retail Stores Group, Inc.                                                                              Feb 2015-Feb 2016

Mandaue City, Cebu, Phils.

Merchandise Planning and Control Department

Head Merchandise Planner

Primary Responsibilities:

• Responsible for supervising merchandise planners in their daily, weekly, monthly and yearly deliverables handling Miscellaneous division which is composed of Toys, Stationery, Houseware,Fabrics, Home Décor, Travel Gear and Linen departments.

• Executes category specific planning calendars by driving key stake holder accountability for achieving deadlines; presenting in plan review meetings; evaluating and discussing historical performance in category talk-out meetings: and providing clear item plans for line reviews.

Achievements:

• Spearhead the Space Productivity Report for all departments and all stores

• Member of the board to conduct MS Excel Advance training

Metro Retail Stores Group, Inc.                                                                              May 2012-Feb 2015

Mandaue City, Cebu, Phils.

Merchandise Planning and Control Department

Merchandise Planner

Primary Responsibilities:

• Responsible for ensuring optimum balance of the key merchandise planning elements (sales, inventory levels, purchases and reductions) that would deliver the maximum return on investments in the assigned merchandise division(s).

• Manages in-season performance by producing and communicating sell-through, item indexing, identifying and addressing liability issues; evaluating markdown impacts to category profitability; and developing plans for high-risk merchandise.

Achievements:

• Training facilitator/speaker for the Basic MS Word and Basic MS Excel workshop.

• Represents team in various company activities.

University of Cebu- Main Campus                                                                                    SY 2013-2015

College of Allied Engineering

Sanciangko St., Cebu City

Part-time College Industrial Engineering Instructor

Primary Responsibilities:

• Works under College of Allied Engineering, Industrial Engineering department handling major subjects such as Human Factors Engineering/ Ergonomics (3.0 units), Industrial Cost Accounting (3.0 units), Operations Research 1 (3.0 units), Marketing (3.0 units) and Project Feasibility Study (3.0 units).

Achievements:

• Received Award from the Student Council body as “Best Teacher of the Year 2015” among engineering teachers.

• Chosen to represent the IE in the Research Congress (Four research studies of Students presented during the National PIIE Research Congress.

Tertiary: SY 2007-2012

University of San Jose-Recoletos, Cebu City

Magallanes St., Cebu City

B.S. Industrial Engineering

GPA: 1.46

Cum Laude

Secondary: SY 2003-2007

University of San Jose-Recoletos (Girls’ High School)

Basak, Pardo, Cebu City

With Honors 3

Primary: SY 1999-2003

Pardo Elementary School

Pob. Pardo, Cebu City

9th Honorable Mention