We provide IT Staff Augmentation Services!

Oracle Techno- Functional Analyst Resume

4.00/5 (Submit Your Rating)

Phoenix, AZ

SUMMARY -

  • Functional Financials Analyst with over 9.5 years of total industry experience including 8 years on core ERP Applications. Experience includes execution of 4 full lifecycle Oracle Applications implementations including teh exposure to e-Business suite Release 12, numerous Application Support projects, RICE implementations, upgrades, with high level of Customer Satisfaction. Over 6 years of extensive experience on Oracle Financials Applications consulting including Quote to Cash and Procure to Pay Executed critical projects as Business Analyst, Functional Consultant on Functional & Techno-Functional roles. Extensive business area experience & have received great commendations at Client site for excellent interpersonal & Client interaction
  • Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities.
  • Experience with Oracle Business Accelerators for e-Business Suite Release 12.
  • Experienced in working with Oracle Applications Release 12
  • Possess strong noledge of Financial modules of Oracle applications, with concentration on AP, Deductions Management, AR, GL, Sub Ledger Accounting, Enterprise Asset Management (eAM), Cash Management and Distribution modules of OM, INV, PO
  • Expertise in Oracle core modules including Order Management, Inventory, Accounts Receivables, Accounts Payables, Service Contracts, Install Base, Purchasing, i-Procurement and General Ledger.
  • Extensive experience on Approval Management Engine (AME)
  • Experience with teh return process in Order Management, Reverse Logistics flow
  • Extensive experience with Oracle Financial Statement Generator (FSG) reports
  • Extensive experience with teh Quote to Cash and Procure to Pay business flows.
  • Formulated solution design and implementation strategy based on client requirements.
  • Configured teh application based on solution design, performed gap analysis and designed workaround solutions.
  • Very good understanding of teh Revenue Recognition Process and US Accounting Standards of US GAAP, Best Estimated Selling Price (BESP) Analysis, Relative Selling Price Allocation, Residual Allocation (SOP 98-9), VSOE Discounts, and VSOE.
  • Extensive experience with writing of BRD and FSD
  • Trained teh clients’ super users on teh application and conducted pilot testing, integrated testing.
  • Design validation & Setups of AR, Deductions Management, Sub Ledger Accounting, AP, GL, FA, OM, INV and PO modules.
  • Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
  • Experience in preparing Requirement Analysis Documentation, Training scripts, Functional Documentation, User Training Documents and Customization Documents.
  • Knowledge of SQL, relational database query tools (e.g. TOAD).

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Oracle Techno- Functional Analyst

Responsibilities -

  • Study AS-IS Business Process (on version 11.5.10.2)
  • Analyze teh Business Enhancement Requirements.
  • Identification of GAPs & proposal of Solution.
  • Impact Analysis of all customizations dat existed on 11i and if they were needed to be moved over to Release 12.
  • Worked on teh Contract Statuses, Contract Approval rules, Contract Auto Renewal rules, etc. in Oracle Service Contracts module.
  • Preparing of all of teh Functional Specification Documents (FSD), Business Requirement Documents (BRD), Canonical Model Definitions, Deriving Use Case scenarios, Flow Diagrams, Data Mapping Documents (DMD) and Functional Testing Documents.
  • Worked on Intercompany Setups in Oracle GL Module.
  • Worked on teh setups of teh Revenue Recognition process - including define teh Revenue Rules, defining Rule Base and Event based Revenue Recognition, defining customer acceptance process - pre and post billing, setting up customer contingencies, setting up daily revenue rules, deferring teh COGS as per deferred Revenue schedule.
  • Worked on Setup of Accounting and invoicing rules for Revenue Recognition.
  • Performed all Configurations and Setups for AR, AP, GL, Advance Pricing, Service Contracts, Install Base PO, OM Modules
  • Worked on teh setups of teh GL Ledgers (Primary and Secondary), defining Ledger Sets, Data Access Sets, Translation, Revaluation, Designing of teh Chart of Accounts, setting up cross validation rules and security rules, etc.
  • Worked on personalization’s of several pages in Oracle Financials.
  • Worked on teh setups and configurations for of teh Sub Ledger Accounting module - Accounting Method Builder, Line Types, Account Derivation rules, Journal Line Types, Sub Ledger Accounting methods, Application Accounting Definitions, etc.
  • Worked on configuration of VAT Tax in Oracle E-Business Tax module.
  • Integrated Oracle AR and AP with Oracle e-Business Tax module for VAT tax for Europe
  • Worked on teh Enterprise Asset Management (eAM) setups.
  • Integrated Oracle AR and AP with Oracle e-Business Tax for Sales and Use Tax for US Taxation
  • Worked on AME setups - defining teh attributes, attribute mapping, setting up approval rules, defining transaction types, conditions, actions and action types, etc.
  • Resolved teh Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
  • Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents.
  • Provide inputs and part of teh team for new solution.
  • Test various business scenarios in teh new system.
  • Interact directly with end users, infrastructure teams, and project teams.
  • Functional design of teh Conversion / Integration programs.
  • Progress teh track thro CRP1, CRP2, UAT & Go Alive.
  • Provide user training & documentation

Environment: Oracle applications R12 (Technology: Advance Collections, Enterprise Asset Management (eAM), Deductions Management, AP, FA, CM, SLA, AME, FSG Reports, e-Business Tax AR, Revenue, GL)

Confidential, San Diego, CA

Oracle Techno- Functional Analyst

