We provide IT Staff Augmentation Services!

Oracle Financials Functional Analyst Resume

Atlanta, GA

SUMMARY:

  • Over 7.8 years of diverse experience in the field of Functional experience in retail and banking/ financial Industry.
  • In - depth Knowledge of the retail, financial, mortgage and banking Industry and its processes.
  • Rich experience in ERP product - Oracle 11i - in Multi-Org environment and in modules comprising of experience in Accounts Receivables (AR), Accounts Payables (AP), I-Expense, i-Payment, i-Procurement, i-Receivables, Oracle Project Accounting (Project Foundation, Project Billing, Project Costing), Advance Collections, General Ledger (GL), Purchasing (PO), Oracle Order Management (OM), Inventory (INV), Fixed Assets (FA), Oracle Federal Financials, AOL and System Admin and integrated custom applications.
  • Experience with Confidential 170 Systems
  • Experience with Oracle User Productivity Kit (UPK ) and Oracle Tutor
  • Has experience in Implementation and Production support
  • Having enriched experience as Business Requirements gathering, Gap analysis, solution design, configuring, setups, Test Plan Preparation, Unit Testing, System Integration testing, and production support in supply chain and distribution industries
  • Experience and knowledge on AIM methodologies.
  • Project Management & Coordination in multinational and multi-cultural environment.
  • Effective communicator and energetic team player with excellent business and interpersonal skills.
  • Heavily involved in brainstorming sessions, GAP analysis, Root Cause Analysis, Risk Analysis, walkthroughs, meetings, and JAD sessions with all stakeholders in the project.
  • Strong experience in interviewing End-Users, Internal and External Stakeholders, Business Owners and Subject Matter Experts to gather business requirements.
  • Specialized in creating UML Diagrams like Use Case, Activity and data flow diagrams using Rational Rose and MS-Visio.
  • Experienced working with Developers and Quality Analysts both onsite and offshore teams.
  • Worked on different application solutions including client server application and web based applications.
  • Worked with the QA team in conducting System Integration Testing (SIT) and supported the User Acceptance Testing.
  • Experience in QA procedures, Test Plan, Test Scripts and working with multiple testing environments.
  • Extensive knowledge of generating reports by executing SQL queries against different databases such as Oracle, MS Access.
  • Used web-based test management tools such as Mercury Quality Center to link requirements and tests; execute tests and report/monitor bugs until completion. Generated execution report, defect report and traceability matrix by using Quality Center.
  • Experience in finance industry and in the ETL process.
  • Extensive experience in writing correspondence, project status reports, e-mails, etc. to keep executive staff and team members apprised of goals, project status and resolving conflicting issues.
  • Excellent judgment skills in identifying areas of high-risk, critical business areas, early in an application and prioritize my tasks to focus my efforts when time is limited.
  • Highly motivated team player with good communication and interpersonal skills.

TECHNICAL SKILLS:

Software: Oracle: 11i

Modules: General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), i-Procurement, Confidential 170 Systems, Fixed Assets (FA), Cash Management (CM), Costing and Inventory (INV).

Expertise: General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), Inventory (INV)

Operating System: MS-Windows & DOS, Mac OS

Productivity Packages: MS Office, MS-Access, PowerPoint, MS Outlook

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Oracle Financials Functional Analyst

