★ Engagement 3: Optus: 2021 - CurrentPrimary architect for Proactive Network Outage Notifications, a Google Cloud Platform (GCP) application to send notifications to customers in advance of mobile or NBN outages. Designed pipelines for data acquisition, ingestion, processing and message delivery. Built using PubSub, Cloud Storage, BigQuery Cloud Functions and Kubernetes★ Engagement 2: Transport for NSW: 2018-2021Data analyst for road (travel times, vehicle volumes) and… Show more ★ Engagement 3: Optus: 2021 - CurrentPrimary architect for Proactive Network Outage Notifications, a Google Cloud Platform (GCP) application to send notifications to customers in advance of mobile or NBN outages. Designed pipelines for data acquisition, ingestion, processing and message delivery. Built using PubSub, Cloud Storage, BigQuery Cloud Functions and Kubernetes★ Engagement 2: Transport for NSW: 2018-2021Data analyst for road (travel times, vehicle volumes) and public transport (Opal card) data. Initially engaged primarily to answer ad-hoc customer queries, soon transitioned to a developer role responsible for two distinct newly-acquired data sources. Subject matter expert on both, I managing this source from end-to-end. I set requirements for upstream (data landing) and downstream (front end reporting tools) ends, as well as developing all parts in between (primarily data transformation in Athena SQL) by myself.★ Engagement 1: REST Super: 2016-2018Team member for a new data warehouse development. Primary role was as a Tableau developer of the company's 'Balanced Scorecard', Member Dashboard' and a 'Policy Committee Report'. These were all supported by my own SQL development of the Presentation Layer within the data warehouse AWS Redshift database. Also responsible for the Tableau Server instance including installation and trouble shooting. Show less

Data Analyst in small team dedicated to E2E process improvement for handling customer complaints. Responsible for compiling existing BAU reports and for developing new ones at both operational and executive level. Principal role was to produce ad-hoc reports for deep-dive analysis of complaint handling process, eg breakdown of time within different resolver units or worst performing complaint categories, to identify targets for process improvement in accordance with DMAIC methodology (Six… Show more Data Analyst in small team dedicated to E2E process improvement for handling customer complaints. Responsible for compiling existing BAU reports and for developing new ones at both operational and executive level. Principal role was to produce ad-hoc reports for deep-dive analysis of complaint handling process, eg breakdown of time within different resolver units or worst performing complaint categories, to identify targets for process improvement in accordance with DMAIC methodology (Six Sigma) Designed, from scratch, Tableau dashboards for multiple measures of business performance with respect to complaint management and KPI attainment. Wrote R code scripts for rapid merging of multiple data sets (csv files of complaints, organisation structure, customer location) in the absence of access to backend databases. VBA for automated report generation from Excel template.Modeled projections of customer complaints that showed volumes would rapidly increase in 2017 (since proved quite accurate) Show less

Managed several projects including air pollution monitoring on road networks and a major field study of in-vehicle exposure to pollution (nitrogen dioxide) in Sydney tunnels. Also responsible for data management, analysis and reporting. Coded and designed databases (MS Access), scripted custom views (SQL Server) and created dashboards (Excel and Tableau)

Writing ad-hoc SQL (SQL server, MS Access, SQlite), Python (data processing, QGIS), VBA (MS Excel and MS Access), R (Graphical presentation) scripts for company projects.Managing projects including job preparation for road crews, client consultation, data processing and data delivery.

Coding (VBA, SQL) for importing and processing raw instrument data into a custom MS Access database. Developed front-end Excel dashboard and R scripts for presentation quality static imagesOperated a GC-FID-MS for identification, quantification and reporting of the chemical composition of gas samples. Developed and refined methods and protocols for its operation

Developed (from scratch) a database and VBA macros to upload and store minute-by-minute log data from different instruments recording over sixteen months (over 5 million measurements). Wrote queries and macros for automated chart generation within Excel.Aggregation and statistical analysis provided definitive answers to questions such as: how far did these pollution plumes travel, which direction did they mostly go, and were they likely to constitute and environmental or health risk?

Co-authored a report into particulate matter (PM) and how it applies to the coal industry both in Australia and major export markets. Critically reviewed wide ranging literature sources including legislation and epidemiology.Analysed several years of historical pollution data from multiple sites near coal-fired power stations in the Hunter region (VBA, MS Access). Findings helped the coal-fired power industry demonstrate its existing pollution control measures produce acceptable… Show more Co-authored a report into particulate matter (PM) and how it applies to the coal industry both in Australia and major export markets. Critically reviewed wide ranging literature sources including legislation and epidemiology.Analysed several years of historical pollution data from multiple sites near coal-fired power stations in the Hunter region (VBA, MS Access). Findings helped the coal-fired power industry demonstrate its existing pollution control measures produce acceptable environmental outcomes. Show less

Ran a small business with my wife. Sold coffee and bacon and egg rolls in a temporary stall at two weekend marketsTook orders from customers, helped prepeare food on the BBQ, developed my own database for all book keeping and performed most other management tasks (ordering stock, preparing tax returns, etc)

PhD project to measure and analyse motor vehicle emissions from a light-duty passenger vehicle whilst being drivenOperated multiple instruments to log data from a motor vehicle on road. Used VBA to upload millions of these measurements into a customised database. Wrote queries and VBA code to synchronise and combine multiple data sets.Applied various analysis techniques: binning, aggregation, time series, modelling and geographical location plots to determine main causes of… Show more PhD project to measure and analyse motor vehicle emissions from a light-duty passenger vehicle whilst being drivenOperated multiple instruments to log data from a motor vehicle on road. Used VBA to upload millions of these measurements into a customised database. Wrote queries and VBA code to synchronise and combine multiple data sets.Applied various analysis techniques: binning, aggregation, time series, modelling and geographical location plots to determine main causes of motor vehicle emissions.Sliced and diced multidimensional data into a form that could be interpreted statistically and visually. Most previous research was limited to time series analysisOne reviewer of my thesis noted it as the most detailed assessment of its type undertaken in Australia Show less

Laboratory research of catalytic converters & TeachingAnalysed, interpreted and reported results from laboratory experiments. Operated gas chromatograph, mass spectrometer and chemiluminescent analysers. Co-authored several papersincluding one breakthrough paper ('The storage of nitrogen oxides on alumina-supported barium oxide') that has been cited at least 161 timesSupervised and graded reports for 1st year undergraduate chemistry students in their laboratory classes… Show more Laboratory research of catalytic converters & TeachingAnalysed, interpreted and reported results from laboratory experiments. Operated gas chromatograph, mass spectrometer and chemiluminescent analysers. Co-authored several papersincluding one breakthrough paper ('The storage of nitrogen oxides on alumina-supported barium oxide') that has been cited at least 161 timesSupervised and graded reports for 1st year undergraduate chemistry students in their laboratory classes. Taught introductory chemistry as a tutor to classes of around 25 students as well as private tutoring Show less

A client required an automated way of producing tags for attachment to bundles of steel products produced in their factory. Used VBA and pivot tables to take data entered into Excel spreadsheets and sort it according to the order these parts were cut in the factory. Automated summarised cost and production information into csv files for later uploading to an accounting/inventory system. Modified spreadsheet to incorporate drop down lists and macros to check data entry errors