We provide IT Staff Augmentation Services!

Oracle Financials It Analyst Resume

Sfo, CA

SUMMARY

  • Over 10+ years of experience in Finance and Banking domain which includes experience in Oracle Financials and CRM
  • 9 years of in - depth experience as a Oracle Financials Functional Analyst wif specialization in Oracle Financials Modules of OM, AR, AP, GL, FA, Cash Management, Sub Ledger Accounting, E-Business Tax.
  • Industry experience revolves around Oracle ERP Applications- Implementation, Support and Upgrade and Testing.
  • Excellent working noledge of Oracle Applications Experience - Financial Systems on OM, GL, me-Expense, e-Business Tax, FA, CM, AP, AR, me-Procurement, AOL, WIP and SYSADMIN.
  • Understanding for both the “Procure to Pay” process as well as the “Order to Cash” process.
  • Has been actively responsible for testing of the functionality of Oracle ERP Application. Well conversant wif documentation as per the AIM methodology.
  • Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
  • Extensive experience wif Oracle Financial Statement Generator (FSG) reports.
  • Has also been involved in scoping and mapping of business requirements of clients for Oracle Financials/Distribution solutions.
  • Very much conversant wif Configuring Oracle Application modules as well as understanding the underlying schema, which give me a better insight into converting user requirements into functional and technical specifications.
  • Extensive business area experience & has received great commendations at Client site for excellent interpersonal & Client interaction skills.
  • Strong communication & leadership skills wif an ability to interact wif business users.
  • Extensive experience wif Managing Off Shore and On Site teams.
  • Highly motivated individual; team player wif strong problem solving and analytical skills. Self-starter who can work independently wifout supervision.

PROFESSIONAL EXPERIENCE

Confidential, SFO, CA

Oracle Financials IT Analyst

Responsibilities

  • My core responsibilities involved implementation of Oracle e-Business Suite in the area of me-Receivables, Revpro, Advance Collections, e-Business Tax, OM, AR, AP, and GL modules and developing complete new FSG Reports.
  • Worked on Oracle e-Business Tax module configurations - worked on the setups of the rates, regimes, rate to regime flow, tax codes, tax rules, exceptions, exemptions, etc.
  • Worked on integration of Oracle e-Business Tax wif Vertex Q series
  • Worked on the setups of tax profiles, event class options, tax hierarchy, tax options in Oracle e-Business Tax.
  • Worked on Credit Card integration wif the Payment Gateway for Credit Card Authorization and Credit Card Settlement process
  • Worked on the Credit Card Integration wif American Express and Visa for loading of statements into me-Expense.
  • Resolved any month end related issues involving and data fixes or configuration changes.
  • Create and follow-up on multiple SEV1 & SEV2 SRs for speedy resolution explain business team wif cause of issue
  • Provide impact analysis on proposed changes and document the complete Change Management Process
  • Daily monitoring of incident issue tracker in Service Center team by Coordinating.
  • Configured and tested various FSG Reports (Income summary reports etc) dat were designed to meet the requirements of CORP Conducted and participated for daily upgrade teleconference meeting wif team, discussed about findings and issues. Attended and discussed issue resolutions and work-in-process update at the meetings wif clients in regular intervals.
  • Activities in System administrator to assign user accounts, assigned responsibilities, menu selection, reports, etc
  • Coordinate wif DBA team to apply patches proposed by oracle after following up on existing issues
  • Followed up wif Oracle team to fix errors while conducting SQL code writing, upgrading, manipulating, editing, and inserting using SQL Developer for Oracle EBS.
  • Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Form Builder 10g.
  • Worked extensively on XML Publisher reports.

Confidential, Madison WI

Oracle Financials IT Analyst

