SUMMARY

• Over 7 years of experience in system development life cycle including business requirement analysis, Design, Development, Testing and Implementation of Teradata applications in UNIX and Windows environments.
• Experience in Teradata TD13, TD12, V2R6/V2R5/V2R4 and TDM (Teradata Datamover).
• Strong hands on experience using Teradata utilities (SQL Assistant, B - TEQ, FastLoad, MultiLoad, FastExport, TPump, Visual Explain, Query man), Unix Shell (Korn) and Perl scripting.
• Expert in Coding Teradata SQL, Macros and Triggers.
• Developed Mappings and workflows in Informatica to handle complex ETL logic.
• Strong knowledge in Data Warehousing concepts.
• Highly experienced in SQL performance tuning and debugging of existing ETL process.
• Experienced with planning, architecture, and design of Teradata data warehousing and SQL optimization.
• Experienced with Logical and Physical Data Model design process
• Experienced with data modeling, program code development, test plan development, datasets creation, testing and result documentation, analyzing defects, bug fixing.
• Experienced in analyzing the data loaded into an enterprise data warehouse from various source systems.
• Experience in creating SQL functions, stored procedures, triggers, and materialized views to implement business logic of SQL database.
• Advanced SQL skills include use of derived tables, unions, multi-table inner/outer joins and performance tuning.
• Expertise in Primary Index selection for uniform data distribution across the AMP’s and Compressing Columns for efficient utilization of available disk space.
• Familiar in Creating Secondary indexes, and join indexes in Teradata.
• Extensively worked on Database migrating from Oracle to Teradata and also from legacy.
• Experience working with on-shore and Off-shore teams.
• Experience in writing UNIX shell scripts to check the status, space management and performance of the database.
• Well versed in writing UNIX korn shell scripting and Perl scripting.
• Reputation for strong organizational skills, excellent communication skills, dedicated teamwork, attention to details, ability to work under pressure to balance competing priorities and meet deadlines.
• Demonstrate a willingness, interest, and aptitude to learn new technologies and skills.

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, Mo

Teradata Developer

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Involved in the Extraction, Transformation and Loading source files from the data warehouse on Teradata.
• Exported data from source to flat files using FASTEXPORT.
• Worked on TDM to copy data base objects such as tables and statistics from one Teradata Database system to another.
• Using command-line interface of TDM for copying tales between two Teradata Database systems
• Extensively wrote several BTEQ scripts for data manipulations and post session processing.
• Designing MLOAD scripts to load data into multiple tables based on Multiload Layout Labels.
• Used External Loaders like Multi Load, TPump and Fast Load to load data into Teradata database.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Involved in loading of data into Teradata from legacy systems and flat files using complex MultiLoad scripts and Fast Load scripts.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Involved heavily in writing complex SQL queries to pull the required information from Database using Teradata SQL Assistance.
• Collecting statistics and tuning based on UPI, NUPI, USI, and NUSI.
• Worked with Partitioned Primary index tables. Utilized RANGE N and CASE N for partitioning.
• Created a BTEQ script for pre population of the work tables prior to the main load process.
• Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Developed UNIX scripts to automate different tasks involved as part of loading process and scheduling.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Experience in requirement analysis, business analysis, database modeling, design and analysis, issue co-ordination and development with Teradata.
• Optimization of SQL to leverage Teradata parallel architecture.
• Used Transactional Control Transformation for managing the commit intervals in different targets.

Environment: Teradata 13, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, TDM, BTEQ, MLOAD, FLOAD, FASTEXPORT, Quality Center, UNIX, Windows 2000, Shell scripts.

Confidential, San Francisco, CA

Teradata/informatica Developer

Responsibilities:

• Coordinating with the client and gathering the user requirements to create specs.
• Created tables, views in Teradata, according to the requirements.
• Performed bulk data load from multiple data source (ORACLE, legacy systems) to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump.
• 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.
• Developed scripts to load high volume data into empty tables using FastLoad utility.
• Used FastExport utility to extract large volumes of data at high speed from Teradata RDBMS.
• Created proper 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 the factors to create NUSI, created appropriate NUSI for smooth (fast and easy) access of data.
• Created stored procedures in TERADATA SQL Assistant.
• Performance tuning for TERADATA SQL statements using Teradata EXPLAIN plan.
• Reduced Teradata space used by optimizing tables - adding compression where appropriate and ensuring optimum column definitions.
• Created UNIX shell scripts and called them as pre session and post session commands.
• Performed End-to-End testing for the entire ETL and Business Intelligence.
• Designed various ETL documents like Application Design, Application Interface Review document etc. needed as part of the Project deliverables and hierarchies.
• Involved in technical meetings and reviews for new ETL design and development.
• Handled multiple projects end to end on the design and hands-on build of the code.
• Developed Mappings and workflows in Informatica to handle complex ETL logic.
• Used various transformations like Expression, Lookup, Joiner, Filter, Normalizer etc. to perform the process of Extract, Load and Transform effectively in the Mapping Designer.
• Made use of Target Load Plan in the mappings’ design, when multiple pipelines are used to load data into target tables.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Involved in creating both positive and negative test data to cover all business scenarios.
• Involved in developing detailed test plan, test cases and test scripts for Functional and Regression testing.

