PROFESSIONAL SUMMARY:

• IT Professional with overall 8+ years of experience on Oracle Applications (E - Business Suite) experience on financial modules across various versions of Oracle Applications including R12.1.3, 11.5.10 and 11.5.9
• In depth knowledge of Oracle Financials, Procure to Pay, Order to Cash, and self Service Modules iProcurement, iExpenses)
• Designed and developed reports using BI Publisher for EB taxmodule.
• Expert in Functional analysis, Gap analysis, Business Process and testing.
• Well experienced in preparing AIM documents (BR100, MD50s)
• Vast production support experience in Financials and Procure to pay modules and Month issues.
• Experience in system analysis, configuration, documentation, testing, user, technical support and maintenance of information systems with emphasis in generating implementation documentation e.g. process flow, process mapping, functional gap analysis documentation etc.
• Skilled in eliciting user demands and translating them to data, functional and usability requirements.
• Experience in supporting the production system and handling day-to-day issues.
• Worked extensively on on-site offshore model and good expertise to guide, coordinate and assist team members to provide deliverables.
• Great learning skills to adapt to rapidly changing technology and implementing the same at work.
• Proficient in documentation and end users on Oracle Financials.
• Extensive experience in working in varied reporting environments including both Relational and Multidimensional databases.
• Strong analytical, leadership, teamwork, inter-personnel, problem-solving skills and proven ability to work under pressure.
• Expert liaison with Business in understanding the business requirements and translating the same as functional specification
• Experience in conducting sessions, coordinating & assigning the daily task to offshore, participating in status meetings, defect tracking, test signoffs, handling production issues and client escalations etc.
• Proficient working in Production Support, handling Change Requests and development of new business requirements.

TECHNICAL SKILLS:

Oracle Applications/Primary Modules: R12.1.3, 11.5.10, 11.5.9 HRMS, GL, AP, PO, AR, FA, AME, Cash Management and SLAiProcurement (Oracle Financials)Oracle Management/Utilities/Tools: SQL* Plus, Toad, SQL Navigator, SQL Developer

Methodology: Oracle Application Implementation Methodology

BFA Process Flows: Procure to Pay, Order to Cash

PROFESSIONAL EXPERIENCE:

Confidential, Foster City CA

Oracle Business Analyst /Oracle financial Functional Consultant

Responsibilities:

• Part of the team responsible for financial modules
• Responsible for functional design and End to End Order to Cash process for Credit card transactions in Receivables
• Responsible for functional design and End to End process for Credit card transactions in Receivables
• Responsible for setting up integrated payables with Comerica
• Responsible for setting up Check, Wire, ACH payments in Oracle Payments
• Part of the Team that set up the Complete Procure to Pay Cycle
• Responsible for setting up AP/AR Netting functionality
• Integrated Oracle receivables with Revenue engine using Auto Invoice for external Invoices
• Responsible for setting up Automatic receipts functionality for Credit Card transactions
• Responsible for setting new lockbox process for Comerica
• Responsible for customizing AME for Invoice Approval process
• Responsible for integrating client services with receivables for creating customers and attributes
• Defined currency translation, conversion, revaluation and set the profile options for GL.
• Defined Payment Terms, Payment Set ups and Distribution Sets
• Developed Functional design documents.
• Create & updating BR100 / setup documents for GL & AP.
• Prepared Integration & Customization Unit Test Plans & supported Business / Functional users in testing Integration with Oracle GL, Purchasing & Oracle Payables Applications.
• Designing of user-manuals for the modules and the end users
• Providing post production support to the business users
• Trained Super Users and troubleshooting during UAT (User Acceptance Test).
• Developed cross-validation rules
• Responsible for set-up accounting period types and accounting calendars
• Set up AP bank accounts, bank documents, bank codes and expense report templates
• Set up suppliers, locations, and purchasing.

Confidential, Oakland CA

Functional Consultant

Responsibilities:

• Working on Oracle modules covering: Procure to Pay (P2P), Oracle General Ledger (GL),, Oracle Advanced Collections, Accounts Receivables (AR) and System Administrator,
• Responsible for coordinating and leading the entire phase of the P2P part of the project which included initial operations analysis, business process re-evaluation, preparation of configuration and set up document and testing for Accounts Payable, Cash Management, Purchasing and iExpense module.
• As an Oracle Finance/HR system analyst, providing guidance and instructions to the team members on a daily basis. Turned around customer relationships between IT and the business.
• Resolved many long standing HR issues after joined the company. Turned around HR so the business users are realigned with IT.
• Involved in designing & integration testing of outside processing process (OSP) related to Purchasing, Procurement, & Costing cycle
• Responsible for key business requirements to support the implementation of a Procure to Pay solution implementing Oracle iProcurement to manage purchase requisitions and purchasing approvals SR updates using AME and coordination with Oracle to solve critical severe issues
• Several OA Framework customizations in iSupplier portal pages.
• Designed interfaces and responsible for data conversion programs for Purchasing and Payable track.
• Addressing Operational issues, concerns and questions by users and providing for them on GL,AR,AP and FA
• Supported Auto Invoice Issues, Lockbox Issues, Month end close in AR
• Supported ACH and positive pay Issues in Payables
• User, bug fixes month end close Issues
• SR updates and coordination with Oracle to solve critical severe issues
• Internal Requisitions and Internal Sales Orders.
• Requirements gathering, fit/gap analysis and process flows.
• Configuration and documentation (BR100).
• Prepared test scripts of all sub-process identified in assessment phase.
• Responsible for unit testing execution for each business process in Procure to Pay track of my project.
• Experience with setting up of Transaction Types (Invoice Types), Auto Accounting Setups, Auto lock box Auto invoice process, Grouping rule, Invoice Types, AR Batch sources, Remit To addresses, Receipt Classes and Payment Methods, Adding and Maintaining Suppliers and Customers etc.
• Worked complex issues relating to month end and year end schedule.
• Set up new chart of accounts

