Management Data

Pranab Mukherjee

Albany, NY • 205-***-**** • ****************@*******.***

Principal - Information Management

Pranab Mukherjee is currently an MDM Data Governance Architect at United Health Group. He is responsible for advising Business Stakeholders on best of breed strategies and responsible for delivering Master Data Management, Business Intelligence and Data Management solutions built on best of breed technology in the healthcare Payer business unit. As an adviser and program delivery leader for MDM projects he works with Business & IT Senior level executives to drive affiliations and align value creation opportunities in order to successfully architect business and technology transformation engagements.

Pranab is a technology leader with over 18+ years of experience in enterprise and application architecture, he has worked the full lifecycle of IT delivery starting with strategic planning in both the commercial and public sector, the Agile development and proposal of technical solution architectures in oral and written proposals, implementation planning with the development of timelines, cost estimates and resource needs, through the successful solution delivery and sustained operations. He also has progressive experience in leading complex, multimillion-dollar transformation projects which consistently result in high profit margins. He leverages his management consulting & IT experiences to drive a business focused strategy that aligns processes, tools & technologies.

He demonstrates comprehensive knowledge and insight by designing, building, and directing end-to-end data management, architecture, integration, and governance. He is the main executive liaison between his consulting employer and top level management (CTO and CIO). Pranab advises client management on how to deliver business results on time and on budget. He keeps them updated on status and proactively communicates risks so they can be managed properly.

He has delivered multiple mission-critical Master Data Management (MDM) and Business Intelligence (BI-DW) strategic projects with modular and scalable solutions based on service oriented architecture (SOA) integrated with an enterprise service bus (ESB) isolating business and technical services with common reusability across global enterprises.

He drives adoption of new Agile developments in the approach, tools and technologies relating to data management and also has strong strategic ability to design frameworks for data architecture with a focus on quality, performance and security. Pranab assures Agile framework compliance through review of designs and code.

Professional Experience

United Health Group(Optum Technology) March 2016 - Present

Currently working as a Sr. MDM / DG Architect on a Big Data and IBM InfoSphere MDM 11x project. Current responsibilities include but are not limited to initiating and providing solutions for data governance and technology frameworks for multiple business stakeholders based on the industry's three key pillars of People, Process and Technology.

Healthfirst – New York, NY January 2015 – February 2016

Healthcare insurance

Sr. Solution Delivery Manager

Worked as a Sr. Solution Delivery Manager in a multi-domain (Payer and Provider) Informatica MDM project. My responsibilities cover the whole ownership of MDM delivery starting with the delivery of a multiyear strategy roadmap, key stakeholder identification, data governance setup and on to implementation of the strategic roadmap.

Infosys Public Services Ltd. – New York, NY Nov 2012 – November 2014

IT & Business Strategy / Transformation consulting services

Sr. Principal, Business Consulting

Lead a $9M+ Data Management, MDM, BI reporting and Analytics program with an onsite team of nearly 22 members working with District agencies, multiple COTS partners and service providing vendors. Led the overall program to implement DC health benefit exchange (DCHBX) (www.dchealthlink.com) within a compressed timeline and met ACA mandated production live date of October 1, 2013. The solution uses COTS products, provides all of the required critical reporting and analytics functionality, and has an operationally-ready exchange staff connected to the citizens and communities.

Engaged with the key stakeholders to identify custom functionality in addition to out of the box (OOTB) features of COTS products. Implemented an ESB/SOA architecture which emphasizes standards-based interoperability between COTS products and with external data sources, including Federal Data Source Hub(FDSH), commercial issuers (using SERFF), and legacy systems.

Defined timeline for delivery and support of the complex program and aligned pricing schedule by breaking down functionalities and features of entire program into three yearly releases with milestones. Provisioned for system maintenance, warranty support, IT help desk support and enhancement.

Computer Science Corporation – Colombia, MD 2011–2012

CSC provides global IT consulting services.

Principal, Master Data Management & BI

Managed large engagement to deliver right value proposition on multiple master data-management transformation projects of budgets up to $8.2M for federal government agencies. Develop pre-sales proposed solutions, implementation plans, and business cases. Provide post-sales full life-cycle management of solutions to realize the business case. As client advisor, provide an engagement strategy, execution approach, risk mitigation and governance for large MDM projects.

Capgemini – New York, NY 2010–2011

Capgemini is a global IT services and consulting company.

Manager, Business Information Management

Devised an engagement strategy to realize the vision “One Dean Way” to produce and maintain common, global customer data. Created a common depository approach for authoritative customer records. Advised risk mitigation and rollout strategy to ensure consistent customer maintenance processes across Dean regions and appropriate control levels were employed without slowing customer-facing processes. Employed a centralized customer MDM repository that propagates common customer fields to OTC systems and prevents local users from overwriting global values.

Improved the visibility of customer’s performance across internal and external, finance, and distribution hierarchies.

Empowered a Customer Data Governance organization to make critical business decisions based upon customer data.

Increased the portability of customer records across OTC platforms.

TCS America – New York, NY 2010

TCS is a services, business solutions, and outsourcing company.

Senior Engagement Manager

Led transformation team performing a 32-week enterprise assessment for PNC Bank post merger with National City Bank. Developed the business case for enterprise-wide transformation initiative to create a Product Master as an initial Master Data Management effort.

