SUMMARY

• 8 years of IT experience in the Analysis, Design, Development, Testing, Implementation, and Support of Database Systems in UNIX and Windows environments.
• Strong working experience in Teradata utilities (SQL, BTEQ, FastLoad, MultiLoad, FastExport, Queryman).
• Strong working experience on Data Warehousing applications, directly responsible for the Transformation, Extraction and Loading data of multiple formats into Data Warehouse.
• Proficient in Database Performance Monitoring, SQL Query Tuning.
• Managed scheduling of large ETL systems using Autosys and Shell Scripts.
• Coded well - tuned SQL and UNIX Shell scripts for high volume data warehouse instances.
• Hands on experience using Data Extraction, Data Integration and Data Mining for DSS as a Data Warehouse developer using ETL (Informatica) and Teradata Tools.
• Involved in Data Migration between Teradata, Oracle and MS SQL server.
• Programming experience using SQL, PL/SQL (Stored Procedures, Functions and Triggers) and UNIX Shell Programming.
• Experienced working on Performance Tuning, PPI Concepts, Join index strategies, Query optimization, Teradata SQL.
• Expertise in Extracting and Loading data to various databases including Teradata, Flat files, Oracle and SQL server.
• Good at Tuning Teradata SQL and having experience in database programming, SQL (Stored Procedures, Macros and Triggers) using Teradata.
• Exposure to Telecom, Banking domain.
• Proficient in converting Store Procedure Conversion from Oracle to Teradata using TMA tool.
• Proficient in Teradata Database Design (Physical and Logical), Application Support, Performance Tuning, Optimization, Administration and setting up the Test and Development environments.
• Having Good written, verbal, inter personal communication and problem solving skills.
• Expertise in SQL performance tuning including identification of requirements, analysis of large amounts of data and optimizing complex SQL queries.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Team player with good interpersonal skills and the ability to work in team.

TECHNICAL SKILLS

Databases: Teradata V2R4/V2R5/V2R6, TD12.10, TD13.10

ETL Tools: Informatica

Scheduling Tools: Autosys, Crontab

Migration Tool: TMA

Programming: SQL, UNIX Shell Scripting, Teradata SQL, ANSI SQL, Transact SQL, C

O/S: NCR UNIX 4400/5100/5500 , Sun Solaris 2.6/2.7, HP-UX, Confidential AIX 4.2/4.3, MS-DOS 6.22

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Teradata Developer

Responsibilities:

• Involved in requirement analysis, database design, coding, testing, implementation and maintenance of EECRIS application.
• Worked with Teradata SQL Assistant, Autosys, Informatica, TPT, Teradata Tools and Utilities.
• Loading data from SQL server, Oracle and Teradata into target data mart using Informatica.
• Providing solution to improve space utilization and performance tuning to the existing system.
• Involved in preparation of test case documents.
• Involved in the technical workshops during the initiation and definition stages of project.
• Gather requirements by involving in meetings with Business System Analysts and Business users to understand the functionality.
• Analyzing and providing solutions to challenges that may arise while upgrading the software to newer version.
• Involved in discussions with clients and business users for ad-hoc business requirements gathering and understanding.
• Review business views developed in the team and UT test cases.
• Reviewing Implementation documents and supporting the implementation of the projects.

Environment: Teradata-13.10, Unix, BTEQ/BTEQWin, FastLoad, MultiLoad, Fast Export, Teradata Parallel Transporter, Autosys, Informatica, SQL Assistant.

Confidential, Dayton, Ohio

Teradata developer

Responsibilities:

• Generation of TPT script for loading flat files on to staging area.
• Appling transformation and loading data to Target table.
• Worked with Teradata utilities like Fast load, Fast export, Multiload, BTEQ.
• Analysis of loaded data using Teradata warehouse miner.
• Involved in the preparing test case documents.
• Worked on automation and performance Improvement of jobs.
• Performed code building and Unit testing.

Environment: Teradata Migration Access, Teradata-12.10, Unix, BTEQ/BTEQWin, Fast Load, Multi Load, Fast Export, Teradata Parallel Transporter, Autosys, Informatica, SQL Assistant.

Confidential

Teradata Developer

Responsibilities:

• Worked with Teradata SQL Assistant.
• Involved in Converting BTEQ Scripts to stored procedures.
• Prepared Autovend ETL Specification document.
• Worked with Teradata utilities like Fastload, Fastexport, Multiload, Bteq.
• Involved in the enhancement of existing mapping as per client requirement.
• Generation of BTEQ script for loading flat files on to staging area.
• Involved in the enhancement of the existing mappings as per the client requirement.

Environment: Teradata-12.10, Unix, BTEQ/BTEQWin, FastLoad, MultiLoad, Fast Export, Teradata Parallel Transporter, Autosys, Informatica, SQL Assistant.

Confidential

Teradata Developer

Responsibilities:

• Analysis, development and implementation of business requirement.
• Worked with Teradata SQL Assistant.
• Worked with Teradata utilities like Fastload, Fastexport, Multiload,Bteq.
• Analysis of specifications provided by the client.
• Scripting using Teradata-BTEQ through Mainframes.
• Involved in the preparing test case documents.
• Worked on performance Improvement of jobs..

Environment: Teradata V2R6, Oracle8i, autosys,Teradata SQL Assistant, FastLoad, MultiLoad, Teradata Administrator, BTEQ, Fast Export, MVS, UNIX.

Confidential

Programmer

Responsibilities:

• Analysis, development and implementation of business requirement.
• Worked with Teradata SQL Assistant, BTEQ, TTU
• Worked with Teradata utilities like Fastload, Fastexport, Multiload,Bteq.
• Involved in the enhancement of existing mapping as per client requirement.
• Generation of BTEQ script for loading flat files on to staging area.
• Preparing Unit Test plans and Unit Test Reports.
• Worked on the Performance Improvement of SQL.
• Adherence to prescribed Quality procedures

Environment: Teradata V2R5,Teradata SQL Assistant, FastLoad, MultiLoad, Teradata Miner, BTEQ, Fast Export, BTEQ Export, BTEQ Import, Crontab.