Looking after four areas: Data Warehousing, Data Engineering, Business Intelligence, and Regulatory Reporting:- Develop and maintain the national RFDS data collection systems and data warehouse.- Provide information and regular reports related to service delivery, patient demographics, and health outcomes.- Apply technical, analytical, and statistical skills to provide analytics on patient demand, utilization, and health outcomes.- Forecast future health service demand.

Key areas:1. Retail Sales segmentation and insights2. Underwriting Rules Engine - Insights3. Developing team's analytical capabilities.4. Retail Sales Quote to Submission predictive modelling

Led the Retail Sales Effectiveness - Business Analytics arm. I have established the foundational analytics practice within retail distribution, taking a hands-on approach to set up:• Datamart that captures the most appropriate level of information for all sales staff• Fully automated key metrics and drivers of sales performance reports for ELT• Developed a predict model to find the probability of leads conversion to submissions. Each sales staff get their own panel’s leads with their ranking at 8 am daily. Impact of this fully automated solution is estimated to be over $5 million in submissions.• Looked after all BI needs for a newly launched Health Insurance product.

Recent projects:Leads Quality Analysis I am working on Lead Quality Metrics to measure the quality of leads we receive. I have produced multiple visualisations and predictive models.Tools used: SQL, Excel, Tableau & RKey Stakeholders: Head of Commercial & Business Intelligence, Commercial & Planning Manager.Workflow process – Analysis of Completions. I went in cold, worked with multiple stakeholders and masterfully manipulated the data to look for insights.Tools used: SQL, Excel, Tableau & RKey Stakeholders: Head of Commercial & Business Intelligence, Managers of Underwriting and New Business teams.

- In close conjunction with business area stakeholders and data owners, gather requirements for answering questions on current and new product usage and features.- Interface with key business stakeholders on a regular basis throughout the project lifecycle to ensure correct analytical or visualisation outcomes.- Communicate findings to business stakeholders and plan and communicate next steps in alignment with project management team.- Work with engineering teams to extract and gather data relevant for analysis.- Adhere to change control and testing processes for modifications to analytical models.- Provide and apply best practices for data mining/analysis services including quality assurance, experimentation, and production management.Technologies used:TableauSQLRSPSS Statistics & SPSS ModelerExcelTalendTangible Achievements:Reduced processing time taken for the monthly ‘Business Process Review’ report from 5 days to 30 minutes.I have developed ‘Predictive Churn Modelling’ to reduce gross customer churn. It is estimated that 10% churn reduction can save $100 million.

