We provide IT Staff Augmentation Services!

Digital Business Integration Manager Resume

0/5 (Submit Your Rating)

New York, NY

SUMMARY:

  • MDM/BI/DW Solutions Architect: Over 25 years of Information Technology experience managing end - to-end, large-scale, full Software Development Life Cycle (SDLC) implementations of Business intelligence (BI/DW), Customer Data Integration (CDI), Master Data Management (MDM), Siebel Customer Relationship Management (CRM), Sales and Marketing and Clinical Trial Management System (CTMS) applications for Fortune 500 companies. Extensive skills in delivery of enterprise wide Data Management Programs, Data Architecture and Modeling, including Conceptual, Logical and Physical for Relational and Dimensional Data Models, Data Profiling and Data Quality solutions.
  • Project Management: My project management experience has mostly been with the Big-5 or Multinationals and in many cases using the Onshore-Offshore model. I have over 25 years of experience managing, coaching and mentoring teams of up to 30 cross functional professionals and I have used various Project Management methodologies such as Agile, Waterfall, Earned Value, etc. plus the ones followed by the Big-5.

TECHNICAL SKILLS:

Business Architecture: Utilize TOGAF and POLDAT Frameworks to create artifacts necessary to document enterprise architecture for alignment between organizational business processes and goals; IT applications, middleware and database systems. Organize Governance Teams of stakeholder representatives for establishing and documenting data policy and quality decisions across the enterprise; conduct Executive Level interviews to identify business drivers, vision and objectives; lead JAD sessions to gather requirements; document roadmap and objectives to develop traceability matrix; analyze and prioritize requirements; architect, design and develop technical solutions to fulfill an organization s need to optimize interactions with its customers and maximize the returns on its IT investments.

Technical Architecture: Manage the development and enhancement of technology infrastructures to analyze, optimize and support implementation of programs including performance tuning. Create sustained value for organizations by creating a global picture of enterprise IT architecture, business architecture and their interactions. Systems include HP, IBM, Sun and Wintel servers running AIX, HP-UX, SOLARIS, LINUX and Windows operating systems, JBoss AS7 application servers, DB2/RS6000, Oracle or SQL Server databases systems; Cognos, Tableau, BOXI, Netezza, OBIEE, Teradata and Amazon Redshift BI/DW platforms, Hadoop, Hadoop Distributed File Systems (HDFS), HBase, HQL, MapReduce, in the Big Data Area, SalesForce.Com (SFDC) and Siebel CRM Siebel UCM, Siperian XU, Informatica MDM Hub, ODI, Informatica Data Director (IDD), Informatica Data Controls (IDC), Services Integration Framework (SIF), Informatica Data Quality (IDQ), PIM, Informatica Metadata Manager (IMM), Address Doctor, SSIS, SSRS and SSAS platforms to create 360 degrees view of an organization s major data assets such as customers, products, etc.

Change Management: Establish change management teams, lead the development and implementation of detailed communications plans including communication flow matrix, communication content, media and processes; based upon the levels of stakeholders and their stages of readiness. Increase enterprise agility by documenting a current state to create a baseline for measuring the impacts of change on the business and IT architectures. Develop plans and materials appropriate for different user communities.

Domain Knowledge: Pharmaceutical, Medical Devices, Health Insurance, Financial Services including global regulatory mandates for Financial Services CCAR, Dodd-Frank, Basel, etc., Publishing, Energy, Transportation and Utilities industries. Effectively communicate and work with all levels of business executives to understand their strategic needs and present solutions demonstrating how technology can help them in gaining competitive advantage over competitors.

Representative Clients: Medco, Confidential & Confidential, HCS (Healthcare Software Solutions), Janssen Pharmaceutica, DePuy, Guidant, Novartis, Schering Plough, Abbott Labs, Amgen, USPS, Prudential Healthcare, Confidential, IBM, Clarke American Administrative Office of the Courts (AOC) - State of California, BP, Entergy and Ernst & Young, Confidential & Sons, Boehringer-Ingelheim, Confidential, Confidential, Confidential, Hartford Group, Confidential, Bristol Myers Squibb, Confidential, Maersk, Noven, Confidential, Merck.

PROFESSIONAL EXPERIENCE:

Confidential

Digital Business Integration Manager

Responsibilities:

  • Worked at a Global Life Sciences company, Bristol Myers Squibb, as a Development Lead for a data profiling and data preparation (ETL) tool Paxata to prepare Clinical Trial and HR datasets to be used by data visualization tool Tableau.
  • Worked at a Global Life Sciences company, Merck, as an Informatica MDM Upgrade Design Lead managing a team of 10 off-shore resources to upgrade from Informatica MDM, PC and IDQ 9.5 to 10.2 and migration of the application from on-premise to AWS and RDS.

