SUMMARY

• Over 7 years of experience in design, development, implementation, testing, maintenance and administration of Teradata database.
• Experienced on Teradata Database Architecture, Database Features and Teradata tools and also worked on Teradata Database Internals Parser, Optimizer and the Amp modules.
• Worked inmigration ofTeradata12 toTeradata13 and Teradata13.10toTeradata14.
• Experience in using Teradata tools and utilities like BTEQ, SQL Assistant, TSET, Teradata Administrator, Teradata Manager, Teradata Workload Analyzer, Teradata Visual Explain, Teradata Index Wizard, Teradata Statistics Wizard, FastLoad, MultiLoad, TPump, FastExport, and Vproc Manager.
• Designed, developed, tested and supported Extract, Transform and Load (ETL) processes necessary to load and validate data warehouse using UNIX shell scripting.
• Well versed knowledge on SQL scripts on various Relational Databases.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Experience and knowledge in Teradata database installations, version up gradations, database maintenance activities like Archive/Recovery operations, user and database creations, creating and managing user accounts, monitoring the SQL queries, monitoring the database status, identifying the CPU, I/O usage, identifying blocking sessions, locks, amp downs.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning.
• Experience working on performance tuning and optimization of Teradata queries.
• Good knowledge on File - AID and CA7 scheduler.
• Experience in Autosys for creating JIL files and Monitoring jobs.
• Having Expertise knowledge in Teradata and has good exposure on other databases like Mainframe DB2.
• Quick learner and keen observer, determining external & internal customer needs and well versed in internal & external relationship building. Good team worker and like to be part of a team, which always tries to explore out of box.

TECHNICAL SKILLS

Programming Languages: C, Data Structures, SQL, Shell scripting, COBOL

Databases: Teradata 13.10/14.00/14.10/15.00

Teradata Load and Unload Utilities: Fast load, fastexport, Multiload, TPUMP, TPT

Database Administration Tools: Index Wizard, Query scheduler, Workload analyzer, Viewpoint

Query mgmt tools: Bteq, Sql assistant

ETL Tools: Informatica power center 9.1

Administrator tools: Teradata Manager, Teradata Administrator

Operating Systems: UNIX, LINUX and Windows

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Senior Teradata Developer

Responsibilities:

• Interacted with the users, Business Analysts for collecting, understanding the business requirements.
• Prepared business requirement documents and reviewed with Clients, downstream application teams and users.
• Create standard abbreviation documents for conceptual, logical, physical and dimensional data models.
• Created/EnhancedTeradataStored Procedures to generate automated testing SQLs.
• Create conceptual, logical, physical and dimensional data models.
• Document conceptual, logical, physical and dimensional data models.
• Extensively worked on the Performance Tuning of mappings, ETL Procedures and process.
• Designed and developed various components usingstored procedures.
• Create procedures inTeradataSQL.
• Different types of Data Loading (Direct, Incremental and SCD Type2) implemented using Teradata client tools i.e. BTEQ, FLOAD, TPT, MLOAD scripts and used configuration files.
• Prepared combine High level and Low level design document for all the applications.
• Involved in creating scripts and JILs as per the design documents.
• Involved creating the tables in Teradata and setting up the various environments like DEV, SIT, UAT and PROD.
• Prepare Unit test case document and perform Unit testing and Integration testing.
• Coordinate with up-stream and downstream application owner to process and make available the required source data for testing.
• Unit testing of the changed/new code.
• SIT and UAT testing of the changed/new code.
• Involved joint working session with LOBs and reviewed the results after each level of testing.
• Involved in CAB activities and release planning to move the components.
• Deployed the components into production using support teams.
• Pre-Production execution and compared the results with existing production results.
• Joint working session with LOBs and reviewed and validated the pre-production execution results.

Environment: UNIX scripts, Teradata Data Mover, Autosys Scheduler Tool, IXP Tool, Teradata SQL Assistant 13.0, 14.00.

Confidential, Newport, NJ

Senior Teradata Developer

Responsibilities:

• Performed analysis of complex business issues and provided recommendations for possible solutions. Writing SQL queries, reports, and used systems to do analysis based on data metrics and facts in order to provide recommendations.
• Focus on providing an environment for adhoc and standard business analytics. As a developer my work surrounds creation of scripts as bteq and mloads.
• In the project R12 we are required to make changes in the currency translation logics.
• Creation of jobs that extract data from ERP bring it to EDW, process and modify them as per requirement
• Provided training on current systems, processes, upgrades and new software implementations.
• The project Provides common framework to bridge between Non ERP applications and ERP.
• Data is interfaced from source system and Data sets are segmented into universes based on data type (Revenue, Orders, Accounts Receivable, Finance, etc.)
• End users utilize Business Objects (BO) as a reporting and information delivery tool. I also took care of BO Reports changes as well as BODI Jobs creation.
• Involved in many JIRA’s related to Fixed Assets.
• Worked with the new features of Teradata 14 like using Regular Expressions, Columnar, Auto Stats collection and temporal.
• Worked with joins, sub queries, set operations extensively.
• Involved in performance tuning of bteq scripts at various levels in Revstream. Revstream was a project that involved changing the source from VSOE columns to Revstream columns that would help in better Revenue Management Platform.
• Prepared BTEQ import, export scripts for tables.
• Written BTEQ, FAST LOAD, MLOAD scripts.
• Prepared FAST EXPORT script for tables.

