SUMMARY:

• “Teradata Certified Master” having close to 10 Years of experience in end to end data warehouse designing, logical and physical data modeling, application development and data warehouse implementation using Teradata, Oracle and Informatica.
• Involved in requirement gathering, analysis, design and implementation of various data warehouse applications. Strong in Data Warehousing and Modeling concepts of star schema and snowflakes schema methodologies and implementations of data model in 1st, 2nd and 3rd Normal Forms.
• Hands on experience in Physical implementation of the Data warehouse on Teradata Server for various database versions using slowly changing dimensions and normalization and de - normalization techniques.
• Strong ETL development knowledge using Teradata SQL, Store procedures, BTEQ and utilities like Bteq, MultiLoad, FastLoad, Tpump and TPT.
• Extensive experience in performance tuning of the Teradata SQL queries Confidential high level like database, user and system level, detailed knowledge of Teradata Architecture and database administration.
• Experienced in understanding of UNIX and Mainframe file systems and programming using UNIX shell scripting.
• Experienced in project Management duties including planning, managing of deliverables, tracking of critical path, managing risk, reporting status to project stakeholders, conducting status meetings and distributing minutes, securing and evaluating assigned resources, controlling budget constraints, ensuring completion of scope.
• Very efficient in debugging the issues through database testing using structured quality control techniques.
• Worked on few aspects of QA (Quality Assurance) like preparing Startup documents, Coding standards, Code review checklists etc.

TECHNICAL SKILLS:

Databases and Tools: Teradata (V2R5, 12, 13.xx, 14 and 15), Oracle (9i,10g,11g), SQL Server 2008

ETL Tools: Informatica (7x, 8x and 9x)

Languages: Operating Systems

SQL, PL SQL Unix: Win 9X, 2000, XP,7,10, Unix(Solaris)

Other Tools and Utilities: ERWIN, MVS (Mainframe), TOAD, MS - OFFICE / 2010

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Technology: Teradata 13.10, 14,15, Unix

Onsite lead and coordinator

Responsibilities:

• Physical data modeling review for the new onboarding applications.
• Performing Data Analysis for new DB requirement from the Design and business perspective.
• Performing the Benchmark Test on the upgraded Teradata Servers with the help of Query Driver Tool Developed in Partnership
• Analyzing performance of various Teradata Applications using Bteq, FastLoad and MultiLoad creating Informatica mappings, sessions and workflows.
• Testing and reviewing business report queries and load process to ensure business SLA’s are met.
• Worked on the daily batch support activity of various applications in Wealth management.
• Handling critical production issues and performance tuning of Teradata queries in terms of Spool, High Sleekness, and High CPU in defined SLA’s.

Confidential

Technology: Teradata 13.10, Informatica 8 . 6.1, Oracle 10g, Unix, Toad

Senior technical consultant for Teradata

Responsibilities:

• Requirement gathering from the client.
• Analyzing the business requirement document and preparing the technical document.
• Performing Data Analysis for new DB requirement from the Design and business perspective.
• Performing Logical data modeling and Physical data modeling for various new billing database requirements.
• Developing Teradata Applications using Bteq, FastLoad and MultiLoad creating Informatica mappings, sessions and workflows.
• Testing and reviewing the developed code and ensuring business standard has been followed while coding.
• Working with the Release and Deployment team in doing the UAT code release.
• Worked on the daily batch support activity of various applications in Confidential & Confidential billing environment.
• Handling critical production issues and performance tuning of Teradata queries in terms of Spool, High Sleekness, and High CPU in defined SLA’s.

Confidential

Technology: Teradata 12. Teradata 13, Teradata 14, View Point, Informatica 8.5

Responsibilities:

• Leading Team of 5 Resources, and responsible for in-time deliveries of the various onsite activities.
• Performing LDM’s and PDM’s for various new databases for the client
• Performance Tuning of Queries in terms of Spool, High Skewness and high CPU.
• Providing Performance reviews of the new databases, tables and queries in Testing Environments before Deployments
• Designing ETL flow for various new applications.
• Handling Production environment issues based on the Priority (P1, P2, P3) for aborted queries.
• Handling CR’s for designing Complex queries or rewriting existing queries for performance improvements.
• Proactively monitoring the Teradata Server performance for the reporting users to ensure that each user should get optimized performance.
• Helped peer team members solve technical problems as well as resolving complex queries for optimized performance.

Confidential

Technology: Teradata V2R5, Teradata 12, SQL Server 2005, Oracle, MainframeUNIX Scripting and Informatica 8 .2

Responsibilities:

• Source system analysis
• Development & Testing of an End to End Source to Target (Oracle to Teradata) Load (History/Incremental Strategies) in Informatica
• Performance Tuning of Queries in terms of Spool.
• Production Support in Mainframe and NT Environment to handle abends.
• Handling Production environment issues.
• Documented Development manuals.
• Helped peer team members solve technical problems as well as complex business logics.
• Development / Enhancement of new or existing Applications in GEDW environment.
• Enhancing performance with respect to Teradata and Informatica.

Confidential

Technology: Informatica 7.1.1,Tearadata,Oracle 9i, Unix, Toad

Responsibilities:

• Design the CDC logic for the various Siebel sources.
• Analyzed Soft Delete Issue
• Analyzing the impact of Change request and extension for new design.
• Involved in Design, Development and testing the jobs.
• Documented Checklist- Pre Deployment Check list and Workflow Dependencies.
• Trained peer team to solve complex business logics

Confidential

Senior technical consultant for Teradata

Technology: Teradata, TACT - Compression Tool, ADAPT Tool

Responsibilities:

• Involved in the Creation of the Guidelines Document that involved research on how compression works internally.
• Created the Compression Planning Document that involves analysis of various schedules and runtimes of the tables that are to be compressed to arrive Confidential a feasible deployment window.
• Analysis of the table data using TACT and generation of the New Compressed DDL.
• Preparation of deployment scripts to be executed for implementation of compression on the production server.
• Involved in deploying changes in production and handled issues that arise during implementation.

Confidential

Technology: Oracle 10g, Teradata V2R6.2, Informatica 8.1

Responsibilities:

• Creating Fast export scripts for reading the data from source.
• Analysis verification of the data for the requested business logic by the customer.
• Creating the different Teradata loading utilities scripts like FastLoad and MultiLoad for the loading the data from Staging area to the EDW.
• Coordinating with the On-site coordinator for the various activities.