SUMMARY

• Overall 10 years of total work experience in Functional Consulting experience in experience in Oracle E business suite i.e. Extensive Upgrade Experience in Finance Modules (AP, GL, FA and CE).
• Handling Month - end close activities and reconciliation for GL, AP, PO and FA modules.
• Resolving Finance issues that occurred during production and provide Month end support to the above financial modules along with delivering the reports of the close.
• Loaded, imported and auto-reconciled the bank statement transaction against payments in Accounts Payable (AP)/Accounts Receivable AR in Oracle cash management modules.
• Conducted CRP1, CRP2 and tested the customized components.
• Configured the Sub Ledger Accounting (SLA) setups.
• Resolved Problem Tickets (PT) and Service Requests (SR) issued by Business Users for various Finance issues using Remedy System.
• Strong Oracle Applications Functional experience in multiple implementations, Upgradation and Post Production Support of Financials Modules in both R12&11i versions of Oracle E-Business Suite.
• Created the MD50 documents for each RICE components
• Handling Month-end close activities and reconciliation for GL, AP, PO and FA modules.
• Oracle Business Flows - Procure to Pay (P2P), Order to Cash (O2C)
• Order types setup, defaulting rules, Processing constraints, fulfillment sets functionality, ship / arrival sets, end customer, pricing modifier/ qualifier, pick release, ship confirm, Customer acceptance.
• Well conversant with concepts like Multi-Org, Flex fields and Workflows
• Inventory Setups, Items, Item templates, Move Orders, Transaction UOM, Org setup, Sub inventories, Locators, Physical Inventory,Cycle counting, Cost controls, Pick rules, Catalogues, Categories, KFF/DFF, Calendars etc.
• Setting up and supporting various business processes in Oracle Like Physical Inventory, Cycle Counting, Kanban, Min-Max Planning, Reorder Point Planning
• Procurement Setups,Types of PO,Buyer Work center, Approved Suppliers List, Sourcing Rules.
• Responsible for Requirement Gathering; Documentation of Environment Setups Functional Design using AIM Methodology/Client specific documentation standards (Develop As-Is Process Flow Diagrams, Presentation Slides, Functional Specifications documents BR100, MD50, Prepare TE20, End User Manuals, Unit Test Scripts); provide Business and Support; Gap Analysis and Testing Bug Fixes; Analyze and build enhancement requests; escalations, logging and managing Oracle SR(s); overtime support of client's Sev1 SR(s).
• Resolving Finance issues that occurred during production and provide Month end support to the above financial modules along with delivering the reports of the close.
• Run Depreciation for the Company Corp books and created the system entries to be approved by Super users, reviewed and then posted.
• Run the CIP and Standard FA Reports for the different Books. Interacted with the end users and demonstrated the functionality in detail.
• Resolved Problem Tickets (PT) and Service Requests (SR) issued by Business Users for various Finance issues using Remedy System.
• Strong Oracle Applications Functional experience in multiple implementations, Upgradation and Post Production Support of Financials Modules in both R12&11i versions of Oracle E-Business Suite.
• Procurement Setups,Types of PO,Buyer Work center, Approved Suppliers List, Sourcing Rules.
• Responsible for Requirement Gathering; Documentation of Environment Setups Functional Design using AIM Methodology/Client specific documentation standards (Develop As-Is Process Flow Diagrams, Presentation Slides, Functional Specifications documents BR100, MD50, Prepare TE20, End User Manuals, Unit Test Scripts); provide Business and Support; Gap Analysis and Testing Bug Fixes; Analyze and build enhancement requests; escalations, logging and managing Oracle SR(s); overtime support of client's Sev1 SR(s).

TECHNICAL SKILLS

