Resume

Sign in

Oracle Support

Location:
Hoboken, New Jersey, United States
Posted:
March 12, 2019

Contact this candidate

Resume:

Rakesh Sirigiri

Oracle Functional Consultant

Oracle Financials - GL, AP, AR, CM, BRM, FA, iExpense, e-Biz Tax, SLA

Implementation / Upgrade / Customization / Support / Training (R12 & 11i)

Email:ac8riu@r.postjobfree.com

Phone: 402-***-****

EXPERIENCE SUMMARY

●Over Eight years’ experience in complex IT projects as a Senior Oracle Developer covering critical business issues and heterogeneous technologies.

●Eight years of experience as a Functional/Business Analyst in Implementation, Upgrade and Production support of Oracle ERP Financial suite including Oracle General Ledger, Payables, Receivables, BRM Project Costing,Assets, Advanced Collections, Revenue Management Cash Management, Federal Vertical and Internet Expenses modules, R12 EBizTax, SLA and MOAC.

●Proficient in AGIS, GIS, GCS, Multi Org concepts, MRC setups and Flex-field concepts of Oracle Apps. Experience with Oracle AIM documents and implementation practices, covering Business Process Architecture (BP), Business Requirements Definition (BRD), and Business Requirements Mapping, Module Design & Build (High level/Functional – MD50, and Detailed – MD70) documents, expertise in GAP Analysis. Worked with the users for solving technical and functional issues, experience in developing and implementing Test Strategy for Functional (Unit, Integration & UAT) and Regression testing environments.

●Experience in Implementation / Upgrade / Customization / Support / Training of R12 and 11i.

●Expertise in Reconciliation and Testing of of Sub-ledger modules with GL, BRM with Solid grasp on the basic table structure of Financial Modules, expertise in creating Financial Reports with Financial Statement Generator (FSG), proficient in Training Documentation & Delivering the Training to the End Users on Oracle Financials, solid experience in designing and implementing functional/technical specifications for the financials modules, Good understanding of Databases, Operating Systems and programming concepts. Experience in Customizations/New Development of Oracle Reports,Interfaces,Conversions and Extensions/Enhancements (RICE)

●Functional Testing with Strong analytical, diagnostic and troubleshooting skills with the ability to work in a fast-paced and team-oriented environment. Entrepreneurial, value based approach with the flexibility to act as a leader, team player

TECHNICAL SKILLS SUMMARY

Oracle Apps

GL, AGIS, FV, AP, AR, FA, BRM,AC, Revenue Management, CE, iExpense, Purchasing, Inventory, AOL, Desktop Integrator & SYSADMIN

Oracle Technologies

SQL, PL/SQL, SQL *Loader, Tuning, Discoverer, Reports, Winscp, Putty, Toad

Operating System

Other Tools

Windows XP, 7, Vista, UNIX.

MS Office, MS Project, MS Visio, MS Visual Studio, Citrix, Share point, Service Desk Manager, HTML, CSS.

Project: R12 Implementation and Production Support Dec-18--Present

Client: Marvel Entertainment LLC, New York, NY

Role: Oracle Techno-Functional Consultant

Environment: Oracle Applications 12.1.3 with GL, SLA, AP, AR, CM, PO, I Expense

Responsibilities:

Worked with Developers and Business Analysts to understand the Requirements, Functional Design and Technical Design.

To work with Technical Core Team to perform functional testing and support the regression testing & UAT testing during the testing phase.

Execution of Test Cases in Projects Module that includes creation of various types of Projects, Formatting as per the various structures followed for projects modules.

To coordinate Functional testing, UAT testing and Regression testing during the pre/post- migration patch activities.

To support AP, AR, GL, PA interfaces and various setups involved.

Execution of Unit Testing for the interfaces being developed for Accounts Payables, Accounts Receivables, General Ledger and Project Accounting modules.

Quick in PL/SQL queries in order to fetch data as per needs for analysis purposes.

