SUMMARY

• 7+ Years of total IT experience and Technical proficiency in the Data Warehousing involving Business Requirements Analysis, Application Design, Data Modelling, Development, testing and documentation.
• 7 Years of experience in Teradata Database design, implementation and maintenance mainly in large scale Data Warehouse environments, experience in Teradata RDBMS using FastLoad, MultiLoad, TPump, FastExport, Teradata SQL Assistance, Teradata Parallel Transporter and BTEQ Teradata utilities.
• Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
• Certified Teradata consultant with experience in Teradata Physical implementation and Database Tuning, technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Technical expertise in ETL methodologies, Informatica 6.0/6.1/6.2/7.1/8.6 - Power Center, Power Mart, Client tools - Mapping Designer, Workflow Manager/Monitor and Server tools - Informatica Server Manager, Repository Server Manager, and Power Exchange.
• Analyzed, Designed and documented requirements for data migration projects between numerous source Legacy/Oracle application feeds and the new Teradata platform.
• Extensive database experience and highly skilled in SQL in Oracle, MS SQL Server, Teradata, Sybase, Mainframe Files, Flat Files, MS Access.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling.
• Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers.
• Expertise in Query Analyzing, performance tuning and testing.
• Experience in writing UNIX korn shell scripts to support and automate the ETL process.
• Experience in different database architectures like Shared Nothing and Shared Everything architecture.
• Very good understanding of SMP and MPP architectures.
• Experience in Tableau software.
• Exclusive knowledge in Identification of User requirements, System Design, writing Program specifications, Coding and implementation of the Systems.
• Excellent communication and inter personnel skills, Proactive, Dedicated and Enjoy learning new Technologies and Tools.
• Strong commitment towards quality, experience in ensuring experience in ensuring compliance to coding standards and review process.

TECHNICAL SKILLS

DATABASE: Teradata V2R4 / V2R5 / V2R 6 / 12/13.10/14.10 , DB2, Oracle 7.x / 8.x / 9.x, MS Access 2000.

ETL TOOLS: DataStage 7.5.1 / 7.1 / 6.0 , Abinitio (Co-op 3.0), Informatica

REPORTING TOOLS: Business Objects 6.x / 5.x, Seagate Crystal Reports 6.x / 5.x / 4.x / 3.x, SQR 6.x, Forms 6i, Reports 6i, and MS Access Reports.

PROGRAMMING: PL/SQL, VBA, UNIX Shell Scripting, Teradata SQL, ANSI SQL, Transact SQL, C

O/S: NCR UNIX 00 / 5500, Sun Solaris 2.6 / 2.7, HP-UX, IBM AIX 4.2 / 4.3, MS-DOS 6.22, Novell NetWare 4.11 / 3.61.

PROFESSIONAL EXPERIENCE

Confidential, Lake Forest, IL

TERADATA/ETL CONSULTANT

Responsibilities:

• Migration project from DB2, Oracle toTeradata13.10
• Responsible and involved in Setting up theTeradatadatabase, users, Roles and Profiles
• Responsible for Architectural Solutions for the applications on theTeradatasystem.
• Used Erwin data Modeler for Data Modeling and using Star Schema, Snowflake Schema, Fact and Dimension tables, Physical and Logical data modeling for Data Warehousing and Data Mart.
• Responsible in interacting with the users and helping in writing proper sql and opportunities in tuning improvements.
• Proactively and periodically check with the users for issues and upcoming tasks.
• Responsible for capacity planning of the DWH and plan road map for the growth.
• PrimaryDBAfor Performance tuning and recommendations for applications.
• Worked with various user groups and developers to define TASM Workloads, developed TASM exceptions, implemented filters and throttles.
• Monitored database space, identifying tables with high skew and working with data modeling team to change the primary index on tables with high skew.
• Worked on Informatica Advanced concepts & also Implementation of Informatica Push down Optimization technology and pipeline partitioning.
• Performed bulk data load from multiple data source (ORACLE 8i, legacy systems) to TERADATA RDBMS using BTEQ, Multiload and FastLoad.
• Used various transformations like Source qualifier, Aggregators, lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, Sorter, Normalizer, Stored Procedure, Union etc.
• Used Informatica Power Exchange to handle the change data capture (CDC) data from the source and load into Data Mart by following slowly changing dimensions (SCD) type II process.
• Used Power Center Workflow Manager to create workflows, sessions, and also used various tasks like command, event wait, event raise, email.
• Implemented various Teradata Manager Alerts. Involved in setting up alters to page DBA for events such as node down, AMP down, too many blocked sessions, high data skew, etc.
• Worked on capacity planning, reported disk and CPU usage growth reports using Teradata Manager, Viewpoint, DBQL, and Resusage.
• Analyzing & Validating the source data, and design source to target mapping, transformation logic, document the approach and scripts, database layout.
• Work with developers to promote their code and solve day to day issues.
• Produced documentation and procedures for best practices inTeradatadevelopment and administration.
• Developed pro- active processes for monitoring capacity and performance.
• Performed implementation analysis for Capacity on Demand (COD), CPU limits and Resusage monitoring.
• Worked with various user groups and developers to define TASM Workloads, developed TASM exceptions, implemented filters and throttles as needed basis.
• Monitoring database space, Identifying tables with high Skew, working with data modeling team to change the Primary Index on tables with High skew.
• Implemented variousTeradataalerts using Alert facility inTeradataManager.
• Involved in setting up alters to pageDBAfor events such as node down, AMP down, too many blocked sessions, high data skew etc.
• Involved in database upgrades, TTU client software upgrade.
• UsedTeradataManager collecting facility to setup AMP usage collection, canary query response, spool usage response etc.
• Worked on capacity planning, reported disk and CPU usage growth reports usingTeradata Manager, DBQL, and Resusage.
• Writing UNIX shell scripts for automating common tasks.