Environment: TD 12, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, Teradata SQL Assistant, Informatica Power center 8.1.2, SQL Server 2005, Windows XP, UNIX, Sun Solaris 2.6.

Confidential, Cypress, CA

Teradata Developer

Responsibilities:

• Interacted with the Data Analysts for their business needs and analysis of the system.
• Requirements analysis, data assessment, business process reengineering.
• Designed and developed TPT (Teradata Parallel Transporter) scripts to load data from flat files, to target tables in Teradata.
• Developed a bridge interface (BTEQ scripts, FastExport, FastLoad, MultiLoad) for Oracle remediation from Teradata.
• Designed and Developed Korn shell scripts for Teradata applications and bridge interface.
• Supported other ongoing projects: Software Upgrade project from Teradata V2R5.1 to V2R6.2.
• Optimized high volume tables (Including collection tables) in teradata using various join index techniques, secondary indexes, join strategies and hash distribution methods.
• Identified necessary tables and data type conversion in Teradata. Did data mapping at table, field level and validated.
• Design, create and regular tuning of physical database objects (tables, views, indexes) to support normalized and dimensional models.
• Wrote procedures, macros and functions that are frequently used by many Data analysts.
• Wrote the coding standards for the bridge interface (Oracle remediation) and Teradata applications.
• Developed standards for the application users for using Teradata applications.
• Created unit test cases for the Teradata applications and implemented.
• Provided technical support to the team members during the migration.

Environment: Teradata V2R5 and V2R6 (BTEQ, SQL Assistant, Multiload, FastLoad, MultiLoad), Teradata SQL Assistant, Oracle 9i, SQL, PL/SQL, UNIX Shell scripts, Linux 7.1.9.

Confidential

Teradata Developer

Responsibilities:

• Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.
• Supported other ongoing projects: Software Upgrade project from Teradata V2R5.1 to V2R6.1.
• Automated related tasks by developing UNIX shell scripts used to maintain the Core EDW.
• Used EXPORT/IMPORT to do table level and full database de-fragmentation.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Accomplished data movement process that load data from DB2 into Teradata by the development of Korn Shell scripts, using Teradata SQL and utilities such as BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD and Queryman reviewed and improved the design of Extract and Load specifications
• Troubleshoot and created automatic script/SQL generators.
• Helping the Reporting team by providing the teradata queries.
• Fulfilled ad-hoc requests coming from superiors.

Environment: Teradata V2R5 and V2R6, SQL, UNIX, BTEQ, FastLoad, MultiLoad, FastExport, Teradata Queryman, Windows XP/2000.

Confidential

ETL Developer

Responsibilities:

• Involved in analyzing the Business requirements and System specifications to understand the Application.
• Hands on experience in importing the data from source files like flat file using the Teradata load utilities like FastLoad, MultiLoad and TPump.
• Created adhoc reports by using FastExport and BTEQ.
• Involved in loading the data into the warehouse from different flat files.
• Developed various Mappings to load the facts and dimension tables and set the order of the session to effectively utilize the tools ability to load different tables in parallel.
• Responsible for Tuning Report Queries and ADHOC Queries.
• Made modifications as required for reporting process by understanding the existing data model and involved in retrieving data from relational databases.
• Worked on managing queries by creating, deleting, modifying, viewing, enabling and disabling rules.
• Configured rules by ignoring EXPLAIN estimates that are below a specified level of confidence.
• Involved in Database testing by writing and executing SQL queries to ensure that data entered has been uploaded correctly into the database.
• Hands on experience with Teradata Queryman to interface with the Teradata.
• Worked on maintenance, enhancements and break-fix requests.

Environment: UNIX, Informatica Power center, TeradataV2R4, BTEQ, Fast load, Teradata Administrator, Multi load, T pump, Teradata Queryman, Unix Shell Scripting, Perl, Windows 2000/NT.