Summary

• 4 years of total IT experience in data warehousing including analysis, design, and development of complex transformation and mappings.
• Strong analytical and conceptual skills in database design modeling in Teradata.
• Hands on experience using Teradata SQL Assistant, Teradata Administrator and data load/export utilities like BTEQ, Fast Load, MultiLoad, and FastExport on UNIX/Mainframes environments.
• Experienced with data warehousing applications in Health services, Finance industries
• Active contribution with Off-shore team for 24 hours development process and production support.
• Proficient in Teradata performance tuning from design architecture to application development.
• Highly experienced in SQL performance tuning and debugging of existing ETL process.
• Extensively worked in Teradata jobs including performance tuning, profound knowledge in UNIX environment.
• Excellent skills in retrieving the data by writing simple/ complex SQL Queries.
• Excellent in problem solving, logical and analytical abilities.
• Hands on Experience with SAS.
• Good Communication and interpersonal skills.
• Demonstrate a willingness, interest, and aptitude to learn new technologies and skills.

Technical Skills

Professional Experience

Confidential

Teradata Developer / Data Analyst

Responsibilities:

• Responsible for gathering requirements from business analyst and format them according to the business needs, identify tables required for data model.
• Coding using Teradata Analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQLs on UNIX environment.
• Involved in unit testing integration testing.
• Preparing Test Cases and performing Unit Testing.
• Delivers the Monthly Business Review MBR report on time to business customer.
• Responsible for Writing the UNIX Korn Shell script that takes the SAS datasets as input and Archives them in Mainframe.
• Develop and maintain a space monitoring and compression scripts in unix.
• Develop and maintain the UNIX Korn shell script that identifies the highly occupied and skewed tables and compress them.
• Extensively used MLOAD MultiLoad , FLOAD fast load on UNIX and windows environment.
• Optimized high volume tables in Teradata using various join index techniques, secondary indexes, join strategies and hash distribution methods.
• Trained off-shore team and on-site Analysts on Teradata architecture, usage of Bteq in UNIX environment and usage of MLoad, FLoad, and TPump Fast Export.
• Extensively used Database query logs DBQL , DBC views to notify the users of their space usage and skew ratio.
• Extensively worked on Teradata performance optimization and brought down the queries to seconds or minutes from spool out and never ending queries by using various Teradata optimization strategies.
• Highly involved in Data Analysis by helping the BA providing the data they needed.
• Extensively wrote SAS Scripts to pull the data from MVS and to load the SAS into Teradata.
• Worked on complex queries to map the data as per the requirements.
• Populate or refresh Teradata tables using Fast load, Multi load Fast export utilities for user acceptance testing and loading history data into Teradata.
• Involved in Performance tuning for the long running queries.
• Reduced Teradata space used by optimizing tables adding compression where appropriate and ensuring optimum column definitions.

Environment: TeradataV13, TeradataSQLAssistant, BTEQ, FLOAD, FEXP, MLOAD, Attachmate, MVS, JCL, SAS, UNIX Shell Scripting, Putty, MS SQL Server, Windows XP, UNIX.

Confidential

Teradata warehouse Developer /Analyst

Responsibilities:

• Responsible for gathering requirements from business analyst and functional analyst and format them according to the business needs, identify tables required for data model.
• Create and enhance Technical Specification Document TSD and Customer Requirement Document CRD through constant interaction with Manager and Tech Lead with CMMI Level II/III
• Created data model with required fact and dimensions.
• Extensively involved in physical modeling of the warehouse.
• Created data mart model and develop jobs using business objects data integrator and business objects.
• Create and Maintain Teradata Databases, Users, Tables, Views, Macros, Triggers and Stored Procedures
• Create and Maintain Users Profile Definition to determine the Performance
• Created the mainframe datasets and jobs for the BTEQ,FLOAD,MLOAD scripts
• Created GDGs for storing the versions of data.
• Used COBOL copy books to check the sanity of the file
• Converted existing program in COBOL module to Teradata QUAL test cases program
• Created the doc that has scheduling instructions.
• Extensively used ISPF editor.
• Coding using Teradata Analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQLs on UNIX environment.
• Developed processes on Teradata using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ Teradata and SQL Plus, SQL Loader Oracle .
• Involved in unit testing integration testing.
• Preparing Test Cases and performing Unit Testing.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Worked on complex queries to map the data as per the requirements.
• Populate or refresh Teradata tables using Fast load, Multi load Fast export utilities for user acceptance testing and loading history data into Teradata.
• Designed delta load on all fact tables.
• Involved in Performance tuning for the long running queries.
• Reviewed source systems and proposed data acquisition strategy.
• Client site for implementation and support 24 7 supports for the project until it goes live.
• Reduced Teradata space used by optimizing tables adding compression where appropriate and ensuring optimum column definitions.

Environment: TeradataV12, TeradataSQLAssistant, BTEQ, FLOAD, FEXP, MLOAD,SAS, Mainframes, Rumba, UNIX Shell Scripting, Perl, Putty, MS SQL Server, Windows XP, UNIX.

Confidential

Graduate Assistant / Teradata Analyst

Responsibilities

• Responsible for gathering requirements from business analyst and functional analyst and format them according to the business needs, identify tables required for data model.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, and Indexes.
• Used Teradata Profiler to analyze data.
• Coding using Teradata Analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQLs on UNIX environment.
• Reduced Teradata space used by optimizing tables adding compression where appropriate and ensuring optimum column definitions.
• Developed processes on Teradata using shell scripting KORN and RDBMS utilities such as Multi Load, Fast Load, Fast Export, and BTEQ.
• Worked on complex queries to map the data as per the requirements.
• Used Performance Monitor tool to kill run away queries, abort blocked sessions.
• Created UNIX Scripts for triggering the Stored Procedures and Macros.
• Involved in Performance tuning for the long running queries.
• Scheduled Daily, Weekly, Monthly and On-demand jobs using TWS Tivoli Workload Scheduler .
• Promoted scripts, DDL and Database Objects between different environments.
• Generated reports using Cognos Report Studio.
• Prepared Test Cases and performed Unit Testing
• Involved in unit testing integration testing.

Environment

TeradataV2R6, Teradata SQL Assistant, BTEQ, Fast Load, Fast Export, Performance Monitor, Teradata Administrator, Teradata Manager, Teradata Profiler, TWS 8.5.1, UNIX Shell Scripting, Smart Putty, SQL Server, Windows XP

Confidential

BUSINESS INFORMATION MANAGEMENT SYSTEM

• A web-based Information Management System, for a Software Consulting firm. The goal of this website is to advertise for the products of the company, organize and schedule training seminars, and sell white papers and training manuals for the visitors and customers. I have Implemented SSL protocol for the secure credit card transactions. Further this website also provided private area for the employees of the firm, which included downloading and uploading facility for the reusable software components.