Professional Summary:

• Teradata Certified consultant with about 8 years of experience in domains like Banking, Financial Services, Manufacturing, Telecommunications and Food Safety.
• Involved in various phases of IT projects in planning and designing Data Warehouse applications, gathering business requirements, analysis, development, testing and implementation encompassing SDLC and agile methodology.
• Over 8 Years of IT experience in Analysis, Design, Development, Testing and Implementation of business application systems in Data warehousing for business system like Banking, Retail and Insurance industries.
• Seven plus years 7 of experience using Teradata SQL Assistant, Teradata Administrator and data import/export, data loading with utilities like BTEQ, Multi Load, Fast Load, Fast Export, T Pump on UNIX/Mainframes environments
• Five plus 5 years of experience in ETL methodologies, Informatica Power center 7.x/8.x, Power mart, Client tools-Mapping Designer, Workflow Manager/monitor and Server tools Informatica Server Manager, Repository Server Manager and Power Exchange.
• Extensively used Oracle SQL and PL/SQL for development of Procedures, Functions, Packages, Triggers and error handling in PL/SQL.
• Proficient in architectural diagrams, logic flowcharts, data maps, operating, maintenance and support procedures, and detailed documentation of the technical design.
• Extensive knowledge of Teradata system architecture, security administration using roles and profiles mechanism, create users, grant permissions, roles and privileges.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Good in tuning queries to leverage benefits of parallel architecture of Teradata database to enhance performance.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions
• Sound knowledge of logical and Physical Data Model design process in Star and Snowflake Schema, 3NF.
• Expertise in debugging complex queries, performance tuning, existing ETL process.
• Working knowledge of BI tools like Cognos, Brio and Hyperion.
• Working knowledge of Data Modelling Tools like Power designer and Erwin use of VB Script Macros.
• Experience in fork lifting data warehouses and data marts from other database like Oracle, Sybase, SQL Server to Teradata
• Well versed in UNIX shell scripting.
• Hands on experience in data modeling, program code development, test plan development and datasets creation.
• Involved in documentation of various functionalities of Data Warehouse, Data Marts, and Business Intelligence.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data used pager for notifying the alerts after successful completion.
• Strong communication, presentation and interpersonal skills with excellent problem solving capabilities.
• Experience in offshore/onsite model.

Technical Skills

Professional Experience:

Confidential

Senior ETL Consultant

• FOOD SAFETY INSPECTION SERVICE FSIS department requires their 10 Systems from different databases like Sybase, SQL Server and ACCESS to be migrated/forklifted to Teradata Database for reporting purpose. Source System has variety of data like Unicode, xml, Large data which is being successfully migrated to Teradata using TPT.
• Involved in various aspects of s/w developmental activities needed as a part of Forklift project like design, build, testing and implementation.
• Converted Oracle/Sybase/SQL Server DDLs to Teradata DDLs using data Modeling Tool like Power designer along with the use of VB scripts.
• Developed automated Unix scripts to generate Teradata Load scripts.
• Exported data from SQL Server and Sybase using BCP methodology.
• Written appropriate code in conversion as per the requirement using TPT Scripts Access Module and loaded data into Teradata.
• Assisted in building the Teradata Environment for all the source systems that includes creating various Database objects, users, roles, imposing security on the data.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, updates strategy, lookup, sorter, Normalizer, sequence generator etc.
• Worked on XSD and XML files generation through ETL processes.
• Involved in the initial Capacity Planning of various Databases.
• Converted Sybase SQL Code to Teradata SQL Code and applied Teradata provided optimization techniques to fine tune the same.
• Identified appropriate indexes, Performed Collect Stats diagnosis in order to provide optimized solution to Users.

Tools/Utilities: Teradata SQL Assistant, Teradata Parallel Transport, Informatica 9.1, Linux, Unix, Power Designer, BCP utility, VB Script

Confidential

Senior Informatica Developer

• Confidential launched IDR Interim Data Repository for analyzing the data that was fetched from various sources. Once the data is rationalized by development team, business analysts evaluate the need and/or enhancement of new initiatives so as to bring in more value to business in long term.
• Analyzed the business requirements and functional specifications
• Used Informatica Power Center 8.6 for extraction, transformation and load ETL of data in the data warehouse. Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Filters, Expressions and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Implemented effective date range mapping Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information
• Troubleshooting fixing the existing Teradata TPT load scripts.
• Optimized the existing Teradata views and SQL queries.
• Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the run time.
• Sound Experience with Informatica Performance Tuning Options like Partitions, Optimizations.
• Good exposure on Unix shell scripts to invoke Oracle PL/SQL stored procedures, scheduling extract jobs, email notifications for job completion/abort status.

Tools/Utilities: Informatica 8.6, Teradata SQL Assistant, BTEQ, MultiLoad, Fast Load, Teradata Parallel Transport, Oracle 10g, Unix.

Confidential

ETL Lead Migration from Oracle to Teradata

