Prashant Kangutkar Email & Phone Number

Watford, England, United Kingdom

Manchester Area, United Kingdom

• Migration project from E-business Financials Suite to Fusion Cloud Financials made live with smooth hyper care • Holding workshops with ITV Finance Stakeholders, KPMG Implementation Team• Responsible for Data extraction (Configuration as well as Transactional) from EBS for loading into Fusion (AR/AP/GL/FA) Modules• Guide technical resources from (ITV as well as KPMG) for getting data from Finance Table• Making sure end to end process has worked and all balances are matched between EBS and Fusion for Transactional as well as Master Data for Finance modules.• Hold workshops for reconciliation items and track them in JIRA ensuring they are actioned.• Discussion with stakeholders on pain points and resolutions provided through Oracle• Customization of FAH (XLA) for Deposits, as functionality in Fusion isn’t there, tested successfully• Large scale Data cleanse activity carried out as part of Migration by writing SQL queries for Finance modules as well as Projects Table structures.• Writing OTBI reports for reconciliation activities• Using smart views to slice and dice financial data with EPM Module

London Area, United Kingdom

• On boarding of New Client in Direct Line Insurance Finance System• Holding workshops with DLG and Client Finance Stakeholders, Architect, Migration Team• Setting up plans to get Historical Data from Client legacy into DLG world through Finance Systems• Data extraction from financial modules for loading into EPM and validate• Preparation of Data dashboard for integration with various systems.• Posting Rules changes to FAH (Financial Accounting Hub)• Configuration and test functionalities within Oracle Cloud in terms of new requirements shared by Client and replay back. Also explaining same to technical developers • Integrity Reconciliation between systems e.g. Policy Admin, FAH, Oracle GL• Requirements gathering includes MI/Reporting Catalogue work and documentation• Working in Agile Methodology environment

London Area, United Kingdom

• Lead for O2C and A2R on Global Single Instance Project for EMEA Countries (R12.2.3)• Application configurations at various stages SIT -UAT – PROD with use of ALM • Preparation of User scripts/manuals / UAT Testing business scenarios for AR,AP and FA• Project delivered on time with smooth completion of hyper care• Discussions with country controllers / stakeholders about business requirements• All customizations are tested thoroughly as per EU Country requirements• Working with different stakeholders for business discussions• Configuration/mapping of Oracle Projects billing/costing to Receivables • Legacy systems like Basware / More4Apps• Ad-hoc SQL Reports for quick wins to Client

• On boarding of New Entities after Schroders acquisition including Financial Module configurations• Financials Cloud classroom training on all modules• Production issues of financial modules AR/AP/GL/eTax/SLA/FA/CM resolving within SLA• Interaction with Business Stakeholders on business process improvements• Interaction and guidance to European and Asia pacific Teams about Financials issues• Monitoring and resolving AR/AP to GL Interface issues on daily basis coming from Quartal,More4apps, Baseware, FAH• Customization/Improvements and testing as per Agile methodology • Interaction with Global Business users from US/EMEA/APAC to ensure month end closures on time• Ad-hoc reporting through writing SQL and extracting data from base tables, discoverer• Liaoning with DBA Team for making sure patch application is executed successfully and also with teams like RBAC, legacy applications

Switzerland / Uk

• Discussion with non-technical managers to understand complex, dynamic business rules/process and subsequently produced comprehensive documentation• Analysed configuration and provided better options of Configuration /Business processes for Financials modules.• Optimum use of interfaces to avoid manual intervention of data handling• Handling long winded production issues based on management priorities in timely manner• Configuration of R12 Financials (AR/AP/GL/CM/FA/SLA/Etax/PO) modules • Production issues resolutions and month end closures on time• Generating OBIEE reports required by finance department for MIS Reporting• Analyse business requirements (Functional/Technical) and convert into deliverables• Requirements gathering and scope definition with non-technical business user constituencies, preparation of MD50• Excellent understanding and ability to analyze and query application data schema• Knowledge on Oracle Enterprise Data Quality Tool, Data migration from legacy system

Dunstable, Bedfordshire

Being part of Finance Transformation project, main focus was to concentrate on existing Chart of Accounts and propose solutions/enhancements. Also handling long winded production issues and automation of fixed assets and other SOP. • • Part of Finance Transformation Project of IT division of Premier Inn, Costa and Restaurants• Delivered fixed Assets automation solution by engaging business users to support all necessary clarification for Development Team and Production Support • Discussion with non-technical managers to understand complex, dynamic business rules/process and subsequently produced comprehensive documentation• Engaged business users and exhibition of business goals and processes to ensure effective use of application solutions• Study and verify business User’s request functionality and business rules based on existing financials configurations and business processes• Ability to create and present key requirements/automation without direct supervision• Proposed changes to SOPs to have accurate management information• Study Interfaces of legacy systems, SQL writing, workflows, Reports to management • Study existing Chart of Accounts (GL) and proposed changes beneficial to the Business e.g. AGIS, data cleansing, auto posting of Journals• Solutions to the pain points and implementation of change requests and managing escalations • Configuration R12 Financials (AR/AP/GL/CM/SLA/ETax) modules and MD50 preparation.• Conduct workshops with key stakeholders for decisions on proposed changes. • Lead Role co-ordinating with technical team and business users in order to deliver reporting requirements for Finance• Excellent understanding and ability to analyze , query application data schema using SQL

Swindon, United Kingdom

