Download
exploring specific use cases and customer successes with informatica ilm n.
Skip this Video
Loading SlideShow in 5 Seconds..
Exploring Specific Use Cases and Customer Successes with Informatica ILM PowerPoint Presentation
Download Presentation
Exploring Specific Use Cases and Customer Successes with Informatica ILM

Exploring Specific Use Cases and Customer Successes with Informatica ILM

172 Vues Download Presentation
Télécharger la présentation

Exploring Specific Use Cases and Customer Successes with Informatica ILM

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Exploring Specific Use Cases and Customer Successes with Informatica ILM David Hermanski, Managing Director Data Management Practice SSG Limited ∙ Dallas, Texas

  2. 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

  3. 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.

  4. 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™

  5. 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.

  6. 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

  7. Use Cases and Customer Successes with Informatica ILM

  8. 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%

  9. 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

  10. 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

  11. 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

  12. 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)

  13. Questions and Discussion David Hermanski, Managing Director Data Management Practice SSG Limited ∙ Dallas, Texas dhermanski@ssglimited.com