Candidates About

 

 

 

Bhargav

Senior Consultant, Oracle Financials

Summary

§  Having 9+ years of experience in Oracle E-Business Suite/ERP that includes Full Life Cycle Implementations, Designing Solution and Supporting Onsite/Offshore Projects.

§  9+ years of Strong domain experience in accounting, finance, costing and taxation.

§  Subject Matter Expert(SME) of OracleR12, General Ledger (GL, COA, FSG), Accounts Payables (AP), Oracle Payment, Accounts Receivables (AR), Cash Management (CE), EB Tax, Fixed Assets (FA), Purchasing (PO), Oracle I-Procurement, Oracle i-Expense& i-Receivables& P-Card, ADI, Sys-Admin and Web ADI.

§  Good knowledge and working experience of Oracle R12 Order Management (OM), Inventory (INV), Workflow Administrator, Oracle Approvals Management (AME) and Costing.

§  Good knowledge and working experience of Reporting Tools like XML Publishers and Web Adi

§  Provided robust design and solution for unique business requirements.

§  Experience in gathering business requirements, performing gap analysis and designing solutions, Documentation, configuration/setup of Applications, Conducting/Tracking CRP testing, SIT, UAT, and PROD Cut Over.

§  Experience in production support, enhancements and roll-outs.

§  Worked on various help-desk/QA ticketing system like GHDS, Jira, QC.

§  Strong analytical and functional troubleshooting skills.

§  Proficient in Reconciling Sub-Ledger Applications with GL.

§  Have proven expertise in building efficient business processes and reports that has improved end-user productivity.

§  Experience in creating/maintaining Users, Responsibilities, Cross Validation Rules, Security Rules, Data Access, Multi-Org Access Control (MOAC), System Profile Options and Menus.

§  Experience of using Oracle SQL plus, SQL Developer, TOAD to extract the desired data from multiple tables for review of transactions and setup data to troubleshoot any issues related to Data and missing or incorrect setup.

§  Good knowledge of standard/Published API's (application program interfaces), data elements, tables and views which are the basis for troubleshooting, building Custom Interfaces, data conversion and reporting.

§  Team Leader as well as team player with good interpersonal and communication skills.

 

Educational Profile

 

 

§  Bachelor’s Degree from JNTUH, 2009

 

 

CERTIFICATIONS

 

•           Oracle Certified Professional in R12 Implementation Expert (Payable & GL)

 

 

 

Technical Education:

 

·         Trained by SQL Star, Hyderabad, India on Oracle Development Track.

·         Trained by NIIT, Hyderabad, India on MS Office and MS Access

 

 

Technical Skills:

 

Tools	:	Data Loader, TOAD, SQL Developer, SQL Plus, MS Word/Excel/Visio/Project
ERP	:	Oracle 11i and R12
ERP Modules	:	GL, AGIS, AP, Oracle Payment, AR, CM, FA, PO, OM, EB Tax, ADI, Web ADI, INV, Costing, System Administration, Oracle I-Expenses, Oracle Procurement, Workflow Administrator, Oracle Approvals Management (AME) and Application Developer

 

Professional Experience:

 

Motorola Mobility – Austin, TX                                                                             Nov 2016 to Till Date

Sr. Oracle Business Analyst

 

Project Type	:	R12 Production Support, Enhancements, Roll out and Projects
Modules Handled	:	GL, AP, CM, FA, Oracle Payment, EB-Tax, Oracle I-Procurement, I-Expense, Purchasing, Web ADI, System Administration, Workflow Administrator and Oracle Approvals Management (AME)

 

·         Involved in testing Multiple integrations along with outbound and Inbound Interfaces from different platforms like RMB & Metavance based on the design.

·         Performed the end to end regression testing along with the new organization.

·         Worked on end to end testing for P2P & O2C Processes for 12.1.3 upgrade (from 12.2.2) and resolved few upgrade issues.

·         Worked on CPU Patch Testing.

