SUMMARY:

• Teradata Certified Professional with 15 years of Data warehousing experience in design and development of Enterprise Data Warehouse which includes Analysis, Design, Development, Implementation and Testing of Data warehousing applications with focus on Teradata and Informatica platforms.
• Played key role as Technical Lead in delivering large scale projects to production interfacing with cross functional teams end - to-end. Lead a team of both onsite and offshore developers
• Extensive experience in planning, designing, and developing ETL processes using SQL, BTEQ, MLOAD, FastLoad, Informatica PowerCenter, Power Exchange tools.
• Strong performance tuning and troubleshooting skills that are needed to provide solutions to optimize performance bottlenecks both in loading and end user report queries.
• Good understanding of Informatica as well as Teradata Architecture and advanced concepts such as design and development of AJIs, OLAP functions, and PDO. Extensively worked with various business teams gathering requirements and translated them into high level and detailed technical designs.
• Strong communication and presentation skills essential for interacting and building collaborative relationships with various teams.

SKILL:

• Teradata SQL
• Korn Shell Scripting
• PL /SQL
• Teradata SQL Assistant V13.1
• Teradata Utilities (Mload, Fast Load, Fast Export, BTEQ, TPT)
• Informatica 9.1
• Informatica Power Exchange 9.1
• AbInito 3.0
• M for scheduling
• Star Team 2009 for Version and Change Control
• Windows, Unix
• First Logic 7.1
• Teradata
• Oracle

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Teradata Consultant

Responsibilities:

• Lead the effort of separating the loading jobs and data of Confidential and the partner network.
• Redesigned BTEQ scripts and ETL architecture to load the appropriate data separating the Confidential and other Partner Network.
• Redesigned and modified the Loading schedule and the extracts to accommodate the changes.

Confidential, Addison, TX

Technical Lead

Responsibilities:

• Lead the development and deployment of couple of key large scale applications for Chase Card Services consisting of onsite and offshore resources.
• Played key role from design, build, testing to deployment of the application following all the stringent process requirements of Card Services.
• Was responsible for the integration of the Credit Card scoring data (used for approval/decline of applications, prescreening prospects etc.) and the Marketing and Campaign List information to the Teradata Enterprise Data Warehouse (ICDW) Framework model.
• Worked extensively on all phases of the integration project from functional specifications, technical design specifications, build, system test and UAT, using Informatica and Teradata BTEQ as the ETL platforms. Since the scoring data was the first application to be integrated into the Enterprise framework, several common components were standardized for future applications.
• Was also responsible for the design, build and performance tuning of the de-normalized user views for BO reporting.

Environment: Teradata V13.0, Informatica 9.1, Informatica Power Exchange 9.1, Control-m, Unix Shell scripting

Confidential, Plano, TX

Senior Analyst - BI / Data Management

Responsibilities:

• Translated the business requirements into high level and detailed design documents for ETL, load process, automation and scheduling, created unit test cases and field Mapping Documents.
• Designed and developed AJIs (Aggregate Join Indexes) based on reporting needs to improve performance
• Worked extensively on end-user SQL query tuning for better performance
• Improved stats collection techniques on AJIs, core tables, fact and dimension tables
• Designed, and developed customized extracts sourcing from STAR2 core tables and Data marts
• Involved in the requirement gathering phase with the business teams
• Interfaced and Collaborated with various teams such as DBA Team, Informatica Admin Team, Unix Admin Team, Business Run Team, Baseline team and offshore teams throughout the development and delivery of the project
• Developed Informatica mappings and workflows for part of the ETL solution
• Designed and developed efficient error handling processes and audit processes wherever needed based on business requirements
• Designed and developed data marts for various business needs and effectively interfaced with BI reporting teams.
• Designed, developed and automated customer Extracts from the STAR2 data mart
• Worked extensively on creating data validation rules using advanced Teradata SQL concepts.
• Effectively led a team of five people for the development of a crucial Integrated Data mart application which housed both bottler and snack data.
• Extensively worked with loading utilities like BTEQ, MLOAD and FastLoad

Environment: Teradata V13.0, Informatica 8.1, Informatica 9.1, Abinitio 3.0, Borland Star Team 2009, Control-m, Unix Shell scripting

Confidential, Irving, TX

Senior Analyst - Marketing Data Warehouse

Responsibilities:

• Prepared project proposal and was responsible for enhancements and maintenance of the Long Distance Revenue and Usage Data Mart, which consolidates data from diverse account administrative systems into a single data framework to facilitate business reporting.
• Performed detailed Gap Analysis on various systems and provided proposals for the closure of redundant systems.
• Provided solutions for all issues concerning the file loading and setting up load processes.
• Developed and automated the Consumer Fraud Feed process.
• Provided solutions and support for customized Mass Merge Purge process.
• Designed and tested the enhancement of a customized Mass Merge Purge process which accepts data from multiple legacy systems, integrates the data into a standard format and leads to the ability to determine the complete value of a customer.

Confidential, Irving, TX

Data warehouse Senior Developer

Responsibilities:

• Worked on an end-to-end Data Warehouse Project for the Long Distance Integrated Decision Support System, which is a massive data repository for Long Distance data such as the Billing, Provisioning, Order Entry, Fraud and various other systems.
• The normalized database was built on UNIX (SUN Solaris) in Oracle9i. ETL development was done in Informatica Power Center, and data cleansing such as Address-Name Standardization and Merge-Purge was done using First Logic.
• Completed the ETL development of the Order Entry and Provisioning Data marts for the Integrated Data Warehouse, which also included data cleansing and automation. Performed model enhancement, design, development, testing and documentation.
• Worked on Integrating and loading external data into the Data Warehouse using PL/SQL programs and Korn Shell Scripts for job automation
• Worked on Development DBA tasks such as backup and restoration, maintenance, monitoring the cron jobs, and building Test Databases.
• Worked on UNIX Server Administration tasks such as OS backups using Legato Networker, Maintenance of the HP-UX server and the Storage Array (RAID 0+1).
• Migrated a database (Performance Reporting Database) from Informix to Oracle8i.

Confidential

Database developer

Responsibilities:

• Responsible for the design and development of Databases such as Inventory Control System and other utilities for internal use.
• These systems were developed in Oracle 8.0.4 on WindowsNT Platform.
• Created Forms and Reports in Oracle Developer and MS Access. Work also included Database Administration and Maintenance.