SUMMARY

• Over EIGHT years of software experience in System Analysis, Application Design, Development, Implementation and ETL, Reporting for Data Warehousing.
• As a ETL Architect in designing and implementing Data Mart / Data Warehouse applications using Informatica Power Centre 9.x/ 8.x / 7.x / 6.x (Designer, Workflow manager, Workflow monitor and Repository Manager).
• Experienced in requirements gathering, project estimating, planning design, build, maintenance, report design, user navigation design, testing and implementation. Good knowledge on SDLC (software development life cycle) and good experience wif unit testing and integration testing.
• Preparing the High level Design Specifications for ETL Coding and mapping standards and experience in Performance tuning. Experience in integration of various data sources like Oracle, Teradata, Sybase and MS access, flat files, and XML. Experience in ERWIN/ ER studio.
• Expertise Informatica B2B Data Transformation, pre - built transformations for most versions of industry standard messages including the following EDI standards Experience in Ralph Kimball Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, FACT tables, Dimension tables.
• Expertise in OLTP/OLAP System study, developing Database schemas like star schema, snow flake schema Dimensional Data Modeling used in relational, dimensional modeling and slowly changing dimensions (SCD’s).
• Performed ETL procedure to load data from different sources into data marts and Data Warehouse using Power Center. Experience in working wif scheduling tools like Autosys and Control M.
• Strong expertise in Relational database systems like Oracle 8i/9i/10g, Teradata, MS Access, design and database development using SQL, PL/SQL, SQL PLUS, TOAD, SQL LOADER.
• ETL experience in development of mappings and tuned existing mappings for better performance using Informatica Power Exchange, Informatica Power Center. Expertise in writing Oracle PL/SQL Stored Procedures, Functions, Packages, Cursors and Triggers.
• SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by creating Explain Plan, SQL hints for query and indexing the required columns. Develop, execute ETL test plans, Document ETL processing and generate required metadata.
• Develop a transformation by marking the relevant data directly on a sample of the data source, and mapping that data to a chosen XML schema.
• Expertise in writing DDL, DML, DCL, and TCL commands and also experience wif UNIX commands, VI editor and writing Shell scripts. Experience in creating reports using Oracle Business Intelligence 10x, and Siebel Analytic.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools. Lean & SIX SIGMA GREEN BELT Certified and knowledge of rigor in software projects.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.5/9.1/8.6.1/8.1.1/7.1.3, Informatica Power Exchange, Informatica Data Explorer, AQUA (Data Quality).

Business Intelligence: Business Objects XI/Business Objects 6.5.

RDBMS: Oracle 11g/10g/9i/8i, SQL*Loader, Teradata, Sybase IQ, MS Access.

Data Modeling: Erwin, Microsoft Visio.

Tools: TOAD, SQLDBx, PL/SQL Developer, SQL Assistant, Rapid SQL 8.1.1, Putty, WinSCP, Autosys, Business Objects 6.5/XI, Sybase.

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++, Java, Oracle SQL Developer 1.5.5, Control-M, SQL, PL/SQL, Visual Basic, HTML, DHTML, XML.

Operating Systems: Windows, HP-UNIX, AIX, Sun OS.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Team Lead

Responsibilities:

• Involved in the design and development of ETL code for the Credit Risk Insight system using Informatica.
• Performing Client Liaison, Requirement Analysis, Data Quality Analysis, Gap Analysis, CODE Mapping, Functional/Technical Specifications, ETL Design Documents, ETL Development, Testing and Support Activities.
• Developed mappings, sessions, workflows and workflow tasks based on the user requirement and scheduled the workflows in workflow manager and monitor the status of the workflow runs in workflow monitor.
• Created and imported different source and target definitions in source analyzer and warehouse designer and called them into the Informatica mapping Designer.
• According to the business logic created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy.
• Responsible for migrating code from development to testing tan to the production environment and experience in creating Reusable Transformations and Mapplets and used them in Mappings.
• Responsible for determining the bottlenecks and fixing the bottlenecks wif performance tuning techniques. Used PMCMD command to start, stop, and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Successfully Implemented Slowly Changing Dimensions. Used type 2 dimension to keep the history changes in data by versioning, TEMPeffective data and flags. Extensively used Workflow Manager and Workflow Monitor for creating and monitoring workflows and sessions.
• Developed workflow tasks like Event wait, Event Raise, Timer, Command and Decision. Created Oracle Stored Procedures to implement complex business logic for good performance and called from Informatica using Stored Procedure transformation.
• Used Informatica debugger to test and fix the mappings and created test cases for Unit Test, System Integration Test and UAT. Conceptual, Logical & Physical Data Model designing for large scale projects.
• Engaging in client meeting and identify the business/technical gaps in the system or process and providing future focused solutions.

