PROFESSIONAL SUMMARY

• A Master Data Management(MDM) Systems Analyst Professional with 10+ years of experience in Information Technology and 7+ years in Data Modeling, Data Mining, Business Process Management and Software Design across project lifecycles with expertise in Retail, Finance and healthcare domains
• Experience in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence in Marketing, Sales modules.
• Deep understanding of with MDM capabilities, and methodology and approach to MDM implementations.
• Extensive experience in Data warehousing and Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components. Worked a lot on Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence/ Oracle Business Intelligence Apps (BI Apps).
• Demonstrated fundamental knowledge of ETL(Extract - Transform-Load) concept
• Performed Data Profiling and Data Quality.
• Expertise in a variety of different file/data formats
• Experience in data analysis and ability to reverse engineer database schema highly desirable
• Thorough knowledge of database design and associated tools
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Good Data Warehousing concepts including Meta data and Data Marts.
• Very good experience in Master Data Management(MDM) and various concepts.
• Deep understanding of RUP, Siebel eRoadmap and SDLC. Expert in documentation, preparing templates and status reports.
• Involved in all the aspects of batch and realtime integration. Designed interfaces from a functional standpoint.
• Have also done testing of interfaces.
• Have been part of integration efforts for export and import of data using EIM in functional capacities.

TECHNICAL SKILLS

Oracle Skills: MDM, eFinance, EIM, EAI, Server Administration, Workflow Manager, Contracts, Order Management, Siebel VB and Siebel e-Scripting.

Packages: Siebel 8.2/8.1/8.0/7.8, 7.7.x, 7.5.x,7.0.x,2000

RDBMSMS: SQL, MS ACCESS, Oracle 12g

Report Tool: Crystal Reports, Actuate 5.0/4.5

Operating System: Windows 2000/ NT/ 98/ 95,XP/7/8, UNIX, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Environment: Informatica MDM, Product Data, Data Goverance, Data Conversion, Data Profiling, Data Consolidation, Data Mapping, Data Governance, Data Quaity, Data Warehousing, Stibo Systems, ETL, Metadata, BI, Oracle, Agile, PIM, Product Management

Sr. MDM Systems Analyst

Responsibilities:

• Gathered and documented MDM application, conversion and integration requirements.
• Providing written direction to these groups regarding product functionality that improved the implementation process.
• Responsible for architecting a Product Information Management system and making the data available through web and internal portal channels. The MDM product used was STEP from Stibo Systems.
• Worked on MDM with PIM Product Information Management
• Facilitated design negotiation and decision making between application teams (Master Data Management (MDM), Content Management)
• Led teams of business and technical analysts in the collection and documentation of business and technical requirements gathering for the development of MDM, Data Warehousing and Reporting implementation roadmaps.
• Led development and documentation of data governance policy and procedures as well as Stewardship inventory and control set up processes for MDM projects.
• Answered questions of various impacted systems’ and business’ representatives regarding UCM capabilities.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Worked directly with suppliers, product managers, sales, and marketing to obtain accurate and complete product content associated
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures
• Worked with users to understand their day to day tasks and processes.
• Analyzed interfaces for strengths and deficiencies.
• Interviewed various stakeholders and documented process flows.

Confidential, Detroit, MI

Environment: Informatica MDM, Product Data, Data Goverance, Data Profiling, Data Mapping, Data Quaity, Data Warehousing, Informatica, ETL, Data Modeling, Metadata Management, Product Management, Pivot Tables, Informatica, ETL, Java, Stibo Systems, PIM

Sr. MDM Systems Analyst

Responsibilities:

• Involved in understanding the customer requirements and mapping the business.
• Involved in defining the product structure and user sessions and configuring the screens as per the client’s requirements.
• Worked directly with vendors and company representatives to maintain all product attributes within the Product Information Management (PIM) software.
• Gathered requirements, developed solution, managed application development, and data conversion and initialization across multiple environments Master Data Management (MDM) from requirements through stabilization.
• Led requirements gathering for MDM tool implementation and user workflow processes.
• Prepared UCM data architecture recommendations including who or what should be represented in the customer master, customer relationships, types of addresses, contact information and other customer master.
• Involved in designing and documenting and implementing a solution based on UCM module of Siebel for maintaining a customer master and implement rules of synchronizing data between Siebel and other systems and UCM.
• Worked on Data analysis for fine tuning the system data flow at the same time to adhering to business process.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing enterprise.
• Worked with internal architects in the development of current and target state data architectures
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements
• Moderated meetings and facilitated interaction between developers and end users.
• Developed high level Design documents for data mapping of various function points discovered during Discovery and Design stage.

