SUMMARY

• Solutions oriented professional with 10 + years of experience as a Senior Teradata lead Architect in database development, process engineering, and application software development.
• Has significant experience in EDW administration standards, design and integration of heterogeneous systems, scalable data warehousing, and relational database technology for global clients.
• Extensive experience in scalable ETL Architecture design using Industry Best Practices and Standards.
• Experience in Active Data Warehousing or Near Real Time Data Warehousing.
• Expertise in working with Teradata 13.x/12.x/v2r6,x/V2R5.x systems and used utilities like Multi Load, Fast Load, Fast Export, BTEQ, TPump, TPT, SQL Assistant, Teradata Manger, PMON, Teradata Administrator.
• Experienced in producing high level and detailed solution designs, including multi - environment configurations including DR options. Experience in complete system recovery and restore in the event of DR/HA scenarios.
• Hands on experience in the design and implementing of ETL processes and transformation mappings using Informatica 9.x/8.5 / 7.1 / 6.x.
• Strong Data Modeling experience with various modeling approaches such as 3nf and Dimensional data modeling, Star Schema modeling, and Snowflake modeling using modeling tools such as Erwin.
• Experience in implementing Informatica ETL setup and configurations, Informatica Duals loads to Teradata HA/DR environments.
• Extensive experience in Source system analysis, extensive data profiling.
• Extensive experience in implementation of ODS, Staging, 3NF, Relational and Multi-Dimensional Data Warehouse solutions. Experience in designing/developing ETL architecture for Teradata 3nf LDM.
• Implemented Teradata GLDM, Physical modeling and good experience on Data Access paths and Join types and Join strategies.
• Able to work independently and in a team and able to effectively communicate with customers, peers and management at all levels in and outside the organization.
• Team leader, Excellent Interpersonal Skills and self-starter, capable of working independently and motivate a team of professional. Capable to effectively communicate with customers, peers and management at all levels in and outside the organization.

TECHNICAL SKILLS

Database: Teradata 13.x/12.x/v2r6,x/V2R5.x, Netezza 6.x, DB2 UDB v7.x/8.x, Oracle 9.x, SQL Server 2003

ETL/BI tools: Informatica 9.x/8.6/7.x/6.x, DataStage 7.x, AbInitio, Cognos 8.4/7.x

Teradata Utilities: Teradata Manager, Teradata load and systems utility, Teradata View point server. Net Backup 6.5, Teradata TARA, PMON, BTEQ, Teradata Manager, Teradata Administrator, TSET, ARCMAIN, PDCR, TASM,TDWM, Priority Scheduler

Hardware: Teradata 5450, 2650. IBM I series Servers, IBM Netezza P3,P6 & Skimmer

CDC Tools: Omni Replicate1, IBM Data Mirror 4.x

OS: RHEL 4.x/5.x, Suse Linux 9.x,, Windows 2000/2003/XP

Other skills: Data Governance, Data modeling Erwin 7.x, Teradata CRM, TRM/ARM 6.X, Neteeza Admin, client tools

PROFESSIONAL EXPERIENCE

Confidential, Uncasville, CT

Teradata Architect

Responsibilities:

• Implemented CRM DW, EIS, CDI, Teradata/Informtica Dual loads, Teradata HA/Fail setup, Teradata platform migration, BAR conversion projects.
• Planned and managed multiple Teradata major hardware, software installation and upgrade, expansion and migration in HA business environments.
• Created a robust, sustainable EDW Architecture, BI/CRM system architecture that supports requirements and provides expansion capabilities.
• Extensively worked on all Teradata utilities MultiLoad, FastLoad, FastExport, BTEQ, TPUMP, Arcmain, SQL Assistant, TDQM, PMON, Teradata Manager and BakBone NetVault.
• Working with Creation of Databases, tables, indexes (Secondary, Join), statistics, base views.
• In depth understanding of Teradata GLDM, Physical modeling and good experience on UPI, NUPI, PPI, USI, NUSI Data Access paths and Join types and Join strategies.
• Review Explain plans, long running queries for Performance tuning and Optimization.
• Automated various DBA task like disk utilization and space management and collect statistics.
• Effectively implemented the Change Data Capture (CDC) process and Incremental loads all over the projects.
• Involved in performance optimization and optimal use of spool, temporary and permanent space.
• Experience designing and developing ETL design data feeds into a Teradata’ Casino/hotel LDM 3NF data model.
• Responsible for design, development, implementation, monitoring, troubleshooting, and support of data extract, staging, transformation and load procedures to populate and update the data warehouse from the source systems.
• Responsible for the quality, accuracy, currency and validity of the warehouse data.
• Responsible for developing test plans, error routines, auditing thresholds, job schedules, metadata and documentation.
• Responsible for evaluation, installation, configuration, upgrades, testing, trouble-shooting, version control and support of ETL Informatica Servers and CRM application and the TCRM Mid Tier servers.
• Responsible for working with the CRM users to gather requirements for the design and creation of CRM Legends, troubleshoot and resolve problems, and provide instruction to maximize customer utilization and satisfaction.
• Involved in performance optimization and optimal use of spool, temporary and permanent space.
• Experience designing and developing ETL design data feeds into a Teradata’ Casino/hotel LDM 3NF data model.
• Responsible for design, development, implementation, monitoring, troubleshooting, and support of data extract, staging, transformation and load procedures to populate and update the data warehouse from the source systems.
• Closely worked with Teradata GSC support people and CSR to register problems in Teradata at your Service, hardware upgrades and problem resolution issues related to Teradata TRM/ARM application.

