SUMMARY:

• Been a member of the Functional focus team and about 8.7 years of IT experience, with a primary concentration on Oracle ERP/CRM implementations and business process re - engineering.
• Functional Consultant specializing in Oracle Application implementations, specifically Financials.
• Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities.
• Experience with Oracle Business Accelerators for e-Business Suite Release 12.
• Experienced in working with Oracle Applications Release 12
• Experience with US, French GAAP principles
• Possess strong knowledge of Financial modules of AP, AR, GL, SLA, Cash Management, CRM, Vertex, e-Business Tax combined with a unique combination of their integration with other modules like Order Management, Purchasing, Advanced Pricing, Shipping and Oracle Discoverer.
• Extensive experience with the Financial, Order to Cash and Procure to Pay business flows.
• Formulated solution design and implementation strategy based on client requirements.
• Configured the application based on solution design, performed gap analysis and designed workaround solutions.
• Trained the clients’ super users on the application and conducted pilot testing, integrated testing.
• Design validation & Setups of OM, INV, AR, Advanced Pricing PO, AP, GL, SLA, FA, Cash Management and Shipping modules.
• Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
• Experience in preparing Requirement Analysis Documentation, Training scripts, Functional Documentation, User Training Documents and Customization Documents.

TECHNICAL SKILLS:

ERP: Oracle Applications R12, 11i

Modules: AP, AR, GL, SLA, Cash Management, Purchasing, i-Procurement, i-Supplier, Sourcing, Procurement Contracts, CRM, Vertex, e-Business Tax

PROFESSIONAL EXPERIENCE:

Confidential, Clearwater, FL

Finance Functional Consultant

Responsibilities:

• As a Functional Consultant implemented the Financial Modules including Oracle Accounts Payables, General Ledger, Purchasing, i-Procurement, Inventory, Accounts Receivables, E-Biz Tax modules
• Performed Requirement and Gap analysis for the Procure to Pay Track
• Configurations and Setups for Oracle Accounts Payables, Purchasing, i-Procurement, General Ledger, Accounts Receivables
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for Supplier Invoices, Customer Invoices, Purchase Orders, Sales Orders, Items and Receipts in AR module
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on setting up the Approval Hierarchies in Purchasing Module.
• Worked on the setups of Punch Out’s in Oracle i-Procurement
• Worked on the setup of catalogs in oracle i-Procurement
• Worked on setting up content zones in Oracle i-Procurement
• Worked on the setups of the Approved Supplier Lists in Oracle Purchasing
• Configured the sourcing rules in Oracle Purchasing.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module.
• Worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
• Worked on the Auto Lock Box process in AR.
• Worked on the Revenue Recognition process in AR Module.
• Developed custom solutions for Support site.
• Responsible for all the Cut over tasks for Licensing and SFDC modules.
• Performed ITFT and UAT testing on various instances and reported bugs.
• Worked on testing the Procure to Pay flow for various products (Hardware / Software /Subscription).
• Tested Support site for various customer accounts linked with various products.
• Worked closely with Developers team for different issues / bugs during each phase of testing.
• Responsible creating orders for various Hardware/ Software/ Subscription products as part of testing the process flow for Licensing.
• Tested Licensing and Support Site UI.
• Developed the Functional Specification Documents (FSD) and Technical Specification Documents (TSD) for all of the customizations and data conversions.
• Worked on the configurations of Advance Pricing and Shipping.
• Reviewing Functional Specifications / Change requests with the client.
• Communicating the requirements to the technical team
• Preparing design document as per the functional requirements
• Preparing System / Integration Test cases and carrying out Integration testing
• Supporting the users with the User Acceptance Testing (UAT)
• Taking part in the review of test cases and giving necessary inputs.
• End-user training

Environment: Oracle e-Business Suite 12.1.3, Oracle AP, Oracle i-Supplier, i-Procurement, Oracle i-Expense, Oracle Time and Labor, Oracle General Ledger and Procure to Pay, PL/SQL, UNIX and Oracle 10g.

Financials Functional Consultant

Responsibilities -

