SUMMARY

• Functional Financials Functional Analyst with over 7.5 years of total industry experience including experience on core ERP Applications Experience includes execution of 6 full lifecycle Oracle Applications implementations including the 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 skills.
• 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 knowledge of Financial modules of Oracle applications, with concentration on AP, AR, GL, CM and Distribution modules of OM, INV, PO
• Experience with the return process in Order Management, Reverse Logistics flow
• Extensive experience with the Quote to Cash and Procure to Pay business flows.
• Formulated solution design and implementation strategy based on client requirements.
• Configured the application based on solution design, performed gap analysis and designed workaround solutions.
• Experience with Oracle Fusion Financials - Revenue Management Cloud, Fusion Expenses and Fusion Advance Collections.
• Very good understanding of the 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 the clients’ super users on the application and conducted pilot testing, integrated testing.
• Design validation & Setups of AR, 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, Santa Clarita, CA

Oracle Financials Lead

Responsibilities:

• Study AS-IS Business Process (on version 11.5.10.2)
• Analyze the Business Enhancement Requirements.
• Identification of GAPs & proposal of Solution.
• Impact Analysis of all customizations that existed on 11i and if they were needed to be moved over to Release 12.
• Preparing of all of the 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 the setups of the Revenue Recognition process - including define the 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 the COGS as per deferred Revenue schedule.
• Worked on Setup of Accounting and invoicing rules for Revenue Recognition.
• Worked on the setups of the GL Ledgers (Primary and Secondary), defining Ledger Sets, Data Access Sets, Translation, Revaluation, Designing of the Chart of Accounts, setting up cross validation rules and security rules, etc.
• Worked on the setups and configurations for OM, Advance Collections, Quoting, Advance Pricing, AR, and Revenue, GL modules.
• Resolved the 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 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

Confidential, Seattle, WA

Financials Functional Analyst

Responsibilities:

• Requirement analysis & Solution design for the Consignment Inventory.
• Jointly derive the ‘To-Be’ Process & Aid Code development.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Use Cases, Canonical models, Data Mapping Documents (DMD) and Functional Testing Documents.
• Worked on the setups of OM, Quoting, Advance Pricing, AR, Revenue, GL modules
• Worked on configuring the GL Module - Defining the Ledgers, Org Structure, setting up Translation, Revaluation, Consolidation process.
• Developed the Revenue Recognition rules as per the US GAAP standards.
• Formulate Test Strategy, Test Scenarios & Test Cases
• Perform Unit Testing & Co-Ordinate User Testing.
• Documented Functional Design, Applications Setups & User Manuals

Confidential, Houston, TX

Financials Functional Analyst

Responsibilities:

• Worked with the 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 the Technical team to Solution.
• Collaborated with Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Worked on the setups of AP, AR, Revenue, GL modules.
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Assisted Business for Business Acceptance Testing and obtain Sign off.
• Worked with the 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 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 Business Systems Analyst

Responsibilities:

• Defining Flex field, Profile options, System parameters, Document Sequences
• Worked on both CTO and ATO Models.
• Set up Transaction Types, Applying & Releasing Holds, Credit Checking
• Advanced Pricing, Price List, Pricing Agreements, and Pricing Attributes
• Defining Modifiers, Qualifiers, GSA Price List, Pricing Formula
• Defining Standard, Internal, RMA and Drop shipment Orders
• Define Pick Release, Pick Release rules, Shipping Parameters
• ATO & PTO Models, ATP Checking, Availability & Reservation
• Established a process for smooth month end closing procedure in Inventory
• Defined the Auto Invoice process in AR
• Worked on setting up the Revenue Recognition process in AR
• Defined the Auto Lock Box process in AR module
• Defined the transaction types and system option in AR module
• Defined the Auto Accounting rules in AR module
• Worked on the collection process in AR Module

Confidential

Oracle Applications Functional

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 the phase of the 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 the 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 the interface.
• Resolving issues related to flex fields and sys admin setups.
• Design and development of custom reports and FSG reports.