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.
- 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
- 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