Faye Coronado
Business & Data Analyst

Faye
Coronado Turning Data Into Decisions

Industrial Engineer and Business Analyst delivering executive-grade analytics across Defence & Space, Oil & Gas, and Shipbuilding — specialising in SAP analytics, Power BI dashboards, and process optimisation.

View Projects Get In Touch Download CV
3+
Industries
60%
Manual Work Reduced
95%
Delivery Rate Achieved
14+
Certifications
SAP Analytics Power BI Dashboards Process Optimisation Supply Chain Analytics Lean Six Sigma Green Belt KPI Design & Reporting Defence & Space Oil & Gas Shipbuilding Dashboard Automation MBA Candidate SAP Analytics Power BI Dashboards Process Optimisation Supply Chain Analytics Lean Six Sigma Green Belt KPI Design & Reporting Defence & Space Oil & Gas Shipbuilding Dashboard Automation MBA Candidate
Who I Am

Industrial Engineer. Data Analyst. Strategist.

I am Faye — a Business and Data Analyst based in Cebu, Philippines, with a foundation in Industrial Engineering and a current Master of Business Analytics at Mapúa University. I transform messy operational data into decisions executives act on with confidence.

My track record spans three high-stakes industries: Defence and Space with duMonde International in Adelaide, Oil and Gas with Sigma Energy in Montreal, and Shipbuilding with Austal Philippines — each demanding precision, reliability, and clarity under pressure.

I build dashboards leadership trusts, automate reporting workflows that reclaim analyst hours, and surface data inconsistencies that silently erode accuracy. Currently expanding into AI-assisted analytics and business automation.

Defence & SpaceOil & GasShipbuilding Lean Six Sigma GBSAP Analytics MBA CandidateRemote-First
01
Executive Dashboards
Balanced Scorecards, KPI frameworks, and real-time operational reporting engineered for senior leadership and board-level review.
02
SAP Data Analytics
Deep expertise in MB51, ME2N, MB52 — extracting procurement and inventory intelligence from complex ERP environments.
03
Process Optimisation
Lean Six Sigma Green Belt methodology applied to procurement, supply chain, and reporting workflows to eliminate operational waste.
04
Automation & AI
Replacing manual reporting cycles with automated pipelines and exploring AI-driven analytics for next-generation operational intelligence.
Core Competencies

Technical Toolkit

A full-stack analytics skill set spanning data extraction, transformation, visualisation, and strategic reporting — built across three demanding industries over five years of hands-on delivery.

Analytics
Excel Advanced
Expert · VBA · Power Query · Pivot
Visualisation
Power BI
Advanced · DAX · Reports · Gateway
ERP
SAP Analytics
MB51 · ME2N · MB52 · ByDesign
Visualisation
Tableau
Dashboards · Stories · Server
Database
SQL
Queries · Joins · Data Extraction
ETL
Power Query
M Language · Transformation · ETL
Strategy
KPI Design
BSC · OKR · Performance Frameworks
Methodology
Lean Six Sigma
Green Belt · DMAIC · Kaizen
Operations
Supply Chain Analytics
Procurement · Inventory · Freight
Design
Dashboard Design
Executive · Operational · Mobile
Quality
Data Validation
Cleansing · Audit · Integrity
Emerging
AI Automation
Zapier · Make · n8n · Prompt Eng · HighLevel
Career Timeline

Where I Have Made An Impact

Business & Data Analyst
Sigma Energy Inc.  ·  Montreal, Canada (Remote)
Oil & GasContract
Jan 2026 – May 2026
  • Delivered end-to-end analytics for SAP procurement and inventory datasets (MB51, ME2N, MB52), supporting operational and financial decision-making at executive level.
  • Designed and implemented automated reporting workflows in Excel, Power BI, and Tableau — reducing manual processing time by over 60% across the full reporting cycle.
  • Identified and resolved large-scale data inconsistencies including duplicate records and missing cost centre classifications, significantly improving reporting accuracy.
  • Developed daily OPEX vs Project cost tracking models enabling per-rig, per-year cost visibility aligned to operational activity.
  • Explored AI-assisted data analysis approaches to further reduce manual reporting dependency in future cycles.
