Oracle Financials Functional Analyst Resume Profile, FL

Reference Id: 83154     Posted on Friday 18th September 2015      Oracle



Please note that this is a not a Job Board - We are an I.T Staffing Company and we provide candidates on a Contract and Full-time basis. If you need I.T.Professionals to fill a Contract or a Full-time Position, please call (800) 693-8939

Oracle Financials Functional Analyst Resume Profile, FL

Professional Summary:

  • Highly experienced with 17+ years IT domain experience including 9+ years as an Oracle Financial Functional Analyst.
  • Experience in R12 and 11i end-to-end full cycle Implementations, Upgrade and Productions support projects.
  • Strong experience in General Ledger(GL), Receivables(AR), Payables(AP), Cash Management(CE) and Fixed Assets(FA) .
  • Worked in multiple projects in environment of Multi-Org and Multi-Currency.
  • Good Knowledge and experience in Oracle AIM Methodology of implementation and documentation .
  • Excellent knowledge of Oracle Financial Modules functionalities, P2P, O2C, A2R and their interplay with overall accounting structure .
  • Experienced in all levels of testing including functional testing, integration testing, system testing, regression testing, user acceptance testing using SQL.
  • Executed SQL queries on PL/SQL server tables to view successful transactions of data and for validating data.
  • Strong experience in providing functional specifications to RICE Components.
  • Expert in Functional Analysis, Requirement Analysis, Process mapping, Functional specification preparation, application configuration, Testing, Data migration and user training. Rich experience in working with multi location technical resources and offshore team to complete deliverables
  • Highly Quality oriented, self driven and motivated for timely target achievement, Effective oral and written communication skills, presentation skills, strong analytical problem solving capabilities, planning and organizational skills.
  • Extensive hands on with using AIM Methodology including BR100, TE40, RD20, BP80, MD50, CV40, etc.

Technical Skills:

Oracle Applications : Oracle 11i (11.5.8, 11.5.9, 11.5.10, 11.5.10.2), R12 (12.0.3, 12.0.5, 12.0.6, 12.1.1, 12.1.3) - GL (SLA ), AP, AR, FA, CE, e-B Tax, PO and Approval Workflow.

Knowledge on other

Module & cycles : OM, PO, INV, P2P, O2C, A2R

Documentation : AIM Methodology (Scope, Business Process, Business Requirement, Conversions, Mapping).

Database : Oracle 9i/10g/11g,Confidential SQL SERVER.

Languages : C, Java, SQL, PL/SQL,C#.Net., Main Frame Programming,

Operating Systems : Windows (95, 98, XP, NT, Vista, 7), Linux.

Other Tools :Confidential Office 2003/2007/2010,Confidential Visio 2007, Use of SQL Developer, ,Confidential Visual Studio, SQL server, UPK (User Productivity Kit), Hyperion, Web ADI, Data loader and XML publisher.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Financials Functional Analyst

Environment: Re-implementation and Post production support, version 12.1.3 (GL, P2P, AP, FA).

Responsibilities:

  • Conducted client interviews to complete the business process analysis and to prepare the business requirements documents.
  • Developed BR100 , CV40, MD50, and TE40 for Citi Confidential FA module.
  • Conducted CRP2 and coordinate UAT Session & responsible to get business signoff on all proposed test cases.
  • Set up the accounting setups and assign the modified accounting method in to ledger.
  • Defined Journal source and categories for import journal from other source.
  • Involved and resolved problem in Journal Import Process.
  • Defined translation set and consolidation set.
  • Set up Fixed Assets including defining category, location, and asset key flex fields.
  • Created mass additions, worked on Mass additions program and Asset workbench.
  • Defined the prorate calendars, depreciation rate and calendars, fiscal calendars.
  • Setup book controls, corporate book and tax book.
  • Defined different deprecation method for corporate book and tax book.
  • Modified accounting method in AMB as per requirement with help of accountants.
  • Modified Account derivation rule in accounting method.
  • Grouped assets associated with a specific project, department, and location to track CIP assets in the organization.
  • Designed and created test scripts and user-manuals for the FA module including: Quick additions, detailed additions, Transfer an asset between Departments, Change an asset's Category, Load assets via Additions Integrator, Change an asset's life, Merge multiple asset lines into one asset, Retire a group of assets, Undo a mass retirement, Run Depreciation Projections, Perform Periodic mass copy, Perform a financial inquiry viewing transaction history, View an assets transaction history, Submit standard Oracle assets report, Perform physical inventory, Reconcile assets to General Ledger.
  • Assisted in data migration from the legacy system
  • Interacted with Oracle Support to resolve the issues through SR/TConfidential
  • Preparation of Cut- over Plan, Listing down all Pre & Post Go- live tasks.