Confidential, New York, NY

MDM/ BI/DW SME and Lead Architect

Tools: /Skills: Informatica MDM 10.0, IPC, IDQ, IMM, AWS EC2, AWS RDS, AWS Redshift, Tableau

Responsibilities:

  • Working at a luxury fitness company as a MDM/BI/DW SME and Architect leading a team of 12 cross-functional professionals to design, develop and implement an enterprise wide MDM/ BI/DW solution on Informatica MDM 10.0, IDQ 10.0, SQL Server, Teradata 2750 and Tableau platforms to provide a 360 degree view of its Customers from source systems including SFDC and other custom applications. My responsibilities included:
  • Forming a data governance team of stake holders from the source systems for establishing and documenting data policy and quality decisions across the enterprise.
  • Working with the Confidential lines of business, BLINKHEALTH, PUREYOGA, SPABIZ and SOULCYCLE to get their data integrated into the MDM solution.
  • Implementing the MDM application on JBoss AS7 hosted in Amazon Web Services (AWS) Elastic Cloud Computing (EC2) platform and Oracle hosted in Amazon’s Relational Database Services (RDS). This was done based upon the Platform As A Service (PaaS) Cloud Service Model.
  • Configuration of the Informatica MDM application on Version 9.7.1 and upgrading it to Version 10.0.
  • Configuration of the Informatica Data Director (IDD), Informatica Data Controls (IDC) and Services Integration Framework (SIF).
  • Leading a team of developers supporting an EDW consisting of SQL Server, SSIS, IDQ, IPC, IMM and Tableau Visual Analytics platforms

Confidential, New York, NY

BI/DW SME and Lead

Tools: /Skills: SQL Server, SSIS, SSRS, SSAS, BIDS and Tableau

Responsibilities:

  • Worked at a Global Pharmaceutical company as a BI/DW SME leading a team of 5 professionals supporting an EDW consisting of SQL Server, SSIS, BIDS and Tableau Visual Analytics platforms running on WebLogic 12c application server.

Confidential, Copenhagen, Denmark

Transition Manager and Lead

Tools: /Skills: Informatica MDM, JBoss AS7, SAP MDG, IPC, IDS, IMM

Responsibilities:

  • Worked as a Transition Champion to lead and manage the outsourcing of the Single Master Data Solution (SMDS) application consisting of a cross functional team of 25 professionals using the Onshore-Offshore model. The work involved comparing offshore vendors and negotiating with the selected one with the goal to transition the work from Copenhagen, Denmark to Trivandrum, India.
  • Worked as a Data Governance/Data Quality/MDM SME and Architect to design, develop and implement solutions to enhance and expand the SMDS on an Informatica MDM 9.5 on JBoss AS7, SAP MDG platform. The BI/DW reporting environment consists of Teradata with Informatica Data Quality (IDQ) 9.5, Informatica Metadata Manager (IMM), Informatica Data Services (IDS) 9.5, Informatica MDM and Address Doctor, Informatica PowerCenter (IPC) 9.5 using Push Down Optimization (PDO) and a SAP BOXI front end. The major subject areas are Customers, Vendors, etc.

Confidential, Parsippany, NJ

MDM/DQ SME and Lead Architect

Tools: /Skills: Informatica MDM, JBoss AS7, IPC, IDS, IDQ, IMM 9.5

Responsibilities:

  • Worked at a global pharmaceutical company as a MDM/DQ SME and Architect to establish a data governance team of stake holders from the source systems for establishing and documenting data policy and quality decisions across the enterprise.
  • Led a team of 6 professionals to design, develop and implement an enterprise wide DQ/MDM solution on a Informatica 9.5 platform consisting of Informatica Data Quality (IDQ) 9.5, Informatica PowerCenter (IPC) 9.5 and Informatica Data Services (IDS) 9.5, Informatica MDM on JBoss AS7, Informatica Metadata Manager (IMM), and Address Doctor to feed a Teradata Data Warehouse with a Tableau front end providing a 360 degree view of its Customers and Products.

Confidential, Princeton, NJ

MDM/DQ SME and Lead Architect

Tools: /Skills: Informatica MDM, JBoss AS7, IPC, IDS, IDQ, IMM 9.5

Responsibilities:

  • Worked at a global pharmaceutical company as a MDM/DQ SME and Architect to establish a data governance team of stake holders from the source systems for establishing and documenting data policy and quality decisions across the enterprise.
  • Led a team of 4 professionals to implement design, develop and implement an enterprise wide DQ/MDM solution on a Informatica 9.5 platform consisting of Informatica Data Quality (IDQ) 9.5, Informatica PowerCenter (IPC) 9.5 and Informatica Data Services (IDS) 9.5, Informatica MDM on JBoss AS7, Informatica Metadata Manager (IMM) and Address Doctor to feed a Teradata Data Warehouse with a Microstrategy front end providing a 360 degree view of its Customers and Products..

