Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

JUDY DING

Box Hill NORTH,VIC

Summary

As a dedicated Data Analyst and consultant with Capgemini, I bring over 3 years of experience, encompassing government sector projects and banking. Proficient in end-to-end data processing, encompassing Data analysis, ETL, Data validation testing, and performance tuning. Energetic problem solver skilled in developing ETL solutions to address business challenges. Extensive knowledge in data lifecycles, SQL, Master data management, and data warehousing principles. Strong communicator with a talent for conveying complex information effectively. Seeking exciting opportunities with your organization.

Overview

6
6
years of professional experience

Work History

Data Analyst

ANZ Bank
04.2023 - Current
  • Contributed to development of frameworks and guidelines for critical data management, focus on metadata management, to ensure critical data governance
  • Played a pivotal role in KRI reporting, consolidating data from diverse sources, including EMR and non-financial-risk hub.
  • Utilised Python scripting to apply transformation rules, identifying pertinent critical data elements for metric reporting.
  • Efficiently managed Python script changes in GitHub, facilitating seamless code collaboration and maintaining organized repositories for streamlined code management
  • Conducted detailed metric script testing to validate code logic, aligning results with established business rules.
  • Designed and socialised user templates within the bank, establishing seamless linkages between critical data elements and controls to support the process of EMR data ingestion.
  • Contributed to data quality team's efforts in preparing and constructing the final KRI dashboard in Qlikview.

IDQ Developer

Department Of Education And Training
07.2022 - 02.2023
  • Collaborated with source system SMEs to identify data discrepancies and formulate key data scenarios that translate to key business requirements
  • Utilised SQL skills to analyse data from government source systems on Oracle and Microsoft Azure, working closely with clients to define business and data quality rules
  • Developed multiple IDQ mappings aligning with business requirements for data transformation.
  • Worked closely with internal and QA teams to comprehend and rectify data issue during defect remediation
  • Executed and monitored batch jobs in IDQ Prod environment, performed data loading during critical releases.
  • Documented key release processes, including the creation of functional release documents, to ensure the latest version control captured in Bitbucket.

Test Analyst/ PMO

Department Of Education And Training
07.2021 - 07.2022
  • Conducted end-to-end data testing across multiple source to target base objects in Oracle and Microsoft Azure, ensuring alignment with established business & data quality rules.
  • Collaborated with developers to gain insights into the code base, enabling the preparation of comprehensive test scenarios/cases and performed test execution.
  • Led defect detection and closure using JIRA to meet business requirements
  • Promoted SCRUM process and assisted with conducting Sprint planning sessions & daily stand ups while managing the Sprints on a JIRA Scrum Board.
  • Responsible for managing the projects financials and resources forecasting, and streamlined the onboarding and offboarding process for all team members though the creation of a detailed induction pack.


SQL Developer

Department Of Education And Training
05.2021 - 07.2021
  • Managed large datasets from over 10 different government data sources.
  • Developed key 'Majority Rule' component using various SQL functions and assisted in its automation in the IDQ environment
  • Collaborated with other team members to translate technical logics and developed functional reports and presented to external stakeholders.

Customer Consultant

Telstra
09.2017 - 02.2021
  • Perform cost- benefit and needs analysis of existing/potential customers to meet their needs
  • Build Rapport, establish and maintain positive business and customer relationships
  • Expedite the resolution of customer problems and complaints to maximize satisfactions
  • Manage time effectively at fast-pasted working environment
  • Achieve agreed upon sales targets and outcomes within schedule
  • Explain technical problems and provide technical support and advise

Education

Bachelor of Information Systems -

Deakin University
Melbourne, VIC
2019

Diploma of Management -

Deakin College
Melbourne, VIC
2015

Skills

    Data Preparation ,

    Data Visualization,

    Model Building (Clustering,

    Time Series Forecasting, Regression Analysis) ,

    Model Validation,

    Python,

    SQL (MySQL/Oracle/Azure SQL/Salesforce SQL),

    JIRA/Confluence,

    Bitbucket,

    GitHub,

    Informatica Data Quality tool ,

    Master Data Management ,

    IBM Watson (Business Intelligence) ,

    RapidMiner (Predictive Modeling),

    Microsoft Word and Excel

Languages

Chinese (Mandarin)
Native or Bilingual
English
Full Professional

Timeline

Data Analyst

ANZ Bank
04.2023 - Current

IDQ Developer

Department Of Education And Training
07.2022 - 02.2023

Test Analyst/ PMO

Department Of Education And Training
07.2021 - 07.2022

SQL Developer

Department Of Education And Training
05.2021 - 07.2021

Customer Consultant

Telstra
09.2017 - 02.2021

Bachelor of Information Systems -

Deakin University

Diploma of Management -

Deakin College

Similar Profiles

CREATE PROFILE
JUDY DING