PROFESSIONAL SUMMARY:

• 8+ years of experience in Teradata V15,V14,V13,V12,V2R6, SQL, Data Warehouse Modeling, Teradata Utilities, Aggregates and building efficient views.
• Good Exposure to Teradata SQL and BTEQ Scripting
• Proficient in Collect Statistics, Database Sizing, Capacity Planning, Database Performance Monitoring, Database Backup/Recovery and SQL Query Tuning
• Proficient in Teradata Database Design (Physical and Logical), Application Support, Performance Tuning, Optimization, User & Security Administration, Data Administration and setting up the Test Development environments.
• Good exposure to Data Warehousing applications, directly responsible for the Extraction Transformation and Loading (ETL) data of multiple formats into Data Warehouse.
• Extensively worked on BTEQ and having good knowledge on utilities including MultiLoad, FastExport, FastLoad, T - pump, and Teradata Parallel Transport
• Used UNIX shell scripts for automating tasks for BTEQ and other utilities.
• Familiar in Creating Secondary indexes, and join indexes
• Experience in Relational Data Modeling and Dimensional Data Modeling
• Hands on experience in developing scalable enterprise applications to the user needs, which serves for Finance, Telecom, Insurance, Retail and Sales.
• Experience in gathering system design requirements, design and write system specifications.
• Good team player with excellent technical and interpersonal skills. Pro-active, self-motivated and able to work independently as well as in team.
• Excellent Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.
• Strong problem solving, analytical, interpersonal skills, written and oral communication skills, and have the ability to work both independently and as a team.

TECHNICAL SKILLS:

Primary Tools: Teradata SQL, Teradata tools & Utilities

Teradata Utilities: BTEQ, FastLoad, MutliLoad, Fast Export, Tpump, SQL Assistant, Teradata Manager, Archive/Restore,configuration/Reconfiguration, Table Rebuild, Teradata Parallel Transport utility(TPT)

Languages: Teradata SQL, SQL, C

Databases: TeradataV2R6.x/ 12.0/13.0/14.0/15.0

Operating Systems: Windows 95/98/NT/2000/XP, Unix

Data Modeling: Erwin4.0/3.5,Logical/Physical/Dimensional/3NF, Star/ ETL, OLAP, ROLAP

Scripting Languages: UNIX Shell Scripting, BTEQ.

PROFESSIONAL EXPERIENCE:

Confidential, Fremont,CA

Teradata Developer

Resposibilities:

• Requirement Analysis, design, documentation and data profiling.
• Communicating with business team and stakeholders.
• Designed and developed various Informatica mappings using transformations.
• Teradata SP/View/BTEQ development and involving in the code review meetings.
• Developed Unix shell scripts to trigger Teradata SP/BTEQ and worked with Teradata Utilities such as Multi Load, Fast Load, Fast Export, BTEQ.
• Integrated IDQ mappings, rules as mapplets within Power Center Mappings.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance tuning and Unit testing of Informatica Sessions and Target Data.
• Testing support including SIT/UAT. Issue tracking and resolution.
• Extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis.
• Troubleshoot problems by checking Sessions and Error Logs, Also used Debugger for complex problem troubleshooting.
• Analyzing production support documents and finding the feasible time to run the jobs.
• Preparation of Production support documents and knowledge transfer to the PS team.
• Preparing production deployment game plan, back out plan, test scripts.
• Supporting production deployment and patching.

Environment: Teradata V15, SFTP, BTEQ, Query man, Multi load, fast export, SQL Tools, UNIX, Windows7.

Confidential, RTP, NC

Teradata Developer

Responsibilities:

• Understanding BRD, Data required document and mapping documents.
• Designed, developed and Unit tested SQL views using Teradata SQL to load data from source to target.
• Involved in requirement analysis, ETL design and development for extracting data from various source systems.
• Responsible for the creation of several Informatica mappings, sessions and workflows to load data from other databases to Teradata database according to the requirement.
• Designed and developed Informatica mappings to perform the Extraction, Transform and Load process by understanding the business requirement from the users and also based on the mapping documents.
• Extensively used various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner, sequence generator, sorter and Rank.
• Involved in writing Teradata SQL bulk programs and in Performance tuning activities for Teradata SQL statements using Teradata EXPLAIN
• Involved in the code review meetings prepared by the teams.
• Used Informatica Debugger to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
• Performance tuning the long running queries.
• Developed processes on Teradata using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata).
• Generated various Reports and Extracts for analysis purposes.
• Used UNIX shell scripts for automating tasks for BTEQ and other utilities.
• Preparation of Production support documents and Knowledge transfer to the PS team.
• Analyzing production support documents and finding the feasible time to run their jobs.

