Prasanta Ranjan Swain

Experience Summary

More than 19 years of IT experience including Managing Master Data Management, Data Governance, Data Quality Project and Operations.

Managed multi country MDM rollout which includes Master Data Solution, Data Quality, Data Security and Privacy across different levels and countries.

Highly experienced in building strong customer relations and ensuring quality and cost-effective delivery of MDM services in a timely manner; experienced in setting and managing realistic expectations for stakeholders;

Ability to drive the data management team across global locations. Strong attention to detail and exceptional analytical and problem-solving abilities

Worked in diversified business domains including Pharmaceuticals, Healthcare, and Banking etc. Some significant client includes Amgen, Pfizer, Merck, AstraZeneca, Amgen, Forest Lab, UBS, Celgene, McKesson etc.

Experience in Customer, Product data Master system

Expertise in integration to application including SalesForce, Veeva, ERP, Legacy systems, defining Workflows and Data Security implementation. Worked with external source system like IQVIA(IMS), AMS, HMS, Acxiom, Medpro, etc.

Experience in Sales and Marketing Alignment and Automation systems. Worked in Validated systems to define quality processes

Monitor and manage the program/project application engineering baseline to ensure activities are occurring as planned - scope, budget and schedule and managing variances

Proactively identify risks, issues and problems on programs/projects - leading project/program team to develop risk management and issue management plans

Ability to clearly articulate problems and proposed options and solutions and apply judgment in implementing application engineering methodologies, processes and practices to ensure security, resilience, maintainability and quality of MDM solutions

Relevant Project Experience

Integration of IQVIA ONEKEY and Global Key Opinion Leader (KOL Phase II) to Celgene Master Data Solution and perform Data Quality Analysis

Technology

Informatica MDM 10.2, Informatica DQ, Informatica Power Center

Client

Celgene

Project Abstract

This project is to Integrate Global Customers from IQVIA ONEKEY and KOL(Phase II) to Celgene Global Customer Master

The technology highlights of the program -

Informatica MDM- Create Customer 360 view in Informatica MDM

Informatica IDQ- Create and maintain Address and Name standardization rules for different source system.

Informatica PowerCenter : Create and maintain data extraction and transformation workflow from source system to MDM hub.

Role

MDM Project Lead and Lead Architect

Worked with the Technical/Business analysts for gathering Data Integration /Data Quality /Reporting requirements.

Profile source data using Data Quality(DQ) tool IDQ and shared result with Business. Based on DQ analysis define Cleanse and Standardization Rule

Design and update MDM Data model based on new source integration.

Design JSON based batch integration strategy, define Trust/Decay rules based in Business required and DQ analysis

Design Address Doctor to correct customer Address Information data.

Designed complete MDM process Landing, cleansing, standardization, Staging, Validation rules, Base Object changes, IDD user interface

Share weekly project status and SIT summary report to Business and IT leadership

Review System Design, Traceability, System Integration Test case

Support the Operation team for Gol live

Master Data Solution, Data Quality

Client

McKesson

Project Abstract

This project is to implement Master data management application and Manage Data Quality within MDM integrated System

Managing Challenges –

Build Complex Vendor Hierarchy from different system

Implement matching logic

External vendor such as SKA

Role

Technical Project Manager Master Data

Manage Business stakeholder and IT for requirements.

Define and document an enhanced data architecture that meets the needs of all the functional business areas and maintain this architecture (including maintenance of the persistence layer - i.e., operational data stores, reporting warehouses, metadata management, etc.) as needed. Review the data quality issue with stake holder.

Define and develop data governance framework, clearly identifying roles and responsibilities of technology and business teams. Includes processes for governing the identification, collection, and use of data and the steps to assure accuracy and validity.

Implement Data Quality Process for

Technology

Informatica IDQ, Metadata, Data Lineage, Hadoop

Client

UBS

Project Abstract

This project is to implement Master data management application.

The technology highlights of the program -

Informatica IDQ- Create and maintain Address and Name standardization rules for different source system. As Address and Names are basic for match rules

