Marcus Oh
Dianella
Summary
Experienced Business Analyst and Data Specialist skilled in Excel, R, Power BI and SQL, with a proven track record in developing data models, visualizations, and dashboards. Adept at sourcing, validating, and analyzing large datasets to drive insights, enhance data quality, and solve complex problems.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Triage Lead / Business Analyst
VENTIA
09.2022 - Current
- Leading a team of 3 analysts to run multiple processes and brainstorm potential efficiency and cost saving improvements
- Developed KPIs and data models to drive cost-saving initiatives, utilizing SQL and Power BI to deliver accurate reporting and insights to senior management
- Built, updated, and maintained Power BI dashboards to track performance and identify improvement opportunities, resulting in an 83% increase in cost savings
- Built SQL queries to extract, clean, and manipulate data from multiple databases, automating reporting processes, reducing report generation
- Troubleshot and optimized Visual Basic Scripting (VBS) for automation of repetitive data tasks, reducing manual intervention and enhancing the efficiency of data processing workflows.
- Engaged with diverse stakeholders to understand reporting needs and deliver actionable insights
- Generated ad-hoc reports to evaluate specific business requirements.
Graduate Business Analyst
VENTIA
05.2022 - 09.2022
- Analyzed and provided data-driven solutions for Estate Upkeep and Operational Services for Defence
- Utilized SQL and VBA scripting to update and maintain contract documentation and reporting tools
Education
Masters of Predictive Analysis - Data Analysis
CURTIN UNIVERSITY
01.2021
Bachelor of Commerce - Economics
UNIVERSITY OF WESTERN AUSTRALIA
01.2018
Skills
- Data analysis
- Business intelligence tools (SQL, PowerBI, Python, R, Excel)
- Microsoft Office Suite
- Reporting and documentation
- Process optimization
- Business process improvement
- Predictive modelling (Linear Regression, Logistic Regression, Forecasting, Time series models)
- Attention to detail
- Analytical thinking
- Data visualization
- KPI tracking
- SAP
Languages
English
Chinese
Malay
Projects and Accomplishments
- Ventia achieved $5.3 million in savings through enhancements in reactive maintenance triage and bundling processes through team led processes in 2022.
- Spearheaded the development and execution of an improved OP&E process, resulting in enhanced coordination between operations, planning, and execution teams.
- Developed and maintained comprehensive Power BI dashboards for the Base Support Services Center, improving decision-making and performance tracking.
- Conducted advanced statistical analysis (VAR/VECM/GARCH) to examine the relationship between stock and crypto returns and Volatility (Submitted in partial fulfilment of the requirements for the degree of Masters of Applied Economics School of Accounting, Economics and Finance Curtin University)
Certification
- Career Essentials in Business Analysis by Microsoft and Linkedin Training - Present
- Agile Requirements Foundations - Present
Timeline
Triage Lead / Business Analyst
VENTIA
09.2022 - Current
Graduate Business Analyst
VENTIA
05.2022 - 09.2022
Bachelor of Commerce - Economics
UNIVERSITY OF WESTERN AUSTRALIA
- Career Essentials in Business Analysis by Microsoft and Linkedin Training - Present
- Agile Requirements Foundations - Present
Masters of Predictive Analysis - Data Analysis
CURTIN UNIVERSITY
Similar Profiles
Allan WheelerAllan Wheeler
Senior Project Engineer at VentiaSenior Project Engineer at Ventia
Khiarah WilkinsonKhiarah Wilkinson
Correctional Officer Training at VentiaCorrectional Officer Training at Ventia
Nisarg BrahmbhattNisarg Brahmbhatt
Site Engineer at VentiaSite Engineer at Ventia