I am a finance transformation professional with 15 years of experience across FP&A, budgeting, management reporting, reconciliation, audit readiness, finance operations, ERP transition, and stakeholder delivery.

My edge is the combination of senior finance judgment and hands-on systems execution. I translate messy business processes into structured workflows, data models, automation pipelines, dashboards, and governance-ready digital solutions.

I am building my career towards:

Finance Transformation Manager • Digital Finance Manager • Finance Systems Manager • FP&A Transformation Manager • Finance Automation Manager

• 15 years of finance, accounting, FP&A, reporting, audit, budgeting, and operations experience.
• Finance-side transformation across budgeting, reconciliation, reporting, ERP transition, and digital payment workflows.
• Experience supporting management reporting, board-level reporting, SGX reporting materials, and business-unit performance review.

• Python ETL, SQL Server, Power BI, workflow automation, dashboard-ready data design, and backend architecture.
• Ability to convert business requirements into process flows, data structures, validation rules, user stories, and working systems.
• Comfortable bridging finance users, IT teams, business owners, and management stakeholders.

• Focused on audit trail, approval discipline, role-based access, data validation, exception handling, and source-of-truth reporting.
• I do not only build dashboards — I help make the upstream numbers clean, traceable, and trusted.

• Languages: Python, SQL, Java, C#, JavaScript, HTML/CSS
• Data & Analytics: SQL Server, Power BI, ETL pipelines, data modelling, reconciliation logic, reporting automation
• AI / ML Exposure: Scikit-learn, predictive modelling, classification, AI-assisted process automation, structured AI output design
• Backend / Web: FastAPI exposure, Spring Boot, ASP.NET, React, Thymeleaf
• Delivery Tools: Git/GitHub, GitHub Actions, Docker exposure, Agile/Scrum, UAT, requirements gathering, process mapping

• FP&A and management reporting
• Budgeting and workforce planning
• Reconciliation and cashflow visibility
• ERP transition and finance systems
• Governance, audit readiness, and process controls
• Nonprofit, aviation, public-sector, SME, and service-operation finance environments

Finance workflow automation | Governance | Approval routing | SQL-ready backend

Problem:
Budgeting data collection is often fragmented across MS Forms, Excel files, emails, manual reminders, and ad-hoc WhatsApp messages. This creates rework, weak audit trail, unclear ownership, and unreliable dashboard inputs.

Solution:
Designed and built a WhatsApp-based HR budgeting workflow to guide requesters through structured budget capture, staff verification, OTP flow, role-based access, BU scope control, reviewer/HOD approval, HR Admin consolidation, and notification handling.

Business value:

• Replaces manual form chasing with a guided digital workflow.
• Improves data quality before reporting begins.
• Strengthens governance through requester → reviewer → approver → HR Admin consolidation.
• Creates dashboard-ready structured data and audit-ready records.

Keywords: Python, SQL Server-compatible repository design, WhatsApp workflow, OTP, approval routing, role-based access, clean architecture, audit trail.

Finance automation | Python ETL | SQL Server | Reconciliation intelligence

Problem:
Multi-channel bank reconciliation can consume heavy manual effort, especially when transactions require classification, remarking, matching, and finance review.

Solution:
Built an ML-enabled cashflow and reconciliation automation solution using Python ETL and SQL Server to ingest, classify, and auto-remark bank statement transactions.

Business value:

• Reduced manual reconciliation effort by approximately 96%.
• Improved near real-time visibility over cashflow and bank activity.
• Strengthened traceability for finance and IT users.
• Converted a manual reconciliation process into an automated, analytics-ready workflow.

Keywords: Python, SQL Server, ETL, reconciliation, classification, finance automation, cashflow monitoring.

Predictive analytics | Aviation finance | Revenue optimisation

Problem:
Passenger no-shows create seat spoilage, planning uncertainty, and revenue leakage in aviation.

Solution:
Developed a Python-based predictive analytics pipeline to identify likely passenger no-shows and support flight-level planning insights.

Business value:

• Supports revenue protection and operational planning.
• Demonstrates feature engineering, predictive modelling, and production-minded data pipeline design.
• Shows how finance and analytics can support pricing, yield, and capacity decisions.

Keywords: Python, machine learning, Scikit-learn, predictive analytics, aviation, revenue optimisation, data pipeline.

Management reporting | Python ETL | Reporting cycle improvement

Problem:
Manual reporting change requests can slow down group FP&A reporting cycles and reduce responsiveness to management needs.

Solution:
Designed Python-based ETL scripts to streamline reporting changes, data preparation, and consistency checks.

Business value:

• Reduced reporting turnaround from around 4 hours to under 20 minutes per change request.
• Improved speed, consistency, and reliability of management reporting support.
• Strengthened the link between finance analysis and automation delivery.

Keywords: FP&A, Python ETL, management reporting, variance analysis, reporting automation.

Full-stack system | Java Spring Boot | Admin workflow

Problem:
Business operations need structured product, checkout, inventory, and admin workflows instead of manual tracking.

Solution:
Built a full-stack system concept with secure checkout, product filtering, and admin dashboard logic for inventory and operational management.

Business value:

• Demonstrates enterprise application thinking beyond scripts.
• Shows ability to design end-to-end user flows, backend logic, and administrative controls.
• Relevant to finance systems, internal tools, and operational workflow platforms.

Keywords: Java, Spring Boot, Thymeleaf, SQL Server, backend architecture, admin dashboard.

My mission is to lead finance transformation initiatives that combine:

• Intelligent automation — replacing manual finance workflows with robust, controlled systems.
• Trusted data foundations — making finance numbers clean, traceable, and dashboard-ready.
• Business-value delivery — reducing rework, improving visibility, and strengthening governance.
• Finance + IT translation — helping business users and technical teams build the right solution together.

I am especially interested in roles where I can lead or support:

• Finance transformation roadmaps
• Budgeting and FP&A automation
• Finance systems enhancement
• Reporting and dashboard enablement
• Reconciliation and cashflow automation
• AI-assisted finance operations
• Governance-focused workflow design

• Graduate Diploma in Systems Analysis — National University of Singapore, Institute of Systems Science
• Bachelor of Commerce (Hons) in Accountancy
• Google AI Professional Certificate
• NTU Certificate in AI Ethics & Governance
• AWS Generative AI Foundation
• Google Data Analytics Professional Certificate
• Google Project Management Professional Certificate
• SCTP Associate Data Analyst
• ACCA Strategic Professional progress: SBL and SBR completed

• LinkedIn: linkedin.com/in/pangsianglian
• Email: angelpsl@ymail.com
• Portfolio: pangsianglian.github.io/pangsianglian-portfolio

“Dashboards show the numbers. Good systems make the numbers trustworthy.”