Informatica PowerCenter : Create and maintain data extraction and transformation workflow from source system to MDM hub.

Managing Challenges –

25+ Inbound source system/interface including all master

Batch interface with 3rd party vendor

External vendor such as Acxiom

Role

Data Quality Architect

Lead the various strategic data architecture initiatives around Master Data Management, Data Quality, Data Architecture Policies, Standards, Governance, Privacy and Metadata Management. Plan for major/minor releases with different teams.

Define and document an enhanced data architecture that meets the needs of all the functional business areas and maintain this architecture (including maintenance of the persistence layer - i.e., operational data stores, reporting warehouses, metadata management, etc.) as needed. Review the data quality issue with stake holder.

Define and develop data governance framework, clearly identifying roles and responsibilities of technology and business teams. Includes processes for governing the identification, collection, and use of data and the steps to assure accuracy and validity.

Customer Master

Technology

Informatica MDM, SQLServer, Web Sphere, IDQ 961,

Client

CUNA Mutual Group

Project Abstract

This project is to implement Master data management application.

The technology highlights of the program -

Informatica IDQ- Create and maintain Address and Name standardization rules for different source system. As Address and Names are basic for match rules

Informatica PowerCenter : Create and maintain data extraction and transformation workflow from source system to MDM hub.

Managing Challenges –

25+ Inbound source system/interface including all master

Batch interface with 3rd party vendor

External vendor such as Acxiom

Role

MDM Project Lead and Lead Architect

Worked with the Technical/Business analysts for gathering Data Integration /Data Quality /Reporting requirements.

Profile source data using Data Quality(DQ) tool IDQ and shared result with Business. Based on DQ analysis define

Design and update MDM Data model based on new source integration.

Design JSON based batch integration strategy, define Trust/Decay rules based in Business required and DQ analysis

Design Address Doctor to correct customer Address Information data.

Designed complete MDM process Landing, cleansing, standardization, Staging, Validation rules, Base Object changes, IDD user interface

Share weekly project status and SIT summary report to Business and IT leadership

Review System Design, Traceability, System Integration Test case

Support the Operation team for Gol live

CMA

Technology

Oracle 10G R2, Weblogic, Informatica 8.1

Client

Amgen Inc.

Project Abstract

This project is to integrate IMS HCOS into CMA Application for new product launch.

The technology highlights of the program -

Informatica IDQ- Create and maintain Address and Name standardization rules for different source system. As Address and Names are basic for match rules

Informatica PowerCenter : Create and maintain data extraction and transformation workflow from source system to MDM hub.

Managing Challenges –

10+ Inbound source system/interface including all master

Batch interface with 3rd party vendor

External vendor such as IMS and Medpro

Role

MDM Project Lead and Lead Architect

Interact with Business and IT for Solution Architecture

Facilitate the successful use of appropriate technologies to meeting business needs for integration, ODS, reporting and analytic purposes

Lead the development and integration of enterprise data across the organization including the production, identification, and extraction of data from source systems, the transformation and loading of data into databases, and the management and maintenance of tools used to perform these activities. A key objective will be to design and implement processes and technology to vastly improve the speed and efficiency by which data is secured and made usable.

Galderma Customer Master

Technology

Siperian Hub 9.5.1, Oracle 10G R2, Weblogic, IDQ, Informatica 8.1

Client

Galderma, Fort Worth, TX

Project Abstract

This project is to implement Galderma Customer master for their sales and marketing department for the purpose of managing the customer master and affiliation. The Customer master would be receiving data from multiple source system including two external vendor SHA and Medpro.Customer master will to way integration CRM.

The technology highlights of the program -

Informatica MDM 9.5.1:.Informatica MDM

Informatica IDQ- Create and maintain Address and Name standardization rules for different source system. As Address and Names are basic for match rules

Informatica PowerCenter : Create and maintain data extraction and transformation workflow from source system to MDM hub.

Managing Challenges –

10+ Inbound source system/interface including all master