Supplier Migration Testing involving creation of invoices for the migrated suppliers.

Actively involved in the preparation of the Test Plan and the Test Strategy.

To create reports and ad- hoc sql queries and extracts based on tables in AP, AR, GL and PA modules.

To configure any new SLA rules to meet the business demands for specific accounting in Payables and Projects.

Tested the custom reports in AP, AR, GL and PA.

To schedule various concurrent programs, request sets and reports to run on a specified time, without any interdependence of other standard programs using Sys Admin responsibilities.

Preparation of the Test Cases for Functional, Performance, Volume, Load and Database Testing across AP,AR, GL and PA modules.

Testing the CEMLI Objects in the modules AP, AR, GL and PA.

Communicated with the Client in Understanding the Requirements and the Change Request.

Tested the personalization in the modules AP, AR, GL and PA.

Responsible for the checklist verification and Release sign off.

Communicating with the Offshore Team in Daily calls to get the status of all the Test Cases and Defects.

Testing all the test cases for the AP, AR, GL, PA to Oracle interfaces and testing the concurrent programs that loads the data in to interface tables and the spawned programs that imports the data in to Oracle, further testing the data to migrate to SAP.

Validated the imported data in Oracle by executing different test cases for invoices, projects.

Validated different file formats based on the file specifications.

Loaded additional information for Invoices, Projects into Oracle Apps as per the requirements.

Validated different profile options, lookups, value sets, email notification formats after the loads as per the BR100 documents for AP, projects.

Understand all the Functional Specification Documents related to Projects, Hierarchy Clean-up, and Journal Import and Posting, Open and Close posting, Reversals and Adjustments.

Execution of distinct concurrent program requests/request sets in EBS and verified if everything was loaded properly or not into SAP.

Testing the data conversions from 3rd party applications in to GL.

Preparing the test cases for Journal import inbound interfaces and validated them in Oracle.

Validating different test cases and scenarios for AP Remittance Inbound Interface.

Project: R12 Implementation and Production Support Aug-18 –Nov-18

Client: Fruit of the Loom Inc., Bowling Green, Kentucky

Role: Oracle Functional Consultant

Environment: Oracle Applications 12.1.3 with GL, SLA, AP, AR, CM, PO, I Expense

Responsibilities:

●Performed analysis on the General Ledger, Accounts Receivables, Accounts Payables, Purchasing, I-Expense and Cash Management

●Delivered documentation to gather the user requirements for new features, developed detailed test scenarios and test scripts.

●Customized Sub Ledger Accounting rules to meet the business requirements.

●Coordinated with users in multiple locations for requirement gathering and user training.

●Worked on functional requirement gathering for building staging table to bring the data from Kofax interface for multiple invoice types to the interface tables further processing of data to the base tables

●Implemented AME workflow for AP invoices in R12.

●Maintenance of Issues Log for reporting the status of the issues and conducting issue status meetings on weekly basis.

●Scheduled various concurrent programs and reports to run on a specified time daily without interrupting other standard programs using System Admin Responsibilities.

●Follow up of team members for the completion of tasks and any queries related.

●Prepared documentation for the custom reports.

●Support for AP, AR, GL, Purchasing, Cash Management, I-Expense related tickets and various setups involved.

●Responsible for diagnosing the root cause analysis of the support issues observed to avoid recurrence of such issues in the future

●Responsible for diagnosing the payment batch issues occurred due to multiple scenarios, prepared Functional Design Document (FDD) for the same.

●Worked on User Admin, Sysadmin tasks.

●Coordinated Functional testing, UAT testing and Regression testing during the pre/post-migration patch activities.

●Quick in SQL, PL/SQL queries in order to fetch data as per user’s needs for analysis purposes.

●Supporting production environments and users on daily basis by responding to ad-hoc requests.

Project: R11 Upgrade and Support Jan-18-Jul-18

Client: News America Marketing Inc, Wilton, Ct

