Oracle Functional Lead Resume
SUMMARY
- Over 20 years of experience in Business and Accounting and over 18 years of Oracle Financials implementation and Training experience in consulting in various capacities.
- Widely involved in complete life cycle implementation, business process analysis, interfaces, data conversions, solution design, and gap analysis, testing and maintaining quality standards for Oracle application products.
- Experience has included work in the Utility, DSD, Telecom, Services, Pharmaceuticals, Financial, Retail, Federal and Manufacturing industry.
- Oracle Applications R12, 11i, 11.03 and 10.7 GUI
- Familiarity with Oracle Fusion Accounts Receivables and Accounts Payables
- UPK
- Extensive expertise in Oracle General Ledger, Channel Revenue Management, Payables, Receivables, Fixed Assets, Treasury, iExpense, Advance Collections, iReceivables, iProcurement, iSupplier, Oracle Sourcing, Purchasing, Cash Management, Oracle Loans, Oracle Time and Labor and Service Contracts.
- Good working knowledge of Advance Pricing, Incentive Compensation, Order Management, Credit Management and Systems Administration.
PROFESSIONAL EXPERIENCE
Oracle Functional Lead
Confidential
Responsibilities:
- Led full life cycle Implementation of Oracle GL, Payables, Purchasing, Receivables, iReceivables, Service Contracts and OTL for a major Telecom provider on R12.2.5
- Designed several interfaces from BMC to Oracle Service Contracts, Inventory and Pricing
- Prepared Functional Design Documents for interfaces and reports.
- Conducted workshops & CRP sessions
- Prepared training documents and test scripts for all business processes
Oracle Contract Lifecycle Management
Confidential
Responsibilities:
- Implemented the advance Procurement suite (iProcurement, CLM Sourcing and Procurement contracts) on Oracle R.12.2.5
- Conducted workshops
- Tested all the business processes
- Prepared User training documents
- Worked on the integration of Clauses with CACI
- Worked on the FBO integration
Oracle Federal Financial Functional Lead
Confidential
Responsibilities:
- Led the upgrade of Oracle Financials (Loans, Receivables, Purchasing, Payables, Payments, Fixed Assets, General Ledger and Fed Administrator) from 12.1.3 to 12.2.5
- Analyzed the impact of changes to the current system design and interfaces.
- Worked with the technical team to make changes to all interfaces to incorporate the changes impacting the interfaces
- Prepared test scripts and training documents using UPK tool.
- Conducted testing of all business process.
Oracle Federal Receivables Lead
Confidential
Responsibilities:
- Led the upgrade of Oracle receivables from R11 to R12.1.3
- Conducted fit gap analysis by analyzing the current system design and requirements
- Analyzed the custom interfaces and reports to access the impact of the upgrade
- Conducted end to end system test to ensure all processes worked as designed.
- Conducted end user training on all new features.
- Tested BOE reports
- Prepared test scripts using UPK tool
- Provided Post Production support.
Oracle Receivables Lead
Confidential
Responsibilities:
- Led the implementation of Oracle Receivables by mapping the requirements to the standard oracle functionality.
- Conducted workshops for new R12 functionality to enable users to understand the new features in R12 specially related to Collections.
- Prepared several functional design documents to interface Billing data from Third Party systems
- Worked with technical team to develop and test the interfaces.
Advance Collections, AR and Channel Revenue Management Functional Lead
Confidential
Responsibilities:
- Assisted in the migration of the newly acquired DSD business from JD Edwards Financials to Oracle Financials.
- Mapped the various AR and Deductions Management processes
- Prepared Functional Design Documents for the integration of third party system to Oracle Deductions Management and GL
- Supported End User Training activities
- Post Go - live support.
Federal Financial AR Functional Lead
Confidential
Responsibilities:
- Led the upgrade of Oracle Accounts Receivable from R11.5 to R12.2.2.
- Conducted Workshops and Solution demos for new R12 features and the impact of R12 functionality on HIGLAS Business processes
- Prepared Functional Design documents for several Extensions and Reports
- Conducted testing for all upgraded components and business processes to ensure all RICELS work as expected after upgrade.
- Supported End User Testing and Training activities.
Federal Financial AR Functional Lead
Confidential
Responsibilities:
- Assisted the implementation of R11 Oracle Receivables.
- Prepared Functional Design documents for Custom Reports, Extensions and conversion of legacy Customers and Receivables.
- Conducted solution demos and Testing of various Business Processes and RICELS.
- Responsibilities also included post go-live support issue resolution and solution design for system enhancements.
Federal Financial Functional Lead
Confidential
Responsibilities:
- Implemented Receivables in Project centric environment for shared services client handling 50 federal agencies using Reimbursable and non-Reimbursable contracts.
- Responsible for guiding the internal implementation team in resolving issues related to R12 reimplementation in the areas of Federal AR, AP, PO, SLA and FA
- Created Test Plans for Receivables, GL and Purchasing
- Prepared Functional Design documents
PMO Support Analyst
Confidential
Responsibilities:
- Responsible for production support and issues resolution.
- Resolved issues related to Purchasing and iProcurement on a project centric federal procurement implementation.
- Resolved post production issues in the area of UMX and Oracle Time and Labor.
- Coordinated agency wide month end close of Financials and assisted in month end close related issues.
- Work as a liaison between the client and the Global Team to ensure that all the agency requirements are met.
- Ensured complete understanding of processes by agency.
- Worked as a liaison between the agency implementation members and Global team to ensure the solutions meet the agency requirements.
- Worked with workforce preparation team to ensure that all the training activities are successfully completed and the agency users are ready for deployment.
- Involved in P2P process area, created test scripts and mapped actual data to test scripts and test scenarios for testing activities.
- Assisted Confidential Agency's in the deployment of Oracle Financials on a timely manner.
- Ensured agency readiness in terms of infrastructure connectivity, user training and helpdesk readiness prior to deployment.
Oracle Advance Collection and Loans Consultant
Confidential
Responsibilities:
- Performed Requirements Gathering.
- Performed Map and Gap analysis.
- Prepared use cases.
- Setup CRP instance to demonstrate R12 Advance Collections and Loans functionality.
Functional Lead
Confidential
Responsibilities:
- Performed testing and Map and Gap analysis.
- Conducted workshops to demonstration all business processes in R12 PO, AP, AR, FA, GL and CM.
- Implemented iProcurement.
- Automated the P-card interface from the bank using the COTS functionality in Oracle AP.
- Tested AP, AR, PO, FA, GL and CM in R11.5.10.
- Prepared functional design documents to track 1099 transactions charged on P-Cards and T&E cards to meet IRS 1099 reporting requirements.
- Prepared functional design documents to electronically transmit payment information to the funding institute for electronic payment to vendors.
- Conducted training for 40 users on R12.
Oracle Channel Revenue Management
Confidential
Responsibilities:
- R12 implementation Map and Gap assessment for AR and Channel Revenue Management formally known as Oracle Trade Management.
- Involved in requirements gathering, Process Re-design, implementation and training of Receivables, Advance Collections, iReceivables and Trade management 11.5.10.3.
- Designed several custom processes, created several MD50 documents to meet the (Direct Store Delivery) DSD industry needs in Receivables.
- Designed several third party interfaces to allow interface of handheld data and other third party systems to integrate with Receivables and Trade Management.
- Responsible for the conversion of Customers and open receivables.
- Prepared training material using UPK and conducted training for 45 users.
Treasury Lead
Confidential
Responsibilities:
- Involved in the upgrade from 11.5.9 to 11.5.10 and implementation of new processes.
- Created user manual to enable users to implement new entities in future.
- Conducted end user training.
iExpense Lead
Confidential
Responsibilities:
- Involved in requirements gathering, documenting the current state and making recommendations on the Future state process for Oracle iExpense OIE.K version.
- Prepared the Business Case and several other documents to help decision making in some key areas of the iExpense implementations.
- Configured the CRP instance based on the client requirements.
AR Functional Consultant
Confidential
Responsibilities:
- Primarily involved in the operation support, billing reconciliation, and configuration and testing of Finance Charge process.
- Created SOP (Standard Operating Procedures) for Reimbursable work and Receivables Management process.
Oracle Channel Revenue Management Lead
Confidential
Responsibilities:
- Led the upgrade of Trade Management (Channel Revenue Management) from 11.5.8 to 11.5.10.
- Implemented the new features.
- Conducted end to end testing to ensure proper functioning of all customizations after the upgrade.
Financial Lead
Confidential
Responsibilities:
- Led the re-implementation of the Oracle Financials 11.5.9.
- Coordinated the testing effort of AR, CE, GL and interfaces to several legacy systems.
- Provided Production support.
Testing and Support Lead
Confidential
Responsibilities:
- Led the Testing effort for financials implementation for a Logistics Company.
- Created several Functional Design Documents for Custom reports, EFT, Lockbox, Custom triggers and processes.
- Created several FSG reports to meet company reporting requirements.
Oracle Treasury and Cash Management Lead
Confidential
Responsibilities:
- Configured Oracle Receivable to support conversion of Legacy Data and ongoing interfaces from Systech to Oracle.
- Led the implementation of Oracle Cash Management 11.5.9 and Oracle Treasury.
- Setup Oracle treasury to capture transactions that impacted the cash flow but were not recorded in Oracle, Short term loans, Certificates of Deposits, Stocks and Mortgages.
- Configured 15 bank accounts for Cash position, Cash Forecasting and cash reconciliation on monthly basis.
- Involved in the configuration of Inter Account and inter Company transfers for 5 legal entities.
- Provided Post Production support in the area of Payables, GL and PO.
- Conducted end user training.
Oracle Financials
Confidential
Responsibilities:
- Led the implementation of Oracle AP, AR & Trade Management on Oracle 11.5.9 for Global Home products, a manufacturer of Glassware, Cookware & Frames with operations in US & Canada.
- Conducted Requirements Gathering and Map and Gap analysis
- Configured the AR, AP and Trade Management applications based on requirements.
- Integrated AR with OM, TM and iPayment for Credit Card processing.
- Prepared and conducted end user training
Documentation & Training Consultant
Confidential
Responsibilities:
- Documented future process flows.
- Created detail training and process documents.
- Conducted end user training for Oracle Receivables, Trade Management and Territory Manager in Oracle 11.5.8 for 45 users.
Procure to Pay Integration Consultant
Confidential
Responsibilities:
- Created functional design document for the integration of PeopleSoft Set of Books to Oracle 11.03 set of Books due to the acquisition of Documentum by Confidential .
- Setup Oracle GL and Purchasing for proper integration of the Documentum Data into Oracle Confidential books.
- Created several functional design documents for custom reports and enhancements.
- Created the iProcurement training document.
Financial Lead Consultant
Confidential
Responsibilities:
- Led the implementation of GL, CM, Financial Intelligence and FA at ALSAC (St. Jude Children’s Hospital) on Oracle Financial R11.5.9.
- Created business process documents and conversion specifications.
- Configured GL, FA and CM.
- Led clients through decision making meetings and conference room pilot activities.
- Converted GL balances and Assets using ADI.
- Created FSG’s.
- Setup Report Manager for electronic distribution of all reports.
- Converted Employees using DataLoader.
- Assisted in the implementation of iExpense including but not limited to the integration of credit card transactions from American Express.
- Assisted in the implementation of iProcurement.
- Conducted end user training.
Testing Lead
Confidential
Responsibilities:
- Conducted the Testing of Oracle Financial R11.5.8 and its integration with the Legacy systems (STARS) and Interchange Financial.
- Coordinated efforts of about 30 team members including several Developers and Functional consultants to ensure that all the customizations and processes were bug-free.
- Developed Test Scripts, process flows and strategies for testing all processes for SIT for the State of Confidential .
Project Lead/Manager
Confidential
Responsibilities:
- Led the implementation/configuration of AR and FA on Rel.11.5.8 for CCITriad, an automotive software development company.
- Conducted Requirements Gathering, Business Process Re-engineering sessions
- Conducted Testing to ensure proper working of the system. Accounts Receivable Implementation included integration with Vertex Tax Software, Invoice printing with DataProse and interfacing with the legacy invoicing System.
- Conducted financial implementation workshops for General Ledger, Accounts Payable, Accounts Receivable and Fixed Assets for Helen of Troy.
- Determined and documented scope for implementation at Helen of Troy, a large international beauty supply company.
- Prepared training material and conducted end user training.
Principal Consultant
Confidential
Responsibilities:
- Led the upgrade of Oracle Financials 11.03 to 11.5.8 for a leading Courier company in Dallas.
- Provided assistance in the pre-upgrade and post upgrade steps, discussed all the new functionality in AP, GL, CM, and FA.
- Conducted an assessment for 11.5.8 upgrade from 10.7 to 11i for Williams Energy, a leading Energy company in Texas for Accounts Receivables and iExpenses.
- Resolved Post-production issues for Accounts Receivables, Payables, General Ledger, PO and OM for a Leading manufacturer, Tramontina on 11.5.6.
- Resolved post-production issues in the area of Oracle Order Management, Shipping, Purchasing, Receivables and Payables for OFS Brightwave (Lucent Technologies).
- Helped in setting up multi-currency transactions, Foreign currency price lists and modifiers, setup new freight carriers and their relationship to shipping methods.
- Served as Team Lead for Release R11i Accounts Receivable, Accounts Payable, General Ledger and Fixed Assets global implementation for OFS Fitel (Lucent Technologies) an international Fiberoptic and Cable company using AIM methodology.
- Integrated with Evergreen document solution, I-payment, iStore and Vertex TaxManager solution in a Financial and Manufacturing implementation.
- Setup Vertex tax Manager in a 11i global implementation to work with Oracle Receivables and Oracle Order Management to calculate Sales tax on Sales Orders and their integration with Receivables.
- Created test scripts to ensure the accuracy of Vertex functionality in OM and Receivable for Exempt and Taxable Customers and items.
- Served as Team lead for Release R11i Accounts Receivable, Accounts Payable, Self-Service Web Expenses and General Ledger global implementation for Fitel-Lucent (Lucent technology) a Cable manufacturing company using FastForward methodology.
- Integrated with Evergreen document solution in a Financial and Manufacturing implementation.
- Prepared the conversion strategy and functional design documents for the conversion of the AR and AP invoices for Tricare Customer Care, a Confidential organization.
- Conducted end to end testing as part of the Oracle Development team on Trading Community Architecture (TCA) and Accounts Receivables.
- Led and assisted in Consolidating the business process, documenting Gaps, made recommendations and implemented solutions for AP, PO, Cash Management and Oracle Alerts on 10.7Sc for newly merged Confidential and Confidential Co. Integrated with Optio document solution for Check printing solution.
- Served as Team lead/application specialist for Oracle Self-Service Web Expense ion 10.7 NCA implementation in a partnership implementation with KPMG for Cable Vision.
- Created functional Design document and coordinated and assisted the technical team in its effort to create the customization as per the functional specs.
- Served as part of the Oracle exchange (e-Business) product management team participated in the launching of Business-to-Business Internet procurement and supply chain software.
- Participated in the end to end functional testing of Registration, Spot Purchase and catalogs but took on a leading role in the testing of the most complex area of Auctions and Bidding between Buyers and Suppliers.
- Served as Team lead for Release 11.03 Accounts Payable and Cash management implementation for Ann Taylor a large apparel Retailer.
- Integrated with Bottom-line document solution.
- Assumed full implementation responsibility for Accounts Payable but facilitated the implementation of Fixed Assets. post-implementation support and month end support for client for the first month of production. 11.03.
- Served as Team lead for Oracle Payables and Cash Management implementation in a Financials implementation for Salant, a clothing manufacturer and retailer in U.S.
- Integrated with Optio document solution Participated in Operations Analysis phase, Conference Room Pilot, Customization Design and Data Conversion.
- Facilitated in Oracle Fixed Assets implementation.
- Provided Post Production Support at in Accounts Payable and Accounts Receivable (version 10.7 characters) and conducted training for Reuters help desk personnel on accounts payable.
- Worked as an Accounts Payable lead on a fast forward implementation for ModoEyeware.
- Implemented Fixed Assets and Accounts Payable and facilitated the Fixed Assets implementation at Morgan-Walke Associates Corp.
- Prepared FSG reports and created custom responsibilities for G/L, A/P and Purchasing at New York Power Pool. Also assisted in trouble shooting Production problems.
- Conducted business requirements analysis for a nonprofit organization for Purchasing, Accounts payable and Fixed Assets and created Solution Documents for all three modules.
- Assisted in the requirement analysis and setup of CRP instance for Purchasing and Accounts Payables for Y&R a leading advertising company in a multi-org environment on release 11.02.
- Assisted in the CRP implementation and testing for Self Service Web time and Expense.
Controller
Confidential
Responsibilities:
- Supervised daily operations of corporate accounting department.
- Streamlined procedures and selected, installed and trained the departments in new accounting software for G/L, Purchase Order, A/P, A/R, Order Entry, Inventory, Leasing and Service.
- Prepared consolidated financial statements.
- Prepared budgets and forecasts, analyzed accounts and cash management.
- Evaluated and explored future business transactions.
- As part of the IT team involved in the analysis of various software packages and hardware platforms.
- Documented business requirements and process flows for G/L, PO, A/P, OE, A/R, Leasing and Service.
- Designed test data for system conversion.
- Implemented MAS90 system.
- Trained employees on the new system.
- Assisted in regular maintenance of UNIX Operating System.
Accountant
Confidential
Responsibilities:
- Maintained manual General Ledger.
- Reconciled Bank Statements and Sub ledger Reconciliations, Processes Payroll, Sales tax and Payroll tax returns.
- Responsible for managing Accounts Payable and vendor relations.
- Prepared all the supporting schedules for financial statement reporting.
