SUMMARY

• Over all 10 yrs of IT experience which includes 8 years of strong data warehousing, ETL and OLAP experience using Informatica Power mart and Power Center 8.6/ 8.1/ 7x/ 6.2/6.1/ 5.1,(Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations), Business Objects, Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2008/2005/2000/7.0/6.5 , MS Access 2007/2005.
• Experience in all aspects of the System Development Life Cycle.
• Designed and developed complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Sorter, Normalizer, Sequence Generator, Router, Filter, Expression, Aggregator, Joiner and Update Worked with Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor tools.
• Extensive UNIX Shell Scripting knowledge.
• Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle database.
• Experience in Performance Tuning of ETL to get quicker execution time.
• Working Experience in E - R modeling-FACT & Dimensions tables, Physical & logical data modeling.
• Involved in Extraction Transformation and Loading (ETL) Process in various projects using Informatica Power Center.
• Worked Extensively with Slowly Changing Dimensions Type1, Type2 and Type3.
• Knowledge of ETL command line utilities to execute workflows in Unix environment.
• Experience in Capturing Incremental data (CDC) from source systems.
• Strong technical skills with Unix/Linux systems.
• Worked on error handling and problem solving in Informatica.
• Experienced in integration and transforming of various data sources from Databases like Oracle, DB2, SQL Server and formats like flat-files, COBOL files, XML, etc.
• Extensive Knowledge of Dimensional Data Modeling of Star Schema/Snowflake and Relational database concepts.
• Expertise in developing SQL,PL/SQL codes through various Procedures/Functions, Packages, Cursors and Triggers to implement the business logics of database.
• Sound knowledge of views, Synonyms, Indexes, Partitioned Tables, Joins and Sub-Queries.
• Experienced in data modeling and data normalization.
• Strong understanding of OLAP/OLTP and relational database design Concepts.
• Experience in Repository Configuration and processing tasks using Workflow Manager & Workflow Monitor to move data from multiple sources into targets.
• Experience with managing ODBC connections.
• Excellent communication skills and ability to learn new things and be highly motivated.
• Involved in Test Planning and execution for various Test Phases: Unit Test, System and User Acceptance Testing.
• Ability to work under stringent deadlines with team as well as independently.

TECHNICAL SKILLS

DWH Tools

: Informatica Power Center 9.1/8.6/ 8.1/ 7 x Business Objects 5.1/5.0,Netezza, TOAD, MS Access

EIM: Informatica Data Quality 9.x/Informatica Data Explorer, Informatica MDM 9.x

BI Reporting Tools: Cognos Analysis, Query Studio (Workspace Advanced)

Languages: Visual Basic, Clear Basic, ASP, PL/SQL, T-SQL.

Data Modeling Tools: Erwin, ER Studio

Databases tools: Oracle 11g/10g/9i/8i, MS SQL Server 2012/ 2008/ 2005/2000 , SQL*Loader,Quest TOAD, UDB DB2 8.0, Sybase.

Environment: Windows Server 2012/2008/2003 , Windows 7 & XP/2000, UNIX,LINUX

CRM Tools: Clarify 8.0/7.0

Scheduling tools: Informatica Scheduler, DAC, Autosys, Tidal Scheduler 2.5/5.3,Crontab, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr Informatica Developer

Environment: Informatica Power Center 9.1.0, Oracle 11g,SQL, PL/SQL, IBM-AIX,DB2, UnixShellScripting, Red hat Linux, PVCS, TOAD,SQL Developer, Business Objects, Autosys, Erwin.

Responsibilities:

• Involved in implementing change management process while fixing the existing code to enhance the code or bug fixing.
• Coordinated with the DBA Teams, Source systems and offshore for different data loads (System test Load, Integration System Test Load, UAT Load and Pre production deployment load) and identified the bugs, new requirement changes and Data Quality Issue.
• Prepared Technical Specification documents (TSD) for Mappings.
• Troubleshooting the issues in Informatica.
• Good understanding of relational database management systems like Oracle,PLSQL,and SQL and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. This led to better session performance.
• Designed and developed Mappings and mapplets with various transformations such as Connected and Unconnected Lookup, XML Source Qualifier, Filter, Joiner, Router, Stored Procedure, Sorter, Expression, Aggregator.
• Developed the code for data extraction, data processing and data warehousing.
• Built-in mapping variable / parameters and created parameter files for imparting flexible runs of sessions / mappings based on changing variable values.
• Planned and executed deployments across all environments.
• Developed Slowly Changing Dimension Mappings for Type 1, Type 2 and Type 3 .
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Performed ETL configuration and troubleshooting.
• Loaded operational data from Oracle, Sql server, flat files, Excel sheets into various data marts.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Used Debugger to fix the defects/ errors and data issues.
• Reviewed ETL code for standards adherence before the migration and tuned mappings and workflows for better performance.
• Migrated the repository objects (workflows) between the folders of different repositories.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision task.
• Used UNIX Shell Scripting to automate the loading process and to generate restart tokens for cold starting the workflows.
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manager.
• Fine-tuned large/complex queries to improve batch load performances.
• Move components across various environments like test, UAT, and production environment.
• Prepared Test preparation and execution plans for different entities and executed the testing with team and Involved in Integration testing.

Confidential, St. Louis, MO

Sr.Informatica Developer

Environment: Informatica Power Center 8.6.1,9.1,Power mart, Oracle 11g,SQL, PL/SQL, IBM-AIX, UnixShellScripting, MS SQL Server 2008, TOAD,SQL Developer, Business Objects, Autosys, Erwin.

Responsibilities:

• Involved in gathering business user requirements, understanding the business model (E-R Diagrams) and database tables.
• Developed Technical design documents (TDD) from user requirements and functional requirements documents (FRD).
• Design, implement and documenting ETL processes data warehousing practices and standards.
• Extensively used Informatica Power center 9.1, Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations etc.
• Used Surrogate keys in the Data Ware house tables to manage the Slowly Changing Dimensions (SCD) properly and easily.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse using different transformations like Joiner, Aggregator, Update Strategy, Router, Lookup, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Designed ETL strategy to load data from source systems such as UDB DB2,Oracle, XML, Flat Files to Target Data Base.
• Worked extensively on Mapping Designer to design and create mappings, transformations to implement transformation logic.
• Extensively used the features of Informatica Version 8.6 including Designer, Workflow manager and Workflow monitor.
• Altered mappings to accommodate new business requirements due to single instance impact at the source.
• Created FTP connections to read data from the flat files from different server.
• Worked with SQL statements for storing, retrieving, and manipulating data in a relational database.
• Created partitions on the sources to improve the performance.
• Hands on Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Created Sessions and Workflows to carryout the ETL process, configured sessions and connection parameters.
• Used SCD Type 1, Type 2 and Type 3 mappings to update slowly Changing Dimension Tables.
• Worked on Informatica developments and enhancements by creating new mappings and making changes to the existing mappings as per the business requirements.
• Developed reusable transformations and mapplets, which were used in other operations.
• Used SQL developer and TOAD to run SQL queries and validate the data in warehouse and data mart.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Used Debugger to test the mappings and fixed the bugs.
• Migrated mappings to various environments like development, testing and production etc.
• Scheduled sessions and work flows using Autosys and Informatica Scheduler.
• Worked with the DBAs for the performance and database tuning.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Created workflows using Session, Command, and Email tasks.
• Developed Unit test cases and Unit test plans to check data is correctly loading.
• Conducted Informatica performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.
• Used UNIX Shell Scripting to automate the loading process.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.

Confidential, Palo Alto, CA

Sr.Informatica Developer

Environment: Informatica Power Center 8.6.1, Oracle 11g,SQL, PL/SQL, IBM-AIX,MS SQL Server 2008, UnixShellScripting, TOAD, Business Objects, Autosys, Erwin, MS Access.

Responsibilities:

• Involved in the full life cycle development of the project including: design, development, and testing.
• Involved in gathering business user requirements, understanding the business model (E-R Diagrams), database table and query design, extracts and use of report query tools and Identify technical risks, assumptions, and dependencies.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule it.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations etc.
• Used Surrogate keys in the Data Ware house tables to manage the Slowly Changing Dimensions (SCD) properly and easily.
• Extracted data from multiple sources such as DB2, Oracle, XML, Cobol, Flat Files & MS Access and loaded the transformed data into targets in Oracle, Flat Files.
• Worked extensively on Mapping Designer to design and create mappings, transformations to implement transformation logic.
• Extensively used the features of Informatica Version 8.6 including Designer, Workflow manager and Workflow monitor.
• Experience in dimensional modeling (star schemas, snowflake schemas /ROLAP, OLAP, MOLAP) .
• Worked with SQL Server SQL statements for storing, retrieving, and manipulating data in a relational database.
• Involved in Data migration, extraction, Data cleansing and Data Staging of operational sources using ETL processes.
• Created partitions on the sources to improve the performance.
• Extensively used Change Data Capture (CDC) approach efficiently to capture only the changed data.
• Used stored procedures for truncating the tables and deleting the rows from error logs.
• Created Sessions and Workflows to carryout the ETL process, configured sessions and connection parameters.
• Worked with the scheduling tool UC4 to schedule the workflow jobs.
• Developed reusable transformations and mapplets, which were used in other operations.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Worked on software engineering/SDLC tools, particularly Microsoft Team Foundation Server (TFS), to document and track work items from initial request through production deployment.
• Conducted Informatica performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.
• Used UNIX Korn Shell Scripting to automate the loading process.
• Developed Unit test cases and Unit test plans to check data is correctly loading.

Confidential, Indianapolis, IN

Sr. Informatica Developer

Environment: Informatica Power Center 8.1.1, Oracle 10g,SQL,PL/SQL,UDB DB2, ODI,Toad, Mercury Test Director8.0,HP-UNIX, Citrix.

Responsibilities:

• Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet designer and Transformations.
• Implemented Joiner, Expression, Aggregator, Sorter, Rank, Lookup, Update Strategy, Filter, stored procedures, Normalizer Transformation and Router Transformations.
• Responsible for managing scope, planning, tracking, change control, aspects of the Informatica Objects.
• Used the Power Center 8.1.1, Designer’s debugger to test and fix bugs in the mappings.
• Generated Reusable Transformations, Mapplets and used them extensively in many mappings.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Created and Monitored Sessions using Informatica Power Center Server to load data in to the Target Database.
• Involved in Informatica GRID configuration & Data Modeling (ERD process).
• Implemented the enhanced ETL mapping to Staging Database and from Staging to Data warehouse star schema.
• Worked on Informatica developments and enhancements by creating new mappings and making changes to the existing mappings as per the business requirements.
• Extensively used ETL to load data from flat files to Oracle and flat files.
• Worked on converting PL/SQL loads to Informatica loads.
• Responsible to tune ETL procedures, processes, and STAR schemas to optimize load and query performance.
• Conducted performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.
• Mercury Test Director is used for assigning and tracking the Change Requests (CR’s) and Test Problem reports (TPR’s).

Confidential, Orange, CA

Informatica Consultant

Environment: Informatica PowerCenter 7.1.1, Oracle 9i, SQL, PL/SQL, Business Objects, Suse Linux, Rational Rose, Clear Case, PVCS.

Responsibilities:

• Participated in build of the Data Warehouse which includes the Design of Data mart using Star Schema.
• Integrated various sources in to the Staging area in Data warehouse for Integrating and Cleansing data.
• Involved in Analysis/Design/Development and Implementation and successfully completed all the work involved in converting the company’s Operational data Store from SQL to Oracle database and deployed the systems in Production, with full Production Support.
• Interacted with business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Extensively used Change Data Capture (CDC) approach efficiently to capture only the changes.
• Responsible for creating and effectively executing deployment plan to move all the objects, tables, mappings, workflows, SQL scripts and created new jobs and their dependencies in Production
• Involved in Control-M Implementation, Extensively used the scheduling tool Control M to schedule jobs and their dependencies in production.
• Completely involved and alert in Easily Solved variety of issues during Production Support, ensuring smooth completion of data loading process.
• Worked with DBA to fine tune complex SQL’s, do regular Run-Stats on the tables, drop and re-create indexes to decrease run times of various Informatica mappings which process large volume of data.
• Extensively worked in planning the Metadata strategy and responsible for maintaining of the Metadata in the Enterprise Data Warehouse (EDW).
• Involved in working with the Data Modeler in Data Modeling.

