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.

TECHNICAL SKILLS

Tools: Data Loader, TOAD, SQL Developer, SQL Plus, MS Word/Excel/Visio/ProjectERP 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

Confidential - Austin, TX

Sr. Oracle Business Analyst

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)

Responsibilities:

• 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.
• ConfiguringI-Receivablesfor 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.

Confidential - Phoenix, AZ

Sr. Oracle Business Analyst

Modules Handled: General Ledger, Account Payables, Expenses, iProcurement.

Responsibilities:

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

Confidential - Portland, OR

Sr. Oracle Apps Consultant

Modules Handled: GL, AP, AR, FA, CE, Oracle Payment, EB-Tax and SLA

Responsibilities:

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

Confidential - Princeton, NJ

Financial Functional Lead

Modules Handled: GL, AP, AR, FA, CE, Oracle Payment, EB-Tax and SLA

Responsibilities:

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

Confidential

Staff Consultant

Modules Handled: GL, AR, AP, FA, CE, Web ADI and SYS Admin.

Responsibilities:

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

Confidential Systems

Functional Consultant

Modules Handled: GL, AP, PO, INV.

Responsibilities:

• 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.
• Configured/setup AR, AP, i-Expenses and CE for one of the Operating Unit.
• Provided operational training to new users for AR, AP, i-Expenses, CE and Discoverer Reports.
• Designed, configured and implemented AR interface and XML invoice printing on pre-printed/pre-numbered stationery and few custom Reports/Processes.