Confidential

Oracle Financials Functional Analyst

Environment: Up-gradation and Post production support from version 11.5.8 to 12.1.3 (GL, AR, OM).

Responsibilities:

  • Worked with business users to gather requirements.
  • Solution to complex issues through Metalink.
  • Set-up of system setup options in Confidential
  • Prepared the MD50 and worked with technical team regarding Rice components.
  • Developed Aim documentation BR-100 for Application Setup.
  • Analyzed and mapped historical data of existing customers.
  • Created customer profile classes, attached payment terms, collectors, matching receipts, statement cycle to profile classes.
  • Defined system options, transaction types, remittance banks, bank accounts, receipt classes, distribution sets.
  • Loaded profiles for all Capacity charge Customers.
  • Updated Project customers contact information (Bill to and Ship to) on production instance.
  • Wrote TE.040 Test Scripts for Functional Testing ofConfidential and OM Modules.
  • Developed test scripts in PL/SQL for end users.
  • Was involved in the testing for the followingConfidential and OM components: Customer setup, Review Customer Account Details, Define Receivable Activities, Define Transaction Type, Modify a Customer record, Open and Close Receivables Accounting, Define Standard Memo Lines, Apply On-Account Credit, Run Standard Oracle Reports, Submit Requests, Define Distribution Sets, Transactions Summary, Define Payment Terms, Review Imported Invoices, Correct Autoinvoice Interface errors, record customer Communication, Create different Type of Invoices (Chargeback,Credit Memo, Debit Memo, Deposit, Guarantee, Invoice) for testing, Reverse an Applied Receipt, Add Customer Contact, Transfer Receipt to another Customer, Create Automatic Receipt Write-Off, Create Automatic Transaction Write-Off, Print aging report, Different Categories of Capacity Charge reports, Create Customer Profile, Generate Late Charges, Create Cash Receipts.
  • Testing of Oracle EBS System R12, Focusing on OM module for the following components. Product order Management, Pricing Management, Shipping management.
  • Created user manuals and trained the end users.

Confidential

Oracle Financials Functional Analyst

Environment: version 12.1.3 (GL, AP, P2P, CE)

Responsibilities:

  • Participated in multiple business meetings for Fit-Gap Analysis and Solution.
  • Assisted functional lead analyst to conduct CRP1 and CRP2.
  • Prepared BR.100 Application setup and Confidential 50 Application Extensions Functional Design documents according to AIM.
  • Involved in configuration of CRP1, UAT and test instance.
  • Trained Super Users and troubleshooting during UAT (User Acceptance Test).
  • Used the System Administrator responsibility to define users and assign responsibilities and set profile options
  • Define Organization Structure (MOAC), Users and Responsibilities, Security Profiles and Flex Fields
  • Set-ups and maintenance, converted the headers, lines and line locations from the legacy system to Oracle Payables
  • Involved in setup for Payables, Inventory, Purchasing, General Ledger based on deep understanding of the functional processes
  • Design & Develop FSG reports in GL
  • Set upConfidential bank accounts, bank documents, bank codes and expense report templates
  • Defined profile options to specify certain implementation parameters
  • Set up Recurring journals template, recurring journals and Auto-reversal in GL.
  • Set up suppliers, locations, and purchasing quick codes.
  • Setup payment terms, invoice distribution, matching of invoices against PO.
  • Configure Financial Options and Payables Options in AP.
  • Created custom Customer invoice print templates
  • Configure System Options in CE.
  • Worked on Cash forecasting, reconciliation, Cash pool and Cash positioning
  • ReconcileConfidential with bank statement in Cash Management.
  • Activation of various flexfields in the forms to gather the additional information
  • Developed test scripts in PL/SQL for end users.
  • Participated in testing. user acceptance testing in test instance using PL/SQL and worked with certain key super users.

