SUMMARY

• Software Professional with 8 years of experience in teh field of Information Technology with an extensive experience in Master Data Management and as an ETL / Informatica Developer with prime focus on analysis, design, development, customization and maintenance of various data warehouse applications in an TEMPeffective way to deliver leading edge software solutions.
• Strong expertise in installing and configuring teh core Informatica MDM components (Informatica MDM Hub Server, Hub Cleanse, Resource Kit and Cleanse Adaptors like Address Doctor)
• Proficient in teh development of solutions usingInformatica MDM Hub
• Created a single, verifiable, consolidated source of data which can be referred across teh organization and subsequently to have a single point of entry for all data within teh organization into dis single source.
• Analyzing teh regulatory restrictions and teh need for identification of gloden record for Master Data.
• Designed, configured and delivered MDM hubs across multiple data domains (Customer, Product, Vendor, etc).
• Configuring and maintaining various components of teh MDM Hub including teh schema, staging and landing tables, configuring base objects, Look ups, Hierarchies, display queries, put queries and query groups.
• Defined teh Trust and Validation rules and setting up teh match/merge rule sets to get teh right master records
• Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Successfully implemented and executed database store procedures in Informatica MDM Hub for Cleaning Base Objects, Stage Jobs, Load Jobs, Generating Match Tokens, Match Jobs, External Match Jobs, Manual Merge Jobs, Multi Merge, Manual Unmerge, Auto Match and Merge, CMX Put, Hard delete job, Soft Delete Job.
• Responsible for creating user groups, privileges and roles to teh users using Security Access Manager (SAM)
• Configured Informatica Data Director (IDD) for data governance to be used by teh 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 teh data.
• Efficient in all teh phases of teh Data warehousing life cycle including: design, development, testing and implementation of teh Data Warehouses as an ETL developer using Informatica Power Center 9.x/8.x
• Good development experience in Informatica (9.1/9.5) Power Center - ETL tool and Informatica Data Quality (IDQ) tool.
• Hands on experience in Extracting, Transforming, and Loading (ETL) data for data warehouse, data migration and other data conversion
• Expertise in implementing complex business rules by creating re-usable transformations and Mappings/Mapplets.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Aggregator, Router, Filter, Update Strategy, Lookup, Sorter, Normalize, Union, Stored Procedure, Sequence Generators.
• Created, launched & scheduled workflows/sessions and extensively involved in teh 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/Gloden copy.
• Extensively involved in writing Oracle, PL/SQL/Functions/Cursors/ Packages & Triggers.
• Worked with various SQL developer tools such as TOAD, SQL Plus, and SQL Developer.
• Strong development skills including teh ability to work through teh entire development cycle from gathering requirements through implementation
• Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Databases: Oracle 9i/10g, 11g/12c SQL Server 2012, 2008, 2005

Languages: SQL, PL/SQL, Java, UML 2.0, Unix

ETL Tool: Informatica Power Center 9.x/8.x (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

MDM Packages: Informatica MDM Multi Domain Edition 9.7, 9.5, 9.1. Informatica Data Director (IDD) 9.7, 9.5. Informatica Data Quality(IDQ) 9.6

RDBMS: Oracle 12c/11g/10g/ 9i (SQL/PLSQL)

Tools: and Utilities: TOAD 10.1, Text pad, Word Pad, SQL Developer 4.0.3

Modeling Tools: Erwin 4.0 data modeler, ER studio 7.5, MS Visio 2007

Environment: Windows 7/XP/2000, Unix, Windows Server 2003, 2008/Linux

Packages: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word), Visual Studio, Java Eclipse

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

IDD/MDM Consultant

Responsibilities:

• Responsible for developing teh IDD user interface(s) to teh Customer Hub.
• Analyzing teh IDD User Interface Requirements (GUI development).
• Design, configure, and test teh IDD interfaces.
• Collect stewardship interface requirements and develop teh IDD constructs within MDM Hub.
• GUI development based on Data Stewardship requirements.