SAP MB51SAP ME2NSAP MB52 Power BITableauExcel VBAPower Query
Data Visualisation Research Analyst
duMonde International  ·  Adelaide, Australia (Remote)
Defence & SpaceContract
May 2025 – Mar 2026
  • Supported enterprise transformation by developing strategic frameworks including Balanced Scorecards, Three-Horizon Models, and Strategy-on-a-Page (SOAP).
  • Conducted data analysis and traceability mapping to align business initiatives with defence sector objectives within SSA enterprise programs.
  • Built executive-level dashboards and reporting tools to support senior leadership decision-making across strategic initiatives.
  • Contributed to workforce capability planning and continuous improvement programs across SSA enterprise initiatives.
Balanced Scorecard3-Horizon Model Power BITableauSharePoint
Procurement Transactional Officer
Austal Philippines  ·  Balamban, Cebu
ShipbuildingFull-time
Feb 2024 – May 2025
  • Developed real-time procurement dashboards within ERP systems, improving reporting turnaround time by 40%.
  • Analysed over 1,000 procurement transactions to identify bottlenecks, reducing process cycle time by 25%.
  • Cleansed duplicate supplier records and implemented validation checks, reducing reporting errors by 60%.
  • Enhanced freight monitoring and supplier tracking, improving on-time delivery from 70% to 95%.
IFS ERPExcel Advanced Power QuerySupplier Analytics
Featured Work

Analytics Projects & Dashboard Solutions

Each project represents a real business challenge solved through data — from SAP procurement intelligence to strategic defence reporting and automated pipeline design.

Oil & Gas
SAP Procurement Analytics
MB51 · ME2N · MB52
Connected
PO Value
$4.2M
+12.4%
Orders
1,847
+8.1%
Pending
63
Action
Auto Rate
94%
-60% manual
Monthly Spend (MB51)
PO Status
94%
Approved
Processed
Pending
SAPPower BIVBA
SAP Executive Procurement Dashboard
Problem
Fragmented SAP data across MB51, ME2N, MB52 required hours of manual extraction before any reporting could occur.
Solution
Automated consolidated dashboard unifying procurement and inventory data into a single executive view with scheduled refresh.
Manual processing reduced 60%  ·  Accuracy improved across all cost centres
SAPPower BIPower QueryExcel VBA
Shipbuilding
Supply Chain Performance
Supplier · Freight · Delivery
Live
On-Time
95%
from 70%
Cycle Time
-25%
Optimised
Transactions
1,247
Analysed
Error Rate
-60%
Cleansed
Delivery Rate Trend
95%Base 70%
Supplier OTD
SupplierOTD
Alpha Co98%+
Beta Ltd95%+
Gamma91%+
Delta Inc78%-
IFS ERPPower QueryExcel
Supply vs Usage Analytics Dashboard
Problem
On-time delivery at 70% and procurement bottlenecks invisible until they escalated into urgent operational issues.
Solution
Real-time ERP dashboard tracking supplier performance, freight status, and transaction patterns with automated bottleneck flags.
Delivery: 70% to 95%  ·  Cycle time reduced 25%
IFS ERPExcelPower Query
Defence
Strategic Balanced Scorecard
SSA Enterprise · 4 Perspectives
EXEC
Financial
87%
On Target
Customer
92%
Exceeding
Internal
79%
Progress
Learning
83%
Growing
3-Horizon Progress
H182%
H258%
H330%
Perspective Scores
BSC3-HorizonPower BI
Strategic Balanced Scorecard Reporting
Problem
Defence enterprise lacked a cohesive framework for aligning operational activity to strategic objectives with visual tracking.
Solution
Designed Balanced Scorecards and Three-Horizon Models integrating traceability mapping with visual strategy reporting for senior leadership.
Strategic alignment across SSA enterprise  ·  Board-ready reporting
Balanced ScorecardPower BITableau
Oil & Gas
OPEX Cost Tracking Model
Rig-Level · Daily · OPEX vs Project
Daily
OPEX YTD
$18.4M
vs $19M
Project
$6.1M
Under 3.2%
Burn/Day
$84K
Per rig
Variance
-2.3%
Favourable
OPEX vs Project Monthly
Rig Breakdown
RigDailyVar
Rig A$91K-4%
Rig B$78K+2%
Rig C$84K+1%
SAPExcel VBAPower BI
Daily OPEX Cost Tracking Model
Problem
Rig-level cost visibility was absent — teams could not distinguish OPEX from project spend or track daily patterns against budget.
Solution
Daily cost tracking models segmenting OPEX vs Project spend per rig per year with automated variance flagging.
Daily financial oversight per rig  ·  Aligned to operational activity
Excel VBAPower BISAP
Cross-Industry
Data Integrity & Audit
Cleansing · Validation · Quality Score
CLEAN
Cleaned
12.4K
Audited
Error Drop
-60%
Post-clean
Duplicates
847
Removed
Quality
96%
from 64%
Error Rate — Before vs After
Intervention-60%
Issue Types
Duplicates847
Missing CC392
Invalid156
ExcelPower QuerySQL
Data Integrity & Audit Framework
Problem
Reporting undermined by duplicate records, missing cost centre classifications, and inconsistent supplier data.
Solution
Systematic cleansing and validation framework with automated checks applied across thousands of records.
60% error reduction  ·  Quality: 64% to 96%
ExcelPower QuerySQLSAP
Automation
Automated Reporting Pipeline
Zero Manual Steps · Daily Scheduled
Auto
Time Saved
60%
Eliminated
Reports/Wk
24
Auto
Refresh
Daily
6 AM
Accuracy
99.2%
vs 94%
Manual vs Automated Hours/Week
Wk1
Wk2
Wk3
Wk4
Pipeline Status
ExtractAUTO
TransformAUTO
ValidateAUTO
DashboardAUTO
EmailSCHED.
VBAPower QueryPower BI
Automated Reporting Workflow System
Problem
Analysts spending 60% of their time manually compiling, cleaning, and formatting data for weekly and monthly reporting cycles.
Solution
End-to-end automated pipeline using VBA, Power Query, and Power BI with daily scheduled refresh and email distribution.
60% manual eliminated  ·  Analyst capacity redirected to insights
Excel VBAPower QueryPower BITableau
Credentials

