SUMMARY

• About 9 years of IT experience in teh 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 teh 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 teh drive to complete tasks TEMPeffectively and efficiently where customer services and technical skills are demanded as well as teh ability to communicate TEMPeffectively with all levels of management and teh 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 teh environment and understand teh complex existing code
• Worked in agile/scrum team environment and delivered end products as per teh 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 teh performance tuning of teh 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 teh Business and Technical migration rules for data mapping from Source to Target.
• Interacting with Requirements team to discuss teh updates and discrepancies.
• Preparing SQL scripts for Extraction of data depending upon teh required mapping documents.
• Populating data in teh Data sheet and applying macros and Transformation logic for specific conditions.
• Created Mapplets to reuse all teh 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 teh workflows.
• Created reusable sessions for different workflows.
• Wrote SQL scripts to verify counts and validate teh data.
• Participated in teh enterprise performance tuning of Informatica for sources, targets, mappings and sessions.
• Performed Unit testing on teh Informatica code by running in teh debugger and writing simple test scripts in teh database theirby tuning it by identifying and eliminating teh bottlenecks for teh optimum performance.
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Worklets and Workflows.
• Created parameters and variables for teh reusable sessions.
• Worked with DBA on SQL scripts to automate teh process of populating teh various columns in teh 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 teh 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 teh 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 teh source and target database schemas, and teh Mapping Designer to map teh sources to teh 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 teh 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 teh users.
• Developed Mappings that extract data form ODS to Data mart and Monitored teh 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 teh various modules, integrated and tested during package release
• Developed UNIX shell scripts as part of teh 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 teh 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 teh Debugger to monitor and test teh sessions prior to their normal run in teh Workflow Manager.
• Involved in fixing repository related, Reader process and External procedure problems.
• Identified and tracked teh slowly changing dimensions(SCD), heterogeneous Sources and determined teh 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 teh loads at required frequency using Power Center Workflow manager.
• Involved in writing Triggers on teh 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 teh 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 teh Mappings from Dev to Test and Test to Production
• Involved in Scheduling teh Jobs using UNIX (IBM - AIX) AUTOSYS Tool.
• Involved in production Support and gave training to teh 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 teh target Data.
• Involved in writing shell scripts on UNIX (IBM - AIX) for Informatica ETL tool to run teh Sessions

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