Environment: Teradata 13.x/12.x/V2R6.x,Netbackup, TARA, DB2 UDB 8.x/7.x, TRM (Teradata Relation manager), ARM (Aprimo Relation Manager) 6.5. Informatica Power Center 8.6/7.x/6.x, Cognos 7.x/8.x, Omni Replicate1, MIMIX, AS/400, Erwin 4.1, Windows 2000/2003, Oracle 9i, SQL Server 2000.

Confidential, FL

Teradata Consultant

Responsibilities:

• Worked as Teradata Consultant responsible for developing and implementing procedures for Marketing Information Systems (MkIS) Enterprise Data Warehouse project aims at the establishment of the Residential Customer Analytic Database (RCAD) warehouse, which provides a single source of residential customer data across the Confidential footprint.
• Part of aEDW DBA team responsible for the day to day operation of Teradata RDBMS.
• Working with Teradata tools like Multi Load, BTEQ, Fast Export, TPump, OleLoad, SQL Assistant, Teradata Administrator, Teradata Manager, PMON and BakBone NetVault.
• Worked with Creation of Databases, tables, indexes (Secondary, Join), statistics, base views.
• Setup and control access rights using Teradata Roles and Profiles. Allocating and monitoring space usage across various user environments.
• Monitor Teradata application(s) performance using PMON and Teradata Manager.
• Make recommendations for implementing Teradata best practices in place.
• Used Teradata manager and PMON utilities for reviewing, monitoring the overall health and utilization of database system by various users.
• Analyzing the performance parameters with SQL, Joins and use of primary and secondary indices to improve query performance.
• Application performance tuning using explains plans, data dictionary, and data management tools.
• Defining backup and recovery methods for the data warehouse.
• Analyzing and troubleshooting the performance and process problems with developers.
• Worked with NCR personnel to register problems, hardware upgrades and to problem resolution.

Environment: Teradata RDBMS v4.1/5.x, BTEQ, Multi Load, Fast Export, Fast Load, TPump Query Man 6.0, Teradata Administrator, SQL Assistant, F-Secure SSH Data Stage, Network Data Mover (NDM) Erwin.

Confidential

Teradata Developer

Responsibilities:

• Worked extensively with Teradata utilities BTEQ, Multi Load, Fast Load, TPUMP, and Fast Export.
• Monitor and maintain a production Teradata database environment, including runtime optimization, capacity management and planning, security, configuration, scheduling, and execution of maintenance utilities.
• Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to Teradata data warehouse.
• Gather information from different data warehouse systems and loaded into warehouse using Fast Load, Fast Export, Multi Load, BTEQ scripts.

Environment: Teradata V2R4

Confidential, Herndon, VA

Data Warehouse Consultant

Responsibilities:

• Worked with Business Analyst, DBA for requirements gathering, business analysis and Build the infrastructure of the data flow.
• Translated business requirements into Enterprise data warehouse architectural design.
• Extensively Worked on Star Schema, Snowflake Schema and Data Modeling
• Designed and Developed new Data Marts along with modifying existing mart to Support additional business requirements
• Worked on Informatica Power Center 6.1tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Extensive use of Transformation like Expression, Lookup, Aggregator, Joiner and Update Strategy.
• Identifying and resolving performance bottlenecks in various levels like source, target, mappings and session
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager
• Troubleshooting and resolving performance bottlenecks as needed.
• Involved in Migration of project from Development to Production environment
• Participated in the planning and execution of integration test, system test, and user acceptance test activities, including developing and documenting test plans

Environment: Informatica Power Center 6.2/5.1((Source Analyzer, warehouse designer, Mapping Designer, Transformation Developer), Business Objects 5.1/6.1, Oracle 9i, PL/SQL, SQL*Plus, SQL*Loader, SQL Navigator, IBM MAINFRME, COBOL, Erwin 4.0, Windows NT/2000

Confidential, NJ

Informtica /BO Developer

Responsibilities:

• Worked with Business Analyst, DBA for requirements gathering, business analysis and Build the infrastructure of the data flow.
• Extensively Worked on Star Schema, Snowflake Schema and Data Modeling
• Installation and configuration of Informatica power mart Client/server tools
• Configured Informtica tools with appropriate code pages according to the business requirements
• Created upgraded local and global repositories according to the business requirements and registered Informatica server with repository
• Installed ODBC drivers, created ODBC data sources and connections as required.
• Worked on Informatica Source Analyzer, warehouse designer, Mapping Designer and Reusable Transformations.
• Extensive use of Transformation like Expression, Lookup, Aggregator, Joiner and Update Strategy.
• Designed the Universe by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts, and creating objects that are grouped into classes for convenience.
• Setup and maintained user security using Supervisor.
• Universe tuning by creating Joins, Contexts, and Aliases for resolving Loops and checked the Integrity of the Universes
• Created queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
• Provided End-user support and training.
• Import and export reports to and from repository.
• Audited the existing BO Architecture to identify areas to increase performance.
• Tested reports before posting them to the repository (query optimization & performance)

Environment: Informatica Power Mart 5.0 (source analyzer, warehouse designer, mapping designer, transformer developer) Business Objects 4.0(Designer, supervisor), MFG/PRO Eb2, Oracle 8.0, SQL * Plus, PL/SQL, Progress 8.0, Windows NT 4.0, Erwin, SQL Navigator