Responsibilities -

  • My core responsibilities involved the implementation in the area of me-Receivables, Advance Collections, e-Business Tax, RevPro, AR, AP, and GL modules.
  • Perform the related set-up tasks in the applications dat work together wif Expenses template to create an integrated environment for expense reporting.
  • Configured all the General Ledger, e-Business Tax, Payables, Fixed Assets and me-Expense set-ups in the test instance.
  • Worked on the setups of Oracle e-Business Tax module - setting up the rates, regimes, rate to regime flows, exceptions, exemptions, tax rules in oracle e-Business tax.
  • Configured Taxation for US Sales Tax, Canadian GST and VAT Tax in EMEA in e-Business Tax module.
  • Worked on Oracle E-Business Tax - Involved in the configuration of Tax Content Service, Tax Determination Services, Tax Users, Look Up Codes, TCA Geography Hierarchy, TCA Classifications for Tax, Tax Classification Codes, Tax Accounts and Tax Accounting Information.
  • Worked on Credit Card Gateway Paymentech - to integrate the authorization and settlement process
  • Worked on Credit Card gateway for importing of Expenses into Oracle me-Expense module.
  • Configured Revenue application Revpro 2.4 for revenue recognition.
  • Configured Erp-Revpro integration to support new version 2.4.
  • Configured Revpro Revenue Rules.
  • Defining new contingencies, rules, Arrangement templates, Accounting setups and custom lookups in Revpro to support new business models.
  • Created Process Maps and reviewed Desktop Procedures for Payables and iExpense Module.
  • Setup Multiple Organizations, General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets Cash Management, me-Expenses, Order Management and Purchasing Modules in development instance, SIT, UAT and Training Instances
  • Completed set up for banks, payments, payment programs, automatic and custom payment formats & programs, tolerances, payment terms, approval limits, signing limits, employee expense reports and expense report templates. Customized vendor letters. Defined payable holds, distribution sets. Completed Credit card and Procurement Card set up by defining credit card code sets, programs, profiles and card references. Defined VAT and Canadian Tax codes, groups and assignments to handle VAT tax calculations.
  • Payables process had been designed and system had been configured and setup for (Financial option, Payable system option & Payable option) to meet the requirements such as batch invoices, batch payments, employee expense report process and reporting.
  • Designed chart of accounts (COA) to meet the client’s business requirements and Set up the financials and payables options
  • Created different transaction types and sources for Receivables (AR) and Created distribution sets, receipt sources, receipt classes & payment terms. Worked wif customization of forms and reports
  • Created different bank accounts for Payables and Receivables. Set up the CE module to reconcile Payables and Receivables wif bank statements
  • Set-up Multiple Organization Access Control (MOAC) and Multiple Reporting Currencies
  • Troubleshooting of the Order Management (OM) and Inventory (INV) modules..
  • Worked wif me-Procurement to place purchase requests and completed the work-flow approval process, populate the orders in the purchasing module to complete the purchase orders
  • Train the business users on Global Translations, Revaluations and Consolidation of Multiple Ledgers
  • Created Users and modified the privileges for the Users, Rollup group and Summary Accounts.
  • Did setup for AGIS (Advanced Global Intercompany Systems) to handle internal company transactions

Confidential, Portland OR

Oracle Financials IT Analyst

Responsibilities

  • Coordinate wif Business team on day-to-day application issues and provide quick updates on issue resolutions along wif status updates on open items tracked in ACSI Service Centre.
  • Worked on GL Interface to import multi-currency Journals.
  • Worked closely wif the team members who conducted trouble shoot activities for the other Oracle applications such as Oracle Projects, Oracle Fixed Assets, e-Business Tax, AP Check Printing, BI, XML both in US /UK / Singapore operations
  • Worked on the setups of Oracle e-Business Tax modules - setting up tax for CST, Sales Tax, VAT and Use Tax
  • Defined the Rates, Regimes, Rate to Regime Flow, Tax Rules, Tax Sets, Tax Rates and Tax Codes on Oracle e-Business Tax.
  • Reviewed and extended the use of purchasing data (e.g., Requisition templates, categories, BPAs, ASL, etc) and made these data structures available to me-Procurement
  • Provide detailed root cause analysis on all assigned issues wif reproducing the same in latest cloned copy of test environment.
  • Provided Users wif access to multiple ledgers in GL through the use of GL Data Access Sets and to Multi-Operating Units through Security Profile in a secured environment.
  • Implemented Vertex tax Setup.
  • Worked wif development of packages and procedures using PL/SQL.
  • Configured the Multi-Organization Access (MOAC), Ledger Setup, and Legal Entities
  • Utilized the Application Object Library to register SQL*Loader programs, shell scripts, PL/SQL procedures and RDF Reports.
  • Worked on the setups of Financial Accounting Hub (SLA/FAH) module including the setups of Event Models, Sources and Source Data, Worked on the definition and build, accounting program integration, Accounting event setups, accounting event analysis, transaction objects, accounting method builder, etc.
  • Configured multi-org business structure in Oracle, Ledger Setup, Legal Entity, Establishment Setups, MOAC security
  • Set up Multi-Currency environment.
  • Configured all the General Ledger, Payables, me-Expense set-ups.
  • Setup MOAC for Payables module to restrict access to different operating units
  • Configured the Balancing Rules for AGIS Transactions.
  • Involving PO, me-Expense, me-Procurement, AP, AR, GL Modules meet wif customers to understand their system and service requirements and then Writing Functional Test Scripts for the end to end testing, coordinating wif the technical team to develop load testing scripts for all of the data conversions as well as inbound and outbound interfaces.
  • Oracle base table analysis related to form errors and coordinate wif technical team for speedy resolution
  • Provide Analysis in identify SQL code logic to trouble shoot application errors at different intervals

