Oracle Financial Business Analyst Resume
Dallas, TX
SUMMARY:
- Nine years of Industry experience with extensive exposure to domains in ERP Oracle E - Business Suite Financial modules, Information Technology (IT), Finance (FIN).
- Experience in different types of projects like Implementation, Upgrade, Development, Testing and support
- Four Full Lifecycle Implementations including functional set-ups, business process analysis, gap analysis and creating functional specifications
- Full life cycle implementation experience: requirements gathering and analysis, solution design, module configurations, testing, conversions, and production support
- Ability to Manage or Lead a project team
- Good knowledge of Procure to Pay, Order to Cash, Record to Report and INV to assets cycles
TECHNICAL COMPETENCIES:
Oracle E-Business Suite: General Ledger, Fixed Assets, Accounts Payables, Cash Management, Account Receivable, Purchasing, Order management, Inventory, Cost management, System Admin, EBTax, Sub-ledger Accounting, Form Personalization, WebAdi, AGIS, FSG etc.
Oracle Projects: Project Foundation, Project costing, Project Billing, Project Management, Project Resource Management.
Oracle Fusion: General Ledger, Account Payables
Database Tools & Utilities: Data Loader, TOAD, Web ADI, SQL Developer
EXPERIENCE:
Confidential, Dallas, TX
Oracle Financial Business Analyst
Responsibilities:
- Providing immediate solution for all Q2C, R2R and P2P cycle defects
- Closely working with developers and Users for customizations (RICEWF items) and new/enhancement requests.
- Writing new process and design documents based on the requirements.
- Supporting Account Receivables, Payables, Fixed assets, General Ledger, Order Management, Inventory, Purchasing, Cost management and Asset Tracking, Oracle Install Base modules.
- Implementing all oracle financial major features SLA, FGS, AGIS, IReceivable, Lockbox etc. based on the requirements
- Supporting COGS and Revenue recognition issues.
- Closely working with offshore team developers for all kind of issues, Developments and all other requests.
- Writing functional design, Test scripts, and Requirement gathering documents.
- Fit/Gap analysis on new requirements
- Performing CRP sessions
- Supporting UAT, SIT, Pre and post production support.
- Heavily involved in Tax regime to rate flow (EBTax)
- Designing new RICEWF components
- Provide user training for new processes/features and designs.
- Month, Quarter and Year end support
Confidential, Chicago, IL
Oracle Financial Lead
Responsibilities:
- Lead Onshore and off shore team
- Closely working with super user for new/enhance requirements for new RICEWF items.
- Support Fixed asset conversion and AGIS setups
- Defining new FSG reports based on the complicated requirements and supporting all ongoing issues.
- Provide immediate solution for all I2R, R2R and Q2C cycle defects
- Heavily involved in Tax regime to rate flow
- Designing new RICEWF components
- Users training on new process and design
- Supporting all Payable invoice, Payments, Tax related issues.
- Helping my team on new features implementation like Lockbox, Auto reconciliation and SLA
- Writing new/change design documents and present to the business on customizations
- Supporting India localization.
- Month, Quarter and Year end support
Confidential, Atlanta, GA
Oracle Fixed Assets Lead
Responsibilities:
- Lead FA Team of 12 resources
- Gathered Requirement analysis for all financials modules in view of established processes under global design
- Performed FIT/GAP Analysis and CRP Sessions with client
- Write and Execute Test Scripts.
- Documenting various workarounds that can be used.
- Supported UAT and Pre-Post production support.
- Designed various interfaces, Reports and Extensions with other external applications like Buy to Pay (SSS).
- Provided solutions on the complex integration between Oracle Financials and various other external applications
- Understanding specific local requirements for RICEWF and wrote many Functional design documents.
- Assist the countries in preparation of data conversion
- End user training on AP, GL and FA modules
- Mock close support and Month end reconciliation of sub-ledger modules
- Reconciliation between Oracle financials and External systems
- Resolved issues on FA and GL interfaces
- Trained Super Users on GL, FA Modules
Confidential, San Jose, CA
Oracle Financial Lead
Responsibilities:
- Gathered Requirement analysis for all financials modules in view of established processes under global design
- Performed FIT/GAP Analysis and CRP Sessions with client
- Write and Execute Test Scripts.
- Documenting various workarounds that can be used.
- Supported UAT and Pre-Post production support.
- Designed various interfaces, Reports and Extensions with other external applications like Concur, Aperture, and Bloomberg etc.
- Defined many FSG reports based on the requirements and provided immediate solution on all ongoing issues.
- Provided solutions on the complex integration between Oracle Financials and various other external applications
- Understanding specific local requirements for RICEWF and wrote many Functional design documents.
- Assist the countries in preparation of data conversion for AP, GL and FA modules
- Actively involved in the implementation and support of the GL, AP, FA, SLA, AGIS, FSG and Cash Management modules for many countries.
- End user training on AP, GL and FA modules
- Mock close support and Month end reconciliation of sub-ledger modules
- Reconciliation between Oracle financials and External systems
- Resolved issues on FA and GL interfaces
- Trained Super Users on GL, AP, AR, FA Modules
- Lead all my GL team More than 8 people
- Inspired each and every team member to perform and produce their best
- Offered solutions to the top management regarding project-related queries.
Confidential, Houston, TX
Project Manager
Responsibilities:
- Managed a team of 13 Business analyst and consultants.
- Provided solution and design for Oracle and third party Financial Management System (FMS) with responsibility for integration and reconciliation.
- Created various documents on setups, standard operating manuals and training Materials for Oracle GL, AP and PO modules
- Conversion and reconciliation of assets.
- Heavily involved in pre and post production support on all financial modules GL, AP, CE, FA and PO.
Confidential, Tampa, FL
Fixed asset Analyst
Responsibilities:
- Initially started the project with requirement gathering for Oracle Fixed asset module in view of established processes under global design
- Performed FIT/GAP Analysis and CRP Sessions with client
- Wrote and Executed Test Scripts.
- Documented various workarounds that can be used.
- Worked on Account Standardization.
- Prepared functional design documents (MD050) on customization and reviewed with the client for approval.
- Supported UAT and Pre-Post production support.
- Implemented FA for LATAM countries and Supported data conversion
- Closely worked with the Super user on customization and training.
- Production support including the ad-hoc reporting requirements and reconciliation of sub-ledgers to general ledgers using SQL.
- Month and quarter end support
Confidential, San Francisco, CA
Oracle Business Analyst
Responsibilities:
- Post-Support Release 12.1.1 rollout implementation
- Established proper hierarchy of the business units for financial reporting
- Defined security rules and responsibilities to ensure SOX compliance
- Defined FSG Reports to consolidate the financial statements of 25 different companies
- Defined and Setup of GIS system and the required responsibilities for proper access of the same
- Defined the GCS for consolidation of 9 different Set of Books.
- Defined the recurring journal allocation formulas for allocation of various expenses across various business units
- Setup fixed assets module with 91 asset books for 9 countries to meet the local statutory reporting of the countries, Local tax requirements, US GAAP requirements and US tax requirements
- Reconciled with GL after data conversion
- Modified Fixed Assets workflow to ensure proper accounting required for reporting