Environment: Informatica MDM 9.7.1 HF4, Informatica Data Director 9.7.1, Informatica Power Center 9.6, Informatica Data Quality(IDQ) 9.6, Jboss, Oracle 11gR2, Address Doctor, SQL Developer.

Confidential, St Louis, MO

Informatica MDM Consultant

Responsibilities:

• Interacted with teh Business Users & Enterprise Data Architects in teh analysis & design of conceptual and logical data model that is required for solid MDM implementation & ensuring that it meets teh business requirements and also supports teh products capabilities.
• Involved in all phases of teh project SDLC planning, design, documentation, configuration, testing activities and code migration.
• Worked w /Data Profiling Team in analyzing teh source systems data for duplicative and quality issues.
• Performeddata profilingof reference data for large data sets using Informatica Data Analyst tool.
• Worked w/ ETL team in configuring teh landing tables structure according to standardization of teh 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.
• Executed Stage Jobs/ Load jobs using Batch viewer and Batch Group Jobs.
• Analyzed teh data from all teh source systems and designed Match Rules, Validation Rules and Trust Scores.
• Configured Match & Merge Rules (Exact and Fuzzy) for consolidation process, Validation Rules and Trust scores respective of their BO tables.
• Worked with teh DG team to create teh 240 business rules and created teh mapping to theirdeveloped teh MDM Hub using teh Data Models proposed to accommodate teh Customer Mastersolution
• Created IDD/ HM Queries, Packages (PUT & Display) and Search Queries (Custom Queries).
• Configured Hierarchies (Entities/ Entity Objects/ Hierarchies/ Relationship Objects/ HM Profiles) to define teh hierarchy data of teh corresponding data-model in IDD.
• Configured Subject Area Group / Subject Area / Subject Area Child / Subject Area Grand Child in IDD Admin Console.
• Utilized Metadata manager for Validating, importing and exporting teh ORS repositories to different environments.
• Created and documented teh secure resources, roles, users for roles, and assigned privileges to roles using Security Access Manager in development environment.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.

Environment: Informatica MDM 9.7.1/9.5.1 , Informatica Data Director 9.5.1, Informatica Power Center 9.5, Jboss, Oracle 11gR2, Microsoft SQL Server, Address Doctor, SQL Developer, DB Visualizer, Erwin

Confidential, Rosslyn, VA

Informatica MDM Developer

Responsibilities:

• Configured and Installed Informatica MDM Hub, MRM Server, MRM Cleanse, MRM Resource Kit and Address Doctor5 in Conversion Island, Development, QA, Pre-Prod and Production in Windows environment.
• Led effort for gathering business requirements for teh data-warehouse as well as business-intelligence reports to be used by teh management.
• Evaluated and reported teh progress of data quality improvement to teh management and also provided data quality training and consulting services to Business and IT members in teh organization
• Good development experience in Informatica (9.5) Power Center- ETL tool and Informatica Data Quality (IDQ) tool.
• Involved in implementing teh Land Process of loading teh customer/product data set into Informatica MDM Hub that was coming from various source systems.
• Took development decisions by working with business users and enterprise architects to understand enterprise vision and direction.
• Hands on executing MDM hub Batch Jobs (Stage, Load, Tokenize and Match Processes) and Batch Groups.
• Designed SQL Queries to pull out teh data which TEMPhas to be Matched & Merged coming from all teh source systems according to match & merge rules setup (to make sure consolidation process configured).
• Configured Match and Merge Rules in improving teh data quality by match analysis, analysis of teh MDM system performance and tuning teh performance by changing teh existing cleanse function, match rules etc.
• Involved in developing and configuring teh Hierarchies using Hierarchy Manager to identify hierarchical relationships.
• Designed, configured and tested Informatica Data Director (IDD) interfaces.
• Provided weekly status updates on progress, status and fatal errors in IDD.
• Led ETL team towards designing and development of extraction mappings for inbound source to MDM and tan outbound MDM to consuming systems.
• Worked on IDD UI configuring subject areas for Customer Domain that assisted to search and edit master records that enabled client with their sales process transformation
• Enabled Message Queue Triggers for Hub State Indicator Changes.