Confidential, Johannesburg, SA

Engagement Manager and Lead Architect

Tools: /Skills: SAP SCM MDG MDM, IBM DataStage

Responsibilities:

  • Worked as an Engagement Manager leading a team of 20 technical, functional and change management consultants.
  • Building a centrally maintained Master Data repository/PIM for Suppliers, Materials and Services including both Static (basic Supplier, Material and Service data attributes) and Dynamic (such as MRP related Min-Max and Reorder Levels for Materials.)
  • Assessment of existing SCM MDM strategy to enable efficient Supply Chain Management activities across company.
  • Established a data governance team of stake holders from the source systems for establishing and documenting data policy, processes and quality decisions across the enterprise.
  • Evaluation of as-is SCM MDM activities including adoption of such cataloging standards Materials and Services, such as eOTD, UNSPSC, GTIN, etc.
  • Establish remedial measures with respect to SCM MDM strategy, structure, process, data governance using SAP MDG and KPI to measure and track improvement
  • The data was to be sourced from seven SAP SCM and SRM systems covering Confidential ’s seven businesses and a cataloging tool named RAMIS (Resource and Asset Management Information System)

Confidential, Hartford, CT

MDM/DQ SME and Lead Architect

Tools: /Skills: Informatica MDM, IPC, IDS, IDQ 9.1

Responsibilities:

  • Established a data governance team of stake holders from 27 source systems and applications including Wealth Management for establishing and documenting data policies, processes and quality decisions across the enterprise.
  • Led a team of 15 professionals to architect and design an Informatica MDM Hub 9.1 based Customer Data Hub to implement a single repository of all aspects of its customer data providing a 360 degree view. The customer data was to be sourced from over 25 source systems using Informatica PowerExchange (IPE) 9.1, Informatica Data Quality (IDQ) 9.1, Informatica PowerCenter (IPC) 9.1 and Informatica Data Services (IDS) 9.1 for Data Virtualization.
  • The work included selection and negotiations with offshore vendors to put together a team of 12 cross functional professionals and managing them.

Confidential, Westport, CT

Solutions Architect and Lead

Tools: /Skills: Informatica MDM, IPC, IDS, IDQ 9.1, SDMX Data

Responsibilities:

  • Led a team of 4 professionals in the development of a proof-of-concept prototype to cleanse, standardize, compare and analyze national economic data in time-series form from Statistical Data and Metadata Exchange (SDMX) and other syndicated sources to find differences in data based upon predefined ranges and produce ad-hoc and canned reports using Global IDs to help their Wealth Management system.

Confidential, Andover, MA

MDM Architect and Lead

Tools: /Skills: Informatica MDM, ODI, IDS, IDQ 9.1, OBIEE

Responsibilities:

  • Established a data governance team of stake holders from the source systems for establishing and documenting data policy and quality decisions across the enterprise.
  • Led a team of 4 professionals to perform post implementation enhancements, troubleshooting and tuning of an Informatica MDM Hub 9.1 based Customer Master to provide a single global repository providing a comprehensive view of all the interactions with its customers.
  • Architected end to end solution for sourcing Customer data from Siebel, SFDC, PeopleSoft, SAP and D&B data sources using ODI, Informatica Data Quality (IDQ) 9.1 and Informatica PowerCenter (IPC) 9.1 and to feed the cleansed, consolidated and integrated Customer data to an OBIEE Data Warehouse with a Cognos front end.

Confidential, Hoboken, NJ

Managing Architect

Tools: /Skills: Informatica MDM, IPC, IDS, IDQ 9.1

Responsibilities:

  • Established a data governance team of stake holders from the source systems for establishing and documenting data policy and quality decisions across the enterprise.
  • Led and managed a team of 5 cross functional professionals based in Bangalore, India and Hoboken, NJ to implement an Informatica MDM Hub 9.1 based Customer Master using Informatica PowerCenter 9.1, Informatica PowerExchange 9.1 and Informatica Data Quality 9.1 running on JBoss application server. The major goal of the project was to create a single global customer repository and to track all its interactions with its customers using SFDC.

Confidential, Gaithersburg, MD

Solution Architect and Lead

Tools: /Skills: Informatica MDM, IPC 9.1, IDS, IDQ 9.1

