Home

Naresh Chandrapu - Senior Oracle Cloud Financial Functional Consultant

[email protected]

Location: Wilmington, Massachusetts, USA

Relocation:

Visa: H1B

Naresh Chandrapu Summary: Over 14+ years of experience in Oracle ERP Cloud Functional and EBS Implementations onsite and offshore. Having ERP Financial end-to-end implementation, upgrade and support experience in GL, Expenses, AP, AR, FA, CM, Lease Accounting and Cloud Tax. Handled various Requirements gathering discussions. Performed key business analysis, gap analysis, solution design, CRP s, configuration, testing & implementation of Oracle Fusion cloud. Effective Oracle Fusion Cloud Financials Functional knowledge with about 6 years of extensive experience in Oracle Fusion Cloud Financials Application Implementations & Support. Setup configuration for Enterprise structure, COA, GL, AP, AR, FA, CM etc. modules as a part of Oracle ERP cloud implementation and Good understanding of all the functionalities, Setups, and issues among the financial modules Proficient with various business processes including Procure to Pay (P2P), Order to Cash (O2C) and Account to Report (R2R) flows. Exposure in preparation of high-level functional design documents for Custom Solutions development, Conversions, Interfaces & Reports (RICE). Experience on Data Conversion and Migrations life cycle. Having Good Experience on ADFDI and FBDI load process for master data as well as transactional data Trained the client s super users and users on the application and conducting Pilot testing, integrated testing, design validations and setups of the Distributed ERP applications Worked on proof of concept to showcase cloud capabilities of Oracle fusion cloud financial for critical business processes (Record to Report, Procure to Pay). Education: MBA Master's degree, Finance, Osmania University 2008. Bachelor s degree, Finance, Osmania University 2005 Technical Skills: Oracle ERP Finance Cloud: Expenses (Exp), Lease Accounting (FLA), Accounts Payable/Payments (AP), Receivables (AR), General Ledger (GL), SLA, Fixed Assets (FA), Cash Management (CM), Subledger Accounting (SLA), Tax, Global Intercompany, Revaluation, Enterprise Structure and Oracle Security Implementation Methodology: OUM Methodology, AIM Methodology, Waterfall Methodology and Agile Methodology Engagement Experience: Cloud Familiarization, Process Playback, Requirement Gathering, Solutioning and Design, Configuration, Data Conversion, Fit/Gap Analysis, Integration Testing, Project Management, Facilitating End User Training, Month End Closure, proof of concept and postproduction support Industry Experience: BNFS, Manufacturing, Property & Maintenance, Gaming and Service Professional Experiences: Client: GenDigital, Tempe, AZ Duration: April 2024 Present Role: Oracle Financial Principal consultant Project: ERP Cloud Implementation Description: Service Area: Technology Responsibilities: Financial Principal consultant for implementing Oracle Fusion Cloud ERP (GL, Exp and AP) for all 28 entities in 25 countries. Created complete roadmap for implementation, including Requirements definition, Gap Analysis and implementation process, Functional Design, Technical Design for GL, Expenses and AP Implementation. Conducted workshops at client business location. Documented business requirements, recommended best practices, performed fit/gap analysis, and documented customization, conversion, and interface requirements. Actively engaged in configuring the Enterprise structure using the Rapid Implementation Spread Sheet. Configured and Testing Financial Applications GL, Expense and Accounts Payables based on business requirement Worked on User Creation & Assigning the roles for all the Financial Modules. Participated in CRP and UAT and created user-manuals and trained the end users Performed Extensive unit and integrated testing before CRP & UAT for GL, Expense and AP Performed Mapping and live Demonstration of all business processes in GL, Expense and AP Prepared the Business test Case and several other documents to help stakeholders for decision making in some key areas of the Financial Module implementations. Prepared MD50 s for different custom reports and form Personalization, Created the extensive test scripts TE 40 to verify the reports; tested, verified and deployed to production Environment: Oracle ERP Cloud 24c, GL, Expenses and Accounts Payables Client: Simmons Food, Siloam Springs, AR Duration: Aug 2023 Mar 2024 Role: Oracle Financial Principal consultant Project: Simmons First Finance Description: Service Area: Manufacturing Responsibilities: Utilize complete implementation and configuration knowledge of Oracle Cloud financial applications to define and analyse testing methods Interact with Business stakeholders to get full understanding of business processes involving third party application integration and facilitate testing for the complete end to end flow by creating scenarios and Obtaining sample data from source systems and validating the mapping and transformations established. Provided Functional design and implemented Lease Accounting, Custom Check Printing, Electronic Payment Processing, Positive Pay file, Worked on Fixed Asset module by Setting up Asset Key Flex fields, Asset Categories, Asset Locations, Asset Calendar and Asset Books. Prepared Custom Job Roles for Employee to provide access to relevant tasks Lead the various Testing Phases including and not limited to Unit Testing, Functional Testing, System Integration Testing of various business processes in Oracle Fusion Cloud financials Prepared the training material for UAT and conducted web sessions to train the business users. Full Participation in the Project until Go-Live Provided Post Production Support Environment: Oracle ERP Cloud 23D, 24A, 24b, GL, Lease Accounting, Payables, Tax and Fixed Assets Client: Fidelity Investments, UK Duration: Nov 2021 July 2023 Role: Oracle Financials Cloud Consultant Project: Phase-4,5 Fidelity Bermuda EFP (Enterprise Finance Platform) Responsibilities: Worked as Oracle functional consultant for Requirement gathering phase for requirement understanding and map those requirements to Oracle ERP Cloud Preparing Documentation for the requirement gathering i.e., Requirement document, Solution design document, config workbooks. etc. System setup configuration for cloud financial for - Enterprise structure, COA, GL, AP, AR, CM, FA etc. modules as a part of Cloud implementation For bulk data upload like values of COA, Ledger, Business unit etc. used Rapid implementation feature of Oracle Fusion Worked with the client to complete FBDI Journal Import template, then loaded beginning balances back to FY Ending 2020 Worked in General Ledger module which includes, LE definition, Assign BSV to LE, Ledgers (Primary, Secondary & Reporting) definitions, Ledge options, Ledger Set Definitions Auto post criteria set Worked on Account Payable module which includes Common Options for Payables and Procurement, Manage Invoice option, Manage Payable calendar, Manage Distribution set, Manage Payment options, Manage Payment Terms, Manage Invoice Tolerance, and Manage Payable Document Sequence etc. Worked on Accounts Receivable module which includes Define Common Accounts Receivable Configuration, Manage Receivable s Document Sequence, Manage Transaction Type, Manage Transaction Source, Manage Auto-Accounting Rules, Define Receivable Activity, Define Customer, Manage standard Memo lines, etc. Demo/Documentation to client on P2P Cycle from request raising stage to Payment - AP stage Which includes booking of requisition/Purchase order/Receiving/Invoice/Payment etc. Worked on Application Security setup configuration like Creating Implementation Users, Enabling Abstract Roles, Assigning Roles to Implementation Users, Creating Application Users etc. Worked with the client to complete ADFDI Import Account Combination spreadsheet, then loaded Account Combinations. The client did not want to allow dynamic insertion to be turned on. Explored the Oracle cloud functionalities like ADF Desktop integrator, External Source FBDI (File based Data import) for data migration from legacy to Oracle Cloud Assisted mapping Primary to Secondary ledger Requirement gathered to prepare balance sheet/ Profile and loss account - FRS Financial Reporting Provided CRP & UAT training to end users & data migration. Successful GO live 8 LE's with financial modules onsite & offshore. Provided GO live Support to business users after implementation for day-to-day transaction. Environment: Oracle ERP Cloud 21C, GL, AP, AR, FA and CM Client: Harrah's Cherokee Casino Resort, Las Vegas, NV Duration: April 2021 to Oct 2021 Role: Oracle Financials Cloud Consultant Project: Project Harrah Responsibilities: Business Process Study Worked with business users to document requirements and criteria Developed business flow by inputs from clients, end users and Subject Matter Experts (SME s) Assisted the client with translation into realistic solutions Engaged in Functional analysis, understood limitations of application and proposed solution for implementation Oracle Applications GL, AP, FA & CE modules Engaged in requirement gathering and analysis and design of the existing and future application Prepared Functional Specification Documents, AS-IS and TO-BE workflows Gap Analysis & Mapping the business process with the standard functionality of Oracle Application Prepared Setup and Module Design and Build (RD011, R020, RD030) Documents Successfully conducted and monitored training and business simulation with end users Product Demo to client for Oracle Cloud General Ledger Modules, Account Payables, Cash Management & Fixed Assets and Fusion. Product Walk through Module Wis in CRP X sessions Documentation of the requirements study as per the OUM Methodology Product configuration and setup including documentation of MC 050 Prepared User Manuals for the Oracle Financials Modules. Preparation of Data Acquisition, Conversion and Data Quality Strategy Extensive Training to the Key User. Conducted User Acceptance testing including documentation of TE 040 Data Migration and Go live. Environment: Oracle ERP Cloud 21A GL, AP, AR, FA and CM Client: State Street Banking and Trust, Boston, MA Duration: January 2019 March 2021 Role: Oracle Financials Cloud Consultant Project Description: Oracle EMEA financials/Procurement END to END Implementation Phase-I, II & III-Global rollout Responsibilities: Engaged in Functional analysis, understood limitations of existing database and proposed solution for implementation Oracle Applications GL, AP, FA module Engaged in requirement gathering and analysis and design of the existing and future application Gap Analysis & Mapping the business process with the standard functionality of Oracle Application Prepared Setup and Module Design and Build Documents Successfully conducted and monitored training and business simulation with end users System configuration for all financial application in the environment of Application setup manager Creating user and giving role provisioning in Security Console Setting up Job role, duty role, and data roles as per business requirement Completed testing for all financial applications (Unit & Integrated) Engaged in Loading Master and transactional data using FBDI Templates Mapping with Oracle Fusion application standard functionality Effectively worked with Oracle support team to resolve product related issues and bugs. Working on Fusion Financial Applications to support day-to-day application user issues. Environment: Oracle ERP Cloud 20C GL, AP, AR, FA and CM Client: State Street- Charles River Development (CRD), Boston, MA Duration: October 2014 to December 2018 Role: Oracle Financials Functional Consultant Description: Application Development, Enhancement and analyst (Implementation, RICE, Enhancement, Customization, personalization and Development) Responsibilities: Requirement understanding with business user and pass on the same to technical development team for custom report development Preparation of BR100 Application Setup, MD50 Functional Design, MD70 technical Design for new Custom report development Helping business user in UAT phase for the new developed report as part of change management Verification of Financial module setup configuration based on existing documentation with system configuration for AP, AR module Guiding the business by providing reconciliation approach between General Ledger and sub ledger modules preparation of high-level functional design documents for Custom application development, Conversions (suppliers, Customers, Banks, Open items & Legacy TB s, Interfaces (Inbound & Outbound) & Custom Reports (RICE). Prepared Kick off presentation on project plan & schedule. Presentation for Project planning & initiation to client Understanding AS IS operations and map with TO BE processes with Oracle Standard features customization and Personalization. Translate the customer requirement into a scenario to show to the customer, and develop these prototypes General Ledger Configuration - Ledger, Legal Entities, Currency, Calendar, SLA, COA Mapping Accounts payable Configuration Financials option, system options, payable options, payable calendar, payment terms, Aging report definition, bank setup, Payment Process Request - PPR payment templates Bank Format understanding and preparing MD50 document, sharing the understanding with Development team for development Accounts Receivable Configuration Transaction type, Transaction source, System options, Auto Accounting, Receipt class, Receipt methods Cash Management Configuration Automatic bank statement generation from bank and uploaded in Oracle system s Fixed Asset Configuration Define Set of Books, Asset Category Flex field, Location Flex field, System controls, Fiscal Year, Deprecation/prorate Calendars, Books Controls, Asset Categories etc. Prepared SOP (Standard Operating process) Invoice-Assets-General Ledger. Conversion of Sub ledger closing balance for new legal entity Roll out project Prepared MD-50 for interface development for source system s which includes IBS, WSS, Sun etc. Configuring the Dev, Test & Prod instance as per the solution design and supporting various test phases such, QA, UA & FSR Gathering requirements from the client for customization, enhancement and change request. Evaluating the Reports and testing them for the desired outputs after development as Per the Business requirements. Assist business user is in UAT for the customized report designed & developed Played significant role in system Integration testing. Tested the entire process of Payables transfer to GL, AP Assets creation and mass Additions create through Payables. Developed and executed test scripts and drove resolution of fixes to the system prior To User Acceptance Test. Preparing BR100 s as per solution design and MD50 as per regulatory requirement for various countries. Assist Business user in UAT phase for testing the functionality of Oracle E-business suite Release 12 and its Features. Environment: Oracle EBS R12.2.2, GL, AP, AR, FA, CM, PO Client: Amex, Chennai, India Duration: July 2013 to Sep 2014 Role: Oracle EBS Financials Functional Consultant Project: Production support Description: American Express provides innovative payment, travel and expense management solutions for individuals and businesses of all sizes. Responsible for Level 2 support. Modules engaged are GL, AGIS, AP, AR, Oracle Applications E-Business Suite. Responsibilities: Worked on Postproduction Support & New Enhancements. Provided Functional & Technical Support, Requirement gathering from Business/Users. Setups and testing of functional components, Created various oracle standard documents MD50, and MD70 & BR100. Monthly Periodic Book Closure process of Sub-Ledger. Solved the IMR s based on Priority. Resolved the issue customized functionality issues (Like DCA Entry and FAR Report issues) Co-coordinated with other technical teams and resolved technical issues. Setup the data like A/c codes, Payment Terms, Cross Validation Rules, and Security Rules etc. with the help of Business Users. Worked on the SR s IPM and other standard functionality related issues. Resolving the CPC transaction tax related issue. Set up the various book category methods in fixed assets and testing the depreciations based on the category Resolving the PO workflow and charge account related issue. Solving the Invoice Approval workflow related issue. Involved in End-to-End testing in the business to validate the functional flow Worked on Pending requestor coding report & invoice approval report. Environment: Oracle Financials 12.1.2: GL, AP, PO & PA, FA, And Ebiz Tax-Vertex. Client: Gates Corporation, Chennai, India Duration: September 2012 to June 2013 Role: Oracle Financials Functional Consultant Description: Enhancement and Responsible for Level 2 support Client: Regeneron Pharmaceuticals, Newyork Duration: September 2011 to July 2012 Role: Oracle Financials Functional Consultant Project Description: implementation Client: East Penn Inc, Chennai, India Duration: October 2010 to August 2011 Role: Support Consultant Description: Responsible for Level 2 support. Modules engaged are GL, AGIS, AP, AR, Oracle Applications 1i. Keywords: cprogramm quality analyst golang container edition purchase order logistics execution Arizona Arkansas Colorado Maryland Massachusetts Nevada Pennsylvania