| Name |
Dionysius Ong |
| Preferred Name |
Dion |
| Phone |
0403 509 565 |
| Email |
tiensung@gmail.com |
Problem Solving Data System Analyst with 5+ year experience in various industries. I help companies with data-related projects such as data migrations, creating reports and dashboards, process automation and system support.
Tertiary
1994-2004 Curtin University
Graduated: 2004
Double Degree:
Bachelor of Engineering (Communication and Electronic Engineering)
Bachelor of Science (Computer Science)
Contract Analyst Mar 2020 - Present
Data and Reporting Analyst May 2019 – Mar 2020
Key Achievements
- Converting an Operational Report that consisted of multiple spreadsheets into one Power BI report that is now being used at an Executive Level.
- Redesigned the Core Operational Power BI data model to be more aligned to the Star Schema.
- Created technical documentation (Process maps, ERD, Data Dictionary) that was used in a RFQ for a new CRM system.
- Providing a suite of Dynamics 365 reports for Contract Managers to monitor panel performance
- I minimised project costs by providing system support during the development of a new PowerApps Portal. The main sources of support included data migration, creation of PowerApps Views & Forms and modifying PowerApps Portal Pages using JavaScript & HTML.
- Reducing the time taken to produce 139 Local Government reports by 50% - 80% for other business units. This was achieved by reducing the number of steps through the use of Power Query and VBA.
Key Accountabilities
- Providing data analytics support within the team and organisation. This includes, but not limited to: data migration, data model optimisation, Power BI report creation, data integrity checks.
- Supporting External Stakeholders with Preferred Supplier Program issues.
- Delivering ad-hoc data analysis for various levels of management.
- Providing technical assistance in data-related projects and business processes within the organisation.
Reporting Analyst August 2018 - April 2019
Technical Analyst August 2017 - AUgust 2018
Key Achievements
- In a data mining project, I analysed over 100,000 patient visitation records uncovered over $50,000 worth of unclaimed expenses
- Saving the organization $25,000 by providing visualisation solution for the First Aid team instead of outsourcing the work.
- Reducing processing time of a key stored procedure from around an hour to about 15 minutes.
- Provided SSRS technical guidance to colleagues as part of a data migration project.
- I improved the organisation's knowledge of a vendor application's database through a data discovery process and documenting my findings within Confluence.
Key Accountabilities
- Providing data analysis to key internal stakeholders to enable decisions to be made.
- Providing Operational Reports to various levels of Management
- Liaising with stakeholders to support their standard data and reporting requirements
- Conversion of SAP Business Object Reports/Dashboards to SSRS Reports/Data
- Developing and maintaining SQL Stored Procedures to help with reporting requirements,improve business processes and automation
- Reviewing, analyzing and documenting key business processes and systems
- Documentation of reporting processes
Systems Analyst (Gaming Systems) July 2016 - August 2017
Key Achievements
- Within the first 3 months as a Gaming Analyst, I impressed a Floor Manager with a data report using Progress DB in a timely manner.
- Provided system support and assisted in client engagement during the launch of the Crown Rewards program.
- I led a regression user acceptance testing process. The duties included, but not limited to, setting up a kick off meeting, liaising with testers within each business units when issues occur and retrieving acceptance sign off.
Key Accountabilities
- Providing Gaming System Support, which includes Disaster Recovery Testing.
- Resolving Support Tickets in a timely manner
- Writing and Reviewing documentation for other departments dealing with Gaming Systems applications
- Actively testing system enhancements through test scripts that were provided.
- Actively engaging the stakeholders to gather requirements for future improvements.
- Implementing System Upgrades for Gaming Applications through a change management process.
- Actively participating in team sprints
- Extracting and presenting data for ad-hoc data requests.