Enterprise Architect Data Analytics

Pranab Mukherjee

205-***-****(Cell); ****************@*******.***

Albany, NY

Information Management & Data Analytics Architect

Pranab is a technology leader and Enterprise Architect with over 20 years of experience delivering multiple mission-critical projects for global enterprises. He specializes in architecting systems for Customer Relationship Management (CRM), Data Governance, Master Data Management, and Product Information Management.

Pranab leads enterprise architecture teams and manages the entire IT delivery lifecycle in both the commercial and public sectors. He proposes effective technical solution architectures and has a proven track record of leading complex, multimillion-dollar transformation projects that achieve high-profit margins. As a change agent, Pranab is passionate about communicating the benefits of data and analytics to business customers. His management career is marked by dramatic turnarounds, showcasing his thought leadership and vision for guiding long-term change.

Areas of Expertise

Data Management / Governance Master Data Management Performance Management Organizational Design

Operational Efficiency Business Development Entrepreneurial Innovation AWS Cloud & Snowflake-DW

Agile Lean Six Sigma Methodology CRM-SFDC PIM(Product Information Management)

Scaled Agile Framework(SAFe) CI/CD Pipeline Digital Transformation

KEY ACCOMPLISHMENTS

He Managed/implemented all enterprise-wide data governance, data warehouse design, and reporting for a $22 million B.I. – Reporting Solution, which had 136 people working on the project at peak volume.

He Led the build/implementation of a B.I. Reporting suite on top of 95% of the Health Market Place. The primary performance table had over 80 million records requiring a deep understanding of query optimization for reporting and model development.

It has implemented transactional datastore/reporting for process and quality metrics within the Fixed Income business unit that is now expanded company-wide. Data/reporting is used for operations performance management, incentive programs, capacity planning, financial reporting/validation, and process improvement analytics.

Professional Experience

Wipro – Data & Analytics Consulting - NewYork October-2021 - Present

Currently working as a Information and Record Management(IRM) Business Solution Consultant in various compliance and Data Governance projects.

• Evaluate existing enterprise-wide IRM policies and procedures. Advise and educate on best-of-breed tool selection. Advise and educate on best practices for designing, documenting, and implementing records management. Advise and educate on best practices for information governance.

• From an IRM perspective, define the Customer Data retention requirements and communicate as part of the HITRUST certifications to all Best Buy Health stakeholders.

• Review and evaluate all existing systems for day-to-day operational activities, define new data topics, and update the retention code per the IRM policy document.

Deloitte – Govt. & Public Sector - NewYork July-2018 – October 2021

Worked as a Data Management / Governance lead architect in various state and federal government, I.E. (Integrated Eligibility) projects. Participated in Business Development lending expertise on MDM (Verato -

cloud identity platform) / Data Governance for several state government agencies.

N.Y. State – Information Technology Services November 2017- June 2018

Worked as a Sr. Data Management and Governance lead architect, evaluating statewide MDM(Oracle – UCM), CDM Cloud, and Data Governance capability. He led a statewide Data Governance and MDM Proof Of Concept on Citizen portal across different state agencies.

United Health Group(Optum Technology) March 2016 – November 2017

He worked as a Sr. MDM / DG Architect on an IBM InfoSphere MDM 11x project. Current responsibilities include but are not limited to initiating and providing CDM 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 (MDM and Data Governance)

He worked as a Sr. Solution Architect in a multi-domain (Payer and Provider) Informatica MDM project. Was responsible for advising Business Stakeholders on best-of-breed strategies and accountable 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 & I.T. Senior-level executives to drive affiliations and align value creation opportunities to successfully architect business and technology transformation engagements. His responsibilities cover the whole ownership of MDM delivery, starting with delivering a multiyear strategy roadmap, key stakeholder identification, data governance set up, and the implementation of the strategic roadmap.

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

Principal Architect, Business Consulting

Lead a $9M+ Data Management, MDM(Oracle-UCM), B.I. 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 D.C. 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 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 that emphasizes standards-based interoperability between COTS products and external data sources, including Federal Data Source Hub(FDSH), commercial issuers (using SERFF) legacy systems.

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

Computer Science Corporation – Colombia, MD 2011–2012

Principal, Master Data Management & B.I.

He managed the extensive engagement to deliver the 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 complete lifecycle management of solutions to realize the business case. As a client advisor, provide an engagement strategy, execution approach, risk mitigation, and governance for large MDM(IBM – initiate) projects.

Capgemini – New York, NY 2010–2011

Manager, Business Information Management

He devised an engagement strategy to realize the vision "One Dean Way" to produce and maintain common, global customer data(CDM). It 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 standard customer fields to OTC systems and prevents local users from overwriting global values.

It has improved the visibility of customer's performance across internal and external, finance, and distribution hierarchies.

It empowered a Customer Data Governance organization to make critical business decisions based on customer data.

It Increased the portability of customer records across OTC platforms.

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(Oracle-PDH) 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 and implementing a master Product Master.

It created a Business case that quantified the business benefit and impacts analysis and an enterprise-wide product master implementation strategy.

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

He Led projects as big as $12.5 with a team size of up to 39. The 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. He 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(IBM Product Master) 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 the delivery of third-party and historical-load subject areas and 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 the 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.

It identified and created charters for additional data governance and quality projects; D.Q. 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 by eliminating redundant processes; raised awareness of the client team on existing, broken D.Q. 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 B.I., / D.W. 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 B.I. Capabilities and to pursue shareholder value that met the client and customer goals. Interviewed stakeholders to gather and develop reporting and ETL requirements. He 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.

He 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 how Underwriting, Sales, Account Management, and Actuarial departments interacted and conducted Business. Performed data modeling and created the conceptual, logical, and physical data model using the 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 2001- 2002

Senior Consultant

The state of California, Department of Corrections 1999-2001

Design Consultant, Security Interface Design

Technical Expertise

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

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

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

ESB: IBM WebSphere, Tibco EMS

Operating Systems: Aix, H.P. 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 M.S. Access

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

Education

•P.G Diploma in Information Management – National Institute of Information Technology

•B.Sc. – Calcutta University, INDIA

Contact this candidate