We provide IT Staff Augmentation Services!

Oracle Financials Functional Analyst Resume

SUMMARY

  • 10+ years experience in Analysis, Design and Implementation of Oracle Applications Modules General Ledger, Accounts Payable, Accounts Receivable, Advanced Collections, Fixed Assets, Cash Management, TCA, E - Business Tax, Project Accounting, iExpenses, Order Management, Purchasing and Inventory.
  • Experience in Implementation and Support of Procure to Pay, Order to Cash and Record to Report Business Processes.
  • Experience in Application Design, Customization, Test Script Generation, Training End Users and creating Training Documents.
  • Well Experienced in configuration and support of Multi-Ledger, Multi-Org, and Multi Currency Global Oracle Applications.
  • Strong Exposure to Data Conversion and Migration to Oracle Applications from Legacy Systems, Validating and Loading Data from third party systems to Interface Tables, Handling the Errors.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Financials Functional Analyst

Responsibilities:

  • Worked as Oracle Financials Functional Analyst
  • Client has implemented Oracle EBS version 12.2.3
  • Client company was looking to develop training documents for Oracle Processes for all the modules they have implemented.
  • Developed training documents for General Ledger, Accounts Receivable, Advanced Collections, Shipping, Costing modules.
  • Worked with the Business users in understanding the Exterran processes and created Job Aids, Training Sets and User exercises.
  • Obtained the signoffs from the Business users regarding the training documents.

Confidential

Oracle Financials Analyst

Responsibilities:

  • Worked as Oracle Financials Analyst
  • Client has implemented Oracle EBS version 12.1.3
  • Client company was acquired by Siemens and its IT systems were being integrated with those of Siemens.
  • Worked in the implementation of new functionality in AP/AR modules as part of Intercompany Clearing project.
  • Both Confidential and Siemens have several subsidiary companies located in different parts of the world. Siemens has inhouse IT system to handle IC transactions. Confidential was to integrate with this system for IC transaction
  • Helped in the Post Go Live phase of the project.
  • Resolved Production issues.
  • Tested the software changes needed to fix the issues.
  • Coordinated with the Business users in testing the changes and obtained their sign off and promoted the changes to Production.
  • Also worked in the AR Invoice Change project. Siemens had remittance bank accounts for each currency and the relevant bank account has to show on the invoices based on its type and currency.
  • Tested for different types of invoices and different subsidiaries of Confidential
  • Coordinated with the Business users, obtained their sign off and promoted changes to Production.

Confidential

Oracle Financials Functional Analyst

Responsibilities:

  • Worked as Oracle Financials Functional Analyst
  • Client has implemented Oracle EBS version 11.5.10.2
  • Worked in implementation of new functionalities in AP/AR/GL modules improving business processes like Record to Report, Procure to Pay etc.
  • Client receives/makes large number of payments from customers/vendors and customized oracle to handle this.
  • Client has identified several problem areas in their current payment/receipt processes and requested these be fixed.
  • Conducted knowledge transfer sessions with the business users and IT resources to understand their current processes and the exact nature of the problem.
  • Written MD050’s to fix the issues and worked with the developers to change the custom programs.
  • Also suggested functional changes to the payment/receipt processes.
  • Given training to the business users in using the new processes.
  • Client has third party systems interfacing to Oracle.
  • Worked on exposure report by pulling data from three software systems including Oracle.
  • Provided functional design as well as the report format for the exposure report.
  • Used Tableau for creating dashboard reports

Confidential

Oracle Financials Functional Analyst

Responsibilities:

  • Worked as Oracle Financials Functional Analyst
  • Client has business operations in several countries and had implemented Oracle R12 solution having a primary ledger for each country.
  • Worked in reimplementing the secondary ledgers in GL module as part of Record to Report process.
  • Client had implemented Secondary Ledgers for 7 countries for the purpose of local statutory requirements. This implementation ran into reconciliation and other issues after the implementation team had left. I was asked to fix these issues.
  • Studied the existing setup of primary/secondary ledgers, Consolidation definitions and mapping rules. Since data had to be brought to the secondary ledgers from multiple ledgers, multiple consolidations were being used.
  • Obtained the reconciliation processes being used by the accounting team and identified the source for the reconciliation differences.
  • Corrected the Consolidation/secondary ledger setups and rerun consolidations for the FY 2014 in a test instance and obtained user sign off.
  • Also corrected SLA setup for AP invoices for two countries as per the user requirement and obtained user sign off.
  • Implemented the changes in Production
  • Given training to the inhouse IT resources.

Environment: Oracle Applications 12.1.3, AR, AP, GL, Proejcts, E-Business Tax, Oracle 11g.

