Archives: Success Stories

BFSI Canada

The customer is the largest provider of personal and commercial insurance in Canada, including automobile, property and liability.

CHALLENGE

Managing data mappings for the enterprise data warehouse via MS Excel spreadsheets had become impossible as the data mapping rules changed across several releases. The customer was looking for a solution to automate data mappings and govern each phase of data integration to save time and reduce required resources.

SOLUTION

After evaluating many vendor tools in the space, the customer selected both erwin Mapping Manager and the erwin Automation Framework.

RESULTS

  • ROI achieved within the first 12 months
  • Accelerated mapping process via drag-and-drop feature
  • More work achieved in less time with fewer development resources

BFSI Australia

The customer is a multinational insurance company headquartered in Sydney, Australia. It is engaged in underwriting general insurance in territories within Australia, New Zealand and Asia.

CHALLENGE

Managing data warehouse mappings via MS Excel had become impossible to manage. The lack of a central repository for data dictionaries and managing codes and code set values in Excel spreadsheets added to the complexity and cost. It was difficult to see which data mappings and ETL jobs were impacted by monthly release cycles and what the changes were.

The customer wished to standardize code set management and enforce standards and best practices for reference data management to save time and money by building repeatable processes.

SOLUTION

By implementing erwin Mapping Manager, the customer was able to realize instant business value by maintaining all enterprise codes and reference data within a consolidated repository.

RESULTS

  • Considerable savings with standardized code sets and reference data
    management
  • Streamlined conversion between legacy and enterprise code sets
  • Code sets and code crosswalks control and management
  • Better governance, control and manageability of enterprise reference data
  • Improved data quality and trust

Health Insurance USA

A non-profit health insurance company that finances and delivers healthcare services across upstate New York and long-term care insurance nationwide. Collectively, the enterprise provides health insurance to nearly 1.5 million members.

CHALLENGE

The customer was using a CDMA product to centralize data mappings, but it lacked certain desired features like versioning, impact analysis and lineage. This led to increased costs, effort and delays.

The customer sought a solution to manage all data mappings across its data integration projects; track changes to mappings through the change and release management lifecycle; process and assess impact analysis; and view data lineage. The efforts were mainly aimed at achieving operational excellence and to reduce delivery time by 80 percent.

SOLUTION

erwin Mapping Manager enabled standardized the pre-ETL data mapping process. The technology is purpose-built to manage data integration mapping through the change and release process. As a result, both internal data mapping and cross functional teams now have easy web-based access to data mappings and valuable information like impact analysis and  lineage — saving time.

RESULTS

By implementing erwin Mapping Manager, the customer achieved operational excellence and delivery time reduction by 80%.

Humanitarian Australia

One of the world’s largest humanitarian organizations with millions of members and volunteers operating in more than 188 countries. It helps tens of millions of people around the world each year and cares for local communities in Australia and Asia Pacific.

CHALLENGE

The organization was dealing with confusion and complexity in data mapping across several releases, impacting source system changes. And its business definitions and data dictionaries across IT systems were not stored in a central repository.

The customer needed a solution to standardize the pre-ETL data mapping process to enable savings and to make the data integration process more efficient.

SOLUTION

The customer used erwin Mapping Manager to standardize the pre-ETL data mapping process. The purpose-built solution manages data integration mapping through the change and release process.

RESULTS

  • ROI achieved within the first 12 months
  • Time savings realized across all IT development and cross-functional testing teams, easily managing mappings, code sets, reference data and data validation rules
  • Data mappings easily created using drag-and-drop feature

Fidelity International

Southern California Edison

Southern California Edison (SCE) has delivered electricity to Southern and Central California for more than 125 years. SCE requires efficient operations and clearly defined processes in order to ensure compliance and keep essential services’ costs to a minimum.

CHALLENGE

SCE sought the support of erwin to address its process management challenges. Ryan Maddox, Process Improvement Manager, explains, “Utilities are complex organizations. None of our business functions operate in isolation, so we have a series of interconnected multi-step processes that need to work every time. These processes are all supported by multiple applications and software solutions, which means a problem in one area will almost certainly have a downstream effect in another. Our job is to make sure it all runs as smoothly as possible.”

SOLUTION

After evaluating various enterprise architecture enterprise architecture solutions, erwin stood out because it offered the right balance of cost and functionality.

RESULTS

  • Enabled major change initiatives
  • Reduced the stabilization period from three to six months to three weeks
  • Saved time and technical writing resources, paying for itself within a year

SSE

SSE plc supplies energy to more than 9.5 million customers throughout Great Britain and Ireland and is the United Kingdom’s leading generator of electricity from renewable sources.

CHALLENGE

SSE wanted to create a central repository for multiple stakeholders, produce business process definition documents across multiple work streams, and preserve a single version of the truth for future programs.

SOLUTION

SSE used erwin solutions to customize the meta model to capture its business and IT modeling artifacts into a shared environment. The company also created a business process definition template that substantially reduced the time required to produce a revised version or introduce a new business process.

RESULTS

  • Helped standardize the methodology used to capture concise business process maps and definitions, reducing the acceptance review time and improving quality
  • Created and modeled nearly 2,500 business process steps, resulting in the efficient production of more than 80 business process definition documents
  • Built comprehensive repository of all business process maps related to customer supply, including IT systems and interfaces

Balfour Beatty Construction

Balfour Beatty is the fourth largest construction management company in the United States with more than 2,500 employees and has won hundreds of awards for construction excellence.

CHALLENGE

To eliminate waste and inefficiency, Balfour Beatty wanted to transform its process documentation so employees had instant access to all company procedures from any location or device.

SOLUTION

Balfour Beatty chose to work with erwin on an ambitious program for process optimization, engaging erwin business process and operations specialists for a customized tool built on erwin business process solutions.

RESULTS

  • Reduced training for new recruits through consistently documenting processes and encouraging standardization
  • Expecting productivity improvements of approximately 5 percent

Royal Bank of Scotland

The RBS Group owns a wide variety of banking brands offering personal and business banking, private banking, insurance and corporate finance throughout Europe, North America and Asia.

CHALLENGE

After taking over another company, the Royal Bank of Scotland realized it needed to document its processes for training 4,000+ staff members and developing a sustainable employee knowledge repository.

SOLUTION

The bank turned to erwin to create a suite of 3-D flowcharts known as Online Process Diagrams (OPDs) that became the foundation for process management and continuous improvement initiatives.

RESULTS

  • Documented more than 5,000 processes
  • Eliminated paper manuals
  • Recognized for these efforts in many business competitions

Plymouth University

Plymouth University

Plymouth University is the 15th largest university in the United Kingdom with approximately 27,000 students and 3,000 employees.

CHALLENGE

The university’s enterprise architecture practice maintained all of its information in different assets, so tying it together was increasingly difficult.

SOLUTION

Using web-based erwin Evolve, Plymouth University established a central repository where all architecture assets can be stored, re-used and shared easily with stakeholders.

RESULTS

  • Established a centralized, web-based enterprise architecture repository
  • Proved the value of enterprise architecture to the business by eliminating costs and business/IT complexity
  • Adopted a collaborative approach to enterprise architecture management
  • Increased agility in producing reports and architectural analysis for senior decision- makers
  • Created closer alignment of overall business and IT strategy objectives