SUMMARY:

• 13 years of IT industry experience with Teradata Master encompassing a wide range of skill set, onsite customer facing leadership roles.
• Extensive experience in Teradata 13.X, Teradata V2R12, V2R6, V2R5 Administration, Data Load/Unload utilities like Fast - Load, Multi-Load, Fast Export, TPT, BTEQ, Tpump, Archive/Restore and Teradata administrative tools like Teradata Manager, Administrator, Viewpoint, PMON, TDWM.
• A strong working knowledge on Teradata 13, 12, V2R6/5 Database design (conceptual and physical), ETL Development, Query optimization and Performance Tuning.
• Experienced in Infosphere 8.5 and Datastage 7.1 ETL tools
• Experienced in setting up and analyzing Teradata Active System Management (work-loads, throttles and filters) using Viewpoint.
• Experienced in back-up/restore procedures and building test environments using Netvault, ARCMAIN and Load/Extract/TPT utility based scripts.
• Experienced on Logical - Physical data models conversions, Fine tuning (Performance tuning) teh complex queries and views.
• Extensive experience in Data modeling, Data warehousing, ETL, Data Administration, and excellent skills in SQL coding and UNIX shell scripting.
• Experience in Design/Development of Semantic Layer for BI (MSTR) and In-house reporting tools.
• Experience in Analysis, Design and Development of Data marts for project specific needs.
• Well versed in forward engineering Data models and creating Physical Database schema and objects.
• Consult/Educate database developers providing guidance on Teradata DDL & DML best practices and administer Teradata Database including database-design, tuning, backup, software maintenance, hardware upgrades and application support of databases.
• Worked across all phases of Data Warehouse project life cycle and well versed with concepts of Dimensional modeling, ETL and Business Intelligence.
• Experience in leading/managing technical teams. Handled multiple roles - Database Administrator, Technical Lead, SME, Designer and Developer
• Mentored team members to understand teh system flows, also was part of providing feedback on their performance during yearly assessments.
• Involved in organization specific technical forums and provided solutions for Teradata technical issues.
• Coordinate with Delivery and Project Managers in assigning resources, preparing project schedules/milestones, establishing Quality/SCM procedures and skill development.

TECHNICAL SKILLS:

Operating Systems: Linux, Unix (MPRAS, Solaris, AIX), Windows NT/2k/XP

Programming Languages: Java, C, C++, PL/SQL, SQL, UNIX Korn shell scripting, Perl, Python

ETL Tools: Infosphere 8.5, Ascential Datastage 7.1, TPT Wizard

TeradataV2R12/V2R13.10/V2R6/V2R5,ORACLE: 11g/9i,MS-Access

Modelling Tools: Erwin Data Modeler R7/4.x/3.x, ER Viewer

Teradata Utilities: Multiload, Fastload, Fastexport, BTEQ, TPUMP, TPT and ARCMAIN

DBA/Dev Tools: Teradata Manager 12, Performance Monitor, Viewpoint, Teradata

Administrator, Netvault, Statistics and Index Wizards, WinMVC

Rational Clear: case, Subversion and Team Foundation Server

Rational Clearquest, Quickr,: Rational RPM, MS Project

PROFESSIONAL EXPERIENCE:

Confidential

Teradata Consultant

Job responsibilities:

• Design Semantic model for Team Member/HR subject area to report HR specific metrics. Transformed 3NF model to Dimensional model to facilitate BI tool
• Developed Semantic tables/views in HR space. Analyzed for teh possibility of implementation of Join Indexes in HR space to improve performance.
• Re-Design (For performance improvements) Row Level Security Solution for HR.
• Performance Tuning in SALES/INVENTORY subject areas. Including analysis/identification/improvements of Join Indexes/Aggregate Join Indexes to improve performance.
• Reviewing BI tool specific SQL’s and suggesting improvements to hit teh JOIN INDEXES/PPI’s defined on teh database for better performance, reducing # of SQL passes and tuning inefficient SQL’s.
• Design/Develop FACT (Aggregation/Report specific) tables in SALES/INVENTORY/Presentation space wherever Indexes are not helping performance.
• Design/Develop Initial Load and Incremental Load scripts for FACT(Aggregation/Report specific) tables.
• Analysis and Implementation of Multi Value Compression.
• Proof of Concepts for various recommendations in Performance Tuning phase.
• Analyze DBQL to identify in-efficient SQL’s, resource intensive SQL’s and tune them regularly.

Environment: Teradata 13.10, Infosphere 8.5, UNIX Shell Scripting, SQL, Multiload, Fastload, Fastexport, BTEQ, TPUMP, TPT, Team Foundation Server, Quality Center, TPT Wizard, Teradata SQL Assistant, Teradata Admin, Viewpoint and ERWIN.

Confidential, Orlando, FL

Teradata Consultant

Job responsibilities:

