Informatica Data Integration

1. Informatica Data Integration Supporting Agency Systems Consolidation Brad Weisberg Srinivas Kosaraju

2. Realignment and consolidation of IT activities

3. Industry Consolidation is on the rise

4. A number of business priorities arise out of IT Consolidations • Minimize service disruptions • Ensure ongoing compliance • Consolidate core business functions (i.e. HR, Finance, IT) • Reduce operational costs • Integrate business processes • Minimize disruption for warfighter

5. IT’s Role in Merger Integration Large IT projects arise to support business requirements post M&A including: • Application rationalization and consolidation • ERP, Front office, back office • Data rationalization and consolidation • Single view of customer • Consolidated financial reporting • Master Data Management • Application integration • Integration of customer facing applications • Transactional platform integration • Partner and supply chain integration • Integrating to 3rd party networks • Consolidation and integration of SCM applications Company A Company B Application consolidation Data consolidation Supply chain integration Application integration New Company

6. IT challenges related to post merger integration • Organizational challenges: • Unrealistic timeframes set by the business • Business Process definition • Lack of insight into source systems • Technology and data management challenges: • Disparate systems and various data sources • Unpredictable data quality levels • Inconsistent definitions of data between companies • Lack of capable data integration technology

7. Mergers and Consolidation are not always successful Poor Strategy Bad Deal-Making Failed Integration • Approx. 36% • Approx. 47% • Approx. 7% Only 20% of firms have formal integration plans and execute them against specific targets and performance measures — This includes IT! * Source: CSC Analysis, London Business School, 2003.

8. Lack Of Trustworthy DataImpedes Key Business Imperatives Mergers Acquisitions & Divestitures Governance Risk Compliance Outsource Non-core Functions Acquire & Retain Customers Improve Efficiency & Reduce Costs Modernize Business Improve Decisions Cloud Computing Application Database Partner Data … NACHA HIPAA Unstructured SWIFT Increase Business Agility Increase Partner Network Efficiency Lack of relevant, trustworthy and timely data

9. The Informatica Platform Comprehensive Unified Open Economical

10. Post merger data integration activities Acquired Agency IT activities and projects Acquiring Agency Front office Application integration Front office Front office Front office • Real-time data transformation & synchronization Warfighter Data MDM Warfighter Data Single view of Warfighter • Access, cleanse, and identify unique warfighter records Financial Data Financial Data Data rationalization and consolidation • Access, cleanse, and define common terms and definitions Application consolidation and retirement ERP ERP • Migrate and deliver fit for use data, archive legacy data Networks Trading partner network integration Networks • Transformand conform to industry/corporate formats in real-time

11. Data integration is required to support IT initiatives Consultants Consultants Consultants Acquired Company Hand code IT initiatives and projects Acquiring Company Front office Application integration Front office Front office COBOL Front office • Real-time data transformation & synchronization Hand code • Costly to develop and maintain • Limited reusability • Takes too long • Error prone • Does not scale • Decreases IT’s value to the business Warfiughter Data MDM FTP Warighter Data Single view of the Warfighter • Access, cleanse, and identify unique customer records Hand code Financial Data Financial Data C++ Data rationalization and consolidation • Access, cleanse, and define common terms and definitions Hand code Application consolidation and retirement C++ ERP ERP • Migrate and deliver fit for use data, archive legacy data Networks Trading partner network integration EAI Networks FTP • Transformand conform to industry/corporate formats in real-time

12. Informatica for Application Integration Acquired Agency IT initiative Acquiring Agency Front office Application integration Front office Front office Front office Data Synchronization • Real-time application integration post merger between BNY and Mellon Financial • Deliver real-time data between asset management systems across both organizations to more than 30,000 clients via a unified portal • Accelerated merger between BNY and Mellon Financial Corp Asset Servicing domain

13. Informatica for Single View of the Warfighter Acquired Agency IT initiative Acquiring Agency Warfighter Data MDM Single view of Warfighter Front office Master Data Management • Single view of Customer across various acquired companies to increase effectiveness and ROI of sales and CRM marketing campaigns • Increased sales campaign effectiveness from 1% to 4% ROI • Reduce operational costs on legacy applications

14. Informatica for data rationalization and consolidation Acquired Agency IT Initiative Acquiring Agency Financial Data Financial Data Data rationalization and consolidation Data Consolidation • Integrated multi-billion dollar acquisition of UK’s RMC Group • Merged supply chains by standardizing and delayed differentiation • Migrated off JD Edwards and mainframe systems • Consolidated supply chain data into single SAP global instance

15. Informatica for application consolidation and retirement Acquired Agency IT Initiative Acquiring Agency Application consolidation and retirement ERP ERP CRM CRM Test Data Management & Archiving Data Migration • Facilitate and accelerate the migration of legacy mainframe data from three nuclear power plant acquisition to create an integrated, standardized multi-plant workflow and document management solution. • Reduced risk, expense of major data migration • Saved $250K by reducing IT project staff from 18 to 6 • Saved 25% migration time and achieved flexible data access

16. Informatica for B2B network integration Acquired Agency IT Initiative Acquiring Agency Networks Trading partner network integration Networks B2B Data Exchange

17. Informatica supports all of a company’s data integration needs post Systems Consolidation Consultants Consultants Consultants Informatica 9 Acquired Company Hand code IT initiatives and projects Acquiring Company Front office Application integration Front office Front office COBOL Front office Hand code Customer Data MDM FTP Customer Data Single view of the Warfighter Hand code Financial Data Financial Data C++ Data rationalization and consolidation Hand code B2B Data Exchange B2B Data Exchange C++ Test Data Management & Archiving Data Synchronization Data Synchronization Data Consolidation Data Migration/Consolidation Master Data Management ERP ERP Application consolidation and retirement Networks Trading partner network integration EAI Networks FTP

18. IT challenges from not having the right data integration technology CIO • Benefits of Informatica for Enterprise Data integration • Lower development costs • Faster time to market • Lower technology costs • Less errors • Increased business confidence in IT • Business has the information to support the warfighter. • Lack of alignment and support from business sponsors • Constant budget shortfalls • Unrealistic time tables set forth by business owners Director of IT • Constant project delays • Lack of consistency in development approaches • Poor employee morale Architects, Developers • Low productivity – too much time spend interpreting requirements vs. getting work done • Constant pressure from management to do more • Quality of work is sacrificed, low job satisfaction

19. Thank You Srinivas Kosaraju District Manager skosaraju@informatica.com 571 535 0473