SUMMARY

• 10 years of experience in ERP (Oracle Financials) as an Oracle Functional Analyst consultant and core team member.
• Experience with Global Roll Outs of Oracle e - Business suite.
• 3 Full Life Cycle implementations in Release 12.
• Strong Experience in Financial Accounting and Reporting with good leadership and interpersonal skills.
• Extensive experience with Trading Community Architecture (TCA) and Customer Data Hub (CDH)
• Extensive experience with Order Management, Inventory Management, Purchasing, General Ledger, Accounts Payable, Cash Management, Accounts Receivables, Fixed Assets, Project Costing, Project Billing, Project Management, Sub Ledger Accounting, Payment Manager
• Extensive experience with “Order to Cash” business processes.
• Extensive experience with documenting the “AS-IS” process and designing the “TO-BE” process.
• Involved in implementation and support projects in Oracle Financials.
• Good experience in Oracle Financial Modules including Procure to Pay and Order to Cash modules.
• Good experience working with Business owners and users; Preparing specification documentation; Gathering business requirement; Designing process workflow; Identifying and resolving Gaps; Documenting functional and reviewing technical specs; Providing functional inputs for specifications, Good understanding of business process, Good experience in tracking and resolving application bugs via the oracle TAR process using Oracle Meta link.
• Experience with Testing methodologies like Mercury Quality Center, Win Runner and Load Runner
• Good written and oral communication skills.

TECHNICAL SKILLS

Functional: Business Requirements Analysis, Gap Analysis, Process mapping and Oracle Applications functional setup

ERP: Oracle Financials (12.0.5, 10.7 and 11i)

Modules: Primary Order Management, Inventory Management, Purchasing, General Ledger, Accounts Payable, Cash Management, Accounts Receivables, Fixed Assets, Project Costing, Project Billing, Project Management, Sub Ledger Accounting, Payment Manager

Methodology: AIM (Applications Implementation Methodology)

Business Intelligence: Working noledge of Oracle Discoverer

Language: Reasonable understanding of SQL

Oracle and Other Tools: Data loader, ADI, Web ADI and MS-Office tools including Visio / MS Projects

PROFESSIONAL EXPERIENCE

Confidential, St Peters, MO

Financials Functional Lead

Responsibilities:

• As a Functional Analyst Supported the financial modules: Order Management, Inventory Management, Purchasing, General Ledger, Accounts Payable, Cash Management, Accounts Receivables, Fixed Assets, Project Costing, Project Billing, Project Management, Sub Ledger Accounting, Payment Manager Release 12.1.3
• Worked on the Functional Specifications for Conversions & Enhancements for Order Management, Inventory Management, Purchasing, General Ledger, Accounts Payable, Cash Management, Accounts Receivables, Fixed Assets, Project Costing, Project Billing, Project Management, Sub Ledger Accounting, Payment Manager module
• Worked on the Chart of Accounts (COA) design in Oracle GL
• Worked on the definition of the Primary and Secondary Ledgers in Oracle GL module
• Worked on Cross Validation Rules and Security Rules in Oracle GL
• Worked on Translation and Revaluation in Oracle GL Module
• Worked on setting up of Revenue Recognition process in AR Module
• Defined the Accounting and Invoicing rules to be used in Revenue Recognition process in AR.
• Configure the OM Module - working on Transaction Types, Processing Constraints, Defaulting Rules, etc i-Expense Worked on Oracle Credit Management configurations and setups - Defining customer data by running the DQM Match rule, DQM Staging, defining credit analysts, setting up credit management system options, customer credit classification, DSO Days, hierarchical relationships, credit management profiles, credit usage rules, assigning credit info to profile classes, etc.
• Preparing BR100, MD050, TE40, TE50, 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 Oracle e-Business Tax Setups
• Worked on Sub Ledger Accounting Setups.
• Configured AR, AP, Credit Management, Project Costing, Project Billing, Grants Accounting, Advance Collections, TCA, FA and GL modules from scratch and simultaneously created BR100 documentation for the setups.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Provided with useful training to the users in Order Management, Inventory Management, Purchasing, General Ledger, Accounts Payable, Cash Management, Accounts Receivables, Fixed Assets, Project Costing, Project Billing, Project Management, Sub Ledger Accounting, Payment Manager
• Created FSG Financial Reports critical to company’s business process.

Confidential, Irvine, CA

Financials Functional Analyst

Responsibilities:

• Analyzed business requirements & performed Gap Analysis to map user requirements to oracle apps functionality & performed prototyping of “To Be” business process flows
• Worked on all of the setup of Order Management, Inventory Management, Purchasing, General Ledger, Accounts Payable, Cash Management, Accounts Receivables, Fixed Assets, Project Costing, Project Billing, Project Management, Sub Ledger Accounting, Payment Manager module.
• Worked on the setups of the Advance Collections module - defining the correspondence templates, strategy elements, scoring elements, collectors work queue nodes, dunning plans, strategy segments, work items, custom workflow for approvals using AME, collection strategy, scoring components and weightage, etc.
• Worked on the setups of Credit Management module - Defining the checklist, automation rules, AME Rules, scoring model, assigning credit usage rules, credit management application workflow, assigning credit info to profiles, etc.
• Worked on the setups of the TCA - setting up the de-duplication rules in CDH, configuring Customer profile classes, credit profiles, Setting up Parties, Accounts, Sites, Site Uses, Contacts and Contact Points, etc.
• I-Expense - Setup i-Expense for Connected and Disconnected expense reporting including setting of several expense reporting templates, setting up the Credit Card interface, implementing P-Card functionality in i-Expense, setting up of Per Diem and Mileage, Setting up i-Expense to support Multi Currency, setting up Audit Automation, Setting up of Expense Report Summary client extension, etc.
• Created a base template to gather country specific localization requirements. Managed team in India to implement the P2P Business flows including GL, FA, I-Procurement, PO, AP, I-expense, EB-Tax modules, Cash Management and Bank Integration.
• Prepared SM010, BR100, MD050, TE40, TE050 and conducted CRP execution, User training and UAT successfully.
• Configurations and setups for Ledger, Legal Entity, Operating Unit and Locations for new countries. Worked on setting up the new tax rates including VAT and withholding taxes as localization requirements, I-expense templates (parking, per diem, corporate cell phone and mileage rates), Approval Hierarchies in Purchasing Module, and Fixed Asset Books and Categories
• E-Business Tax - Worked on the oracle e-Business Tax setups like setting up the rates, regimes, tax codes, rate to regime flows, setting up e-business tax for sales and use tax as well as VAT Tax.
• E-Business Tax - Worked on the integration of Vertex Q Series with Oracle e-Business Tax
• E-Business Tax - Defined tax rules for exemptions and exceptions in Oracle e-Business Tax module
• Worked on the AMEX credit card integration with Oracle i-Expense module
• I procurement/Purchasing: Setup the approval hierarchy, approval groups and approver assignment and designed workflow customization. Prepared the custom PO Print Program - MD050 and worked on custom PO Detail Report.
• Involved in the Item Master Setups in Inventory module including setting up of Item templates, defining Item attributes, enabling the items in various orgs and adding items to the Catalog in I-procurement.
• Worked on Romania bank integration - ability to make payment from OFA to Deutsche Bank (DBI) Online system. Conducted meetings with AP and Treasury to decide the payment methods and further, prepared MD050 and payment generation files for Domestic and International Wire payment methods. Also completed Mexico bank integration with HSBC for ACH and WIRE payment methods.
• Conducted Regression testing and OATS testing
• Prepared the CRP plan, conducted kick off meetings, created testing trackers and metadata for reference.
• Post-production live support.
• Executed production cut-over simulation task on a 24x7 calendar
• Provided user support in the live phase

Confidential, Foster City, CA

Oracle Apps Functional Consultant

Responsibilities:

• Requirements gathering from end users, Requirement analysis.
• Preparing the AS Process, TO Be Process, Use Case Diagrams, Process flow diagrams, Swim Lane diagrams, process breakdowns, etc.
• Worked on the entire Financials business process.
• Performed all of the setups required for Order Management, Inventory Management, Purchasing, General Ledger, Accounts Payable, Cash Management, Accounts Receivables, Fixed Assets, Project Costing, Project Billing, Project Management, Sub Ledger Accounting, Payment Manager modules
• Worked on the configuration of the GL Chart of Accounts, Calendar, Ledger, Ledger Sets, Data Access Sets, Cross Validation rules, security rules, etc.
• Developed several enhancements to the Business Processes on the Procure to Pay side. e-Business Tax - Worked on the configurations of Oracle e-Business Tax modules, setting up rates, regimes, rate to regime flow, tax codes, tax rates, tax exemptions, exceptions, tax rules, etc.
• I procurement: Define system profile options. Extract catalog and item data. Setup of Sourcing Rules and Sourcing rules assignment using Blanket Purchase Orders.
• I-Expense - Setup i-Expense for Connected and Disconnected expense reporting including setting of several expense reporting templates, setting up the Credit Card interface, implementing P-Card functionality in i-Expense, setting up of Per Diem and Mileage, setting up i-Expense to support Multi Currency, setting up Audit Automation, Setting up of Expense Report Summary client extension, etc.
• Worked on Confidential Card integration with Oracle i-Expense.
• Coordinated all rounds of CRP and SIT testing with the business users.
• Supervised and halped business users in UAT (User Acceptance Test) testing.
• Support Production issues on a day to day basis including month end closure p1 issues
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Categories, Document Sequence Assignment, Profile Options.
• Preparing the BR030, BR100, To-Be Document.
• Prepared MD050 functional design document.
• Prepared the test script documents TE040, TE050 & TE130 for SIT & UAT testing.
• Prepared i-procurement training manual for the Ship users and the Casino Managers.
• Performed Framework Personalization setups.

