SUMMARY

• Over 9+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Telecom and Manufacturing Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, Informatica MDM, ETL, OLAP, BI, Client/Server applications.
• Having good understanding of Master Data Management (MDM) architectures and business processes
• Participated in the requirement gathering/ solution architecture for MDM initiatives.
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, writing and customizing user exits, customizing/configuring Data Director.
• Have good experience in Informatica MDM Data Manager and Merge Manager tools
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects
• Work with business to gather requirements and define the Data Quality solutions for data profiling, standardization and cleansing etc.
• Extensive experience working as a Business Intelligence Consultant with specialization in Crystal reports and COGNOS.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Experience in creating ad-hoc reports using Business Objects Web Intelligence tools.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools: Informatica power center/Exchange 7.x/8.x/9.6.1, Informatica MDM Multi-Domain 9.x Informatica IDQ, Informatica Metadata Manager.

Reporting Tools: Knowledge on OBIEE, Tableau

OLAP TOOL: Business Objects XIR3

Version control: Microsoft visual studio, Peregrine

Databases: Oracle 11g/10g, SQL Server 2005/2008 R2

Languages: T-SQL, PL/SQL, basic Unix Shell Script.

DB Tools: Toad, SQL* Loader, SQL server management studio

Scheduling Tools: DAC, Control-M

ERP Systems: SIEBEL, EBASE, PEOPLESOFT

Operating Systems: Windows 2003/08, UNIX,LINUX - UBUNTU

PROFESSIONAL EXPERIENCE

Confidential, Houston/TX

Sr. ETL/Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Extensively used Informatica Client tools - Informatica Repository Manager, Informatica Designer, Informatica Workflow Manager and Informatica MDM Workflow Monitor.
• Created ETL mappings, sessions, workflows by extracting data from MDM system, FLASH DC &REM source systems.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Involved in writing UNIX shell scripts for Informatica MDM workflows/jobs to run on Tidal scheduler.
• Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting
• Provided Ongoing support to BI applications running in production & troubleshoot any issues.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Develop complex Business Intelligence solution for Customer Business using coding skills on Informatica, Teradata, DB2 and Oracle and also involve in review of test case with consent with Customer Interaction.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• 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.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Understanding existing business model and customer requirements to understand technical design.
• Gathering and analyzing business and technical requirements.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 8.6.1, Workflow Manager, Informatica Master Data Management (MDM) 9.5.1 Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, Sybase, UNIX AIX, Toad 9.0, Cognos 8.

Confidential, CT

Sr.ETL/Informatica Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA.
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Worked on Master Data Management (MDM), Hub Development, extract, transform, cleansing, loading the data onto the staging and base object tables.
• Created cleanse functions to use in mappings for cleansing data and loading onto staging tables.
• Design, develop, test and review & optimize Informatica MDM and Informatica IDD Applications.
• Developed mappings for loading data from landing tables to staging tables in Master Data Management.
• Good experience working on Informatica MDM Client tools Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica PowerCenter Designer 8.6/8.1, Informatica Master Data Management 9.5 Informatica Repository Manager, Oracle10g/9i,DB2 6.1, Erwin, TOAD, SAP Version: 3.1.H,Unix- SunOS, PL/SQL,SQL Developer

Confidential

ETL/Informatica Developer

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for all the projects.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Work lets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Conducted code reviews developed by my team mates before moving the code into QA.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Modified existing mappings for enhancements of new business requirements.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in production support.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica Power Center 9.1.0, Oracle 11g, SQLServer2008, IBM ISeries (DB2), MS Access, Windows XP, Toad, Tidal, Cognos 8.4.1., SQL developer.

Confidential

ETL Developer

Responsibilities:

• As a Data Warehousing team member, Involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the banking data from various source systems feeds using Informatica, PL/SQL and Unix Shell scripts.
• Involved in Data Extraction, Staging, Transformation and Loading and worked with Oracle Application Integration
• Creating Informatica mappings for populating the data into dimension tables and fact tables from ODS tables.
• Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformations.
• Created Informatica Mappings with PL/SQL procedures/functions to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and update strategy.
• Created sessions and batches. Used parameter files to pass variable values.
• Generated Reports using Business Objects.
• Created Dimension objects keeping in view of the end-user requirement. Created User Prompts, Conditions and Filters to improve the report generation.
• Used Hierarchies for providing drill down options for the end-user.
• Created Master Detail and Cross Tab Reports.

Environment: Informatica 6.5, Test Director, Cognos EP Series 6.5 (Impromptu, IWR, Upfront, Powerplay, Transformer, Access Manager), TOAD 7.1, IIS Web Server, SQL, PL/SQL, SQL Server2000, Oracle 9.1, DB2, IBM AIX, Windows 2000/NT.