SUMMARY

• About 8 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Insurance and Financial.
• Expertise in implementing complex business rules by creating robust Mappings, Mapplets, Sessions and Workflows using Informatica Power Center.
• Strong knowledge in OLAP systems, Dimensional modeling using Star and Snowflake schema.
• Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica Power Center tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor, and Informatica Administration Console).
• Experience in designing/developing complex mapping using transformations like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Normalizer, Joiner, Sequence Generator, Connected and Unconnected Lookup and Update Strategy.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages, Cursors, Triggers, Views, and Indexes in distributed environment.
• Experience in performance tuning of Informatica mappings and sessions to improve performance for the large volume projects.
• Worked extensively in various stages of SDLC like design, development, testing (QA, UAT, and Regression) and production support.
• Worked with cross - functional teams such as QA, DBA and Environment teams to deploy code from development to QA and from QA to Production server.
• Good Experience in creation of Quality related documents (Function specification, ETL architecture design, High Level and Low Level design, and Unit Test Case documents).
• Excellent analytical, problem solving skills with strong technical background and interpersonal skills.
• Excellent client relation skills with the drive to complete tasks effectively and efficiently where customer services and technical skills are demanded as well as the ability to communicate effectively with all levels of management and the client community.
• Good experience in working as part of Agile project team in gathering requirements and analysis
• Extensive work experience on all applications of SAP BO- Crystal Reports, Dashboards
• Extensive knowledge on BO-Admin and LCM.
• Worked along with Developers, Business Analysts to discuss and validate test scripts and other documentation
• Got experience in working with ETL and Data warehouse engineers in BO projects for validation of scripts
• Expertise Domain Knowledge on Finance, Health care.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center (Source Analyzer, Repository Manager, Data warehousing designer, Mapping Designer, Mapplets, Transformations, Work flow Manager, Task Manager).

Reporting Tools: Business Objects, BO Web Intelligence, Xcelsius 2008.

Databases: Oracle 10g,8i,9i

Languages: SQL, PL/SQL, MS-Excel, Unix Shell Scripting.

GUI Tools: SQL Developer.

Manual testing: Functional, System, Integration Testing, E2E testing, regression Testing

Bug Tracking Tools: Fast Issue Track, JIRA, Bugzilla

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential, San Rafael, CA

Responsibilities:

• Quickly adjusted to the environment and understand the complex existing code
• Worked in agile/scrum team environment and delivered end products as per the requirements
• Split complex PL/SQL code to populate Subscription Customer Fulfillment (SCF) data and revenue data separately and reduced overhead
• Designed/developed loading strategies (Full/ Delta) using Informatica
• Created/modified Informatica objects to sync SIEBEL and SFDC systems
• Created mappings, mapplets using various transformations of Look-up, Aggregator, Expression, Stored procedure, Sequence Generator, Router, Filter, and Update Strategy
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Co-ordinated with off-shore/onsite cross functional teams and supported QA/UAT cycle.
• Created design documents, test Documents with expected/actual results and migration documents
• Analyzed/de-bug UAT/QA issues and provided quick turnaround.

Environment: Informatica Power Center 9.1, Windows 7, Oracle 11g, Agile, Scrum, UNIX, Perforce, PL/SQL

Informatica Developer

Confidential, Bloomington, IL

Responsibilities:

• Understanding the Business and Technical migration rules for data mapping from Source to Target.
• Interacting with Requirements team to discuss the updates and discrepancies.
• Preparing SQL scripts for Extraction of data depending upon the required mapping documents.
• Populating data in the Data sheet and applying macros and Transformation logic for specific conditions.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.
• Created various tasks to give various conditions in the workflows.
• Created reusable sessions for different workflows.
• Wrote SQL scripts to verify counts and validate the data.
• Participated in the enterprise performance tuning of Informatica for sources, targets, mappings and sessions.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Worklets and Workflows.
• Created parameters and variables for the reusable sessions.
• Worked with DBA on SQL scripts to automate the process of populating the various columns in the tables with surrogate keys.

Environment: Informatica Power Center 9.1, SQL, PL/SQL, UNIX, Win 7.0, Microsoft Visio

Informatica Developer

Confidential, San Francisco, CA

Responsibilities:

• Performed data analysis based on the source systems and existing OLTP database systems.
• Defined attributes on various dimensions like clinical programs, protocol, subjects, site, design, activities, payments etc to suggest a star schema with the core entity as patient’s treatment records. Knowledge in Dimensional Modeling Techniques to create Dimensions and Fact tables using Erwin.
• Involved in creating, administering repositories, Folders, Permissions and users using repository manger.
• Used ETL to extract and load data from Oracle, Sql server and flat files to Oracle.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like filter, Router, lookups, stored procedure, joiner, update strategy, expressions and aggregator transformations to pipeline data to Data Warehouse/Data Marts.
• Used Power Exchange tool reads the data from oracle redo logs and to create extract maps and supplement logs.
• Tuned performance of Informatica sessions for large data files by implementing pipeline partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval and resolved bottlenecks.
• Involved in production Support and gave training to the users.
• Developed Mappings that extract data form ODS to Data mart and Monitored the Daily and Weekly Loads.
• Used Informatica for migrating data from various OLTP servers/databases.
• Wrote functions, triggers, menus and stored procedures in PL/SQL.
• Wrote SQL validation scripts Source file validation, field and record level validation.
• Created test plans for the various modules, integrated and tested during package release
• Developed UNIX shell scripts as part of the ETL process to schedule tasks/sessions.

Environment: Informatica PowerCenter 8.1, Oracle 9i, SQL, PL/SQL, UNIX, SQL SERVER 2005, Erwin.

ETL Developer

Confidential, CT

Responsibilities:

• Worked Extensively on Informatica tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Designed and developed various mappings and mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data from SQL Server and load to Oracle database.
• Involved in Data modeling and Design of star schema with confirmed and granular dimensions and FACT tables.
• Extracted Erwin physical models into repository manager using Informatica.
• Extensively used transformations such as Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, Look up (Target as well as Source), Update Strategy, Source Qualifier, Stored Procedure and Joiner.
• Responsible for using the capabilities of Power Center namely list files, pmcmd, pmrep, Target override, Connected and Unconnected look up, Persistence lookup, Dynamic & Static lookup.
• Created and ran Pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
• Involved in fixing repository related, Reader process and External procedure problems.
• Identified and tracked the slowly changing dimensions(SCD), heterogeneous Sources and determined the hierarchies in dimensions.
• Developed Informatica Mappings, Re-usable Transformations, re-usable mappings and Mapplets for data load to data warehouse and database (oracle)
• Set up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Involved in writing Triggers on the source to attain Power center change data capture(CDC).
• Extensive use of SQL commands with TOAD environment to create Target tables.
• Perform review of Session log files to trace causes of bottlenecks.
• Created Unit Test plans and involved in primary unit testing of mappings
• Designed and developed a strategy for a specific and vital reporting need. Emphasis was on a design to support current and historic reporting. Data loading mappings were developed in Informatica.

Environment: Informatica Power center 7.1.2(Source Analyzer, warehouse designer, Mapping Designer, Mapplet, Transformations, Repository Manager, Work Flow Manager, Workflow Monitor, Oracle Power Connect), UNIX, Oracle 9i (SQL Plus, PL/SQL), SQL Assist 6.1, Win NT

Data Warehouse Consultant

Confidential, Texas

Responsibilities:

• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Created various transformations such as Update Strategy, Look Up, Joiner, Filter and Router Transformations.
• Created cubes, dimensions, hierarchies, mappings and complex mapplets using Informatica Power Center 7.1
• Created Pipeline partitioning to improve session performance
• Involved in the creation of oracle Tables, Table Partitions, and Indexes.
• Involved in writing lot of Functions, Stored Procedures.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor
• Worked with physical and logical data models of Erwin.
• Generates reports using Business Objects Universe
• Execute Backend Testing application by writing complex Sql Queries
• Creating Relational Connections, Migrating the Mappings from Dev to Test and Test to Production
• Involved in Scheduling the Jobs using UNIX (IBM - AIX) AUTOSYS Tool.
• Involved in production Support and gave training to the users.
• Loaded consolidated data using SQL*Loader in parallel and direct mode
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Involved in writing shell scripts on UNIX (IBM - AIX) for Informatica ETL tool to run the Sessions

Environment: Informatica Power Center 7.1, Oracle 9i, Sqlserver2000, PL/SQL, Sybase, Business objects, Java, Unix, Erwin.