Wellington, Wellington, New Zealand
• Senior analyst/developer with proven experience as independent contractor. I will learn up your data structures and adapt to your technical stack fast. I am also adept in translating between developer speak and non-technical business users. • Project experience: Data migration, financial modelling, north island cyclone recovery (infrastructure), Christchurch earthquake recovery (insurance), NZ's Covid response. • Power BI, SQL, Azure Data Factory, Databricks, R. • PhD in Physics, Victoria University of Wellington - data modelling on how electricity flows in graphene. > Chun rhymes with fortune.
• Engaged for data visualisation and technical expertise - Power BI dashboards; SQL / Snowflake Cloud. Wrote algorithms to simplify and automate data integrity checks between planning and financial systems. • Notable Power BI dashboard is one showing financial forecasts to asset planners sourced live from the data warehouse. This enabled proactive/interactive planning instead of relying on monthly finance exports. • Worked across data and finance teams to resolve a long-standing ETL (table population) logic error. • Prototyped a new functionality with senior stakeholder input to help speed up project planning. Based on the successful proof-of-concept, communicated and started implementing the improved process across different teams. • June - Nov: Contract extended to support new performance functional team. Data exploration leading to creating robust performance trackers and indicators. (Independent contractor, connected via Hays)
• Mentoring junior analysts and increased their confidence in writing SQL scripts and handling stakeholder questions including from media, ministers, and members of the public. Led by example by promoting cross-team collaboration. • Responsible for calculating key performance measures published in annual reports. Worked closely with independent auditors by walking them through data products, definitions, and data flows. • Assisted procurement and funding decisions by: analysing tender bids for a pharmaceutical product, and deep-dive and summarizing patient treatments for a particular cohort. • Led data improvement efforts working closely with senior developers. These include ETL migration (with a proof-of-concept in PowerShell), data visualization proof-of-concept in Power BI, major data cleansing downstream from an inconsistent data supply, proofs-of-concept to automate integrity checks for the forecasting system. • Investigated data issues and developed technical resolutions, produced concise technical documentation for team reference. • Translating business requirements from and into: SQL / Snowflake Cloud, Power BI / Power Query, Qlik Sense, and R.
• Main skill gained was communicating with external senior stakeholders dealing with an emergency situation, to elicit information that fulfilled business requirements. This built on my previous experience supporting the nation's Covid emergency efforts. • Contract extended from July onward to support North Island floods/cyclone recovery project with data cleansing, engagement with external stakeholders, front-end testing, and producing data insights. • As business analyst - sourcing external data, scoping, modelling and preparing technical documentations on the business purpose and specifications of new data. Develop and enhance data standards by working closely with the product and data leads. • As data scientist - using R algorithms (including fuzzy matching) to combine different data sources, delivering insights to senior stakeholders. • Front-end tester of a new external-facing app. • Azure Databricks, and R (in the syntax of Apache Spark and RStudio). (Independent contractor, connected via INSIDE Recruitment & Consulting)
• In an analyst/developer role, translated legacy Visual Basic scripts into SQL, to enable financial reporting and reconciliation post-system migration. Worked closely with testers, subject matter experts and product owners. • Delivered complex analyses of investment returns in relation to tax. • Developing assurance solutions for operational financial transactions. • Database modelling to support the future stage of system migration. • Azure Data Factory - data integration/ETL; Azure DevOps - version control & release; SQL - data warehouse; Navicat - database modelling. (Independent contractor, connected via Robert Walters)
• Delivering high-impact, tight-deadline, cross-agency (Health, Customs, MBIE) operational reporting and advice on NZ's Covid health response focusing on border protection and booster vaccinations. • Lead analyst or test lead on dashboards across multiple environments: Salesforce/Tableau CRM, Snowflake/SQL data warehouse, R, and Qlik Sense. • Data modelling lead for new cohorts into the workforce immunization register (2021). • Workforce modelling for Reconnecting NZ operations (2022). PROJECT HIGHLIGHT (Dec 2021 - Feb 2022): Cross-agency analytics on booster vaccinations of border workers. While the IT system was being built, I developed an interim reporting solution with limited resources and tight deadlines, which ended up serving all-of-government booster reporting every day for more than two months. This included numbers reported in the media and statistics used in advice to senior leadership and ministers. I am especially proud of this achievement as an independent data consultant. (Independent contractor, connected via Frog Recruitment)