·         Configuring I-Receivables for customers so they can have access to the invoices balances and credit memos.

·         Functional Design for Customization of I-Procurement/I-Receivables Pages and End to End Testing.

·         Provided Functional assistance in the Implementation of I-Receivables and Advance Collections.

·         Involved in changing the process for Journal Approval Workflow & Attachment

·         Provided Production Support to resolve issues for P2P & O2C modules.

·         Worked on AP Invoice Interface and Reverse Feed of Payment through SFTP and other Processes.

·         Set up EB-Tax as per Tax requirement including the testing of the entire cycle.

·         Helped in Developing BI Report for reporting Tax Variance between Tax Amount Interfaced and calculated Tax Amount according to EB Tax setup.

·         Worked on Rolling out the P2P Sub-Ledgers process to newly created Operating Units including Setting up iProcurement and Catalog Punch out process.

·         Configured, tested and deployed the complete punchout process from Office max to Office Depot.

·         Helped User to resolve the Bank Reconciliation Issue.

·         Worked on Requisition Change Order Process (RCO) – Custom Process impacting PR, PO &AP, AME, Approvals/Notifications and Reporting.

·         Worked on Enhancements covering P2P and O2C modules.

 

 

 

Best Western – Phoenix, AZ (R12)                                                                 May 2016 to Oct 2016

 

Sr. Oracle Business Analyst

Project Type	:	Oracle Financials
Modules Handled	:	General Ledger, Account Payables, Expenses, iProcurement.

 

§  Experience in implementing lifecycle of Oracle procure to pay and Supporting Oracle financial Modules.

§  Having strong experience in Support Life Cycle, SLA management and working with Oracle Product.

§  Worked on Enterprise Configuration, Role Based Access Control, APM and BPM

§  Configured the Expense Report Templates and setup the corporate cards for employees.

§  Have worked on Punch-out request on Multiple Supplier Sites, helped configure and map the Item Categories to the supplier site categories.

§  Worked on gathering and documenting business requirements, leading fit-gap analysis, conference room pilots (CRPs) functional configuration, testing, client user training.

§  Good understanding of Sub-Ledger Accounting (SLA) and Taxes.

§  Understanding of File based data import and export.

§  Work directly with Business User as an Oracle Financials functional expert.

§  Configured the various project documents – Solution design, Functional Specifications, Setup Documents, SIT-UAT Test Scripts, Training materials.

§  As a business analyst I was involved in explaining the requirement to other team members in the project.

§  Created and executed test scenarios in various test environments.

 

 

 

 

Nike – Portland, OR (R12)                                                                          Aug 2015 to Apr 2016

 

Sr. Oracle Apps Consultant

 

Project Type	:	R12.1.3
Modules Handled	:	GL, AP, AR, FA, CE, Oracle Payment, EB-Tax and SLA

 

§  Documented the Current Business Process detailing the ‘AS IS’ process in their legacy system (Matavance), future business process ‘TO BE’ and performed GAP analysis

§  Interacted with the client team to understand the existing business practices and assisted in the preparation of business requirement definition document BR 30.

§  Created MD 50 for AP Check Printing & Remittance Advice

§  Defined different expense templates for different business requirements

§  Configured Punch-out and Non-catalogue request for I procurement.

§  Configured Invoice Approval using AME for Invoices that are not matched to Purchase Orders

§  Defined different payment process profiles for Check & EFT payments

§  Configured Approvals & Approval hierarchy in Purchasing for Requisition & Purchase Order Approval

§  Defined payment terms, distribution sets, matching tolerances for purchase order matching.

§  Defined both single currency and multi-currency bank accounts

§  Configured for integration of American Express Corporate Credit Card with i-Expenses & Accounts Payable

§  Strong Understanding of the Business processes, Procure to Pay (PP) and Order to Cash

§  Developed financial reports using FSG

§  Worked on entire Collections process and Collection Workbench.

