SUMMARY

• Over 9 yearsof experience in Information Technology wif 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 hands - on agile mythologies wif experience in Financial, Insurance and Retail Domain.
• Extensive Experience onTeradatadatabase, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables wif 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 the effective 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.
• Has Good experience in providing production support for huge data warehouse systems.
• Worked closely wif the Data Modeler and Data Architect in enhancing the FSLDM
• Expertise wif all ODI (Oracle Data Integrator)tools - Topology, Designer and Operator.
• Has Good experience in Downstream Development and process handling like Different Datamart Layers and their purposes in data mart functioning.
• Detailed knowledge and practical experience wif the MPP architecture.
• Proficient in delivering the high data quality by designing, developing and automation of audit process and implementation the reconcile process accordingly.
• Utilized ELT based data transformation to apply complex business rules to transform source data.
• Experience in handling initial (me.e. history) and incremental loads in target database using mapping variables.
• Extensive experience in Loading High volume of data, requirement gathering, analysis, design, development,Testing and implementation.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues.
• Excellent Team member wif good Communication, analytical, interpersonal skills and ability to learn new concepts.
• Ability to achieve and be accountable for timely delivery of architectural results dat 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.

Testing Tools: HP- ALM, Quality Center (QC), QTP and Load Runner.

PROFESSIONAL EXPERIENCE

Confidential, RICHMOND,VA

Consultant

Responsibilities:

• Post production implementation support responsibility.
• Supporting enterprise data warehouse and ETL development activities.
• Providing strategic and tactical direction to the team.
• Performed the analysis of data in Enterprise data warehouse and maintain the Data integrity and Data quality.
• Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Created workflows wif the event wait task to specify when the workflow should load the 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 the data into the target.
• Developed UNIX Shell Scripts for scheduling BTEQ scripts.
• Redesigned some of the mappings in the 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 the logic embedded in the mappings.
• Re wrote the SQL scripts to improve performance.
• Responsible for Technical implementation of the change request solution.
• Supporting enterprise data warehouse and ETL development activities.
• Tested the data and data integrity among various sources and targets. Associated wif Production support team in various performances related issues.
• Responsible for migrating project between environments (Dev, QA, Prod) and handling the 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 the pmcmd commands.
• Prepared the 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 effectively in a demanding multi-project, multi-team environment.
• Planning and prioritizing the tasks to meet the 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 the source systems and loading it into the Data warehouse.
• Worked closely wif the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the 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 wif Slowly Changing Dimensions Type2 for Data Loads in ODI.
• Created ODI packages, scenarios using interfaces, variables, procedure.
• Optimized the ODI knowledge modules to improve the functionality of the process.
• Worked as a Data mapper for Provident Fund Data.
• Extensively worked on stored procedures to implement Masking logic .
• Implemented the Teradata views wif business logics as per mapping.
• Created the BTEQ scripts to do Audit after completion of Runs.
• Prepared MLoad and FLoad script to load the flat files data into Teradata database.
• Generated the workflows in ODI by finalizing the dependency in the EDW.
• Responsible for Performance Tuning .
• Responsible for the Data Cleansing of Source Data using different operations of the Expression Transformation.
• Created Shell scripts to drop and Re create indexes to load data efficiently and decrease load time.
• Implemented logic to archive the source files wif date stamp affixed after the successful load.
• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator.
• Participated in all the 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.
• Coordinate wif testing teams for UAT, SIT and IR support.
• Worked as Team lead to provide production support at warranty Period .

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 wif the 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 has 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 the constraints, correctness of the data, stored procedures, field size validation.
• Worked closely wif 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 the efficiency of session and Scheduled Workflows using Control-M.
• Moving the mappings and workflows to staging and then production environment and testing the 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 the daily loads and handling the reject data.
• Responsible for writing complex SQL Scripts for post production fixes.
• Coordinated wif 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 the user’s issue by analyzing the symptoms and figuring out the underlying problem.
• Identify the underlying problem and provide the possible solution to close the case on time.
• Part of K-Look frame work team, which is developed on UNIX scripts.
• Followed the architecture and design standards defined by the 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 the logical model of the databases and normalizing it when necessary, Involved in identification of the fact and dimension tables.
• Developed transformation logic as per the requirement, created mappings and loaded data into respectivetargets.
• Involved in Impact Analysis, Design, Development, Testing, Documentation and Implementation of the 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.
• Implemended business logic in stored procedures.
• Good knowledge on Teradata PMON, DBQL, SQL assistant and BTEQ.
• Coordinated wif the business analysts and developers to discuss issues in interpreting the 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 the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems feeds using Informatica, PL/SQL scripts
• Worked on Data cleansing, data conversion & process implementation.
• Worked wif Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads.
• Involved in performance Tuning at the Mapping, Session and Target Level.
• Created Shell scripts to drop and Re create indexes to load data efficiently and decrease load time.
• Responsible for the Data Cleansing of Source Data using LTRIM and RTRIM operations of the Expression Transformation.
• Implemented Informatica Power Exchange CDC Option to capture the changes for up-to-the-minute data and increasing business agility.
• Developed Mappings in Informatica to load the 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 wif the event wait task to specify when the workflow should load the tables.
• Created support documents for the mappings and sessions & Provided Production Support for business users.

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