440 likes | 1.98k Views
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).
E N D
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) Oracle Financial Services Analytical Applications on Oracle Exadata: Right Technology/Solution
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
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 +
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
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
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)
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.)
Run Time Comparison Activity Based Costing
Run Time Comparison Activity Based Costing
Run Time Comparison Activity Based Costing
Results Actual + Plan + Forecast
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.
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. ”
Contact Us Mark Saltzman BIAS Corporation Mark.Saltzman@biascorp.com JagannathPoosarla BIAS Corporation Jagannath.Poosarla@biascorp.com AlpeshTopiwala SunTrust Bank Alpesh.Topiwala@suntrust.com