• Responsible for the complete setup of AR, AP, Purchasing, i-Procurement, Inventory, GL, FA and Sabrix in Test and Production instances.
• Performed Fit gap analysis & proposal of Solution.
• Prepared all the Functional Specification Documents (FSD), Business Requirement Documents (BRD) and Data Mapping Documents (DMD) for Sabrix and Oracle systems.
• Worked on the Functional Mappings for data conversion for Supplier Invoices, Customer Invoices, Purchase Orders, Sales Orders
• Worked on the setups of Purchasing module - defining the Approval Groups, Approval Limits, worked on setting up the approval hierarchies, worked on the setups of the Purchasing and Financial options, defining the match tolerances, etc.
• Worked on the setup of the Sourcing in oracle Purchasing module - defining the Approved Supplier Lists (ASL), setting up the sourcing rules and defining the BPA.
• Worked on Oracle i-Procurement - defining the Punch Outs, setting up catalogs, supplier hosted catalogs, content zones, shopping carts, etc.
• Worked on the Inbound Purchase Order (POI/850/Orders)
• Worked on setting up Trading Partner Link to e-Commerce Gateway
• Worked on the Inbound Purchase Order Change (POCI/860/ORDCHG)
• Worked on the Inbound Invoice (INI/810/INVOCI)
• Performed ITFT, UAT testing for Procure to Pay and Sabrix using HPQC.
• Responsible for all the Cut over tasks for AR and Sabrix modules.
• Worked on e-commerce gateway Outbound Invoice EDI transfers with GXS.
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
• Responsible for setting Profile options, currencies, Responsibilities and new Set of books as part of RTR track.
• Worked on setting up daily exchange rates and transferring data from AR to GL.
• Responsible for global implementation for EMEA and APAC regions.
• Responsible for preparing TE040 (Test Scripts) for OTC modules.
• Familiar with debugging SABRIX exception messages, logs.
• Was involved in Standard Functionality testing in Phase I and Phase II for 3 instances.
• Scheduling and designing appworks workflow for running custom nightly jobs.
• Work closely with developers to implement out of the box solution for certain Tax Requirements.
• Worked on various Oracle and Discoverer reports for credit and collections as well as OTC track.

Environment: R12.1.3, Order Management, Inventory, i-Procurement, Purchasing, Oracle Payable (AP), Oracle Receivable (AR)

Oracle Financials Functional Consultant

Responsibilities:

• Responsible for the complete setup and implementation of AR, FA, Purchasing, i-Procurement, Inventory, GL, AP, OM, INV
• Worked on all the setups for the AR, GL, AP, Purchasing, i-Procurement, Inventory, OM, INV, FA Modules
• Worked on all the setups of the GL Module, including the setup of Ledgers, Secondary Ledger, Ledger Sets, Data Access Sets, Revaluation, Translation, Cross Validation Rules, Security Rules, etc.
• Setting up of complete Procure to Pay cycle setups.
• Worked on all the Purchasing module setups.
• Worked on the AP setups.
• Worked on the AR Module to setup the Auto Invoice Process
• Worked on the AR Module to setup the Auto Lock Box process
• Worked on the Revenue Recognition process in AR module to set up rule for both deferred revenue and revenue for service items.
• Impact analysis done on the service items and professional service items with the new setup done for the Event-based Revenue Recognition process
• Involved in making the detailed Project Test Plan regarding the scope and focus of the testing (TE 10).
• Written standard Integration test scripts for Procure to Pay Modules (PO, i-Procurement, AP, GL)
• Created reusable actions for user-defined functions to enhance code efficiency.
• Submitted weekly status updates and reports showing the progress of Software Testing.
• Responsible for validating the back-end data that was migrated from previous versions.
• Recommended areas for fine-tuning the system based on the analysis to the server experts(s) and system administrators.
• Created DNS Test Scripts for all FTP jobs as a part of upgrade project introduces Multi-tier Environment and change the hard coded server names to DNS names.
• Worked on testing the Revenue Recognition functionality in AR for all the Accounting and Invoicing rules that were defined.
• Tested a patch that we had applied for the Revenue Recognition process.
• Tested Multi-Org Setups because of the new Parts Operating Unit that is being introduced as part of the upgrade to R12.
• Involved in Unit Testing and System Testing.
• Generated test scripts to be used as Virtual users and scenarios to imitate the business processes and behavior of real users using Load Runner.
• Documented and communicated test results to the Test Management and Business Management Team
• Worked closely with Developers team for different issues

