SUMMARY:

• Around 6 years of IT experience in Development and Implementation of EIM services using Informatica Master Data Management, Informatica Power center, Data Quality in various organizations such as Banking, Insurance, Telecommunication and Pharmaceutical.
• Expertise in all phases of Systems Development Life Cycle from analysis, requirement gathering, planning to development and deployment.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Experienced in Installing, Managing and configuring Informatica MDM core component such as Hub Server, Hub Store, Hub Cleanse, Hub Console, Cleanse Adapters, Hub Resource Kit.
• Experience in defining and configuring landing tables, staging tables, base objects, lookups, query groups, queries/custom queries, packages, hierarchies and foreign - key relationships,
• Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Designed & developed multiple cleanse function, Graph function and standardization scenarios using Address Doctor.
• Configured JMS Message Queue in the MDM hub Console.
• Configured Soap based SIF API calls by using Soap UI for performing multiple tasks in Informatica MDM Hub.
• Experience in configuring Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, Profiles using Hierarchy tool.
• Successfully, setup the data and configured the components needed by Hierarchy Manager for MDM HUB implementation which included implementing hierarchies, relationships types, packages and profiles by using hierarchies’ tool in model workbench.
• Developed workflows to data domains for performing data extraction, data validation, data cleansing, data match, data load and required data related activities to support Customer’s MDM requirements.
• Experience in several facts of MDM implementations including Data Profiling, data migration, validation, reject processing and pre-landing processing.
• Responsible for creating user groups, privileges and roles to the users using Security Access Manager (SAM).
• Configured Informatica Data Director (IDD) for data governance to be used by the business users, IT Managers and Data Stewards and also implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data.
• Well acquainted with deploying multiple Application Servers such as Jboss, Weblogic and Web sphere
• Having Good Knowledge of Data Warehousing concepts. Strong knowledge and understanding of all phases of Software Development Life Cycle (SDLC) Methodology, Waterfall, V Model from project definition to post-deployment.
• Extensive experience in design of Multi-Dimensional modeling concepts like Star and Snowflakes schema.
• Good development experience in Informatica (9.1/9.5) Power Center- ETL tool and Informatica Data Quality (IDQ) tool.
• Experienced in working with tools like TOAD, SQL Developer and SQL plus for development and customization.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Aggregator, Router, Filter, Update Strategy, Lookup, Sorter, Normalize, Union, Stored Procedure, and Sequence Generators.
• Created, launched & scheduled workflows/sessions and extensively involved in the performance tuning of mappings and sessions.
• Strong experience in designing and developing mappings to extract data from different sources including flat files, RDBMS tables and XML files.
• Experienced in Data Cleansing and Data Standardization using Informatica Power center and UNIX Shell script by using Reference Data/Golden copy.
• Exposure in preparation of Technical Design document, Test cases and Unit test documents.
• Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

EIM tools: Informatica MDM Multi-domain 9.5.1/9.7.1 , IDD, SIF.

ETL tools: Informatica Power Centre 8.X, 9. X.

Cleanse Adapters: Address Doctor, Trillium

Databases: Oracle 10g/11g, My SQL 5.0/4.1, SQL Server 2008, MS Access

Editors: SQL Navigator, Toad

Data Modeling: ERWIN 4.0, MS Visio

Programming Skills: SQL, PL/SQL, C, C++, UNIX Script, Java

Application Servers: Web Logic 10.x/9.x, JBoss

Environment: Windows OS, UNIX, Windows SERVER 2003/08

BI Reporting Tools: MS Excel 2010, SSIS, SSRS.

PROFESSIONAL EXPERIENCE:

Senior Informatica MDM developer

Confidential, Houston, TX

Responsibilities:

