We provide IT Staff Augmentation Services!

Lead Oracle Financial Functional Resume

Cleveland, OhiO

EXPERIENCE SUMMARY:

  • 13 years of IT experience in Oracle Apps Financials as Functional Consultant with strong understanding in AR, AR/DS, CHRM, OM,, SLA,TCA, GL, CHRM,AP, EB - TAX, CM, and System Administration modules.
  • Experience in requirements gathering, functional fit-gap analysis, application design, setups, testing, and performance tuning, creating design documents and performs impact analysis for application changes.
  • Expertise in end-end implementing, supporting and maintaining Order to Cash (O2C)
  • 2+ Years Experience in Channel Revenue module(Deduduction/Overpayment,write-off,Chargebacks, Rebates and commission) .
  • Expertise in Oracle Financials covering wide array of consulting and client management responsibilities.
  • Experience in production support, system maintenance and full life cycle ERP implementations as functional analyst, technical specialist and project lead.
  • Demonstrated experience of working collaboratively with all levels of project organization to ensure smooth and successful implementation of projects.
  • Extensively worked with Customers,3rd party vendors, Technical group,B2B team and Global business group in Integrating mainframe, best of breed systems, Legacy system & Mobile application, External Banks with Oracle.
  • Extensively worked on guiding and coordinating onsite and offshore team in developing RICE components (Reports, Interface, conversions, and enhancements) in the R12 Financials.
  • 4 + years’ experience in leading team.
  • Experience in designing Oracle Financials in EU countries and meeting statutory requirements.
  • Experience in Sub-ledger to GL Reconciliation.
  • Sound knowledge of Accounting.
  • Experience prioritizing competing demands, scoping large efforts and negotiating timelines.
  • Work directly with end-users gathering business requirements and translating them into systems documentation using AIM and OUM methodologies such as High level process design(BP-070), To be process(BP-080) set-up (BR-100), Functional and Technical Application Extension specifications (MD-050 or MD-070), system test scripts (TE040) and UAT report (TE130).
  • Experience in Data mapping the external source files with oracle columns in Oracle Accounts Receivables, General Ledger Accounts Payables modules.
  • Assisting users with any issues/problems and resolving them independently.
  • Creating test plans, test cases, test scripts and performs functional testing.
  • Well versed with Onsite-Offshore model.
  • Provide effective support during critical milestones e.g. CRP and UAT and GO-Live etc.
  • Experience in Month/Quarter period close activities.
  • Implementation and knowledge with R12’s new features, changed architecture, MOAC, SLA, EBTAX and key concepts like Oracle Trading Community Architecture, Period close activities, Reporting, etc.
  • Experienced on EBTAX configuration (Regime to Rate flow) like Tax regimes, Tax Jurisdiction, Tax Recovery Rates, Tax Rates and Tax Rules.
  • Responsible for final code migration from UAT environment to Production by testing, reviewing and getting sign-off from the client.
  • In-depth knowledge of Oracle E-Business, as well as functional expertise to consults with project personnel, stake holders, users and management to determine scope of project, fit gap analysis, providing solution, suggest process improvements and coordinating with various parties as-an when required.
  • Experience in Reports, Interface, conversions, and enhancements.
  • Knowledge of the underlying Oracle tables, integration points and technology processes.
  • Creating and Monitoring Oracle SRs (Oracle Support/Metalink) and working with DBA to apply critical patches and testing the same with end-end testing.
  • Ability to quickly pick up new tools and technologies and work independently with limited general supervision.
  • Strong process orientation with demonstrated analytical thinking, organization skills and problem solving skills.

TECHNICAL SKILLS:

Oracle EBS: Oracle Applications (11i & 12), GL, AR, CHRM,AP,PO, FA, CE, AOL, EBTAX

Oracle Technical: Reports, Interfaces, Conversions, Extensions

