The project entailed migration of Network and Switches data from existing databases named Teradata/Netezza to IIAS(DB2). Re-engineered whole ETL process, re-designed the Data Model

Project Brief: Project entailed building Data Mart for company’s insurance products for future Advanced Analytics, IRDA reports, and to automate their existing manual report generation on various frequency.

Role: ETL Architect and Modeler

Software Tools: ETL: DataStage 11.5, Database: Teradata | Data profiling: Information Analyzer 11.5 (IA) | DataStage Information Suite, AIX | Data Modeling: Information Data Architect (IDA) | Teradata Performance Tuning.

Software / Tools: Teradata 12 (BTEQ, ML, FL, FE, SQL-A), UNIX Shell Scripts

Key Deliverables

<!--[if !supportLists]-->R <!--[endif]-->Provided estimation on BTEQ, FL, ML, FE and JCLs.

<!--[if !supportLists]-->R <!--[endif]-->Designed technical and functional specifications, and tested database design, and network-related issues such as connectivity, access rights.

<!--[if !supportLists]-->ð <!--[endif]-->Project: Enhancement and Support of EDW, Duration: Jul 2007 – Feb 2008, Client: TeliaSonera, Sweden

Role: Team Lead

Software / Tools: MLOAD, BTEQ, FL, FE, SQL A, & Mainframe (JCL, Serena Changeman, EARS Remedy and JCLs

Key Deliverables

<!--[if !supportLists]-->R <!--[endif]-->Provided estimation on BTEQ, FE and JCLs via regular interaction with the clients.

<!--[if !supportLists]-->R <!--[endif]-->Identified code defects during Unit, System Integration (SIT), and User Acceptance (UAT) Testing

<!--[if !supportLists]-->R <!--[endif]-->As a SPOC, finalized 14 PoC Use Cases and resolving all technical queries (TML & CRIS).

<!--[if !supportLists]-->R <!--[endif]-->Designed POC Use Cases solution on TML 33 main Tables, Compression of Tables, Extrapolation strategy of Data from 1 TB to 5 TB (TML & CRIS).

<!--[if !supportLists]-->R <!--[endif]-->Designed a simulated TML environment for creation of workload related to Loading, SQL Queries, Archiving, DDL

<!--[if !supportLists]-->R <!--[endif]-->Converted Oracle SQLs into Teradata SQLs (TML & CRIS).

<!--[if !supportLists]-->R <!--[endif]-->Managed tasks assigned to respective teams which included data unloading from Oracle and loading it into nearly 480 Teradata tables (CRIS).