**HAJI MOHAMMED

+1-469-***-**** adaris@r.postjobfree.com

EXPERIENCE SUMMARY:

•5+years of IT experience in Informatica MDM Hub with Software Development Life Cycle (SDLC) analysis, design, development, testing, maintenance and quality assurance with implementation of software applications in MDM and Data warehousing.

•Experience in Master Data Management concepts, methodologies and ability to apply this knowledge in building MDM solutions.

•Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian).

•Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling.

•Configured landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups.

•Worked on Mappings from landing to staging tables and Imported new ORS in to MDM hub console.

•Designed & developed multiple cleansing and standardization scenarios using Address Doctor.

•Implemented Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies.

•Created IDD application as per the business needs by creating the subject area and subject area groups.

•Configuring Informatica Data Director (IDD) to meet Data Governance objectives in project life cycles.

•Configured Entity 360 view by building business entities in Provisioning Tool.

•Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.

•Installed and configured Oracle 11g and Oracle SQL Developer.

•Provided solutions for various uses cases provided by the business users to meet the requirements.

•Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica server.

•Expertise in various Testing & QA methodologies entailing Black Box Testing, User Acceptance Testing, Module Testing, System Testing, Migration Testing, Sanity Testing, and Mobile Testing.

•Expertise in manual testing using User Interface, Client and Web based applications.

•Strong exposure testing applications on different browsers like IE, Firefox, Chrome.

TECHNICAL SKILLS:

•EIM Tools: Informatica MDM 10.2/10.1/10.9/9.7, IDD, SIF, Power Center.

•Testing Tools: HP Quality Center, Quick Test Professional (QTP).

•Defect Trackers: Jira, Bugzilla, IBM Clear Quest.

•Operating System: Linux, Windows 2000/XP and Mac OS.

•Build Tools: Agile & Scrum Methodologies, Waterfall methodology.

•Package: MS Office (MS Access, MS Excel, Ms Power Point, MS Word).

•Databases: Oracle 9i/10g/11g, SQL Server, Microsoft SQL server.

•Servers: JBoss 6.4, WebSphere (WAS), Tomcat.

PROFESSIONAL EXPERIENCE:

INFORMATICA MDM DEVELOPER Nov 2018 – Present

Mayo Clinic, Dallas, TX

Description: Mayo Clinic is a nonprofit organization committed to clinical practice, education and research, providing expert, whole-person care to everyone who needs healing. Mayo Clinic offers highly specialized medical care, and a large portion of the patient population is referrals from smaller clinics and hospitals across the upper Midwest and the United States.

RESPONSIBILITIES:

•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 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

•Identified Golden Record for Customer Data by analyzing the data and duplicate records coming from different source systems

•Helped the testing team for data integrity and consistency

•Defined and configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries

•Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records

•Used Hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD

•Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries.

•Configured match rule set property by enabling search by rules in MDM according to Business Rules

•Created mappings using Informatica Power center and loading data into pre-landing tables

•Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document

Environment: Informatica MDM 10.2 HF2, SOAP UI 5, SQL Server, Oracle 11g, SQL Management Studio, Eclipse, JBoss 6.4.0, Power Centre, Unix, IDD.

INFORMATICA MDM DEVELOPER Oct 2017-Nov 2018

State Street, Boston, MA

State Street Corporation is an American financial services and bank holding company headquartered at One Lincoln Street in Boston with operations worldwide. As part of the AML KYC program and other ORI initiatives, State Street Corporation needs to be able to provide a validated, trusted and defendable detailed view of entities they transact with to all the downstream systems. This information is critical for risk reporting and AML transaction monitoring purposes.

RESPONSIBILITIES:

•Integrated Customer data from different sources to create a Customer Master Data to get best version of truth as golden record.

•Successfully completed the Hub configuration phase to deployment of the project.

•Defined standard interfaces, Data Profile, metadata acquisition, data migration, validation, pre-landing processing and Reference Entities.

•Defined the landing tables, staging tables, and configured base objects.

•Defined foreign-key relationships, lookups, query groups and queries.

•Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.

•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.

•Involved in creating, monitoring, modifying, & communicating the project plan with other team members.

•Performed match/merge and ran match rules to check the effectiveness of MDM process on data.

•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.

•Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.

Environment: Informatica MDM 10.2, Provisioning Tool, Smart Search, IDD, SQL Server

2008/2016, Informatica big data management (BDM 10.x) State Street ESP & ERP applications, Oracle 11g, Address Doctor, Informatica Power Center, JBoss 6.4.

INFORMATICA MDM DEVELOPER Nov 2015 - May 2017

Seanergy Digital, Hyderabad, India

RESPONSIBILITIES:

•Gathered requirements by working closely with Business and IT Team.

•Created Base objects, staging tables, landing tables, defined foreign key relationships and configure lookups on the stage tables.

•Created users, roles and groups.

•Worked closely with the Business in gathering the Match and Merge rules.

•Created Match Paths, Match Columns for Match and Merge Process.

•Defined Exact, Fuzzy and Filtered match rules.

•Worked on Match rules tuning and analyzed Match Key distribution for potential hot spots.

•Configured Trust Framework and validation rules.

•Worked on Hierarchy Manager for hierarchical relationships between the entities.

•Created PreStage, PostMatch and PostMerge user exits to support business requirements.

•Define Subject Areas, Subject areas child and grandchild.

•Ran batch jobs - Stage, Load, Generate Match Tokens, Match, Auto Merge, Auto Match and Merge etc.

•Used SOAP UI to execute SIF API's.

•Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to different environments.

• Helped in System testing team for creating test cases.

•Provided periodic status reporting to the Project Manager.

Environments: Informatica Multi Domain edition 10.0, Informatica Data Director (IDD), Oracle 11g, JBoss6.1, SOAP Ul, Java1.7, Red Hat Linux, SQL.

MDM Tester/Developer Oct 2014- Nov 2015

Seanergy Digital, Hyderabad, India

RESPONSIBILITIES:

•Worked in integrating customer data from different sources to create Customer Master Data to acquire unsurpassed version of truth as golden record by using Informatica Power Center.

•Productively engaged in the Hub configuration phase till deployment of the project.

•Defined standard interfaces, Data Profile, metadata acquisition, data migration, validation, pre-landing processing and Reference Entities

•Offered services in defining the landing tables, staging tables, and configured base objects

•Defined foreign-key relationships, lookups, query groups and queries

•Hands on experience in utilizing Hierarchy tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.

•Worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.

•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.

•Utilized Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.

•Created Unit Test Case Document, Test Artifacts Document, Data Validation document and Knowledge Transfer Document.

•End to end data integration testing

Environment: Informatica MDM 9.7, Informatica Power Center 9.6.1, JBoss 6.3, Oracle 11g, SQL Developer

Contact this candidate