Tools: Sql Plus, Toad, SQL Developer, Sql* Loader, Forms & Reports 10g/6i, XML Publisher, Data loader.

Database: Oracle 11g/10g/6i, Microsoft Access.

Programming Languages: SQL, PL-SQL Xml, Unix Shell Scripting

WORK EXPERIENCE:

Confidential, Cleveland, Ohio

Lead Oracle Financial Functional

Responsibilities:

  • Worked as a lead for creating and designing the Project plan for AR, CHRM and peripherals modules and made sure all the Project activities were managed per Implementation methodology in designated timeframe.
  • Conducted weekly 4INAB meeting and ensured the stakeholders were updated with the current status.
  • Provided the weekly report on the project status to Finance and Project lead.
  • Complex integration with 3rd party vendor application with home grown tool and Oracle for interfacing customers.
  • Local & Statutory requirements for integrating banks payments through batch receipts from different sources and for smooth &efficient reconciliation.
  • Designed & Implemented Mobile app for customers/Distributors for viewing Customer balance, Credit limit, available credit limit, open order & Invoice documents on mobile.
  • Worked Closely with Local AR managers, users and Global business owners in understanding the current As-Is process pain areas and implement the best possible solution
  • Worked Closely business, corporate team, legacy B2B to integrate Non Oracle system like EDI and Micro-strategy with Oracle and made sure all requirements were implemented.
  • Working in partnership with OM, Shipping, POS,ITC,TAX and others to help a team or work group achieve its goals.
  • Effectively manages time and resources to ensure that work is completed efficiently.
  • Provide subject Matter expertise and direction to Team wherever required.
  • Conducted Discovery, SIT, UAT and Involved in End user and Key Management folks and made sure all the business cases were discussed, documented and Implemented.
  • Provided support to the GRC team in reconciling user access, test cases etc.
  • Go Live support for AR module and staying on top of all High priority Tickets for ANZ Implementation.
  • Delegating and sharing work with team and making sure there time is effectively utilized.
  • Led discussions relating to the new Oracle Processes, pros and cons and best practices presented and provided

Confidential, Cleveland, Ohio

Lead Oracle Financial Functional

Responsibilities:

  • Worked as a Project lead for creating and designing the Project plan and made sure all the Project activities were managed per Implementation methodology in designated timeframe.
  • Successfully Completed the High Radius Cash Application Implementation and ensured the business requirements were met per December 2017 timeline.
  • Conducted weekly Leads meeting and ensured the stakeholders were updated with the current project status.
  • Provided the daily trend and comparison of production load with High Radius to the management.
  • Provide subject Matter expertise and direction to Team wherever required.
  • Conducted Discovery, SIT, UAT and Involved in End user and Key Management folks and made sure all the business cases were discussed, documented and Implemented.
  • Designed and worked on the Parallel Testing Reconciliation Process with Oracle Productions and made sure all the test cases were taken care.
  • Provided support to the GRC team in reconciling user access, test cases etc.
  • Worked Closely with Global business owners and AR managers in understand the current As-Is process and pain areas
  • Actively Involved in the vendor comparison and provided recommendation to the management.
  • Facilitate System Integration Testing and User acceptance testing along with test data preparation.

Confidential, Cleveland, Ohio

Lead Oracle Financial Functional

