Innovation Awards

Accelerating shareholder value in mergers and acquisitions category

Honeywell International - Winner
Honeywell's big problem was how to quickly and effectively weave new acquisitions into the business. The diverse geographic location of applications, business users, and IT support staff made it difficult for this Fortune 100 manufacturer of safety, security, and energy technologies to successfully manage integration projects and realize the benefits of its merger activity. The heart of the problem was a lack of a reusable data migration process, minimal collaboration between IT and the business data experts, and no clear process to report true project status―including relevant data quality metrics. The key to accomplishing more than 1,000 data migrations was to focus on a lean integration process, reusable components, and a built-in approach to process improvement. Standardizing on the Informatica Platform and a process tightly focused on management, people, process and technology, Honeywell now has a robust, lean, global data migration program, based on re-usable mappings, transformations, and data quality scorecards. The benefits are the speed and ease with which Honeywell can now integrate data post-acquisition. The business data experts are actively involved in the day to day audit and validation of the data, eliminating the type of finger pointing and blaming so common in poorly managed migrations. Each phase of the migration also represents significant time and cost savings. However the most important metrics focus on the quality of the data. By implementing the new standards, methodologies, and tools, Honeywell's data quality target for initial load to development went from 35% to 80%, and for test from 85% to 95%. This results is faster time to production, and significantly, huge improvements in user buy-in and acceptance.

Finalists in this category:
Santander Brasil with Informatica Professional Services
Saxon Bank

Delivering trusted information to drive data governance, compliance and reduce risk category

Bank Julius Baer & Co Ltd Singapore Branch – Winner (Tied)
Compliance has been getting the limelight these last few years. For large financial institutions, such as Bank Julius Baer which has a presence of more than 40 locations worldwide, compliance is one key area to good corporate governance. However, the increasing depth of compliance checks required in private banking led this Swiss banking firm to adopt more and more manual compliance processes. There was a need for an automated, easy to use solution to help its compliance officers and relationship managers identify names and whether they were possibly linked to internal and external bank 'black-lists'. A high-precision, high-volume Informatica Identity Resolution solution provides the Bank with a two-step search and match process which (i) enable users in the bank to perform adhoc checks for any name against such black-lists and (ii) enable the bank to perform automatic periodic checks. The Informatica Identity Resolution solution allows for variations in spellings, language, common use of nick-names, aliases, or abbreviated names. The solution provides the Bank with an integrated and enterprise-wide view of risk and compliance. In addition, the introduction of internal searches means the bank can maintain confidentiality by not depending upon external online solutions.

D&B with Cognizant – Winner (Tied)
Trusted data was a distant dream for D&B. Why? Because individual geographies and lines of business (LoBs) within this leading business information and insight provider each had their own data integration infrastructure. This made it challenging to enforce process compliance and adherence to standards and best practices across 25 fragmented application teams. Second, existing production applications experienced performance and data quality issues and did not meet agreed SLAs. This in turn impacted D&B's revenue and customer penetration. And because it was so difficult to add new applications and maintain the existing infrastructure there was a correspondingly high time-to-market and costs for new products. To foster a strategic approach to governance and compliance―and deliver trusted data―D&B established a data integration Center of Excellence (CoE). The CoE manages all informatica development in a shared, reusable grid environment, supporting all LoBs. Best practice measures include scorecards to track process improvements, resource savings, and revenue generation; a data integration reference guide to act as a reference point for standards and recommendations; and a STAR (Standards Adherence Rating) report to ensure universal adherence of standards and compliance. Achieving 100% core hours availability in 2009, the CoE has helped D&B's SBRI (Small Business Risk Insight) LoB deliver revenue growth of 113% between 2007 and 2009. Performance enhancements for improving process management and for accommodating growth were achieved on schedule―they include 2,100 hours saved per year in data quality support; 3,700 hours saved per year in process automation; 17,860 hours saved per year in process improvements; and $13,380 saved per year in DASD costs. D&B's integration partner, Cognizant, employed several solution accelerators to reduce the total efforts in solution development and maintenance. An automated integration code quality engine reduced development effort by 10%, a mapping developer reduced impact analysis by 10%, and a data quality assessment tool reduced support tickets generated by 40%.

Finalists in this category:
BBVA Compass with Crowe Horwath
Johnson and Johnson Healthcare Systems

Driving operational excellence by outsourcing noncore functions, modernizing the business, or reducing IT costs category