Confidential

Environment: version 12.1.1 (GL, AR, eBTax)

Responsibilities:

  • Presented requirement questionnaire to the business and mapped business requirements. Prepared RD.20 and BP.80 according to AIM implementation methodology.
  • Preparing Visio Process diagrams forConfidential IS / TO BE scenarios.
  • Worked with the business to come up with the future business process
  • Configured multi-org business structure in Oracle, Ledger Setup, Legal Entity, Establishment Setups and MOAC security.
  • Set up Multi-Currency environment
  • Created Customized responsibilities, customized menus, customized request groups
  • Designed a Prototype (Demo) configuration of French Localization as per client's request.
  • Created BR.100 Application setup and CV.040 Conversion data mapping documentation for GL, AP, AR, SLA (Sub ledger Accounting)
  • Contributed towards Conference Room Pilots CRP1 and CRP2
  • Coordinate with offshore technical team for data conversion.
  • Helping users upload journals using Web ADI in GL
  • Involved in Scheduling the Reports
  • Configured GCS (Global Consolidation System) to consolidate balances from French Ledger with Parent company Ledger
  • Configured AGIS for LeapFrog Head Office to handle their inter-company transactions along with defining intra-company rules
  • Setup International Tax Calculation including UK (VAT) and Confidential (VAT)
  • Defining System Option Parameters in AR
  • Completed setup and demonstration of handling Refunds
  • Prepared System Test Scripts TE.040 for UAT sessions and Training Documents with screenshots for end users
  • Prepare and Configure Setups in Production Instance and Production Support
  • Define State, County, City, Tax Regimes, Tax, Tax Rates and Tax Rules in eBusiness Tax module
  • Provided various custom solutions for client's specific needs
  • Trained end users using Oracle UPK (User productivity Kit)
  • Provided with post-production support after go live on GL,Confidential andConfidential modules

Confidential

Oracle Financials Functional Consultant

Environment: version 12.0.6 (GL, AP, AR, FA & CE)

Responsibilities:

  • Train the business users on Global Translations, Revaluations and Consolidation of Multiple Ledgers.
  • Writing TE.040 Test Scripts for Functional Testing of GL, AP, FA and developing Guided Navigations
  • Developing Training Material for AP, FA modules
  • Conducted end user training sessions and User manuals.
  • Post implementation support and maintenance - performed successful three month end and period close activities in the newly implemented modules
  • Design and Configure Financial Statements Using FSG
  • Maintain issue tracker using Bugzilla and issue resolution.
  • Conduct business meeting whenever required based on issues and new functional requirements.
  • Prepare documentation for change management process along with impact analysis on the proposed solution.
  • Create and follow up on Service Request (SR) with Oracle support.

Confidential

Environment: Upgrade from 11.5.10.2 to R12.0.6 (AP, AR, CE, eBTax)

Responsibilities:

  • Involved with Super User Training and resolving post UAT issues.
  • Re-defined system parameters and Bank Statement Mapping in CE
  • Perform additional Setup for Customer and Address Relations in TCA Architecture
  • Corrected the system configuration to take care multi currency invoice entry and payments
  • Worked on Trading Community Architecture (TCA) and customizing customer import program for site/contact information
  • Defined the 1099 suppliers and testing the tax payment extractions for reporting purpose
  • Developing AP,Confidential and CE Training Guides
  • Setup the Auto Cash rule set according to client requirements
  • Prepared Static and dynamic data template for collecting all the information about the Banks, Vendors, Customers, Tax Codes etc.
  • Develop/Update Discoverer Reports for Month End Reports
  • Support Business Users in Month End Close Process
  • Resolve the Reconciliation issues with Sub ledgers to GL
  • Prepared documentation at various phases.
  • Confidential

