SUMMARY

• Over 12+ years of experience in Enterprise Data Warehouse (EDW/ADW), Data Mart and 5 + years in Teradata Admin/DEV.
• Teradata Certified Professional in V2R5.
• Teradata Certified Implementation Specialist V2R5.
• Experience working with clients of financial and Banking Clients
• Good Experience in Data modeling and Design and Architecture of Enterprise Data Warehouse and Data Marts
• Strong Experience in Development, Implementation and support of the Full Life cycle of Data warehouse projects.
• Used Informatica features to implement Type II, III changes in slowly changing dimension (SCD) tables.
• Developed Teradata12.0 features such as PPI, Character PPI, and Timestamp PPI.
• Expert DBA skills in Teradata DBMS Administration, development and production DBA support, use of Teradata Manager, FASTLOAD, MULTILOAD, TSET, TPUMP, SQL, ARCMAIN, VIEWPOINT for workload management.
• Experience in planning and coordinating Disaster recovery solution for Teradata
• Working with BUSINESS OBJECTS/TABLEAU Team to optimize various report run times by applying various TD performance techniques such as Partitioning, JIs, AJIs, USI and NUSI.
• Implemented various Teradata recommended best practices while defining Profiles, Roles, Alerts, Teradata Data Mover, and Net Backup.
• Teradata SQL troubleshooting and Performance tuning of scripts given by Analysts and developers.
• Created PPI for some of the monthly and daily tables to have a good performance on range queries with date constraints. Also created NUSI on PI column for the PPI tables have a good performance on queries with PI access.
• Implemented ETL level collection statistics for the Indexes and for some of the columns going to be involved in the constraints or join conditions.
• Responsible for the design and implementation of the entire DW Dimensional Model architecture using Join Indexes and Partitioned Primary Indexes to achieve and exceed the desired performance.
• Generated a Capacity management reports on analyzing the Spool/CPU/I/O/Usage resources and proactive monitoring to meet performance and growth requirements on PDCR Database.
• Having good experience in writing shell scripting.
• Modification of views on Databases, Performance Tuning and Workload Management. Maintenance of Access Rights and Role Rights, Priority Scheduling, Dynamic Workload Manager, Database Query Log, Database Administrator, Partitioned Primary Index (PPI), Multi - Value Compression Analysis, Usage Collections and Reporting of ResUsage, AmpUsage, Security Administration Setup etc. and leading a team of developers for workaround with different users for different, complicated and technical issues.
• Strong experience in ETL Tools like Informatica 6.2/7.1.3/8.1, Talend

TECHNICAL SKILLS

Database: Teradata V13,V12, Teradata V2R5, V2R6, DB2, Oracle,MySQL,Oracle Express,Sybase

Reporting Tool: Business Objects 5.0/XIR2, Crystal Reports, Tableau

ETL: Informatica 5.1/6.1/7.2/8.0/9.0, Talend, TD ETL Mload, Fload, Xport, Bteq, Tpump, SQL.

Modeling Tools: Erwin and Sybase Power designer

Operating Systems: Windows 2000, SUSE 11 LINUX, UNIX: Sun Solaris, HP-UX

Methodologies: Business Process, Relational Data Modeling, Logical Data Modeling, SQL Assistant, and Physical Database Design, Power Designer 16, Teradata Utilities, Visual Explain, Workload Manager, Teradata Visual Explain, Teradata Manager & Administrator, ETL Design, Database Architecture. ETL Architecture.

PROFESSIONAL EXPERIENCE

Confidential - Austin, TX

Technical Architect

Responsibilities:

• Designing and Developing the ETL Architecture and restructuring the reporting layer.
• Designing and Developing of Physical Data model and Logical Data model for the Teradata DB.
• DBADMIN for Teradata DB
• Designing the ETL Architecture and merging with the Existing model
• Creating Bteq scripts and also the Talend jobs for ETL.
• Development of Tableau reports from the UNICA logs.
• Loading the UNICA logs to the Teradata using the Talend ETL
• Automating the loading process using Unix shell scripts and scheduling in cron
• Performance tuning the Bteq and Talend jobs.

Environment: Teradata V12, Talend, Tableau, Linux, Toad, PL/SQL Developer, BTEQ, MLOAD, FLOAD, FASTEXPORT, UNIX, UNIX Shell scripts.

Confidential -San Jose, CA

Technical Lead

Responsibilities:

• ETL Design and Development of Mappings in Informatica
• Designing and Developing of Physical Data model and Logical Data model in Teradata DB.
• Development of the BTEQ’s to handle the Huge data to Transform
• Performance tuning in the BTEQ scripts.
• DB admin for Deployment and support.
• Developing loading strategies for Sales force from Teradata and vice versa.
• Scheduling the jobs in the UC4
• Creating the shell scripts for the monitoring and alert mechanism.
• Creating PI and NUPI for the Tables with JI and API for the reporting.
• Creating the Reusable Code for Automated loading of the flat file to Teradata using the Fast load utility
• Used FLOAD, MLOAD and other Teradata Utilities.

Environment: Teradata 13, Informatica 9.1, TDSQL, TDAdmin, Teradata Load utilities, Linux, Sybase Power Designer, Sales force, BTEQ, MLOAD, FLOAD, FASTEXPORT, UNIX, Unix Shell scripts

Confidential - NY

Technical Lead

Responsibilities:

• ETL Design and Development of Mappings in Informatica
• Designing and Developing of Physical Data model and Logical Data model in Teradata.
• Development of the store procedures to process the data
• Performance tuning in the Informatica scripts.
• Teradata admin for Deployment and support
• Developing loading strategies in Informatica and Teradata.
• Scheduling the jobs in the Unix Cron
• Creating the shell scripts for the monitoring and alert mechanism.
• Creating Business objects reports and deploying the same.
• Administrating the user access and reports access in Business objects.

Environment: Teradata, Informatica 9.1, Business objectsXIR2, Unix, Oracle, MLOAD, FLOAD, FASTEXPORT,UNIX, Unix Shell scripts.

Confidential - San Jose, CA

Technical lead

Responsibilities:

• ETL Design and Development of Mappings in Informatica
• Designing and Developing of Physical Data model and Logical Data model in Teradata DB.
• Development of the BTEQ’s to handle the Huge data to Transform
• Performance tuning in the BTEQ scripts.
• Handled huge data of the site tracker log files of omniture
• Handled the loading strategies to load the near future omniture files
• DB admin for Deployment and support.
• Developing loading strategies for Sales force from Teradata and vice versa.
• Scheduling the jobs in the UC4
• Creating the shell scripts for the monitoring and alert mechanism.
• Creating PI and NUPI for the Tables with JI and API for the reporting.
• Creating the Reusable Code for Automated loading of the flat file to Teradata using the Fast load utility
• Used FLOAD, MLOAD and other Teradata Utilities.

Environment: Teradata 12, Informatica 9.1, TDSQL, TDAdmin, Teradata Load utilities, Linux, Power Designer

Confidential - San Jose, CA

Technical Lead

Responsibilities:

• ETL Design and Development of Mappings in Informatica
• Designing and Developing of Physical Data model and Logical Data model in Teradata DB.
• Development of the BTEQ’s to handle the Huge data to Transform
• Performance tuning in the BTEQ scripts.
• Handled huge data of the site tracker log files of omniture
• Handled the loading strategies to load the near future omniture files
• DB admin for Deployment and support.
• Developing loading strategies for Sales force from Teradata and vice versa.
• Scheduling the jobs in the UC4
• Creating the shell scripts for the monitoring and alert mechanism.
• Creating PI and NUPI for the Tables with JI and API for the reporting.
• Creating the Reusable Code for Automated loading of the flat file to Teradata using the Fast load utility
• Used FLOAD, MLOAD and other Teradata Utilities.

Environment: Teradata 12, Informatica 9.1, TDSQL, TD Admin, Teradata Load utilities, Linux, Sybase Power Designer

Confidential - Houston, TX

Project Leader

Responsibilities:

• ETL Design and Development of Mappings in Informatica
• Designing and Developing of Physical Data model and Logical Data model in Oracle DB.
• Handled data model for the Saba - LMS
• DB admin for Deployment and support.
• Creating the shell scripts for the monitoring and alert mechanism.
• Developed Store procedures in Oracle
• Crystal reports are created and also the Reports are merged in the SABA site.

Environment: Oracle, Informatica 9.1, Saba - LMS, UNIX, PL/SQL, Crystal Reports

Confidential - NY

Module Leader

Responsibilities:

• Preparation of Technical Specifications.
• Developing of ETL Mappings
• Job Scheduling
• Unix Shell scripting
• Loading the Data in TLM
• User Acceptance Testing (UAT)
• Reconciliation of Extracted Data
• Creation of schema in Sybase
• Unit Testing and Specification
• Creating the Store Procedures in Sybase
• System Integration Testing
• Created Supporting and handover Documents
• DB2 Admin - IBM DB2 UDB.

Environment: ETL- Informatica 7.1.3, UNIX, Sybase, AutoSys, DB2, Shell Scripting, Business Objects 6.5