Job Description :
Developed design documentation and implementation proposal for extraction of data from W data warehouse.
Developed modules to extract, process & transfer the customer data using Teradata utilities.
Created Fast Export scripts for extracting and formatting customer data from data warehouse in a mainframe file.
Created FTP Id to set up transmission path between mainframe and UNIX machine.
Developed an environment to receive an external source file for the data that were missing in W tables.
Performed the value added processing (VAPS) on the Customer data generated for user.
having deep experience in developing complex SQL in Teradata (Advance SQL function) and convert SAS Enterprise Guide code to Teradata SQL.

Client : PSCU Bank