SUMMARY

• 8+ years of experience in Analysis, Design, Teradata database administration, tuning and design methodologies and Development using Teradata tools and ETL toolsInformatica, Datastage
• Experience in designing and maintainingslowly changing dimensions to keep track of historical data changes.
• Extensively worked in various Teradata Client Utilites like Multiload, Fast load, Fast Export, Tpump, TeradataParalleltranspoter and TERADATA administrator activities.
• Extensively worked in Teradata RDBMS V2R5/V2R6/12/13.10.
• Familiar in Creating Secondary indexes, and join indexes in Teradata.
• Involved in SQL Tuning, Optimizer, Indexes and Table partitions.
• Closely worked on Teradata Data Labs (Sandbox environment) and did POC.
• Supported many applications from design Phase to Implementation Phase.
• Extensively worked on DBC and PDCR tables.
• Proficient in converting logical data models to physical database designs in Data warehousing Environment and in - depth understanding of Database Hierarchy and Data Integrity concepts.
• Skilled in Data Warehousing Data Modeling using Star Schema and Snowflake Schema.
• Good knowledge of Teradata RDBMS Architecture, Tools & Utilities.
• Sourced data from disparate sources like Mainframe Z/OS, UNIX flat files, IBM DB2, Oracle, and SQL Server and loaded into Oracle, Teradata DW etc.
• Extracted source data from Mainframe Z/OS using JCL scripts and SQL into UNIX Environment and created formatted reports for Business Users using BTEQ scripts.
• Strong Teradata SQL and ANSI SQL coding skills.
• Experience with using the following Teradata Utilities: Bteq, multiload, fastload, fastexport, Tpump, TPT, TD explain utility, visual explain, TSET, TD Index Wizard, TD Statistics Wizard, ViewPoint, and SQL Assistant.
• Expertise in Report formatting, Batch processing, and Data Loading and Export using BTEQ.
• Worked on the performance tuning of user queries by analyzing the explain plans, recreating the user driver tables by right primary Index, scheduling collection of statistics, secondary or join indexes.
• Well versed with Statistics Wizard, Index Wizard, and Visual Explain.
• Developed UNIX shell scripts and used BTEQ, FastLoad, MultiLoad, and Fast Export utilities extensively to load to target database.
• Skillfully used OLAP analytical power of Teradata by using OLAP functions such as Rank, Quantile, Csum, MSum, group by grouping set etc to generate detail reports for marketing folks.
• Expertise in Oracle 9i/8.x/7.x, SQL/PLSQL, Procedures, Functions, Database Packages, and Triggers. And experience in trouble shooting techniques, tuning the SQL statements, Query Optimization and Dynamic SQL.
• Developed UNIX Shell scripts for Batch processing.
• Responsible for writing Deployment/Release Notes before the project release and End User manual for production team.

TECHNICAL SKILLS

Databases: TERADATA V14/V13,V12, V2R6/V2R5, ORACLE 8i/9i/10g/11g, DB2, MS ACCESS, MS SQL Server 2005/ 2000, SYBASE IQ 12.5

Tools: & Utilities: Ab-InitioGDE (3.0,1.15, 1.14), Co>Op 2.14/2.15/3.0.1, Informatica Power Center 8.1, AutoSys 3.4/4.5, Toad 7.6,MS Visio, MS Project, Business Objects 6.0, Quality Center, Erwin 4.1, SQL AssistantLoad & Export Utility FastLoad, MultiLoad, FastExport, BTEQ, OLE load, ORACLE SQL Loader

Languages: C, C++, SQL, Java, PL/SQL, COBOL, VB, Perl and Korn Shell Scripting

Operating Systems: Windows 95/98/2000/2003/ XP/Vista/7, Mac OS, Sun Solaris 5.6, Unix-AIX, HP-UX, Linux

PROFESSIONAL EXPERIENCE

Confidential, NC

Sr Teradata DBA

Responsibilities:

