Summary
Overview
Work History
Education
Skills
Certification
Technologies And Skills
Timeline
Generic

Chung-Yee Chin

Summary

Hi, I'm Chung-Yee, a data professional specialising in data analysis, reporting, and enterprise data solutions. I excel at interpreting complex datasets, delivering actionable insights, and collaborating with stakeholders to align solutions with business goals. My expertise spans data reconciliation, report development, dashboarding, and cloud-based technologies. Previously, in Deloitte’s Data Consulting practice, I gained hands-on experience in data governance, strategy, migration, and business intelligence across government, telecommunications, and banking sectors, helping clients navigate complex data environments for informed decision-making.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Consulting

Antares Solutions
01.2022 - Current
  • Blackmores
  • BI Consultant – Data Ingestion and Semantic model development
  • Consulted with business users and business analysts on business logic and requirements, field mappings, and transformation requirements
  • Used Jira and Confluence for documentation
  • Ingested required source data from source systems, including creating and updating manifest information for data pipelines, and creating relevant tables, views, and stored procedures
  • Analysed available and ingested data and used SQL to create datasets for API consumption and customer self-service reporting from the web interface, ensuring data consistency between different source systems
  • Used SoapUI to extract data from Oracle WebCenter, scheduled new Oracle jobs
  • Made updates using SQL in tables and stored procedures to assist additional reporting requirements such as the creation of customer hierarchy logic and demand groups for international markets, currency conversions, different aggregations
  • Created reports and dashboards in Power BI
  • J C Decaux Australia
  • Data Warehouse and Power BI Development
  • Engaged in data ingestion processes and developed Power BI reports, including Sales Revenue and Inventory reports, for finance teams across Australia and New Zealand
  • Utilised tools including Tabular Editor and DAX Studio to refine measures, create calculation groups, and enhance report performance
  • Conducted troubleshooting and fixes for historical and daily data loads in Databricks, ensuring accurate reconciliation of reported figures
  • Vasey RSL
  • Data and AI Team – Integration Hub Design and Data Platform Implementation
  • Reviewed UI and APIs to identify required fields for Employee and Customer domains, tested API data, and defined mapping requirements in collaboration with the business
  • Created detailed design documentation, including API configurations, mapping logic, and test results
  • Worked with APIs using Postman for access, testing, and integration setup
  • Developed notebooks for fact and dimension tables, structured datasets for reporting, and reviewed invoices to define automation rules for external vendors
  • St Agnes’ Catholic Parish
  • Finance Reporting optimisation
  • Set up dataflows into the Fabric environment
  • Created pipelines in Fabric for each source system, and then master orchestration for these
  • Used PySpark/Python, Spark SQL in Fabric notebooks to tackle ingestion process, manifest, and data quality issues such as deduplication and hashing
  • Directed all existing reports to the new data and conducted data reconciliation exercises
  • The Law Society of NSW
  • Data and AI Team – Trust Bank Reporting
  • Set-up framework including ADF, Databricks, KeyVault, SQL server, storage account, SQL database, control database set-up and associated manifest and status tables
  • Created Excel spreadsheet template for banks standardize information received from banks
  • Used SQL to set-up notebooks across raw, trusted, and curated layers
  • Created curated views for reporting and creation of dashboard in Power BI

Consulting

Deloitte Australia
01.2015 - 01.2021
  • Tertiary Education Quality and Standards Agency (TEQSA)
  • TEQSA Information Strategy, Consultant
  • Preparation of materials and documentation for IDO lab (Insight Driven Organisation framework) – background research, current trends – for information management strategy
  • Workshops and consultations with key stakeholders to understand issues to form current state assessment across pillars of strategy, people, process, data and technology
  • Development and prioritisation of initiatives and use cases based on issues raised for governance framework and future road map
  • National Australia Bank (NAB)
  • Data Lineage and Reconciliation, Consultant
  • Workshopping to understand system requirements and work through selection criteria, and then mapping of source attributes to target attributes, following transformation rules and logic
  • Analysis of data extracts to understand data issues, and data investigation and lineage
  • Use of SQL to perform data reconciliation between source and target systems
  • Reporting on results of reconciliation and further analysis on fallouts
  • Environmental Protection Agency (EPA)
  • Data, Reporting and Analytics Hub
  • Liaison with stakeholders to confirm requirements and mappings
  • Used SQL, Data Factory, Databricks, Power BI and DevOps for data analysis and engineering
  • Reconciliation of migration data and follow-up of fixes
  • Creation of automated reports to pick up discrepancies between systems
  • Creation and deployment of Power BI dashboards for compliance and enforcement information

Education

Master of Technology - Business Systems

Swinburne University of Technology

Bachelor of Arts - Geography, Engineering (Hons.)

The University of Melbourne

Skills

  • SQL/T-SQL
  • DAX
  • Python
  • Tableau
  • Qlik View
  • Qlik Sense
  • Microsoft Power BI
  • Microsoft Azure
  • Data Factory
  • DevOps
  • Fabric
  • Synapse
  • Databricks
  • Microsoft SQL Server
  • Talend
  • Fivetran
  • Postman
  • SoapUI
  • Jira
  • Confluence
  • Sharepoint

Certification

  • Microsoft – Azure Fundamentals, AZ-900
  • Microsoft – Azure Data Engineer Associate, DP-203
  • Microsoft – Azure AI Engineer Associate, AI-102
  • Microsoft – Fabric Analytics Engineer Associate, DP-600
  • Databricks – Developer Essentials
  • Databricks – Developer Foundations
  • Scrum - Certified Professional Scrum Master, PSM1
  • Dataiku (Data Science Platform) – L1 certification

Technologies And Skills

SQL/T-SQL, DAX, Python, Tableau, Qlik View, Qlik Sense, Microsoft Power BI, Microsoft Azure (Data Factory, DevOps, Fabric, Synapse), Databricks, Microsoft SQL Server, Talend, Fivetran, Postman, SoapUI, Jira, Confluence, Sharepoint, DevOps

Timeline

Consulting

Antares Solutions
01.2022 - Current

Consulting

Deloitte Australia
01.2015 - 01.2021

Bachelor of Arts - Geography, Engineering (Hons.)

The University of Melbourne

Master of Technology - Business Systems

Swinburne University of Technology

Similar Profiles

CREATE PROFILE
Chung-Yee Chin