Shubham G.

Milestones Handled while Development of Data warehouse application for Charles Schwab Bank (US Client) Projects Enterprise security Master Project: In this project source data is with GSDW (Talend) which further processed in target of SCHWAB IDW in SCD 2 Format. All the security with respective customer information is stored in this table having one single target ESM_DIM_T (joining of 22 tables in IDW) which further act as source for reporting. Responsibility:  Requirement gathering and Test Planning for the project    Creation of Test Case and proper Execution of all the Test Case   Deciding the table type(Snapshot, SCD 2, Event etc) after analyzing the Business Requirement    Validation of UAT (User Acceptance Test case ) with User client    Deciding the flow and Creation of Workflows and also helped in writing the shell script require to achieve some data extraction and workflow tasks 