Jose Raymund Z. Apostol Jr.
Industrial Engineer
Quezon City
Summary
An Industrial Engineer working in the field of Business Intelligence & Data Analytics. Apart from process optimization, Jose Raymund Apostol specializes in developing user-centric solutions for data-driven decision-making.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Business Intelligence & Automations Manager
Emma – The Sleep Company
2 2024 - Current
- Product Claims: Developed Python web scraper to automate extraction of product defect images from customer service platform, eliminating manual extraction from ~400 tickets monthly
- Enabled company to file claims to suppliers and reclaim defective product costs
- (Python, Power BI)
- Overhaul of Last Mile Dashboards: Implemented a hybrid data sourcing strategy to update Last Mile Logistics Dashboards: data of established markets were sourced from data marts while data from emerging markets were sourced from data marts and Excel trackers
- Provided additional insights into Carrier Performance, Lead Times, and Order Distributions
- (SQL, Power BI)
- Data Integration of Emerging Markets: Consolidated and integrated Order Delivery Data from emerging markets into existing data marts, providing visibility and access to APAC data for other regions
- (Power BI)
- APAC Unit Cost Validation & Automation: Updated regional unit cost tracking logic and coordinated with global analytics engineering team to update their cost data marts
- Resulted in improved accuracy of APAC Costs reporting after validating correct implementation.
Junior Business Intelligence Manager
Emma – The Sleep Company
2023.02 - 2024.01
- APAC Operations Centralized Dashboard: Led APAC's multi-team data consolidation efforts and managed backend logic for KPI calculation
- Established Power BI dashboards as a one-source-of-truth for the region's operational performance across various teams: First Mile & Last Mile Logistics, Procurement, Customer Service, and Supply & Demand Planning
- Essential tasks included ideating KPIs, determining feasibility, and collaborating with stakeholders on logic development
- (Power BI)
- Regional Owner of APAC Metrics: Shared centralized dashboard with global teams to align and standardize KPI tracking and calculation methods across regions
- This triggered the start of APAC’s regional performance visibility.
- Procurement-Logistics Monitoring Files: Developed Power Query automations for processing data from Procurement PO Trackers and Logistics Container Trackers, eliminating manual file comparisons
- Tools were also designed to have outputs ready for direct distribution to business partners
- Overall, project resulted in weekly person-hour savings of at least 6 hours
- (Power Query)
- Pre-Sales Initiative Dashboard: Linked data from Order Management Systems and Customer Service Platform data marts to assess Pre-Sales initiative impact on customer average basket size and order value
- Dashboard revealed approximately 20% and 10% increases in metrics, respectively, aiding in the justification of Customer Service team projects to business partners
- (SQL, Power BI)
- APAC Inventory Report Automation: Created a Macro-based Excel tool to extract data from Financial Reports and produce monthly inventory reports
- This automation also enabled regionalization of calculations and metrics, removed dependencies on global teams, and offers on-demand usage
- (VBA)
- Planning Tool Dashboard: Converted horizontally stored, multi-column data into a vertically stored format for ingestion into Power BI
- Dashboard facilitated the Supply Planners' communication and visualization of weekly Ending Inventories, Incoming Replenishments, and Out-of-Stock Items to business partners
- (Power BI)
Technology Strategy & Transformation Analyst
Deloitte Consulting – Southeast Asia
2021.11 - 2022.12
- Reconciliation Tool Automation: Assigned to a leading Telecommunications provider in the Philippines to create Macro-based Excel tools which automated document ingestion and reconciliation for inventory management and cost tracking
- Multinational teams were assembled for each tool to handle development complexity
- Tools improved reconciliation rate by 300% and facilitated client's establishment of quality control processes for supplier documents
- (VBA)
- Testing & QA: Tasked with overseeing and facilitating end-to-end System Integration Tests (SITs) and User Acceptance Tests (UATs) as part of the project's testing team
- Collaborated with client's QA team to ensure testing standards and business requirements were met, and that deliverables were deployed punctually.
Education
Bachelor of Science in Industrial Engineering -
College of Engineering, University of The Philippines - Diliman
Quezon City, Philippines 2016.01 - 1 2021
undefined
Ateneo de Manila High School
2012.01 - 1 2016
Skills
Data Visualization (Power BI) & Transformation (Power Query)
SQL
Python
VBA Programming
Certification
Professional Scrum Master I (PSM I), Scrum.org, 2022
Professionalmemberships
Phi Kappa Phi Honor Society, Member
Languages
English
Bilingual or Proficient (C2)
Filipino
Bilingual or Proficient (C2)
Japanese
Advanced (C1)
Accomplishments
Award 1
Award 2
Award 3
Affiliations
Affiliation 1
Affiliation 2
Affiliation 3
Software
PowerBI
Power Query
SQL
Python
VBA Programming
Interests
Physical Fitness
Culture and Heritage
Boardgames
Timeline
Junior Business Intelligence Manager
Emma – The Sleep Company
2023.02 - 2024.01
Technology Strategy & Transformation Analyst
Deloitte Consulting – Southeast Asia
2021.11 - 2022.12
Bachelor of Science in Industrial Engineering -
College of Engineering, University of The Philippines - Diliman
2016.01 - 1 2021
undefined
Ateneo de Manila High School
2012.01 - 1 2016
Business Intelligence & Automations Manager
Emma – The Sleep Company
2 2024 - Current
Professional Scrum Master I (PSM I), Scrum.org, 2022
Similar Profiles
Krushna MundeKrushna Munde
Intern, Project Management Analyst at Emma The Sleep CompanyIntern, Project Management Analyst at Emma The Sleep Company
Sérgio SalazarSérgio Salazar
Junior Performance Marketing Manager at Emma The Sleep CompanyJunior Performance Marketing Manager at Emma The Sleep Company
Marco TrautmannMarco Trautmann
Director of Finance (interim) at EMMA Sleep GmbHDirector of Finance (interim) at EMMA Sleep GmbH