Education & Certifications

Education

Master in Business Analytics

Mapua University  ·  2025 – 2026

In Progress

BS Industrial Engineering — Cum Laude

Cebu Technological University  ·  2020–2024  ·  Ranked 1st of 49

CTU Diploma
Recognition & Awards

1st Place — Systems Engineering Study

RECOD 2024  ·  Cebu Technological University

1st

2nd Place — DTI Fabsiklaban

Machine Learning Device Category

2nd

Most Promising Business Idea

TechnoExhibits 2024

Awarded

Research Adviser / Academic Mentor

Cebu Technological University — Guided IE students in analytics and applied systems design.

Data & Analytics

Certified Data Analytics Associate

Nievgen  ·  Feb 2023  ·  #20523012

CDAA

Certified Data Science Associate

Nievgen  ·  Feb 2023  ·  #21423003

CDSA

Certified Database Management Analyst

Nievgen  ·  Feb 2023  ·  #21223005

DBMA

Microsoft Excel: Data Analysis

Udemy  ·  Feb 2025  ·  UC-ffd1ad91

The Complete Financial Analyst Course 2025

Udemy  ·  Feb 2025  ·  UC-1925a344

Process Improvement & Quality

Certified Lean Six Sigma Green Belt

Nievgen  ·  Sep 2023  ·  #92723002

LSSGB

Certified Lean Six Sigma Yellow Belt

Nievgen  ·  Oct 2022  ·  #101422003

LSSYB

Certified Continuous Improvement Practitioner

Nievgen  ·  Jul 2023  ·  #073023010

CCIP

ISO 9001:2015 QMS Lead Auditor

Udemy  ·  Jan 2025  ·  UC-b338b452

Certified

Basic Occupational Safety & Health (BOSH) 40hr

J3 Trainers & Consultants  ·  Aug 2024  ·  #J3-24-101-28344

SAP Business ByDesign: Machine Learning Cockpit

SAP  ·  Jun 2023

SAP Business ByDesign: CRM

SAP  ·  Jun 2023  ·  OpenSAP

Certified

Certified Project Management Associate

Nievgen  ·  Feb 2023  ·  #21023016

CPMA

Doing Business in Defence Course

duMonde International  ·  Jun 2025

Verify Nievgen Certifications

All Nievgen certifications are publicly verifiable on the official registry. Click below to view the live verification record.

View Official Nievgen Registry →
Nievgen Verification
Click to expand verification record
Emerging Capability

AI & Automation Projects

Currently building AI-powered automation solutions as short-form projects since 2025 — combining workflow automation platforms, prompt engineering, and no-code AI tools to eliminate manual processes and accelerate business outcomes.

