SUMMARY

• Around 9.3 years of IT experience in System Analysis, Application Design, Development, Implementation and ETL, Reporting for Data Warehousing projects.
• Experienced as a ETL Architect in designing and implementing Data Mart / Data Warehouse applications using Informatica Power Centre 9.x/8.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.
• Created IOD Data Assessment and Data Replication tasks using IOD application.
• Performed Inserts/Updates/Deletes into applications like (SFDC objects, Accounts & Address etc.) using both Informatica power center and Informatica cloud application.
• Extracted the Salesforce data using Informatica Cloud and loaded it into Oracle Database
• Used Informatica Cloud (and others) to extract, transform, and load data into our custom - built Salesforce solution.
• 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 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 with scheduling tools like Autosys and Control M.
• ETL experience in development of mappings and tuned existing mappings for better performance using InformaticaPowerExchange, InformaticaPowerCenter.
• 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.
• 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 with UNIX commands, VI editor and writing Shell scripts.
• Experience in creating reports using Business Objects and creating Reports.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS

ETL Tools: Informatica Cloud, Informatica Power Center 8.x/9.x & Power Exchange, Informatica Data Explorer/Data Quality, AQUA

Business Intelligence: Business Objects XI/Business Objects 6.5

RDBMS: Oracle 11G/10G/9i, SQL*Loader, Teradata, Sybase IQ

Data Modeling: Erwin 9.X, Microsoft Visio

Tools: Toad, SQL DBx, PL/SQL Developer, SQL Assistant, Rapid SQL 8.xPutty, WinSCP, Autosys, Remedy, Quality Center, Control-M

Languages: SQL, PL/SQL, UNIX Shell Scripting, PL/SQL, Visual Basic, XML.

Operating Systems: Windows, UNIX/LINUX, AIX, Sun OS

PROFESSIONAL EXPERIENCE

Confidential, Lexington, MA

Principal Consultant

Responsibilities:

• Involved in designing and development of ETL code for the Aggregate Spend project using Informatica, Oracle, UNIX and ERWIN/VISIO
• 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.
• Performing Client Liaison, Requirement Analysis, Data Quality Analysis, Gap Analysis, CODE Mapping, Functional/Technical Specifications, ETL Design Documents, ETL Development, Testing and Support Activities
• Expertise in Functional/Technical Design document and System Architecture documents
• Used External Loaders like Oracle SQL Loader to load data into several databases
• Created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy as per the business logic
• Responsible for migrating code from development to testing then to the production environment and experience in creating Reusable Transformations and Mapplets and used them in Mappings.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules)
• Successfully Implemented Slowly Changing Dimensions and used type 2 dimension to keep the history changes in data by versioning, effective data and flags
• Extensively used Workflow Manager and Workflow Monitor for creating and monitoring Workflows and Sessions
• Analyze poor performance in application at all tiers, and provide remediation path, and possibly implementation of same.
• 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, Regression Testing and UAT (User Acceptance Testing).
• Involved in troubleshoot, debug, fix and test production support issues

Environment: Informatica Power Center 9.5.1, Oracle 11G, PL/SQL, Flat Files, VISIO Data Modeling tool, UNIX/LINUX, Shell Scripting, Informatica Scheduler, HP Quality Center, Remedy, SharePoint, XML.

Confidential, Marlborough, MA

Sr. Datawarehouse Engineer

Responsibilities:

• Involved in designing and development of ETL code for the Aggregate Spend project using Informatica, Oracle, UNIX and ERWIN/VISIO
• 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.
• Performing Client Liaison, Requirement Analysis, Data Quality Analysis, Gap Analysis, Functional/Technical Specifications, ETL Design Documents, ETL Development.
• Expertise in Functional/Technical Design document and System Architecture documents
• Created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy as per the business logic
• Responsible for migrating code from development to testing then to the production environment and experience in creating Reusable Transformations and Mapplets and used them in Mappings.
• Successfully Implemented Slowly Changing Dimensions and used type 2 dimension to keep the history changes in data by versioning, effective data and flags
• Extensively used Workflow Manager and Workflow Monitor for creating and monitoring Workflows and Sessions

Environment: Informatica Power Center 9.5.1, Informatica IDQ, Oracle 11G, PL/SQL, Flat Files, ERWIN 9.5/VISIO Data Modeling tool, UNIX/LINUX, Shell Scripting, Informatica Scheduler, HP Quality Center, SharePoint

Confidential

ETL Architect

Responsibilities:

• Creation and maintenance of ETL & Data Architecture’s for the Credit Risk Insight system and provided technical leadership to team by designing the ETL solution.
• Performing Client Liaison, Requirement Analysis, Data Quality Analysis, Gap Analysis, CODE Mapping, Functional/Technical Specifications, ETL architecture documents (HLD & LLD), ETL Designs & 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.
• 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 then to the production environment and experience in creating Reusable Transformations and Mapplets and used them in Mappings.
• Successfully Implemented Slowly Changing Dimensions, used type 2 dimension to keep the history changes in data by versioning, effective date 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.
• Designing High level & Low Level design documents according to project requirements.
• Designing conceptual, logical & physical Data Models for large scale projects
• Engaging in client meeting and identify the business/technical gaps in the system.

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

Confidential

Sr. Software Engineer

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.
• Experienced in defining Roadmap, providing Solutions, Architecting, Modeling, Designing and Developing Database, Datawarehouse and Business Intelligence Applications
• Provided an architecture solution that is reusable, maintainable and scalable.
• 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 8x, Oracle 10g, SQL, PL/SQL, and Windows, Autosys, Unix, Metadata Manager, Teradata R11, XML, Erwin 7.

Confidential

ETL Consultant/Lead

Responsibilities:

• Experienced in defining Roadmap, providing Solutions, Architecting, Modeling, Designing and Developing Database, Data warehouse and Business Intelligence Applications
• 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 helpful 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, Mapplets 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.
• Developed functional and technical specification documents, mappings and exception handler for ETL processes.
• Extensively worked on ETL performance tuning for tune the data load, worked with 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/Lead

Responsibilities:

• Involved in gathering and reviewing business requirements, designing functional / technical specifications design documents and design of Data warehouse / marts.
• 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 Conceptual, 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 and Informatica ETL package design in RDBMS systems like Oracle, Sybase, Teradata etc.
• 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 with 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.
• 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 with 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 with 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: Informatica 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.

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