SUMMARY:

• 9 years of experience in software development,maintenance,testing and troubleshooting on Informatica Master Data Management MDM, ETL applications, data quality,and data integration.
• Involved in all phases of SDLC from analysis of business requirements and planning to development and deployment.
• Expertise in installing, configuring and managing Informatica MDM Hub server, Informatica MDM Hub Cleanse server, Cleanse Adapters (Address Doctor), Informatica MDM Hub Resource Kit.
• Experienced in configuring landing tables, staging tables, base objects as per the data model, data sources and business rules.
• Prowess in configuring lookup table base objects, created relationships between base objects and lookup tables.
• Designed & developed multiple cleansing and standardization scenarios using Address Doctor.
• Analyzed the Business data and defined the Match and Merge rules and helped business to develop Trust Scores for MDM Hub.
• Analyzed the source systems for erroneous, duplicative, and integrity issues related to the data.
• Identified Golden Record (BVT) for Customer Data by analyzing the data cleansing and merging duplicate records coming from different source systems.
• Skillful in configuring batch groups for processing staging, loading base objects and for performing match jobs in parallel and sequential order as per the dependency between base objects.
• Performed all Informatica administration functions such as user access accounts, roles, setting standards and associated privileges.
• Configured Hierarchy Manager for MDM HUB implementation which includes implementing hierarchies, relationship types, packages and profiles by using hierarchies’ tool in model workbench.
• Worked on JAVA SIF and implemented webservices.
• Worked on SIFAPI to integrate MDM data with external Applications.
• Experienced in using Java Messaging Services (JMS).
• Experience in developing Web Applications with various Open Source frameworks: Spring Framework, Spring MVC, and Hibernate.
• Used SQL loader to load data from files into Oracle tables.
• Created Mappings in Mapping Designer to load data from various sources using complex transformations like transaction control, Lookup (Connected and Un - connected), Joiner, sorter, Aggregator, Update Strategy, Filter and Router transformations.
• Extensive database experience and highly skilled in SQL in Oracle, MS SQL Server, DB2, Teradata, Sybase, Mainframe Files, Flat Files, CSV files, MS Access.
• With Strong Knowledge in all phases of Software Development Life Cycle(SDLC) such as developing, testing, Maintenance of various platforms like UNIX, Windows NT/2000/XP/98.
• Experience in delivering End-User report generating tools, Tableau.
• Functional and Technical expertise in Decision Support Systems - Data Warehousing, ETL (Extract Transform and Load) using Informatica.
• Developed Complex mappings from varied transformation logic like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more in Informatica
• Experience creating processes for defining and documenting data standards and Meta models.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS:

ETL Tools: InformaticaPowerCenter 9.6/9.5.1/9.1. x/9.0.x/8.6.x/8.1.x/7.1.xInformatica MDM 10.1/9.7, Blue Wolf, Analyzer, Designer, Server manager, Work Flow Monitor, Warehouse Designer, Mapplet Designer, Mapping Designer, Work Flow Manager), Informatica Cloud MDM, OLAP, OLTP, Informatica Data Profiler.

Operating Systems: Windows XP/2000/NT/98/95, Windows 2003,07,10 servers, UNIX.

RDBMS: Oracle 12c/11g,10g/9i/8i/8.0, MS-SQL Server 2008/2005/2000 /7.0/6.5

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snowflake, FACT, Dimensions), Entities, Attributes, ER Diagrams, ERWIN, ER Studio 7.1/6.1.

Data Base Tools: Oracle 11g/10g/9i/8i, Teradata 13.0, MS SQL Server 2008/2005/2000, Oracle SQL Developer 3.0.04, SQL*Loader, IBM Data Studio 2.2.1.0, EDW DB2, Sybase

Reporting Tools: Tableau

Scripting: UNIX Shell Scripting

Web Technology: Web Technology HTML, Java script, J query

Languages: SQL, PL/SQL, C, C ++, J2EE XML, Core Java

CRM: SalesForce.com(SFDC)

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr Informatica MDM developer

Responsibilities:

• Supporting the ETL Inbound for heterogeneous sources using ETL CDC (ChangeDataCapture) Mappings and scripts in InformaticaPowercenter.
• Copied subset of secured data from Production databases to development and Testing environments of Test Data Management (TDM).
• Worked on Informatica web services Consumer transformation to fetch the MDM executed batch related data using SIF API WSDL by passing parameters to Powercenter mapping through SoapUI.
• Gained extensive knowledge on SIF APIs in communication between external systems and MDM HUB.
• Users that described the scope of work for technical team to develop prototype and overall system.
• Worked on an Agile SDLC model to deploy our product and Payer data.
• Payer data is extracted from facets and maintained across the organization.
• Particiapted in review meetings with users to build payer MDM and provide the real time integration between the MDM and downstream.
• Developed both provider and payer MDM and maintained their relation across the organization.
• Worked towards data modelling, baseline the data model to accommodate all business specific requirements and configured Informatica MDM Hub Server, Lookup Adapter, Cleanse Server, Cleanse Adaptor and Resource Kit.
• Implemented Data&Services integration with customer registry.
• Designed and created BO, staging tables, mappings, transformations as per business requirements.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Used small sample data sets to complete DEV match iterations.
• Defined multiple conservative match rules for IDL.
• Used multiple server properties and cleanse properties for matching.
• Performed External match jobs.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Responsible for creating user groups, privileges and roles to the users using Security Access Manager.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• Worked on integrating Hierarchies created in MDM Hub Console and IDD.
• High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role
• Implemented Search feature, Add/Update feature and Task Assignment feature in IDD for Admin user.
• Implemented Post Landing, Pre-Staging, Save Handler User Exitsusing JAVAEclipse Mars and integrated those user exits with MDM Hub Console using User Object Registry module.
• Configured pre-staging ,post-staging, pre-matchinguserexits and worked on SIF Integration.
• Worked on JAVA SIF and implemented webservices.
• Experienced in using Java Messaging Services (JMS).
• Experience in developing Web Applications with various Open Source frameworks: Spring Framework, Spring MVC, and Hibernate.
• Worked on BPM tool and Integrated to Informatica MDM.
• Configured Custom java cleanse functions and userexits.
• Performed analysis, design, development and maintenance activities associated with the database and data in support of multiple applications (including following standards/procedures to achieve integration of systems through database design).

Confidential- Norfolk, VA

Sr MDM Application developer(Enterprise Management).

Responsibilities:

• Prepared Business Requirement Documents (BRD’s) referring to the Functional Requirements provided by System Users that described the scope of work for technical team to develop prototype and overall system.
• Worked on an Agile SDLC model to deploy our product and Payer data.
• Payer data is extracted from facets and maintained across the organization.
• Particiapted in review meetings with users to build payer MDM and provide the real time integration between the MDM and downstream.
• Developed both provider and payer MDM and maintained their relation across the organization.
• Worked towards data modelling, baseline the data model to accommodate all business specific requirements and configured Informatica MDM Hub Server, Lookup Adapter, Cleanse Server, Cleanse Adaptor and Resource Kit.
• Implemented Data&Services integration with customer registry.
• Designed and created BO, staging tables, mappings, transformations as per business requirements.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Used small sample data sets to complete DEV match iterations.
• Defined multiple conservative match rules for IDL.
• Used multiple server properties and cleanse properties for matching.
• Performed External match jobs.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Responsible for creating user groups, privileges and roles to the users using Security Access Manager.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• Worked on integrating Hierarchies created in MDM Hub Console and IDD.
• High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role
• Implemented Search feature, Add/Update feature and Task Assignment feature in IDD for Admin user.
• Implemented Post Landing, Pre-Staging, Save Handler User Exitsusing JAVAEclipse Mars and integrated those user exits with MDM Hub Console using User Object Registry module.
• Configured pre-staging ,post-staging, pre-matchinguserexits and worked on SIF Integration.
• Worked on JAVA SIF and implemented webservices.
• Experienced in using Java Messaging Services (JMS)..
• Experience in developing Web Applications with various Open Source frameworks: Spring Framework, Spring MVC, and Hibernate.
• Worked on BPM tool and Integrated to Informatica MDM.
• Configured Custom java cleanse functions and userexits.
• Performed analysis, design, development and maintenance activities associated with the database and data in support of multiple applications (including following standards/procedures to achieve integration of systems through database design).

Confidential, Cincinatti, OH

MDM Developer

Responsibilities:

• Involved in effort estimation for the requirements in the project and prepared mapping documents based on client requirement specifications.
• Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process. Datawarehouse Developer.
• Provided data warehouse expertise including data modeling, Extract, Transform and Load (ETL) analysis, design and development.
• Analyzing the sources and targets, transforming the data, mapping the data and populating the data into targets by using Informatica Designer, Workflow Manage and Workflow Monitor.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations.
• Handled versioning and dependencies in Informatica.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Resolving technical and design issues.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Responsible for creating user groups, privileges and roles to the users using Security Access Manager.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• Worked on integrating Hierarchies created in MDM Hub Console and IDD.
• High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role
• Implemented Search feature, Add/Update feature and Task Assignment feature in IDD for Admin user.
• Implemented Post Landing, Pre-Staging, Save Handler User Exitsusing JAVAEclipse Mars and integrated those user exits with MDM Hub Console using User Object Registry module.
• Configured pre-staging ,post-staging, pre-matchinguserexits and worked on SIF Integration.
• Worked on JAVA SIF and implemented webservices.
• Experienced in using Java Messaging Services (JMS).

Environment: Informatica Multi-domain MDM 9.7.1, Informatica Power Center 9.1, JBoss EAP6.2,Oracle 11g, SQL Developer, Address Doctor,IDD, SIF, Toad, Windows Server 200

Confidential, MountainView, CA

Informatica MDM developer

• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Create Landing, staging and Base Objects, Create Data validation and Trust settings, Create Match and Merge rules
• Using Informatica MDM Hub to run Batch jobs; Loading data from Informatica MDM Landing to Stage
• Define requirements for data matching and merging rules, and data stewardship workflows
• Designing data hierarchy management for Informatica MDM
• Executing jobs in Batch Viewer and Batch Group ; Created Batch Scripts using Informatica, Oracle APIs
• Used Hierarchies tool for configuring entity base objects, entity types, relationship base. Integrated critical enterprise data by importing customer information, billing information and financial data by using Informatica Cloud MDM.
• Involved in Informatica server and Repository Migration from One Machine to another.
• Worked shoulder to shoulder with Informatica Vendor team to resolve Production issues.
• Handling Critical Applications in Production Database; Stabilized the Production Environment
• Experience in Informatica MDM HUB development support & detailed technical knowledge of Informatica MDM products
• Worked on Informatica tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Used various Transformationslike Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement complex logics while coding a Mapping.
• Extracted data from Flat files, oracle andloaded them into Oracle and Netezza.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Worked extensively on mapper, parser, seralizer, streamer, UDT, etc.
• Worked with complex queries for data validation and reporting using SQL and PL/SQL.
• Worked on various defects/issues related to MDM hub, IDD user exits occurred during SIT and UAT
• Involved in analyzing the requirements, designing and development of data warehouse environment.
• Preparing TSD and ETL Specs based on BSD and Mapping document.
• Conducting walk through on TSD with client tech leads, team leads and Data Archs and DBAs
• Providing Temporary Solution to the Failed jobs in Production and raising a Change Request
• Improved performance of Informatica Objects and Oracle Objects.
• Identified Major Data Quality issues in MDM Production.
• Expertise in Informatica Matching components and developing MDM initiate
• Provided Trainings to on and offshore Team members; Knowledge Transfer to every member of the Team

Environment: Informatica MDM 10.1/ 9.6.1, SQL Server 2012/2014, Oracle 11G, DB2, Flat Files, UNIX, Windows server.

Confidential

Informatica developer

Responsibilities:

• Participated in Design and Build for Supply Chain domains namely Supplier, Manufacture, Location, Product and Contract.
• Configured 7 source systems and prepared Source to Target Mapping document for ETL load in Landing Tables.
• Configured Landing Tables, Base Objects,Relationships,Staging Tables,Mappings,custom cleanse functions, Match and Merge settings, Trust and Validation Rule.
• Identified issues in the ETL load to reflect the current data model relationships.
• Configured Entity Objects, Entity Types, Hierarchy and Relationship Types for Contract,Product,and Party Hierarchical view in IDD.
• Configured Supply Chain IDD Application for use by Data Stewards.
• Configured Queries and Packages for all the domains for use in IDD.
• Configured Subject Area Groups for Supplier,Manufacture,Product and Contract.
• Configured Roles for Read Only, Approver and IDD specialist for respective domains.
• Created Task Assignment in IDD for Supplier and Manufacture domains.
• Worked with ETL team to schedule Batch Groups for all the domains and are called via ETL workflows which call corresponding MDM SIF API’s.
• Responsible for creating Hive tables based on business requirements
• Implemented Partitioning, Dynamic Partitions and Buckets in HIVE for efficient data access.
• Involved in NoSQL database design , integration and implementation.
• Loaded data into NoSQL database HBase
• Used Hive to transfer data between RDBMS and HDFS.
• Converted existing SQL queries into Hive QL queries.
• Created MDM Workflows to manage the Data flow process.
• Experience in Cloud Computing technologies like Amazon Web Services (AWS)
• Configured pre-staging ,post-staging, pre-matchinguserexits and worked on SIF Integration.
• Used SOAP UI to perform SIF API calls like clean tables etc.
• Installed and configured Jboss, Hub, Cleanse server, Address Doctor on Production.
• Participated in making the Data Stewards familiarize with the IDD functionality.
• Cleansed US address using Address Doctor with US license.
• Ability to coordinate across teams, working closely with peers to ensure the appropriate focus and sense of urgency is applied to all MDM issues.
• Worked with Informatica Support for MDM issues and upgrades.
• Configured External Authentication using LDAP configuration for Users Authentication.
• Documented the application and teach/share with others as necessary.

Environment: Informatica Multidomain MDM 9.6/9.7.1 HF1, Jboss 6.2 EAP, SQL Server 2012, IDD, Erwin, Address Doctor 5, SOAP UI 5.0.0, Hadoop, Hive, Hbase, AWS.

Confidential

SQL Programmer/Database Analyst

Responsibilities:

• Actively participated in the requirement analysis, database design and modeling.
• Worked with business analysts for gathering requirements from high-end users and Performed Analysis on Business Data.
• Participated in the implementation of a payroll system using SQL, Oracle forms & triggers on UNIXplatform.
• Also involved in performing development tasks such as writing extensive PL/SQL programs units liketriggers and forms.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookupand Update transformation rules.Created reusable transformations and mapplets and used them in complex mappings.
• Involved in database administration. Design, development and implementation.
• Responsible for development of forms and interfacing the data selection from the database.
• Assisted in the Development of several reports including tabular, master detail reports.

Environment: Oracle 8i, SQL, PL/SQL, TOAD, Oracle Developer 6i, WinNT4.0.