Rupendranath Alle

Summary:

Over ** years of experience as an Oracle Financial Functional Consultant, experience in full-fledged End-to-End Implementation and support projects.

Oracle Cloud Fusion financial certified consultant - AR, GL & Purchasing.

Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User Training and Supporting for Oracle Financials R12/11i GL, AP, AR, CM, OM, iProcurement, isupplier and FA modules.

Participated in multiple Oracle Apps R12/ 11i & Oracle Fusion/Cloud Financials releases 12 implementations in multi org/multi-currency scenarios, including areas involving Pricing, Purchasing, and Inventory.

Worked on in P2P and O2C Cycles.

Worked on E Business Tax in R12, India Localization, EB-Tax & Vertex.

Hands-on working and demonstrating of Oracle Cloud Financials and Fusion Accounting Hub (FAH).

Implemented AGIS company Transaction, Consolidation, Elimination entries setups and configurations.

Worked on AME, SLA, IPM & Mark view and other Invoice Integration experience.

Designed and executed several Customizations & Interfaces (Concur, Amex, Lockbox, Payment outbound file, Bank statement import, IRIDIUM and Emtories) Setups in ERP as a part of solutions.

Experience in Data mapping the external source files with oracle columns in Oracle Accounts Receivables, Accounts Payables and Fixed Assets modules.

Prepared Functional design documents for customizations/conversions using AIM methodology.

Experience in all phases of the system development/implementation life cycle.

Prepared RTM document and conduct the walkthrough to the module owners based on new changes.

As Functional Consultant, worked efficiently with multi-national teams. Ability to interact with individuals at all levels and accustomed to working under tight schedules.

Technical Skills:

ERP Products: Oracle Applications: Version 11.5.9 / 11.5.10 / 12.1.1 / 12.1.3 GL, AP, AR, AGIS, E-Business Tax, Vertex, FA, CM, PO, AME,SLA, ADI and Flex fields.

ERP Engagement Expertise: Oracle ERP Implementation, Upgrade, Onsite/Offshore, Production Support, User Training and Testing, Requirements Analysis, Business Process Study, SR/TAR Management

Other ERP/Related Skills: GAAP Accounting, Month End Close Process, COA Design, Multi-Org Design, IR/ISO, Intercompany Accounting, EbizTax-Vertex integration

Implementation Methodology: Oracle: AIM, Oracle: Fast Forward, Oracle: OUM

Development Methodology: SDLC, E-R Modeling

Development Tools: Oracle: Toad, SQL Developer,, Data Loader, QTP & Integra Apps.

Languages: SQL,

MS Products: MS Projects, Visio, Excel, Word, Power Point

Industry Expertise: Manufacturing, Healthcare (Pharma), Insurance, Banking & Finance, Broking, Construction

Education:

Master of Business Administration (MBA), from University of Madras, in 2003.

Bachelor of commerce (BCOM) from university of Madras, in 2001.

Certifications:

Oracle Financials Cloud: General Ledger 2018 Certified Implementation Specialist

Oracle Procurement Cloud 2018 Certified Implementation Specialist

Training:

Oracle Fusion Financials, GL, AP, AR, CM and FA, Oracle, March – 2016

Professional Experience:

Client: Daikin Applied, Plymouth, MN

Duration: Aug 2019 to date.

Role: Oracle EBS Financials Functional Consultant.

Project: R12 Oracle International Implementation & Support General Ledger, Accounts Payables, Accounts Receivables, Order management & Fixed Assets.

Description: Daikin Applied is a manufacturer of energy-efficient commercial HVAC systems for heating, ventilation and air conditioning.

Responsibilities:

Working on EBS Financials (General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets & Order management)

Configured & tested new Banks, payment terms, pay groups, payment process profile & PPR for Utility expenses credit card payments.

Worked on AP Invoice interface issue from other system(EDI, RSOL & Concur) to oracle.

Worked on BPA & purchase order related issues.

Logged, viewed, accessed, monitored, followed up and closed the Service Request (SR) with Oracle Support.

Provided training and conducted practice and Business Requirements definition sessions. Supported the production environments and users daily by resolving user issues.

Worked on the Month end period closing issue for all financial modules.

Resolved Fixed Assets SLA related issues.

Worked on Order Import interface, to load all the legacy orders in booked status into Oracle.

Configured & tested new AR transaction types, transaction sources, Receipt class & Receipt sources for training and Astea related invoice creation.

Resolved Sales Order WF issues while shipping & invoice interface.

Resolved Auto invoice import issues( like ship Via, revenue account, Gl date issues)

Configured Journal Approval & new Web-Adi templates.

Worked extensively on Auto Lock Box to bring data from external sources into Receivables AR base tables.