Confidential, San Jose CA

Functional Consultant

Responsibilities:

• Oracle R12 Applications Modules: GL, AP, AR and CM
• Advance Global Intercompany (AGIS),
• Production Support after GO Live
• Areas Supported GL, AP, CM, FA, Payments and Web ADI
• Addressing Operational issues, concerns and questions by users and providing for them on GL,AR,AP,FA and CM
• Design, Develop, Customize and enhancement in theHRMS Application
• Supported Auto Invoice Issues, Lockbox Issues, Month end close in AR
• Supported ACH and positive pay Issues in Payables
• User, bug fixes month end close Issues
• SR updates and coordination with Oracle to solve critical severe issues
• Intercompany process for Multi-org IR/ISO and Intercompany dropship sales orders.
• Internal Requisitions and Internal Sales Orders.
• Configuration and documentation (BR100).
• Production support and issue resolution for all Oracle modules.

Confidential, Sunnyvale CA

Functional Consultant

Responsibilities:

• Responsible for requirements study, interaction with business users, preparing design documents, for Implementation project for new organization in Multi org environment
• Conducted business process review and gap analysis to determine business requirements
• Implemented requisition (PR) approval process using AME rules based on Dollar amount and purchase categories
• Responsible for setting up ACH and Check functionality using Oracle Payments with Bank of America
• Responsible for setting up Payables system options and Invoice Approval process
• Provided test scripts for various functional scenarios in end to end system testing, purchase requisition approval rules and functional extensions.
• Prepared setup documents for General Ledger, Purchasing, Payables and Fixed Assets modules
• Responsible for daily support and month end close.

Confidential

ERP Functional Consultant

Responsibilities:

• Coordinator and team lead for entire phase of the P2P part of the project. It included initial operations analysis, business process re-evaluation, preparation of configuration and set up document and testing for Accounts Payable, Purchasing and iExpense module.
• Worked complex issues relating to month end and year end schedule.
• Prepared BR100 / setup documents for GL & AP
• Providing post production support to the business users
• SR updates and coordination with Oracle to solve critical severe issues
• Prepared and executed Unit Test Plans and test scripts for Oracle GL, Purchasing & Oracle Payables Applications.
• Designing of user-manuals for the modules and the end users
• Trained Super Users and troubleshooting during UAT (User Acceptance Test)
• Ensure all the incidents (related to Process) raised on the gatekeeper are picked up and timely resolution for incidents raised has been provided to the customer.
• Managing monthly outages and ensuring system availability to all the users.

Confidential

ERP Functional Consultant

Responsibilities:

• Completed an Implementation of Oracle Application 11.5.10.2 (iExpense and Payable modules)
• Completed and validated all necessary setups, end-user and documentation associated with the Implementation.
• Designed and tested various test business case scenarios, system testing and integration testing for various business flows.
• Setting up signing limits & various iExpense expense report templates needed as per the business.
• Debugged issues faced while iExpense approval.
• Debugging various bugs in Oracle Payables system.
• Validated the setup on Payables like Invoice, Payment, Define Bank, Payment Terms, Distribution set etc.
• Responsible for defining Employee as a Buyer, Locations, Supplier & Site Info, Approval Groups & Assignments, and Self Billing for ERS invoices.

Confidential

ERP Analyst

Responsibilities:

• Production Support after GO Live
• Areas Supported GL, AP, AR, Purchasing, iProcurement, AME
• Addressing Operational issues, concerns and questions by users and providing for them on GL,AR,AP
• Involved during the analysis phase and measuring the business impact and functional changes with respect to Accounts Payable (AP) and General Ledger (GL).
• Involved in testing phase of newly installed functionalities for financials.
• Provided necessary functional specifications for customizations.
• Involved in testing the customization.
• Prepared MD050 documents for new reports and customizations based on user requirements
• Responsible for working with business users for month end close and reconciliation Issues
• Responsible for daily support on Financial modules, Payables, iPurchasing and General ledger
• Worked with banks for file Issues related to lockbox and bank statements.
• Worked with developers and functional consultants in Integrated testing and configuration testing
• Part of the Business team responsible for testing all the new reports and customizations in UAT.
• Prepared test scripts and data for UAT testing.
• Responsible for reporting Bugs and Issues in Bridge (Issue tracking tool).