Oracle Applications: R12 (12.0.3, 12.0.5, 12.0.6, 12.1.1 and 12.1.3) GL, AP, AR, FA, CEEB-Tax, i Expenses 11i (11.5.8, 11.5.9, 11.5.10 and

Languages and Tools: PL/SQL, Discoverer Viewer, Web ADI, SQL Loader, Data Loader

PROFESSIONAL EXPERIENCE

Oracle Financials Consultant

Confidential, Plano, TX

Responsibilities:

• Developed solutions for the business requirements
• Configured the delta setups in system (end-to-end) for all the Modules.
• Worked exclusively on Vertex for configuring 2 new entities with Ebiz Tax for Ebiz Vertex Related Profile Options, P2P Enablement, Configuration Owner Tax Options, Tax Rules, Vertex-Org, Vertex Rules and testing.
• Identified and created User Acceptance Testing (UAT) scripts.
• Conducted User Acceptance Testing (UAT) and getting sign off.
• Single POC from the Project team to Release Management.
• Configured the delta setups in system (end-to-end) for all the Modules.
• Worked exclusively on Vertex for configuring 2 new entities with Ebiz Tax for Ebiz Vertex Related Profile Options, P2P Enablement, Configuration Owner Tax Options, Tax Rules, Vertex-Org, Vertex Rules and testing.
• Identified and created User Acceptance Testing (UAT) scripts.
• Conducted User Acceptance Testing (UAT) and getting sign off.
• Single POC from the Project team to Release Management.
• Resolving issues, Cutover Activities, Go-Live and support.
• Worked closely with data conversion team and gathered requirement before configuring in system for their data conversion objects.
• Identified delta setups, Documenting BR100's, MD050 for RICE components and getting sign off before configuring.
• Created 35 new Operating Units as part of disintegration for Zebra Tech. (Including subledger modules).
• Conducted requirement gathering, conference room pilot and user acceptance testing sessions.
• Configured the Cloud Financials applications, validate and migrate the configuration to production
• Performed Data Conversions using tools like FBDI and ADFDI
• Implemented project plans, managing daily activities, regular communication, ensuring quality of deliverables and adherence to compliance standards
• Interacted with the project team responsible for delivery of reports, interfaces, and data conversions.
• Lead team members and work product delivery on and offshore
• Write business requirement documents for reports, interfaces, data conversions and application extensions
• Develop end-user documentation and materials
• Provide status and issue reports to the project manager/client on a regular basis
• Worked as Oracle EBS Finance Functional Lead implementation in for Hong Kong, Taiwan, Japan and Philippines Lighting, implementation of Greece, Angola and Nigeria GE Corporate entities in Central Corporate Ledger program
• Provided direction and subject matter expertise for Oracle Financials and supply chain modules.
• Partnered with finance, operations leaders, and users to evaluate and improve business processes and arrive at mutual, cost effective solutions
• Conducted requirement gathering, conference room pilot and user acceptance testing sessions.
• Implemented project plans, managing daily activities, regular communication, ensuring quality of deliverables and adherence to compliance standard
• Lead team members and work product delivery on and offshore
• Supported Post-Implementation phase for all Oracle Financials Modules.
• Production support, interfaces maintenance, change management, month end closing
• Prepared and modified MD50's for different reports like Product profitability report, PO received but notinvoiced report, etc.
• Created the extensive test scripts TE 40 to verify the reports; tested, verified and deployedto production.
• Researched and resolved PO number in customer credit card statement for refund transactions.
• Resolved the issues related to credit card refund, return, bills only, freight charge return, not invoiceable items, credit card authorization, consolidated invoicing, in order management and receivables.
• Resolved the issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, and customer statement report.
• Worked on development of new FSG reports and customized various standard FSG reports.
• Worked with technical team regarding RICE components.
• Created work around for unsolved issues.
• Supported Post-Implementation phase for all Oracle Financials Modules.
• Worked with Oracle Support to resolve the critical issues through SR/TAR.
• Customization of Promise Date of Sales Order form after creation of Depot Repair Service Request.
• Procedure is used to call the API OE ORDER PUB which updates Request Date, Promise Date and Schedule Ship Date of RMA line on Sales Order form as per the business logic using CUSTOM.PLL
• Co-ordinate between Onsite and Offshore teams for Effective Delivery
• Completely responsible for all development OM, Service Contracts, Install Base, AR, OM, AP, i-Expense and INV modules.
• Performed the expense report data conversion into i-Expense from a legacy system.
• Worked on i-Expense customizing the functionality for expense approval
• Customization of Reports of various modules like Receivables (AR), Inventory (INV), and Order Management (OM) modules.
• Designed and developed the Auto Lockbox interface program to import receipts from 3 banks. Developed the import program and used SQL Loader to load data into the AR PAYMENTS INTERFACE ALL table.
• Escalate and derive the logical conclusion, of all technical issues, that may impact the project schedule.
• Post Production support after GO-live.
• Create TARS and follow-ups with Oracle for product related issues
• Worked on Development using custom PL/SQL Package for Suppliers Data Extract File.
• Production Support for purchasing issues involving Workflow enhancements (sourced from stock).
• Designing, implementing and supporting business processes in an Oracle environment;
• Designing, building, testing and deploying various Oracle solutions;
• Identifying and addressing client needs by building relationships with clients, developing an awareness of Firm services, communicating with the client in an organized and knowledgeable manner, delivering clear requests for information, demonstrating flexibility in prioritizing and completing tasks and communicating potential conflicts to a supervisor;
• Developed solutions in Fusion Cloud applications pertaining to Allocations, BPM Approval rules, Intercompany, Travel and Expenses.
• Lead design efforts to modify and add new functionality to Oracle Cloud ERP application, including designing functional specifications for RICE (Reports, Interfaces, Conversions, Extensions) items/
• Participate in business requirement sessions, perform gap analysis and provide level of effort estimates
• Work with business/ business analyst to understand the functional requirements
• Create functional and technical specifications
• Perform unit testing and validate testing results meet requirements
• Partnered with finance, operations leaders, and users to evaluate and improve business processes and arrive at mutual, cost effective solutions

Oracle Financials Consultant

Confidential, Wichita, KS

Responsibilities:

• Designed and implemented business process in Oracle for Project budgetting and disallowing requisiton if project budget is not available.
• Prepared functional documents for custom reports and forms for the following
• Custom Project Status Inquiry form
• Offered industry best practices and assisted the client with the road map definition
• Coordinated the effort for the Monthly Releases (Release Management) with EADP- Fusion - ERP
• Coordinated with the team for the Monthly Release Regression testing.
• Worked closely with business for Conducting UAT for Expansion of Cash Card Providers (ePay, Incomm, Blackhawk) to different European Countries.
• Worked closely with the Vendors in Re -designing the Remittance file format.
• Involved in gathering requirements for New Payment methods where Electronic Gaming Expanded.
• Worked closely with the business users on Finance Month End & Year-End close Issues (AP, AR, GL, FA).
• Involved in technical discussions for migrating the code and validated the code by testing in Test and QA before moving the PPM Packages to Production.
• Worked closely with offshore team for Testing and Development work.
• Coordinated the effort for the Monthly Releases (Release Management).
• Coordinated with the team for the Monthly Release Regression testing
• Worked on the Root cause for the incorrect accounting for Refunds (No accounted amount is being populated in ar distrubtions table for some refunds.)
• Worked closely with the business on Quota Allocation, Claim Research, and Claim Settlement.
• Involved in data cleanup for the year end closing (Remittance Account, Cash clearing Account, Prepayment Account, Revenue Account)
• Involved in technical discussions for migrating the code and validated the code by testing in Test and QA before moving the PPM Packages to Production
• Worked on the Root cause for the incorrect accounting for Refunds (No accounted amount is being populated in AR distributions table for some refunds.
• Worked closely with Banks, Bank Accounts for internal purpose and Payment Formats for Manual Check and Electronic Fund Transfer (EFT) in single and multiple currencies.
• Involved in Accounts Reconciliation for Year-end close
• Involved in Redesign of refund process (Refund Issue on returns, Refund Issue on edit cancels,
• Leapfrog is a leading designer, developer and marketer of innovative, technology-based al products andrelated proprietary content. Worked as an Oracle Financials Functional Consultant before CRP1 through user and was responsible for GL, AP, PO, I Expense and P2P.
• Carried out module configuration, solution design, process analysis, and implementation of Oracle Financials General Ledger, Accounts Payables, Purchasing, I Expense and P2P.
• Responsible for the documentation (BR.030 -Business Requirements Mapping, BR.100 -Application Setup and TE.040 -System Test Script).
• General Ledger, Account Payables, andPurchasing Modules setups.
• Business communications for the system updates and meeting the deadlines for the implementation.
• Created Auto Invoicing and Auto lockbox (Source of Auto Invoice was Project Billing) processes.
• Set-up of Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, CrossValidation Rules, Security Rules, Calendar, Currencies, Assigning Ledger to a
• Setting upResponsibility, Standard Journals, Statistical Journals, Recurring Journals, Suspense Accounts and Mass Allocations.
• Defining Financial Statement Generator, Creating Ad-hoc Reports, and Open and Close Accounting Periods.

Oracle Financials Consultant

Confidential, TX

Responsibilities:

• Procedure is used to call the API OE ORDER PUB which updates Request Date, Promise Date and Schedule Ship Date of RMA line on Sales Order form as per the business logic using CUSTOM.PLL
• Co-ordinate between Onsite and Offshore teams for Effective Delivery
• Completely responsible for all development OM, Service Contracts, Install Base, AR, OM, AP, i-Expense and INV modules.
• Performed the expense report data conversion into i-Expense from a legacy system.
• Worked on i-Expense customizing the functionality for expense approval
• Customization of Reports of various modules like Receivables (AR), Inventory (INV), and Order Management (OM) modules.
• Designed and developed the Auto Lockbox interface program to import receipts from 3 banks. Developed the import program and used SQL Loader to load data into the AR PAYMENTS INTERFACE ALL table.
• Escalate and derive the logical conclusion, of all technical issues, that may impact the project schedule.
• Post Production support after GO-live.
• Create TARS and follow-ups with Oracle for product related issues
• Worked on Development using custom PL/SQL Package for Suppliers Data Extract File.
• Production Support for purchasing issues involving Workflow enhancements (sourced from stock).
• Modified custom program using API's to create new contacts, address, phone numbers and others for every new customer in the Trading Community Architecture (TCA).
• Developed SQL*loader control files and did data mapping for item interface and customer interface
• Preparation of application setups, documentation & few solution design documents like setup doc, MD docs& test docs.
• Leading the closing activities of the client on a monthly, quarterly and yearly basis including yearly roll-over process.
• Worked on the escalation management and priority handling of the critical issues as the SPOC from Off-shore.
• Knowledge sharing sessions and creation of technical and functional documents and white papers.
• Leading the various RCA defect management.
• Developed custom interface (RICE Component) to generate value-addition to the business after the thorough contemplation of the recurring issues and obtaining the business sign-off.
• Project Management activities like SLA-Service Level Agreements, Metrics, and Team coaching & building team competencies.
• Delivered presentations to end users on the SLA architecture and Consolidation
• Reviewed and analyzed current business processes for implementation of Oracle Receivables, Oracle Payables, Fixed Assets, General Ledger, SLA, Cash Management
• In conjunction with the project team, conducted detailed business analysis alongside end users and other stakeholders to identify operational requirements and propose enhancements
• Created Business requirement documents and Fit-Gap Analysis documents
• Worked in conjunction with the IT department in conducting data clean up prior to migration
• Prepared application Setup documents (BR100) and Functional Design documents(MD50)
• Tested PO and AP setups for inconsistencies
• In conjunction with oracle Support, Viewed, Accessed and followed up on Service Requests
• Worked closely with the business users on Finance Month End & Year-End close Issues (AP, AR, GL, FA).
• Worked closely with technical teams involved in the conversion process, giving directions on the various approaches to the conversion process and making sure that all conversion items are completed, and balances reconciled with the legacy system.
• Trained end users on running Translation, Revaluation and Consolidation of ledgers in multiple scenarios
• Prepared Issues List, Risk Plan, Change Request Forms and regular Client Status Reports.
• Prioritized tasks for the team based on feedback from the client meetings, number of defects and project progress.
• Perform unit testing and validate testing results meet requirements
• Partnered with finance, operations leaders, and users to evaluate and improve business processes and arrive at mutual, cost effective solutions
• Developed solutions for the business requirements
• Conducted requirement gathering, conference room pilot and user acceptance testing sessions.
• Configured the Cloud Financials applications, validate and migrate the configuration to production
• Performed Data Conversions using tools like FBDI and ADFDI
• Implemented project plans, managing daily activities, regular communication, ensuring quality of deliverables and adherence to compliance standards
• Interacted with the project team responsible for delivery of reports, interfaces, and data conversions.
• Lead team members and work product delivery on and offshore
• Write business requirement documents for reports, interfaces, data conversions and application extensions
• Develop end-user documentation and materials
• Provide status and issue reports to the project manager/client on a regular basis
• Worked as Oracle EBS Finance Functional Lead implementation in for Hong Kong, Taiwan, Japan and Philippines Lighting, implementation of Greece, Angola and Nigeria GE Corporate entities in Central Corporate Ledger program
• Provided direction and subject matter expertise for Oracle Financials and supply chain modules.
• Partnered with finance, operations leaders, and users to evaluate and improve business processes and arrive at mutual, cost effective solutions
• Conducted requirement gathering, conference room pilot and user acceptance testing sessions.
• Implemented project plans, managing daily activities, regular communication, ensuring quality of deliverables and adherence to compliance standard
• Lead team members and work product delivery on and offshore
• Identified and created User Acceptance Testing (UAT) scripts.
• Conducted User Acceptance Testing (UAT) and getting sign off.
• Single POC from the Project team to Release Management.
• Resolving issues, Cutover Activities, Go-Live and support.
• Worked closely with data conversion team and gathered requirement before configuring in system for their data conversion objects.
• Identified delta setups, Documenting BR100's, MD050 for RICE components and getting sign off before configuring.
• Created 35 new Operating Units as part of disintegration for Zebra Tech. (Including subledger modules).
• Worked on mapping the new Zebra entity's with MSI existing locations.
• Created intercompany solution for new entity's products.