Confidential, San Jose, CA

Financials Functional Analyst

Responsibilities:

• Worked on the entire Procure to Pay business process.
• Worked on the AS Is Process, TO Be Process, Swim Lane diagrams, Use Cases, Process Flows, etc.
• Performed all of the setups for e-Business Tax, Project Costing, Project Billing, Grants Accounting, i-Procurement, Procurement Contracts, PO, AP and GL
• Developed several enhancements to the Business Processes on the Procure to Pay side.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Hungary.
• Implemented the Oracle e-Business Tax module - defining the rates, regimes, rate to regime flows, tax codes, etc.
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• Support Production issues on a day to day basis including month end closure p1 issues
• Implementation and support of Cash Management and Account Payable Module
• Functional Support for SOX and PWC Audit
• Integration and Implementation of Foreign exposure through Fire Apps external software with Oracle GL
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, e-Business Tax, Project Costing, Project Billing, Grants Accounting, CM, and AR) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Setup and Support of Markview170 System

Confidential, Minneapolis, MN

Oracle Apps Functional consultant

Responsibilities:

• Created functional specification documents for customized interfaces, reports and extensions.
• Performed GAP analysis for Payables module.
• Created test scripts for testing of standard application functions and customizations.
• Created functional design and test scripts for EDI inbound and outbound processes.
• Coordinated all rounds of CRP and SIT testing with the business users.
• Executed and tested Payables closing process and fixed issues.
• Supervised and halped business users in UAT (User Acceptance Test) process for reports, interfaces and extensions.
• Worked on configuration and set-ups.
• Worked on business requirement gathering and created design documents.
• Created functional specification documents for customized interfaces and reports.
• Worked on configuration purchasing for all CRP and SIT instances.

Environment: Oracle Applications Implementation 11.5.10.2/R12, AP, OM, INV

Confidential, San Jose, CA

Oracle Apps Functional resource

Responsibilities:

• Requirements gathering from end users, Requirement analysis
• Mapping the functionality in Oracle product and performing Gap analysis
• Configuring the product in the system
• Key user training and user manual preparations
• Preparation of test methodology, test guidelines
• Preparations of System test plans and integration test plans
• Preparing BRD document, BR100, CV040
• Preparing Functional Specification document for Extension, Customization & Reports
• Assisting Conversion team with data analysis and data preparation
• Post Production support Oracle Modules Used: AR, AP, e-Business Tax, i-Procurement, Advance Pricing, INV and PO

Environment: Oracle Applications - 11.5.9

Confidential, Cleveland OH

Oracle Apps Functional

Responsibilities:

• Defined Accounting Flex field Structure, Security Rules, Assigned Security Rules Setup, Define Cross-Validation Rules.
• Defined Period Types, Accounting Calendar, Currencies, Conversion Rate Types, Enter Daily Rates, Set of Books.
• Performed all the setups for PO, e-Business Tax, AP, CM, Project Accounting (Costing, Billing), FA, INV, i-Procurement, i-Expense
• Defined Journal Sources, Journal Categories, ShorTEMPthand Aliases
• Implemented Oracle Cash Management for Bank reconciliation.
• Performed Bank Reconciliation.
• Trained users on Cash Management and General ledger.
• Fully participated in Conference Room Pilot (CRP) and authored user’s manuals.
• Writing and executing detail manual test scripts in Mercury Test Director.
• Developed input test data and expected results for test plans.
• Researched testing errors for resolution and documented all defects in detail with attachments, before passing on to the senior business analysts for further review.
• Interacted with the end users to get necessary feedbacks.

Environment: Oracle Applications - 11.5.10

Confidential

Oracle Apps Consultant

Responsibilities:

• Defined Accounting Flex field Structure, Security Rules, Assigned Security Rules Setup, Define Cross-Validation Rules.
• Defined Period Types, Accounting Calendar, Currencies, Conversion Rate Types, Enter Daily Rates, Set of Books.
• Defined Journal Sources, Journal Categories, ShorTEMPthand Aliases
• Implemented Oracle Cash Management for Bank reconciliation.
• Performed Bank Reconciliation.
• Trained users on Cash Management and General ledger.
• Fully participated in Conference Room Pilot (CRP) and authored user’s manuals.
• Writing and executing detail manual test scripts in Mercury Test Director.
• Developed input test data and expected results for test plans.
• Researched testing errors for resolution and documented all defects in detail with attachments, before passing on to the senior business analysts for further review.
• Interacted with the end users to get necessary feedbacks.

Environment: Oracle Applications - 11.5.10