Digital Business Integration Manager Resume
SUMMARY:
- 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 including Data Architecture and Modeling (Relational and Dimensional), Data Profiling and Data Quality solutions.
- 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 20 years of experience managing, coaching and mentoring teams of up to 50 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.
- 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.
- 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, 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), 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.
- 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 training plans and training materials appropriate for different user communities.
- 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.
PROFESSIONAL EXPERIENCE:
Confidential
Digital Business Integration Manager
Responsibilities:
- Worked at a Confidential as a Development Lead for a data preparation tool Paxata to create datasets to be used by data visualization tool Tableau.
- Worked at a Confidential as an Informatica MDM Upgrade Design Lead managing a team of 10 off-shore resources to upgrade from Informatica MDM 9.5 to 10.2.
Confidential, New York, NY
MDM/ BI/DW SME and Lead Architect
Tools: Informatica MDM 10.0, IPC, IDQ, IMM, AWS EC2, AWS RDS, AWS Redshift, Tableau
Responsibilities:
- Working at a Confidential 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, 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.
- 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: SQL Server, SSIS, SSRS, SSAS, BIDS and Tableau
Responsibilities:
- Worked at a Confidential 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
Transition Manager and Lead
Tools: 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.
- 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: Informatica MDM, JBoss AS7, IPC, IDS, IDQ, IMM 9.5
Responsibilities:
- Worked at a Confidential 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: Informatica MDM, JBoss AS7, IPC, IDS, IDQ, IMM 9.5
Responsibilities:
- Worked at a Confidential 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: 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 business case to build a centrally maintained master data repository 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 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 is to be sourced from seven SAP SCM systems covering Confidential ’s seven businesses, an SAP SRM 7 and a cataloging tool named RAMIS (Resource and Asset Management Information System)
Confidential
Principal and Managing Consultant
Tools: Informatica MDM, IPC, IDS, IDQ 9.1
Responsibilities:
- Established a data governance team of stake holders from the source systems including Wealth Management for establishing and documenting data policy 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: 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: 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: 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 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: 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 Confidential, 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: 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. 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.
Confidential, Chicago, IL
MDM Architect and Lead
Tools: Siperian MRM XU, SAP SCM, IBM DataStage
Responsibilities:
- Led a team of 2 professionals to complete a Business Requirements Document (BRD) for creating Master Data Repositories for Materials, Suppliers and Sites sourcing data from multiple 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: 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 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 Confidential 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.