Responsibilities -

  • Requirement analysis & Solution design for teh Financials Modules (AR, AP, GL, Enterprise Asset Management (eAM), SLA, Cash Management and Revenue Recognition)
  • Jointly derive teh ‘To-Be’ Process & Aid Code development.
  • Performed all teh steps for AR, AP, GL, Advance Pricing, Service Contracts, Install Base PO, OM modules.
  • Preparing of all of teh Functional Specification Documents (FSD), Business Requirement Documents (BRD), Use Cases, Canonical models, Data Mapping Documents (DMD) and Functional Testing Documents.
  • Developed several FSG using reports using teh Row Sets, Content Sets and Column Sets etc.
  • Worked on teh setups of teh VAT Tax for Europe
  • Worked on teh configuration of Oracle e-Business Tax for VAT Tax
  • Worked on teh configuration of Oracle e-Business Tax for Sales and Use Tax.
  • Worked on teh setups of AR, Enterprise Asset Management (eAM), GL modules
  • Worked on configuring teh GL Module - Defining teh Ledgers, Org Structure, setting up Translation, Revaluation, Consolidation process.
  • Developed teh Revenue Recognition rules as per teh US GAAP standards.
  • Worked on teh Sub Ledger Accounting module - defining teh line types, events, account derivation rules, accounting method builder, Line Types, Journal Line sources, etc.
  • Worked on personalization’s of several pages in Oracle Financials
  • Worked on Oracle AME Configurations – defining custom transaction types, attributes, conditions, actions, action types, rules, etc.
  • Formulate Test Strategy, Test Scenarios & Test Cases
  • Perform Unit Testing & Co-Ordinate User Testing.
  • Documented Functional Design, Applications Setups & User Manuals

Confidential, Los Angeles, California

Business Analyst

Responsibilities -

  • Worked with teh Business team to baseline ‘As Is’ Process and derive ‘To Be’ flow.
  • Pricing Business Requirement Study and designed / documented Functional Specification.
  • Identification of Gap & put collaborative effort with teh Technical team to Solution.
  • Collaborated with Pricing & IT Business to obtain clarity on teh Business Rules and capture teh same.
  • Worked on developing around 70 FSG Reports in GL for teh business.
  • Flow Testing for SCM Modules (AR, AP, OM, Advance Pricing, Service Contracts, Install Base, i-Procurement, INV, PO) to make sure flow is working without any issues
  • Worked on teh setups of Advance Collections, AME, AP, Enterprise Asset Management (eAM), FA, CM, e-Business Tax AR, Revenue, GL modules.
  • Worked for teh Category & Mapping data migration to meet teh go alive deadline.
  • Assisted Business for Business Acceptance Testing and obtain Sign off.
  • Worked with teh Business team to baseline NPI ‘As Is’ Process and derive ‘To Be’ flow.
  • Pricing Business Requirement Study and designed / documented Functional Specification.
  • Identification of Gap & put collaborative effort with teh Technical team to address teh same thro Technical Specification.
  • Facilitated Pricing & IT Business to obtain clarity on teh Business Rules and capture teh same.
  • Conducting Pre Project Review & Post Project Review.
  • Providing Post Implementation support
  • Worked for teh Category & Mapping data migration to meet teh go alive deadline.
  • Jointly worked with teh QA team in formulating teh Test Cases & Test Scenarios.
  • Assisted Business for Business Acceptance Testing and obtain Sign off.

Confidential

Business Analyst

Responsibilities:

  • Defined teh Auto Invoice process in AR
  • Worked on setting up teh Revenue Recognition process in AR
  • Defined teh Auto Lock Box process in AR module
  • Defined teh transaction types and system option in AR module
  • Defined teh Auto Accounting rules in AR module
  • Worked on teh collection process in AR Module
  • Setup Modifiers and Qualifiers in QP.
  • Setup teh pricing attributes in QP
  • Setup teh Dynamic formulas for pricing in QP.
  • Setup teh Attribute mapping in QP
  • Setup teh QP profile options.
  • Key setups like Flex fields, Organization, Inventory Parameters, UOM, Sub inventory, stock locator, Item Attribute control, Item Template and Transaction Type
  • Established a Item Category and Item Cataloging for their products.
  • Defined a ABC Analysis and Cycle Count
  • Established Customer Item and Customer Item Cross Reference
  • Established a process for smooth month end closing procedure in Inventory

Confidential

Business Analyst

Responsibilities

  • Provided analysis, design, installation, setup and rollout of Oracle 11i INV, AR, Quoting, AP, Advance Pricing, PO, OM modules
  • Setups included Multi Language, Multi Reporting Currency, Multi Organization
  • Worked extensively on TCA architecture and was involved in migration of customers from various legacy systems into Oracle TCA architecture.
  • Coordinated teh phase of teh project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules
  • Developed Functional specifications for interfaces and data conversion programs for applications
  • Addressed operational problems, concerns, and questions posed by users
  • Interacting with upper management to identify teh business process and needs and with end users to identify their requirements
  • Provided GAP Analysis expertise in INV, AR, Quoting, AP, Advance Pricing, PO, OM modules.
  • Involved in Inventory org setups.
  • 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 OM to AR and ensuring no records are stuck in teh interface.
  • Resolving issues related to flex fields and sys admin setups.
  • Design and development of custom reports and FSG reports.
  • Process Architecture & Enhancement.
  • Designed Approach Document for Data Migration from Legacy to 11i
  • Customer Interaction and Issue Tracking
  • Have Migrated Customer/Items/Item Relationship/Cross Reference
  • Have Done Unit Testing/User Acceptance Testing/System/Integration testing for teh Loaded data
  • Have worked on key tasks such as Sub-Inv Transfer
  • Have worked on Writing and Customizing Interfaces.
  • Complete Process flow noledge on INV, PO, and WIP.
  • Concurrent Manager Administration, Interface monitoring
  • Application Users creation.
  • Performance Tuning for Reports & Interface

We'd love your feedback!