Confidential, Los Angeles, CA

Oracle Financials IT Analyst

Responsibilities

  • Worked wif the client team in understanding their business process and prepared various requirement gathering and functional design documents
  • Prepared “To Be Docs” for all five modules including GL, AP, AR, FA, and CE
  • Identified process flow through Grants module to introduce accounting activities to AR and FA
  • Identified and configured as per Client’s Requirements two future segments in COA
  • Defined grouping and Line ordering rules for Auto invoice, Auto accounting rules, Auto Cash rules, Receivable classes and Payment terms, Statement cycle, Dunning Letters etc.
  • Worked on the setups of AP/AR Netting.
  • Set up supplier auto numbering and AME workflow for invoice approval process and hold resolution
  • Introduced TCA to manage customer/supplier information and Bank information
  • Templates creation for Cash Forecasting, Cash positioning in CE module
  • Defined auto-reconciliation process to handle electronic bank statements wif Cash Management module
  • Created New Mass Allocation Formulas, to allocate head office rent expense to branch offices
  • Defined one Corporate Book for managing assets. Defined asset cost, asset clearing, depreciation expense, accumulated depreciation, CIP cost, CIP Clearing, Depreciation Adjustment as Fixed assets accounting
  • Per clients requirements, defined Straight Line Method (STL) asset depreciation and proposed depreciation ceilings and bonus rules
  • Identified the use of the current Descriptive Flex fields (DFF) in Purchasing into AP. Discussion how to integrate Confidential ’s current Asset Work to proposed FIS.
  • Created test scripts for UAT in TE40 documentation wif detailed testing of the modules involved in development of RICE components

Confidential

Oracle Financials IT Analyst

Responsibilities:

  • Understanding the existing business processes including AR, AP, GL, FA, CM, Sub Ledger Accouting, Fixed Asets, E-Business Tax, INV and Purchasing
  • Giving demonstration of standard functionalities of AR, AP, GL, FA, CM, Sub Ledger Accouting, Fixed Asets, E-Business Tax, INV and Purchasing to the Business Users.
  • Discussing wif business users and preparing business process documents like BP80 for future Process documents for AR, AP, me-Expense, GL, INV and FA.
  • Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
  • Worked on the setups in all the modules in Procure to pay and Order to cash cycle, which includes AR, AP, me-Expense, GL, INV and FA modules.
  • Developed several Row Sets, Column Sets, Row Set Account Assignments, Row Set Calculations, Column Set Account Assignments and Calculation, Content Sets for FSG Reports
  • Developed and defined more than 50 FSG reports and also created FSG report sets.
  • Created and maintained FSG Financial Reports critical to company’s business process.
  • 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.
  • Preparing various functional requirement and propose high-level design details for programs to keep data in Order Management and AR.
  • Setup of Accounting, Invoicing rules, Auto Lock Box process and Auto invoice process in AR module in AR module.
  • Responsible for the implementation ABC codes, Cycle counting and Physical Counting in Oracle Inventory.
  • In Advance Pricing, Defined Pricelists, Modifiers, Qualifiers, for different orders and customers in Advanced Pricing. Modifiers include discounts, freight discounts and point price breaks.
  • me procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data.
  • Providing support to users after implementation is done and fixing all issues related to set ups.
  • Fixing the issues for converted data for AR, AP, me-Expense, GL, INV and FA modules.
  • Conducting CRP1, CRP2 UAT1 and UAT2 and halping the user for going through all the test cases.
  • Working wif Technical team closely and getting done development for customizations for AR, AP, me-Expense, GL, INV and FA Modules.
  • Interacting wif upper management to identify the business process and needs and wif end users to identify their requirements.

Environment: Oracle Apps Release 12.1.3 e-Business suite (AR, AP, me-Expense, GL, INV and FA)

Confidential

Oracle Financials IT Analyst