• Worked as a team with database administrators to determine indexes, statistics, and performed Table partitioning the data warehouse, in order to improve performance for end-users.
• Extensively worked on PMON for monitoring the sessions, Teradata Manager during the period of TD 12.
• Extensively worked on DBC, PDCRtables and Teradata ViewPoint for most of the manager activities.
• Troubleshooting the production issues and providing production support.
• Optimal usage of Fastload to load empty tables, Using Multiload to insert, update, and delete records,
• Tpump for real time data loads. Using BTEQ for IMPORT/EXPORT
• Usage of analyst tools like TSET, INDEX WIZARD, STATS WIZARD to improve performance
• Database backup and recovery strategy using net vault and net backup.
• Good knowledge on BAR media and Master Servers for any trouble shooting during the Backup issues.
• Database performance tuning and SQL code optimization.
• Creating error log tables for bulk loading Shell Scripts to automate various routine jobs like tablespace check,
• Materialized view refresh, run monthly user status reports in database etc.
• Extensively worked onCreating Databases, Users, profiles, Roles, Assigning Privilleges tothe roles.
• Extensively worked on the Prod and Non-Prod issues dat come from the Development team and testing/QA team.
• Designed data feeds to load Teradata tables from Oracle tables or from flat files, using FastLoad,
• MultiLoad, and SQLPlus
• Worked with the collect stats to make sure dat to be up to date.
• Worked closely with Teradata Vendors for the Teradata incidents and database restarts during the maintainance windows etc;
• Extensively worked on Production-Support (ON-CALL) on a cycle basis.
• Extensively worked on Technical design documents and Standard process documents.
• Worked on Teradata Queryman to validate the data in warehouse for sanity check .Performance Tuning of sources,
• Targets, mappings and SQL queries in transformations
• Performed tuning and optimization of complex SQL queries using Teradata Explain. Constant Testing of Source and Target after loading to ensure Consistency in the Data
• Preparing Impact analysis for new enhancements
• Review the work done by the team members

Environment: Teradata 14/12,Teradata Manager, View Point, PMON, NetVault, NetBackup, Teradata Administrator, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD,TPT,Data Labs, Erwin, Windows XP, UNIX, SuseLinux.

Confidential, MN

Teradata DBA

Responsibilities:

• Involved in requirements gathering and analysis for implementing theData Warehouse.
• Day to day activities included performance tuning, collecting statistics, analyzing explains&determining which tables needed statistics.
• Extensively worked on performance tuning on very large database (5+TB).
• Space estimations and User maintenance on dev machine.
• Created Users, Databases,and Profilesand Assigning the Roles.
• 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/USI/NUSI/JI etc) etc.
• Complex views were created using Teradata SQL Assistant, in the Teradata staging area to join five or more tables implementing various design specifications, complying with the business requirements.
• Created proper Primary Index (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Involved in the active communication and interaction with the off shore support team during the Production implementation phase of the project.
• Created tables, views in Teradata, according to the requirements.
• In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
• Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Extensively worked on DBC and PDCR tables
• Database backup and recovery strategy, database performance and tuning and SQL code optimization.
• Implemented efficient and TEMPeffective performance tuning procedures.
• Solved Various Defects in Set of wrapper Scripts which executed the Teradata BTEQ,MLOAD, FLOAD utilities and UNIX Shell scripts

Environment: Teradata 13.10/12,Teradata Manager, View Point, PMON,NetVault,Net Backup, Teradata Administrator, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD,TPT,Data Labs, Erwin, Windows XP, UNIX, Linux.

Confidential, Cincinnati, OH

Sr Teradata DBA

Responsibilities:

• Created Teradata objects like Databases, Users, Profiles, Roles, Tables, Views and Macros.
• Modified Databases, Users, Roles & Profiles, Views & Macros.
• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Performed Space Management for Perm & Spool Space.
• Reviewed the SQL for missing joins & join constraints, data format issues, mismatched aliases, casting errors.
• Granted & Revoked Object Rights, System Rights on Databases / Users / Roles.
• Dealt with Incremental data as well Migration data to load into the Teradata.
• Have experience in tuning some batch BTEQ queries.
• Enhanced some queries in the other application to run faster and more efficiently.
• Data was extracted from Teradata, Processed/Transformed using JCL programs and loaded into Data Mart.
• Used various Teradata Index techniques to improve the query performance
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Created series of Macros for various applications in TERADATA SQL Assistant.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created several custom tables, views and macros to support reporting and analytic requirements.

Environment: Teradata V2R5, Teradata SQL Assistant, Teradata Manager, SQL, MVC, JCL, AutoSys.

Confidential

Teradata Developer

Responsibilities:

• Developed Source to Target Mappings using InformaticaPowerCenter Designer from Oracle, Flat files sources to Teradata database, implementing the business rules.
• Used various transformations like Source qualifier, Aggregators, lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, Sorter, Normalizer, Stored Procedure, Union etc.
• Extensively used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Used the Informatica Workflow manager to create sessions, worklets and workflows to create Load Ready Files (flat files).
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Modified BTEQ scripts to load data from Teradata Staging area to Teradata data mart Used FastLoad for loading into the empty tables.
• Used volatile table and derived queries for breaking up complex queries into simpler queries streamlined the Teradata scripts and shell scripts migration process on the UNIX box.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse. Worked on Teradata Queryman to validate the data in warehouse for sanity check. Performance Tuning of sources, Targets, mappings and SQL queries in transformations.

Environment: Teradata V2R5, Oracle8i, Teradata Priority Scheduler, Teradata SQL Assistant, FastLoad, MultiLoad, Teradata Administrator, BTEQ, MVS, UNIX, DB2, COBOL.