• The ADS data warehouse environment provides data to a number of financial applications which include credit cards information, reporting and analysis based upon the data collected from various systems of record.The ADS Re-platform project's objective was to convert the ADS infrastructure and functionality which was resident on Oracle 10g to migrate to Teradata v13.0 RDBMS.
• Involved in the physical design and creation of ETL Technical Design Document.
• Converted Oracle packages to Teradata Stored Procedures.
• Worked on Oracle PL/SQL packages to generate flat files that are consumed by Informatica to load data into DW.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Modified the existing ETL mappings and sessions in informatica to be able to load into Teradata.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Extensively worked under the UNIX Environment using Shell Scripts.
• Developed strategies for Testing Team to perform data validation and data integrity check.
• Interaction with the offshore team on a daily basis on the development activities.

Tools/Utilities: Informatica 8.6, Oracle 10g, Toad, Teradata SQL Assistant/Administrator, AIX UNIX, BTEQ, MultiLoad, FastLoad, Maestro Scheduler, HP Quality Center.

Confidential

Teradata DI Consultant

• Confidential is leader in biotechnology that develops, manufactures and delivers innovative human therapeutics. The project aims at analyzing data from various health centers and hospitals so as to provide maximum benefits to people with minimal healthcare expenses.
• Developed complex and highly-optimized SQLs looking up at core EDW in Third Normal Form to output at demoralized data mart requirements
• Create and execute test plans for Unit, Integration, and System test phases
• Worked closely with Project Managers, Business Analysts, BI Architect, source system owners, Data Management/Data Quality team to ensure timely and accurate delivery of business requirements
• Handled Source to Target Data Mapping, Technical Specs documentation, and ETL documentations such as Data Profiling, Data Mapping, and Programmer Specs conforming to internal guidelines
• Developed UNIX shell scripts.
• Assisted SIT/UAT testers in optimizing testing scripts and to ensure data accuracy and integrity.
• Extensively worked on data Extraction, Transformation and loading from source to target system using Bteq, FastLoad and MultiLoad and Informatica.
• Involved in writing scripts for loading data to target data Warehouse for Bteq, FastLoad and MultiLoad.
• Did error handling and performance tuning in Teradata queries and utilities.
• Involved in unit testing and preparing test cases. Involved in manual functional testing and peer reviews.

Tools/Utilities: Teradata, SQL Assistant, Cognos, AIX UNIX, BTEQ, MultiLoad, FastLoad,Informatica.

Confidential

Teradata DI Consultant

• Analyzed business requirements, transformed data, and mapped source data from the source system to the Teradata Physical Data Model.
• Developed Teradata Stored Procedures to load data from 3NF schema to Start Schema.
• Worked with Teradata PMON, Teradata Admin and Teradata Manager to monitor the performance and tuned SQLs to help improve performance.
• Optimizing Query Performance, Session Performance and Reliability.
• Perform testing activities, verify validate compiled data.
• Understanding Business needs and implementing the same into a functional database design.
• Worked closely with business analyst and analyze source data to develop the transformation logic.
• Involved in unit testing and preparing test cases. Involved in manual functional testing and peer reviews.

Tools/Utilities: Teradata SQL Assistant, Teradata Manager, PMON, Teradata SQL Assistant, Teradata Administrator, Teradata Utilities BTEQ, FastLoad, FastExport, MultiLoad Update/Insert/Delete/Upsert , ERwin Data Modeler.

Confidential

Production Support Personnel

• Free scale was experiencing performance issues due to huge data residing in Oracle DB. So they initiated migration project from Oracle to Teradata. The database and reporting tool were migrated to Teradata and Hyperion 9.2. All major objects like ETL jobs and reports were also migrated to enhance performance.
• Acquired knowledge on Teradata SQL Assistant, Teradata Administrator and Performance Monitor PMON .
• Involved in writing extraction scripts using SQL, BTEQ, Fast Export scripts.
• Create and drop Databases, Profiles, Roles, Tables, Views, Indexes Primary, Secondary, partitioned etc. , Triggers, Macros and stored procedures.
• Data loading to Teradata tables using Fast load and Multi load scripts.
• Created simple Data stage jobs.
• Supported reporting tool like Brio Hyperion.
• Created Physical data model using Erwin Data modeling tool.
• Provided 24/7 on call Prod support.
• Scheduling and Monitoring of Jobs using Maestro Scheduler.
• Unit tested the developed ETL scripts, created test SQLs, and handled UAT issues, enhanced SQLs for performance tuning.
• Rolled out documentation for the ETL Process and Data Profiling.
• Supported the production implementation of the data warehouse, monitored jobs fixed failed scripts
• Supported throughout the lifecycle of project and was involved in Migration from Oracle to Teradata

Tools/Utilities: Oracle 10g, TOAD, DataStage 7.5, Teradata SQL Assistant, Teradata Administrator, Teradata Utilities BTEQ, FastLoad, FastExport, MultiLoad Update/Insert/Delete/Upsert , ERwin Data Modeler, Maestro Job Scheduler, Hyperion 9.2

Confidential

SAS Data log Developer

• Converted SAS/STAT code into SAS/BASE to reduce SAS license cost.
• Impact / Requirement Analysis of Service type request.
• Preparation of detailed program specifications.
• Coding and Unit Testing.

Tools/Utilities: Base SAS, SAS/AF, SAS/GRAPH, SAS/STAT, SAS/QC.