HealthNow New York - Winner
HealthNow New York was suffering from a data integration nightmare: crucial customer and product data needed for pricing and risk analysis was spread across 16 enterprise databases and over 30,000 access databases. It was no way to run a cost-efficient, agile New York healthcare company. In its place, HealthNow New York required a solution that would speed up time-to-delivery of data, enable better business involvement for claims processing, minimize the impact of change, lower operational costs, and decrease complexity. Creating custom data marts, connecting legacy stores individually, and maintaining integrations by hand simply would not work any longer—the process was simply too painful. With the Informatica Platform, HealthNow has been able to address its key integration goal for 2010: providing a single, reusable framework using enterprise data services for the business-wide data access and management of healthcare data. It used to take HealthNow 1,700 man hours to add a new product to the portfolio. With IDS, HealthNow can build a domain model (e.g. CLAIMS) so that the application layer can access data through data services. With IDS, instead of taking weeks to get a new data feed ready it can be done in hours. Altogether, HealthNow has decreased the time of delivery of business pertinent data by up to 5x or more and reduced the cost associated with maintaining data feeds by up to 3x or more. Equally, the business used to go to 5 different places to get claims information. With IDS, HealthNow can have a data service for data feeds such as "paid claims" and "pending claims" and business users only have to go to one place though a Web-based tool to get this data. That data integration nightmare has turned into a vision of operational excellence.

Finalists in this category:
AstraZeneca
Deutsche Asset Management Company with Wipro
ICICI Prudential Life Insurance Company

Enabling better decision making by driving business intelligence category

