Wing Wong

Work History

Work History
Jun 2013 - Present

Data Warehousing Consultant

NBN Co. (via Servian)

Established the architecture and design framework for the NBN Co. data warehousing solution to enable intra-day reporting.

The implementation includes using Infosphere CDC to extract data from source system in a non intrusive manner (where possible).  Data Stage to to provides the data transformation functionality.  Other tools includes Information Analyzer to perform the data profiling activities. 

Responsibilities:

  • Translate business requirements into detailed architectures and design
  • Take lead role in dealing with clients, program managers, IT team
  • Technical project management to facilitate the IT service transition to production
  • Lead a team of developers in the delivery  of the Impact Assessment Framework (IAF)
  • Liaises with the source system owners to acquire new data
  • Mentor new developers

Achievements:

  • Successfully deployed Infosphere CDC to production with over 7000 tables
  • Successfully deployed the Impact Assessment Framework to production with over 35 source systems baseline totaling over 20,000 tables
  • Successfully deployed the data warehousing solution to Netezza and Tableau reports
Mar 2013 - Jun 2013

Data Warehousing Consultant

Optus Pty Ltd (via Servian)

An agile project with the business to developed a process to systematic calculate the "Revenue Turn On" for Sales Consultants.  The role requires an understanding of the business processes and how the information is represented in the Customer Care system and Billing system so we could measure the revenue conversion from opportunities (in Customer Care) to actual revenues (in billing).

Responsibilities:

  • Provided data analysis services to the business
  • Translate business requirements to detailed design
  • Developed the data model for the Customer Care system
  • Developed the data model for the Billing system
  • Developed the mapping rule engine to translate Customer Care data
  • Developed the mapping rule engine to translate the Billing system data
  • Developed a report to provide Revenue Turn on reporting to the business

Achievements:

  • The reporting solution was successfully completed on time and on budget
Aug 2012 - Feb 2013

Solution Architect

SVX Global (via Servian)

A project requiring us to design an online based customer facing solution as the core business application for SVX Global.  The application enable registered individuals digital fingerprint to establish a central repository of personal documentation.  The solution allows integration with major financial institutions and superannuation.

Responsibilities:

  • Document all business requirements including Use cases
  • Translate business requirements to detailed designs (Context Diagrams, Interaction Diagrams, ER Data Models, Physical Models, etc)
  • Developed a solution Roadmap from current state to the desired end state
  • Developed the project plan for the statement of work
  • Selection of technology for the development project (including Database, Application Software, Source Control, etc)
  • Solution Design
  • Demonstrating solution to clients
  • Implementation

Achievements:

  • the Solution Architecture and Design was accepted by the Client
  • the Implementation was successfully completed and deployed
  • all demonstration was well received and effort was appreciated
  • Client expectation was well managed
Aug 2011 - Jun 2012

Solution Architect/Project Manager

IBM Australia (via QuantumIT)

The IBM Sales Incentives program was an online application to encourage IBM partners to sell more products and achieve higher sales volumes.  The application is fully integration with existing IBM web portals and provides online reporting and metadata management for administrators.   The application was successfully completed and rollout global to all IBM partners.

Responsibilities:

  • Developed the Solution Architecture Briefing
  • Developed the Data Modelling required for the solution
  • Designed the Business Intelligence Reports for the Administrators
  • Coordinated the changes and development activities
  • Managed the Project deployment activities
  • Managed the Stakeholders concers and expectations

Achievement:

  • The solution architecture briefing was accepted by the IBM Architecture Review Board
  • the solution was deployed successfully global to all IBM partners
  • the BI Reports was successfully deployed
  • the project was completed ahead of schedule
Feb 2009 - Aug 2011

Manager Data Solutions

ANZ Bank

A project requiring us to design and build a new data warehousing solution for the ANZ investment banking.  The project MITD (Markets Integrated Trade Data-warehouse) source data from multiple trading systems across the global and provides daily reporting solutions to product controllers and regulatory reporting requirements.

The implementation includes a dynamic rule engine to manage financial bond rules, data mapping and data transformations. The solution was successfully completed and deployed to production.  

Responsibilities:

  • Developed the Solution Architecture Design (SAD)
  • Lead the Solution Design for the MITD project
  • Project Manager for the MITD project
  • Developed the Business Requirement Definition
  • Development activities (data acquisition, impact analysis, risk analysis, compliance requirements)
  • Mentoring
  • Application demonstrations
  • Managing offshore development (ANZ India)

Achievement:

  • Successfully deployed to production and the only solution to automatically reconcile back to the general ledger
  • Developed and delivered an efficient and cost-effective technical solution meeting all customer requirements
  • Leading the project from start to finish and overcame all challenges along the way
Jun 2005 - Feb 2009

Development Lead

Sensis Pty Ltd

The initial data warehouse was build to support the balance scorecard application but quickly turning in a sales reporting platform.  The roles includes new data acquisition, BAU (day-to-day support), new application development and building new reports.

Responsbilities:

  • Manage the day-to-day running of the data warehousing solution
  • Manage the Small Business initiative project works
  • Defining the Statement of Work for the business
  • Lead all major solution design to ensure feasibilities
  • Solution Development

Achievement:

  • Successfully completed and deployed 9 fixed price projects on time and on budget (many project was developed alone)
  • build a strong relationship all stakeholders
  • the delivery of reports never exceeded Service Level Agreement (SLA)
Jan 2001 - Jun 2005

Senior Data Warehouse Developer (Contractor)

Telstra

Building a new data warehousing solution for Telstra to enable retail reporting to the business.  The roles includes data modelling, data acquisition (daily and real time), performance tuning, data cleansing and business rules implementation.

Responsibilities:

  • Data Acquisition from Telstra source systems
  • Performance Tuning
  • Data Cleansing

Achievements:

  • All data was acquired on time
  • the project was successfully completed
Jul 1998 - Dec 2001

Technical Team Leader

IBM Global Service Australia

The project is Infotranz which is a Wholesale rebilling project for Telstra.  The system acts as a gateway between Service Providers and Telstra internal billing systems and facilitates the transactions.

Responsibilities:

  • Lead the Development team (key stakeholder for code reviews)
  • Developed the functionality requirements
  • Translating functionality requirements to technical requirements
  • Team management

Achievements:

  • Successfully deployed 5 major releases without errors or problems (first within the group)
  • High Achiever for 2 consecutive years which includes IBM Stock options

Education

Education
Mar 1992 - Nov 1995

Bachelor of Science in Computer Science (Hons)

RMIT University

Skills

Skills

Tableau

C# (.NET and MVC4)

IBM Infosphere DataStage

Netezza

Oracle PL/SQL

Solution Design/Solution Architecture

C

Java

PHP

Unix (shellscript, awk, sed, ksh, bash)

Data Modelling

Sql*Server (including SSIS, SSRS)

Oracle

Certifications

Certifications
Feb 2014 - Present

TOGAF 9

The Open Group
Aug 2013 - Present

IBM Information Management (Netezza) Certified

IBM
Jul 2013 - Present

Certified ScrumMaster

Scrum Alliance