SUMMARY:

• About 8+ years of total experience in Information Technology Industry and 4 years experience with Informatica MDM tool and 4.5 years with Data ware house applications.
• Professional experience in Master Data Management and Data Warehousing solutions.
• Experience in Mater Data Management (MDM) Multi Domain Edition HUB Console Configurations, Informatica Data Director (IDD) Application creations.
• Extensive experience in Master Data Management (MDM) HUB Console Configurations such as Staging Process Configurations, Landing Process Configurations, Match and Merge Process, Cleansing Functions, User Exits.
• Experience in creating queries, packages, custom cleansing functions and reusable functions.
• Expertise in RDBMS, database Normalization concepts and principles.
• Implemented MDM configurations for Party, Vendor, Product and Customer.
• Technical hands - on expertise in Reporting tool SQL Server Reporting Services (SSRS).
• Strong experience in designing and developing mappings to extract data from different sources including flat files, RDBMS tables and XML files.
• V e ry s tr on g in S Q L e xt e n s i v e h and s on e xpe rie n ce in cre a tio n of d at ab as e t ab les, sequ enc es, func tion s, p r oc ed u r es, p ac k ag es an d tr i g g er s.
• Worked with various SQL developer tools such as TOAD, Management studio, and SQL Developer. Strong development skills including the ability to work through the entire development cycle from gathering requirements through implementation.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases.
• Strong experience in Extraction, Transformation, loading (ETL) data from various sources into Data Warehouses and Data Marts using SQL Server Integration Services.
• Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

MDM Tool: Mata Data Management Multi Domain Edition 10.1, Informatica Data Director(IDD)

Business Intelligence Tools: SQL Server Management Studio, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Tableau.

ETL Tools: SQL Server Integration Services

Operating Systems: Windows 2008, 2000, XP, 2010

Databases: Oracle10g, Oracle 11g, SQL Server 2012, MS Access 2007

Microsoft Office: MS. word, MS. Excel, MS. PowerPoint, MS. Access, MS. Outlook

PROFESSIONAL EXPERIENCE:

Confidential, New York

Informatica MDM Developer

Responsibilities:

• Designed, Installed, Configured core Informatica Master Data Management (MDM) Hub components such as Informatica Master Data Management (MDM) Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter & Data Modeling.
• Designed the Data Model, Landing Table, & Staging Tables.
• Configured Trust and Validation rules and match rules & enable Auto Match.
• Created Queries & Packages to view the data in IDD, Data Manager or Merge Manager.
• Configured batch jobs using batch group utility.
• Created the Mater Data Management (MDM) Hub Console configurations like Stage Process configuration, Load Process Configuration.
• Done Match and Merge Setups like Match path, Match columns, and Match rules and tuning of Match Rules.
• Created cleansing functions for effective consistent master data records.
• Implemented cleansing functions such as pre defined functions (STRING Functions, Logic Functions, Math Functions, Data Conversion Functions).
• Developed Informatica Data Director (IDD) applications and queries used for Data Steward Analysis.
• Lookup tables were configured in the IDD applications.
• Created Queries and performed the Manual match and Merge operations in IDD.
• SIF API was created to access Master Data Management (MDM) Hub from External Application.
• Handled Master Data and Transactional Data, and did the reporting of transactional data which is required by the Business Decision Support People.

Environment: Informatica MDM 10.1, IDD, SoapUI, Oracle 11g.

Confidential, Alpharetta, GA

Informatica MDM Developer

Responsibilities:

• Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to Data Model for new requirements.
• Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor.
• Involved with Master Data Management (MDM) for Customer Data Integration using Siperian tool.
• Handled Mater Data Management (MDM) Hub Console configurations like Stage Process configuration, Load Process Configuration, Hierarchy Manager Configuration.
• Involved with ETL developers, for developing complex mappings, Mapplets, reusable transformations using Informatica 8.6 designer to integrate data from different sources like Oracle, Teradata, Flat files, and SQL databases by following guidelines and loaded data successfully into target.
• Created Match and Merge Setups like Match path, Match columns, and Match rules and tuning of Match Rules.
• Analyzed the background tables for the Data analysis purpose. Tables included Stage tables (RAW table, REJ Table, PRL table), XREF table, MTCH Table, HIS table, STRP table.
• Created cleansing functions for effective result set of mapping results.
• Implemented cleanse list functions and pre defined functions.
• Created reusable cleanse components using Graph Function, Regular Expression function, cleanse list.
• Created queries and packages in the MDM (Master Data Management) HUB Console.
• Created Applications in the IDD (Informatica Data Director) and performed Match and Merge operations.
• Assigned workflows to business users and managers to review the task.

Environment: Informatica MDM 9.5, IDD, Teradata, SoapUI, Oracle 11g

Confidential, LA

ETL Developer / Informatica MDM Developer

Responsibilities:

• Created Base Objects, Lookup Base Objects and configured relationships.
• Created Landing tables, staging tables, Mappings, transformations.
• Configured Trust and Validation rules, match rules.
• Fine tune the Match Rules using Accept Limit Adjustment
• Configured IDD application using IDD Configuration manager.
• Created Workflow Tasks for new and Merge.
• Created Batch Bulk Merge document to ease Data steward’s burden.
• Utilize SIF for Hard Delete, Bulk Unmerges.
• Modified the existing design to accommodate Operate specific changes in the data model.
• Coordinated the Mapping and transformation effort of the ETL
• Designed and developed the real-time integrations with MDM - Operative system using ESB as the middleware
• Enhanced the application by User Exit
• Configured Trust rules

Environment: Informatica MDM 9.5, IDD, SoapUI, Oracle 11g

Confidential

BI Developer

Responsibilities:

• Performed design of ETL components in this project. Creation of Design documents, Development and testing were my primary responsibilities.
• Created the warehouse tables.
• Designed the source to target mappings that contain the business rules for the server during the extract, transform and load process.
• Created mappings to extract data from heterogeneous data sources like Oracle, MS SQL Server, MS Access & Excel Sheets to load into the data warehouse with various types of transformations like Aggregator, Expression, Filter, Joiner, Lookup, External Procedure, Router & Update Strategy.
• Created and maintained documents including data quality plan design, mapping inventory, mapping specifications, change request form, unit test plan, test case list, target-source matrix etc.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing Tasks, Workflows and the Target Data.
• Making enhancement and fixes in the Procedures, Packages, Triggers.
• Creation of Bitmap indexes & Partitioned indexes for partitioned tables to maximize performance.
• Proficient in physical/logical design, SQL Stored Procedures, Functions, Cursors and Trigger.
• Install, upgrade, migrate database.

Environment: SSIS, MS SQL Server2010, T-SQL, Oracle 10g

Confidential

BI Developer

Responsibilities:

• Extraction, Transformation and data loading were performed using stored procedures into the database. Involved in Logical and Physical modeling of the drugs database.
• Based on the 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 the data and to load the data.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed the 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.
• Designed, documented and sign off ETL process from business, implementing partners and Vendors.

Environment: SSIS, MS SQL Server2010, T-SQL