Nigel Boyer Oyog

Experience

• 

  Hyundai Asia Resources, Inc. (HARI)

  Mar 2018 - Mar 2021

  As a Sales Training Officer, I conducted both technical and soft skills training programs to employees of the company's nationwide network of dealerships. Being a Product Knowledge Expert as part of the role, I assisted Dealer Sales Trainers and Sales Consultants in all inquiries and training needs.Highlights:• Conducted 44 of Hyundai’s Training Programs to 436 Sales Consultants• Conducted specialized training programs for Dealer Principals and Dealer-based Sales Trainers• Monitored Dealer-based Sales Trainers’ performance in conducting non-core training programs to Sales Consultants Show less As part of the Product Development Team, I conducted in-depth research on automotive industry trends, emerging technologies, and market preference, integrating insights into product development strategies and marketing initiatives.Highlights:• Spearheaded the development of the company’s first mini-bus prototype specialized for the local market• Analyzed product value of company vehicles through specification comparison to competitor brands• Conducted product enhancements from conceptualization to market introduction Show less

  • Sales Training Officer

    May 2019 - Mar 2021

  • Product Development Senior Staff Assistant

    Mar 2018 - May 2019
• 

  Petron Corporation

  Mar 2021 - Aug 2024

  As the Fleet Safety Analyst, I developed Power BI dashboards to track and monitor a fleet of approximately 1,050 company trucks, ensuring compliance with maintenance standards and government regulations, and identifying factors that affected delivery fulfillment and turnaround times. Also, I supported Fleet Services Group Managers in stakeholder meetings by analyzing data and developing visually compelling presentations.Highlights:• Reduced report creation time from one week to three minutes through automated consolidation of a month of daily tank withdrawals into a single report using a VBA Macro program• Validated 114 GPS logs of truck deliveries, facilitating the recovery of a substantial debt from the third-party hauling service Show less As an Operations Planning Engineer (similarly "Business Analyst"), I managed the Operations Department Power BI dashboard, monitoring key business performance indicators, delivery fulfillment, department expenditures, project completion status, and other critical metrics. In addition, I supported the Operations Planning Group Manager by assisting in feasibility studies of long-term business projects by leveraging data analysis and drawing business insights from Power BI dashboards, as well as acting as the data steward for operational metrics, tracking business expenses, project completion statuses, and reporting compliance across various work groups.Additionally, I supported colleagues and stakeholders using data analysis and BI solutions, tackling critical business challenges. I also developed comprehensive documentation for the Power BI dashboard, outlining report objectives, data sources, modifications, and troubleshooting steps to support continuous improvement.Highlights:• Optimized 13 Power BI dashboards among a total of 39 managed, contributing to enhanced data visualization and more informed decision-making• Developed and implemented four new Power BI dashboards, translating business needs into visually compelling reports• Ensured high data quality and accuracy by utilizing SQL-based data pipelines for data cleaning, implementing data checkpoints, and cross-verifying reflected data against expected results• Reduced file creation time from 1.5 months to 1.5 hours by creating a VBA Macro program that consolidated expenses and budget allocations for 187 cost centers into 63 Excel files Show less As a Fleet Systems Analyst, I collaborated on cross-functional projects that optimized systems and processes to increase employee efficiency and effectiveness. Furthermore, I conducted training sessions to onboard colleagues and stakeholders on system modifications and developed systems and projects. Additionally, I supported Fleet Services Group Managers in stakeholder meetings by providing status updates on system improvement projects.Highlights:• Developed the company’s first delivery fulfillment Power BI dashboard• Developed automated solutions and effective data processing and analysis by learning Visual Basic and Power Query through self-study and practical application• Reduced report creation time from 30 minutes to six minutes by automating the consolidation and analysis of customer sell-out and inventory data using VBA Macro programs Show less As a Fleet Planning Programmer (similarly "Demand Planner"), I monitored the sales performance and inventory levels of the company's nationwide network of approximately 1,600 service stations and scheduled fuel replenishment deliveries in SAP, with consideration of different factors such as freight cost, delivery route, customer satisfaction, customer payment, among others. I coordinated with Sales Representatives and Operations Department Personnel nationwide to fulfill daily delivery schedules, resolving operational challenges and ensuring complete delivery fulfillment. One of my key achievements as a Fleet Planning Programmer was when I reduced the average run-out rate for customers in my assigned area by 78% through careful delivery planning by analyzing product inventories, sales performance, and order behavior. Show less

  • Fleet Safety Analyst

    Apr 2024 - Aug 2024

  • Operations Planning Engineer

    Nov 2023 - Mar 2024

  • Fleet Systems Analyst

    Dec 2022 - Nov 2023

  • Fleet Planning Programmer

    Mar 2021 - Dec 2022