Oracle Financial Functional Analyst

Environment: R12 Upgrade from 11.5.10.2 to R12.0.5, (AP & AR)

Responsibilities:

  • Set-up of financials options, payables and payables System options in AP
  • Set-up of system setup options in AR
  • Involved with migration of historical data for Accounts Payables and Accounts Receivables.
  • Set-up of invoices, debit and credit memos, guarantees, transaction types
  • Set-up receipt class, receipt methods, receivable activities
  • Created the supplier, supplier sites, banks and bank account
  • Configured the Sub ledger Accounting(SLA) setups
  • Created customer profile classes, attached payment terms, collectors, matching receipts, statement cycle to profile classes.
  • Participated in CRP and UAT
  • Prepared theConfidential 50 and worked with technical team regarding RICE components
  • Prepared and executed test scripts (TE 40)
  • Created user-manuals and trained the end users

Confidential

Oracle Financials Functional Consultant

Environment: version 11.5.10.2 - Support (GL)

Responsibilities:

  • Cut over and Go live as per the schedule and provided post-production support.
  • Writing User Manuals and Training End Users.
  • Conduct business meeting whenever required based on issues
  • Issue tracking and solution, maintained documentation for the same
  • Functional enhancement for invoice approval workflow
  • Reset security rules to restrict access of users for only few fixed responsibilities
  • Followed a strict change management process involving end users followed by problem analysis, development or bug fixes, unit testing and user acceptance testing with thorough documentation maintained at all stages.
  • Opened and followed through on Technical Assistant Request (TAR) with Oracle.

Confidential

Oracle Financial Functional Analyst

Environment: Implementation and Production Support 11.5.10.2 (GL,Confidential and AP)

Responsibilities:

  • Defined Business requirements for Oracle GL and AR, involved in identifying GAPS
  • Prepared Documentation of BR 100, BR 30 and Functional Extension and design DocumentConfidential 50
  • Involved in all the business meetings and communicated with the business for system updates and the meeting of implementation deadlines
  • Was involved in finding effective solutions that consisted of both work around and customizations to the forms and reports
  • Identified RICE components according to the client needs
  • Created Chart of Accounts, accounting Calendar, Currency, defined Legal entities and completed Ledger accounting options as per client requirement
  • Created multiple responsibilities, developed security rules and customized menu to restrict user access to GL functionality as per client's requirement
  • Defined formulas for Mass Allocation and Recurring Journals and completed setup of options required to perform Mass Allocations
  • Defined Budgets, Budget Organizations, Budget Formulas, and Defined Budgetary control options, Created Master/Detail budgets, Defined Mass Budgets and Mass Budget formulas
  • Involved in the setup of inter-company balancing and global inter-company system
  • Designed and created reports for client using the FSG
  • Defined setup steps of theConfidential module. These included System Options, Receipts, Lockbox, Quick Codes and Taxes. Exemptions were defined, as products were not subject to tax in all states
  • Defined Customers, customer profile classes, payment terms, and distribution sets, and Auto Cash Rule Sets
  • Defined Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources
  • Defined accounting options, methods of accounting, realized gain/loss account, unallocated revenue account, auto cash rule set, and auto invoice tuning
  • Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defined collectors, and defined aging buckets
  • Created customer profile classes, attached payment terms, collectors, matched receipts, statement cycle to profile classes
  • Setup transaction types, invoices, guarantees, deposit, and credit memos, debit memos
  • Assigned receivable account, revenue account, unbilled account, freight account, cleared account, and unearned account to transaction types
  • Conducted CRP 1, CRP2, CRP3 and tested all the setup

Confidential

Oracle Financials Functional Consultant (GL,Confidential & AR)

Environment: Oracle Application 11.5.3 to 11.5.10.2 - Up-gradation & Production Support

