Transcript Asdas asdasd asd asd asdasdasd asd asd asdsa ddas
Exploring Specific Use Cases and Customer Successes with Informatica ILM
David Hermanski, Managing Director Data Management Practice SSG Limited ∙ Dallas, Texas
Bridging the gap between vision and implementation™
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
Bridging the gap between vision and implementation™
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 to iterative successes.
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
Use Cases and Customer Successes with Informatica ILM
Bridging the gap between vision and implementation™
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
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
INFORMATICA SOLUTION BENEFITS
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
Data across production, test and development environments growing 4.5 TB / YR
INFORMATICA SOLUTION BENEFITS
Production database size maintained at 6 TB, a 50% reduction, yielding major savings in terms of primary storage and server costs Reliance on an on-demand model meant growth was costing business significantly more in storage and hardware costs Payback within less than 1.5 years Experienced 30% improvement in application performance Address declining application performance Provided staff with seamless access to archive Provide seamless access to archived data from existing application interfaces Ensured backup processes comfortably fit within backup window Reduce backup and recovery windows
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
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
INFORMATICA SOLUTION BENEFITS
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
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
INFORMATICA SOLUTION BENEFITS
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)