Financial close suite – Tips & Tricks

1. Financial close suite – Tips & Tricks Rahul Sane Oracle OpenWorld 2013 24th Sep

2. Agenda Client EPM program overview Financial close innovations Client testimonials Introduction to Infosys

3. Infosys’ Information Transformation (IX) Practice BI Practice offers a comprehensive solutions for our clients’ needs Skill sets: World class Consultants Breadth : Offers broad range of Services • 7000+ dedicated professionals • Strong Business Consulting Capabilities • Dedicated R&D Group to understand the business and technology trends • Strategy, Roadmap, Business process & IT consulting, technology strategy , implementation & integration, support & managed services, BPO, Governance Center Of Excellence: Providing Optimum Value Alliance : Structured Alliance Programs • Solutions, Methodologies & Tools • Knowledge Management • Training and Certification • Structured Alliance programs and strong working relationships with leading ISVs to support solution development, training, certification etc. Multiple Industry Domains and Business Functions • Industry specific solutions & Horizontal Solutions • Focused on specific needs – viz. Supply Chain analytics, Vendor Performance, Sales Productivity dashboard etc Predictability : Creating success stories • 390+ active client relationships • 50+ Multi-million dollar customer engagements • Customer proximity : Active clients with strong global footprint 3

4. About me… • Experienced EPM consultant with 5 years of functional experience • Specialize in EPM solutions involving entire Oracle EPM suite of products • Exposure to newer Oracle EPM products like ARM, HTP etc… What really sets me apart is my -> ATTITUDE -> TEAM Contacts Email: rahul_sane@infosys.com Phone: +1-510-759-3583 LinkedIn: http://www.linkedin.com/in/rahulsane

5. EPM Program overview • Fortune 150 manufacturing giant • 190+ countries & territories • $17 billion to $30 billion in 3 years! • Integrated business units, diverse requirements! Can an organization grow with inefficient financial systems & processes??? NEED A SIMPLE, EFFICIENT, INTEGRATED, AUTOMATED AND SCALABLE EPM SOLUTION WITH ROBUST STANDARDIZATION, CONTROLS & GOVERNANCE

6. EPM SOLUTION Data conversion(FDM-ERPI) EPM Applications HFM ARM EBS DRILL BACK TO SOURCE HP ESS OTH SOURCES Reporting Master data management (DRM) • Stream-lined, Efficient, Integrated & Automated! • Power to the business!!

7. Section Name MASTER DATA MAINTENANCE TO REPORTING Emails! Emails!!More Emails!!! Prepare master data Run variance process to email reports Load master data Nightly backups, consolidations, refreshes Can FDM leverage DRM master data? Load data to EPM BSO to ASO refresh Trigger consolidation/aggregations ICP Matching, Journal reports Data extracts for other systems Profit-in-Inventory calculations & reporting Is data consolidated? How to control sequence of activities??

8. INNOVATIONS • Master data setup & maintenance • Load Master data to EPM applications • DRM for data integration • DRM for account reconciliation • Load Data to EPM Applications • Trigger Consolidations/Aggregations • Profit in Inventory automation • Nightly Backups • BSO to ASO Cube Refreshes • ICP Matching, Journal Reports • Run Variance Process to email reports • Data Extracts for Finance Systems • Automated notifications • Control Sequence of Activities

9. Master data load automation Non-EPM EBS Consolidation Data Integration Planning Account Reconciliation ENTITY ACCOUNT Analytics (Essbase) Data warehouse BEING ACCOMPLISHED Challenge to setup DRM as ‘Single source of truth’ for finance applications Manually run DRM exports and load them into target applications AUTOMATED

10. Consolidation & reporting automation Data load & consolidation day is an intense, action- packed day! Owners & consumers differ by process, spread geographically! - Activities integrated into a single workflow - Reduce consolidation & reporting timeline from few days to few hours!!! Sample consolidation package

11. Data load process automation FDM/ERPI EPM Admins control & run the process! • FDM/ERPI acts as the single data integration tool for all source systems • Provides drill back to Oracle & some Non-Oracle source systems Areas of Automation Automated subledger data load to Reconciliation manager Load multiple Set of books & consolidate in single workflow Load 12 months annual plan data through single workflow

12. Period 13 reconciliation Period 13 reconciliation a key requirement of reconciliation process Non-standard period in EBS Period dates overlap with Dec period Need to be incremental reconciliation Solution addresses all these issues!!! Only accounts with Period 13 adjustments to be reconciled Period 13 mapped to December month of Reconciliation Manager Quick, efficient Period 13 reconciliation

13. Client testimonials The implementation team has been a key contributor in the successful implementation of ARM. Additionally, they have helped develop critical process improvement tools and processes that will help us roll out the tool to the rest of the Company…. This assistance will result in significant cost savings and improved control environments throughout the Company. We could not be at the point we currently are without them. Steven Buzzard, Internal Controls Manager (ARM program business lead) ….ODI tool was used very creatively by our EPM consultants to automate many activities…At times, these consultants have gone beyond out of the box functionality offered by the tool and used existing functionalities in a very innovative way to achieve desired outcome. I highly appreciate their smart efforts! SonalKulkarni, EPM lead ….we were able to achieve this consistency in our systems with the outstanding help of our EPM consultants! Jon Gehring, Corporate Consolidation Director

14. Thank You