• Utilize in-depth functional and technical experience in Teradata/Unix, Python and other leading-edge products and technology in conjunction with Industry and business skills to deliver high quality solutions to customer.
• Design/Develop ETL jobs using Teradata/Python including for varying project requirements to meet batch and near real-time expectations.
• Identify and Analyze performance issues by reviewing DBQL and Data model and propose solutions to improve teh performance.
• Analyze Performance Metrics (CPU/IO Skew, PJI, UII, and Impact CPU) and Tuned in-efficient queries
• Designed/Developed Semantic Layer on Teradata platform for varied project requirements.
• Identify Multi-value compression candidates using Win MVC tool and apply Multi-value compression.
• Build DEV/TEST env’s by copying data from PROD env using Load/Export/TPT scripts.

Environment: Teradata V2R12, Unix MPRAS, Python, Multiload, Fastload, Fastexport, BTEQ, TPUMP, ARCMAIN, Business Objects, MIMIX Replication, MQ-Series, FTP/SFTP, ER Viewer, Rational Clear case, Teradata Manager, Teradata SQL Assistant, Teradata Admin, PMON, Viewpoint, Win MVC

Confidential

Lead DBA/ DW Architect

Responsibilities:

• Utilize in-depth functional and technical experience in Teradata/Unix, Datastage/Infosphere and other leading-edge products and technology in conjunction with Industry and business skills to deliver high quality solutions to customer.
• Logical data modeling, physical database design, implementation and testing of large scale database structures.Ongoing tuning of databases objects and structures to improve operational efficiency as measured by decreased processing time and/or reduced maintenance effort
• Tuning assistance and best practice guidance for Teradata ETL utilities (Fastload, Mload, Fastexport, TPT, Tpump, BTEQ).
• Proactively analyze databases for worst performing SQL and coordinate with developers/analysts to tune application code
• Identify and Analyze performance issues by reviewing DBQL and Data model and propose solutions to improve teh performance.
• Provide code tuning guidelines to development & project teams and coordinate teh resolution of performance issues as needed
• Developed standards and best practices for statistics collection to enable Teradata to generate optimal query execution plans and minimize resource utilization.
• Analyzed Query workloads and implemented TASM workloads/throttles/filters.
• Analyzed Query workloads in production env on regular basis and recommend changes to TASM throttles/filters to utilize database resources optimally.
• Monitor all teh Teradata systems (production and test/development) for availability and performance using Viewpoint/PMON tool.
• Developed scripts to analyze candidates for Multi-value compression and apply Multi-value compression.
• Administration of database objects and security including setup of database objects and user profiles/roles.
• Setup up performance reports to analyze performance metrics (CPU/IO Skew, PJI, UII, and Impact CPU) and tune teh inefficient queries.
• Setup process for copying data between PROD and DEV/TEST env’s using Export/Load/TPT scripts and Archive/Restore scripts
• Analyzed impacts and supported Teradata SW/HW upgrades.
• Implemented Service Improvement Plans for Teradata Database Application from time to time.
• Monthly review of SLAs, major s, and ticket counts/effort applied.
• Monitor database usage and growth trends to forecast future storage needs, includes quarterly trending reports by database
• Extensive knowledge working on Teradata client tools such as SQL Assistant, Viewpoint, PMON, Teradata Manager and Teradata Administrator.
• Created a roadmap to convert ETL jobs using traditional Teradata utilities with Teradata parallel transporter scripts per Teradata’s recommendations.
• Designed and Implemented ETL processing using Infosphere and Teradata utilities
• Upgraded ETL tool from Datastage 7.1 (AIX) to Infosphere 8.5 (Linux)
• Designed and developed Unix/Teradata based framework to generate event based email notifications.
• Designed and developed Data-marts for varied business requirements.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Design, code, debug and document complex computer programs for Data warehouse applications mostly written in Unix shell scripts using Teradata utilities and Datastage jobs.
• Defined project and technical scope and deliverables that supported business goals in collaboration with senior management and stakeholders.
• Prepared resource plan, created and managed risk mitigation plan and ensured that teh program executed on time.
• Responsible for effective communication between teh project team and teh customer. Provide day to day direction to teh project team and provide regular project status to teh customer
• Establish SCM Procedure for teh team and continuously monitor and audit to ensure team follows SCM procedures

Environment: Teradata V2R12/V2R13.10, Infosphere 8.5 Designer/Director/Administrator, Linux, Unix MPRAS, UNIX Shell Scripting, Multiload, Fastload, Fastexport, BTEQ, TPUMP, TPT, ARCMAIN, Hyperion 8.1, Oracle 11g, Connect Direct (NDM), SSH, Rational Clear case, Rational Clear-quest, TPT Wizard, Teradata Manager, Teradata SQL Assistant, Teradata Admin, PMON, Viewpoint

Confidential

DBA, Tech Lead

Job responsibilities:

• Utilize in-depth functional and technical experience in Teradata/Unix, Datastage and other leading-edge products and technology in conjunction with Industry and business skills to deliver high quality solutions to customer.
• Participate in due-diligence sessions with teh CIW technical team to understand teh technical aspects of teh application, high level process flows.
• Designed and Developed ETL strategy for data migration (initial) and incremental loads from CIW to ABS DW.
• Designed and Developed ETL jobs to load data using Datastage, FastLoad, BTEQ, FastExport, MultiLoad, and shell scripts.
• Analyzed requirements, transformed data, and mapped source data to Teradata.
• Assisted in converting logical data model into physical data model suited to Teradata and Assisted ETL developers in tuning queries by suggesting new indices, statistics collection.
• Developed scripts to implement DDL as per Data Model. Administer Database access by using Roles and Profiles mechanism.
• Designed, Created and fine tuned physical database objects (tables/views/indexes)
• Perform capacity planning, Handling Space issues, Handling Locks if any and Co-ordinate database backups/restore.
• Worked extensively in implementation of multi - value compression and implementation of table driven approach to collect statistics on regular basis.
• Setup teh environment for Development, SIT and UAT and promotion of DDL’s to Production.
• Provide code tuning guidelines to development & project teams and coordinate teh resolution of performance issues as needed
• Responsible for leading a project team in delivering solution to teh customer.
• Responsible for effective communication between teh project team and teh customer. Provide day to day direction to teh project team and regular project status to teh customer.
• Defined project and technical scope and deliverables that supported business goals in collaboration with senior management and stakeholders.
• Communicated project expectations to team members and stakeholders.
• Prepared resource plan, created and managed risk mitigation plan and ensured that teh program executed on time.

Environment: Teradata V2R5, Datastage 7.1 Designer/Director/Administrator, UNIX MPRAS, UNIX Shell Scripting, Multiload, Fastload, Fastexport, BTEQ, TPUMP, ARCMAIN, Netvault, Subversion, Teradata Manager, Teradata SQL Assistant, Teradata Admin, PMON, Viewpoint

Confidential

Tech Lead, Data Specialist

Job responsibilities:

• Defined technical scope and deliverables that supported business goals in collaboration with senior management and stakeholders.
• Schedule project timelines and milestones.
• Communicated project expectations to team members and stakeholders.
• Set and continually managed project expectations between Offshore/Onsite team.
• Prepared teh resource plan, created and managed risk mitigation plan and ensured that teh program executed on time.
• Design and Develop data conversion jobs for production for varied business requirements.
• Prepared macro level design document.
• Managing teh team and their activities, Status updates and issue resolution with teh onsite team.
• Knowledge Transfer and trouble shooting for teh team, Ramping up new team members
• Ensure all deliverables are made by team members in a timely manner and adhere to quality norms.
• Responsible for UAT and project implementation.
• Code walkthroughs to meet teh quality standard set by teh project.
• Mentored teh new team members to understand teh system workflow fast and led them to deliver teh subsystems with Good Quality.
• Performance tuning and SQL query enhancements to achieve performance targets

Environment: Oracle 9i (SQL and PL/SQL), Sun OS, Unix Shell Scripting, C, C++, DSAP/DMQ. Connect Direct, Clearcase

Confidential

IT Consultant

Job responsibilities:

• Involved in identifying test scenarios and test-case development for telecom based billing and account management application.
• Prepared test plans and test cases documents
• Deliver high quality test plans and test cases in response to varying system requirements
• Guided project team in test management, test planning and testing activities
• Responsible for effective communication between project team and teh customer and provide day to day direction to teh project team
• Mentored new team members to quickly understand teh system workflow and enable them to deliver high quality deliverables.
• Developed scripts to verify/validate teh test data.
• Developed reusable test-case templates to prepare test-cases with minimal effort.
• Developed scripts to create test data with minimal effort.
• Prepared resource plan, created and managed risk mitigation plan and ensured that teh testing phases executed on time.
• Set and continually managed project expectations between Offshore/Onsite team.
• Analyzed System Requirements to identify high quality test scenarios and test cases.
• Automation/Creation of Test bed to perform Regression Testing on regular basis.
• Automation of test data creation for Integration Testing
• Delivered more number of projects with zero UAT defect delivery
• Delivered high quality product with zero/minimal production defects.

Environment: Oracle 9i (SQL and PL/SQL), Sun OS, Unix Shell Scripting, C, C++, DSAP/DMQ. Connect Direct, Clearcase

Confidential

Software Engineer

Job responsibilities:

• Involved in developing Web based application.
• Developed Low level design document.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Knowledge transfer and trouble shooting for teh team and ramping up new team members.
• Responsible for Project implementation and UAT.
• Code walkthroughs to meet teh quality standard set by teh project.
• Mentored new team members to quickly understand system workflow and enabled them to deliver teh subsystems with high quality.

Environment: Java 1.2, Tomcat, Java Script, Oracle 8i, Sun OS, Subversion.