SUMMARY

• Having 9 years Experience in Software development in Designing, Installing & Configuring core Informatica MDM Hub components: Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD & Data Modeling
• Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager - Entity types, Relationship objects, Packages, customizing/configuring Informatica/Business Data Director.
• Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Implementing Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies.
• Informatica MDM processes including batch based and real-time processing.
• Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Configuring Informatica Data Director (IDD) to meet Data Governance objectivesin many project life cycles.
• Informatica Power Center tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Working on transformations like Source Qualifier, Expression, Aggregator, Router, Filter, Update Strategy, Lookup, Sorter, Normalize, Union, Stored Procedure, and Sequence Generator, Slowly Changing Dimensions.
• Scheduling and Creating Workflows, sessions & involved in the Performance Tuning of Mappings & Sessions.
• Design of Extract, Transform, Load environment using Informatica Power Center.
• Design of Business Object reports using Web Intelligence and Dashboard.
• Design of Universe using Universe Designer.
• SQL, UNIX, Data Relationships, Data extraction & Validation.
• Designing & developing multiple cleansing and standardization scenarios usingAddress Doctor.
• Performing Data standardization of addresses using Address Doctor andInformatica Data Quality and Data integration in real-time using SIF API’s.
• Workedprimarily in design, development, customization and maintenance of various applications in telecom domain.
• Worked as a Scrum Master in Agile methodology of SDLC model.
• Excellent communication skill with IT and Business Stakeholders.
• Worked closely with IT Managers/Business Analysts and major stakeholders for smooth and seamless execution of the Projects.
• Excellent Problem Solving skills and ability to understand and analyze the Application Systems.
• Ability to understand the Business Problems and translate them in Technical Language.

TECHNICAL SKILLS

Technologies: ETL, Business Objects,Tableau, Mediation Zone, SQL, Business Intelligence, Data Ware House, Hive

EIM Tool: Informatica MDM Multi-Domain 9.x, IDD, SIF.

Data Warehousing Tools: InformaticaPower center9.x

Business Intelligence Tools: Tableau, Universe Designer3.x/4.x, Web Intelligence 3.x/4.x, Dashboard 4.x, Information Design Tool 4.x

Cleanse Adapter: Address Doctor

Databases: Oracle 10g/11g, MS SQL Server, Sybase

Operating System: Windows, Unix

Other Tools: Quality Centre, MhWeb, Clarify,SQL Developer, DB Visualizer

Language: Python, Java, C, APL, PROTEL

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Informatica MDM Senior Developer

Responsibilities:

• Was part of architecture and solutions team in the Iteration Design and Development sessions and demo sessions associated with the agile approach to design and development of the Confidential master (Consumer & Provider)
• Data profiling for various Consumer and provider source like Experian/Enclarity for Confidential master as a golden source for hospital system as third party master data
• Hospital specific system - source wise data profiling as well as cumulative source data profiling
• Worked with business to Identify business rules, match merge criteria, data validation rules, setting up trust frame work for cell level survivorship
• Created logical and physical data model for consumer and provider MDM - Party model
• Identified consumer hierarchy, provider hierarchy, consumer house hold hierarchy, consumer provider association
• Gathered requirements from pilot hospital systems to integrate and fulfill their business need - Web Forms based campaign requirement, mass emailing for campaign
• Identified Strategy, timeline, data elements, data volume from upstream systems
• Designed MDM feed to integrate downstream in order to syndicate data back and forth to source system vs. MDM
• Provided inputs and POC from the Functional and capabilities of the Informatica MDM and SIF integrations
• Interacted with the Business Users & Enterprise Data Architects in the analysis & design of Conceptual and logical data model that is required for MDM implementation & ensuring that it meets the business requirements and also supports the products capabilities
• Transformed the business requirements into technical specifications
• Provided technical solutions to the various business requirements like handling sensitive data, display of active Match rules in IDD, Data Volume and Performance Issues
• Configured and installed Informatica MDM Hub server version 9.7.1 for Oracle Server 11 g, cleanse, resource kit in all the Environments
• Applied the HF2 hotfix in all the Environments
• Handled the Bi-weekly Demo of the solutions/progress to the Client
• Participated in discussions, Data Analysis and iterations for deciding the match columns, match rules and match rule sets
• Worked on data cleansing and standardization using cleanse functions, cleanse lists and creating custom cleanse functions (Attribute functions and Object functions) in Informatica MDM
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
• Configured match rules and rule sets property by enabling search by rules in MDM according to Business Rules
• Implemented the Hierarchy Manager as of the business requirement
• Implemented IDD applications based on subject areas and subject area groups for search requests for Customer model

Confidential, Dallas, TX

ETL MDM Developer

Responsibilities:

• Analysing requirements and Functionality.
• Converting the client’s Business requirements into technical requirements
• To meet the SLA with the client
• Development and Testing, Maintenance
• Prepare Maintenance Manual, Operations Manual, System Description Document and other technical and functional documents
• Testing: Unit, integration and UAT
• Created Base objects tables, Staging tables, Landing tables, foreign key relationships, static lookups,dynamic lookups, queries, packages and query groups.
• Performed data analysis and validation of the data received from upstream systems.
• Define Trust along with Match and Merge rule set.
• Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file.
• Installed & Configured MDM Hub on Dev, Test and Prod Server, cleanse, resource kit and Address Doctor5 in Dev, QA.
• Developed standard Mappings and Mapplets using various transformations like SQL transformation, Update Strategy, Lookup transformation, Expressions and SequenceGenerator for loading the data into target table.
• Developed various workflows, Work lets with Event Waits, Assignments, conditionalflows, Email and Command Tasks.
• Developed Batch Scripts for automation of ETL process.
• Making complex BI reports based on KPI needed to be analyzed by Business Users.
• Involved in creation of Universes and making necessary changes to existing universes using Universe Designer.
• Generating Ad-hoc Business Objects WEBI and Xcelsiusreports as per customer requirement
• Scheduling Web Intelligence reports to various group of User for Monthly and weekly Basis
• Involved in migration of Reports and universes from SAP BOXI 3.1 to SAP BO 4.1 using Upgrade Management Tool
• Involved in basics administration like user creation, creating events etc.

Confidential, Dallas, TX

SAP Business Object Developer

Responsibilities:

• Involved in measuring performance of NSA and Multi-BSC NSA from deployment perspective with the help of various WEBI and Xcelsius reports.
• Involved in measuring performance of various domains such as NOIS, Maintenance
• Involve in creation of various WEBI reports to track various call scenarios such as voice call, SMS, data call, Call Forward, handoff, roaming etc.
• Involve in creation of various WEBI reports to track routing of messages between different nodes.
• Understand and analyze customer requirement
• Creation of test plan and test strategy documents
• Creation and execution of test cases for unit and integration testing
• Support during system testing and acceptance testing
• Interact and communicate to other teams from deployment point of view
• Creation of deployment documents like Installation Methods, 30 MSR and Deployment Guide
• Involved in maintenance of Business Intelligence server
• 24*7 support during deployment of features