ENVIRONMENT: Teradata 13 and 14, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, FLOAD, FASTEXPORT, Erwin Designer, Informatica 8.1, Cognos, Tableau, UNIX, Korn Shell scripts, SAP BW, ECC, Teradata Analytics for SAP.

Confidential, Jacksonville, FL

Sr. Teradata Developer

RESPONSIBILITIES:

• Understanding System loads and distribution of workloads using Viewpoint heat maps.
• Actively involved in the TASM workload management setup across the organization. To define TASM Workloads, developed TASM exceptions, implemented filters and throttles as needed basis.
• Backup and Recovery Operations Using Net-Backup & TARA.
• Complete Teradata access requests (new users, password resets, password unlocks and user deletion) as required, following agreed processes. Responsible for Architectural Solutions for the applications on the Teradata system.
• Participating in Data migration activities between development and production environments
• SQL Tuning based on the CPU and Performance reports extracted from DBQL and PDCR.
• Used ER data Modeler for Data Modeling and using Star Schema, Snowflake Schema, Fact and Dimension tables, Physical and Logical data modeling for Data Warehousing and Data Mart.
• Responsible in interacting with the users and helping in writing proper sql and opportunities in tuning improvements.
• Proactively and periodically check with the users for issues and upcoming tasks.
• Responsible for capacity planning of the DWH and plan road map for the growth.
• Expertise in implementing complex Business rules by creating robust mappings, mapplets, and reusable transformations using Informatica Power Center and Power Mart.
• Work with developers to promote their code and solve day to day issues.
• Monitoring database space, Identifying tables with high Skew, working with data modeling team to change the Primary Index on tables with High skew.

ENVIRONMENT: TD 12/13, Teradata Viewpoint, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, PMON, Teradata Arc main, Informatica 8x, UNIX.

Confidential, ST. LOUIS, MO

TERADATA CONSULTANT

RESPONSIBILITIES:

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Used Teradata utilities FastLoad, MultiLoad, TPUMP to load data
• Wrote BTEQ scripts to transform data
• Wrote FastExport scripts to export data
• Wrote, tested and implemented Teradata FastLoad, MultiLoad and BTEQ scripts, DML and DDL.
• Constructed Korn shell driver routines (write, test and implement UNIX scripts)
• Wrote views based on user and/or reporting requirements.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Worked with various user groups and developers to define TASM Workloads, developed TASM exceptions, implemented filters and throttles.
• Monitored database space, identifying tables with high skew and working with data modeling team to change the primary index on tables with high skew.
• Performance tuned and optimized various complex SQL queries.
• Wrote many UNIX scripts.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Gathered system design requirements, design and write system specifications.
• Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Worked on data warehouses with sizes from 30-50 Terabytes.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements

ENVIRONMENT: Oracle, Teradata, Teradata SQL Assistant, SQL, VSS, Outlook, Datastage, Informatica 8x, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, TDWM, PMON, DBQL

Confidential, ATLANTA

TERADATA CONSULTANT

RESPONSIBILITIES:

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Responsible and involved in Setting up theTeradatadatabase, users, Roles and Profiles
• Responsible in interacting with the users and helping in writing proper sql and opportunities in tuning improvements.
• Wrote, tested and implemented Teradata FastLoad, MultiLoad and BTEQ scripts, DML and DDL.
• Constructed Korn shell driver routines (write, test and implement UNIX scripts)
• Worked with various user groups and developers to define TASM Workloads, developed TASM exceptions, implemented filters and throttles.
• Backup and Recovery Operations Using Net-Backup & TARA.
• Participating in Data migration activities between development and production environments
• SQL Tuning based on the CPU and Performance reports extracted from DBQL and PDCR
• Involved in setting up alters to pageDBAfor events such as node down, AMP down, too many blocked sessions, high data skew etc.
• Involved in database upgrades, TTU client software upgrade.
• Work with developers to promote their code and solve day to day issues.
• Monitoring database space, Identifying tables with high Skew, working with data modeling team to change the Primary Index on tables with High skew.

ENVIRONMENT: Teradata V2R6, Teradata SQL Assistant, SQL, VSS, Outlook, Datastage, Informatica 8x, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, TDWM, PMON, DBQL

Confidential

Teradata Developer

RESPONSIBILITIES:

• Designed the ETL Architecture for oracle data extraction and loading the Teradata base tables.
• Played a major role in selection of Teradata load utilities based on the nature of data.
• Responsible for coding and executing SQL scripts for Oracle data extraction.
• Solely Responsible for Source data analysis and formulation of extract strategy
• Contributed in preparation of ETL specifications for partial subject areas by continual interaction with data modeler.
• Suggested data type and other table modifications to physical and logical GRM model.
• Created of staging tables and Test base tables for enhancements to the physical model.
• Created Bteq scripts with data transformations for loading the base tables.
• Standardized the ETL scripts catering to error table handling process and load statistics collection as per the organizational IT standards.
• Documentation of scripts, specifications and other processes.
• Responsible for testing and fixing all issues arising from data validation process.
• Loading staging tables on Teradata and further loading target tables on Teradata via views.
• Creating load process to perform aggregations and load base tables.

ENVIRONMENT: Teradata V2R5, Oracle8i, Teradata Priority Scheduler, Teradata SQL Assistant, FastLoad, MultiLoad, Teradata Administrator, BTEQ, MVS, UNIX, DB2, COBOL.