• Installing and Configuring of Informatica MDM Hub Console Hub Store Cleanse and Match Server Address Doctor Informatica Power Center applications.
• All facets of MDM implementations including Data Profiling metadata acquisition data migration validation reject processing and pre landing processing.
• Performing requirement gathering analysis design development testing implementation support and maintenance phases of both MDM and Data Integration Projects.
• Master Data Management MDM Data Integration concepts in large scale implementation environments.
• Creating landing tables Staging tables Base Tables as per the data model and data sources.
• Developing mappings using various cleanse functions and Address doctor functions to move data into Stage tables
• Defining Trust Score Validation rules Match rules and Merge settings.
• Closely worked with other IT team members business partners data stewards stakeholders steering committee members and executive sponsors for all MDM and data governance related activities.
• Developing the IDD application building Hierarchies as per the business needs.
• Working with Power Center Designer Repository Manager Workflow Manager and Workflow Monitor.
• Worked on Real Time Integration between MDM Hub and External Applications using Power Center and SIF API for JMS.
• Supporting role towards Business Analyst and Team lead in requirement phase, peer review and preparing high level design.
• Developed the code based on Low level design - includes more detail information tables, database and data flow.
• Created ETL jobs and mappings with the help of Informatica power center to integrate the data from different heterogeneous sources like flat files, .csvs, ms SQL database, oracle database.
• Development includes two crucial jobs - Pre-landing job and Landing job in ETL. Jobs perform pass through mappings for moving data from staging to landing tables.
• MDM development includes creating Base object tables, staging tables and landing tables as per requirement in LLD.
• Created individual mappings (i.e. Stage jobs) for moving data from landing table to staging tables. Staging tables are like raw table, history records, prl table - Delta detection (Incremental) and reject table.
• Configuring the trust and validation in base object columns as per business requirement.
• Ran the load jobs for moving data from Staging tables to base object tables. Base object tables more like Bo tables, Xref tables history tables etc.
• Configured Trust and created Queries & package to integrate the Trust score.
• Involved in creating various Match rules. Two match rules, Fuzzy match will be set based on token known as tokenization and Exact match will give exact record information.
• Also configured many merge rules (Auto merge and Manual merge). However we had data stewards who will handle the manual merge activity by manual intervention.
• Published the records to downstream applications with help of ETL power center with the help of message queue.
• Configured IDD for client usage on web application. Clients can access the master record and update the information directly in base object.
• Setup SIF for java application communication and interfacing the IDD as required.
• Created User exit features extending the functionality and features of MDM HUB.
• Design and development test scenarios for unit and integration testing, as well as positive and negative testing and generating the test data as per test cases.
• Preparation of test cases and code review document, debugging the defects identified and fixing them.
• Updating the code into production with proper version.

Environment: Informatica Multi domain MDM 9.5.0, JBoss 5.1, Oracle 11g, Address Doctor 5, IDD, SIF, Informatica Data Quality (IDQ) 9.5.0, Informatica Power Center 9.1.0, Toad, SQL*Loader, Windows Server 2008XP.

Senior Informatica MDM developer

Confidential, St Louis, MO

Responsibilities:

• Having strong understanding in Product life cycle, Data governance, Data quality, Data security for products across the enterprise from many disparate systems.
• Interacted with the Business Users & Enterprise Data Architects in the analysis & design of conceptual and logical data model that is required for solid MDM implementation & ensuring that it meets the business requirements and also supports the products capabilities.
• Involved in all phases of the project SDLC planning, design, documentation, configuration, testing activities and code migration.
• Worked w /Data Profiling Team in analyzing the source systems data for duplicative and quality issues.
• Performed data profiling of reference data for large data sets using Informatica Data Analyst tool.
• Worked w/ ETL team in configuring the landing tables’ structure according to standardization of the Client.
• Configured Base Object Tables in schema and relationship tables in hierarchies according to data-model.
• Configured Landing Tables, Staging Tables, Look-ups, Cleanse Lists, Cleanse functions, Mappings, Audit trail/ Delta detection.
• Creating project plans, design and development Building a data model according to business needs by interacting with data architect.
• Configured the three Source system from which approximately 1.2 million data will be used in landing process.
• Configured Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, query groups, packages and custom cleanse functions.
• Defined System Trust and Validation rules for base object column.
• Worked in implementation of Profiling, Score Card, Classifier models, Probabilistic models, Human task and Exception record management as part of IDQ process.
• Experienced in customizing error messages displayed on the IDD screen.
• Configured Search Strategy, Match rule sets, Match Columns for Match and Merge Process in improving data quality by match analysis.
• Created Queries, Query Groups and packages in MDM Hub Console.
• Implemented inserting/updating strategy using batch process which is done nightly, SOAP for near real time data and IDD
• Configured Informatica Data Director (IDD) in reference to the Data Governance of users, IT Managers & Data Stewards.
• Created and deployed new applications in Informatica Data Director and binding application to a specific ORS
• Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to different environments.
• Performed testing on data validation, Batch Jobs and Batch groups.