Responsibilities:

  • Established a data governance team of stake holders from the source systems for establishing and documenting data policy and quality decisions across the enterprise.
  • Led a project team of 6 professionals to implement an Aggregate Spend solution and to integrate its Siperian MDM application with that of Astra Zeneca, Confidential ’s parent company. The ETL environment used IPC 9.1, Informatica PowerExchange 9.1 and Informatica Data Quality 9.1. The goal was to track total dollars spent for every prescriber.

Confidential, Ridgefield, CT

Solution Architect and Lead

Tools: /Skills: Siperian MRM XU, IBM DataStage

Responsibilities:

  • Lead a team of 4 professionals to support a Siperian MRM XU based Customer Master. The Customer Master sourced data from a SFDC and SAP Customer Master (CM) applications and other syndicated sources, such as IMS, Symphony Data, DDD, etc. and fed the consolidated and cleansed Customer data to a Cognos 8 Data Warehouse to track all of the organization’s interactions with its customers, both payers and prescribers. The work also involved extensive design and development in the reporting environment.

Abbott Labs, Chicago, IL

MDM Architect and Lead

Tools: /Skills: Siperian MRM XU, SAP SCM, IBM DataStage

Responsibilities:

  • Led a team of 5 professionals to complete a Business Requirements Document (BRD) for creating Master Data Repositories/PIM for Materials, Suppliers and Sites sourcing data from five SAP SCM applications. Developed a Proof of Concept (PoC) MDM application using Siperian MRM XU Release SP2 and BDD. The work involved analyzing, profiling and extracting data from five SAP SCM applications and complete configuration of the Siperian Hub and BDD running on JBoss application server. These Master Data Repositories were a source for a Cognos 8 BI reporting application and the work involved extensive architecting for the reporting environment.

Confidential, Piscataway, NJ

Project Manager/MDM/BI Architect

Tools: /Skills: Siperian MRM XT, Informatica 8.6.1 and Trillium 12

Responsibilities:

  • Selected and negotiated with offshore and onshore vendors to assemble a team of 30 cross functional professionals based in Calcutta, India and Piscataway, NJ and led them to support Siperian MDM and Cognos 8 based applications and planning for an upgrade. The applications covered Customer and Product subject areas. The environment consisted of Siperian MRM XT, Informatica 8.5.1 and Trillium 7.6 which will be upgraded to
  • Siperian MRM XU, Informatica 8.6.1 and Trillium 12. My responsibilities include working with the HCS Data Governance committee and the Data Stewards from each of the source applications to ensure that all the Data Governance guidelines, processes and procedure are being followed to maintain data quality and integrity in the MDM Hub.

Confidential, Houston, TX

Senior Managing Consultant

Responsibilities:

  • Used TOGAF and POLDAT EA Frameworks to provide leadership in developing and enhancing various artifacts to support the enterprise architecture documenting all the major business processes and the technology infrastructure to support them, including Data Center, Network, Application and Database towers. The goal of this approach was to optimize all the mission critical business processes at AOC and to ensure that the infrastructure and applications systems including SAP ERP, SAP BW, Cognos 8, Business Objects XI, Crystal Reports and Court Case Management Systems (CCMS) are capable of supporting them.
  • Leading strategic initiative to implement the latest generation of Court Case Management System (CCMS) to provide a common application platform for all 52 Superior Courts, replacing over a dozen applications currently in use and upgrade of the Data Center and Network infrastructures.
  • Performing the physical design of the Stress Testing and Product Acceptance Testing environments to host the latest generation of Court Case Management System (CCMS). These used the latest server virtualization technologies offered by Sun and Dell.
  • Leading the effort to enhance and streamline all the BI environments consisting of SAP BW, Business Objects XI and Cognos 8 to deliver a complete range of BI applications including Reporting, Analysis, Scorecards and Dashboards. The enhancements also included Dashboards for major KPIs and Real-Time SLA monitoring,

Confidential

VP

Responsibilities:

  • Led a team of 12 cross functional professionals in the implementation of a Customer Repository (Accounts and Surgeons) and Business Intelligence (BI/DW) applications. The Customer Repository, a Siperian MDM XU implementation, integrated data from their ERP and Medical applications and syndicated data sources, such as IMS, Symphony Data, DDD, etc.
  • Formed a governance team of stake holders from the franchises for establishing and documenting data policy and quality decisions across the enterprise.
  • Developed functional and technical requirements for the enterprise portal including requirements for the ESB

Confidential

Solution Architect

Responsibilities:

  • Led a team of 12 cross functional professionals in the implementation of Customer and Product Masters on a Siperian MDM XU platform, integrating data from 5 J&J Operating Companies and syndicated data sources, such as IMS, Symphony Data, DDD, etc.

We'd love your feedback!