SUMMARY:

• 7+ years of experience in Analysis, design, development, implementation, testing and maintenance of applications in Real - time.
• Data analysis of meter data in MDM and generating reports, identifying data mismatches and proposing data fix solutions.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration, and Metadata Management Services, and Configuration Management.
• Extensive experience in designing, supporting and enhancing SAP NetWeaver MDM (Master Data Management) application.
• Strong experience in analyzing systems to determine opportunities for enhancement, propose solutions to build efficient applications.
• Experience in supporting Informatica applications, data extraction, Transformation and Loading from heterogeneous sources using informatica Power Center.
• Extensive experience in reviewing and understanding of Business & Testing requirements and writing detailed Test Plans, Test Cases, and Test Scripts.
• Collaborated with the MDM Architect on the development of the MDM Integration Plan and the MDM Hub architecture.
• Performed Current State/Gap/Fit-for-Use analysis on data, procedures, and systems (Veeva, R-Squared, and internal systems) relating to the integration of the MDM Hub solution.
• Created and managed Function Requirements Specification document for the creation of the MDM Hub and associated integration points.
• Data analysis of meter data in MDM and generating reports, identifying data mismatches and proposing data fix solutions.
• Proficient in working with healthcare Technology standards such as HL7, ANSI ASC X12, IHE XDS/XDM, HITSP, CCR (continuity of Care Record), CCD (Continuity of Care Document), NCPDP Script 8.1, ELINCS, and CDA, HHS, CMS, RHIO's, IHDN's.
• Extensively uploaded test cases from MS Excel, MS Word to Test Director & Quality Center.
• Worked on Extracting, Transforming and Loading (ETL) process to load data from Excel, Flat file to MS SQL Server using SSIS.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse.
• Designed normalized (3NF) Conceptual/Logical Data Model for MDM Hub Landing, Processing, and Publish layers.
• Designed layout and data content of target system specific MDM Integration Extracts.
• Created and managed Test-Plan and Test Case scenarios (SIT and UAT) for the integration of data into and out of the MDM Hub.
• Developed data quality procedures to monitor the accuracy and completeness of MDM output from vendor (HMS) as it specifically relates to Compliance (PPACA and State Reporting) needs.
• Heavily interacted with Dataware housing team in Metadata Modeling and gathering requirements.
• Assisted new team members on MDM technologies and project domain.
• Strong functional knowledge of SAP MDM Architecture, Data Manager, Materials & Services Data Model, tables, MDM Console, TIBCO MDM.
• Extensive knowledge of Object Oriented Analysis and Design using Rational Unified Process (RUP) and UML Methodology.
• Expertise working as a liaison among stakeholders, understanding business operations and proposing solutions that add value to the business as well as business units and information technology.
• Experience in defining and creating data models, schemas, Data Dictionaries and Meta Data Repositories.
• Experience in designing interfaces for MDM and ECC using PI/XI and creating mapping documents.
• Expertise in using HP Quality Center and JIRA for test and defect management.
• Experience in playing lead roles in projects where necessary, handled work allocation, peer reviews, managed weekly status reports.

PROFESSIONAL EXPERIENCE:

Sr. MDM Business Analyst

Confidential,Lincoln, NE

Responsibilities:

• Worked as a liaison among business client and development team for the implementation of 4010 to 5010 transition in compliance with HIPAA standards.
• Identified the business functions and processes, and prepare system scope and objectives based on user needs and industry regulations.
• Defined terms, conducted stakeholder analysis, elicited business needs, conducted business process modeling work, facilitated work sessions (JAD), elicited requirements, wrote requirements and use cases, analyzed requirements, validate & prioritize requirements, trace requirements to related project documentation (process models, designs, test scenarios & scripts).
• Gathered requirements by using interviews, observation, JAD, brainstorming sessions, and documents analysis.
• Responsible for the analysis, design, development, testing, and support of data extract, transform, and load processes within the enterprise data warehouse
• Developed complex SQL queries to create OLAP cubes inside the data-warehouse.
• Migration of new customer data platform from legacy system CDB to new MDM.
• Setting of timelines to meet the required time and designing project plans using Microsoft project.
• Documented standard procedures for developing and designing all BI solutions
• Own, managed and created data mapping documentation of Customer Information and Payment information from old CDB platform to new MDM platform.
• Worked closely with the team members to identify any bugs, fixes, any issues regarding the development and designing.
• Used Data Mining extensively to analyze data from different perspectives and summarizing.
• Used MDM tool to support Master Data Management by removing duplicates, standardizing data (Mass Maintaining), and incorporating rules to eliminate incorrect data and filter data as per requirements.
• Involved in Data mapping, logical data modeling used SQL queries to filter data within the database tables.
• MDM to resolve data issues to recognize the inconsistent and duplicate data and finding useful relationships to improve business performance.
• Analyzed business scenarios to track possible business outcomes for the functions which could be incorporated into more detailed test scripts.

Sr. MDM business analyst

Confidential,Chicago, IL

Responsibilities:

• Analyzed legacy business procedures and problems to define data, systems, and program functions and to convert systems and programs to Functional specifications.
• Involved in full life cycle implementation of SAP NetWeaver Master Data Management (MDM) 5.0, 7.1.
• Involved in SAP MDM Support Pack upgrade projects, user interface redesign project using SAP CE, BPM.
• Guide and Manage Informatica product implementations for MDM and Data Governance
• Extensively worked with data warehousing, ETL methodologies, technologies, using Informatica Power Center.
• Involved with full life cycle implementation of SAP MDM 5.0 & 7.1. Involved with design, development, support, enhancement and maintenance of SAP MDM application (Master Data Management).
• Create automated reporting in Excel using VBA, Access DB, and SQL Server connections.
• Managed functional requirements for interfaces and conversions between SAP ECC and other legacy systems to Teradata, MDM, Enhancements, Workflows and Reports for MDM.
• Represent and present Informatica perspective/methodology on MDM and Data Governance at conferences
• Experience in error handling, performance tuning and problem fixing in Informatica MDM.
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Strong functional knowledge of MDM Data Manager, MDM Console as well as MDM Main tables, Lookup tables.
• Created Work Flows, Process Flows, Flow Charts and Mock-Ups of user interface screens using Rational Rose & MS Visio.
• Conducted meetings and Joint Application Development (JAD) sessions with users to gather requirements for enhancements to existing applications and new applications to be developed.
• Involved in defining tables, fields, data types in MDM Repository and MDM Console.
• Developed interface mapping documents to capture requirements for mapping MDM to ECC & NAMS (Nuclear Asset Management System) applications via PI 7.0, 7.1.
• Coordinated weekly milestone meetings with team members, business meetings with customers.
• Conducted user interviews, gathered requirements, analysed the requirements by using Rational Rose, Visio and Requisite pro - RUP.
• Managed useful project documents, FDs (Functional Design Documents), Test Scripts, on MS SharePoint.
• Experience in leading production support help desk for MDM team, performed as tier 1 support. Managed production tickets, defects using Sharepoint, Remedy & Lotus Notes applications.
• Hands-on experience with SAP MM application. Helped design the interfaces between MDM, ECC & SRM during various implementations. Extensive involvement with material creation, update process in MM. Involved in designing the material creation workflow from MDM to ECC.
• Performed system testing in various phases of project life cycle: Functional Unit Testing, Functional Integration Testing, Performance Testing, Load Testing, Regression Testing, User Acceptance Testing.

MDM Business Analyst

Confidential,Overland park,KS

Responsibilities:

• Gathered business requirements by driving user-group meetings and working with various global, cross-functional and virtual teams
• Mapped process flow; assess as-is processes through user interviews, data collection and analysis, design and evaluation of to-be process solutions.
• Contacted patients and doctors to obtain Medicare compliant documentation to receive durable medical equipment.
• Experience in integrating external application with Informatica MDM hub using message queries as a significant advantage.
• Extensively worked with data warehousing, ETL methodologies, technologies, using Informatica Power Center.
• Excellent hands-on Data Exchange, MDM, IDQ, Data Transformation, SQL development.
• Good knowledge in Data warehousing concepts involving dimensional Star Schema, Snowflakes Schema and Galaxy Schema methodologies
• Performed requirements gathering, future state data maintenance process and data structure design, system configuration, testing and on-going support of MDM system with help of analysts.
• Coordinate Master Data synchronization requirements during the migration timeframe to ensure accuracy of data transfer.
• Expertise in documenting the ETL process, Source to Target Mapping specifications, status reports and meeting minutes.
• Expertise in transforming data imported from different data sources into analysis data structures, using SAS functions, options, ODS, macro facility and other SAS procedures.
• Work on the Data Governance and Data Quality approach for EIM data. Create Traceability metric.
• Working within a growing knowledge of X12 4010 HIPAA 837 I, P, D, 835, 834, 820, 270, 271, 276, 277, 278, EDI, Privacy, Security, and Medicaid.
• Participated as a core team member of a Clinical Development initiative to create an architectural business end-to-end solution for clinical trials as a standard for all remote data capturing clinical trials.
• Helping HHSC clients on welfare benefits they receive.
• Make customized changes to the MMIS per state guidelines and client request
• Created new security reports and maintained other security reports within MMIS system
• Facilitate and lead requirement gathering sessions, JAD sessions, and Prototyping sessions
• Experienced in writing Indexes, PL/SQL procedures, Functions, Packages, Database Triggers.
• Experience in error handling, performance tuning and problem fixing in Informatica MDM.
• Involved in implementing Oracle MDM system and defined master data that connects to transactional system and Data warehouse.
• Converted Data from different legacy systems with respect to the organization's business rules into the Oracle Application system.

MDM Business Analyst

Confidential,Cincinnati, OH

Responsibilities:

• Worked with Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Configuring Informatica Data Director (IDD) to meet Data Governance objectives in many project life cycles.
• Proficiency in analyzing and Creating Use cases, Use Case Diagrams, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams and Navigational flow diagram and Sequence diagrams using MS Visio and Rational Rose.
• Involve in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.
• Designed and developed MDM data model and integration between SAP MDM and WebSphere Process Server.
• Performed mappings & ran sessions and workflows to execute the Land Process of loading the customer data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
• Create MDM mappings using best practices to capture the errors and have a clean load.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Apply UML notations and methodology in developing models that accurately represent the business process and workflows and clearly communicate them to the stakeholders.
• Managing the User Access Levels and roles for the MDM Application through Security Access Manager.
• Experience working with Siperian Hub MDM (Master Data management) for customer integration model and tested the same.
• Created business requirements and helped system analysts in converting them into System Requirement Specification (SRS) document for MDM Business and Data Quality Requirements.
• Managed MSSQL data warehouse, Wrote SSIS for ETL tools, SSAS for data analysis, SSRS for reports.
• Conducted user interviews, JAD and RAD sessions, gathered Business requirements, FRS's and analyzed the requirements using MS Visio.