Confidential, Madison, WI

Informatica Consultant

Environment: Informatica PowerCenter 6.2, Business Objects 5.1, Oracle 9i, SQL,PL/SQL, UDB DB2 8.1, Toad, HP-UNIX, Citrix, eRequester and Rational Portfolio Manager (RPM).

Responsibilities:

• Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet designer and Transformations.
• Worked on Informatica developments and enhancements by creating new mappings and making changes to the existing mappings as per the business requirements.
• Worked on converting PL/SQL loads to Informatica loads.
• Involved in development of various data migrations projects using Informatica like Siebel sales release (extracted and transformed data as per business rules from third party system ‘CALLBACK’ and loaded into Siebel tables), MDR database lease (extracted and transformed data as per business rules from third party leased flat files and loaded into Oracle tables to be used by Business Objects for reports).
• Developed email routines to indicate failure or successful completion of workflows.
• Involved in Migration of project from Development to Production environment.
• Used Repository Manager to create folders, which is used to organize and store all Metadata.
• Created mappings to migrate data from Flat files, DB2, Sybase, Oracle, and MS Access to data warehouse.
• Implemented Joiner, Expression, Aggregator, Sorter, Rank, Lookup, Update Strategy, Filter, stored procedures, Normalizer Transformation and Router Transformations.
• Worked on building Universes and universe modification using Business Objects on Oracle as database.
• Resolved loops by creating aliases and contexts.
• Created Measure Objects, Conditions and Functions as per the User requirements.
• Developed Business Objects reports.
• Involved in preparation of design documents, technical documents and Unit test documents.
• Involved in Application migration phases (Application Specific Migration Phase, Guided and Assisted perform phase and parallel perform phase).
• During Migration prepared various documents like Application specification Plan document, Application information document, Application support control plan and parallel perform completion report document.
• Provided estimates and schedule inputs for service request (both Project service requests and Blanket service requests).
• Responsible for creating all service requests in eRequester application which is used to track build activities and the effort estimates.
• Responsible in creating all the tasks created in eRequester application back in Rational Portfolio Manager (RPM) application which is used for tracking effort tracking, resources allocation and as document repository.
• Assign tasks against Service Requests/Problem Tickets/User Queries to the team members.
• Establish the cause of problem and try to resolve at Onsite.
• Be the primary contact for customer/end-user queries.
• Support release/rollout activities in acceptance and production environments.
• Participate in review of requirements and high-level design with client.
• Review and Monitor progress.
• Ensure compliance with Software Development Life Cycle (SDLC).

Confidential, Ann Arbor, MI

Informatica Consultant

Environment: Informatica Power Center 6.1, Business Objects 5.0, Oracle 9i,10g, MS SQL Server 2000,Red hat Linux, Erwin, UNIX Shell Scripting.

Responsibilities:

• Business Analysis and Requirements Gathering.
• Involved in logical and physical data modeling.
• Analysis and Design of ETL processes.
• Extensively used Business Objects for BI reports.
• Created and managed Universes.
• Extraction, Transformation and Loading of the data Using Informatica Power Center’s Designer and Server Manager.
• Worked on Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer and Transformation Developer.
• Involved in the development of Informatica mappings and also tuned them for better performance.
• Different sessions were run in the Server Manager and the log was studied to modify the mappings to obtain correct result from the transformation.
• Used ETL to load data from source to Oracle database.
• Worked on Data Conversion and Data Analysis. Stored data in the Data Warehouse about Claims, Customers, and Accounts.