VIVO with Teradata - Winner
Formed from the merger of 6 different companies, each with its own data warehouses and different data sources, business rules, processes, tools, cultures and platforms, VIVO struggled to obtain strategic information for management decision making. In response, Brazil's largest mobile telecommunications company, with more than 54 million customers, created a unified business intelligence solution, comprising Informatica, Teradata, and MicroStrategy. It resulted in an enterprise data warehouse with 100Tb and 2,5 billion registers loaded per day. By unifying concepts, business rules and processes, VIVO can now take advantage of comparative analysis between regions and a global view of KPIs. This large-scale, innovative project involved nearly 40 business areas―ranging from Business Intelligence, Marketing and Sales, to Customer Care, Billing, and Call Centers. By standardizing on the Informatica Platform, VIVO's single version of the truth has reduced costs and increased revenue while accelerating trusted, accurate decision-making. Now, for example, sales reports are sent six times daily by SMS to the sales force with sales indicators comparing partials of sales during the day with goals defined to each location. The result? More agile sales performance. The EDW has billions of call data records and billing information for detailed analysis on real traffic versus billed traffic―which means reduced billing issues. And a customer segmentation model, providing teams with an integrated customer view to differentiate offers and customer service. More efficient predictive churn models allow actions to avoid customer defection and to increase customer satisfaction. This business intelligence strategy has translated into bottom line savings: reduction in bad debts (reduction in write-offs by US $13M in a year and 24% reduction in intentional default; the identification of 1 million inactive lines has reduced tax payments by $15 million per year; ther has been a 20% reduction in network operation maintenance; and enhanced direct marketing processes have cut operational cost by $1.2 million per year. Simultaneously, VIVO has increased revenue via better targeted direct marketing campaigns by $40 million annually and reduced time to market by 75%.

Finalists in this category:
AstraZeneca
Cabela's with Teradata
HealthNow New York

Improving customer information to enhance customer service or increase customer revenue category

Merrill Lynch with Informatica Professional Services - Winner
The overall objective of Merrill Lynch's MDM implementation, dubbed the 'Client Experience Data Program' (CEDP), was to leverage aggregated client knowledge to improve client satisfaction and business operations. To do so, the Global Wealth Management (GWM) team needed to provide decision-makers with a 360-degree view of client relationships and product information. With these insights, the company could fully leverage the investments various lines of business had made in client data operational environments and infrastructure, while presenting a consistent and compelling GWM brand across all client touch points. Using Informatica MDM, the firm's 16,000 advisors will be enabled through a single interface, access real-time client data stored at virtually any location in the enterprise. As a result, informed, fact-based decisions can be made in far shorter timeframes, and institutional knowledge and information resources can be leveraged to address client needs and improve account services.

Finalists in this category:
Johnson and Johnson Healthcare Systems
Station Casinos with Informatica Professional Services

Strengthening partner network efficiency category

Insurance Company and Third Party Vendor - Winner
First, this Insurance Company wanted its business analysts to be able to create the reports (feeds) that the insurance provider's distributors needed to effectively sell its products. Proprietary feeds were expensive to generate and maintain over the long term, and the standard tactical approach was inefficient and costly. The company deployed Informatica B2B Data Exchange to create, manage, and monitor the feeds going to their distributors. The innovation came in the user interface created specifically for the business analysts, making it easy for them to tailor the reports to the needs of each distributor. Critical features of B2B Data Exchange included pre-built transformations for ACORD XML support including (Large XSD, Large XMLs, complex features), interoperability with other standards, optimized performance, and the management of large data sets. This initiative involved a strong cross-functional partnership between the business and IT teams.

Second, The Insurance Company also had an existing working process that it wanted to improve and streamline. The company's affiliates distribute its insurance products, including variable annuities, through third-party distribution firms. After the day's transactions, one of these firms sends the transactional data through ACORD XML files which are then processed and sent to the downstream mainframe systems as COBOL flat files. The downstream systems, which are critical enterprise applications, check the financial transactions before processing to help ensure that compliance and financial reconciliation requirements are satisfied. Prompt availability of the output to the downstream systems assists the company in meeting audit and regulatory requirements. Working closely with a third party vendor, the company used Informatica B2B Data Transformation and Informatica Power Center. The initial installation cost of the solution was offset by the quick time-to-market, as well as reductions in complexity and development, maintenance and enhancement costs. The Serializer component of the Informatica B2B Data Transformation (DT) was used to parse the huge ACORD XML data-files and produce the desired output COBOL file. While the DT program has its own engine to run, it cannot be automated, which was done using Informatica PowerCenter. The DT program was deployed as a Service, and Informatica PowerCenter called this service through DX Transformation UDO (Unstructured Data Object). UNIX Shell Scripts were scheduled to initiate these Informatica PowerCenter jobs. It was necessary to handle the complex parent-child relationships of insurance policy to financial activity types to various fund sections through a robust and scalable solution that would help ensure that any change in logic can be implemented easily, without much impact on code and effort.

Finalists in this category:
Wells Fargo with Informatica Professional Services

Fortifying overall operations with global data quality category

U.S. Xpress Enterprises - Winner
U.S. Xpress is bringing innovation to the transportation business. One of the organization's top priorities was to accelerate decisions by addressing weaknesses in the business intelligence platform—everything from the lack of integration across platforms and data modernization, to gaps in the enterprise data warehouse and business intelligence tools. More challenging, there was no corporate wide data quality strategy in place, leaving data in disarray and at times making it difficult to respond to business inquiries. U.S. Xpress implemented Informatica Data Quality in 4 ½ months with a team previously unfamiliar with Informatica to standardize data across 7,000 trucks and increase the accuracy and reliability of data. Fuel cost reduction was an early victory. In the past, U.S. Xpress couldn't accurately assess how much drivers were idling. In weeks, U.S. Xpress dramatically reduced idle time—ultimately saving the company $6 million. It was a milestone toward gaining business credibility. With the business now empowered to participate in data quality, business analysts and data stewards can see, influence, and react to the impact of data quality on their applications and processes. Informatica Data Quality is used to standardize address components relating to 9,200 trucks, such as common abbreviations, common formats, and consistent usage across records. Simultaneously, the technology saved $1.2 million using data profiling to enhance truck maintenance system data quality and it is anticipated that a new enterprise data warehouse may save between $9 million and $20 million over two years. Topping the fact that U.S. Xpress has a comprehensive, accurate picture of the content, quality, and structure of its enterprise data is the fact that the company received a total return on investment in only three months.

Finalists in this category:
Bank Julius Baer & Co Ltd Singapore Branch
Foster's Group

Cloud computing category

Toshiba America Business Solutions - Winner
It all looked good. Toshiba America Business Solutions (TABS) had implemented a successful Salesforce CRM system, giving sales teams the information they needed to sell the company's copiers, facsimiles and other office equipment solutions. However, TABS needed to integrate multiple back-end systems, including after-sales service and leasing information. Up to 80% of the business products TABS sells are leased, so it was vital to provide its sales teams with this unified view of customer lease information. That's when it turned sour. TABS' Strategic Business Planning Project Manager approached the IT team to facilitate the integration of these vital back-end systems with Salesforce CRM, but they were too busy to do it―and that meant a delay of several months for any integration, with the subsequent loss of competitiveness. So the non-technical business team did it themselves. Using Informatica Cloud Services, they achieved three quarters of the Salesforce CRM integration in one day, which would have taken up to 160 hours using an on-premise integration appliance solution (Cast Iron), plus an additional week for training. This approach has turned a relatively reactive sales force into a highly responsive, proactive team. Previously, there were multiple manual processes involved in selling copiers and printers—cross-referencing after-sales service and leasing details. By enabling non-technical business users to deliver a vital data integration capability, TABS's sales teams now benefit from an up-to-the-second view of after-sales service and leasing information. Certain sales processes that used to take a week or more to complete, such as opportunity management, are now all available quickly and in a shared environment. Moreover, the whole company benefits from universal, secure data access. Informatica Cloud Services has dramatically changed the way TABS does business: improving efficiency, reducing costs, accelerating decision making, and supporting the acquisition and retention of customers.

Finalists in this category:
Telegraph Media Group Limited
TransUnion

Accelerating shareholder value in mergers and acquisitions category

Santander Brasil with Informatica Professional Services
Banco Santander Brazil's acquisition of Banco Real was the biggest acquisition in the bank's history and the largest ever in Brazil; however it required the rapid consolidation of the Banco Real legacy trading application into Santander's bank trade system. With little knowledge about the data structures and business rules associated with the target application, the team needed an approach that would move the data and provide the necessary data quality checking, without the need to reverse engineer the entire database layer in order to discover data load requirements. The integration approach also needed to be sufficiently agile to respond to the types of change requirements that happen in a large post-acquisition data integration project. Engaging with Informatica Professional Services (IPS), Banco Santander Brazil deployed the Informatica Platform and adopted an inspired, innovative approach to the post-acquisition data integration strategy. Completed 50% more quickly and at 35% lower cost than the bank anticipated, the agile approach supported the process needs to ensure that the software was used to its fullest potential for change requests, error handling, data quality issue resolution, and data audit. The team was also able to respond to multiple business changes requests in an agile fashion. The result for Banco Santander Brazil of this solution has been a rapid realization on the synergies of the merger, a higher rate of success, and a reusable IT infrastructure to support subsequent mergers and acquisitions.

Saxon Mortgage
In the punishingly competitive mortgage market, winners are judged by their agility and efficiency. Just ask Saxon Mortgage. When this mortgage servicing company became part of Morgan Stanley, it took the strategic decision to convert from a single servicing platform to two separate loan servicing platforms. And that required the development of a unified operational data store, an applications layer database, and a new reporting environment. Saxon Mortgage's management team anticipated that this integration program would take 18 months―but they underestimated the power of the Informatica Platform. Saxon Mortgage was in fact able to complete the integration in only four months―allowing the organization to more quickly access, integrate, and trust its information assets, increase operational efficiency, better manage risk, and grow revenue in a competitive and volatile economic climate. The Informatica Platform was used to map more than 1,100 mappings, from multiple sources, in four months to load six different databases. One of the toughest challenges was to create manual copybooks to read the VSAM data, as these had been missing originally. A mapping was created with the Informatica Platform to dynamically create the copybooks, read an Excel spreadsheet, and dynamically names each copybook. It allowed Saxon Mortgage to build out the entire bulk data extract load in two weeks―run the first time with zero errors. Reflecting its seamless scalability, the Informatica Platform has grown from an application running 50 mappings per night to a mission critical system performing every aspect of data integration for the firm's mortgage environment. Saxon Mortgage now runs more than 2,000 mappings per night in a six hour window. Shareholder value has rarely looked so good.

Delivering trusted information to drive data governance, compliance and reduce risk category

BBVA Compass with Crowe Horwath
To enhance internal controls and governance technologies and improve efficiencies in complying with U.S. regulatory anti-money laundering requirements, BBVA Compass made the decision to replace its legacy anti-money laundering system, where data required for compliance and anti-money laundering controls resided in multiple disconnected systems, formats, and structures. One of the first decisions taken by the 15th largest U.S. commercial bank was to seek a more sophisticated solution that offered broader coverage: a data integration solution that was flexible and scalable to meet not only current but future regulatory compliance needs. By standardizing on the Informatica Platform, Crowe Horwath LLP (one of the largest public accounting and consulting firms in the United States) helped BBVA Compass integrate data from multiple source system interface points into its new Oracle Mantas Anti-Money Laundering system, including data about loans, credit cards, and deposits, plus on-line banking transactions. Connecting financial information regardless of source, type, volume, or geography, Informatica technology has helped the bank to better monitor customer transactions daily, using historical information and account profiles to furnish a holistic view of these transactions and related activities. This monitoring allows BBVA Compass to detect, investigate, and report suspected money laundering activity and comply with current regulations more efficiently and effectively, in addition to providing a framework designed to accommodate future regulatory changes. It has improved resource management, too, by isolating unusual behavior and reducing the amount of false hits, thereby freeing up more time to review the quality alerts. Overall, the solution provides key stakeholders in the bank with a comprehensive view of financial activity and customer risk to transparently detect and investigate potential money laundering behavior.

Johnson and Johnson Healthcare Systems
How does an organization improve compliance with federal regulations, where failure to comply can result in damage to one's brand image, stiff civil penalties, or even criminal charges? How does it drive towards the 'perfect end-to-end commercial experience' when the three key process processes it relies on―account management, contract management and order-to-cash―have different data requirements? Just ask Johnson & Johnson Health Care Systems (JJHCS). This leading health care manufacturer deployed Informatica MDM to develop five distinct core masters across the enterprise that are used by 14 operating companies across multiple regions. By creating these core masters, raw data is transformed into consistent master data and delivered to all downstream systems for use across the JJHCS application landscape. This allows consistent transaction data to be fed to data warehouses and data marts that supply enterprise-wide compliance and sales management applications. To ensure success, JJHCS created a global data governance organization comprised of representatives from both business and IT which is responsible for overall governance, stewardship and communications. It has well defined processes to manage shared data through the established Global Data Governance Process utilizing information as an enterprise asset. Serving 350,000 customers and covering 300,000 products, the MDM strategy has helped JJHCS to deliver millions of dollars in benefits. The firm is able to process payments, rebates, and disputes more accurately; it can better comply with regulations requiring controls over data; and it is increasing customer service levels through error prevention, timely payments, and an enhanced end-to-end experience. Moreover operating companies are able to adapt faster to changing market requirements such as introduction of new products, sourcing of new customers, and negotiating new contracts. JJHCS is also steadily moving to that perfect order, where the quality of master data is 100% clean, all sales systems are updated during each order, and duplicate product codes no longer exist.

Driving operational excellence by outsourcing noncore functions, modernizing the business, or reducing IT costs category

AstraZeneca
Data has become the currency of choice at AstraZeneca. And the extent to which this global biopharmaceutical company can find it, use it, and trust it is key to thriving in the face of macroeconomic conditions and competitive biopharmaceutical market threats. Industry regulators are increasing their scrutiny to ensure drug safety and legislation compliance. Shareholders are looking for a faster and faster return on investment from an industry that typically takes 12 years to bring a new drug to market—and another 10 to recover the investment. And drug patent licenses are fast expiring, opening the prescription medicines market to copycat competitors and diminishing the income for the drug originators. These are some of the challenges that AstraZeneca faces today, and the company is increasingly looking to technology to address these issues and gain a competitive advantage. By standardizing on the Informatica Platform, AstraZeneca is driving operational excellence through reduced complexity, collaboration, and the efficiency needed to maximize investment in R&D. AstraZeneca is creating a strong pipeline of drugs that delivers value for patients and payers. And the company is able to collaborate with partners more easily to reduce risk and increase the likelihood of drug success. The Informatica Platform is helping to reduce the time required to bring new drugs to market from 12 years to 8; it has saved $2 million in AstraZeneca's Asia Pacific operations by unifying business intelligence—adding as much as 2% to the company's market share there; and it's reduced reporting time in sales and marketing from 27 hours to 2 minutes. Data quality is being transformed too—improving operational efficiency, productivity, and reducing risk—while the company is now better equipped to adapt processes to changing conditions, maximizing financial performance.

Deutsche Asset Management Company with Wipro
The Deutsche Asset Management (DeAM) Securities 'Golden Copy Program' was conceived to create a single version of the truth―a golden copy of master data elements, including Securities, Accounts, and Counterparties, across the global organization which would deliver operational excellence. Previously, this asset management division of Deutsche Bank had multiple data sources spread across geographies, resulting in ambiguity and redundancy; while reference/master data was being managed by disparate operations teams using a manual customization model. To compound the situation, there was no common data exchange/messaging format across DeAM's upstream and downstream applications. The first phase of this innovative Informatica Platform implementation has been to consume data from the internal data authorities/sources and centralize instrument data within the DeAM ecosystem. Plans are also in place to third-party data from issuers, brokers, and counterparties to make this a robust, true multi-domain MDM implementation. The next phase is to consume data from market data providers like Bloomberg directly into the hub. This 'always-on' securities reference data management hub will ultimately manage all the securities/instruments from across DeAM's geographies and provide a consistent single version of truth to all the upstream and downstream applications (there is a target 50% reduction in data management effort). There will be improvements with respect to turn around time and accuracy within trading applications that play a crucial role in straight through processing, by simplifying and centralizing the security/instrument set up and management. Centralizing data procured from industry data providers will eliminate redundant data and save on integration costs. Meanwhile, a unified MDM process will streamline operational activities and thereby increase efficiency and accuracy. Overall, DeAM anticipates a 100% ROI over four years by means of cost reduction, cost avoidance, and risk reduction.

ICICI Prudential Life Insurance Company
If you were to compare the ICICI Prudential Life Insurance Company's IT architectural landscape to a city's architecture, then Informatica would be taking care of the transportation system. Reflecting 6 years of innovation and operational excellence with Informatica, the Indian insurance company has standardized on the Informatica Platform, steadily re-engineering its information and integration architecture to address its enterprise-wide data requirements―most recently to extend the use of Web Services as an SOA platform for real time data consumption by satellite systems (Web Services now process 20,000 transactions per hour, with 1,000 concurrent users). ICICI Prudential's key data integration goals for 2010 were to expand the SOA landscape and optimize the data integration framework through the implementation of a service bus, hubs, and components. This would help tackle the problems that had dominated information management for so long: the inefficient mesh architecture, problems with data integrity, inconsistency in information flows, and the lack of a standardized protocol for application interactions. By implementing the Informatica Platform for Web Services, ICICI Prudential is addressing goals such as cost reduction in IT systems development and maintenance, increased productivity (with reduced maintenance and development efforts resource allocation comes down), and improved customer service engagement through profile-based up-sell and cross-sell. Simultaneously, ICICI Prudential's customer and agency servicing applications can now obtain data in real-time from a centralized source, enabling uniform information availability through all possible service channels―adding immense value to the service quality. The target applications no longer need to store high volumes of data obtained from the source systems, reducing infrastructure and resource costs. And ICICI Prudential now has high control over data validity, reducing the risk of data manipulation by maintaining a single system holding data for application integration.

Enabling better decision making by driving business intelligence category

AstraZeneca
Within the AstraZeneca organization, it's referred to as 'Project Amazon'. Not because it's the world's longest data integration project, meandering like a river, but because the project will simplify the company's architecture and rationalize applications. This global, innovation-driven, integrated biopharmaceutical company recently had 65 different information management strategies―including 19 different, overlapping business intelligence solutions. Project Amazon will distill these 65 information management instances into 1, with the Informatica Platform the standard for data integration and business intelligence. The ripple effect of the Informatica Platform is being felt throughout AstraZeneca, with the technology enabling faster, more accurate decision making. During the drug discovery (or early development) phase, for example, Informatica technology supports predictive analysis and modeling, integrating complex data from multiple sources and systems, and helping AstraZeneca to more quickly determine the outcome of a clinical trial. The result is that the company can bring drugs to market faster: it used to take 12 years to bring a new drug to market, but AstraZeneca has reduced this to about 8 years. Business intelligence is crucial here, putting accurate, timely clinical trials and other data in the hands of the decision makers more quickly. Of course, advancing the drug launch by four years also gives AstraZeneca an extra four years protected patency on the drug—and that translates into greatly increased revenue. This innovative business intelligence solution—consisting of Informatica PowerCenter, Informatica PowerExchange, Informatica Data Quality, and Informatica Master Data Management—has already saved $2 million in AstraZeneca's Asia Pacific operations and added at least 2% to its market share there. Reducing reporting time in sales and marketing from 27 hours to 2 minutes also allows decisions almost in real time―enabling the company to quickly adapt processes to changing conditions, maximizing financial and operational performance.

Cabela's with Teradata
To grow its specialty retail business, Cabela's realized the need to go beyond its catalog business to focus on eCommerce and improve its in-store customer experience. Working with Informatica and Teradata to turn raw information into insight, Cabela's created a single version of all customer, sales, product, marketing, and inventory data. Cabela's analysts were now free to work on data analytics―instead of data management. This information framework has also provided insights for decision makers to assist them with complex enterprise-level decisions. Analytics have given Cabela's many wins in Marketing, Merchandising, Inventory, eCommerce and Retail Operations. For example, better segmentation of the customer base has lifted master catalog distribution by approximately 2%―while the percentages may seem small, 2% on a $2.5 billion company is significant. Elsewhere, Cabela's was able to evaluate the products contained within its fliers and adjust the method of delivery for the flier, such as direct mail vs. insertion into newspapers, based on improved business intelligence. From this, Cabela's saw a 60% gain in the effectiveness of retail fliers through ROI, turning the initiative from a money loser to a money maker. Improved multi-channel sales data has also allowed Cabela's to perform product affinity analysis to determine what products are purchased together. This led to a 300% gain in eCommerce add-on sales. Using a blend of data from product and sales subject areas within the EDW, Cabela's is also able to determine which products drive the most sales and profitability, ensuring that proper product inventory levels are maintained based on seasonal demand. And advanced analytics―including demographic and economic data―are being used to make retail site selections as well as suggest proper sizing of stores.

HealthNow New York
In the same way its patients need fast, accurate medical diagnosis, HealthNow New York needs instant, trusted information at its fingertips to provide outstanding health care. Not easy when the leading New York State health care company had data spread across 16 enterprise databases and over 30,000 access databases, without any unified definition of attributes or entities. Challenged to speed up time-to-delivery of data, enable better business involvement for claims processing, and cut operational costs, HealthNow turned to Informatica. A model-driven data services development strategy fits seamlessly with HealthNow's SOA program, enabling the company to leverage existing skills and resources, and expose trusted information without having to understand all the underlying data sources and their complexity. This rapid, reliable provisioning of data has enabled HealthNow to cut the time needed to launch a new product to the portfolio from 1,700 man hours to hours. The single version of the truth also enables HealthNow's business sponsors to be more proactive. Previously, the business had to go to 5 different places to get claims information; with Informatica Data Services, HealthNow can have a data service for data feeds such as "paid claims" and "pending claims" and business users only have to go to one place though a Web-based tool to get this data. Altogether, the firm has decreased the time of delivery of business pertinent data by up to 5x or more and reduced the cost associated with maintaining data feeds by up to 3x or more. HealthNow is also able to leverage Informatica for improved business-IT collaboration: the company is starting to share data profiles with the business to get a better understanding of the data and is creating business rules.

Improving customer information to enhance customer service or increase customer revenue category

Johnson and Johnson Healthcare Systems How does an organization improve compliance with federal regulations, where failure to comply can result in damage to one's brand image, stiff civil penalties, or even criminal charges? How does it drive towards the 'perfect end-to-end commercial experience' when the three key process processes it relies on―account management, contract management and order-to-cash―have different data requirements? Just ask Johnson & Johnson Health Care Systems (JJHCS). This leading health care manufacturer deployed Informatica MDM to develop five distinct core masters across the enterprise that are used by 14 operating companies across multiple regions. By creating these core masters, raw data is transformed into consistent master data and delivered to all downstream systems for use across the JJHCS application landscape. This allows consistent transaction data to be fed to data warehouses and data marts that supply enterprise-wide compliance and sales management applications. To ensure success, JJHCS created a global data governance organization comprised of representatives from both business and IT which is responsible for overall governance, stewardship and communications. It has well defined processes to manage shared data through the established Global Data Governance Process utilizing information as an enterprise asset. Serving 350,000 customers and covering 300,000 products, the MDM strategy has helped JJHCS to deliver millions of dollars in benefits. The firm is able to process payments, rebates, and disputes more accurately; it can better comply with regulations requiring controls over data; and it is increasing customer service levels through error prevention, timely payments, and an enhanced end-to-end experience. Moreover operating companies are able to adapt faster to changing market requirements such as introduction of new products, sourcing of new customers, and negotiating new contracts. JJHCS is also steadily moving to that perfect order, where the quality of master data is 100% clean, all sales systems are updated during each order, and duplicate product codes no longer exist.

Station Casinos with Informatica Professional Services
Like many entertainment ventures, Station Casinos looked to understanding customer activities and expand its customer base through more accurate communications and personalization. This premier provider of gaming and entertainment for Las Vegas' residents wanted to execute tailored marketing campaigns geared to maximizing customer acquisition and retention. Using the Informatica Platform, Station Casinos developed a unified, 360 degree view of its customers and their activities. The customer intelligence project is exceptional in its vision of using real-time data integration and analytics to power more rewarding customer service. It is also helping to bolster customer loyalty through extended personalization and services which make customers feel special and attract new guests. It is exceptional in its scope, scale and execution too―involving 18 casinos and hotels, multiple customer touch points, and 500 heterogeneous data sources (including gaming, lodging, and food & beverage ).. The project has marshaled the abilities to access, integrate, and process data from multiple sources in real time as well as batch; transparently capture database updates in real time; protect the performance of operational systems; ensure the value of the data through data matching; and promote IT agility through rapid, codeless data integration development. On a business level, the project is supporting Station Casinos' leadership as gaming and entertainment provider to people working and living in Las Vegas. It is also enabling the company to understand its customers significantly better and more quickly, and to recognize their present and future value. And there's one other important benefit: the firm can develop new services up to five times faster compared to traditional hand-coding, which ultimately means services adapt more quickly to what customers need.

Strengthening partner network efficiency category

Wells Fargo with Informatica Professional Services
Like any diversified financial services company, Wells Fargo is aware that long-term customer retention depends on making it as easy as possible for both parties to do business with one another. Prior to the implementation of Informatica B2B Data Transformation, Wells Fargo was investing weeks in on-boarding hundreds of customers from financial intermediaries, involving tens of different formats, and hundreds of thousands of payments a year. This delay not only impacted customer satisfaction, it was potentially also leading to SLA-related fines. Moreover, there were excessive costs associated with implementing each customer on the Wells Payments Platform, and significant costs were involved in managing both customer changes and changes in industry formats. The other challenge for Wells Fargo was to process payments details received from customers, in the original customer format, including industry standards like EDI, proprietary flat files, and document formats like Excel and PDF. Once the data was received from the customer it then needed to be translated to the relevant payment format, such as SWIFT or NACHA. Working in collaboration with Informatica Professional Services, Wells Fargo adopted Informatica B2B Data Transformation and a center of excellence focused on data transformation and industry standards. The Informatica technology is used as a standalone (File Upload System) in Data Exchange (Wachovia), as part of the webMethods Payment Manager infrastructure, through web services and Tibco infrastructure and the MFT layer (Axway). This unified transformation engine has helped reduced maintenance costs by 40%. The partner management strategy has also enabled Wells Fargo to reduce the customer on boarding time from weeks to days (a decrease of 80%), cut 80% of the cost associated with customers' proprietary formats, and ensure compliance with industry standards and regulations.

Fortifying overall operations with global data quality category

Bank Julius Baer & Co Ltd Singapore Branch
Compliance has been getting the limelight these last few years. For large financial institutions, such as Bank Julius Baer which has a presence of more than 40 locations worldwide, compliance is one key area to good corporate governance. However, the increasing depth of compliance checks required in private banking led this Swiss banking firm to adopt more and more manual compliance processes. There was a need for an automated, easy to use solution to help its compliance officers and relationship managers identify names and whether they were possibly linked to internal and external bank 'black-lists'. A high-precision, high-volume Informatica Identity Resolution solution provides the Bank with a two-step search and match process which (i) enable users in the bank to perform adhoc checks for any name against such black-lists and (ii) enable the bank to perform automatic periodic checks. The Informatica Identity Resolution solution allows for variations in spellings, language, common use of nick-names, aliases, or abbreviated names. The solution provides the Bank with an integrated and enterprise-wide view of risk and compliance. In addition, the introduction of internal searches means the bank can maintain confidentiality by not depending upon external online solutions.

Foster's Group
While Foster's Group was toasting its acquisition success, the global beverage company was leaving a trail of data integration challenges in its wake. The fragmented information environment arising from multiple acquisitions made it hard to establish a single integrated view of operations worldwide and maintain efficient supply chains that closely matched production with demand. It also led to higher IT costs because of the extra resources needed to operate multiple systems and consolidate and analyze financial and operational data. Foster's answer was a global enterprise architecture program—consolidating ERP systems, establishing common business processes, and ensuring data quality throughout the migration process. The Informatica Platform is used to profile and cleanse data in the legacy applications and institute data quality plans to maintain data integrity after consolidation. For example, Informatica Data Quality enabled Foster's to standardize its product data hierarchies―necessary for gaining a unified view of sales and shipments—across each system worldwide. Having access to timely, trusted product and customer data will help give Foster's a single, accurate view of global operations. That in turn will lead to better business decisions and better business outcomes. In practice, high quality data helps the company get the order right the first time, and deliver the right product, to the right location, at the right time. The company is garnering savings by eliminating the hand-coded integrations that used to proliferate in its old environment, allowing it to rely more on economical outsourced IT services. Standardizing integration on the Informatica Platform enables Foster's to leverage the marketplace to have integrations built by vendors—which drives costs down significantly. This strategy is enables the company to reduce its IT staff from about 350 a few years ago to 160 today – almost 50%.

Cloud computing category

Telegraph Media Group Limited
Telegraph Media Group—publishers of British newspaper The Daily Telegraph as well as various magazines and the Telegraph.co.uk website—is using Salesforce.com to support its newspaper subscription business. However, one thing was missing: operational reporting on integrated data from Salesforce and other systems, which was critical for decision making. Reflecting the Group's visionary approach to cloud computing, the company chose Informatica Cloud Services to replicate subscription data for reporting and analytics applications. A further innovation is the use of the Amazon EC2 Web Service to host the reporting database. This simple Web service interface presents a virtual computing environment, allowing the team to quickly launch instances with a variety of operating systems and run the Salesforce reporting image using fewer on-premise resources.

Using Informatica Cloud Services, Telegraph Media Group now has the flexibility to access and analyze Salesforce data relating to newspaper subscriptions, while ensuring consistent, accurate, up-to-date and integrated data from Salesforce and other systems. The subscription management team can receive regular reports into numbers of subscribers, their profiles and their entire subscription history. Or they can examine the impact of marketing campaigns aimed at driving up subscription rates. With data replication deployed in two days, compared with an estimated two weeks for a traditional on-premise data integration appliance, Informatica's on-demand services inspire faster, more accurate decision making based on timely, trusted subscription data and have helped improve collaboration between the business and IT. Telegraph Media Group is also reaping all the benefits of cloud computing: new features are available immediately without complex software upgrades, the company pays only for the computing power it needs, risk is reduced, and the total cost of ownership is lowered. Telegraph Media Group is also well on the way to their goal of decreasing time spent on operational issues from 70% to 30% of IT workload―freeing up more time for the technical team to devote to innovation, rather than operational issues.

TransUnion
By implementing Informatica Cloud Services, TransUnion is nearing a complete 360 degree view of customers and maximizing their CRM investment. The sales and service representatives at this global leader in credit and information management use SalesForce.com almost exclusively to manage customer relationships in the U.S. and Canada. Thus, TransUnion needed a way to enhance and integrate data from multiple on-premise systems.

Informatica Cloud Services allows TransUnion to integrate Salesforce.com with their centralized data repository, which is populated using Informatica PowerCenter. Sales can now easily retrieve billing data without leaving their CRM system, and the data is more actionable, providing greater visibility into upcoming trends. The integration has also put control of the minor configurations back into the hands of the business, allowing IT to remain focused on enterprise-wide initiatives.

In another innovation, TransUnion was able to avoid the need for additional FTE and reposition their Data Steward to focus on architecture, metrics, data quality and governance. The company also established a Sales Automation Center of Excellence to provide on-demand thought leadership for other countries and business units. Moreover, because the infrastructure and architecture are completely scalable, TransUnion is now able to easily expand its Sales Automation capabilities to other geographies at a rapid pace.

The cloud integration also has improved productivity and the user experience, reducing valuable development and testing resources. This has resulted in real dollar productivity gains. Additionally, TransUnion's automated solution is now managed in a single web-based interface, replacing the three desktop-based technologies that were previously required. Beyond the resource streamlining, TransUnion is now able to enrich the existing records in its CRM system using the "upsert" command. Further, TransUnion then publishes that enriched data for other systems to consume, making SalesForce.com a two-way participant in the TransUnion operating architecture.