Exploring Specific Use Cases and Customer Successes with Informatica ILM David Hermanski, Managing Director Data Management Practice SSG Limited ∙ Dallas, Texas
Agenda • Brief Introduction to SSG Limited Overview and Engagement Philosophy Billing & Revenue Management Practice Data Management Practice • Exploring Specific Use Cases with Informatica ILM Data Archive | Application Retirement Data Subset | Divestitures Data Privacy | Persistent & Dynamic Masking • Questions and Discussion
SSG Introduction & Overview SSG Limited is a software professional services firm committed to building long lasting, trust-based client relationships by leveraging our expertise and doing what we say we are going to do. • Founded in 1997, with offices in Dallas and Denver. • Solution “focus” around best-of-breed technologies in two primary practice areas: • Billing & Revenue Management Practice • Data Management Practice • Engagement Philosophy – Produce uncommon results for our clients with small “special forces” of very experienced SSG team members committed toiterativesuccesses.
Billing & Revenue Management Practice • Oracle Billing & Revenue Management (BRM) Practice • Oracle Premier BRM Partner • 14 years of experience in complex telecommunications billing environments implementing Oracle Communications BRM, a fully convergent, real-time enterprise revenue management application for Communications, Media and Cloud Service Providers. • SSG BRM Services • Deployment | Customization | Integration | Optimization | Upgrade | Migration | Support • SSG BRM Packaged Solutions • BRMmart™ | ExpirationSolver™ | BRMIntegrator™ | AccountArchiver™
Data Management Practice • Data Management Practice • Delivering expert Oracle DW/BI Project Consulting Services • Solutions Sales around the Informatica Platform and related Professional Services addressing Extended Enterprise Data Integration, Data Quality, Application ILM, Master Data Management and Cloud Data Integration.
SSG Awards & Recognition Our effort to do the right things the right way has earned SSG recognition and the respect of our partners, peers and employees. • 2011 Tech Titans Finalist (Metroplex Technology Business Council) • 2010, 2009, 2008 Dallas Business Journal “Best Places to Work“ • 2010 Dallas 100 Award (SMU Caruth Institute for Entrepreneurship) • 2009 Vistage CEO Annual Achievement Award • Oracle Gold Business Partner • Informatica Business Partner CEO Achievement
Data Archive | Data Subset Use Case Leading Provider of Digital Office Solutions and Innovative Document Management Systems, Software & Services KEY BUSINESS IMPERATIVE AND IT INITIATIVE • Increase operational efficiency by managing spiraling data growth • Reduce the cost of data storage • Ensure the company can respond to customer requests rapidly THE ILM CHALLENGE INFORMATICA SOLUTION BENEFITS • Spiralling data growth on Oracle E-Business Suite at 2 TB / year • With multiple database copies in non-production environments, total database size would reach 80 TB very quickly • Unacceptable application response times • Growing infrastructure cost • Growing inability to back up data • Addressed data growth challenge for both • production & non-production environments • Depth / Breadth of Application Accelerators and customize business rule extensibility • Reduced costs by $2M annually, equivalent to a complete ROI in only six months • Gained 18.8 TB of storage capacity (14 TB via Data Subset and 4.8 TB via Data Archive) • Reduced back up window by 40%
Data Archive | Data Subset Use Case Global Leader in Specialty Plastic Film Manufacturing and North America’s Largest Manufacturer of Residential Garage Doors KEY BUSINESS IMPERATIVE AND IT INITIATIVE • Reduce management, software, and hardware costs associated with Oracle data • Manage data growth arising from expanding Oracle E-Business Suite • deployment and business growth • Optimize performance of the application infrastructure THE ILM CHALLENGE INFORMATICA SOLUTION BENEFITS • Data across production, test and development environments growing • 4.5 TB / YR • Reliance on an on-demand model meant growth was costing business significantly more in storage and hardware costs • Address declining application performance • Provide seamless access to archived data from existing application interfaces • Reduce backup and recovery windows • Production database size maintained at 6 TB, a 50% reduction, yielding major savings in terms of primary storage and server costs • Payback within less than 1.5 years • Experienced 30% improvement in application performance • Provided staff with seamless access to archive • Ensured backup processes comfortably fit within backup window
Application Retirement Use Case Mega Merger Combining Two of the World’s Largest Research-Based Pharmaceutical Companies KEY BUSINESS IMPERATIVE AND IT INITIATIVE • Support an enormous Application Rationalization program across the new entity • Drive activities to support vast infrastructure cost reduction goals • Maintain access and manage retention of data from any decommissioned apps THE ILM CHALLENGE INFORMATICA SOLUTION BENEFITS • Provide standard and robust end-to-end support for retiring potentially thousands of applications • Desire to save $4B through merger integration programs in first 36 months, application retirement activity represented major contribution • Needed a solution to begin work within • 3 months • Maintain Business Objects access to any retired data • Enterprise Standard Solution for retiring up to 2,500 legacy applications • Retire 34 instances of JD Edwards from acquired company • Conducted two POCs over 4 week period • Optimized file archive with up to 98% data compression, providing access via Informatica Data Discovery Portal and Business Objects
Data Subset | Divestiture Use Case Multinational Supplier of Engineered Materials and Natural Resources fully divests a Performance Minerals Division in sale to a Private Equity Capital Fund KEY BUSINESS IMPERATIVE AND IT INITIATIVE • Support rapid and complete divestiture from parent company • Enable the new business to be operational more quickly and at reduced cost • Minimize the risk associated with divestiture strategy THE ILM CHALLENGE INFORMATICA SOLUTION BENEFITS • Automate an Informatica Data Subset solution to create a smaller (yet complete) targeted instance of the Oracle E-Business Suite from the complexity of the parent company’s heavily integrated Oracle data, with more than 600 custom tables • Bring speed and effectiveness to the process while meeting the needs of all stakeholders (regulatory authorities and shareholders, executives and staff of both entities) • In the final “production” run, fully divest the two companies over a weekend • Saved more than $1M in avoiding ERP • implementation costs, people costs, and • temporary hosting costs • Enabled divested business to launch an • effective operational Oracle E-Business Suite • six months more quickly than other divestiture • strategies – able to target, acquire and • support customers more quickly • Ensured all sensitive parent data deleted, Subset solution created divested Oracle EBS system within 24 hours
Data Archive | Data Subset | Data Mask Leading Provider of Comprehensive Onshore Energy Production Services KEY BUSINESS IMPERATIVE AND IT INITIATIVE • - Enterprise Wide Siebel Field Service and Billing Platform | DGA 310GB -> 400GB+ • - Adding many concurrent users w/Mobility Initiative (ticketing, inv. control, asset mgmt) • - Improve then Maintain Application Performance & Manageability | Seamless Access • - Enterprise Data Archiving Platform (Siebel first, the Oracle EBS and Legacy Systems) Global Medical Technology Discovery, Development and Manufacturing Company KEY BUSINESS IMPERATIVE AND IT INITIATIVE • - Fully divesting an international division (approximately 25% of the business) • - Customized Oracle EBS (US EMEA HR), custom Oracle OE, Fld Service & Ins. Billing Apps • - Support rapid divestiture, enable new ownership entity to be operational immediately • - Combine Data Subset and Data Masking to ensure absolute parent data privacy Leading Independent Worldwide Oil & Gas Exploration and Production Company KEY BUSINESS IMPERATIVE AND IT INITIATIVE • - Complex comprehensive Oracle EBS installation and federated EDW (OBIA and custom) • - Data Subset & PDM to reduce general data proliferation and support JV data needs • - Dynamic Data Masking requirement for production Oracle HR / HR Analytics (OBIEE)
Questions and Discussion David Hermanski, Managing Director Data Management Practice SSG Limited ∙ Dallas, Texas email@example.com