Responsibilities:

  • Worked as a lead for creating and designing the O2C(AR,Deduction/Claims,CE,GL) project plan
  • Implemented full Order to Cash (O2C) cycle.
  • Automated Bank reconciliation process as a part of UK requirement
  • Working with Development team to build the functionality for the new requirements and testing in DEV / QA instances before migrating it to UAT and PROD instances.
  • Engage in regular client interaction through Live Meetings and Conference Calls to better understand the business and clarify any doubts in requirements.
  • Introduced lot of new Oracle Process in Sherwin Williamns like AR Refund, Control Accounts, OBIEE and Endeca Dashboard which is benefiting the local business in Managing Receivables
  • Streamline Accounting process so that GSC IT and corporate team can better manage SLA Accounts for future waves.
  • Extensively worked with O2C lead to make sure all the string scenarios effecting AR is tested and signed off.
  • Conducted CRP,SIT,UAT and provided to the End user and Key Mangement folks and made sure all the business cases were discussed, documented and Implemented.
  • Expensively worked on the Reconciliation Process with Legacy system and made sure everything was reconciled in AR.
  • Proposed and Implemented better way to Manage Month End Checklist and the ways to provide accurate results to the external Auditors.
  • Worked Closely business and corporate team to integrate Non Oracle system like EDI and Micro-strategy with that of Oracle and made sure all of there request were taken care.
  • Go Live support for AR module and staying on top of all High priority Tickets.
  • Led discussions relating to the new Oracle Processes, pros and cons and best pratices presented and provided
  • Delegating and sharing work with contractors and making sure there time is effectively utilized.

Confidential, Cleveland, Ohio

Senior Oracle Financial Functional Consultant

Responsibilities:

  • Performed requirements gathering, gap mapping and responsible for setting up Brazil Tax in Brazil Localization module.
  • Involved in Integration of Mastersaf with oracle and printing NotaFiscal approved per Local Statutory law.
  • Performed high level tax validation on invoices and with the tax vendors.
  • Implemented full Order to Cash (O2C) cycle.
  • Regularly interacting with business, tax vendors and technical team to minimize the gap with legacy system and Oracle and keeping track of the project plan.
  • Implemented COGS vs Deferred Revenue Matching Process.
  • Implemented Bank Collection process as a part of Brazil Localization.
  • Automating huge volume of tax scenarios through PL/SQL program and validating the same with business.
  • Responsible for successful roll out of Oracle applications for Order to cash modules.
  • Preparing and tracking the Project plan. Ensure the timelines are met
  • Working with Development team to build the functionality for the new requirements and testing in DEV / QA instances before migrating it to UAT and PROD instances.
  • Extensively worked and resolved the issues on Brazil Localization, OM, AR, Shipping Execution, INV Application.
  • Troubleshooting and fixing the issues per oracle standard localization.
  • Created Oracle service requests and fixed the bugs in Oracle Brazil Tax Localization Module.
  • Engage in regular client interaction through Live Meetings and Conference Calls to better understand the business and clarify any doubts in requirements.
  • Facilitate System Integration Testing and User acceptance testing along with test data preparation.

Confidential, Cleveland, Ohio

Senior Oracle Financial Functional Consultant

Responsibilities:

  • Performed requirements gathering, gap mapping and responsible for setting up GL, AR and OM modules like Accounting Setup Manager, creating operating units, intercompany, cross validation rules, security rules etc.
  • Worked on validating GL Blance load file from business and mapping the same in oracle GL.
  • Workd on designing highly complex custom component for giving rebates/promotions(AR) to customer when the sales target have been achieved.
  • Implemented COGS vs Deferred Revenue Matching Process.
  • Implemented Auto Lockbox Process.
  • Analysed,design, map and integrated SRP application with oracle EBS to book sales order.
  • Worked on Oracle to Micro-strategy interface for providing AR sales data to the management for reporting.
  • Design custom E-invoice process (AR) which electronically signs the transaction, credit memo debit memo and delivery document by SRI(Fiscal authority) as a legal requirement.
  • Preparing and tracking the Project plan. Ensure the timelines are met.
  • Setting up of AR module and doing custom SLA setups.
  • Logged, viewed, accessed, monitored, followed up, and closed Service Requests (SR) online - Oracle MetaLink.
  • Developed Functional specification documents (AN.100) for various RICE objects as per RICE component and Functional setup document (DS130).
  • Performing period-end processing for Oracle Receivable Module.
  • Engage in regular client interaction through Live Meetings and Conference Calls to better understand the business and clarify any doubts in requirements.
  • Analyze the various project requirements and transferring the knowledge to offshore team.
  • Facilitate System Integration Testing and User acceptance testing along with test data preparation.

