Lead Oracle Financial Functional Analyst Resume
4.00/5 (Submit Your Rating)
Bellevue, WA
SUMMARY:
- 8.3 years of primary concentration on Oracle ERP/CRM implementations and business process re - engineering.
- Functional Consultant specializing in Oracle Application implementations, specifically Quote to Cash, Invoice to Cash, Record to Report and Procure to Pay
- Extensive engagement work and project implementation experience has given her an insight into the interactions between Oracle’s modules and project implementation methodologies.
- Business experience and background has helped to foster a detailed knowledge of best practices regarding the accounting and finance functions.
- Worked with Joint Application Design (JAD) Sessions, Conference Room Pilots (CRP) and User Acceptance Testing (UAT)
- Worked on 2 projects in Release 12 - extensive experience with the new features of Release 12 like Multi Org Access Control (MOAC), Sub Ledger Accounting, Payment Manager, TCA enhancements, e-Business Tax, New Revenue Recognition Rules (Event based and Rule Bases), Deferred COGS, etc.
- Accounts Payables (AP), General Ledger (GL), Cash Management (CM), Costing, i-Expense, Purchasing (PO), Oracle Order Management (OM), Inventory (INV), Channel Revenue Management, TCA, AOL and System Admin and integrated custom applications.
- Strong on Oracle’s Application Implementation Methodology (AIM)
- Detailed knowledge of Oracle E-Business Suite manufacturing and supply chain software, release 12, specializing in Financials, SCM, and Lean business concepts
- Oracle Applications R12 E-Btax - General Ledger (GL), Inventory (INV), Purchasing (PO), Order Management (OM), i-Procurement (i-Proc), Shipping, Account Receivables (AR), Payables (AP), XML (BI) publisher
- Methodologies and Documents: Oracle’s Application Implementation Methodology (AIM), Oracle Document - BR030, BR100, BR010, TE20,
- Exceptional requirements definition, mapping and gap analysis skills
- Experienced in configuration, setup, and testing of Oracle EBS Manufacturing and Supply Chain software
- Producing document deliverables
- Excellent written, oral, visual, and multi-media communication skills.
- Experience working with offshore / remote teams.
- Extensive experience in developing and delivering customized functional training
- Over 7 years of experience working with clients in a manufacturing and retail.
PROFESSIONAL EXPERIENCE:
Confidential, Bellevue, WA
Lead Oracle Financial Functional Analyst
Responsibilities:
- As a Lead Oracle Financial Functional Analyst, worked on the solution for the functional designs, which include integrations with various 3rd party vendors and managing the enhancements/mini-projects, and Monitoring, the issues/tickets raised by business users and ensure them to closure.
- Leading teams both from onshore and offshore from the Financials functional track standpoint and help resolve the issues on functional designs, functional setups, business use cases and project deliveries
- Functional Upgrade of 11i to Release 12.1.3 of Account Receivables, Credit and Collections, Advance Collections, General Ledger, Accounts Payables, Cash Management, Fixed Assets modules.
- Worked on Cash Management (CM) module - Worked on defining bank transaction codes, bank statement interface, bank statement mapping, setting up bank statement signing authorities, reconciling bank statements, creating payment and receipt transactions, reconciling adjustments and corrections to bank errors.
- Worked on Cash Forecasting in Oracle Cash Management
- Worked on Cash Positioning in Oracle Cash Management
- Define Cash Pools in Oracle Cash Management
- Worked with Joint Application Design (JAD) Sessions, Conference Room Pilots (CRP) and User Acceptance Testing (UAT)
- Implementation of Revenue Recognition process in Oracle AR module - - defining the revenue rules (accounting and invoicing), worked on event based and rule based revenue recognition, worked on Customer Acceptance process for revenue recognition, worked on integrating the Revenue distributions to an external system for reporting.
- Worked on the Auto Invoice process for importing of invoices from external sources in Oracle AR
- Worked on Standard Costing, Average Costing, FIFO and LIFO Costing.
- Worked on setup of the Cost Structure - defining cost elements, sub elements, activities, basis types, GL Accounts, etc.
- Defined all the cost organizations and shared costs in Oracle Costing
- Defined the material, material overhead, resource, overhead and outside processing costs for Oracle Costing
- Defined cost activities, basis types, resource value, resource units, total value, etc. in Oracle Costing
- Worked on cost transfer and distribution to GL
- Worked on retroactive pricing in oracle Cost Management
- Worked on the implementation of the Auto Lock Box process in AR module for Bank of New York and Royal Bank of Canada
- Worked on the implementation of Credit and Collections module - defining the credit limits, assigning activity codes, defining credit and statement templates, setting up delinquency policies, etc.
- Worked on the setups of the Collection Agents, Dunning Letters, Dunning Letter Templates in Oracle AR module
- Worked on the setups of the Advance Collections module - defined the collectors, work queues, setting up employee and locations, assigning of collectors, define the resource group hierarchy, enable AR Transaction summary tables, setup notes, setup tasks, enabling oracle interaction center, etc.
- Providing training to the Super Users/End Users including documentations.
- Extensively worked on Business Requirements Gathering, Solution design, Business Mapping, configuration, set-ups, Building RICE components & Testing.
- Application enhancement for AR and Channel Revenue Management and functional assistance for any production issues.
- Assist the technical team is understanding the requirements and its related business
- Functional Designing (BR100 & MD050)
- Conduct CRP for end-users
- Conduct UAT and go-live
- Delivery of Functional design documents for custom reports
- Root cause analysis
- Fit-Gap-Analysis and create mapping between as-is-process vs to-be-process for Confidential finance process
Confidential, Detroit, MI
Lead Financials Business Analyst
Responsibilities:
- Analyze the Expandable System & Integration Requirements.
- Identification of GAPs & proposal of Solution.
- Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
- Worked with Joint Application Design (JAD) Sessions, Conference Room Pilots (CRP) and User Acceptance Testing (UAT)
- Carry out Data Mapping.
- Understand Division-specific business processes from the end users and implement the same.
- Responsible for training the end users on the new processes and facilitated on-the-job training.
- Performed Item Mapping from legacy system and vendor catalogs into Oracle - to define new items and categories.
- Worked on the setups and configurations for AP, Cash Management (CM), AR, Advance Collections, e-Business Tax, Sub Ledger Accounting, FA and Cash Management modules.
- Worked on Manual and Automatic Bank Reconciliation in Oracle Cash Management
- Worked on defining Cash Forecasting and Cash Pooling Options in Oracle Cash Management
- Worked on the interface of Cash Management with Accounts Receivables and Accounts Payables
- Worked on the bank statement mapping in Oracle Cash Management
- Worked on the bank statement load process in Oracle Cash Management
- Defined cash forecasting templates in Oracle Cash Management.
- Worked on the Invoice Processing functionality in AR module using the Auto Invoice process. Performed all the setups for Auto Invoice including the setups of Source, Line Ordering rules, Grouping rules and Line Transaction flex field.
- Worked Extensively on RICE components (or CEMLI's) (Reports, Interfaces, Conversions and Extensions in Oracle AR module
- Worked on the Receipt Processing Functionality in AR module using the Auto Lock box functionality.
- Worked on the integration of credit card functionality with Oracle e-Business suite.
- Worked on the Revenue Recognition process in AR Module
- Worked on Cost Management module - defined the cost elements, sub elements, standard cost variance accounts, average cost valuations, etc.
- Worked on Credit and Collections module – defining delinquency polices, defining activity codes and assigning them, setting up statement cycles, setting up credit insurance policies, assigning credit and collection information to customers, etc.
- Worked on the dunning letter templates setups, defined the statement cycles, etc.
- Worked on the Advance Collection module – defined the resources, defined collectors, assigning collectors to work queues, assign roles and resource groups, enabling AR transaction summary tables, call wrap up admin, etc.
- Worked with business users on planning and executing data conversion activities like Item, PO, On-hand, Cost and Categories.
- Designed the Return process, which starts from customer return, rectifying/repair/disposition and then ship the good back to customer.
- Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
- Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing track
- Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents.
- Provide inputs and part of the team for new solution.
- Test various business scenarios in the new system.
- Interact directly with end users, infrastructure teams, and project teams.
- Functional design of the Conversion / Integration programs.
- Progress the track thro CRP1, CRP2, UAT & Go Alive.
- Provide user training & documentation
Environment: Oracle applications R12 (AP, AR, e-Business Tax, Costing, Cash Management (CM), Sub Ledger Accounting, FA and Cash Management), Oracle database 9.x, 10.g, SQL, PL/SQL, TOAD
Confidential, Fresno, CA
Financials Business Analyst
Responsibilities:
- As a Financials Business Analyst implemented the following modules AR, e-Business Tax, Cash Management (CM), Costing, AP, GL, i-Expense and i-Procurement
- Worked on the Functional mapping of data Conversions & Enhancements for AR, Costing, Cash Management (CM), AP, GL, e-Business Tax, i-Expense and i-Procurement modules.
- Preparing BR100, TE40, 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 Cash Management (CM) module – defining the Cash Forecasting parameters, Cash pooling, worked on bank statement interface, define cash forecasting templates
- Worked on Manual and Auto Reconciliation in Oracle Cash Management
- Worked on Cash Positioning in Oracle Cash Management
- Worked on Oracle Cash Management Interface to AR and AP modules.
- Worked on the configuration of the Payment Manager in AP module.
- Worked on the configuration of the Payment Process Profiles in AP Module
- Defined the Supplier Structure for AR/AP Netting process
- Worked on the Refund Functionality in AP module
- Worked on the Rertainage and Recoupment in AP module
- Configured Oracle AR, AP, Costing, e-Business Tax, GL, i-Expense and i-Procurement modules from scratch and simultaneously created BR100 documentation for the setups.
- Setup the Approval Hierarchies in Oracle Purchasing module.
- Worked on Cost Management module – worked on standard costing, average costing, LIFO, FIFO, defined the cost elements, sub elements, defined cost variance accounts, GL valuation accounts for cost, defined elements for Landed Cost Management, etc.
- Involved in troubleshooting issues on Auto Invoice Import Program.
- Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
- Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
- I-Procurement – Worked on the Configuration of i-Procurement module including the setups of the requisition templates, setting up the Item Catalogs and Categories, Account Generator, etc.
- Provided with useful training to the users in GL, AP, OM, INV and PO Modules.
- Created FSG Financial Reports critical to company’s business process.
- Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL
Confidential, Ann Arbor, MI
Oracle Financials Business Analyst
Responsibilities:
- Preparing Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating units.
- Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
- Worked on the Financial modules of AR, AP, GL and FA
- Performed all the setups for AR, AP, GL and FA modules.
- Worked on the Revenue Recognition Process in Oracle AR module.
- Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
- Worked on the entire upgrade strategy to upgrade the application footprint from 11.5.10.2 to Release 12.1.1
- Pricing Business Requirement Study and designed / documented Functional Specification.
- Identification of Gap & put collaborative effort with the Technical team to address the same thro Technical Specification.
- Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
- Conducting Pre Project Review & Post Project Review.
- Providing Post Implementation support
- Worked for the Category & Mapping data migration to meet the go alive deadline.
- Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
- Assisted Business for Business Acceptance Testing and obtain Sign off.
Confidential
Oracle Financials Business Analyst
Responsibilities:
- Participated in Scope analysis for supply chain domain
- Collated the issues in the current version and requirements in the latest version
- Prepared AS IS and TO BE process documents
- Configured additional Setups in the upgrade version
- Developed Test scripts and successfully completed CRP 1 with Localization
- Established Purchase Requisition process and Approval hierarchy to manage non-production (Indirect) Items purchases in the Organization
- Developed solution to manage Stock Items and recurring non-stock purchases using Blanket Purchase Agreement (BPA) and Blanket Releases
- Configured Auto-Sourcing rules, Approved Supplier List (ASL) and BPA to enable Buyers to release purchase orders automatically from Planners Workbench
- Developed solution to manage Inventory using ‘Inspection’ as receipt routing for Items routed through Quality department and established ‘Return to Vendor’ process
- Designed and developed all the setups and configurations for Inventory management.
- Setup all the planning functionality for Inventory
- Performed all Organization setups for Inventory
- Performed all setups for Cycle Counting in Inventory
- Performed all setups for ABC Analysis
- Performed all setups for Items, Categories, Catalogs, etc.