Role: Oracle Techno-Functional Consultant

Environment: Oracle Applications 11.5 with AP, AR, GL, INV, OM

Responsibilities:

●Worked as a technical lead to provide support in cloud project as well as support to EBS R11 applications.

●Worked on Chart of Accounts mapping that needs to be migrated to Cloud.

●Performing various tasks in Oracle Applications as a System administrator, Workflow administrator, Technical Support.

●Worked on workflow mailer, payment batch issues to have a clean data to be moved to cloud.

●Worked on required request list items and reports for SOX compliance and audit purposes.

●Support for Payables, Receivables, GL related tickets and various setups involved.

●Documented the MD050 requirements for AS IS process of EBS auto invoicing process,

●Documented the MD050, MD070 for Vendor, Customer Deactivation.

●Worked on Customer, Vendor data cleanup for the data migration to cloud.

●Created codes to perform customer and vendor deactivation as per the business requirement.

●Interacting, participating in business meetings, designing and coordinating with business personnel.

●Created reports and ad-hoc SQL queries and extracts based on tables in AR, AP and GL modules.

●Maintenance of Logs for Issues resolved/working on for reporting purposes.

●Performed UAT testing and Regression testing during the pre/post-migration activities.

●Supported production environments and users on daily basis by responding to emergency requests.

●Issue resolution using Oracle Support, creation and follow up of Service Request with Oracle.

Project: R12 Implementation and Support Feb-17 –Jan-18

Client: UPS, Parsippany, NJ

Role: Oracle Developer

Environment: Oracle Applications 12.1.3 with GL, SLA, E-BizTax, AP, AR, FA, CM, PO, INV, OM.

Responsibilities:

●Implement new functionalities in R12 as per the business requirements. Documented all requirements and Future TO BE Processes for new features.

●Configured New SLA rules to meet the business demands for specific accounting in Payables and Receivables.

●Interacting, participating in business meetings, designing and coordinating with business personnel.

●Modified/ Enhanced E-Business Tax Rules for AR and AP.

●Documentation : Future Business Model (BP 080), setup Documents (BR 100), Test Scripts TE20/40

●Building of interfaces with third party applications to Oracle

●Creating one-time reports and ad-hoc SQL queries based on tables in AR, AP, GL modules.

●Resolved Create accounting issues based on different scenarios, event models

●Resolved UPS to HUB process conversions and interface which in general transfers batches from AP to GL.

●Performing various tasks in Oracle Applications as a System administrator, Workflow administrator, Alert Manager, Trading Community Architecture, AOL administrator

●Development of xml publisher reports, oracle reports and OAF personalizations and extensions.

●Support for Payables, GL related tickets and various setups involved.

●Issue resolution using Oracle Support, creation and follow up of Service Request with Oracle.

●Created code fixes in the existing package bodies to resolve the issue with journal entry batches.

Project: R12 Implementation and Production Support Aug-16 -Dec-16

Client: Marsh & McLennan Companies, Hoboken, NJ

Role Oracle Functional Consultant

Environment: Oracle Applications 12.1.3 with GL, SLA, E-BizTax, AP, CM, PO, iExpense

Responsibilities:

●Delivered my best in maintaining and distributing the workflow by being a Queue Lead for AP, Revenue Billing & iExpense modules in US shift through the ticketing tool.

●Acted as a key member for AP, E-Biz Tax, iExpense thus played a significant role in stabilization of the application.

●Performed analysis on the General Ledger, BRM, Payables, E-Biz Tax, iExpense and Cash Management

●Delivered documentation to gather the user requirements for new features. And developed detailed test scenarios and test scripts.

●Customized Subledger Accounting accounting rules to meet the business requirements.

●Coordinated with users in multiple locations for requirement gathering and user training.

●Implemented AME workflow for AP invoices in R12.

●Configured E-Business Tax in R12 and eliminated some custom PL/SQL using rules.

