SUMMARY

• Over 7 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• 7 years of ETL experience using Informatica Power Center 9.1.0/8.6/8.1, Informatica Power Exchange 9.1
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema. Designed data models using Erwin.
• Experience in Business Intelligence in generating various reports using Business Intelligence tool OBIEE.
• Proficient experience in different Databases like Oracle, IBM DB 2, SQL Server, MS Access.
• Proficient experience in different files like XML, .csv, .dat, .txt.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Experience in Performance Tuning of sources, targets, mappings and sessions.
• Application Data warehousing experience in Healthcare, Insurance, Telecom, Confidential .
• Performed Unit, Integration and System Testing.
• Good analytical and problem solving skills.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.1.0/8.6.1/8.5/7.1 Informatica Power exchange 8.6.1(Designer, Workflow Manager, Workflow Monitor, Server Manager),Informatica Power Connect, OLAP

Data Modeling: Erwin 4.0/3.5, Star Schema, Snow Flake

Databases: Oracle 11g/9i/8i, MS SQL Server 2005/2000, MS Access, DB2

Business Intelligence: OBIEE

Languages: SQL, PL/SQL, C

Tools: Toad, SQL* Loader

Operating Systems: Windows 7/XP/98/2000 Server, Linux

PROFESSIONAL EXPERIENCE

Confidential, LA

Sr Informatica Developer

Responsibilities:

• Develop much of the ETL processes for loading the Ochsner data warehouse from 83 different source systems including mainframe data in both VSAM and sequential files, Microsoft SQL Server, Oracle, flat - files, XML based data and unstructured data. This ETL consists of more than 300 Informatica mappings and associated workflows.
• Responsible for automation of ETL process execution using Informatica based “master” workflows and scheduling, coordinating system extraction and load to ensure that all loads complete with acceptable performance and in proper order.
• Performance tuning of ETL processes to ensure that incremental loading takes place in a timely manner and that all data is made available for the organization’s use as early and often as possible.
• Provide support and assistance to other developers on complex Informatica development issues.
• Derive data warehouse model and data requirements from user-interviews, data mining and analysis, and business process analysis. The data warehouse structure is not predefined but must be generated based on an understanding of Ochsner business processes. Develop this understanding with subject matter experts and validate assumptions against source data to ensure that subject matter experts have a correct and complete picture of the way things “actually are” rather than how they “should be”.
• Data warehouse was developed in record-time, coming into production from initial conception within 4 months, considerably faster than most data warehousing efforts of much smaller size.
• Monitor all production loading processes and intervene to correct issues as they arise to ensure timely and correct data loading.
• Develop and implement plans to run data corrections as issues in the existing data warehouse structure or data are discovered to minimize need for reloads and provide the ability to repair shortcomings.
• Gain an understanding of healthcare data and processes, labor analysis data and processes, and accounting, billing and clinical data and processes.

Environment: Informatica Power Center 9.1.0 (Power Center Designer, workflow manager, workflow monitor), Power Exchange 9.1, Oracle11g/R2,SQL Server, Mainframe, OBIEE 10.1.3.4, Toad Data modeler 3.6, Toad for Oracle 10.6, Windows XP professional, Novell GroupWise

Confidential, MN

Sr Informatica Developer

Responsibilities:

• Gather; analyze business and functional requirements and translating them into technical specifications.
• Assisted in Creating Logical and Physical Data Modeling.
• Creating the design and technical specifications for the ETL process of the project.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked on different types of SCD’s like Type 1 and 2.
• Designing and creation of complex mappings using SCD type II.
• Extracted data from various sources like IBM DB2, Oracle, flat files and generated XML files as Targets.
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Warehouse Designer and Transformation Developer.
• Designed and developed Informatica Mappings and sessions based on business rules.
• Developed several Mappings and Mapplet’s using corresponding Sources, Targets and transformations such as expression, joiner, aggregator, lookup, update strategy, filter.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Created Post session commands to move files from Informatica server to other location.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Extensively developed Informatica mappings & tuned them for better performance.
• Creating the catalogs and analyzing the joins.

Environment: Informatica Power Center 8.6.1 (Power Center Designer, workflow manager, workflow monitor),Lotus Notes, IBM DB2 V5/R4, Oracle9i, Erwin 3.5.2, Windows XP professional, Altova XML Spy, IT2B.

Confidential, Bloomington, IL

Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection of various projects like Fixed Asset, GL Mart, Revenue Mart, Data warehouse restructuring.
• Created mapping documents to outline data flow from sources to targets.
• Designed various mappings using Informatica Designer to load Dimensions and Facts.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Was responsible for creating of PL/SQL Packages, procedures, cursors using dynamic sql, ref cursors etc.
• Migrated Data stage into Informatica.
• Created various Workflows, worklets and Sessions for the mappings to run.
• Used various transformations like Aggregator, Joiner, Expression, Filter and Router, Lookup, Update Statergy, Sequence Generator to transform the data.
• Modified existing mappings for enhancements of new business requirements.
• Worked with the DB team to put database changes in place for the mappings to run.
• Used sql*plus to load oracle tables where there was no need for Informatica to be used.
• Used the ETL standard’s to load the Dimension and Fact tables daily by scheduling the workflow using informatica scheduler.
• Extensively worked as production support developer to identify and fix data problems.
• Created technical support documentation for the team for production support.
• Extensively used parameter files to pass parameter called LAST EXTRACT DATE which would get the data only for particular dates.
• Created test scenarios to test the functionality of the mappings.
• Worked on the three tier model (DEV, TEST, and PRODUCTION).
• Followed standard procedures to migrate the mappings from Development to Test and Production environments.
• Used the email task in the Production to keep the team posted when session’s fail.
• Documented, Explained and demonstrated the load process to the team.
• Maintained the version control of all the code and documentation using VSS as a tool.
• Created store procedures to implement the logics and using them in Informatica.
• Extensively used environments to create shell script and maintaining the logs of Informatica admin console.

Environment: Informatica 8.1/7.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor, Oracle 9i (Toad), Erwin 4.0, SQL Server 2005, PL/SQL Developer, Windows XP professional.

Confidential

ETL /Data Warehouse Developer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Involved in Designing Logical and Physical Data model using Erwin Tool.
• Creating the design and technical specifications for the ETL process of the project.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked on Business objects version 6.5
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, SQL Server, flat files and loading to Oracle target database.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Aggregator, Filter, and Lookup.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented complex mappings such as Slowly Changing Dimensions.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Built in mapping variable/parameters and created parameter files for imparting flexible runs of workflows based on changing variable values.
• Designed and Developed pre-session, post-session routines for Informatica sessions to drop and recreate indexes and key constraints for bulk loading.
• Maintain Development, Test and Production mapping migration Using Repository Manager.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Created adhoc reports using Business Objects.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.

Environment: Informatica Power Center 7.1, (Power Center Designer, workflow manager, workflow monitor), Oracle9i, SQL Server 2005, SQL*Loader, Erwin 4.0, UNIX, Windows 2000, TOAD7.0, Business Objects 6.5