Financials Functional Consultant

Responsibilities -

• Coordinating and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules of AR, AP, GL, FA, Purchasing, i-Procurement, Inventory, e-Business Tax
• Identified the key business process areas along with the dependencies if any as suggested by the Business team.
• Reviewed the regression test results and updated the flow of business processes in all modules.
• Conducted workshop with business team as a part of explaining the flexibility of oracle functionality and how it meets the business requirements.
• Created MD.20, MD.050, and MD.060 document for a project life cycle.
• Designing functional design document for custom interfaces, reports, pre production testing, and related documentation and deliverables in Payable and receivable module.
• Maintained proactive interaction with the client to understand business practices to aid in system configuration.
• Analyzing and creation of technical and functional analysis document of custom process.
• Worked on design, development and coding custom AR reclass program to facilitate in booking new sub ledger details to new accounting set up.
• Development of custom program for data extraction, transmission and loading from Oracle to external system.

Oracle Finance Functional Consultant

Responsibilities:

• SPOC for the Business in resolving their day-to-day issues in AR, AP, GL, SLA, Cash Managements, OM, PO, INV, Vertex, GL
• Worked on Tax Vertex engine and interface it with Oracle AR and AP Module.
• Worked on the setups for interfacing Vertex Tax Engine with Oracle.
• Worked on the setups of Standard Rates, Rules, Zones and Authorities, Purchase Transaction taxation, Product exemptions in the Vertex Tax Engine
• Providing functional Support assistance to OM and AR Internal Customers.
• Actively handling Order Management & Shipping Production issues in areas like stuck SO lines, RMAs, Pick Release, Pick slip & Shipping documents, Adjustments & maintaining setups.
• Performed Standard Functionality testing in i-Procurement, Vertex, PO, AP and OM
• Worked on Inventory setup changes, real time defect resolution in areas like Inventory Move Order, pending Inventory transactions, material on hand & transaction quantity mismatch, Item control, Sub inventory Transfer & Month end closure.
• Played an important role on Advanced Pricing setups, designing Pricing Formulas, Price rounding, Modifiers, Pricing Events, Partial Pricing, Qualifiers, DFFs to track Price changes, assessment for tiered Pricing for expedited orders & maintaining Intercompany Transfer Pricing.
• Ensured appropriate seeded workflows in OM are used in the transactions. Resolved issues in application setup and configuration with the Financial Consultant to ensure proper interfacing of AR with OM and AP with Purchasing, and Inventory with GL.
• Extensively worked on Receivables and configured setups for organization structure, Auto invoice, auto accounting, Receivables Activities, distribution sets, Application of Receipts to transactions and invoice printing with remit address
• Creating Service Requests & coordinating with Oracle Metalink Support for issue resolution, bug tracking, requesting back ported patches, testing patches towards defect fixes in OM, Shipping, Inventory, Pricing & Purchasing areas.
• Update the BRD’s manuals/cheat sheets on a regular basis for all the business processes.
• Handling a team of 4 members and responsible for their productivity, efficiency & quality.

Oracle Finance Functional Consultant

Responsibilities:

• Responsible for gathering Business Requirements, creation of Technical Design Documents (MD.60), Unit Test Cases, Defect logs and user Documentation using AIM methodology.
• Working on understanding and gathering of functional designs for customizations / extensions / inbound-outbound interfaces and preparing Functional Design Documents (MD50).
• Design and program the solution as per Sarbanes Oxley (SOX) requirements
• Created technical design (MD.60) and development for reports that will reflect status of each invoice whether it has been extracted sent to Hewitt and paid in Oracle system.
• Performed code modification and testing at user approval testing