Responsibilities -

  • As a Functional consultant implemented financial modules: AR, AP, I-Expense, Oracle Project Foundation, Project Billing, Project Costing, GL, e-Business Tax, FA and CE
  • Performed Requirement and Gap analysis. Configurations and Setups AR, Treasury, AP, GL, Project Foundation, Project Billing, Project Costing, e-Business Tax, FA and CE
  • Worked on the Oracle Project Foundation, Project Billing, Project Costing module - setting up the projects, tasks, burdening, cost allocation, cross project charging, ect.
  • Worked on the setups of i-Expense module - setting up the expense report templates, per diem, integration with AMEX cards, expense approvals, expense categories, etc.
  • Configured Taxation for US Sales Tax, Canadian GST and VAT Tax in EMEA in e-Business Tax module. Involved in the configuration of Tax Content Service, Tax Determination Services, Tax Users, Look Up Codes, Confidential Geography Hierarchy, Confidential Classifications for Tax, Tax Classification Codes, Tax Accounts and Tax Accounting Information.
  • Worked on the data conversion from 11i to Release 12 for all financial modules.
  • Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
  • I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
  • Pre upgrade testing and Post upgrade production live support.
  • Support Production issues on a day to day basis including month end closure p1 issues
  • Implementation and support of Cash Management and Account Payable Module
  • Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, CM, and AR) and create new ones based on business requirements.
  • Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex Field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
  • Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Environment: Oracle Applications Release 12.1.1 Upgrade from Release 11.5.10.2 Rollout for US, Canada, EMEA and Middle East AR, Treasury, AP, GL, FA, Project Foundation, Project Billing, Project Costing, CE, Sub Ledger Accounting, Financial Accounting Hub, e-Business Tax

Confidential, San Diego, CA

Oracle Financials Functional Consultant

Responsibilities:

  • Conducted study on current busiO2C Business flow including OM, Project Foundation, Project Billing, Project Costing, AR, FA, GL, PO, I-Expense modules.
  • Worked on the setups for Project Costing, Project Billing and Project Foundation modules.
  • Worked on the setup of the Approval Hierarchies, Document Types, Matching rules, PO Options in Purchasing Module
  • Worked on all of the setups in the i-Expense module and worked on the integration of i-Expense with AP.
  • Gathered and analyzed business requirements including process reengineering. Documented functional requirements pertaining to financial modules and security features.
  • Created new Assets (from new acquisitions) in Enterprise Asset Management (EAM)
  • Involved in troubleshooting issues on Enterprise Asset Management (EAM) Mass Additions.
  • Worked on the process of retiring Asset process in Enterprise Asset Management (EAM).
  • Setup Oracle Assets Function security in Enterprise Asset Management (EAM)
  • Performed all setups and configurations for Revenue Recognition process in AR module, including the setups of Accounting and Invoicing rules, AR Transaction types, Auto Accounting, etc.
  • Worked on the Costing Module to Update Standard Costs, Rolling up Assembly Costs, Updating Pending Costs to Frozen Standard Costs, Setup Inventory Standard Costing method.
  • CRP and user acceptance test (UAT) were carried out for the above modules. Trained the end users and resolve problems during UAT.
  • Prepared whole data conversion approach and cutover strategy for balances from their legacy system to Oracle Application.
  • Developed ADI templates for data conversion to GL and FA. Converted Data from the legacy system to Oracle through Open Interface tables.
  • Assisted the Client with Production Data Conversion, Reconciliation and Execute tasks for Go-Live activities.
  • Developed and tested the financial statements as per requirement using Financial Statement Generator (FSG)
  • Coordinated with technical and DBA team for resolving the customizations issues and documenting them
  • Provided functional support to other teams and troubleshooting and maintaining the system

Environment: Oracle Apps 12.1.1 (OM, Project Foundation, Project Billing, Project Costing, AR, FA, GL, PO, I-Expense), Toad, Discoverer, Solaris 2.6.

Confidential, San Diego, CA

Procure to Pay Functional

Responsibilities:

  • As a Business Analyst Supported Procure to Pay Process Release 12.1.3
  • Lead Conversions & Enhancements for OM, PO and INV module
  • Worked on setting up of Revenue Recognition process in AR Module
  • Worked in configuring the Approval Hierarchies in PO module
  • Worked on the setup of i-Procurement module including the setting up of Catalogs, Categories and Uploading Items into i-Procurement, Punch-out’s both transparent and direct.
  • Worked on the setup of Purchasing Options, Financial Options and Document Types in PO Module.
  • Worked on the configuration of the Intercompany transactions using the Internal Requisition Internal Sales Order (IRISO) process.
  • Configured PO, INV, i-Procurement, AP modules from scratch and simultaneously created BR100 documentation for the setups.
  • Worked on the Localizations for Europe (Netherland, Spain, Italy), UK, Mexico, Latin America, Japan, China
  • Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
  • Completed Multi-Org configuration by creating a new Organization Structure for WVI (World Vision International) by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
  • Conducted Regression testing to examine the effects of a new Org on the previous Org.
  • Conducted Multi-Org Revert Testing to create an effective Revert Plan for WVI, as and when required.
  • Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
  • Created FSG Financial Reports critical to company’s business process.
  • Worked on creation of Confidential Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL.