Batch interface

External vendor such as SHA and Medpro Integration

Role

MDM Project Lead and Lead Architect

Interact with Business and IT for Incident management

Promotes and deploys best practices concerning Data Architecture

Responsible for influencing the organization and making decisions across the enterprise related to data..

Interact with external vendor IMS and Medpro

Review the data quality issue with stake holder.

AstraZeneca-US Core Masters Operation Support Lead

Technology

Siperian Hub XU SP2, Oracle 10G R2, Weblogic, Trillium, Informatica 8.1

Client

AstraZeneca (AZ), Wilmington, DE

Project Abstract

AstraZeneca’s Core Master provides Customer/Organization, Product, Plan and Block Master Data to AZ business stakeholder. Core master Operation activities include Incident, Problem management. Also includes small enhancement and product upgrade such as Informatica MDM and Trillium. Operation team also provides various daily/Monthly reports.

The technology highlights of the program -

Informatica MDM XU SP2 Patch B: Adding new cleanse rules and validation rules. Tuning the match/merge, Validation rules and Trust depending on the requirement.

Trillium 11.7- Create and maintain Address and Name standardization rules for different source system. As Address and Names are basic for match rules

Informatica PowerCenter : Create and maintain data extraction and transformation workflow from source system to MDM hub.

Managing Challenges –

50+ Inbound source system/interface including all master

Batch, Real time, Canonical interface

External vendor such as IMS and Medpro Integration

Role

MDM Architect

Interact with Business and IT for Incident management

Plan for major/minor releases with different teams.

Interact with external vendor IMS and Medpro

Review the data quality issue with stake holder.

Masterfile Data Sources Replacement(Siperian XT SP2) and Affiliation Synch with SAP CRM

Technology

Siperian Hub XT SP2, Oracle 10G R2, Weblogic, Trillium, Informatica 8.1

Client

Forest Laboratories Inc.

Project Abstract

Forest Lab’s Customer Master (CM) caters Customer and Organization Master Data to Sales and Marketing CRM system. This project is to integrate AMS and HMS source systems to CM. This includes processing the Customer and Organization information into Customer Master and managing the affiliation information to view/edit in Hierarchy Manager. Then, finally synching up the CM affiliations with SAP CRM.

The technology highlights of the program -

Integrate new source AMS and HMS into the current CM.

Adding new cleanse rules and validation rule for new Source

Re-defining the Match and Merge Rules for accommodating the new source.

Design new interface for SAP CRM for Affiliation Synch up.

Managing Challenges –

Re-define new Match / Merge rules to accommodate different types of customer for the new source system

Work with existing CM to define the List of Value (LOV) Synchronization.

Managing data synch up between CM and SAP CRM.

Role

MDM Architect

Project Initiation & Project Management of MDM track

Interacting with AMS and HMS source systems to understand the data and quality issues

Design the architecture for the CM and SAP CRM interface and data flow sequence.

Co-ordinate the interaction between CM and SAP teams at Onsite and Off-shore.

Work with stake holder for redefining the existing Match / Merge Rules.

Siperian BDD Implementation

Technology

Siperian XU SP2 Patch B Rollup 1, Triilum, Business Data Director (BDD), Java, JSP, Log4j, JBoss 4.0.5, Oracle 10g, Informatica,

Client

Merck & Co

Project Abstract

Implementing Merck’s new graphical user interface (GUI), Business Data Director (BDD) integrated with the Siperian Customer Master (CM) system. The BDD will support Data Stewardship operations, in real and near-real time, on CM Best of Breed (BoB) records and all source information. The GUI will also support pending operations. With creation of the new GUI, functionality that is currently spread across multiple applications like the CM Pending Tool, CM Search Tool, Siperian Console and SM SOPs will be integrated into a single centralized tool. Additional capabilities will be added such as a User Dashboard, links to the help desk, and LOV viewing. The CM GUI application will replace the various existing data stewardship applications presently used by ICI data stewards.

The technology highlights of the program -