Confidential, Location:

Columbus, GA

Environment:MDM, Healthcare, HIPAA, MMIS, Product Master, Data Cleansing, Data Conversion, Metadata Management, Data Profiling, Data Mapping, Data Quaity, Data Warehousing, Informatica, Teradata, Data Modeling, Informatica, ETL, Java, Agile, PL/SQL

MDM Business Systems Analyst

Responsibilities:

• Responsible for analyzing the client business process requirement and mapping it with the Siebel functionality.
• Facilitate and lead workshops focused on customer data pain points and arrive at a suitable UCM data model
• Actively participate in the Design, Build, Test, and Deploy phases of Siebel UCM implementations for Oracle customers.
• Document outlining the expected level of effort and resource requirements to configure required MDM Hub side to support the client onboarding and maintenance business processes within company.
• Gap-Fit each MDM requirement as well as provide high level of estimate for the level of effort required to meet each requirement.
• Worked on data migration batch design for migration of Accounts, Contacts, Assets, Opportunities, Service Requests, Activities, Prospects and List related components from an old Siebel application to a new implementation.
• Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• Created data trace map and data quality mapping documents.
• Performed Data Profiling and Data Quality.
• Involved on user training, UAT, functional testing and various sign-offs processes.
• Played a key role in ensuring production rollout. Worked on various aspects like application data setup including positions and responsibilities, user level data set up and other data set up including LOV’s and static pick lists.
• Worked as point of contact for various users during UAT to ensure timely response to any queries and issues found during UAT.
• Facilitated meetings between stakeholders, user representatives and project team. Conducted JAR/JAD sessions between developers and End users.

Confidential, Concord NC

Environment: MDM, Oracle UCM, Upgrade, Oracle, Smartscripts, campaigns, Data Cleansing, Data Harmonization, Data Conversion, Data Management, Data Quaity, Data Warehousing, Metadata Management, Data Modeling, Web Services, Informatica, ETL

MDM Business Systems Analyst

Responsibilities:

• Making a preliminary estimate of the feasibility of solutions within cost and profit metrics of the client.
• Document outlining the expected tasks, level of effort and resource requirements to migrate from Oracle UCM to Oracle Fusion Customer Hub in the future.
• Provided direction to less experienced software engineers regarding MDM platform development, processes, and product architecture.
• Hands on UCM development for Survivorship, real-time integration using UCM web services and Data Quality
• Deliver Functional Design for integrating customer Product reference and hierarchy data into UCM Worked on creating a Siebel UCM solution to set up customer data.
• Worked on Entity, field and dropdown values( LOV) level mappings from spoke systems to UCM.
• Worked on identifying the strategy for loading the data into hub (UCM) as part of the initial load.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.
• Performed data analysis for the existing data warehouse and changed the internal schema for performance.
• Developing and articulating standardized processes and deliverables.
• Involved in gathering requirements for various modules
• Performed a study to establish the difference between old legacy system and Siebel.

CONFIDENTIL, Mankato MN

Environment: MDM, Oracle, Data Quaity, Data Warehousing, ETL Tools, Data Modeling, SAP, Informatica, Windows, Unix, SQl Server, EIM, EAI, eScript.

MDM Business Data Analyst

Responsibilities:

• Contributed to business process understanding during GAP Analysis.
• Gathered Siebel requirements from customers.
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
• Actively participated in the requirements and process mapping workshops for the project.
• Involved in understanding the customer requirements and mapping the business.
• Participated in the design of various development templates and methodology documents.
• New corporate business account process
• Credit limit increase for existing account/card
• Add a new card to existing account
• Writing Test Cases after going through the SRS/FRS/Design Document
• Executing the test cases
• Conducted manual testing to ensure deliverables as per client specifications
• Involved in GUI, Functional Testing