SUMMARY

• Over 9 yearsof experience in Information Technology with a strong background inData warehousing andTeradata.
• Involved in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Data modeling tool ERWIN and Dimensional modeling techniques (Kimball and Inmon), Star Schema, Snow Flake Schema, Slowly changing Dimensions.
• Strong Data warehousing experience specializing in RDBMS, ETL Concepts to load data from different sources into data warehouse using Informatica Power Center and Teradata Utilities.
• Proficient in Data Architecture in Teradata Data warehousing environment.
• Strong knowledge in all phases of Software Development life Cycle (SDLC) and application ILM with experience in Financial, Manufacturing, Insurance and Retail Domain.
• Extensive Experience onTeradatadatabase, analyzing business needs of clients, developing TEMPeffective and efficient solutions and ensuring client deliverables with in committed timelines.
• Expert in Teradata utilities include BTEQ, MLOAD, FAST EXPORT and TPUMP. Teradata infrastructure and services.
• Expert in designing and developing Workflows, Sessions and other tasks using Work flow manager tools Task Developer, Workflow & Worklet Designer to handle different load scenarios.
• Provided technical support and leads teh TEMPeffective problem resolution for customer inquiries and production issues.
• Expert in Teradata Physical Database Design, Development and Performance Tuning.
• Experienced in UNIX shell scripts to write wrapper scripts to call ETL Jobs.
• Highly adept at creation, execution, testing and debugging ofInformatica mappings, Mapplets, sessions, tasks, workletsandworkflowsinUNIXandWindowsenvironments.
• Created mapping documents and work flows and data dictionaries.
• Worked closely with teh Data Modeler and Data Architect in enhancing teh FSLDM
• Expertise with all ODI (Oracle Data Integrator)tools - Topology, Designer and Operator.
• Have Good experience in Downstream Development and process handling like Different Datamart Layers and their purposes in data mart functioning.
• Detailed knowledge and practical experience with teh MPP architecture.
• Proficient in delivering teh high data quality by designing, developing and automation of audit process and implementation teh reconcile process accordingly.
• Utilized ELT based data transformation to apply complex business rules to transform source data.
• Experience in handling initial (i.e. history) and incremental loads in target database using mapping variables.
• Extensive experience in Loading High volume of data, requirement gathering, analysis, design, development and implementation.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues.
• Excellent Team member with good Communication, analytical, interpersonal skills and ability to learn new concepts.
• Ability to achieve and be accountable for timely delivery of architectural results that support business needs.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x, Oracle Data Integrator (ODI), Sunopsis.

Databases: Oracle 11g,Teradata 13.10, DB2 8.1, SQL server, My SQL.

Database Tools: TeraData SQL Assistant,TOAD, Oracle SQL developer, SQL *PLUS

Languages: SQL, PL/SQL, Java,UNIX Scripting, XML.

Operating System: Windows 2000,XP, UNIX, LINUX, MS DOS.

Scheduling Tool: Control-M,WLM.

Data modeling Tools: Erwin

PROFESSIONAL EXPERIENCE

Confidential, RICHMOND,VA

Teradata Consultant

Responsibilities:

• Post production implementation support responsibility.
• Supporting enterprise data warehouse and ETL development activities.
• Providing strategic and tactical direction to teh team.
• Performed teh analysis of data in Enterprise data warehouse and maintain teh Data integrity and Data quality.
• Developed Informatica mappings, enabling teh extract, transport and loading of teh data into target tables.
• Created workflows with teh event wait task to specify when teh workflow should load teh tables.
• Loaded data from various sources (Flat files, Oracle, Teradata) using different Transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Expression, Sequence Generator, Union and Update Strategy to load teh data into teh target.
• Developed UNIX Shell Scripts for scheduling BTEQ scripts.
• Redesigned some of teh mappings in teh system to meet new functionality and Extensively used Debugger Process to test Data.
• Used Informatica Power Center Workflow manager to create sessions and workflows to run teh logic embedded in teh mappings.
• Re wrote teh SQL scripts to improve performance.
• Responsible for Technical implementation of teh change request solution.
• Supporting enterprise data warehouse and ETL development activities.
• Tested teh data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Responsible for migrating project between environments (Dev, QA, Prod) and handling teh reject data.
• Provided Knowledge transfer to QA team and assisted for defects fixes.
• Prepared migration documents,DBA scripts and assisted informatica admin,Oracle DBA for migration.
• Created post-session and pre-session shell scripts and mail-notifications.
• Developed UNIX shell scripts to invoke Informatica jobs using teh pmcmd commands.
• Prepared teh QA script to do basic level sanity checks.
• Developed mapplets and used rules to validate date format, number, standardize string case,check Nulls etc.
• Worked on Data quality transformations like labeler, standardizer, parser, matching transformation etc.
• Ability to work TEMPeffectively in a demanding multi-project, multi-team environment.
• Planning and prioritizing teh tasks to meet teh deliverable deadlines..

Environment: Teradata,Informatica Power Center 9.1, Oracle 11g,Flatfiles,XML,DB2,Oracle SQL Developer, Unix,WinSCP, Putty.

Confidential

Senior ETL Developer

Responsibilities:

• Involved in Requirement Analysis, ETL Design and Development for extracting from teh source systems and loading it into teh Data warehouse.
• Worked closely with teh Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying teh requirement documents, creating source to target mappings.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.
• Extensively worked with Slowly Changing Dimensions Type2 for Data Loads in ODI.
• Created ODI packages, scenarios using interfaces, variables, procedure.
• Optimized teh ODI knowledge modules to improve teh functionality of teh process.
• Worked as a Data mapper for Provident Fund Data.
• Implemented teh Teradata views with business logics as per mapping.
• Created teh BTEQ scripts to do Audit after completion of Runs.
• Prepared MLoad and FLoad script to load teh flat files data into Teradata database.
• Generated teh workflows in ODI by finalizing teh dependency in teh EDW.
• Responsible for Performance Tuning .
• Responsible for teh Data Cleansing of Source Data using different operations of teh Expression Transformation.
• Created Shell scripts to drop and Re create indexes to load data efficiently and decrease load time.
• Implemented logic to archive teh source files with date stamp affixed after teh successful load.
• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator.
• Participated in all teh phases of project - development, testing, deployment and support.
• Participated in code reviews. Did code promotions from dev to test, staging and production environment using ODI.

ENVIRONMENT: Teradata, Oracle Data Integrator 10.1.3.5,Oracle Database 10g,InformaticaPowerCenter9.1, Oracle10g, Flatfiles,XML,DB2,Oracle SQL Developer, Teradata SQL assistant 14,Unix,WinSCP, Putty, Tivoli

Confidential

Teradata developer

Responsibilities:

• Involved in creation of mappings, sessions, command task and workflows.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Developed various Mappings with teh collection of all Sources, Targets from legacy data sources and Transformations.
• Developed, tested and maintained ETL procedures employing ETL tools.
• Extract data from various sources, transformed data, and loading into data warehouse.
• Worked on Slowly Changing dimensions Type 2 and have excessive Knowledge in usage of Surrogate key.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Involved in Performance/Query tuning, Generation/interpretation of explain plans and tuning SQL to improve performance.
• Extensively participated in database testing like checking teh constraints, correctness of teh data, stored procedures, field size validation.
• Worked closely with DBA in performance tuning of queries using Analyze Tables and SQL Trace.
• Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase teh efficiency of session and Scheduled Workflows using Control-M.
• Moving teh mappings and workflows to staging and then production environment and testing teh process at every level.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Implemented dozens of automated batch processing jobs, running in numerous development, test and production environments.
• Solely responsible for teh daily loads and handling teh reject data.
• Responsible for writing complex SQL Scripts for post production fixes.
• Coordinated with users to get UAT sign-off on time.
• Performance tuned and optimized various complex SQL queries.
• Provided technical support over production cut over.
• Prepared Technical design document and Mapping documents as per Clients standard.
• Assigned project responsibilities under limited supervision and aggressive deadlines.
• Determining teh user’s issue by analyzing teh symptoms and figuring out teh underlying problem.
• Identify teh underlying problem and provide teh possible solution to close teh case on time.
• Part of K-Look frame work team, which is developed on UNIX scripts.
• Followed teh architecture and design standards defined by teh client.

Environment: Teradata, FSLDM,Informatica Power Center 9.1, Oracle 10g,SQL server 2008,XML,Toad,Control-M,UNIX.

Confidential, NEW YORK

Teradata Developer

Responsibilities:

• Analyzed teh logical model of teh databases and normalizing it when necessary, Involved in identification of teh fact and dimension tables.
• Developed transformation logic as per teh requirement, created mappings and loaded data into respectivetargets.
• Involved in Impact Analysis, Design, Development, Testing, Documentation and Implementation of teh project.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Prepared impact document, High level design document, Low level design document and Support Turnover Document.
• Extensively worked on BTEQ scripts to implement Business Logics.
• Wrote Fastexport scripts to export data from Teradata.
• Wrote Teradata views based on user and/or reporting requirements.
• Performance tuned and optimized various complex SQL queries.
• Good knowledge on Teradata PMON, DBQL, SQL assistant and BTEQ.
• Coordinated with teh business analysts and developers to discuss issues in interpreting teh requirements.
• Provide Teradata operational support, including performance tuning, clean-up after batch failures, investigation of end-user reported issues.

ENVIRONMENT: Teradata,Informatica Power Center, Oracle 9i, DB2, SQL Plus, Erwin, UNIX.

Confidential

Teradata Developer

Responsibilities:

• Involved in designing, developing and documenting of teh ETL (Extract, Transformation and Load) strategy to populate teh Data Warehouse from various source systems feeds using Informatica, PL/SQL scripts
• Worked on Data cleansing, data conversion & process implementation.
• Worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads.
• Involved in performance Tuning at teh Mapping, Session and Target Level.
• Created Shell scripts to drop and Re create indexes to load data efficiently and decrease load time.
• Responsible for teh Data Cleansing of Source Data using LTRIM and RTRIM operations of teh Expression Transformation.
• Implemented Informatica Power Exchange CDC Option to capture teh changes for up-to-teh-minute data and increasing business agility.
• Developed Mappings in Informatica to load teh data from various sources using various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Union, Aggregate, Update Strategy, Joiner, Filter and Router.
• Implemented dozens of automated batch processing jobs, running in numerous development, test and production environments.
• Generated SQL loader scripts and shell scripts for automated daily load processes.
• Created workflows with teh event wait task to specify when teh workflow should load teh tables.
• Created support documents for teh mappings and sessions & Provided Production Support for business users.

Environment Informatica Power Center 8.5/8.1, Informatica Power Exchange, Oracle 9i, Sybase, TOAD, S Oracle SQL Developer, UNIX Shell Scripts, SQL, WinSCP, Putty.