Studied PNC and National City bank existing product lines and provided recommendations for the optimal method of merging two different product lines as well as implementing a master Product Master.

Created a Business case that quantified the business benefit along with an impact analysis and an enterprise-wide product master implementation strategy.

M. Dubliner – St. Louis, MO 2009–2010

M. Dubliner provides custom IT system development and program management skills.

Independent Contractor

Facilitated procurement of resources to manage IT Projects and also oversaw and mentored them during the project execution. Led a project team developing custom real estate valuation software and a BI application to monitor IT systems operations.

Accenture – New York, NY 2004–2009

Accenture is a global management consulting, technology services, and outsourcing company.

Enterprise Information Management Program Delivery Manager, Best Buy, 2008–2009

Led projects as big as $12.5 with a team size of up to 39. Project scope included simplified returns and exchange processes, robust receipt look-up capability, integrated tech check applications, and integrated item master and dot com integration. Led project auditing initiatives, identified major defects inherent in the process and system through root cause analysis, and devised improvement strategies. Collaborated with representatives from Finance, Quality Assurance, Engineering, Logistics, vendors, and customer’s functional departments in a cross-functional metric environment.

Led and deployed a successful $6M custom returns application for Best Buy’s EDW and MDM within two years; the U.S. version of the end-to-end solution was piloted in April 2008 with a chain-wide rollout completed by Fall 2008. Created and implemented change requests of $150,000.

Implemented improvement plans to increase enterprise-wide, return system efficiency.

Onshore Information Management Delivery Lead, AG Edwards, 2005–2008

Supervised, deployed and rolled out delivery of third-party and historical-load subject areas. Mentored the client’s data architect and Data Quality team. Defined and established enterprise-wide, data governance processes. Established data management protocol and obtained executive approval. Collaborated with database administrators to implement designs. Supervised coding and testing of ETL by the offshore team and assisted in loading metadata properly in compliance with quality standards.

Implemented a $9M global central data repository. Enabled Accenture to obtain an additional $80,000 in revenue and created a new business opportunity for Accenture with AG Edwards.

Identified and created charters for additional data governance and quality projects; DQ compliance and data lifecycle management that archived continual improvements.

Set the design standards across the enterprise and established offshore development capabilities.

Saved 160 work hours and $15,000 in monthly expenses through eliminating redundant processes; raised awareness of the client team on existing, broken DQ processes and educated the client on industry best practices and process alternatives.

Produced processes that allowed the client to track and document aggregate tables, business transformation rules, and subtotals. Customized standards to suit financial services.

Lead BI, / DW Architect, 2004–2005

American Express: Created and addressed the U.S. Management Reporting Data Warehouse that resulted in providing accurate, timely, and financially balanced reporting. Automated a sustainable, controlled process to drive financial reporting that was transformed to include BI capabilities and to pursue shareholder value that met client and customer goals. Interviewed stakeholders to gather and develop reporting and ETL requirements. Educated the client in Accenture Data Warehouse methodology. Prepared and maintained the project plan for offshore ETL, reporting, and historical data-loading development. Performed requirements analysis and established new standards for the data warehouse. Conducted change-control meetings with business users.

Trained and developed the 30-member offshore ETL team on the data model and ETL design.

Kaiser Permanente: Assigned to the National Pricing System (NPS) “Right Price Project” to provide a consistent and accurate rating while supporting product, segment, and market requirements. Implemented the NPS Right Price system to impact the manner in which Underwriting, Sales, Account Management, and Actuarial departments interacted and conducted business. Performed data modeling and created the conceptual, logical, and physical data model using ERwin tool.

Developed database design standards and the change request template.

Managed change management activities and prepared the system test and development plan

Other Significant Experience

Birlasoft, General Electric Corporate Information Systems Group 2002–2004

Technical Onshore Project Coordinator

Boston Scientific Corporation 2002

Senior Consultant

Baptist Health Systems 2001–2002

Technical Project Leader

R Systems Inc. 1997–2002

Senior Systems Analyst

Adventist Health Care 2000–2001

Senior Programmer Analyst, PeopleSoft Financials

Marriott International 1997–2000

Programmer Analyst, PeopleSoft Support

State of California, Department of Corrections 1997

Design Consultant, Security Interface Design

Technical Expertise

Technology Skills: Pranab has the rich experience in the following areas;

Master Data Management: IBM –Initiate; InfoSphere; Oracle-UCM; PIM; SAP

Architectural Standards: Workflows, Distributed Enterprises, Zachmans Framework, TOGAF etc.

Development Methodologies: Waterfall, RUP, Agile, SCRUM etc.

ESB: IBM WebSphere, Tibco EMS

Operating Systems: Aix, HP Unix, Sco Unix, Linux, Windows

App Servers: WebLogic, IBM Websphere, Oracle Application Server

Object/Data Modeling: Eclipse, RUP, Rational ERWIN, Visio

Languages and Scripting: C++, C, Html, PL/Sql, T Sql, Unix Shells

Database(s) :Oracle, MySQL, Sybase, MS SQL Server, Unify, Focus, and MS Access

Database Tools: Informatica, SQL*Loader, Business Objects, Micro Strategy, & Toad

Education

National Institute of Information Technology, India

Post Graduate Diploma in Advanced Systems Management, 1993

Calcutta University, India

B.S. in Physics, Chemistry, & Mathematics, 1991

Contact this candidate