Case Studies
In-depth case studies showcasing my approach to solving complex business challenges through data-driven strategies, operational excellence, and user-centered design. Each case study highlights the specific problems addressed, methodologies employed, and measurable impacts achieved.
Quick Navigation
Enterprise HRIS Governance & Audit Support
Role: HR Technology Intern reporting to SM HR (Shared Services & Technology)
Executive Summary
Supporting enterprise HRIS governance across SIA Group entities. Auditing SAP SuccessFactors role-based permissions, processing GRC access change requests, and maintaining Kronos workforce management system integrity across multi-entity aviation organization.
The Challenge
Large aviation MRO organization with multiple subsidiaries required rigorous HRIS governance to maintain SOX compliance and audit readiness. Role-based access controls needed systematic review across SAP SuccessFactors Employee Central Payroll, with GRC change requests requiring documentation and approval workflows.
What I Did
- Audited 100+ SAP ECP and SF roles, documenting permission structures and identifying access control gaps
- Processed 11 GRC change requests with proper documentation and approval workflows
- Maintained Kronos workforce management system across multiple business entities
- Supported production access management across SIA Group HRIS infrastructure
Business Impact
Contributed to enterprise HRIS governance framework supporting SOX compliance and audit readiness across SIA Group entities.
Skills Demonstrated
SAP SuccessFactors • SAP GRC • Kronos • HRIS Governance • Role-Based Access Control • Enterprise Systems • Audit Support • Multi-Entity Operations
Digital Transformation
Role: Sole Business Analyst reporting to CEO
Executive Summary
Health-tech startup lacked data infrastructure across 30K+ user health assessment records in 15 countries. Built analytics capability from scratch-creating SQL Server views, Python automation, and branded Power BI dashboards-enabling executive reporting where none existed.
The Challenge
Health-tech startup with 30,000+ user health assessment records across 15 countries lacked structured data infrastructure. No way to track user behavior, measure product engagement, or inform strategic decisions. Leadership needed actionable insights to guide product roadmap and identify growth opportunities.
What I Did
- Created 4 SQL Server views with JSON parsing (OPENJSON) and 1 custom function to transform raw assessment data into queryable analytics tables, enabling organization's first cross-functional analytics capability
- Built Power BI dashboards with DAX calculations tracking user engagement, stress/anxiety/sleep patterns, and product adoption metrics; enabled executive reporting where none existed
- Automated data processing using Python (pandas, NumPy) for JSON extraction, device parsing, and data merging; improved data quality by filtering bot traffic and test records
- Designed brand-compliant visual guidelines for all BI dashboards, standardizing design language (typography, color system, chart specifications) for future development
Business Impact
Built analytics infrastructure where none existed, enabling executive decision-making across product and marketing teams. Dashboards and data views became foundation for ongoing organizational analytics capability.
Skills Demonstrated
SQL Server (T-SQL, OPENJSON) • Python (pandas, NumPy) • Power BI (DAX) • JSON Parsing • Brand Guidelines • Data Quality • Stakeholder Management • Executive Reporting
Operational Turnaround: Rebuilding & Scaling an Organization
Role: Co-Founder & Executive Director
Executive Summary
Education nonprofit faced existential crisis after co-founder departure with no documented processes. Executed organizational turnaround, scaling to 30 team members across 8 departments, serving 200+ students through academic consulting and hosting events reaching 1,500+ attendees.
Business Challenge
Founded education nonprofit that grew to 15 team members but faced existential crisis when co-founder departed. No documented processes, unclear roles, risk of losing all institutional knowledge. Needed to stabilize operations while continuing to serve students and scale impact.
Approach
- Executed organizational turnaround after co-founder departure: documented operational processes across team protocols, volunteer handbook, and job descriptions; rebuilt leadership team with zero leadership attrition post-transition
- Managed P&L, fundraising, and strategic partnerships including Startup Weekend Yangon, Dinger, and Chat Studio; established governance framework with weekly operations reviews and quarterly board reporting
- Redesigned organizational structure across 8 departments with clear role definitions, reporting lines, and accountability metrics
- Reduced volunteer onboarding time through process standardization and systematized training protocols
- Secured legal registration (DICA) and formal incorporation as Company Limited by Guarantee
Business Impact
Created scalable operating model enabling 100% organizational growth while maintaining quality. Achieved zero leadership attrition post-transition. Organization continues operating successfully with formalized governance and quarterly board reporting.
Skills Demonstrated
P&L Management • Process Design • Change Management • Organizational Design • Stakeholder Management • Cross-functional Team Leadership • Governance Frameworks • Operations Strategy
Admissions Analysis and Campus Planning
Role: Student Analyst reporting to Campus Chancellor
Executive Summary
University leadership needed data-driven insights to inform recruitment strategy during COVID-disrupted enrollment cycles. Consolidated 4 years of enrollment data and informed admissions strategy adopted for ongoing initiatives.
The Challenge
University leadership needed data-driven insights to optimize recruitment strategy during COVID-disrupted enrollment. Required analysis of enrollment trends, virtual event effectiveness, applicant behavior, and competitive positioning among Singapore private education institutions.
What I Did
- Led admissions data analysis spanning 4 years (2017-2021) and 212 survey responses; cleaned, consolidated, and analyzed applicant behavior trends to identify conversion drop-off points
- Built interactive Tableau and Excel dashboards tracking admission funnels, virtual event effectiveness, and demographic patterns; designed for ongoing use by Enrollment team after departure
- Conducted competitive benchmarking of Singapore private education institutions comparing fee structures, program offerings, and student outcomes
- Synthesized qualitative student focus group research into recommendations for the ERAU Asia 2030 campus planning initiative
- Presented findings to Enrollment & Campus Operations team with actionable recommendations
Business Impact
Analysis informed recruitment strategy and student services improvements during COVID-disrupted enrollment cycles. Dashboards and analytical framework were adopted for ongoing use by the Enrollment team.
Skills Demonstrated
R Programming • Tableau • Excel (VLOOKUP, INDEX-MATCH, Pivot Tables) • Competitive Benchmarking • Qualitative Analysis • Statistical Analysis • Strategic Analysis • Executive Communication
Supply Chain Optimization
Role: Supply Chain Analyst (Capstone Project)
Executive Summary
Airline's centralized inventory system created unnecessary part transfers across 7 maintenance stations. Analyzed 500K+ records to identify 40% operational waste and built forecasting models achieving 92% prediction accuracy for distribution optimization.
The Challenge
Airline's centralized inventory system was generating unnecessary part transfers between 7 maintenance stations. Parts routed through headquarters instead of direct station-to-station transfers created delays and inefficiencies. No data-driven allocation strategy existed.
What I Did
- Analyzed 500,000+ inventory records for 6 critical aircraft components (brake assemblies, hydraulic pumps, flight control computers) across 7 maintenance stations
- Built Distribution Requirements Planning model identifying 40% operational inefficiency in centralized distribution system caused by hub-routing instead of direct station transfers
- Developed forecasting models using regression and time-series analysis achieving 92% prediction accuracy
- Developed business case comparing centralized vs. decentralized distribution strategies with cost-benefit analysis
- Presented optimization business case to Material Planning team with recommendations and projected financial impact
Business Impact
Proposed distribution optimization strategy to reduce unnecessary transfers and improve parts availability. Quantified cost reduction opportunity and presented business case to Material Planning team.
Skills Demonstrated
Supply Chain Analytics • Excel Modeling • DRP • Regression Analysis • Time-Series Forecasting • Process Optimization • Cost-Benefit Analysis • Aviation Operations