§  Setup Dunning Letters to customers to generate and sent directly to email and Fax using bursting technology.

§  Created responsibilities with appropriate menu for users to restrict their access to application.

§  Provided Training to users, and Created User Manuals for PO, AP & I-Expense modules.

§  Provided Post-production support in the Procure to Pay Cycle.

 

 

 

 

 

Trimax Americas – Princeton, NJ (R12)                                                      Feb 2014 to Jul 2015

 

Financial Functional Lead – R12 Upgrade (From 11.5.10.2)

 

Project Type	:	R12.1.3 Upgrade
Modules Handled	:	GL, AP, AR, FA, CE, Oracle Payment, EB-Tax and SLA

 

·         Setup General Ledgers and related setup for CRP0 (POC) with Multiple Legal Entities (LEs) having more than one Balancing Segments and multiple Operating Units (OUs) under one ledger.

·         Setup Multi-Org Access control (MOAC) to access multiple OUs from one responsibility.

·         Configured/setup Suppliers, Banks, Oracle Payments, AP, EB-Tax (for Payables only) and SLA in Multi-org/Multi Currencies environment for CRP0 (POC) and for requirement gathering sessions.

·         Involved in conducting CRP0 (POC) and requirement gathering sessions.

• Provided support for month end closing, quarter end closing and reconciliation of Sub ledger with Oracle General Ledger

·         Worked on few enhancement and projects of 11i and R12

·         Provided Production Support to resolve issues of 11i & R12 financial modules.

·         Worked on roll outs of R12 financial modules (GL, AP, AR, Oracle Payment, FA and EB Tax) for EFT Payments (XML file), Check Printing (On Blank Stock).

·         Worked on R12 Oracle I-Expenses.

 

 

 

Apps Tree IT Services - Hyderabad, India                                                    Mar 2011 to Jan 2014

 

Staff Consultant – R12 New Implementation

 

Project Type	:	R12.1.3 New Implementation
Modules Handled	:	GL, AR, AP, FA, CE, Web ADI and SYS Admin.

 

·         Configured/setup GL, AR, AP, FA, CE and Inter Company in Multi-org/Multi Currencies environment.

·         Converted GL Balances for 3 years and reconciled with legacy ledgers.

·         Converted Fixed Assets (more than 3000 Assets) and reconciled with legacy Corp/Tax Books.

·         ­Involved in conversion of Suppliers, Customers and AR Transactions.

·         Created documents under UPK and trained Users for Oracle Financial processes/Web ADI.

·         Conducted CRPs/UAT and actively involved in PROD cutover.

·         Provided Go-live support for Financials Modules.

·         Involved in the cloning procedures and coordinated with the Data Base Admin team and updated the client as well as my team on day to day status of the project.

·         Defining Collector, Aging Buckets, Auto Cash Rule Sets and Assign to Customer Profile Classes, Defining Statement Cycles, set up the customers and customer profile classes, setting up Transaction types, Sources, Receipt classes and receipt sources, Setting up receivables activities, statement cycles.

·         Involved in the Design and configuring the auto accounting on basis of transaction types, assisted in setting up Invoicing rules, accounting rules, remittance banks, distribution sets, Set up system options and profile options

·         Involved in Configuring and Setting up Auto invoicing (Grouping Rules, Line Ordering Rules), Setting up Consolidates sales invoice based on client requirement.

 

 

 

Harshavardhana Systems, UK – (R12)                                                         Jun 2009 to Feb 2011

 

Functional Consultant

 

Project Type	:	R12, Support & Enhancements.
Modules Handled	:	GL, AP, PO, INV.

 

·         Involved in 12.1.2 Upgrade from 12.0.4.

·         Involved in setting up custom Edit Rules based on Segment values, Journal Categories and Responsibility.

·         Provided operational training to users for GL, Web ADI, AR, FA and Custom Reports.

·         Provided Production support for GL, AR, FA, CE, Web ADI, and Reports in multi-currencies environment.

<p class="MsoN