Responsibilities:

  • Designed and created new CHART OF ACCOUNTS and set of books
  • Created users and modified the privileges for users, rollup group and summary accounts
  • Created suspense accounts for automatic balancing journal entries from particular sources and categories
  • Created budget, budget organization, master detail relationship, budgetary control and budgetary control groups
  • Define the Global Inter-company System (GIS), Designed and Setup the Global Consolidation System
  • Developed several FSG reports, including balance sheet and income statements
  • Set-up supplier and supplier sites for suppliers in payables
  • Developed several custom reports and customized oracle reports for payables
  • Set up banks, receipts, transactions, plus training for invoicing, receipts, adjustments, and period close
  • Created updating adjustment of invoices, debit memos, credit memos
  • Defined banks, customers, receipt classes, collectors
  • Analyzed and mapped historical data of existing customers
  • Setup customer profile class, profile attributes, customer relationships, statement cycles and accounting rules
  • Defined system options, transaction types, auto cash rule sets, remittance banks, bank accounts, receipt classes, distribution sets and payment methods Trained and guided users through the testing period

Confidential

Oracle Financial Functional Analyst

Environment: Implementation of 11i 11.5.10 (GL & AP)

Responsibilities:

  • Member of the core team responsible for implementing and setup of GL and AP
  • Involved in current system analysis and GAP analysis system configuration and testing in GL andConfidential module implementation. Involved in organizing work shop with the end users for requirement gathering, limitations of existing system and proposed the solutions.
  • Setup suppliers, supplier sites, banks and bank transaction codes
  • Set up the approval hierarchy for expense reports
  • Created employee expense templates for different departments
  • Involved in developing test scripts, creating user manuals and end user training
  • Configured the Sub ledger Accounting(SLA) setups
  • Configured setups for Global consolidation, Multi reporting currency and FSGS
  • Configured the setup for batch invoices and batch payments, multi currency invoices and multi currency payments to meet the requirements in AP.
  • Developed AIM documentation RD-20, BR-100, CV-40, MD-50, and TE-40 for business requirements, system setups, conversions, customizations and functional testing respectively.
  • Extensive unit and integrated testing done before CRP's & UAT

Confidential

Jr. Oracle Financials Functional Consultant (GL & AR)

Environment: Oracle Applications 11.5.9 - Implementation

Responsibilities:

  • Identified Business needs, Gaps and Requirements Analysis
  • Defined GL Responsibilities, Value Sets, Key Flexfield Segments, Period Types, Accounting Calendar, Currencies and created Set of Books
  • Defined Recurring and Allocations Formulas
  • Setup the Global Consolidation System, involved in Creation of customized reports as per the client's requirement in Oracle GL using FSG
  • Performed Complete Setups related to manual and automatic receipts
  • Defined Profile Options to specify certain implementation parameters, Processing Options and System Options
  • Defined Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources
  • Involved in defining Tax features such as Codes, Rates, Exceptions and Exemptions
  • Involved in Defining Organization, auto cash rule set, auto invoice tuning
  • Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defining distribution sets
  • Defined receipt class, specifying creation method, Payment method, clearing method, defining collectors, defining aging buckets
  • Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes
  • Trouble-shooting in GL & AR
  • Involved in CRP 1, CRP 2
  • Involved in UAT user acceptance test

Confidential

Senior Programmer / Analyst

Responsibilities:

  • Designed, analyzed, coded, and tested functions for subscription system, authoring documents which were reviewed and approved by management team for each project.
  • Developed institutional marketing's subsystem external design specification, internal design specification, and coding.

Involved in analysis, design, coding, and testing phases for the following projects: Data mail System for Institutional Marketing Department, Data graph system for Trading department, Accounting System for William O' Neil & Co., Finadco System, ODS Corporation System, Data analysis system, Brokerage System for Trading Department, Subscription System for Daily graph Department, Telemarketing System for Daily graph and IBD Department, Merrill Broad court System for Trades and Trading Department, and Stock mart System for employee trading.

Search Resumes

Looking for I.T Professionals on a Contract basis?