Environment:TeradataV14,BTEQ,TeradataSQLAssistant,Multiload,fastload,fastexport,SQL,UNIX,Windows7, Control-m Scheduling Tool.

Confidential, Smithfield, RI  

Teradata Developer

Responsibilities:

• Communication with business users and analysts on business requirements and analysing the specifications provided by the clients.
• Reviewed mapping documents provided by Business Team, implemented business logic embedded in mapping documents into Teradata SQLs and loading tables needed for Data Validation.
• Interacted with people from various teams in the Project like Oracle/ETL/Teradata DBAs’, Ctrl-m Schedulers, Micro strategy (BI) Reporting etc. to aid in the smooth functioning of the Project flow.
• Work on complex queries to map the data as per the requirements.
• Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and execute the SQL’s on UNIX environment.
• Involved in the code reviews conducted by the teams.
• Worked on deploying solutions using version control systems like Subversion.
• Created UNIX Scripts for triggering the Stored Procedures and Macro’s.
• Created test cases and performed unit testing for the SQL views and documented the Unit testing results and Reviewed the Integration test cases.
• Populate or refresh Teradata tables using Fast load, Multi load & Fast export utilities for user Acceptance testing.
• Production Implementation and Post Production Support.
• Worked with Scheduling team on finding the feasible time to run the jobs.
• Created views based on user and/or reporting requirements.
• Generated various Reports and Extracts for analysis purposes.
• Preparation of Production support documents and Knowledge transfer to the PS team.
• Strong problem-solving, testing, and troubleshooting abilities.
• Performance tuning the long running queries.
• Reduced Teradata space used by optimizing tables - adding compression where appropriate and ensuring optimum column definitions.

Environment:TeradataV14,BTEQ,TeradataSQLAssistant,Multiload,fastload,fastexport,SQL,UNIX,Windows-XP, Control-m Scheduling Tool.

Confidential, Memphis, TN

Teradata Developer

Responsibilities:

• Involved in meetings to gather information and requirements from the business.
• Understanding the business requirements, developing design specifications for enterprise applications using Teradata.
• Reviewed mapping documents provided by Business Team, implemented business logic embedded in mapping documents into Teradata SQLs and loading tables needed for Data Validation.
• Created Macros for triggering the Teradata SQL’s.
• Design, developed and Unit tested SQL views using Teradata SQL to load data from source to target.
• Created BTEQ, Fast export, MultiLoad, TPump, Fast load scripts.
• Created test cases and performed unit testing for the SQL views.
• Documented Unit testing.
• Generated various Reports and Extracts for analysis purposes.
• Used UNIX shell scripts for automating tasks for BTEQ and other utilities.
• Developed Load strategy to populate work and final tables through Unix Jobs.
• Prepared Job scheduling docs and Job Stream List Using Dollar U for code migration to test and production.

Environment:TeradataV13,BTEQ,TeradataSQLAssistant,Multiload,fastload,fastexport,SQL,UNIX,Windows-XP,$U Scheduling Tool.

Confidential, Fort Worth,TX

Teradata Developer

Responsibilities:

• Understanding BRD, Data required document and mapping documents.
• Creation of Data bases and users
• Space and User maintenance on dev machine
• Designing the ETLs and conducting review meets.
• Analyzed Design documents and developed ETL requirement specs.
• Created re-usable objects and shortcuts for various commonly used flat file and relational sources.
• Developed Informatica mappings, mapplets, and reusable transformations to load external data.
• Developed Mappings which loads the data into Teradata tables.
• Created mappings to read parameterized data from tables to create parameter files.
• Involvement in implementation of BTEQ and Bulk load jobs.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata) and SQL*Plus, SQL*Loader (Oracle).
• Involvement in database optimization
• Preparation of Production support document.
• Interacted with people from various teams in the Project like Oracle/Teradata DBAs’, Maestro Schedulers, Spec. Creators, Reporting, Unix etc. to aid in the smooth functioning of the Project flow.
• Exported the data into from UNIX to Mainframe for backup.
• Knowledge transfer to the PS team.
• Developed the triggers to handle history and audit data for production environment.
• Created users, roles, profiles and Objects and system rights.
• Performance changes to allow fast handling of transaction processing related request (plan caching).
• Created Understanding documentation and Release Testing documentation on the tickets handled, and documented the issues found in a central repository.
• Involved in Data mining through Teradata miner.
• Involved in the code reviews prepared by the teams.
• Analyzing production support documents and finding the feasible time to run their jobs.

Environment:TeradataV12,BTEQ,TeradataManager,TeradataSQLAssistant,Multiload,fastexport,SQL, Mainframes, UNIX,Windows XP.

Confidential, St Charles, MO

Teradata Developer

Responsibilities:

• Worked with different Sources such as Oracle, SQL Server and Flat files
• The data that was obtained from various sources were fed into the staging area in Teradata .
• Enterprise wide templates were created for handling SCD, Error handling etc .
• Used Service Request to log in and track the tickets/ service requests.
• Worked in resolving production issues providing apt solutions with tight deadlines and SLA’s.
• Involved in loading of data into Teradata from legacy systems and flat files using complex MLOAD scripts and Fast L oad.
• Extracted data from Oracle database transformed and loaded into Teradata database according to the specifications.
• Involved writing BTEQ scripts for validation & testing of the sessions, data integrity between source and target databases and for report generation
• 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.
• Developed technical design documents (LLD) based on the functional requirements
• Used scheduling tools like DRIFT2K.
• Involved in troubleshoot, debug, fix and test production support issues
• Implemented AGILE methodology for our formal delivery.

Environment: Teradata V12, DRIFT2K, Oracle 9i, Unix, Fload, Mload, TPUMP, BTEQ, SQL Assistant.

Confidential, Denver, CO

Teradata developer

Responsibilities:

• Involved in the analysis of the Issues and proposing the solutions to the client
• Involved in the analysis of test results and documenting the test results.
• Preparing the documents in details which will be shared across the organization
• Create export scripts using Teradata Fast Export Utility.
• Preparing Test cases and Test Data
• Create data manipulation and definition scripts using Teradata BTEQ utility Involved in the analysis and design of the system
• Involved in Testing of the prototype.
• Create load scripts using Teradata Fast Load and Mload utilities Code Reviews and Code walk through of the prototype.
• Create procedures in Teradata SQL.
• Attending corporate meeting for the kick off of major enhancements at corporate level.
• Organizing meeting with the SME’s of the dependent systems when changes are done for the existing system.
• Create UNIX scripts for file manipulation.
• Involved in preparation of architecture and infrastructure documentation.
• Involved in Designing DR process for the ESB application
• Involved in the Weekly issue meeting with the customer.
• Organizing meeting with the department heads when changes are recommended for the existing system for performance improvement.
• Organizing meeting with the team on daily basis.
• Must be able to reverse engineer and document existing code
• Involved in decision making for changing the existing programs for special processing.

Environment:Teradata V2R6,UNIX,BTEQ,Fast load, Teradata Administrator, MultiLoad, TPump, Power, FTP, SFTP

Confidential, Atlanta, GA

Teradata Developer

Responsibilities:

• Involved in database design/preparing SQL scripts to support the larger databases that involves terabytes of data.
• Coordinated with the database team to create the necessary data sources for PSG (Premier Services) and FA (Financial Accounts) using Metadata Utility.
• Involved in the design of complex campaigns for the Business users to accomplish different marketing strategies.
• Coordinated with the test team in the design of test cases and preparation of test data to work with different Channels, setup regency and timeout for the Campaigns.
• Involved in running the batch process for Teradata CRM.
• Creation of BTEQ, Fast export, MultiLoad, TPump, Fast load scripts.
• Worked on complex queries to map the data as per the requirements.
• Developed number of Graphs based on business requirements using various Components such as Partition by Key, Partition by round robin, reformat, rollup, join, scan, normalize, gather, Broadcast, merge etc.
• Designed and implemented stored procedures and triggers for automating tasks in SQL.
• Interacted with technical and business analyst, operation analyst to resolve data issues
• Analyze the current data movement (ETL (Informatica)) process and procedures.
• Used Data profiler to allow the analysis of data directly in the database, which improves performance, while eliminating the time and costs of moving data among databases.
• Identify and assess external data sources as well as internal and external data interfaces
• Created and updated MS Excel mapping document by doing field level analysis and field mapping.

Environment: Teradata V12, BTEQ, Teradata Manager, Teradata SQL Assistant, FastLoad, MultiLoad, Fast Export, Control-M, UNIX.

Confidential, Richmond,VA

Teradata developer

Resposibilities:

• Understanding BRD, Data required document and mapping documents.
• Creation of Data bases and users
• Space and User maintenance on dev machine
• Involvement in implementation of BTEQ and Bulk load jobs.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata) and SQL*Plus, SQL*Loader (Oracle).
• Involvement in database optimization
• Preparation of Production support document.
• Knowledge transfer to the PS team.
• Developed the triggers to handle history and audit data for production environment.
• Created users, roles, profiles and Objects and system rights.
• Performance changes to allow fast handling of transaction processing related request (plan caching).
• Involved in the code reviews prepared by the teams.
• Analyzing production support documents and finding the feasible time to run their jobs.

Environment: Teradata V2R6, SFTP, BTEQ, Query man, Multi load, fast export, SQL Tools, PL/SQL, UNIX, Windows XP.