Boarded in to enhance Oracle Financials but later played Implementation Consultant when RUCK formed UKSBS Shared Business Centre. Also played role of team lead. Part of migration project in assuring figures matched.• Successful Implementation of GBS http://www.hmrc.gov.uk/gbs/ Project configuring Financials R12 (AR/AP/GL/CM/Payaments/eTax) modules managing entire project • Strong functional understanding of the systems supported and the development framework for customizations• Discussion with non-technical managers to understand complex, dynamic business rules/process and subsequently produced comprehensive documentation• Modified SubLedgerAccounting(SLA) definition for business delivering business requirement • Worked on AGIS Implementation Project which involves Business requirements gathering, E-Tax configurations (Tax Regime to Tax Rule)• Gap Analysis of E-Business Tax functionality to current and future business requirements• Work closely with business to identify on-going systems enhancements and to fully realise the business potential of current applications to improve business performance• Contributes to the definition and execution of a continuous improvement schedule for assigned applications so that business operations can benefit from improved services• Implementation of Financials modules bringing external customer on board in newly formed shared service centre • Identifies how best to meet the business requirements – whether through extending their use through configuration or through development of the application• Co-ordinated implementation of the solution guiding technical pool to deliver solutions • Troubleshooting long pending Issues on Production environment• Excellent understanding and ability to analyze , query application data schema using SQL• Project Accounting / project costing interfaces to GL and AP troubleshooting • Developing new SQL queries for MIS reporting in OBIEE Tool

Preston, United Kingdom

• Management of upgrade issues from 11.5.10 to Rel 12 of financials modules• Checking 11.5.10 Configurations/ Reports for project requirements• All the configuration testing on ETax (Tax Regime to Tax Rule), AR, AP, GL ,SLA and CM modules and Discoverer• Interacting with Business Users for Testing requirements and desired results• Knowledge transfer that enable Client to meet changing needs of the Business

France / Austrailia / Mexico

CMA Being Shipping company, where business is done between Carrier-Agency, solution was designed for Head Office and Agencies across the Globe. • Responsible for Implementation of AR/AP/GL Modules on R12• Discussion with non-technical managers to understand complex, dynamic business rules/process and subsequently produced comprehensive documentation• Engaged business users and exhibition of business goals and processes to ensure effective use of application solutions• Study and verify business User’s request functionality and business rules based on existing financials configurations and business processes• Roll-out of Financial Modules to Australia and Mexico Agencies• Data Migration from legacy system into R12 financial modules• Understanding Business Processes and mapped them onto Release 12 version of Oracle• Documentation (User Training, Business processes) upgrade with appropriate Screenshots based on the live cases of Business• Meeting with Off-shore team of 5 people to manage Client Requirements• Meetings with Client and Vendors like IBM to work out solutions and design Custom Reports• Consulting on Statement of Work• Providing consultation on Pre-sales work for bidding• Monitoring Issues Tracked and providing weekly status to Client• Work under pressure situation as there were Other Vendors like IBM involved in the Project

Woking, United Kingdom

Appointed for maintenance and support e-business environments by providing techno functional support of operational Oracle financials Modules ( GL/AR/AP/CM &AX)• Liaising with Business Users for providing resolution to issues raised more often quickly• Running Custom reports weekly for Collections as this is Management report for Cash Flow• Interaction with Technical Team of three and DBA for Custom Reports requirements and Application performance• Managed the relationship between the Finance and the IT departments• Timely Month-End Closures of AR,AP&GL Accounting Periods with Business Users• Running of WEB ADI for General Ledger Journals upload• Use of SQL for extracting Data for Business Users Analysis purpose • Providing inputs relating to Financials modules to Legacy Application experts as data was interfaced into Oracle Applications

London, United Kingdom

• Appointed to mange End Client Hilton Hotels for Post production support• Identified and documented potential issues with processes and systems• Prepared test scripts, produced test scenario documentation & drew up a testing schedule• Provided post-production support for the AR/AP/GL/AX and CM modules• Managed On-site – Offshore Team of Four personnel.

Middlesbrough, United Kingdom

• Appointed to bring project expertise of GL module to move on Global Single Instance• Responsible for the preparation of GSI functional solution design document• Understanding of existing UK Business Operations of GL Modules and finding Gaps • Prepared project plan, test cases for entities & functional specs to Tech. team for interfaces • Testing of various functional set ups into Applications• Interaction with Application Business Users as well as IT department• Configuration of Setups for GL/AR/AP Modules

London, United Kingdom

• Appointed to Identified options for potential solutions to technical and business suitability• Play a key role in the development of business opportunities for the practice• Provided onsite production support of Oracle Financials (AR/AP/GL/FA/CM) 11.0.3 across UK• Lead Role in monitoring Team activities and maintained a balance of On-site/Off-shore Model

Reading, United Kingdom

• Appointed to Implement, Upgrade, Migration, testing and support of Rel 11 to 11.5.9 functionally (AR/AP/GL/CM) Modules with Shared Service Centre in Dublin • Self learned AX Module while handling production issues and became responsible for AX going live across EMEA on GSI Project and then trained Oracle India consultants• Application Set-ups Test and Support of all month-end critical production Issues • Only functional consultant in delivering successfully EURO Currency Project for EU countries• Learnt complete Table Structures of Financials modules and very good hands on SQL writting • Preparation of User Manuals for European Users• Liaising with DBAs for Custom Report requirements and Load testing of Application• Due to good knowledge of Functional as well as technical side of Application, never raised issues with Metalink.• Contribute to internal knowledge sharing• Training to Oracle India consultant on AX Module • Troubleshoot Production Issues of Financials Modules across EMEA within Oracle• Handled pressure situations of Business Users and provide timely resolution during Month End Closure as there were many P1 Issues hitting the Team

Cairo, Egypt

Implementation of AR/AP/CM Modules at ICL,EgyptData migration from legacy system into Oracle base Tables through SQL LoaderPreparation of MD50 documentation and training to business users (non-english speaking)Preparation and testing of business scenarios through non-production systemPost production support of financials modules.