SAS DI Developer

• Dec 2022 - Present

SAS Data Engineer

• Mar 2022 - Aug 2022

Playing a major technical role in the data migration of insurance data from a bank to Allianz following a business transfer. Playing a major technical role in the data migration of insurance data from a bank to Allianz following a business transfer.

BI Reporting Lead

• Sep 2015 - Feb 2022

Creating and enhancing the BAU reports used by Bupa Finance Teams for continous improvements and for Sales and Growth. The reports employ a combination of modern technologies such as Base SAS, SAS Macro, SAS Enterprise Guide, Oracle DBMS, MySQL DBMS, MS Excel, Windows VBS and Microsoft BI.Other duties includes the extract of claim data and loading onto a Linux plateform that runs MySQL and Drupal. Designing reports related to referrals for Home, Car, Pet insurance and insight into customer prospects.Initially this fix term employment was for three months only. Near the end of the tenure it was extended for a year to December 2016. Again it was further extended to December 2017.

Solution Advisor

• Jul 2009 - Dec 2014

Develop Financial Reports using Base SAS, SAS Macro and Excel VBA, sourcing data from SQL Server, Oracle Server and the data warehouse.Enhance and automatic existing report programs.Execute daily, weekly and monthly reports. When error occurs, analyse root cause of the problem and provide resolution.Quality assurance of the reportsProvide technical support to other SAS programmers and business analysts. Develop Financial Reports using Base SAS, SAS Macro and Excel VBA, sourcing data from SQL Server, Oracle Server and the data warehouse.Enhance and automatic existing report programs.Execute daily, weekly and monthly reports. When error occurs, analyse root cause of the problem and provide resolution.Quality assurance of the reportsProvide technical support to other SAS programmers and business analysts.

Test Analyst

• Jan 2001 - Jul 2009

Creating test strategy and test plan.Schedule test and executing test cases.Product test result summary.Manage defects and resolutions.Setting up test environment and creating test data using SAS.Setting up automated test execution and verification using SAS. Creating test strategy and test plan.Schedule test and executing test cases.Product test result summary.Manage defects and resolutions.Setting up test environment and creating test data using SAS.Setting up automated test execution and verification using SAS.

Quality Assurance Advisor

• 2000 - 2001

Ensuring programmers follow the development process during all the stages including function design, technical design, construction, unit testing, application testing and interface testing etc. The goal was to maintain the CMM level 3 creditation.

Programming Analyst

• 1996 - 2000

Maintenaning Telstra’s core billing system Flexcab, including fixing production defects and implementing new functionalityReviewing other programmer’s work to ensure compliance to coding standards and software quality for CMM accreditationSystem enhancement is a continuous process. I was involved in making technical change (designing and coding) to implement new functionalities. As a programmer I followed strict project standards such as naming convention, registering object names, programming styles, comments within source code and unit testing method.

Application Programmer

• 1994 - 1996

Developing automatic verification tools for testing using SAS.Developing tools to set up testing environment using SAS.Exploring data stored in a relation database and produce complicated reports from the data.The automatic verification tool was added to the end of the normal process. Quite often it repeated the original functionality and the outputs from the tool and process were automatically compared to ensure that they were functionally the same. Developing automatic verification tools for testing using SAS.Developing tools to set up testing environment using SAS.Exploring data stored in a relation database and produce complicated reports from the data.The automatic verification tool was added to the end of the normal process. Quite often it repeated the original functionality and the outputs from the tool and process were automatically compared to ensure that they were functionally the same.

Application Programmer

• 1989 - 1994

Maintenance to the Student Record information system in COBOL.Implementing HECS reports using SAS.Maintenance to the interface between the university’s library and the Student Record system.Providing user support in entering data into the mainframe computer.

Mainframe Operator

• 1988 - 1989

Controlling job execution in an IBM3090 mainframe computer, including setting job priority, holding and resuming jobs, and cancelling jobs.Mounting magnetic tape and DASD plates.Distribution of system printer printout.