Environment:Informatica Power Center 9.5.1, Oracle 10g, PL/SQL, Flat Files, Sybase, ERWIN/VISIO Data Modeling tool, UNIX/LINUX, Shell Scripts, Control M, Clarity, HP Quality Center, Java, SharePoint, JIRA, Remedy, Crontab.

Confidential

Sr. Software Engineer Singapore

Responsibilities:

• Client Liaison, Analysis, Designing, Development and Support new project requirements. Involved in conducting complete business requirement gathering and converting URS to Functional & Technical documents.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Sales and Marketing Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Engaging in client meeting and identify the business/technical gaps in the system or process and providing future focused solutions.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data Involved in the development and testing of programs, Informatica mappings and update processes.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules). Expertise in Teradata FSLDM Concepts and Involved in Logical Data Model and Physical Data Model design and architecture.
• Worked on various active & passive transformations like Aggregator, Expression, Filter, Router, Lookup, Update Strategy, Stored Procedure, Update Strategy, and Sequence Generator. Used debugger to test and fix the mappings.
• Used various Oracle Index techniques to improve the query performance.
• Designed and Developed Oracle PL/SQL Stored Procedure for efficient customized data loading, retrieval and implement complex business logic for good performance, Created Materialized views for summary tables for better query performance.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality. Involved in writing UNIX shell scripts to automate the business process and also provided End-user training and support.

Environment:Informatica Power Center 8.1, Oracle 10g, SQL, PL/SQL, and Windows, Autosys, UNIX, Metadata Manager, Java, Power Connect, Teradata R11, XML, Erwin 7.

Confidential

ETL Consultant/Lead

Responsibilities:

• Management to forecast their markets accurately identifies the factors that most impact involved in all phases of SDLC from requirement, design, development and testing.
• Management to forecast their markets accurately identifies the factors that most impact involved in all phases of SDLC from requirement, design, development and testing.
• Each segment's profitability. Warehouse is supposed to assist in defining strategy for extensively involved in requirement analysis and created ETL mapping design document.
• Each product segment. The project is focused on developing various details and summary Extensively Designed, Developed, Tested complex Informatica mappings and mapplets reports that will prove halpful for the sales and marketing teams. This application is to load data from external flat files and other databases.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin. Extensively Worked on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language likes transformation expression, constants, system variables, data format strings.
• Extensively worked on the Repository Manager to create/modify/delete users/group/roles. Involved in running the loads to the data warehouse and data mart involving different environments.
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.
• Extensively worked on ETL performance tuning for tune the data load, worked wif DBAs for SQL query tuning etc.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data marts.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Integrated various sources into the Staging area in Data warehouse and provide technical support to Quality Assurance team and Production group. Hands on experience in Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ) to analyze, standardize and cleanse the data.
• Fair amount of knowledge in Business Objects suite like BO reporter, Supervisor, Designer Web Intelligence, Info View and Broadcast Agent.

Environment:Informatica Power Center 8.1.1, AQUA, Oracle 10g, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, ERWIN & VISIO, Teradata V5R4, UNIX Shell Scripting using AWK/SED, Linux, Cognos 8.0, ProcMon Scheduler, HP Quality Center.

Confidential

Informatica Consultant/Lea

Responsibilities:

• Involved in gathering and reviewing business requirements and designing functional specifications design documents, Data modeling and design of Data warehouse.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center. Created the repository manager, users, user groups and their access profiles.
• Created Logical & Physical models, used Erwin & VISIO for Dimensional Data Modeling.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations. Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), and Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle. Extracted data using BTEQ scripting which includes Fast Export and Multi Load utilities.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2). Cleansed the source data, extracted and transformed data wif business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Involved in the development of Informatica mappings and also performed tuning for better performance. Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.
• Setting up sessions to schedule the loads at required frequency using Power Center, Workflow manager, PMCMD and also using scheduling tools. Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Automated the entire processes using UNIX shell scripts. Fair amount of knowledge in Business Objects suite like BO reporter, Supervisor, Designer Web Intelligence, Info View and Broadcast Agent.
• Conduct status meetings wif project managers, escalate issues when necessary, conducts meetings for issues resolution. Hands on experience in Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ) to analyze, standardize and cleanse the data.

Environment:Informatica Power Center 8.1.1, Power Exchange, AQUA, Autosys, HP QC, UNIX, Erwin, Oracle 9i/10g, Erwin 4.0, Visio, SQL, PL/SQL, SQL * Loader, T SQL, TOAD, XML, Business Objects.

Confidential

Informatica Consultant/Lead

Responsibilities:

• Reviewed data models, system and designed Extracting architecture, Applications design, requirements documentation and program specifications.
• Production Support, ETL Executions using Web methods scheduler, Performing Root Cause Analysis on Critical batch jobs failure, Defect Tracking and bug reporting, UAT Data & production Implementation support. Work closely wif business areas to identify high value business issues.
• Created Informatica repositories in different stages of project, which supports multi-language data (Unicode data) and created users, user groups and connections. Designed the mappings and sessions to extract Real-Time data from different systems.
• Created Simulation mappings, sessions and workflows for processing error records while loading into Informatica. Workflows have been scheduled dynamically according to the business usage by using UC4 scheduler.
• Written UNIX shell scripts to process the Real time extracted staging files for the load process, Written and executed SQL Queries for Functional, Regression, Integration testing, User Acceptance Testing.
• Written SQL queries and stored procedures to check data integrity by logging test results in Quality center. Provide End to End support activities using scheduler and monitoring & automating the production workflows.
• Prepare High Level and Low Level Design Document, Functional Specification documents, CODE mapping Documents according to the Business Requirements

Environment:menformatica Power Center 7.1.4/8.0, Oracle, Neoview, Web methods scheduler, HP Quality Center, UC4 Dynamic Scheduler, UNIX Shell Scripting, Sun Solaris.

Confidential

Informatica Developer

Responsibilities:

• Developed ETL mappings, transformations using Informatica power center. Implemented source and target definitions in workflow designer.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression. Mappings were designed to cater the slowly changing dimensions.
• Used various stored procedures in the mappings. Preparation of Test Plans, Test Cases/Scripts, SIT/UAT Testing, Reporting, Client Presentation and Post Production Support Activities. Development Reports using Business Objects reporting solutions.
• Data Modeling Design using Erwin & Microsoft VISIO, Developed several reusable transformations and mapplets that were used in other mappings. Worked on the server manager to run several sessions and batches concurrently and sequentially.
• Mappings were designed to the utmost performance by optimizing expressions in expression editor of transformation, filtering source data at the source qualifier, and applying transformation logic.

Environment:Informatica power center 7.1.4/8.1.1, Oracle 9i, UNIX, PL/SQL, STAR Schema, Flat files, Quality Center, Remedy, Autosys, Business Objects.

Confidential

ETL Developer

Responsibilities:

• Involved in creation of Schema Objects like indexes views, and stored procedures. Involved in the Analysis of how the purchase order process is organized. Involved in a team in designing the Database Schema, for the metadata for storing the informative queries that are generated dynamically.
• Implementation of ETL Strategies, which optimizes Mapping Performance and Assist in planning and review of Internal Quality processes, Metrics and approaches, Involved in writing procedures and functions.
• Preparations of Test Plans, Test Cases, SIT Testing, Post Production Warranty Support Activities. Involved in documenting the entire process.

Environment:Informatica 7.1.4, Oracle 9i, UNIX, PL/SQL, STAR Schema, Flat files, Quality Center, Remedy, Autosys.