●Maintenance of Issues Log for reporting the status of the issues and conducting issue status meetings on weekly basis.

●Follow up of team members for the completion of tasks.

●Prepared documentation for the custom reports.

●Support for AP, BRM E-Biz Tax related tickets and various setups involved.

●Responsible for diagnosing the root cause analysis of the support issues observed to avoid recurrence of such issues in the future

●Responsible for diagnosing the Trax issues related to payments occurred due to multiple scenarios, prepared Functional Design Document (FDD) for the same.

●Worked on User Admin, Sysadmin tasks.

●Coordinated Functional testing, UAT testing and Regression testing during the pre/post-migration patch activities.

●Quick in SQL, PL/SQL queries in order to fetch data as per user’s needs for analysis purposes.

●Supported production environments and users on daily basis by responding to emergency requests.

Project: R12 Implementation and Support Mar-14 – July-16

Client: Hertz Corporation, Oklahoma City, OK

Role: Oracle Functional Consultant

Environment: Oracle Applications 12.1.3 with GL, SLA, E-BizTax, AP, AR, FA, CM, PO, INV, OM.

Responsibilities:

●Implement new functionalities in R12 as per the business requirements. Documented all requirements and Future TO BE Processes for new features.

●Configured New SLA rules to meet the business demands for specific accounting in Payables and Receivables.

●Modified/ Enhanced E-Business Tax Rules for AR and AP.

●Documentation : Future Business Model (BP 080), setup Documents (BR 100), Test Scripts TE20/40

●Creating one-time reports and ad-hoc SQL queries based on tables in AR, OM and GL modules.

●Created accounting rules, event models and month-end period close using Oracle FAH.

●Production support – month-end reconciliation, interface issues, support enhancements, ad-hoc reports, bug fixes.

●Setup of Policy schedules such as Accommodations, Meals and Entertainment, Rental Car, Airfare, Mileage, Relocation, other travel expenses as part of iExpense roll out

●Support for iExpense related tickets and various setups involved.

●Implemented Automatic approvals of expenses reports based on certain criteria.

●Random audit was enabled for iExpenses to meet the audit requirements of the Payables/Internal audit.

●Implemented iExpenses and iprocurement as part of R12 Project.

●Configured the Expense Policy as per the client requirements and also customized some of the expense entry pages to default certain values based on the employee designation.

●Issue resolution using Oracle Support, creation and follow up of Service Request with Oracle.

●Review and Resolve Reconciliation between subledger and general ledger.

●Assist in new users in understanding the modules and other day to day activities

●Periodic User Training for all employees.

●Level 1 Support to All financial users.

●Responsible for diagnosing the root cause analysis of the support issues observed to avoid recurrence of such issues in the future

●Functionality of Revenue recognition has been configured by setting up the organization wide policies in revenue management and in specific cases configured the rules for specific customers/customer classes.

●Assisted in Sarbanes-Oxley compliance reviews for data security.

●End user training for using ADI.

●Worked on User Admin, Noetix Views Admin & Discoverer Admin tasks

Project: R12 Implementation and Support Jan-2013 to Feb-2014

Client: C&S Wholesale Grocers, Keene, NH

Role: Oracle Functional Consultant

Environment: Oracle Applications 12.1.3 with GL, SLA, E-BizTax, AP, AR, FA, CM, PO, INV, OM.

responsibilities:

●Key member and Lead in solving production issues.

●Worked on multiple enhancements for accommodating changes per the business requirements.

●Worked on created and issues resolution on Purchasing i.e. Purchase Order, Receipts, Requisitions.

●Resolved issues in Purchase Orders.

●Worked on Order to Cash. Resolved issues as well.

●Solved issues with Sales Order in Order Management (OM).

●Worked on Revenue Recognition process.

●Good working knowledge on invoicing rules and Accounting rules.

●Experience with Data Quality Management (DQM), Trading Community Architecture (TCA).

●Resolved issues with Customer Master, Invoice interface, Customer Interfaces.

