1 / 20

Atlanta Oracle Applications User Group Member Spotlight

Atlanta Oracle Applications User Group Member Spotlight. April 15, 2005 Mark Clark and Greg Keith. Agenda. Who is AMVESCAP?. Oracle Applications Environment. Lessons Learned / Future Projects. Who is AMVESCAP?. One of the largest independent investment management groups

kiaria
Download Presentation

Atlanta Oracle Applications User Group Member Spotlight

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. Atlanta Oracle Applications User Group Member Spotlight April 15, 2005 Mark Clark and Greg Keith

  2. Agenda Who is AMVESCAP? Oracle Applications Environment Lessons Learned / Future Projects

  3. Who is AMVESCAP? • One of the largest independent investment management groups • Strives to deliver outstanding retail (mutual fund) and institutional products and services • $380+ billion in Assets Under Management • 50+ offices worldwide • Growth through mergers and acquisitions • Entrepreneurial and autonomous culture

  4. Our Brands

  5. Global Footprint Revenues Profit As of 9/30/04

  6. Who We Are / Were • Mark Clark • During implementations, was the Controller for our AIM division in Houston • Greg Keith • Corporate-level IT project manager

  7. Original Oracle Applications Environment • 1997-98 – AIM first implements 10.7 SC (AP, GL, FA, CM, PO, Projects) • 1999 – INVESCO US offices implement within the same instance and adds AR • 2000 – AIM implements Inventory and Order Entry for Sales Literature Warehouse • 2000 – AMVESCAP purchases Trimark and merges their existing 10.7 environment into our instance

  8. Problems Faced By 2002, AMVESCAP faced: • Looming Oracle de-support of 10.7 • Finance groups outside of North America that were on 14 separate GL systems • Consolidation and reconciliation that was problematic given tight reporting timelines • Intercompany transactions that were difficult to process – manually intensive

  9. The Solution After Before GLOBAL GLOBAL Purchasing AP Fixed Assets LOCAL AR GL Cash Mgmt iExp Inter - Co LOCAL Local technology decommissioned

  10. Dual Projects North America Global

  11. Project Progressions North American Upgrade Initiation CoA Design Continental Europe Dublin Pilot UK Rollout Asia Pacific

  12. North America Houston Atlanta Toronto Denver Louisville New York Boston Dallas Global London Henley-on-Thames Dublin Hong Kong Frankfurt Brussels Melbourne Paris Tokyo Milan Teipei Singapore Locations

  13. Chart of Accounts Design For AMVESCAP, the key to a successful implementation was the design of a single Chart of Accounts structure. We needed a structure that was: • As simple as possible • Flexible • Supportive of a variety of Statutory and Management reporting requirements • Providing a framework for future reporting needs

  14. AMVESCAP Chart of Accounts Entity Dept/CC Natural Account Sub Account Inter- company Fund/ Product Channel Misc 4 6 4 5 4 6 4 6 Ownership AMVESCAP AMVESCAP (Ranges) AMVESCAP Local AMVESCAP Local AMVESCAP (Ranges) Local Required Yes No Yes No Yes, For I’co Tx No No No

  15. Expected and Realized Benefits • Enabled financial reporting from Oracle rather than another reporting tool • Enabled implementation of the Global Intercompany System to clear intercompany transactions • Enabled an efficient Shared Services environment – Accounts Payable, Payroll, etc. • Enabled relationship reporting across business units – vendors, customers, etc. • Single CoA structure reduced required IT maintenance

  16. Unanticipated Benefits • Consolidation of business locations was accomplished much easier • Served as the common reference tool for implementation of Sarbanes 404 under COSO approach

  17. IT Shared Services Environment • Application Development and Support • 1 Manager plus 6 Developers, including 4 with 5+ years of Oracle Financials experience • Dedicated Database Administration Support • Network and Telecommunications Support • Houston Data Center 24x7 Support

  18. Upcoming Projects • Upgrade to 11.5.10 • Global Consolidation System • Sarbanes – Oxley Tool

  19. Questions and Answers

  20. Thank You!

More Related