Confidential

Oracle Financials Functional Analyst

Responsibilities:

  • Worked as Oracle Financials Functional Analyst
  • Client was not using Oracle for Tax reporting and this was objected to by the external auditors.
  • Designed and Implemented Secondary Ledger for US operations at balance level for Tax purposes. Implemented AR module and E-Business Tax module for a subsidiary business unit.
  • Designed and implemented Secondary ledger at Journal level for France for statutory purposes as part of Record to Report process.
  • Participated in requirements gathering sessions, designed the solution, configured Proof of Concept instance for business approval.
  • Configured the secondary ledger in test instance, helped in user testing, obtained business sign offs
  • Setup the customers as per TCA model
  • Written MD050s for custom components, worked with developers, tested the components.
  • Worked with Oracle Support in raising SRs and getting resolution.
  • Provided training sessions to the business users
  • Configured secondary ledger in Production.

Environment: Oracle Applications 12.1.3, AR, AP, GL, FA, iExpense, TCA, E-Business Tax, Oracle 11g.

Confidential

Oracle Financials Functional Analyst

Responsibilities:

  • Worked as Oracle Financials Functional Analyst
  • Helped in implementation of Financial Modules GL/AP/AR/FA as part of business processes like Record to Report, Procure to Pay etc.
  • Resolved UAT Issues and obtained User signoff
  • Conducted Functional Specification Document walkthrough with the business users
  • Helped Developers understand the Functional Specification document, tested the components developed by them and obtained the User signoff
  • Implemented E-Buisiness Tax module for NC Sales Tax.
  • Setup Scoring Engine/Dunning Plans/Strategies/Promise to Pay as part of Advanced Collections.
  • Performed setups for additional user requirements that came out of testing.
  • Held Training/demo sessions for users.
  • Worked on Oracle Budgets/Encumbrance accounting
  • Worked on 1099 reporting including Forms, E-Media File, Comma Delimited Report
  • Worked on setting up iExpense / AP Invoice approvals using AME
  • Helped in Invoice conversions done by the developers
  • Helped in Go Live Cutover activities.

Environment: Oracle Applications 12.1.3, AR, AP, GL, FA, TCA, Advanced Collections, iExpense, E-Business Tax, Oracle 11g.

Confidential

Oracle Financials Functional Analyst

Responsibilities:

  • Worked as Functional Analyst for Oracle Imaging Project
  • Helped in Gathering User Requirements for the Imaging Project which included AP Invoices/Expense Reports/Payroll Documents/PO Documents
  • Helped in finalizing the scope of the project and timelines for it
  • Coordinated with the offshore to setup Oracle Webcenter
  • Held Demo sessions for the users

Environment: Oracle Applications 12.1.3, Oracle Webcenter

Confidential

Oracle Financials Functional Analyst

Responsibilities:

  • Worked as Oracle Financials Functional Upgrade Analyst
  • Held discovery sessions with the users regarding their existing 11.5.9 system
  • Gathered additional user requirements to put into the new 12.1.3 system
  • Prepared process flow documents for all the financial modules
  • Setup the Ledgers/Operating Units/Accounting Flex field in Release 12 instance
  • Setup new Templates / Formats and Payment Process Profiles in Oracle Payments
  • Configured the GL/AP/AR/Advanced Collections/FA/iExpense/E-Business Tax modules in the new 12.1.3 system.
  • Setup Scoring Engine/Dunning Plans/Strategies/Promise to Pay as part of Advanced Collections.
  • Held CRP sessions to demonstrate the functionality of the Financial Modules in 12.1.3 instance
  • Written MD050s for conversions of open transaction data
  • Written XML reports for GL module as per client requirements.
  • Worked on Essbase Reports
  • Tested conversions done by the developers
  • Worked in EDI 810/820/844/849 Transmissions
  • Created custom BPA template for AR transactions
  • Converted customers as per the TCA model
  • Worked on Production Helpdesk tickets
  • Conducted UAT sessions with the end users
  • Resolved UAT issues logged by the users and obtained their signoff for going live.
  • Setup the financial modules in Production during cutover.
  • Provided Post Go-Live support.

Environment: Oracle Applications 12.1.3, AR, AP, GL, FA, TCA, iExpense, Advanced Collections, E-Business Tax, Oracle 11g.

Confidential

Sr. Applications Analyst

