Dion O. Email & Phone Number

Perth, Wa, Au

current projectcreating the medallion architecture using Microsoft fabricingesting data using data pipelines and notebooks from various data sources such as APIs and data verse

Continuation of the Contract Analyst role but in new team

West Leederville, Western Australia, Australia

Other Roles: Business Analyst, Data Modeller, Data Analyst, Reporting Analyst, Procurement Analyst, Technical Business Analyst, System AnalystKey Accomplishments- For a Dynamics CRM RFQ, I created technical documentation such process maps, a Database ERD, Use Case Diagrams, Function Specifications and Data Dictionary. - Automating a process to create the Preferred Supplier Program's Annual Report for each Local Government in timely manner. The data extraction involved SQL, Power Query and Excel. The design of the report was done in macro-enabled Word and PowerPoint files, which was later turned into a PDF file.- I minimised project costs by providing system administration support during the development of a new PowerApps Portal. - I reduced the time take to produce external reports for other business units within the organisation by 50%-80%. This was achieved through optimisation by automating the process.- Converting a Operational Report that consisted of multiple spreadsheets into one Power BI report that is now being used at an Executive Level.

Belmont, Western Australia, Australia

Position Performed: SQL Developer, Data Analyst, Business Intelligence DeveloperKey Accomplishments- In a data mining project, I provided data extracts that uncovered additional profits in excess of $50,000- Provided SSRS technical guidance to colleagues as part of a data transition from Business Objects to SSRS. - I improved the organisation's knowledge of a vendor application's database through a data discovery process and documenting my findings within Confluence.

Belmont, Western Australia, Australia

Other Positions Performed: Application Support Analyst, SQL Developer, System Support Analyst, Business Intelligence Developer, SAP Business Objects AdministratorKey Accomplishments- Saving the organization $25,000 by creating a Call Centre Performance dashboard instead of outsourcing the work - Reduced processing time of a key stored procedure from around an hour to about 10 minutes.

Perth, Australia

Other Positions Performed: Application Support Analyst, Functional Analyst, SQL Developer, System Support Analyst.As a system analyst, I played an important role in ensuring customer expectations are exceeded and complying with government legislation. This is done through supporting the applications the client facing staff are using. These applications include casino based applications, patron management system and in-house applications.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.

Perth, Australia

As a System Specialist, my key task was to provide system support to our two key document management systems.Key Achievements- After a three hour crash course with a senior colleague in using SSRS, I was able to expand my knowledge through self learning to become a SME for SSRS Reporting in the APAC region.- Created a suite of standard SSRS reports that was used with each implementation of small to medium projects.- Developed a custom application that improved document management processes.- Provided data-related system support to an international project. This included, but not limited to, data cleansing, creating SSRS reports to show status of the project and staff training.

DB Engineers is a 4D Software house that creates tailor made software solutions for it clients in various industries and sectors. In this role, whilst learning the 4D Language, I was assisting the lead developer create and maintaining web interface modules. In particular, I was integrating a third party AJAX scheduling control into a web page module.Key Accountabilities• Maintain and Support Enterprise Software• Providing Clients with Solutions• Participation in Requirement meetings for and with Clients• Implementation of Third party software plug ins• Researching on usage of third party software plug insKey Outcomes• Acquired Knowledge of 4D Language• Acquired Knowledge of JQueryLanguages Used: 4D, HTML, CSS, JavascriptAPI Used: JQueryDatabase Application: 4DKey Software Used: Mac OS

Creative On-Line Technologies is a start up company that is developing a new product for the banking industry that improves transaction security. In this role, I was assisting the managing director in the reviewing and testing of possible technologies that were suitable for the product. Key Accountabilities• Reviewing Infrastructure methods• Providing recommendations from product testing• Maintenance and implementation of company website• Provide analysis of vendor products• Providing administrative supportKey Outcomes• Product knowledge of the Infra-red systems• Product knowledge of finger scanners• Attended Vendor FunctionsLanguages Used: HTML, CSS, JavascriptKey Software Used: JDeveloper

West Leederville, Perth, Australia

Tim Technologies provides a software solution to monitoring phone usage. In this role, I was assisting the lead developer in adding functionality to the product. While engaging with the lead developer, I developed and implemented various modules to the existing product.Key Accountabilities• Maintenance and implementation of “in-house” software projects• Trouble-shooting client problems• Adhering to the specifications given• Research and analysis of vendor productsKey Outcomes• C# Design and development using Visual Studio .NET 2005• Database design for SQL Server 2000 and 2005• OO Methodologies• Exposure to Linux Technologies• Client InteractionLanguages Used: C#Database Application: SQL ServerKey Software Used: Visual StudioExposure: Linux

Perth, Australia

Bluegem is a Microsoft Development House which specialises in the learning and training industry. In my role, I was participated in the all phases of the software development life cycle.Key Accountabilities• Acquiring information to write scope of work requirements• Creating technical reports development plans and specifications• Implementing and maintaining client websites (in ASP.NET. 1.1 and 2.0)• Participation in review of functional specifications and vendor tests• Participation in peer training sessions• Design and Implementation of web and smart device projects• Adhering to the specifications given.• Development of Windows Mobile and Symbian mobile device applications• Providing client training of company products• Providing .NET web and mobile solutions for clients• Upgrading and maintaining current company products.Key Outcomes • N-Tier Software and database modelling in UML and ERD• C# design and development using Visual Studio .NET 2003 and 2005• Software design and development in ASP.NET 1.1 and 2.0 Frameworks• .NET XML Web Services• Database design for SQL Server 2000 and 2005• Microsoft Solutions Framework software development life cycle methodology• Develop modules and integrated applications for DotNetNuke CMS• Web technologies including: PHP, Javascript, HTML, XML, CSS• Windows Mobile and Symbian OS programming• OO Methodologies • Graphical User Interface and Skin design • Exposure to TAPILanguages Used: C#, ASP, PHP, Javascript, HTML, XML, CSS, Windows Mobile and Symbian OS ProgrammingAPI Used: JQuery, .NET XML Web ServicesDatabase Application: SQL ServerKey Software Used: Visual Studio, DotNetNuke CMSExposure: PHP, TAPI