Confidential, San Diego, CA

Oracle Apps P2P Functional consultant

Responsibilities:

  • As a Functional Consultant implemented the Order to Cash Business flows including OM, AR, AP, GL, Project Costing, Project Billing, INV and Pricing
  • Performed Requirement and Gap analysis.
  • Configurations and Setups for AR, OM, GL and AP modules
  • Worked on the setup of Revenue Recognition in AR module.
  • Setup of Accounting and Invoicing rules in AR module
  • Defined the Auto Lock Box process in AR module
  • Defined the Auto invoice process in AR module
  • Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
  • 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 Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
  • Pre upgrade testing and Post upgrade production live support.
  • Support Production issues on a day to day basis including month end closure p1 issues
  • Implementation and support of Accounts Receivables and Account Payable Module
  • Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Confidential, LA, CA

Functional Consultant

Responsibilities -

  • Gathering business requirement by having detailed discussions with business team.
  • Functional Specification writing, Reviewing Master business requirement details, Gap analysis.
  • Worked on the Localizations for Mexico and India.
  • Review other functional Specifications.
  • Worked on the set ups all the modules in Order to cash cycle.
  • Preparing various functional requirement and propose high-level design details for programs to keep data in AR, AP, GL, OM and INV
  • Involved in setups, requirement gathering and functional specs preparation for Oracle incentive compensation.
  • Prepared high-level technical design document.
  • Interacting with upper management to identify the business process and needs and with end users to identify their requirements.

Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.10.2), AR, i-Procurement, PO & AP.

Confidential, Seattle, WA

Oracle Applications 11.5.10.2 Implementation

Worked as a functional Consultant to implement Oracle Application 11.5.10.2 involving PO, i-Expense, AP, AR, GL and FA Modules Meet with customers to understand their system and service requirements Writing Functional Specification and coordinating with the technical team to develop AP Check Printing, EFT, PO Form and AR Invoice. Assist in the regression testing of Oracle Modules as required.

Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.10.2), PO, AP, i-Expense, AR, GL and FA

Confidential

Oracle Applications 11.5.10 Implementation

Responsibility: -

  • Provided analysis, design, installation, setup and rollout of Oracle 11i Order Management Logistics, Manufacturing module and established proof-of-concept.
  • Setups included Multi Language, Multi Reporting Currency, Multi Organization
  • Worked extensively on Confidential architecture and was involved in migration of customers from various legacy systems into Oracle Confidential architecture.
  • Developed interfaces and data conversion programs for applications
  • Addressed operational problems, concerns, and questions posed by users
  • Interacting with upper management to identify the business process and needs and with end users to identify their requirements
  • Setting up profile options values (standard and custom), set up for OM, AR and PO.
  • Involved in Inventory org setups.
  • Was involved in the 4-D methodology (Discover, Design, Develop and Deploy).
  • Preparing technical specifications for the sub modules like (Customers, OM, Shipping, Interfaces, etc).
  • Implementation methodology documentation including technical specs and functional specs.
  • Liaising with client key users and technical team, conducting CRP/testing
  • Ensuring order Processing/Booking (OM) during month/quarter/year end and resolving inter-company accounting issues.
  • Responsible for transfer of data from External systems like Web, EDI, PO to OM.
  • Responsible for transfer of data from OM to AR and ensuring no records are stuck in the interface.
  • Resolving issues related to flex fields and sysadmin setups.
  • Design and development of custom reports and FSG reports.
  • Design of custom forms and extensions for OM and PO module.

Environment: Oracle 8i, Developer 2000(6i), PL/SQL, SQL, Oracle Financial Applications 11i(11.5.10.1), AP, AR, PO, OM (Functional & Technical - AOL, Sys admin), SQL Net, Oracle Workflow, Oracle Discoverer, Designer 2000, TOAD, SQL Loader, Unix.

Hire Now