William Stuart Email & Phone Number

Sydney, New South Wales, Australia

Supporting the Commonwealth Department of Health EDW

Providing development, support and consultancy services in Data Warehousing environments.

1 Martin Place, Sydney

• Supported the Data Migration of iManage objects to Sharepoint – in the cloud(Scope of work was all MacCap: Macquarie Capital documents)
• Completed Macquarie Bank onboarding
• Studied dashboard that summarized and measured the in-scope iManage contents
• Learnt the Proventeq tool using documentation and familiarized by testing in the DEV and UAT environments
• Examined the standard Proventeq steps and their interaction with the underlying Proventeq Database tables:o MigrationTaskso ProcessingRunso ProcessWorkItemso View: PWST which captures the detail of the processing steps
• Examined the additional steps that were run after the “Proventeq” Transform to produce additional information at the Target (i.e. PWST: TargetItems table)

Canberra, Australian Capital Territory, Australia

Supoprting a Teradata Data Warehouse fed by Informatica ETL processes within an in-built set of frameworks also built with Teradata and Informatica components.My specific role is to keep the Informatica environment up-and-running and also to implement change packages into the Teradata/Informatica/Linux/Control-M system software and configuration.Change is.

Edgecliff

Helped to develop a Data Migration Application using SQL Server 2012 to move data from MARS ( ( McGrath Automated Real-estate System) to SALESFORCE (in the cloud) ).Included sophisticated Integrity Checking within the STAGING Database layer PRIOR to SALESFORCE Load.Designed Built and Tested the full Initial Load and also a Delta Load to pick up changes.

Australia Square, Sydney CBD

This major Enterprise Data Integration Project captured Customer/Premise/Utility Installation details from 4-5 NSW Energy Market "Participants"​ and migrated them from two external companies into the Origin Energy SAP-centric environment over a 2 year period.This was achieved with a high-accuracy solution that incurred minimal loss of business productivity.

Chatswood, Sydney

Supporting the Teradata EDM and related Data Warehouse environments at Vodafone Australia - Chatswood.Developed Archival approach for Call-Data. Achieved sign-off and delivered a working prototype.

60 Martin Place, Sydney CBD

Support and Maintenance of GDW Teradata environment at St George Bank / Westpac.Mostly designing and building SQL and Datastage ETL feeds to the GDW Bronze and Gold layers.Delivered a new "Customer Match" Application which matched across the entire client-base in an attempt to better resolve individuals within the mixed St Georg and Westpac data sources.

Provided support for the IDW environment at Optus.Developed Trap Batch feeds to IDW.Performance Tuning on existing IDW Macros.Maintenance to the TCRM interface to IDW.Supported Customer Analytics using the GTM (Gateway Territory Model)Supported SMB Bundle analysis.

Domestic Airport - Sydney

Supported the Teradata Data Warehouse environments at QANTAS Airways Ltd.Worked on CDW Bookings warehouse in several waves of maintenance and enhancements.Joined the support team and was part of (24-hour) support roster.Member of team to implement FM and CM waves of Booking enhancements that were part of the Triton (Amadeus Interface) Programme.Wrote ETL.

Supported establishment of Metadata Repository as source of all Data Warehouse definitions.Built Web Publishing mechanism for delivery to client-base.Built Business Objects (BI) layer for client access to Metadata.Participated in Knowledge Management Program at BA.Established Airline Operations Glossary owned and contributed to by the business SMEs.

Designed solutions for capturing QANTAS Data Models (phyiscal, logical, enterprise) into a Metadata Repository.

Developed and Supported Applications to deliver Dictionary and Metadata Management capability to AMP Business and IT communities.Wrote PL1,COBOL,DB2 software to support Data Management at AMP.DB2DD: Dictionary of DB2CMR: Corporate Model RepositoryADR: Application Development RepositoryIDR: Information Definition Repository (Data Mapping)

Supported real-time (24 hour) Appliation System Databases at QANTAS Airways Ltd.Design, mainteneance, 24-hour-support, Specialised in Flight Operations and Flight Scheduling subject areas.

Bsc Honours, Mathermatics

Activities and Societies: Volleyball, Snooker, Soccer, Surfing

Higher School Certificate, Maths And Art