SUMMARY

• Seven plus years of IT experience with expertise in analyzing the requirements, application development and major focus on TERADATA Developer/DBA.
• Strong hands on experience using Teradata utilities (SQL, B - TEQ, FastLoad, MultiLoad, Fast Export, Tpump, Administrator and View Point).
• Loading data by using the Teradata loader OLE LOAD, writing Teradata utilities scripts (Fast Load, MultiLoad, TPump).
• Skilled in large-scale multi-terabyte initial database load and ongoing update techniques, backup and recovery requirements, SQL, etc.
• Technical expert in the areas of relational database physical design and performance tuning of the RDBMS.
• Familiar in creating Secondary indexes in Teradata.
• Extensive experience in writing queries by using Joins, Indexes and Views.
• Provided performance tuning and physical database design support in projects for Teradata systems.
• Experienced with Physical Data Model design process in Star and Snowflake Schema, 3NF.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, data validation, systems integration and user acceptance testing.
• Rapid accommodation to emergent technologies, able to quickly learn new technologies and proprietary systems.
• Assist in interacting with the Business Users to understand the Business needs and create data model to accommodate their needs.
• Reputation for strong organizational skills, excellent communication skills, dedicated teamwork, attention to details, ability to work under pressure to balance competing priorities that are required to effectively work in the field of applications development and maintenance.

TECHNICAL SKILLS

Operating Systems: Windows2003/2000/XP/NT, UNIX,MVS

Languages: SQL, HTML, XML, PL/SQL, C programming, VB

Teradata Utilities: BTEQ, FastLoad, MultiLoad, FastExport, SQL*Loader,Teradata SQL Assistant 13.0, Exp/Imp.

ETL Tools: BTEQ,SSIS, DTS, Informatica.

Reporting Tools: Business Objects, Crystal Reports, Excel,SSRS.

Databases: Teradata, MS SQL Server 2000/2005,Oracle, MS-Access.

Database Tools: SQL Enterprise Manger, SQL Client Configurationutility, Backup Server, SQL Server Management Studio,SQL Server Business Intelligence Development Studio.

Other Tools: .Net frame work, Unica 7.5,MS Office, Quality centre 9.0

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

Teradata DBA/Developer

Responsibilities:

• Experienced in preparing code review documents, impact analysis and work requests.
• Created Databases, Profiles, and Roles as per the requirements.
• Have knowledge on access level rights and provide access to Users using Teradata Administrator.
• Performed database health checks and tuned the databases using Teradata Manager.
• Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
• Used Teradata View Point and Teradata Manager Tools for monitoring and control the system.
• Responsible for designing ETL strategy for both Initial and Incremental loads.
• Responsible for writing program specifications for developing mappings.
• Involved in tuning of SQL queries for better performance.
• Worked on database connections, SQL joins views and aggregate conditions.
• Involved in extracting, cleansing and transforming of the data.
• Played a major role in setting up different regions - Testing, Integration, Performance, Break fix and Production environment with the Wrapper scripts and setup and folder structure for Teradata scripts to run in UNIX environment.
• Worked on Teradata Query man to validate the data in warehouse for sanity check.
• Populate or refresh Teradata tables using Fast load, Multi load & Fast export utilities for user Acceptance testing and loading history data into Teradata.
• Created join indexes to enhance the performance.
• Restructure the SQL queries which have bad performance in the production environment.
• Created proper Primary Index (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and
• Execute the SQL’s on UNIX environment.

Environment: Teradata 13.0, BTeq, Mload, Fast Load, UNIX and Windows XP, Teradata SQL Assistant, Teradata View Point, Teradata Administrator, Team Forge, ITSM, TARA.

Confidential, NC

Teradata DBA/Developer

Responsibilities:

• Analyzed business requirements, transformed data, and mapped source data using Erwin Logical Data Model tool, from the source system to the Physical Data Model.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, Fast Export, Tpump, Visual Explain, Query man).
• Worked closely with the source team and users to validate the accuracy of the mapped attributes.
• Troubleshoot and created automatic script/SQL generators.
• Helping the Reporting team by providing the Teradata queries.
• Fulfilled ad-hoc requests coming from superiors in lower environments.
• Analyzing the specifications and identifying the source data that needs to be moved to data warehouse.
• Involved in tuning of SQL queries for better performance.
• Worked on database connections, SQL joins views and aggregate conditions.
• Performed database health checks and tuned the databases using Teradata View Point.
• Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
• Involved in preparing technical design/specifications for data Extraction, Transformation and Loading. .
• Check the output according to the specifications using Unit Test.
• With the in-depth expertise in the Teradata cost based query Optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, Physical design considerations (PI and USI and NUSI and JI ) etc.
• In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance
• Reduced Teradata space used by optimizing tables - adding compression where appropriate andensuring optimum column definitions.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Worked on migration issues from development to testing environments and fixed the same.
• Responsible for documentation of projects.

Environment: Teradata SQL Assistant, BTEQ,Teradata Administrator, SQL Developer 3.2,Multi load, fast export, Data Quality, UNIX, SQL Server, Star Team.

Confidential

Teradata developer

Responsibilities:

• Designed Technical documents and worked with Mapping documents, Identified the source and Target systems as per the business requirement.
• Created tables, views in Teradata, according to the requirements.
• Executed Bteq scripts by collecting initial stats on the required columns.
• Extensively used data mover tool to move data from different environments and created data mover jobs to reuse for the data refresh.
• Developed the code in testing environment and integrated into production.
• Expertise in performance tuning the user queries.
• Worked on production abends and adhoc reports.
• Deployed the DDL changes in QA and Prod environment.
• Designed new Interfaces and coded, unit tested for the new requirements.
• Improving the performance of reports by reducing the spool space and time.
• Collecting statistics on the required columns of the tables and also creating secondary indexes where ever required.
• Created proper Primary Index (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Expertise in Performance tuning the long running queries and saving cpu space, I/O and time.

Environment: Teradata V6.0, Teradata SQL Assistant, BTEQ, Fast Load, Fast Export, MultiLoad, Teradata Administrator, Windows XP.