SUMMARY

• 7+ Years of IT experience in the Analysis, Design, Implementation, Testing, Developing and Administration of business application systems in Data warehousing.
• Over 6 years of experience in Teradata DBA with two plus years of experience in Teradata V 12/13/14,
• Expertise in WINDDI/Teradata Administrator for managing databases, user tables, indexes, statistics, managing permissions(Roles & Profiles) addressing the user issues.
• Experience in performance tuning, Teradata SQL optimization, detailed design, application support, tuning and optimizing bad queries and handling database maintenance.
• Skilled in Teradata Manager, PMON, TDWM, DBQL, SQL Assistant and BTEQ.
• Proficient in using teradata utilities such as TD Manager, Administrator, SQL Assistant, TSET, Visual Explain, arcmain, TASM.
• Strong hands on experience using Teradata utilities (SQL, BTEQ, Fast Load, MultiLoad, Fast Export, Tpump, Visual Explain, Query man, WinDDI) and Unix Shell (Korn) scripting.
• Expertise in using Visual Explain, Index wizard, Statistics wizard to tune the bad queries and analyze the plans implement the recommendations to gain the performance.
• Extensive experience in Teradata work load balancing concepts like TASM worked with various user groups and developers to define TASM workloads, exceptions, implemented filters, throttles as required.
• Expertise in database programming in writing of the SQL, Stored Procedures, Functions, Triggers, Views in Teradata, Oracle, DB2 & MS Access.
• Skilled in coding and debugging Teradata utilities like Fast Load, Fast Export, MultiLoad, Tpump, TPT
• Experienced in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Experience in Backup and Restore (BAR) methodologies. Design, implement and co - ordinate all back-up and restore strategies.
• Familiar with Teradata architecture such as shared nothing, nodes, AMP’s, BYNET, Partitioning, primary index, secondary index, teradata explain etc.
• Experience in developing ETL mappings and scripts using Informatica PowerCenter 9.1/8.5 and PowerMart 6.2/5.1 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager/ Monitor.
• Strong experience in Teradata RDBMS V2R12/V2R6/V2R5, application performance tuning, Teradata SQL optimization, detailed design, application support, tuning and optimizing bad queries and handling database maintenance works.
• Experienced in trouble-shooting techniques, tuning SQL statements, Query Optimization, Single AMP Optimization, Dynamic SQL and Materialized Views, Normalization, Data Modeling.
• Experience in analyzing, resolving and monitoring database performance related issues.
• Provided support to product, test and development environments for data warehouse projects.
• Proficient in SQL coding, Teradata utilities like TD Manager, Administrator, SQL Assistant, TSET, Visual Explain, Arcmain, TASM, collecting statistics for better performance of the queries.
• Strong Communication, Presentation and Interpersonal skills with excellent problem solving capabilities.

TECHNICAL SKILLS

Data Warehousing: TeradataV2R13/V2R12/V2R6, Oracle 10g/9i, SQL server2000, MS Access.

Operating Systems: HP-UX, Sun Solaris, Red Hat Linux, Windows2003/2000/XP/NT, IBM AIX.

Languages: SQL, PL/SQL, C, C++, UNIX shell scripting, PERL.

DB Utilities: BTEQ, Fast Load, Multi Load, Fast Export, T Pump, SQL*Loader, Exp/Imp, TD Administrator, TD Manager, TSET, SQL Assistant, Visual Explain, TASM.

Scheduling Tool: Multiload, AutoSys, Version Control.

Tools: CSV, VSS, Arcmain, Teradata Administrator, Visual Explain, SQL Assistant, Toad, Putty, WINSCP, CYGWIN, Oracle Developer 2000, SQL*Plus, Crystal Reports, Remedy.

Others: MS Office, Informatica Power Center 7.X/8.X, Telnet, Adobe Acrobat Reader/Writer, XML, HTML, UML, SFTP, FTP, SCP, Telnet, TCP/IP.

PROFESSIONAL EXPERIENCE

Confidential, Riverwoods, IL

Teradata DBA

Responsibilities:

• Monitored Teradata system for delays, blocking and skewing using Teradata Tools like (PMON, TASM and Viewpoint) to increase system efficiency.
• Addressed system issues by notifying and directing application users for temporary workarounds (turning on diagnostics or instructing onsite Teradata personnel to modify dbscontrol flags).
• Teradata Database peroformance monitoring and maintenance using Teradata manager.
• Adjusted priority levels for application users in order to meet SLA’s. Restored application tables from tape by using Teradata Arc Utility.
• Updated Teradata Development System utilizing Teradata Utilities like Fastexport, Archive, Fastload and Restore in order to test and develop the applications.
• User access management, space management, session management, Index management (Partition Primary Index, Join Index, Secondary Index, etc.).
• Restored application tables from tape using Teradata Arc Utility. Monitored disk usage via PMON and Reusage.
• Configured and scheduled data collection to analyze trend reports for CPU, I/O, database and table growth, user account etc. Collect statistics for better performance of queries.
• Worked on optimizing and tuning the Teradata views, SQL queries and single AMP optimization to improve the performance of batch and response time of data for users.
• Prepared low level technical design document and participated in build/ review of the BTEQ Scripts, Fastexports, Multiloads and Fast Load scripts.
• Created various SQL Queries for data extraction and transformation. Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
• Created Technical Design Document as per Physical Data Model., Data Flow Diagrams as per design.
• Involved in extracting and loading data from external sources into Teradata Warehouse.
• Exxtensively uses Explain to fine tune Teradata tables and improve performance.
• Transformed Logical Data Model to Physical Data Model ensuring the Primary Key and Foreign Key relationships in PDM, Consistency of definitions of Data Attributes and Primary Index considerations.
• Regulated password expiration, reuse and minimum characters via profiles to adhere to Medco standards.

Environment: Teradata V13/V14, Viewpoint, UNIX, SQL, TASM, TPT

Confidential, Chicago, IL

Teradata DBA

Responsibilities:

• Involved in complete SDLC (System Development Life Cycle).
• Expert DBA skills in Teradata DBMS Administration, initial environment setup, development and production DBA support, Teradata Manager, Viewpoint, FASTLOAD, MULTILOAD, TPUMP, SQL and TASM for workload management.
• Established application hierarchies, databases, users, roles and profiles as per requirements.
• Responsible for performance monitoring, resource and priority management, space management, user management, index management, access control, execute disaster recovery procedures.
• Development and maintenance of complex SQL with multiple tables JOIN conditions. Involved in maintaining and troubleshooting problems for business applications.
• Loaded data using FastLoad, BTEQ, Fast Export, MultiLoad, and Korn shell scripts.
• Designing, creating and tuning physical database objects (tables, views, indexes) to support normalized and dimensional models. Maintain and enhance database performance using Teradata Manager, Performance Monitor, and TASM.
• Teradata database performance monitoring and maintenance, Support Teradata database & TTU upgrade activities, design, implement and co-ordinate all back-up, recovery (BAR) strategies.
• User and access Management, Space Management, Session Management, Index Management, System analysis, design & Maintenance.
• Assisted in troubleshooting the Production support problems, which are related with Teradata database.
• Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data.
• Involved in large scale multi terabyte initial data load, data migration, and ongoing update techniques, backup and recovery requirements, SQL, etc.
• Directed MVS group on necessary changes to enhance Teradata TDP performance, Ran showspace to check for cylinder fragmentation and available free cylinders.
• Responsible for documentation of the project translating functional requirements to technical specifications.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Lookup, Router, stored procedure and Aggregator to create robust mappings in the Informatica Power Center Designer.

Environment: Teradata 13.10, Teradata Viewpoint, Informatica Power Center 8.5 (Domain, Services, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), Toad 8.5, UNIX Shell Programming, SFTP, NDM, Solaris 5.8, Windows 2000.

Confidential, Los Angeles, CA

Teradata DBA

Responsibilities:

• Managing database space, allocating new space to database, moving space between databases as need basis.
• Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
• Extensively worked with DBQL data to identify high usage tables and columns. Redesigning the Logical Data Models, and Physical Data Models.
• Use of Teradata Manager, BTEQ, FASTLOAD, MULTILOAD, TPUMP, SQL and TASM for workload management.
• Monitoring bad queries, aborting bad queries using PMON, looking for blocked sessions and working with development teams to resolve blocked sessions.
• Perform workload management using various tools like Teradata Manager, Fast Load, Multi Load, TPump, TPT, SQL Assistant and TASM.
• Involved writing BTEQ scripts for validation & testing of the sessions, data integrity between source and target databases and for report generation.
• Developed Backup and Recovery (BAR) procedures for Development, Testing and Production.
• Enterprise wide templates were created for handling SCD, Error handling etc.
• Involved in writing Teradata SQL bulk programs and in Performance tuning activities for Teradata SQL statements using Teradata EXPLAIN.
• Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata Database. Involved in analysis, development, testing, implementation and deployment.
• Created debugging sessions for error identification by creating break points and monitoring the debug monitor.
• Created Stored Procedures to transform the data and worked extensively on SQL, PL/SQL for various needs of the transformations.

Environment: Teradata V2R6, DRIFT2K, Oracle 9i, Mainframes, Fastload, Multiload, TPUMP, BTEQ, SQL Assistant, SRM.

Confidential, Atlanta, GA

Teradata DBA

Responsibilities:

• Conducted several JAD sessions with key business analysts to get the requirements related Reports, KPIs and Data Mining.
• Performed extensive Data Profiling on the source data by loading the data sample into Database using Database Load Utilities.
• Worked with Data Modelers to create a star schema model for the above subject areas and made sure that all the requirements can be generated from the models created.
• Created High level and detail design documents for above data mart projects containing process flows, mapping document, initial and delta load strategies, Surrogate key generation, Type I and Type II dimension loading, Balance and control, Exception processing, Process Dependencies and scheduling.
• Identified the required dependencies between ETL processes and triggers to schedule the Jobs to populate Data Marts on scheduled basis.
• Did the performance tuning on the Ab Initio graphs to reduce the process time.
• Designed and coordinated the backfill process to load 3 to 5 years of the data into Data Marts.
• Participated in the evaluation of Teradata DBMS to replace DB2/UDB 7 for the EDW. Created several large tables with real card portfolio data totaling 4 TB for the POC. With the help of Teradata folks at San Diego, created tables with right primary index and partitioning index on the 4 node Teradata system. Created several complex queries and ran them to get the performance measurements. Compared the results with the results from running the same queries on UDB DB2 system. Presented the results to Management.
• Worked with DBA team to ensure implementation of the databases for the physical data models intended for the above data marts. Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
• Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
• Extensively used the Teradata utilities like BTEQ, Fastload, Multiload, DDL Commands and DML Commands (SQL). Created various Teradata Macros in SQL Assistant for to serve the analysts.
• Created several BTEQ scripts involving derived tables and volatile/Global temporary tables for adhoc purpose to extract data for several business users on scheduled basis.
• Involved in the collection of statistics on important tables to have better plan from Teradata Optimizer.
• Did the performance tuning of user queries by analyzing the explain plans, recreating the user driver tables by right primary Index, scheduled collection of statistics, secondary or various join indexes.
• Created Query Prompts, calculations, Conditions & Filters. Developing Prompt pages and Conditional Variables. Involved in Testing and improving Report Performance.
• Involved heavily in writing complex SQL queries based on the given requirements such as complex DB2 Joins, Sub Queries, Stored Procedures, and Macros etc.
• Helped Business Users by writing Complex efficient Teradata SQLs to get a detailed for Data Mining. Automated these extract using BTEQ an Unix Shell Scripting.
• Involved in user training and support for data mining and reporting.

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

Confidential

Teradata Developer

Responsibilities:

• Involved in analysis of Extraction, Transformation and Loading ETL process.
• Involved in creation of the mappings between sources and target tables.
• Used different transformation like Expression, Aggregator, Source Qualifier, Sequence Generator, Filter, Router, Update strategy and Lookup Transformations.
• Created reusable transformations, sessions and Batches using Server Manager. Involved in debugging mappings and tuned for better performance.
• Involved in Unit testing as well as Functional testing, Performance Tuning of Queries.
• Created staging Tables, Indexes, Sequences, Views and performance tuning like analyzing tables, proper indexing.
• Identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Writing Reconciliation Queries as per Business Requirements.

Environment: Informatica, Business objects, Oracle 8i, Windows NT, Teradata V2R6.