Configuring Siperian Business Data Director (BDD) over Siperian Hub.

Connecting Siperian component with BDD for defining rules.

Deploying Customized J2EE component with BDD.

Managing Challenges –

Understanding new user interface BDD’s capability and limitation

Customization of BDD according to the User requirement.

Performance effectiveness of the user interface.

Train the end User for effective use of BDD.

Role

Onsite MDM Lead

Understand the user requirements and convert them based on capabilities and limitations of BDD. Since this was the first release of BDD, in some instances had to provide work around methodologies

Worked with vendor Informatica, for customizing some user requirements and the issues arising due to the implementation of a brand new product (BDD).

Worked with onsite and offshore team for customization of BDD for user requirements.

Coordination with offshore Lead for achieving on time deliverables.

Work with onsite technical team during development and deployment.

Pfizer Consolidated Customer Master(CCM), Global

Technology

Siperian MRM, Address Doctor, Java, JSP, Jakarta Struts 1.1, JDBC, EJB, Java Mail, XML, Weblogic 9.2, Oracle10g, Sun Solaris 10, Rational Rose Enterprise 7.0, UML, ANT, Eclipse Europa, Log4j

Client

Pfizer Inc.

Project Abstract

Pfizer’s CCM will unify customer information from multiple sources and systems to create and maintain a unique, complete and accurate customer profile and make that profile information available to all operational applications in batch and near real time (Message Queue). CCM will reduce cost – hardware, software & maintenance across multiple countries. Provide single version of truth across the enterprise (US, Europe, Canada) for all entities

There was a need for a J2EE based User Interface built for the Data Stewards to manage potential matches, feed exceptions and search customers. This UI was built over Siperian Service Integration Framework (SIF).

Siperian was used as MDM tool and Informatica used for source data extraction.

This was a multi year, multi country rollout program with multiple tracks dealing with the development and maintenance of multiple Master data.

The technology highlights of the program -

Implementation of Multi country rollout in single MDM repository

Handing enormous amount of data in multi country rollout.

Implement MS BizTalk for workflow orchestration and messaging ESB

Integrate with multiple data providers based on the country of operations (IMS, Dendrite, Cegidm etc)

MDM is integrated with major systems like Siebel SFA, Call center, eClinical, Oracle Finance, SAP HR systems among others

Managing Challenges –

Data privacy and secrecy across multiple countries and different levels within countries

Managing the data loading windows across different countries

Defining local and global rules across multiple countries

Manage Information ownership Issues and conflicts

Timeline alignment of different ongoing programs with the MDM implementation program and manage dependencies

Working with Multiple Application team and various vendor, while integrating source systems and application

Performance of data load into and out of the MDM systems

Role

Onsite MDM Lead

Worked with stakeholders during requirement gathering around Siperian capability and limitation.

Worked with stakeholders to define Match, Validation, Trust rules

Designed the MDM Data model with the client Data Architect team

Designed the MDM system, defined Landing, Staging and Base Objects

Design universal Inbound and outbound interfaces definition. All the external and internal source system follows interface format to send or receive data from MDM

Define real time interface using Biztalk and near real time interface using Siperian’s message Queue.

Work with inbound and downstream source system to define a hand shaking mechanism for data availability and consumption.

HLC(Health Law Compliance) HCPM (Health Care Provider Master)

Technology

Oracle 9i, Siperian Hub XT, Data Stage.

Client

Pfizer Inc.

Project Abstract

Pfizer’s HCPM will unify customer information from multiple sources and systems, create and maintain a unique, complete and accurate customer profile and make that profile information available to all operational applications in real-time

The technology highlights of the program -

Defining complex validation rules in Siperian

Design and develop a user interface using Siperian provided Hierarchy manager SIF component

Managing Challenges –

Defining complex compliance validation rules in Siperian

Producing out bound data feed to Spend analysis system about the expenses on the customers

Role

Onsite MDM Lead

Working with stakeholders during requirement gathering around Siperian capabilities and limitation.

Worked with stakeholders to define Match, Validation, Trust rule

