Exploring specific use cases and customer successes with informatica ilm
Download
1 / 13

Exploring Specific Use Cases and Customer Successes with Informatica ILM - PowerPoint PPT Presentation


  • 55 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Exploring Specific Use Cases and Customer Successes with Informatica ILM' - ila-rodriguez


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Exploring specific use cases and customer successes with informatica ilm

Exploring Specific Use Cases and Customer Successes with Informatica ILM

David Hermanski, Managing Director

Data Management Practice

SSG Limited ∙ Dallas, Texas


Exploring specific use cases and customer successes with informatica ilm

Agenda Informatica ILM

  • 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 Introduction & Overview Informatica ILM

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
Billing & Revenue Management Practice Informatica ILM

  • 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 Informatica ILM

  • 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
SSG Awards & Recognition Informatica ILM

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
Data Archive | Data Subset Use Case Informatica ILM

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 case1
Data Archive | Data Subset Use Case Informatica ILM

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
Application Retirement Use Case Informatica ILM

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
Data Subset | Divestiture Use Case Informatica ILM

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
Data Archive | Data Subset | Data Mask Informatica ILM

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
Questions and Discussion Informatica ILM

David Hermanski, Managing Director

Data Management Practice

SSG Limited ∙ Dallas, Texas

dhermanski@ssglimited.com