Talk to sales Try for Free
Mandy Bai

Mandy Bai

Followers of Mandy Bai232 followers
location of Mandy BaiMelbourne, Victoria, Australia

Connect with Mandy Bai to Send Message

Connect

Connect with Mandy Bai to Send Message

Connect

  • Timeline

  • About me

    Analytics and Data Engineer Specialist delivering end-to-end solutions

  • Education

    • Xidian University

      1998 - 2002
      Bachelor's degree Computer Science and Technology

  • Experience

    • China Telecom Corporation Limited

      Jul 2002 - Jan 2008

      Build and deliver reporting solution for Retail, Finance, Marketing, VIP relationship and management in Oracle, Brio Reporting, Crystal Reporting Build and deliver reporting solution for Retail, Finance, Marketing, VIP relationship and management in Oracle, Brio Reporting, Crystal Reporting

      • Senior Program Analyst

        Jan 2004 - Jan 2008

      • Program Analyst

        Jul 2002 - Jan 2004

    • Victoria University

      Jan 2009 - Jan 2011
      Senior Analyst Programmer

      Data Migration; ETL; Callista; Oracle; PL/SQL; UNIX Shell Scripting

    • Carsales.com.au

      Jan 2011 - Jan 2015
      BI Analyst/Developer

      OBIEE 11G (Building RPD, Analysis and Dashboard); Oracle BI Publisher Reporting; ODI; Oracle Data Integrator; Data Warehouse; BI; ETL; Data Migration; Data Integration; Oracle; PL/SQL; SQL; Performance tuning; SQL*Server; Relational Data Modelling; Dimensional Data Modelling; Kimball Dimensional Modelling Methodology; Agile

    • Yarra Valley Water

      Jan 2015 - Jun 2022
      Senior Analytics Specialist

      -Experience in modern data platform in Cloud-Data Warehouse modelling across many different business areas including customer, billing, asset management especially in designing star schema-Build change data capture engineering Golden Gate and ODI seamlessly bring changed data into warehouse from enterprise operational data-Extract, load, transform and shape data from various sources and technologies ready to be consumed -Work closely with business SME to actively look for opportunities to build solutions improving business activities-Build automated bank reconciliation process for 21 payment channels greatly improved productivity of finance team-Experience in building applications for taking business inputsExpertise in below technologiesMicrosoft Power BI, Microsoft SQL Server database, Oracle database, SQL, PL/SQL, ODI, OBIEE, OAC, APEX, GoldenGate, Linux/Unix Shell Scripting Exibir menos

    • NAB

      Jul 2022 - now
      Senior Data Engineer

    • Infosys

      Jul 2022 - now
      Lead Consultant

  • Licenses & Certifications

    • SAFe Practitioner

      Scaled Agile, Inc.

    • Microsoft Certified: Power BI Data Analyst Associate

      Microsoft
      Mar 2022
      View certificate certificate