Environment: Teradata 13, Teradata SQL Assistant, Teradata Manager, UNIX, Scripts, BO Reporting.

Confidential, Bowie, MD

Teradata Developer

Responsibilities:

• Involved interactively with the business units to understand the requirements and gather the feedback during the design, development and testing of solutions.
• Extracted the data from various data source systems into the Landing Zone area by creating the Informatica mappings using the Teradata fast Loader Connections.
• Wrote SQL Queries as part of Data validation in the Target tables.
• Created the Scripts to process the business logic from the Landing Zone to the Common Staging Area (CSA).
• SQL statements with sql extensions, which will be used in Database transformations to extract the data from different source tables and to load into the target table.
• Database, Datasets, Transform, FTP and Sort to build Graphs in GDE.
• Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates.
• Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.
• Worked on utilities like FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.
• Created mapplets and reusable transformations.
• Creating sessions and batches to run with the logic embedded in the mappings using Informatica Power Center Workflow Manager.
• Conducting debugging sessions and fixing invalid mappings.
• Designed and developed UNIX Scripts to automate the tasks.
• Used the different types of transformations in Informatica such as Source Qualifier, Look up, Router, Joiner, Union, Aggregator etc.
• Created necessary Repositories to handle the metadata in the ETL process.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Done the Unit testing after successfully loading the data into Landing Zone (LZ) area.

Environment: Informatica Power Center 9.1, Teradata 13.10, TPT, BTEQ, Teradata SQL Assistant, Flat Files, Toad, SQL, PL/SQL, UNIX Scripting, MLOAD, FASTLOAD, TPUMP.

Confidential, Tinto Falls, NJ

Teradata Developer

Responsibilities:

• Interacted with business users, analysts to gather, understand, analyze, program and document the requirements of Data Warehouse.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Understood the business requirements with extensive interaction with users and reporting teams and assisted in developing the low level design documents.
• Using Sequence generator for Surrogate keys in the dimensions to reduce the complexity and for improving the performance of composite keys.
• Worked on Workflow Manager to Schedule the workflows and run the sessions according to job dependency.
• Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
• Uploaded data from operational source system (Oracle 8i) to Teradata.
• Used utilities of FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.
• Imported Metadata from Teradata tables.
• Implemented Change Data Capture (CDC) using Power exchange.
• Prepared BTEQ scripts to load data from Preserve area to Staging area.
• Worked on Teradata SQL Assistant querying the source/target tables to validate the BTEQ scripts.
• Involved in peer to peer reviews.
• Troubleshoot the issues by checking sessions and workflow logs.
• Conducting debugging sessions and fixing invalid mappings.
• Created the Data Flow Diagrams to check the dependency.
• Involved in DBMS developments include building data migration scripts using Oracle SQL*LOADER and UTL packages.
• Wrote Unix Shell scripts to automate workflows.
• Developed unit testing, systems testing and post-production verification.
• Involved in writing the test cases and documentation.
• Involved in extensive Performance tuning by determining bottlenecks at various points like targets, sources and systems. This led to better session performance.
• Participated in weekend reviews with team members and Business People.

Environment: Informatica Power Centre 9.1, Oracle 10g, Teradata 13.10, TPT, BTEQ, Teradata SQL Assistant, Teradata V2R6, FASTLOAD, Windows 2000.

Confidential

Teradata Developer

Responsibilities:

• Involved in understanding the Requirements of the End Users/Business Analysts and Developed Strategies for ETL processes.
• The project involved extracting data from various sources, then applying the transformations before loading the data into target (warehouse) Stage tables and Stage files.
• Worked on Informatica power center tools-Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer.
• Created the mappings using transformations such as the Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
• Configured the source and target database connections using .dbc files.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• 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.
• Adapted Agile software development methodology to ETL the above data marts.
• Created mapping documents from EDS to Data Mart. Created several loading strategies for fact and dimensional loading.
• Designed the mappings between sources (external files and databases) to Operational staging targets.
• 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.
• Did the performance tuning for Teradata SQL statements using Teradata Explain command.
• Created .dml files for specifying record format.
• Analyzed the Data Distribution and Reviewed the Index choices.
• Tuning of Teradata SQL statements using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes.
• Extensively worked under the UNIX Environment using Shell Scripts.

Environment: Teradata RDBMS, BTEQ, FastLoad, MultiLoad, Fast Export Teradata Manager, Teradata SQL Assistant.

Confidential

Teradata Developer

Responsibilities:

• Working on the tickets raised by the development team.
• Allocating the space for DEV tables.
• Deallocating the space from the DEV tables.
• Sending email notification to the teams for reminding the table deletions or extensions.
• Providing the different levels of access to DEV tables based on the requests.
• Attending meetings with clients.
• Loading the development environment space details into the database.

Environment: Teradata SQL Assistant 12.0, MYSQL.