Responsibilities:

  • Designing the system wif configuration setup for Purchasing and Order management modules
  • Setting up Document Approval and Security
  • Maintaining Purchasing Items
  • Managing the Supply Base
  • Managing Requisitions and Document Approval
  • Creating Purchase Orders and Blanket Purchase Orders, Receiving Production Items, Generating Purchase Requirements.
  • Managing Outside Processing
  • Worked on Order Cycle, which includes Booking, Scheduling of Order, Pick Release, Ship Confirming, Closing Order Lines and Order Headers, and Interface to Receivables, Invoice/Credit memo generation.
  • Defined time limit for Booking of Order, Set up pricing parameters/list.
  • Modification/cancellation of Orders/Order lines.
  • Defined the Set of Books and Chart of Accounts. Summarized accounting information required by product, by department.
  • Set up budget organizations & set up systems for entering budget amounts & journals and Set Cross Validation and Security rules.
  • Defined Period Types, Accounting Calendar, Currencies, Conversion Rate Types, Enter Daily Rates,set of books.
  • Defined Rollup Groups, Summary Accounts and Suspense Accounts.
  • Set up of Oracle Receivable dat included - Defining System Options, Accounting Rules, Aging Buckets,
  • Banks, Bank Charges, Bank transaction Codes, Dunning Letters, Transaction Types, Payment Terms, Invoicing etc.
  • Implemented Payables - Payment Terms, Pay Group, Tax Set up, supplier’s Sites, Bank, Distribution set, Financial and Payable options.
  • Basic Purchasing set up, identifying structure
  • Conducted Regression testing to examine the effects of a new Org on the previous Org.
  • Successfully provided Technical and Functional support to the users, testers and Business System Analysts.

Environment:Oracle Applications (11.5.9)

Confidential

Oracle Functional Consultant

Responsibilities

  • Implemented new Auto accounting rules for Receivables to halp drive the right accounting
  • Supported procure to Pay issues wif month end and additional configurations.
  • Defined the prorate convention, prorate calendar, depreciation rate and calendar, fiscal calendar and system controls
  • Grouped assets associated wif a specific project, department, and location to track CIP assets in the organization
  • Designed and created test scripts and user-manuals for the modules.
  • Resolved any month end related issues involving and data fixes /configuration changes
  • Configured AGIS for mainstream to handle intercompany transactions along wif defining intra company rules
  • Conducted study on the existing business practices, gatheird requirement specifications and performed Gap Analysis for implementing GL, AR.
  • Involved in AP AR Netting control Account/ Bank accounts/ configure AP AR netting Receipt Class/ Netting agreement.

Confidential

Oracle Financials Functional

Responsibilities:

  • Interaction wif Business Users to understand better their main points and Key requirements
  • Understanding current Chart Of Accounts and propose a future design to enhance the way Atrium does Business currently wif a new Chart of Accounts
  • Configuring/Updating Functional Setups of GL, AP, AR, and CE modules
  • Discuss and analyze handling of Project Capital Assets As-Is and To Be Process
  • Define Scoring models and Credit checklists for validated/ Approved customer list
  • Gathering Business Requirements for Upgrade considerations and documenting them
  • Capture and upgrade all the Custom Processes and Reports
  • Actively involved in implementation of E-business suite including gathering the requirements from the user and understanding their business model the modules worked on includes AR, AP, FAH, GL and FA Modules
  • Provide a Demo environment to show the Intercompany (AGIS) Future transactions in R12
  • Upgrade and modify the current Revenue Recognition schedule in AR to reflect R12 changes and Future Business needs
  • Develop Unit (TE.020) and System Integration Test Scripts (TE.050).
  • Designed chart of accounts (COA) to meet the client’s business requirements
  • Set-up accounting period types and accounting calendars
  • Set up Fixed Assets including defining category, location, and asset key flex fields.
  • Designed and configured Location and Fixed Assets Key Flex Fields, Asset Books, Asset Categories, Asset Sub-Categories, Asset Depreciation, Fiscal Calendar, Prorate Calendar, Security by Book.
  • Defined Asset TAX Book Performed Quick Additions, CIP Additions, Mass Additions and Capitalized CIP Assets.
  • Performed Asset Transfer, Mass retirement, Reinstate the retirement and Mass Changes in Assets
  • Grouped assets associated wif a specific project, department, and location to track CIP assets in the organization
  • Setup Oracle Payments for Check, ACH, and Credit Card Payment Methods
  • Set up the financials and payables options and created different bank accounts for Payables
  • Involved wif migration of historical data for Account Payables(AP)
  • Involved wif study of existing system, preparing the Functional (MD50) wif Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables
  • Configuration of CRP1, and UAT instances

Hire Now