Tata Consultancy ServicesBI Solution Designer
Sep. 2011 - Apr. 2013Westpac, Martin Place, SydneyClient: Westpac Banking Corporation Role: BI/DW Consultant Duration: March 2012 – July 2012 Team Size: 8
ETL: Informatica 9
Database: Teradata V2R13 Operating System: Unix
Tools: SQL Assistant, CA Erwin, Quality Centre, EDW Meta Project Description Westpac ECE project is to identify the customers who are not complaint with the identification process in order to prevent the Anti-Money Laundering. Enterprise Data Warehouse (EDW) receives customer identification Verification details, Employee details and reference data from Source Systems into Source Image and pass on to Core and Semantic layers with transformation according to business rules. OBIEE reports are built from Semantic layer. Contribution Understand Business Requirement Document, Conceptual and Logical Data Model Prepare Physical Data Models Provide ETL Solutions for Source Image, Core and Semantic layers in Enterprise Data Warehouse Prepare Detail Technical Design Document Prepare Informatica Data Mapping and End-End solution document Pass on to Development team and assist them creating Informatica components, Unix Jobs, Teradata tables Prepare Test Plan according to TCS Quality standards and walk through with Enterprise Testing team and help in creating System Integration Test plans.