Designed and build the custom tax reports with technical team support.

Provides second level support, relating to business applications and processes, and escalation support for aging unresolved issues.

Analyzed user needs, conferred with users to improve procedures and identified and solved problems

Environment: Oracle Financials 12.1.3: GL, AP, AR, FA, CM- Ariba.

Client: Cigna Insurance, Hartford, CT

Duration: May 2018 to July 2019.

Role: Oracle Fusion Financials Functional Team Lead

Project: Oracle Fusion Release 12 USA Implémentation General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets and FAH.

Description: Cigna is a global health service company dedicated to helping people improve their health, well-being and sense of security.

Responsibilities:

Worked on fusion financials (General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets)

Identifying business requirements and mapping them to the Oracle Cloud functionality

Advising clients on options, risks, and any impacts on other processes or systems

Configured the Oracle Cloud Applications to meet client requirements and document application set-ups

Writing business requirement documents for reports, interfaces, data conversions and application extensions

Defined testing scenarios and developed test scripts

Supporting clients with the execution of test scripts in UAT.

Developed end-user documentation and training materials

Worked on Vertex integration with Fusion environment.

Effectively communicating and driving project deliverables

Completed tasks efficiently and in a timely manner

Interacting with the project team members responsible for developing reports, interfaces, data conversion programs, and application extensions

Implemented ACH &Wire customization process to sending bank payment files.

Providing status and issue reports to the project manager/client on a regular basis

Opens, manages, and resolves Oracle Service Requests with Oracle Support.

Customization of BI Publisher templates for checks, positive pay and Confidential payment files

Developed, tested and implementation of custom inquiry Roles for enhanced security

Solved the Defects based on the priority.

Integrating with Ok2pay and Master Data interfaces from Oracle to Ariba vice versa.

Worked on FA Tax books conversion for the newly acquired acquisition assets

Implemented and tested Assets creation process with Cigna customization.

Environment: Oracle Fusion Release 12: GL, AP, AR, FA, CM & Ariba.

Client: Cigna Insurance, Hartford, CT

Duration: March 2016 to April 2018

Role: Oracle EBS Financials Functional Team Lead

Project: R12 Oracle International Implémentation & Support General Ledger, Accounts Payables, Accounts Receivables & Fixed Assets

Description: Worked on full life cycle Implementation with responsibility of GL, AP, AR, FA, CM and EB-Tax modules R12.1.3 Oracle Applications E-Business Suite.

Responsibilities:

Prepared AP322 configuration documents Iprocurement modules

Prepared Functional design document to developing the custom reports and providing functional support to testing the developed reports.

Developed custom interface to integrate American Express corporate card (AMEX) with Concur expenses.

Involved in integration between the IRIDIUM system and Oracle AP for Non-PO invoices.

Developing test scripts and test cases for customizations.

Participating User acceptance testing and getting sing form the business before moving in Production

Implemented Approval workflow generator process and tested custom functionality in all CRP3 and UAT instance.

Implemented Auto Invoice & Lockbox process to importing invoices and receipts.

Resolved customer Interface issue while importing customers from SFDC to oracle.

Resolved Bank Interface and reconciliation issues.

Solved the Defects based on the priority.

Involved Standard PO, BPA & CPA customization functional support.

Enabled and tested Supplier catalog Authoring and Advance Shipment notice functionalities based on business requirement.

Supported XML & Iridium Invoices imported file invoices issues.

Non –PO invoice functionality tested in various test instances and enabled the future to creating invoices from I suppliers.

Configured AGIS setup for processing Intercompany Transactions.

Customized Account Generator process to creating charge account as per business requirement.

Ability to changing the charge expenses Centre & project code while creating the Requisition.

Tested I supplier PO and Non-PO Invoice process.

Tested the end-to-end process through WEBADI and normal AGIS process.

Conducted CRP1, CRP2, SIT & User Acceptance Testing (UAT) and getting sign off.

Resolving issues Go-Live and postproduction support.

Environment: Oracle Financials 12.1.3: GL, AP, AR, FA, CM & Ariba.

Client: Morning Star, IL

Duration: May 2014 to Feb 2016

Role: Oracle EBS Financials Functional Team Lead.

Project: R12 Oracle Rollot Project Implémentation & Support (Germany, Netherlands & Luxemburg) Project execution: Accenture.

Description: Morningstar, Inc. Headquartered in Chicago, Illinois is a leading provider of independent investment research in North America, Europe, Australia, and Asia. Worked on full life cycle Implementation with responsibility of GL, AP, AR, FA, CM and EB-Tax modules R12.1.3 Oracle Applications E-Business Suite.

Responsibilities:

Worked with business users and IT on Requirement gathering for all the modules (GL, AP, AR, CM, AGIS, FA and Ebiz Tax.

Identified delta setups and Documented BR100’s and getting business sign off before configuring.

Configured the delta setups in system (end-to-end) for all the Modules.

Profile Options, P2P Enablement, Configuration Owner Tax Options, Tax Rules, Vertex-Org, Vertex Rules and testing.

Identified and created User Acceptance Testing (UAT) scripts.

Conducted User Acceptance Testing (UAT) and getting sign off.

Implemented bank statement interface and lock box receipts import process in Accounts Receivables.

Implemented EB-Tax module-based business requirement.

Implemented SLA configuration based on the client requirement and thoroughly tested all end to end process areas.

Implemented SEPA & Host2Host customization process to sending bank payment files.

Supporting Concur & Lock box related interface issues and configured and worked with development team in fixing and testing hot defects in these areas.

Configured AGIS setup for processing Intercompany Transactions.

Attending daily status call providing complete details to onshore team.

Analyzed the patches required and testing to ensure functionality.

Resolving issues, Cutover Activities, Go-Live and support.

Environment: Oracle Financials 12.1.3: GL, AP, AR, CM, FA, AGIS, and Ebiz Tax.

Client: Morning Star, IL

Duration: January 2014 to April 2015

Role: Oracle EBS Financials Functional Team Lead.

Project: Morningstar domestic Production Support US & Canada.

Project execution: Accenture.

Description: Responsible to Support US and Canada operating units R12.1.3 Oracle Applications E-Business Suite both ITA & R2R.

Responsibilities:

Supporting ITA & R2R modules in the offshore SR resolution and configuration changes and testing providing the solution with technical team.

Solving the Quick base tickets based on the priority.

Supporting Month end Reconciliation issues for both financial modules & service contacts.

Providing detailed documents to decreasing Business process related issues. This will help the business to reducing the time& cost.

Providing functional support to developing the GL EXT003 Custom form.

Implemented Fixed Asset SLA configuration based on the client requirement and thoroughly tested all end to end process areas.

Resolving the payment file process related issues.

Supporting Concur & Lock box related interface issues and configured and worked with development team in fixing and testing hot defects in these areas.

Setup the new Legal Entities based on client Requirement.

Creating the new tax code in the EB-Tax module-based business requirement.

Configured AGIS setup for processing Intercompany Transactions.

Preparing Functional design document to developing the custom reports and providing functional support to testing the developed reports.

Supporting Month end Reconciliation issues for both financial modules & service contacts.

Attending daily status call providing complete details for Daily assigned SRs.

Environment: Oracle Financials 12.1.3: GL, AP, AR, CM, FA, AGIS, Service contract and Vertex.

Client: Symantec, CA

Duration: April 2013 to December 2013

Role: Senior Oracle EBS Financials Functional Consultant

Project: Symantec Davanci (Implementation Project)

Project execution: Accenture.

Description: Symantec provide security, storage and systems management solutions to help our customers – from consumers and small businesses to the largest global organizations – secure and manage their information-driven world against more risks at more points, more completely and efficiently than any other company. By creating new Ledgers, Operating Units in R12.1.3 Oracle Applications E-Business Suite. Total 54 operating units implemented and supported.

Responsibilities:

Collected Business requirements for all the modules in-accord with the business users and IT. (GL, AP, AGIS, AR, FA, CM and Ebiz Tax-Vertex)

Worked closely with data conversion team and gathered requirement before configuring in system for their data conversion objects.

Identified delta setups, Documenting BR100’s, MD050 for RICE components and getting sign off before configuring.

Created 54 new Operating Units as part of disintegration for Symantec (Including sub ledger modules).

Created intercompany solution for new entity’s products.

Coordinated between on- onshore team for completing the configuration for Fixed Assets, AGIS, and Ebiz Tax modules.

Worked with Data conversion team on conversions and clean-up activities.

Identified and created CRP& UAT scripts.

Conducted CRP & UAT and resolved issues that raised during testing

Provided functional support while developing to Importing concur Invoice with secured credit card (Encrypted) Process for both employee expenses & Standard invoices for against Amex credit card suppliers.

While doing Amex credit card payment to developing Secured file process.

Provided functional support to developing custom reports based on client specifications.

Configured payment process templates for all test environments.

Co-coordinating with other technical teams and resolving technical issues.

Raising the SR’s IPM and other standard functionality related issues.

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.

Solved 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.

Executed Cut- over plan activities, prepared a list of all the Pre-& Post Go- live tasks with the team and provided production support with any conversion related issues until the end of ECP.

Go-Live and support.

Environment: Oracle Financials 12.1.3: GL, AP, AGIS, AR, FA, CM and Ebiz Tax-Vertex.

Client: Amex (OSI)

Duration: July 2010 to March 2013

Role: Senior Oracle EBS Financials Functional Consultant

Project: Production support OSI

Project execution: Syntel Ltd.

Description: American Express provides innovative payment, travel and expense management solutions for individuals and businesses of all sizes. Responsible for Level 2 support. Modules involved are GL, AGIS, AP, AR, OM, Service Contracts and Ebiz Tax-Vertex - R12.1.2 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 resolving 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: Artha Money, India

Duration: December 2009 to June 2010

Role: Oracle EBS Financials Functional Consultant

Project: Implantation & Production support

Description: Artha Financial Services Ltd., popularly called as Artha Money is financially powered by The Times of India Group. Artha Money is positioned as India’s leading financial supermarket and a one stop solution for a gamut of Personal Finance Solutions across India Implemented Oracle Financials 12.0.6 GL,AP,AR,CM & FA with India Localization.

Responsibilities:

Set up the Additional Information for Local service Tax purpose.

Set up the Tax code and Tax categories.

Developed data scripts according to the business requirements. Worked on resolving daily production support tickets and ensure the production problems are resolved within SLA for the support project.

Worked extensively on UAT and CAT testing for new functionality implementations. Worked on month end closing activities.

Prepared and conducted weekly status reports with IT and business stake holders on the Support and Project Progress.

Created and updated documentation logs for the resolved custom process issues as a sourced of reference

Interacted with Oracle Support to resolve Critical issues by raising various level severity Service Requests. Trained the Super users, IT team and Users on the new functionality and setups maintenance.

Environment: Oracle E- Business Suite R12.0.6. GL, AP, AR, CM and FA.

Client: Pfizer

Duration: August 2007 to November 2009

Role: Oracle EBS Financials Functional Consultant

Project: Implementation & Support

Project Execution: Thirdware solution Ltd

Description Pfizer is the world's largest research-based biomedical and pharmaceutical company. Implemented Oracle 11i in 36 countries on replacing their legacy systems to Oracle E- Business Suite 11.5 10.2.

Responsibilities:

As a Functional Consultant responsible for Implementation and support of GL, AP & AR, FA, PO & CM modules.

Testing of overall Application for various phases of the project: CRP, UAT etc. Troubleshooting issues related to Procure to pay business cycle with more responsibility on AP module.

Set-up Supplier, Supplier Sites and all additional vendor related information in Accounts Payables.

Worked on service requests and interacting with the Oracle Support using metalink. Established Best Practices” and plan for continuous improvement of processes. Trained the Super users, IT team and Users on the new functionality and setups maintenance

Arrive at a consolidated process document for the company operations in the areas of Invoice processing and Transactions Processing.

Based on the OCR’S we have to set up the GL, AP, AR, FA, and OPM modules.

Setup Multi-Org data as per OCR’S in the new Project and production environments.

Set up the descriptive flexi filed information based on P2P, R2R and O2C document.

Exposures to the various business processes followed by the Pfizer EFSS especially in procure to pay and Record to Report streams.

Solved the ticket based on the priority in all project environments changes.

Worked on QTP tool for inserting the data.

Data Migration from one instance to other instances using Integra Apps tool.

Implementing the RFC’S in Production environments.

Aligning the RFC’S in Project environments in weekly basis

Running the comparison report in between the environments and aligning the as per base instance.

Create the GL calendar, OPM Inventory calendar and cost calendar in Production and project environments.

Worked on Integra Apps testing and preparing test cases various scenarios.

Raising new tickets for various teams based on the requirements.

Worked on RFC’S for various production changes.

Preparation of Standard operating procedures (SOPs) relating with business flow specific to the company.

Worked on Multi-Byte character testing.

Defined set of books by using Chart of Accounts, Calendar Periods and Currency.

Taken care of Multi Company/Set of Books Consolidation.

Solved the CVR and Security Rule errors.

Created the end users and assigning the Responsibilities based on the user requirement.

Environment: Oracle E- Business Suite 11.5.10.2: GL, AP, AR, OM, FA, CM, OPM PO and Inventory

Client: KCLLICK NIXON Ltd., India

Duration: January 2004 to July 2007

Role: Accounts Executive

Responsibilities:

Maintaining the Stock Statements in the godown.

Preparing bills for Sales, Purchase Orders and sending Receipts to Dealers.

Maintaining Invoices, Cash Receipts and Outstanding statements to the dealers.

Adjustments of Credit Notes and Debit Notes of the Dealers.

Preparation of P&L A/c and Balance Sheets.

Managing& Monitory Mandatory Company accounting.

Extraction & Preparation of MIS reports of Sales & Marketing

Contact this candidate