SUMMARY:

• Oracle Functional Analyst with over 8.8 years of total industry experience including experience on core ERP Applications. Experience includes execution of 4 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.

ERP Expertise:

• 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 GL, AR, AP, FA, Projects (Costing, Billing), Service Contracts, Costing, i-Expense, i-Procurement, PO
• Experience with Vertex and Sabrix.
• Experience with the return process in Order Management, Reverse Logistics flow
• Extensive experience with Oracle Financial Statement Generator (FSG) reports
• Extensive experience with the Quote to Cash and Procure to Pay business flows.
• Expertise in design and development of the three layers (Physical/Business Model and
• Formulated solution design and implementation strategy based on client requirements.
• Configured the application based on solution design, performed gap analysis and designed workaround solutions.
• Extensive experience on Revenue Recognition as per US GAAP rules.
• 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 GL, AR, AP, FA, Projects (Costing, Billing), Service Contracts, Costing, i-Expense, i-Procurement, 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, Irvine, CA

Oracle Financials Functional Analyst

Technology: GL, AR, AP, FA, Projects (Costing, Billing), Service Contracts, Costing, i-Expense, i-Procurement, PO

Responsibilities:

• 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 GL, AR, AP, FA, Projects (Costing, Billing), Service Contracts, Costing, i-Expense, i-Procurement, PO modules
• 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 defining the customer acceptance process for Revenue Recognition
• Worked on setting up Daily Revenue rules for Revenue Recognition
• Worked on configuring the deferred COGS, Deferred Revenue process in Revenue Recognition.
• Worked on the setups of e-Business Tax module - including the setups of Tax Rates, Tax Codes, Tax Regimes, Regime to Rate flow - for EMEA and US.
• Worked on the integration of Oracle e-Business Tax with Sabrix module.
• Worked on the Sabrix’ Sales and Use Tax Manager, Purchase Transaction Taxation, Special Complex Taxation, Product Exemptions
• Worked on the Sabrix Workbench - for tax planning, tax modeling and testing.
• Worked on consolidated reporting solution, which was used to generate audit reports, worked on the financial dashboard for the executives to give them a snapshot of the company’s tax obligations
• Worked on the compliance and returns module for the company’s returns process.
• 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 of the Sub Ledger Accounting module - Accounting Method Builder, Line Types, Account Derivation rules, Journal Line Types, Sub Ledger Accounting methods, Application Accounting Definitions, etc.
• As part of the Production Support team - worked on handling the help desk tickets
• Routinely involved with period close and book closure activities.
• Worked on prioritizing the help desk open requests
• Worked on the support of the users for new enhancement requests.
• Supported the users for developing ad hoc reports as part of the reconciliation process
• Supported the interface issues and resolved the errors
• As part of the production support team - worked on resolving workflow issues
• Supported the users for developing of new error reporting alerts (periodic and event)
• Supported the users in resolving performance issues in the system
• Worked on the close process with the users
• Supported the streamlining of closing of the modules in oracle e-business suite
• Resolved issues on a daily basis with interfaces that we coming in from suppliers with ASN Information
• Worked on the support of the Auto Invoice interface that loaded invoices from external sources into oracle
• Supported the Auto Lock box interface with Confidential
• Supported the ACH process in the AP Module
• Supported the AP Payment Manager process
• Supported the Loading of journal into GL from external sources using the GL Interface
• Supported the FSG report development in GL module
• Supported and resolved issues with the Approval process in Purchasing module
• Supported the users in closing the books – helping with reconciliation issues, interface issues, ad hoc reports needed to support reconciliation, etc.
• Supported the users with resolving performance related issues
• Supported the Order to Cash and Procure to Pay processes
• Supported new code introduction into production – by having code review meetings, business impact meetings with the users, etc.

Environment: Oracle applications R12 (Technology: GL, AR, AP, Sabrix, E-Business Tax, FA, Projects (Costing, Billing), Service Contracts, Costing, i-Expense, i-Procurement, PO)

Confidential, Redwood City, CA

Business Functional Analyst

Technology: GL, AR, AP, FA, Projects (Costing, Billing), e-Business Tax, Costing, i-Expense, i-Procurement, PO

Responsibilities:

• Requirement analysis & Solution design for the Financials Modules ( GL, AR, AP, FA, e-Business Tax, i-Expense, i-Procurement, PO )
• 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.
• Developed several FSG using reports using the Row Sets, Content Sets and Column Sets etc.
• Worked on the Oracle E-Business Tax module – defining rates, regimes, rate to regime flows, exemptions, exceptions, VAT Tax, etc.
• Worked on the integration of Oracle e-Business Tax with Sabrix Tax ware.
• Worked on Sabrix Tax Manager, Sabrix Reporting Dashboard, etc.
• Worked on the setups of AR, Fixed Assets, Cash Management, 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.
• Worked on the Sub Ledger Accounting module – defining the line types, events, account derivation rules, accounting method builder, Line Types, Journal Line sources, etc.
• Formulate Test Strategy, Test Scenarios & Test Cases
• Perform Unit Testing & Co-Ordinate User Testing.
• Documented Functional Design, Applications Setups & User Manuals

Confidential

Technology: GL, AR, AP, FA, Projects (Costing, Billing), Service Contracts, Costing, i-Expense, i-Procurement, PO

Business Functional Analyst

Responsibilities:

• Worked with the 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 the Technical team to Solution.
• Collaborated with Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Worked on developing around 70 FSG Reports in GL for the business.
• Worked on the setups of Advance Collections, AP, Fixed Assets, CM, e-Business Tax AR, Revenue, GL modules.
• Worked on Revenue Recognition rules – defining Accounting and Invoicing rules
• Worked on setting up Customer Acceptance process in Revenue Recognition
• Worked on rule based and event based revenue recognition rules
• Worked on configuring deferred revenue deferred COGS process.
• 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, Orrville, OH

Business Functional Analyst

Responsibilities:

• Conducted meetings with Super users/SME’s to gather requirements for Procure to pay and Order to Cash cycles and documented in BR-30.
• Responsible for the complete setup and implementation of AR, AP, GL, Sub Ledger Accounting
• Developed all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Functional Specification MD050, Testing Documents TE030 and TE040, etc.
• Worked on all the setups for the Revenue Recognition, OM, and INV modules.
• Performed all the setups for the Quoting Module in relation to Order Management.
• Worked on the Ledger Setups of GL.
• Responsible for the implementation Finance Banks in Oracle Cash Management
• Performed Purchasing set-ups. Set up the approval hierarchies and workflow in Purchasing.
• Worked in the Bank Reconciliation process in Cash Management module.
• Worked closely with CRM team on spares management and Depot-Repair modules to understand and implemented repair planning and min-max planning.
• Participated in RICE component activities and created functional design documents for conversions and interfaces. (CV040 and MD050).
• Worked closely with Client finance user team and Oracle finance consultant on issues like intercompany invoicing, auto invoicing, tax codes and inventory valuation and resolved them by explaining the standard Oracle functionality.
• Worked closely with on site and off site technical team on Master and Transactional data conversion and validation issues.
• Also, designed functional documents for various Gaps and interfaces such as SFDC forecast interface and PDM to Oracle interface.

Confidential, San Francisco, CA

Business Functional 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 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.

Confidential

Procure to Pay Functional Consultant

Responsibilities:

• Process Architecture & Enhancement around the i-Procurement, i-Supplier, Advance Pricing, Inventory, Purchasing, Accounts Payable, General Ledger modules
• 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 the Loaded data
• Have worked on key tasks such as Sub-Inv Transfer
• Have worked on Writing and Customizing Interfaces. i-Procurement, i-Supplier, Advance Pricing, Inventory, Purchasing, Accounts Payable, General Ledger
• Concurrent Manager Administration, Interface monitoring
• Application Users creation.
• Performance Tuning for Reports & Interface