SUMMARY:

• Functional Financials Analyst wif over 7 years of total industry experience including experience on core ERP Applications
• Experience includes execution of 3 full lifecycle Oracle Applications implementations including teh exposure to e - Business Suite Release 12, numerous Application Support projects,
• RICE implementations, upgrades, wif 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 & has 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 wif Oracle Business Accelerators for e-Business Suite Release 12.
• Experienced in working wif Oracle Applications Release 12
• Possess strong knowledge of Financial modules of Oracle applications, wif concentration on AP, AR, GL, CM and Distribution modules of OM, INV, PO
• Experience wif teh return process in Order Management, Reverse Logistics flow
• Extensive experience wif 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.
• Experience wif Oracle Fusion Financials - Revenue Management Cloud, Fusion Expenses and Fusion Advance Collections.
• 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 wif writing of BRD and FSD
• Trained teh clients’ super users on teh 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, scripts, Functional Documentation, User Documents and Customization Documents.
• Knowledge of SQL, relational database query tools (e.g. TOAD).

TECHNICAL SKILLS:

Applications & Modules: Oracle Versions 11.5.10.2, R12.0.3, R12.0.5, R12.0.6, R12.1.1, R12.1.3, R12.2, Fusion R9

Tools: GL, AGIS, PO, AP, AR, CE, FA, SLA, E-BTax, me-Exp, Sys Admin, P2P, O2C, R2R Cycles

Data: Loader, Toad, Bugzilla, Web ADI, OBIEE, Hyperion & Discoverer, Smart View, Hyperion

Microsoft Office: Access, Excel, Outlook, PowerPoint, Visio, Word, Projects

Languages: SQL, PL/SQL, RDBMS, HTML, XML, AUTO CAD, STAT12

Operating systems: Microsoft Windows, MS DOS, Sun Solaris, Linux/Unix, IBM

PROFESSIONAL EXPERIENCE:

Confidential, Dunwoody, GA

Oracle Financials Functional

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 that existed on 11i and if they were needed to be moved over to Release 12.
• 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 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.
• 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 teh setups and configurations for OM, Advance Collections, Quoting, Advance Pricing, AR, and Revenue, GL modules.
• 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 wif 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 & documentation

Confidential, Sunnyvale, CA

Oracle Financials Functional

Responsibilities:

• Provided support to Business Users for all teh financial production related issues on a daily basis by responding to critical issues and requests.
• Updated Ledger setups, Ledger Sets, Request Sets per business requirement and updated teh functional documents.
• Worked on teh setups of GL, AP, AR, SLA, E-Business Tax, me-Expense modules.
• Worked on setups of for teh Auto Lock Box process for Bank of America and Wells Fargo bank
• Worked on teh Credit Card integration wif Oracle e-Business suite using teh Verisign Credit Card Gateway.
• Worked on teh Collection process in AR Module
• Worked on teh Auto Invoice process for Invoicing in teh AR Module.
• Worked on setting up teh Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up teh Line and Header transaction flex field in AR for Auto Invoice to work.
• Implementation of Revenue Recognition process in Oracle AR module
• Worked on teh Configuration on teh Primary Ledger and Secondary Ledgers in GL
• Worked on teh setups of teh Ledger Sets and Data Access sets in Oracle GL
• Worked on Revaluation and Translation process in Oracle GL
• Worked on teh Consolidation process in Oracle GL module
• Worked on teh ACH Process in AP module
• Worked on teh configuration on teh Payment manager in AP
• Worked on teh AR/AP netting process in AP
• Worked on teh bank setups in Oracle Cash management for AP
• Tax configuration included complete set of tax rule as part of tax Regime etc.
• Prepared and did extensive testing of TE 040 test scripts.
• Support business users during Month End Close (MEC).
• Prepared Application configuration setup BR.100 and MD.50 Application Extensions Functional Design documents according to AIM.
• Tax configuration setup using teh Regime to Rate flow and setup teh tax rules
• Actively involved in teh functional configuration of setups and implementation of financial modules throughout various phases since inception till go-live.
• Involved in troubleshooting and issue resolution wif Oracle Applications financial modules.
• Conducted UAT and resolved all teh issues in time before Go-Live.
• Track all issues and prioritize to follow-up wif Oracle Technical Support and conduct OWC sessions for speedy resolution of issues.
• Document all proposed changes along wif Functional Impact Analysis as part of teh Change Management Process.
• Provided support to project manager in creating new Production Support responsibilities, daily & weekly reporting, and PCM.
• Created new Categories & added major & minor in FA.
• Tested assets by using mass addition template & running depreciations and assets retirement.

Confidential, Atlanta, GA

Oracle Financials Business Analyst

Responsibilities:

• Worked wif 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 wif teh Technical team to Solution.
• Collaborated wif Pricing & IT Business to obtain clarity on teh Business Rules and capture teh same.
• Worked on teh setups of OM, Quoting, Advance Pricing, 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 wif 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 wif 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 wif teh QA team in formulating teh Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Confidential, Minneapolis, MN

Oracle Financials Business Analyst

Responsibilities:

• As a Functional Consultant implemented teh Financial Functional Modules including teh Record to Report Track - Oracle Accounts Payables, Payments, General Ledger, Accounts Receivables, Fixed Assets
• Worked on teh setups of Payments module defining teh Payment Process Profiles, Payment Formats, integrating Oracle Payments wif Verisign Payment gateway, etc.
• Performed Requirement and Gap analysis.
• Implemented E-Business Sales Tax forUS - Regime to Rate flow wif Rules and Exceptions and Self assessment Tax
• Worked on a GAP Analysis between Vertex and e-Business Tax to convert from teh existing Vertex implementation to e-Business Tax
• Worked on teh setups of Vertex module - defining teh rates, regimes, rate to regime flows, tax rules, exceptions, exemptions, etc.
• Configurations and Setups for Oracle Accounts Payables, Payments, General Ledger, Accounts Receivables, Advance Collections, Credit Management
• Worked on teh configurations of teh Fixed Assets module - defining teh Tax Books, Asset Books, Depreciation rules, depreciation methods, etc.
• Worked on teh Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Worked on teh setup of teh Collection Scoring Engine, Operational Data Level of Customer and Account, collector work queues, multi level strategies for different Operating Units, Strategy work node, broken promise node, delinquent node in teh Advance Collection module.
• Worked on teh setups of teh Credit Management defining teh credit usage rule sets, credit hierarchies, scoring models, assigning automation rules, credit recommendations and approval policies.
• Worked on teh Revenue Recognition process in oracle AR module - deferred Revenue, contingency billing and customer acceptance process.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating wif technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on setting up teh Approval Hierarchies in Purchasing Module.
• Worked on setting up teh Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up teh Line and Header transaction flex field in AR for Auto Invoice to work.
• Worked on teh Auto Lock Box process in AR.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues
• Implementation and support of Accounts Receivables and Account Payable Module
• Provide support/enhancements for teh existing Oracle and Discoverer Reports (across AP, FA, 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
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per teh SOD Document in System Administration.

Environment: Oracle E-Business Suite 12.1.3, AR, AP, GL, e-Business Tax, Payments, Advance Collections, Credit Management, Sub Ledger Accounting, CM, OM, INV, PO, Service Contracts, Install Base

Confidential, San Francisco, CA

IT 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,, 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 wif upper management to identify teh business process and needs and wif 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 wif 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.