Designed the MDM system, defined Landing, Staging and Base Object

Designed universal Inbound and outbound interface definition

Produce the outbound extract for the Spend Analysis system gold copy with expense information.

Pfizer CCM Pilot

Technology

Oracle 9i, Siperian Hub XT, Data Stage.

Client

Pfizer CCM, UK

Project Abstract

Pfizer’s CCM pilot will unify customer information from multiple sources and systems, create and maintain a unique, complete and accurate customer profile and make that profile information available to all operational applications in real-time. This project is implemented as a Pilot project.

The technology highlights of the program -

First Siperian implementation for Cognizant.

Understand the Siperian Product.

Role

Onsite MDM Lead

Working with stakeholder during requirement gathering for Siperian capability and limitation.

Work with stakeholder to define Match, Validation, Trust rule

Design the MDM system, define Landing, Staging and Base Object

Customer Master & Alignment

Technology

Java, JSP, Jakarta Struts 1.1, JDBC, EJB, JMS, XML, Weblogic 8.1, Oracle9i, Sun Solaris 5.6, Unix Shell Script, Rational Rose 2003, UML, ANT, Eclipse 3.1, Log4j

Client

Millennium Pharmaceuticals

Project Abstract

To manage Millennium pharmaceutical customer, includes Doctors, Hospitals, Pharmacies ect. Customer Master(CM) provides functionality for Add, Update and Delete. CM provides customer match and merge between different source systems and provides gold copy version.

Also to manage these customers for reporting purposes, it provides Alignment system, where it creates logical territories and aligns with customer

The technology highlights of the program -

Develop a J2EE based MDM system,

Build inhouse Match Engine.

Role

Offshore Lead Architect managing a team of 10. Responsible for

Entire development life cycle including testing phase,

Manage the offshore team

Customer Master and Alignment 1.1

Technology

Java, JSP, JDBC, EJB, XML, Weblogic 6.1, Oracle 8i, Sun Solaris 5.6, Unix Shell Script, Rational Rose 2000, UML, Jakarta Struts 1.0

Client

Amgen

Project Abstract

Amgen’s Customer Master and Alignment (CMA) systems designed for integration into Sales and Marketing Information architecture. CMA provides an interface to users for Customer Profile Management, Field Force Alignment, including Field Force and Management hierarchies, as well as setting up the Field Force Relationships to Customers and Organizations that Amgen does its business with - directly and indirectly. CMA is built upon the cutting edge technologies and patterns of Java 2 Enterprise Edition (J2EE). Key technologies and tools which are leveraged in this project are Java Messaging Service (for asynchronous communication) Java Server Pages (for user interface), Enterprise Java Beans (business components), Tibco (enterprise application integration), Web Services (platform independent communication between systems). The development process itself follows the industry standard Rational Unified Process and makes full use of Rational’s project management and execution tools. CMA is an effort towards improving scalability, enhancing performance and providing major functional upgrades to the existing system.

Role

Offshore Lead to a team of 4 team members. Responsible for

Analysis the Change Request and enhancment

Designing the application

Implementing and testing the application

Unicorn6.0, Telecom Billing – UshaComm

Technology

Java, JSP, JDBC, Oracle 8i.0

Client

UshaComm

Project Abstract

UshaComm develops and delivers billing and customer care software to help operators build profitable businesses and maintain strong relationships with their subscribers and business partners. UshaComm deliver almost all critical pieces of BSS like billing, customer care, interconnect billing, mediation, partner settlement solution, revenue assurance etc.

Unicorn Web reporting User Interface using crystal 9.0 and crystal report application server. The reporting Module consists of reports of Packaging .Credit Control, Billing, Accounts and payments and Customer Care module of the Unicorn 6.0 release.

Role

Offshore Lead to a team of 4 team members. Responsible for

Creating Access control list for reporting module using java beans

Creating java beans data source for repors with electric xml parser (SAX)

Using and crystal 9 SDK to bring the report on the web.

Contact this candidate