SUMMARY

• Overall 7 years of IT experience in System Analysis, Design, coding and testing of Data Warehousing implementations across Financial, Insurance, pharmaceutical and Telecom Industries.
• Involved in various stages of Software Development Life Cycles (SDLC) including requirements analysis, design, development, testing and implementation.
• Expert in tasks associated with data such as data analysis, data validation, data modeling and data cleaning.
• Up to speed in ETL development using Informatica PowerCenter (Admin, Designer, Workflow Manager, Workflow Monitor, Repository Manager, and Metadata Manager) for extracting, cleaning, managing, transforming and finally loading data.
• Implemented Performance tuning concepts for Informatica at database, designer and workflow manager for the faster retrieval of data.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling developing Database Schemas like Star flake schema and Snowflake schema used in relational, dimensional and multidimensional modeling
• Knowledge of data ware house methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.
• Experience with Type1, Type2, Type3 Dimensions
• Skilled in the installation, configuration and administration of Informatica 7.x and 8.x.
• Proficient in the integration of various data sources such as DB2, SQL Server, Oracle, XML Files, Fixed Width Flat Files, Delimited Flat Files and Oracle 11i ERP into ODS.
• Proficient in UNIX Shell Scripting.
• Strong experience on Installation of Informatica and configuration of Informatica Power Center 8.6 on windows.
• Experience in implementing of Change Data Capture using Oracle stored procedures.
• Experience in using Versioning features in Informatica such as Deployment Groups, Labels and Object Queries.
• Experience in effectively using different migration methods in Informatica
• Working knowledge of PL/SQL, SQL, programming.
• Excellent work ethics, strong communication skills and interpersonal skills that help in communicating with the fellow team members, Managers, Developers and Users.

TECHNICAL SKILLS

Data Warehouse: Informatica 6/7.x/8.x

Languages: PL/SQL, SQL, T-SQL, C, C++

Database: Oracle 8i/9i/10g, DB2, SQL Server, MS Access

Oracle Tools: SQL*Loader, TOAD, SQL Navigator, SQL*Plus

Operating Systems: Windows 98/NT/2000/XP/2007/VISTA, UNIX, LINUX

Data Modeling: Erwin, MS Visio 2007

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

DWH Consultant

RESPONSIBILITIES:

• Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• To build ETL Specification document based on Functional Requirement.
• Involved in parsing of XML documents to fetch the data from xml through PL/SQL and store in oracle tables.
• Implemented and reviewed the transformation logic in the ETL mappings according to the pre-defined ETL standards.
• Created Mappings, reusable transformations using Designer of Power Center (Informatica Tool).
• Sophisticated transformations are implemented using Informatica features like Aggregator, Filter, Expression, Normalizer, Lookups, UPS and Source Qualifier and etc.
• Using Joiner transformation for extracting data from multiple sources.
• Implemented performance tuning logic on sources, mapping, sessions and targets in order to provide maximum efficiency and performance.
• Defined Target Load Order Plan for loading data into Target Tables.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Coding & Debugging, Sorting out their time-to-time technical problems.
• Created error log table to capture the error messages, session load time.
• Used Workflow monitor to see the work flows running and get the session properties and session log.
• 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 various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Wrote PL/SQL stored procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Develop and/or update Technical documentations i.e. operational manual etc.
• Develop new and support existing ETL processes using the Informatica Tool.
• Performance tune databases and SQL statements in connection to ETL code as required Perform source system analysis as required.
• Develop stored procedures, database triggers and SQL queries where needed.

Environment: Informatica Power Center 8.6.1,Erwin 4.x,Oracle 10g, PL /SQL, UNIX, UC4, CSV, XML.

Confidential, TX

Informatica Developer

RESPONSIBILITIES:

• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/ Reusable Objects/ Transformation/ mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 7.1.1/ 8.6.1
• Knowledge in upgrading from Informatica version 7.1.1 to 8.6.1.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.1./7.1.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
• Worked with Web services.
• Created SSIS Packages to migrate slowly changing dimensions.
• Created E-mail notifications tasks using post-session scripts.
• Deployed SSIS packages and Scheduled Jobs.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support to develop the entire warehouse architecture and plan the ETL process.

Environment: Informatica Power Center/ Power Mart 8.6.1/7.1.1 , Oracle 10g/9i, SQL, PL/SQL, XML,AS 400, MS Access, Web services, JAVA,UNIX, UDB DB2 8.1, Shell Script, SSIS.

Confidential, Charlotte

Sr. Informatica Developer

RESPONSIBILITIES:

• Worked with architect and business managers to understand the requirement. Communicated with the DBA group to understand the source systems as well.
• Worked with Database people to understand the environment. How they are managing source systems.
• Worked with Data modeler to understand the source to target mapping documents, the structure of the tables, how the final target looks like.
• Worked with DBA team to formulate the incremental loads, change data capture process to Informatica interface.
• Worked on E/R studio 7.6 and interacted with data architect to design source to target mapping document.
• Created mappings of initial load for all source systems, cleansed data and load it into staging area.
• Created mappings for initial load in PowerCenter Designer using the transformations Expression, Aggregator, Joiner, Normalizer, and Source Qualifier.
• Created complex mappings for full load into target in PowerCenter Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, Union, Rank, Stored Procedures, External Procedure, Sequence Generator and Transaction Control.
• 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.
• Implemented Type 1 and Type 2 Slowly Changing Dimensions for each data set.
• Created various tasks like session, email, command, event raise and event wait to give various conditions in the workflows.
• Created reusable sessions for different workflows.
• Worked on Cumulative Fact (Aggregate fact tables), Atomic Fact loading from all Dimensions in the Target. (Star Schema)
• 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 Stored Procedures and Functions, Testing of Informatica Sessions, Worklets and Workflows.
• Used Informatica Scheduler to schedule the work flows as this organization is having Tidal Scheduler (Optional)
• Created parameters and variables for the reusable sessions. Created Email task, Decision task
• Worked on SQA environment to test the data before we move into Production Environment. Worked with DBA group to resolve performance.
• Responsible for creating the parameter files in order to connect to the right environment and data base.
• Worked with DBA on SQL scripts to automate the process of populating the various columns in the tables with surrogate keys
• Worked with data architect to create table and column definition to prepare the data dictionary for users.

Environment: Informatica Power Center 8.6.1, Oracle 9i, Oracle 11i RAC, PL/SQL, SQL, UNIX, Shell script, Toad 8.5.1, E/R Studio 7.6, SQA

Confidential, IN

ETL Developer

RESPONSIBILITIES:

• Extensively used Informatica PowerCenter 7.1.2/8.1 to extract data from various sources and load in to staging database.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle 9i) using Informatica PowerCenter 7.1
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Designed Logical and Physical Modeling using Erwin Data Modeler tool.
• Did data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
• Created data stores, project, jobs, and data flows using Data Integrator.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• In charge of converting data using SQL Server 2005 using SSIS.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designing mapping templates to specify high level approach.
• Involved in creating/modifying reports using Business Objects and Web Intelligence.
• Developed PL/SQL scripts to move historical data from ERP sources to BOW.

Environment: Informatica PowerCenter 8.1.1, Oracle 10g/9i, Business Objects XI R2, Web Intelligence 2.5, PL/SQL, TOAD, SQL*Plus, Erwin, Windows, UNIX HP UX, Control M.

Confidential, IL

Informatica Developer

RESPONSIBILITIES:

• Participated in requirement meetings with Business Analysts and End Users to understand analytical content needs, assisted in documenting these requirements, resolving ambiguities, conflicts, and ensuring requirements are complete.
• Worked with DBA/architect to provide input on various project related schema and architecture of the data marts.
• Analyzed the functional specifications provided by the data architect and created technical specs documents for all the tasks.
• Created new mappings, modified existing mappings, sessions, workflows to comply with the new architecture.
• Developed a new historical data mart for collections, tasks included gathering the information, defining the schema, creating scripts to drop and recreate the indexes, creating and scheduling the workflows to run along with the already existing nightly jobs.
• Analyzed and created various Fact and Dimensions tables.
• Implemented various Slowly Changing Dimensions (SCD - Type I & II) as per the requirements.
• Worked heavily on production support and fixing the issues to ensure data marts are online under SLA.
• Performed code reviews.
• Performed repository backups and managed folders, user access, connection variables for dev, sys, UAT and production.
• Used Informatica partitioning to increase the performance of the mappings.
• Created various tasks like session, email, command, event raise and event wait to give various conditions in the workflows.
• Worked on the deployment of new code from one environment to other during the release.
• Worked with Business Objects developers to assist them in the development of various reports.

Environment: Informatica power Center 7.1.2/8.1, SQL Server 2005, Oracle, Siebel, Star Team, Lawson, Tidal, Erwin, Business Objects, and PL/SQL.

Confidential, NJ

Informatica Developer

RESPONSIBILIES:

• Converted historical healthcare data into the new streamlined standards. Created new mappings for different business needs
• Collaborated with Business Analysts to ascertain the issues with the existing data warehouse. Modified mappings to conform to business rules
• Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc
• Worked on different data sources like facets, Medco, labcorp; tasks included cleansing the data, providing the claims data coming from facets into a flat file in the desired format.
• Worked on reading the data from VSAM files and transferring into staging area.
• Prepared the code migration document and worked with release team to migrate the code from one environment to other.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and sequence buffer length.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, Worklets and Workflows.
• Developed shell scripts to perform the testing.
• Responsible for creating the parameter files in order to connect to the right environment and data base.
• Worked with DBA on SQL scripts to automate the process of populating the various columns in the tables with surrogate keys.
• Provided production support.
• Conceived unit, system, integration, functional, and performance test plans.
• Involved in preparing detailed ETL design documents.

Environment: Informatica Power Center 7.1, DB2 8.0, COBOL, VSAM files, UNIX shell scripting, Control Center, Ultra Edit 10.10a, Win SQL 5.0.

Confidential

ETL Developer

RESPONSIBILITIES:

• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations.
• Cleanse the source data, Standardize the Vendors address, Extract and Transform data with business rules, and built Mapplets using Informatica Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement the ETL jobs using Informatica.
• Created Users, user groups, database connections and managed user privileges using supervisor.
• Created universe and reports.
• Involved in creating desktop intelligence and web intelligence reports.

Environment: Informatica Power Center 5.1.1, Windows NT, PL/SQL, Excel, SQL Server 7.0, Erwin, Business Objects 6.5/5.1.