Current AI & Automation Toolkit Zapier Make.com n8n Prompt Engineering Process Mapping Claude Code HighLevel Lovable.dev
AI Automation
Workflow Automation Pipeline
Running
TRIGGER Zapier
PROCESS Make.com
TRANSFORM n8n
OUTPUT Notify
Runs Today
247
100% success
Time Saved
18h
This week
Steps Auto
12
Zero manual
Zapier Make.com n8n
Multi-Platform Workflow Automation
In Progress · 2025
Objective
Designing end-to-end workflow automation pipelines that connect business applications, eliminate manual handoffs, and trigger intelligent actions based on data events.
Approach
Building multi-step automations across Zapier, Make.com, and n8n — connecting CRMs, spreadsheets, dashboards, and communication tools into fully automated workflows.
Target: 80%+ reduction in manual task handling  ·  Zero-touch reporting pipelines
ZapierMake.comn8nProcess Mapping
AI Automation
AI Prompt Engineer · Claude Code
// System Prompt: Business Analyst Assistant
You are an expert business analyst specialising in
  SAP procurement data, KPI design, and executive
  reporting. Your outputs must be board-ready.
// User Prompt
Analyse the following MB51 export and generate
  a variance summary with recommended actions...
// Claude Response
Executive Summary: Cost variance of -$84K detected
  in Rig B OPEX. Root cause: supplier lead time +12d.
  Recommended: escalate to procurement lead...
Prompts Built
40+
Use Cases
12
Tool
Claude Code
Prompt Engineering for Business Analytics
In Progress · 2025
Objective
Engineering structured prompts that transform AI into a domain-specific business analyst — producing board-ready outputs, SAP data summaries, and KPI narratives on demand.
Approach
Using Claude Code to build reusable prompt frameworks for procurement analysis, variance reporting, and stakeholder communication — turning AI into an intelligent analytical assistant.
AI replaces 3–4 hours of manual report writing per cycle  ·  Consistent executive-grade output
Claude CodePrompt EngineeringProcess Mapping
AI Automation
HighLevel CRM Pipeline Active
New Lead
John S.
Oil & Gas Corp
Maria L.
Defence Ltd
2 leads
Nurture
Auto Email 3/5
AI-written
1 contact
Proposal
AI Deck Sent
Auto-generated
1 contact
Closed
Won ✓
Analytics Contract
1 deal
AI Automation Active Email · SMS · Tasks · Follow-ups → AUTO
HighLevel CRM & AI Sales Automation
In Progress · 2025
Objective
Building AI-powered CRM pipelines in HighLevel that automate lead nurturing, follow-up sequences, and proposal generation — reducing sales admin to near zero.
Approach
Mapping client acquisition workflows, then automating each stage: AI-written emails, SMS follow-ups, auto-task creation, and pipeline movement triggers based on contact behaviour.
Fully automated client nurture sequences  ·  AI-generated outreach copy at each stage
HighLevelZapierPrompt EngineeringProcess Mapping
AI Automation
AI App Builder — Lovable.dev v0.4.2
PROMPT
Build a portfolio site for a
Business Data Analyst with:
- Dark executive theme
- SAP project showcases
- Certificate modal viewer
- KPI counter animations
- Power BI style dashboards
Generating...
PREVIEW
FAYE CORONADO
Business & Data Analyst
SAP · Power BI · Tableau · Process Optimisation
Apps Built
3+
Deploy Time
< 1hr
No Code
100%
AI-Powered App & Portfolio Building
In Progress · 2025
Objective
Using AI-native builders like Lovable.dev to rapidly prototype and deploy professional web applications — from portfolios to client-facing analytics dashboards — in under an hour.
Approach
Translating business requirements into precise AI prompts, iterating on generated code, and deploying production-ready applications — bridging the gap between analytics expertise and technical delivery.
Full web apps deployed in <1hr  ·  Zero traditional coding required  ·  Client-ready outputs
Lovable.devClaude CodePrompt Engineering
Get In Touch

Ready to Discuss a Data or Analytics Requirement?

Whether you need a Business Analyst, BI consultant, or someone to architect your next executive dashboard — I would love to learn about your challenges and scope how I can deliver the right outcome.

Send an Email LinkedIn Profile Download CV
Location
Cebu, Philippines
Available for remote engagements globally
Email
fayerenadelecoronado@gmail.com
LinkedIn
linkedin.com/in/fayerenadelecoronado
Availability
Open to Remote Opportunities
Contract  ·  Full-time  ·  Consulting
Specialisations
SAP Analytics  ·  Power BI  ·  Tableau
Process Optimisation  ·  Supply Chain  ·  KPI Design
Certificate