Worked with stakeholders and understanding their needs, eliciting the requirements.
Communicating with business users and analysts on business requirements. Gathered and documented technical and business Meta data.
Worked on creating BTEQ Reports for Credit Analysts, Delinquency recovery agents and others working at our service centers.
Utilized ODBC for connectivity to Teradata & MS Excel for automating reports and graphical representation of data to the Business and Operational Analysts.
Coding using BTEQ SQL of TERADATA, writing UNIX scripts to validate, format and execute the SQL’s on UNIX environment.
Used UNIX shell script programming to calculate the date values and assigned to a UNIX variable and used these variables in BTEQ SQL Where conditions.
Worked with Teradata EXPLAIN facility, which describes to end-users how the database system will perform any requests.
Worked on loading data from flat files to Teradata tables using SAS Proc Import.
Performance Tuning and Optimization for increasing the efficiency of the scripts on large databases for fast accessing data and generating reports