Responsibilities:

  • Worked as Sr. Applications Analyst.
  • Job duties include supporting the Production System and assisting in implementation of several ongoing projects like Global Rollout Project, New Countries Project, Oracle On Demand Project etc.
  • It is a Global Organization with Distribution Centers / Manufacturing plants all over the world. While the North/South Americas Solution was already in Production by the time I joined the company, APAC/EMEA regions went live later.
  • Resolved Production Helpdesk Tickets of various nature like FSG / Mass Allocations, AP Month End issues, AGIS / Consolidation / ADI issues, AR Auto invoice Issues, Reports Issues, Cash Management Issues, Data load Issues, Sabrix issues etc.
  • Supported Project activities relating to Global Rollout Project. Project activities included writing up BR100s / MD050s, configuring the test systems, conducting user testing, resolving issues arising from user testing and obtaining user signoff, configuring Production and going live and post go live support.
  • Changed Calendar to reflect December year end from the existing March year end for one set of books.
  • The company is expanding to new countries on a continual basis. IT is expected to bring these new countries operations into Oracle by setting up new set of books / Operating Units / Inventory Organizations. Worked as Finance Lead for the new countries projects and implemented GL/AP/AR modules
  • Implemented AGIS for all the new countries.
  • Company has e-commerce website which enabled the distributors to login, place orders and pay for them. Worked on integrating this with oracle in creating the orders and receipts in oracle.
  • Written MD050s for enhancements and done code review and testing. Supported AR interfaces from third party systems.
  • The company has implemented Oracle on Demand solution (Release 12) for the manufacturing plants. Supported the implementation of financial modules and E-Business Tax module as part of this project.

Environment: Oracle Applications 11.5.10.2 & 12.1.1, AR, AP, GL, FA, CM, Sabrix, iExpense, E-Business Tax, AGIS, Oracle 10.2.0.4.0

Confidential

Sr. Applications Analyst

Responsibilities:

  • Client Corporation was setting up International Development Center in India. This had to be integrated with its existing Oracle Applications
  • The reporting requirements for India IDC were different from the existing India Sales office. The consolidation of India GL data had to flow in different directions for the Sales office and the IDC. Suggested having a new balancing segment value for the India IDC and configuring Consolidation accordingly.
  • Modified the existing FSGs to include the India IDC.
  • Projects Module was implemented to track Capital Expenditures / Budgets relating to IDC.
  • Project Types / Templates / Organizations created.
  • Projects Auto accounting setup.
  • Assets Module was implemented to track the IDC Assets and integrated with the Project Module.
  • Setup Corporate / Tax Asset Books / Asset Categories / Prorate and Retirement conventions.
  • Conducted Testing Sessions with the Business Users for IDC Processes signoff. Created Test Scripts.
  • Provided Post Go Live support.
  • Client Corporation was setting up Auto lockbox & Positive Pay functionality within its existing Oracle Applications.
  • Studied the Check/Remittance advice data and identified Client specific business scenarios and mapped them to Oracle Applications.
  • Suggested changes to the Bank’s standard transmission format to suit Client’s requirements.
  • Worked with the Web methods and Client’s Network team for developing the process to daily download the data file from the Bank
  • Conducted Testing/Training sessions with the Business users for the new Auto lockbox Process signed off. Developed Test scripts / Training documents for the same.
  • Implemented Auto lockbox in Production and provided Post Go Live support.
  • Studied the Bank’s format requirements for the Positive Pay data files.
  • Worked with the Web methods and Client’s Network team to develop a process to daily poll Check data from Oracle and upload to the Bank.
  • Developed scripts for creating a data file to be uploaded manually to the Bank in case of Web methods failure to upload.
  • Worked with the Bank to have the data files, both manual and automatic, tested and signed off.
  • Coordinated with the Bank to have training session with the Business Users.
  • Implemented Positive Pay in Production and provided Post Go Live support.

Environment: Oracle Applications 11.5.9, AR, AP, GL, FA, PA, Oracle 9i

Confidential, Aliso Viejo, CA

Sr. Applications Analyst

Responsibilities:

  • Client Corporation was setting up Sales Offices in various International Locations. This had to be integrated with its existing Oracle Applications
  • Payables and Purchasing Modules were implemented to track PO’s/Invoices relating to these sales offices.
  • Studied the Organizational setup, Business Process Flow of the Organization and identifying the required set ups to map it into Oracle Applications.
  • Involved in planning and setting up Payables/Financial options in Payables Module.
  • Setup Banks both Cash as well as Intercompany.
  • Setup Multi Currency functionality and developed a process for payment of Foreign Currency Invoices in Oracle.
  • Conducted Testing sessions with the Business users and developed Test Scripts.
  • Implemented Payables/Purchasing Modules in Production and provided Post Go Live support.

Environment: Oracle Applications 11.5.9, AP, PO, Oracle 9i

Hire Now