Company Background
This large Fortune 50 Bank is in over 1,000 cities, 160 countries and serves millions of people worldwide. They have over 200 years of experience meeting today’s toughest challenges and strive to create the best outcomes for their customers using financial solutions that are simple, creative and responsible.
Objectives
This organization’s analytics processing was built by the business and designed for CCAR (Comprehensive Capital and Analysis Review) executed on large UNIX servers with EMC storage. These configurations led to extremely long processing times, often in excess of 40 hours.
Resolutions
Destiny Corporation assessed the existing infrastructure and identified areas of inefficiencies. A new MPP (Massively Parallel Processing) environment was put into place and the CCARs logic was transferred onto this solution. The strategic utilization of intelligent parallel processing decreased this client’s analytics processing time from 44 hours to 15 seconds.
Benefits
The organization can now perform their analytics processing in under a minute, allowing more time for data analysis and less time spent on running reports.
Company Background
This large Fortune 50 global bank serves people, companies and institutional investors worldwide, and is a leader in the financial services industry. They help clients achieve their goals by providing value, convenience, expertise and innovation while adhering to their key operating principles.
Objectives
The organization ran high-level analytics processes on their own MPP data mart environment within a Teradata enterprise data warehouse. This configuration led to long processing times, resulting in the business spending more hours on processing information than analysis. They wanted to reduce their overall run times.
Resolutions
Destiny Corporation evaluated the configuration of their existing environment and in conjunction with the client, designed a new architecture with a new MPP environment. This allowed processing jobs to drop to 15 minutes, while previously they demanded 15 hours.
Destiny Corporation evaluated the existing configuration and, in conjunction with the client, designed an architecture with a new MPP environment that was better designed to process data. This allowed processing jobs to drop to 15 minutes instead of 15 hours.
Benefits
This new MPP solution lets the organization spend less time processing data and more time on actual analysis.
Company Background
This large Fortune 50 Global Bank serves people, companies, and institutional investors worldwide, and is a leader in financial services. This organization helps their clients achieve their goals by bringing them value, convenience, expertise, and innovation, while adhering to key operating principles.
Objectives
This organization had Analytics processing, built by the business, and designed for CCARS executed on large UNIX servers with EMC storage. These configurations lead to extremely long processing times, often in excess of 40 hours.
.
Resolutions
Destiny Corporation assessed the existing infrastructure and identified areas of inefficiencies. An upgraded server environment was put into place and the CCARS logic was transferred onto this platform. Analytics processing went from 40 hours to 12 hours with the upgraded server environment.
Benefits
This organization is now able to perform their Analytics processing in a fraction of the time, allowing more time for data analysis and less time spent on processing.
Company Background
This large Fortune 50 global bank serves millions of consumers, from small businesses to many of the world’s most prominent corporate, institutional and government clients. They are a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management and private equity.
Objectives
This client had stringent regulatory deadlines in order to comply with federal bank reporting regulations. Unfortunately, their EMC infrastructure caused them to miss these crucial time limits, resulting in massive penalties and fines. Several employees had to be terminated due to noncompliance with these regulations.
Resolutions
Destiny Corporation evaluated the existing Analytics environment that was supporting the SLA reporting. Destiny Corporation designed a new architecture with upgraded server and storage solutions. The replacements brought processing times down from 90 hours to 2 hours.
Destiny Corporation evaluated the analytics environment that supported SLA reporting. We designed a new architecture and upgraded their server and storage solutions. This new infrastructure brought processing times down from 90 hours to 2 hours.
Benefits
The organization can now report all federally required information within the time constraints given by the government and there are no longer issues with penalties and fines.
Company Background
This lending institution had an aggressive strategy in place to procure other banks. This created a need to analyze and monitor the performance of these new acquisitions on an ongoing basis. To perform this analysis, a combination of ad hoc reports had been put together using spreadsheets. The patchwork of numerous financial applications was cumbersome to deal with and no standard interface existed to link these applications. Additionally, the limited functionality of the disparate systems made it difficult and time consuming to create and access comprehensive financial reports, restricting the amount of value-added analysis that could be performed.
Objectives
Our representatives met with the Head of the Bank Reporting Unit who helped us understand their requirements. They wanted standardized reports and graphs that could be created on a monthly basis with minimal effort by a non-technical person. Real time access to a reporting system became imperative to provide senior management with quick and accurate financial information. Ideally, this process would be automated to the fullest extent possible, enabling administrative staff members to run the reports. We recommended writing an application with a user-friendly GUI front-end that could easily be executed by a non-programmer each month.
Resolutions
We worked with key personnel involved in this venture to further analyze their situation and needs. Ad hoc reports, data sources, users and methodology were evaluated. Based on our findings, we developed a highly automated reporting and graphing package, designed to provide them with accurate information in a consistent and timely manner. This software solution was built using application development tools in a Windows based environment.
Benefits
The organization now has standard reporting and graphing applications in place. Their administrative staff can access information on a monthly or as-needed basis, and the organization’s financial information is readily available through an automated process. This system enables upper management to make strategic decisions based on the most up-to-date information.
$250B U.S. BANK
SITUATION
- 100 SAS users
- SAS Infrastructure costs over three years were
$27M, now down to $2.5M per year
HOW DESTINY CORPORATION HELPED
- Interviewed departments, ran analysis,
and found ways to optimize their current
environment - Gave IT knowledge about SAS infrastructure
utilization - Helped customer restructure and optimize
their costs
BUSINESS OUTCOME
- Over 360% reduction in SAS Infrastructure
costs, while better supporting the organization’s
SAS user community
U.K. BANK WITH OVER £210 IN ASSETS
SITUATION
- SAS was mission critical to the bank and ran
on Windows servers - 800 SAS users
- Servers were crashing
- Did not have standardized processes
- SAS jobs ran for hours and days
- IT cannot do backups when jobs are running
HOW DESTINY HELPED
- Designed proper infrastructure to fully
support SAS processing needs - Wrote custom scripts to read all SAS
storage locations - Found 22 million lines of SAS code with
many logic and data issues - Destiny Corporation designed and educated the client on the proper batch use of SAS/Grid
- Destiny Corporation showed every touch point – SAS logic, SAS datasets, and non-SAS
- Created standards for SAS users and
developed education process - 14 month project
BUSINESS OUTCOME
- 500% faster running SAS jobs
- Five SAS Windows servers were reduced to a
single server instance on IBM Power - SAS jobs never crashed after their migration
- SAS jobs went from hours or ‘all weekend’ to minutes