Environment: Informatica Multi Domain MDM 9.5/9.1, Informatica Data Director, Informatica Power Center 9.1, Oracle 10/11g, Windows Server 2008, Address Doctor, Toad 10.1, SQL*Loader, Erwin.

Confidential - FortWorth, TX

Informatica/MDM Developer

Responsibilities:

• Involved in landing teh 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.
• Defined teh Landing tables, Base objects, staging tables, foreign key relationships, lookup definitions, queries, packages and query groups.
• Analyzed teh source systems for erroneous, duplicative, and integrity issues related to teh data which is resided in various source systems such as ERP, LEGACY, CRM, DNB, SALES system, and defined those all source systems in systems and trust model workbench.
• Developed and managed relationships between data domains for teh data models.
• Created mappings to perform teh tasks such as cleansing teh data and populate that into staging tables.
• Analyzed teh business data and defined teh Match and Merge rules and Trust Scores for MDM Hub.
• Involved in loading data from different sources to staging area by cleansing data to do dis 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 teh ware house
• Involved with ETL developers, for developing complex mappings, mapplets, reusable transformations using Informatica 8.6 designer to integrate data from different sources like Oracle, Flat files, and SQL databases by following guidelines and loaded data successfully into target.
• Used Informatica components extensively Repository, Designer, Workflow Manager & Workflow Monitor .
• For loading business logic successfully to database used different transformations like Router, Expression, Source Qualifier, Aggregator, Filter and Sequence Generator transformations extensively.
• Created workflows and used various tasks like Email, Event-wait and raise, decision in workflow manager.
• Involved in interaction with DBA team for creation of primary and secondary indexes on data warehouse tables.
• Used debugger to test teh mappings and fixed bugs accordingly.
• Created Session and Batches using server manager to execute mappings.
• Helped teh testing team for data integrity and consistency.

Environment: Informatica MultiDomain MDM 9.1, Informatica Power Center 8.6, Web logic, Oracle 10g, SQL Developer, Address Doctor, Toad, SQL*Loader, Windows server 2003, Erwin

Confidential, Charleston, WV

Informatica Developer

Responsibilities:

• Worked with business analysts for gathering requirements from high-end users and Performed Analysis on Business Data.
• Responsible for development, support and maintenance of theETL(Extract, Transform and Load) processes usingInformatica Power Center.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules. Createdreusable transformationsandmappletsand used them in complex mappings.
• UsedWorkflow Managerfor creating, validating, testing and running teh sequential and concurrentBatchesandSessions, scheduled them to run at a specified time.
• Used mappingparametersandvariables.
• Analyzed Session log files to resolve errors in mapping and managed session configuration.
• Involved in migrating theETL applicationfrom development environment to testing environment and extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and triggers.

Environment: Informatica Power Center 8.6, DB2, Oracle 10g, SQL, PL/SQL, Toad 9.1 SQL*LOADER and UNIX Script.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Extraction, Transformation and data loading were performed using stored procedures into teh database. Involved in Logical and Physical modeling of teh drugs database.
• Based on teh requirements created functional design documents and technical design specification documents for ETL.
• Created tables, views, indexes, sequences and constraints.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
• Used legacy systems, Oracle, and SQL Server sources to extract teh data and to load teh data.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed teh database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/purchase reports.
• Coordinated database requirements with Oracle programmers and wrote reports for sales data.

Environment: Oracle 9i, SQL*Loader, SQL, PL/SQL, WindowsNT, UNIX shell scripting, Toad and ERWIN.