Confidential, Stamford, CT

Oracle Financial Functional Consultant

Responsibilities:

  • Analysis of the current system by interacting with business and cross functional team
  • Performed requirements gathering, gap mapping. Responsible for initial setups using Accounting Setup Manager, creating operating units etc.
  • Detail Study of GE - Mexico Customization to Oracle AR module.
  • Responsible for all deliverables including Data extract programs, Reports and $U programs.
  • Mapping the Client requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of Customizations, workarounds, reengineering and form personalization.
  • Responsible for successful roll out of Oracle applications for AR and GL.
  • Sub-ledge to GL Reconciliation.
  • AR Period Close Process
  • Done the Configuration for GL, AR, and AP modules as per the client needs.
  • Maintain and present the project metrics to the Management.
  • Performing Business Requirement Study in Financials and modelling Future Process Model and preparing AS-IS (BP040) and TO-BE (BP080) documents.
  • Customization designs and work around for various business requirements in R12.
  • Developed Functional and Technical documents (MD50, MD70) for various RICE objects as per RICE components.
  • Performing period-end processing for Oracle Receivable Module.
  • Logged, viewed, accessed, monitored, followed up, and closed Service Requests (SR) online - Coordinating the Cross Functional teams for customizations and calling out key issues.
  • Analyze the various project requirements and transferring the knowledge to offshore team.
  • Facilitate System Integration Testing and User acceptance testing along with test data preparation.

Confidential, Stamford, CT

Oracle Financial Functional Consultant

Responsibilities:

  • Determine business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting.
  • Involved in the Functional implementation of Oracle Applications Financial including GL, AR, AP, PO, CM, EBTAX modules.
  • Customization designs and work around for various business requirements in R12 like AR Aging Report for China and Turkey.
  • Worked on complex integration between receivable and Golden tax adapter (GTA).
  • Special logic is applied to customized AR invoice upload PL-SQL program for China and Turkey.
  • Worked on Multi-Tax Regime for Turkey.
  • Implemented Auto Lockbox Process.
  • Sub-ledger to GL Reconciliation.
  • Responsible for full AR Period Close activity.
  • Developed conversion program from importing Standard Purchase order in PO.
  • Logged, viewed, accessed, monitored, followed up, and closed Service Requests (SR) online - Oracle MetaLink.
  • Developed Functional and Technical documents (MD50, MD70) for various RICE objects as per RICE components.
  • Provide effective support during critical milestones e.g. CRP and UAT etc.
  • Analyze the various project requirements and transferring the knowledge to offshore team.

Confidential, Stamford, CT

Oracle Financial Functional Consultant

Responsibilities:

  • Involved in the Functional and Technical implementation and support of Oracle Applications Financial including GL, AR, AP, PO, CM, EBTAX modules.
  • Participated in providing Procure-to-Pay (P2P) life cycle support.
  • Implemented supporting s for XLA of AR module.
  • Setting up of MOAC for managing multi-org setups.
  • Issue Resolution, which includes managing the issues that come up during the course of the project and getting it resolved in a timely manner.
  • Defined value sets, profile options, registering the reports in oracle Financials (executable, concurrent programs, and request groups.
  • Prepared RD020, BR100, TE040 (Test Scripts) and End User Manuals.
  • Forms and Reports Customization to provide functional specifications to technical team
  • Logged, viewed, accessed, monitored, followed up, and closed Service Requests (SR) online - Oracle MetaLink.
  • Developed Functional and Technical documents (MD50, MD70) for various RICE objects as per RICE components.
  • Provide effective support during critical milestones e.g. CRP and UAT etc.
  • Analyze the various project requirements and transferring the knowledge to offshore team.
  • Facilitate System Integration Testing and User acceptance testing along with test data preparation.

Hire Now