EXPERIENCE 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 12/13/13.10/14.0/14.10/15/15.10 .
• 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 workload balancing concepts like TASM worked with various user groups and developers to define TASM workloads, exceptions, implemented filters, and 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.
• Experience in development of Big Data projects using Hadoop, HDFS, Map Reduce, Hive, Sqoop, Hue, HBase, Pig and Oozie. Expertise in implementing Map Reduce jobs of Big Data Hadoop in Java.
• 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 and 12/13/13.10/14.0/14.10/15/15.10 , 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 Designing and implementing disaster recovery plans.
• Performed backup and recovery of Teradata databases using Arc utility.
• Proficient in converting logical data models to physical database designs in Data warehousing Environment and in-depth understanding in Database Hierarchy, Data Integrity concepts and Data Analysis.
• Very good understanding of Reporting tools like Micro Strategy and Business Objects.

TECHNICAL SKILLS:

Data Warehousing: Teradata V15.10/V15/V14.10/V14/V13/V2R12/V2R6, Oracle 11g/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, Viewpoint, 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, Atana Suite, 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, ROCKYHILL, CT

Teradata DBA

Responsibilities:

• Proactive monitoring of the system via PMON, TASM and TERADATA VIEWPOINT and addressed the problem causing issues to provide better batch/user experience.
• 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.
• 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.).
• Create and maintain backup and restore jobs on TARA and NETBACKUP.
• Addressed system issues by notifying and directing application users for temporary workarounds (turning on diagnostics or instructing onsite Teradata personnel to modify dbscontrol flags).
• Create and modify Indexes to improve performance of Batch and reporting applications.
• Extensively uses Explain to fine tune Teradata tables and improve performance.
• Involved in data modelling to map the data elements from source systems to the data warehouse.
• Automated statistics collection and table clean-up process using metadata driven approach.
• Adhoc SQL programming and reporting using Teradata SQL assistant.
• Implemented block level compression with query banding to compress cold data.
• Created various SQL Queries for data extraction and transformation. Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
• 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.
• Working on Database entities like packages, stored procedures, functions, macros and queries in Teradata SQL Assistant tool.
• 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.
• Creating the tables and its corresponding views with security to get them accessed to the end user and ETL.
• Performing Code Reviews to enforce the project coding standards.
• Attend monthly calls with TGS to review incidents/monthly outages and maintenance activities and DR’s.
• Provided fixes for any failures in Live by raising Emergency Change Controls.
• Worked as a member of the Big Data team for deliverables like design, construction, unit testing and deployment.
• Loading data from large data files into Hive tables.
• Initial setup to receive data from external source.
• Designed and developed Hive job to merge incremental file.
• Involved in writing Map/Reduce jobs using java.
• Importing and exporting data into HDFS and Hive using Sqoop.
• Regulated password expiration, reuse and minimum characters via profiles to adhere to Medco standards.
• Working closely with Developer, QA team and Business for the final release of the applications.

Environment: Teradata V15.10, V15, V14.10, V14 SQL Programming, UNIX Shell scripts, BTEQ, Fastload, Multiload, SQL assistant, Teradata Manager, Erwin Data modeler, Atana suite.

Confidential, Riverwoods, IL

Teradata DBA

• 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.
• Developed and implemented hive custom UDFs involving date functions.
• Implemented Pig scripts and used Skewed, replicated and merge Joins for performance improvements. 
• Designed and implemented stored procedures and triggers for automating tasks in SQL.
• 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/V14, Teradata Viewpoint, SQL Assistant, BTEQ, FastLoad, FastExport, Multiload, 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, Dallas, TX

Teradata DBA

• 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

Teradata Developer / DBA

• 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.
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
• Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
• 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 V2R5, Oracle9i, Teradata Priority Scheduler, Teradata SQL Assistant, FastLoad, MultiLoad, Teradata Administrator, BTEQ, MVS, UNIX, DB2, COBOL.