1) Data Delivery Consultant - Board of Airline Representatives of Australia Inc.Consolidated multiple Airline patronage related databases to create Panel Data set for econometric modelling. Tools used: Excel, SPSS, Stata & TableauKey Stakeholders: Executive Director2) Digital Marketing Consultant - Proactive Accounting Group (www.proactiveaccounting.com.au)Dashboard development using Google Analytics & TableauAchievement: This site is ranked number 3 for the search phrase 'accountants camberwell'.3) Credit Risk Modeller - Creditor Watch (https://creditorwatch.com.au/page/creditscores)Binomial Logistic Regression Model was developed to produced credit score for Australian businesses using SPSS.Achievement: This score is displayed on their clients' web dashboard.

ETL (Extract, Transform and Load):A new short-term (horizon of 5 years) demand panel econometric based forecasting model was developed to inform the 2011 IPART Price Submission. I consolidated the required data from many sources, extensively manipulated and finally prepared the data for modelling. Outcome: Later, this model was used to construct a new long-term demand forecasting model. I continuously contributed to the development of the requirements for the long-term demand forecasting model.SPSS, Stata, MapInfo, Microsoft SQL, Excel, Access, and Visio were used for this project.Consumer Segmentation: I developed separate dynamic econometric panel data models for 14 different consumer segments, using the econometric estimation method of General Method of Momentum (GMM) to better understand Sydney Water’s customers.Outcome: A lecturer from the University of Otago (NZ) made the following observation: “I commend the effort San has put into this research. He has demonstrated extensive understanding of the different econometric methods to analyse the research problem.”SPSS, Stata, MapInfo, Microsoft SQL, Excel, Access, Word, PowerPoint and Visio were used for this project.Reporting/Requests: I provide input into major Sydney Water reports (Annual Report, Water Conservation, and Metropolitan Water Plan), folios (Leakage, Water Efficiency) at specific times each year. In addition, solved ad hoc requests for data, data manipulation or interpretation of data.

Price Elasticity Study:This state of the art panel data analysis involved analysing 5 years of metered consumption for around 100,000 households to determine the impact price increases had on water consumption. I performed all ETL (Extract, Transform & Load) tasks for this project as well as provided expert advice to the external consultant.Outcome: This is one of the largest econometric panel studies ever done in this space and it set a new benchmark in estimating the responsiveness of residential households to water usage prices. I was presented with an award as a direct result of this study.SPSS, Stata, MapInfo, Microsoft SQL, Excel, Access, Word, PowerPoint and Visio were used for this project.BASIX Multi-Dwelling Review: To ensure that BASIX is implemented as intended and to its full potential, Sydney Water and the Department of Planning (DoP) were undertaking analysis on the water savings. This study was previously deemed too difficult to undertake however, I performed this study and prepared the BASIX Multi-Unit Water Savings Monitoring Report. Outcome: This analysis provided insights into this program and enabled DoP to benchmark BASIX properties.SPSS, Microsoft SQL, Excel, Access, Word, PowerPoint and Visio were used for this project.Program Evaluations ( Pre, During & Post Analysis): I have project managed and guided program evaluation of Sydney Water's water efficiency programs. The outcomes of many evaluations changed the way Sydney Water has been operating. Most evaluations were completed using SPSS, Stata and Excel.I have personally undertaken the following program evaluations:Pool Cover Evaluation.‘Love Your Garden’ Program Evaluation.WaterSmart Pilot Evaluation.Pressure Management Program Evaluation.I have also mentored three team members in performing the following project evaluations:Spray Gun pilot.Smart Metering In House Device Program. Toilet replacement program.

Database Development: Project managed, operated, maintained and developed large databases.Dwelling Forecast: Managed and analysed the housing related data received from various sources - data input, verification, analysis and reporting.Staff Management: Acted in Team Leader role managing data analysts and GIS staff.

Major Projects:Sangju-Yeoungcheon Expressway Study (Korea): Performed various statistical models to produce traffic and revenue forecasts for a new toll road in Korea for Macquarie Bank.Malahat Highway SP Design (Canada): Designed a Stated Preference questionnaire for the derivation of travel model parameters for the Malahat corridor.Milsons Point Station Pedestrian Model (Sydney): Developed a pedestrian model to assess the infrastructure modifications.VKT 2007 Update (Sydney): Enhanced the estimation and the forecasting of Vehicle Kilometres Travelled (VKT) for NSW Environment Protection Agency. Ryde Traffic and Transport Study (Sydney): Extensive data analysis of Sydney Travel Model output. Current and future scenario traffic data were analysed.Dandenong rail corridor study (Melbourne): Analysed survey questionnaire data to assess the public attitude to temporary line closures for rail engineering works.

Main Duties: Data Preparation: Prepare data for, and coding of the public transit and highway networks. Maintain the accuracy of networks in the model.Analysis: Analyse current travel data as collected in the Sydney Household Travel Survey and other data sets held by the Transport and Population Data Centre (TPDC).Model Operation: Produce travel forecasts from the Sydney Travel Model (STM), from land use models, and any other travel or land use model developed or acquired by the TPDC.Communication: Liaising with the IT department and software vendors. Handling specialised software licenses. Solve internal software problems and upgrades.Programming: Using different languages (SPSS syntax, Emme Macro, DOS script, Perl script) automate various tasks required to the STM and many other day to day tasks.Training: Conducting in-house training in SPSS.

Strategic Electronic Business Technologies:Topics covered: PC's and Office Networks, Software, Internet and Web programmingIntroduction Telecommunications:Topics covered: Computer communications, The Internet, Integrated networks (ISDN and ATM) and Security.Communication Networks (Laboratory Assistant):Topics covered: WAN & LAN systems, Bridges, Communications architecture and protocols, Internetworking and Network security.Mathematics Study Centre:Topics covered: Algebra, Trigonometry , Calculus, Optimisation and MS Excel