Environment: Informatica MDM 9.5.0, Informatica MDM Data Director 9.1.0, Informatica Data Quality (IDQ) 9.5.0, Informatica Power Center 9.1.0, AQT 9.0, Erwin Jboss, HP Quality Center 9.2, Windows XP.

Informatica MDM Developer

Confidential, Rosslyn, VA

Responsibilities:

• My role here at the client is to configure MDM and develop IDD application.
• Worked with Business Analyst and end users to generate Requirement Document according to business needs for Customer Master ORS.
• Involved in landing the data from Seven Different source systems by running external batch process to load business data for creating customer master data. External batch process used was ETL process.
• Developed and managed relationships between data domains for the data models.
• Involved in loading data from different sources to staging area by cleansing data to do this we are using Trillium services and Duns Numbers from Duns and Bradstreet (DNB). After getting data as per business requirement from DNB and Trillium we are loading data to the ware house.
• Created Base objects, staging tables, loading tables and foreign key relationships for a defined party model for Customer Master ORS.
• Created mapping document and mappings in MDM HUB ORS using various cleanse list and cleanse functions.
• Defined Trust and validation rules for base table defined by End users and BA team.
• Performed Match and Merge Rules as per business requirement on source data.
• Configured IDD application for Party Communication, Party to Party Rel and Master Guarantee Agreement Subject Area required for data governance used by the Data Services Team.
• Created queries, procedures and packages in MDM Hub for displaying and updating the data.
• Established data quality rule and data quality improvement, defined data mining and performance optimization policies for customer master data.
• Created Roles and privileges for Read Only and Data Entry for Data Entry Team users.
• Involved in Data Steward Activities like manual Merge/Unmerge and updating data.
• Used metadata manager for importing, exporting, validating the data for transforming the schema from development environment to testing environment.
• Configured Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, and Profiles using Hierarchies tool.
• Improved the data quality by Match analysis, analysis of the MDM system performance and tuning the performance by changing the existing cleanse function and match rules.
• Experienced in Metadata manager to Import and Export of Metadata and Promote Incremental changes between environments from development to testing environment.
• Created user groups, privileges and roles to the users using Security Access Manager (SAM).

Environment: Oracle 11g, Informatica MDM (Formerly Siperian) 9.1, TOAD, JBoss, Address Doctor 5.

Informatica developer

Confidential

Responsibilities:

• Mainly involved in ETL developing.
• Created data extracts and reports using Microsoft SQL Server Suite (SQL Server Integration Services and SQL Server Reporting Services).
• Worked closely with Business Analysts and SMEs to understand business requirements.
• Designed, developed and maintained complex business intelligence reports.
• Designed and developed SQL Server stored procedures, functions, views and triggers to be used with ETL & reporting processes.
• Created source-to-target mappings for loading data warehouse/data marts.
• Perform data analysis of structured and unstructured data, performance tuning of ETL processes.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Recommended new and modified reporting methods and procedures to improve report content and accuracy.
• Analyzed the sources, targets, transformed the data, mapped the data and loading the data into Targets using Informatica.
• Creating the mappings using transformations Filter, Expression, Aggregator, Sorter, Lookup, Update Strategy.
• Using ETL Process to Extract, Transform and Load the data into stage area and data warehouse.
• Using Transformations to clean the data from staging area as per the data warehouse requirements.
• Creating reusable transformations and using in mapping.
• Designed Informatica mappings to build business rules to load data.
• Worked on Informatica client tools - Data warehousing designer, Workflow manager, and Workflow Monitor and Repository manager.
• Performed requirement gathering with internal clients to develop reporting system for finance department.
• Designed and developed scorecard report in MS Excel to understand distribution of cost and resources for all active projects from year 2009-2012.
• Developed drill down charts, graphs and reports to project cost vs resources for active projects in entire North America.
• Creating Mapplets and using in mapping.
• Resolving, if any issues in transformations and mappings.

Environment: Windows XP, Informatica Power Center 8.1.x, DB2 8.1, WinSql 5.5, UNIX.