●Worked on Lockbox enhancements.

●Resolved critical issues caused due to problem with Direct Debit files and Lockbox files.

●Supported production environments and users on daily basis by responding to emergency requests.

●Experience with MOAC Multi-Organization Access Control, Security Profile.

●Designed, coordinated development tested and resolved issues Customer Statements to suit different business needs.

●Defined Strategies, Scoring Engines to handle delinquent customers in Advanced Collections.

●Customized Subledger Accounting per the business requirements in both AP and AR.

●Worked round the clock during AR, AP Period close process.

●Designed interfaces to accommodate customer accounts/invoices for various business requirements.

●Quick in SQL, PL/SQL queries in order to fetch data per user’s needs for analysis purposes.

●Worked on Custom reports massively in order to accommodate different columns from customer accounts, customer transactions, receipt applications, tables etc.

●Have setup Transaction sources and types, Memo lines, Receipt Methods per business needs.

●Worked on Cash application (AR Receipts) customizations and enhancements.

●Resolved Lockbox, custom cash application, receipt netting, AP AR netting issues.

●Worked on several reconciliation issues.

●Worked on Payment reconciliation with Cash Management.

●Worked as a functional analyst for the implementation of Projects (Costing/Billing).

●Have configures Project Templates, Tasks, Transaction Controls, Cross Charges, Bill Rates, Rate schedules.

●Designed Change Requests (CR), Functional Design Documents (FDD) and Technical Design Documents (TDD) for any enhancement.

●Was extensively involved in decision making regarding the development needed to be done based on the business needs.

●Solved issues during AP Invoice and AR Invoice import, Customer and Supplier outbound.

●Also resolved issues during Auto Invoice, Auto Lockbox processes.

●Worked on issues related to Balance Forward Billing.

●Designed various classification lookups and mapping per the business need.

●Worked on Vertex integration with Oracle.

●Resolved issues encountered by Tax calculation in Vertex.

●Coordinated Functional testing, UAT testing and Regression testing.

●Created MD50s, Test Scripts, Change requests for the enhancements and change requests.

●Documented processes through MS Visio, MS PowerPoint.

Project

: R12 Upgrade and Support Feb 11 – Dec 12

Client

: Dish Network, Denver, Colorado

Role

: Oracle Financials Functional Consultant

Environment

: Oracle Applications 12.1.1

Worked as Functional Consultant on Oracle Financial modules GL, AP, PO and iProc, AR, CM, FA and iExpense modules. Resolving the issues brought-up by the users and raising the SR (TAR)s and following up with Oracle Support for product related issues. Interacting with the users and prepared functional specifications for the customization of the reports. Raising Service Requests (SRs) with Oracle for product related issues and resolving issues by applying the patches or data fix.

Responsibilities:

●Acted as key member in R12 upgrade and thus played a significant role in stabilization of the application.

●Performed analysis on the impact from current version of 11.5.10.2 to R12 upgrade for General Ledger, Payables, Receivables and Collections, Assets and Cash Management.

●Delivered documentation to gather the user requirements for new features. And developed detailed test scenarios and test scripts.

●Implemented new features in R12 Cash Management Module to use multiple sources for reconciliation of same BAI codes.

●Customized Subledger Accounting’ accounting rules to meet the business requirements.

●Provided online details for each customer group through advanced collections customizations and statements to customers.

●Coordinated with users in multiple locations for requirement gathering and user training.

●Implemented AME workflow for AP invoices in R12.

●Configured E-Business Tax in R12 and eliminated some custom PL/SQL using rules.

●Created FSG reports for consolidation of multiple legal entities.

●Maintenance of Issues Log for reporting the status of the issues and conducting issue status meetings on weekly basis.

●Configured AGIS for intercompany billing.

●Follow up of team members for the completion of tasks.

●Prepared documentation for the custom reports.

●Implemented iProc and iExpenses as part of R12 upgrade to use new features.



Contact this candidate