1 / 19

Oracle Financial Services Analytical Applications on Oracle Exadata: Right Technology/Solution

Oracle Financial Services Analytical Applications on Oracle Exadata: Right Technology/Solution. Agenda. OFSAA & Exadata SunTrust’s Vision for Financial Transformation Key Business Challenges Infrastructure OFSAA Financial Transformations Run Time Comparisons (pre and post Exadata).

Download Presentation

Oracle Financial Services Analytical Applications on Oracle Exadata: Right Technology/Solution

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Oracle Financial Services Analytical Applications on Oracle Exadata: Right Technology/Solution

  2. Agenda OFSAA & Exadata SunTrust’s Vision for Financial Transformation Key Business Challenges Infrastructure OFSAA Financial Transformations Run Time Comparisons (pre and post Exadata) Oracle Financial Services Analytical Applications on Oracle Exadata: Right Technology/Solution

  3. About BIAS Corporation About SunTrust Bank Inc. Founded in 2000 Distinguished Oracle Leader Technology Momentum Award Portal Blazer Award 3 Time Titan Award Excellence in Innovation Award Management Team is Ex-Oracle 250 employees with 10+ years of Oracle experience on average SunTrust Banks, Inc. (SunTrust) is a commercial banking organization. SunTrust delivers a full suite of financial products and services to a broad range of consumer, business, and institutional clients. Our businesses are organized around three client segments: • Consumer Banking and Private Wealth Management • Wholesale Banking • Mortgage Banking • Inc.500|5000 Fastest Growing Private Company in the U.S. for the 5th Time • 30 Oracle Specializations spanning the entire Oracle stack • Locations: • Atlanta (Headquarters) • Washington D.C. • Offshore – Hyderabad, India • Offshore – Chennai, India

  4. ORACLE FINANCIAL SERVICES ANALYTICAL APPLICATIONS (OFSAA)

  5. Exadata Innovations Smart Flash Cache Uses flash for physical I/O Smart Flash Log Uses flash to improve log I/O latency Smart Scan Runs portions of a database query in storage Hybrid Columnar Compression (HCC) Reduces the number of blocks (and I/O) for compressed data IO Resource Manager (IORM) Prioritizes I/O bandwidth based on database or workload within a database +

  6. Vision for Financial Transformation The goal of the Finance Transformation is to create a high performing Finance Division • Improved Effectiveness • Improved Efficiency • From.. • Finance as a function: silo-based • Transaction processing takes up much effort and attention • Focus on ad hoc operational solutions • Finance functioning, but not at top quartile performance • Performance management partially effective • Finance professionals under-challenged • To… • Finance as a business partner • Focus on business performance management for core processes • Finance operations low cost and effective

  7. Business Challenge • Business Requirement to model 48 months of forward looking Indirect Costs within an SLA of 48 hours drove the move to Exadata • Key Challenges • Existing Process Time Consuming • Inconsistent methodology • Inability of existing platform to perform complicated cost calculations

  8. Legacy Infrastructure

  9. Exadata Database Machine X3-2 Pre-Configured for Extreme Performance Quarter Rack 2 Xeon-based Dual-processor Database Servers 32 cores (16 per server) 256 GB memory (128GB per server) 10 Gig E-connectivity to Data Center 10 x 10 GB E-ports (5 per server) 4.8 TB High Speed Flash 3 Exadata Storage Servers X3-2 All with High Performance 12 x 600GB SAS disks 2 Sun Datacenter InfiniBand Switch 36 36-port Managed QDR (40GB/s) switch 1 “Admin” Ethernet switch Redundant Power Distributions Units (PDUs)

  10. Exadata Infrastructure

  11. Finance Transformation… DOP and partitioning on tables to enable faster reads and writes by forcing parallel operations Drop indexes to reduce DB overhead for I/O during data population and re-create them upon completion Direct path insert to bypass DB UNDC DOP on LEDGER_STAT DOP on source tables to enable parallel read operations Dropped non-unique indexes on LEDGE_STAT Primary/Unique Key index INVISIBLE during batch process to force FULL TABLESCAN Additional indexes on DIM related tables based on allocation methodologies (e.g. Org, GL etc.)

  12. Run Time Comparison Activity Based Costing

  13. Run Time Comparison Activity Based Costing

  14. Run Time Comparison Activity Based Costing

  15. Run Time Comparison

  16. Results Actual + Plan + Forecast

  17. Additional Strategic Value • OFSSA on Exadata allows the Finance organization to model initiatives and future projects and see the fully loaded impact of those things within the same Forecast cycle, enabling executive input and action on a timely basis. • OFSAA on Exadata gives Sun Trust a strategic advantage by allowing them to see the fully loaded impact of a wide range proposed business initiatives in there forward looking views.  • OFSAA on Exadata gives Sun Trust insight into their proposed impact on Revenue, Expense, Efficiency Ratio and fully loaded profitability.

  18. Customer Quote “ Quote from Dean Harrelson (Senior Vice President for SunTrust, CFS) Wow! Cutting a 12 hour cycle to 2 is amazing! This type of performance will be the lynchpin for: • Integrating our single Indirect Cost Allocation engine into the very tight timeframes required to run 48 months in the Forecast cycle • Moving from a single 9 day Management close cycle that runs once, with Cost a month in arrears, to a multiple complete cycle with an improved publish date and Cost running current month. These items will be key in driving our new culture of enabling buyer and seller conversations and systemically driving better efficiency ratios across the bank. ”

  19. Contact Us Mark Saltzman BIAS Corporation Mark.Saltzman@biascorp.com JagannathPoosarla BIAS Corporation Jagannath.Poosarla@biascorp.com AlpeshTopiwala SunTrust Bank Alpesh.Topiwala@suntrust.com

More Related