We provide IT Staff Augmentation Services!

Oracle Resume

Irvine, CA

Executive Summary:

  • Over 6.8 years of experience in analysis, design, development, implementation, support, and maintenance of Oracle Applications 11i and R12.
  • Strong knowledge of Oracle Business Accelerators (OBA) being an OBA Level – 3 certified professional.
  • Expertise in Functional aspects of Oracle Applications 11i/R12 Financials modules which includes Account Payables (AP), Account Receivables (AR), General Ledger (GL), Purchasing (PO), Cash Management(CE), Fixed Assets (FA), Credit Management (CM), Advanced Collection (AC), System Administrator (Sys Admin) and E-Business Tax (eBTax).
  • Expertise in Financial modules with strong experience in Order to Cash and Procure to Pay cycles.
  • Well versed with R12 SLA (Sub ledger Accounting), MOAC (Multi-Org Access Control), COA (Chart of Accounts) and Multi-currency.
  • Experience in requirement gathering and mapping business requirements to Application features.
  • Experience in implementing Oracle E-Business Tax (eBTax) module at various configuration levels such as Global Configuration Level and at Operating unit level based on business requirement.
  • Worked on request group, users, menus, flex fields configurations, responsibility creations required for customization through System Administrator.
  • Good exposure and experience in the preparation of Application Implementation Methodology (AIM) documents such as BR100, RD050, TE040.
  • Established expertise in implementing Oracle Applications R12 Multi-Org setups for clients having business in multiple countries across the world.
  • A team player with exceptionally good organizational, analytical, training, trouble shooting, functional and interpersonal communication skills.
  • Exposure and experience on financial modules database tables using SQL scripts, and SQL*Loader.
  • Hands on experience in troubleshooting Production Issues in various modules.
  • Good analytical, problem solving, communication, presentation and leadership skills. Ready to take the challenges with a Positive attitude and dedication, A Key team player.

Educational Qualifications & Certifications:

  • Bachelor of Technology in Computer Science
  • Oracle Business Accelerators (OBA) Level-3 Certified Professional

Technical Skills:

ERP

Oracle Applications EBS 11i/R12

Modules

General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Cash Management (CE), Fixed Assets (FA), Purchasing (PO), Credit Management (CM), Advanced Collections (AC) and E-Business Tax(eBTax), System Administrator

iModules

iSupplier, iExpense

Processes

Order to Cash (O2C/OTC), Procure to Pay (P2P/PTP)

Database

Oracle 9i / 10g

Languages

C, C++, SQL

Tools and Utilities

Oracle Business Accelerators, Toad, SQL *Plus

Operating Systems

Windows 9x/NT/2000/XP

Professional Experience:

Confidential, Irvine, CA Apr 2011 – Till Date
Oracle Functional Consultant
HID Global is the trusted leader in solutions for the delivery of secure identity solutions for millions of customers around the world and is committed to enhancing customer value by delivering the most trusted, advanced and dependable secure identity solutions in the market. This project involves implementation of Oracle Financial, Customer Relationship and Supply Chain Modules.
Responsibilities:

  • Played a key role in the implementation of Oracle Financials R12 modules.
  • Responsible for requirements gathering and converting the client data as per OBA tool.
  • Business Requirements Mapping for AP, AR, GL, E-Biz Tax and Cash Management modules.
  • Designing Oracle Applications Financial setups and Operating structure of client organizations - Multi-Org Setup.
  • Setups for Oracle General Ledger (GL) involved defining 4Cs: Chart of Accounts, Currency, Calendar, Accounting Method and Rules.
  • Implemented Location based tax for Accounts Payables & Accounts Receivables through E-Business Tax.
  • Involved in taking OBA instance run to develop base instance and performed post-setups.
  • Testing modules setup for inconsistencies and missing steps-Test scripts and Users Acceptance Test (UAT).
  • Worked on Auto-Invoicing to import transaction from Order Management and Projects.
  • Responsible for writing SQL queries to fetch data from 11i instance that can be used during re-implementation of Oracle Applications in R12 version.
  • Documentation of test scripts for Payables, GL, Receivables, and Cash Management & Fixed Assets with different scenarios.

Environment: Oracle Applications R12 (AP, AR, GL, CE, PO, FA, E-Biz Tax), Oracle 10g, SQL, SQL*Plus

Confidential, Aliso Viejo, CA May 2010 – Mar 2011
Oracle Functional Consultant

Quest is a global software company offering a broad and deep selection of products that target common IT challenges. Quest creates simple-to-use, innovative IT management software that saves time and money across physical, virtual and cloud environments.
Responsibilities:

  • Implementation and support of Oracle Applications R12 (GL, AP, AR, FA, CE, CM & AC).
  • Modeling and Design of Solution based on Requirements.
  • Analysis and Mapping of Requirements to the Application.
  • Involved in the design of Ledger configuration and Subledger Accounting setups. R12 concepts were utilized to map out the new Ledger reporting.
  • Configured GL, AR, Oracle Payments, AP, FA and Cash Management modules on Oracle R12 platform. Multiple Bank interfaces and Bank Reconciliation were setup for Cash Management purpose.
  • Involved in working with Oracle support and Development teams to fix product issues.
  • Testing modules’ setup for inconsistencies.
  • Creation of Content such as Setup Documents, Flow Models, Test Scripts and UPK scripts for End User training.
  • PO creation, invoiced the PO in AP, created payments for purchases and finally posted to GL, in order to test the P2P flow as per business requirement.
  • Imported transactions from OM to Receivables through Auto-Invoicing and then used Accounting Methods as per clients requirement for Revenue Recognition then applied receipts to the transactions finally posted the accounting entries to GL.
  • Performed setups for Advanced Collections Strategies to identify and process the payment for the transactions from the delinquent customers.

Environment: Oracle Apps R12 (AR, AP, GL, PO, FA, CE, CM & AC), SQL *Plus, SQL, Oracle 10g

Confidential, Redwood Shores, CA Sep 2009- Apr 2010
Oracle Functional Consultant
Oracle has been the leader in database software. And as it has further developed technologies and acquired best-in-class companies over the years, that leadership has expanded to the entire technology stack, from servers and storage, to database and middleware, through applications and into the cloud. My tenure here revolved around strengthening Oracle Business Accelerators Financial Modules for Oracle USA solutions.
Responsibilities:

  • Analysis of effort estimation for automation of Advanced Collection and Credit Management.
  • Setups for Advanced Collections and Credit Management with the help of user guides and analyzed the functionalities that can be implemented through accelerator and can be incorporated in our solution.
  • Setup Strategies and Dunning Letters foe the Advanced Collections collection methods and created customized Customer Scoring Methods.
  • Setups for the Credit Management Agents, Resources & Roles and Responsibilities, created Credit Scoring, Data points, Automation Rules & Checklist to complete the setups for Credit Management modules.
  • Guided the tools team to automate the setups required for the implementation of Advanced Collections and Credit Management.
  • Involved in building instance through setup tool.
  • Involved in certifying and validating instance with iterative testing.
  • Document preparation like TE040, Key Assumptions document, BR100, Flow Model etc.

Environment: Oracle Applications R12 (AC, CM & AR)

Confidential, Redwood Shores, CA Dec 2008– Aug 2009
Oracle Functional Consultant
Oracle Business Accelerator solution design to implement companies having business in various part of the world like United States of America and Latin American countries such as Columbia. Worked on various localization features for Latin American countries.
Responsibilities:

  • Gathered the Financial Requirements from the Country Team and mapped the same to Oracle Applications.
  • Implementation of country localizations such as currency, chart of accounts, calendar, taxation & payment formats.
  • Implementation of withholding tax in the payable module.
  • Setting up Master Data for Testing i.e. Bank and Bank Accounts, Setting up Suppliers and Customers.
  • Defining special calendars (Withholding, Recurring), Creating Recurring Invoices Templates, Creating Expense report Templates.
  • Involved in defining Receivables Activities, Receipt Classes.
  • Involved in doing transactions in Payables and Receivables to validate the instance.
  • Worked on Common application setups, Shared setups (P2P,O2C), and Application specific setups in Oracle Purchasing (PO) module.
  • Responsible for opening and closing the accounting periods in AR & AP.

Environment: Oracle Applications R12 (AP, AR, GL, PO)

Confidential, Redwood Shores, CA Feb 2008 - Nov 2008
Oracle Functional Consultant
Oracle Business Accelerator solution design to implement companies having business in various part of the world like United States of America (USA), Canada, France, Denmark & Sweden
Responsibilities:

  • Involved in validating natural accounts, parent child relationship in accounts.
  • Involved in defining COA, Multi-Org structure, Payables, Receivables & Fixed Assets setups.
  • Creating Mass Allocation, Recurring Journal templates.
  • Involved in defining Cross Validation Rules and Security Rules.
  • Involved in creating prepayments, making payment to those prepayments, applying them to Invoices.
  • Defining Recurring Invoices, Distribution Sets Financial, Payables and System Options.
  • Matching invoices to PO and Receipt.
  • Involved in defining E-Business Tax Setups.
  • Involved in creating, preparing & posting Mass Addition in Fixed Assets.
  • Involved in doing payment setups to pay multiple currency invoices.
  • Involved in creating Payment Formats for various EFT payments.
  • Involved in defining Bank & Bank Accounts and perform AP/AR Netting.
  • Involved in defining Receivables Activities, Receipt Classes.
  • Involved in doing transactions in Payables and Receivables to validate the instance.
  • Involved in preparation of testing document with various Business Scenarios & Business Processes.

Environment: Oracle Apps R12 (AP, AR, E-Biz Tax, GL, FA) Oracle 9i

Confidential, Apr 2006 – Jan 2007
Oracle Functional Consultant
Confidential, is one of the world’s leading communications services companies, serving the needs of customers in the UK and in more than 170 countries worldwide. BTs main activities are the provision of fixed-line services, broadband, mobile and TV products and services as well as networked IT services. This project includes the production support of various Oracle Application modules.
Responsibilities:

  • Involved in managing period close for AR, AR modules.
  • Involved in solving production issues with respect to Requisitions and Purchase Order.
  • Involved in performing unit testing when new setups are performed and moved to production, to identify the negative impact on related functionalities.
  • Involved in activation and deactivation of accounts and account code combinations based on the business requirement.
  • Responsible for running the periodic request sets for business needs.
  • Responsible to upload data using data loader to make enormous changes in existing data in the application.
  • Responsible to take the business lead approvals before continuing with the updates in production instance.
  • Involved in assigning the business area specific issues to module consultants.
  • Responsible for setting up various profile options.
  • Responsible to solve Payment Batch issues.
  • Run Journal Import in General Ledger (GL) to load the data into Oracle application tables.
  • Did system administration, created New Menus, Responsibilities, Users, etc.

Environment: Oracle Apps 11.5.10 (AP, AR, PO, GL, iExpense & iSupplier)

Confidential, Bradford, UK Aug 2005 – Mar 2006
Oracle Functional Consultant

My Travel is a world’s leading holiday & leisure group. MT work with some of the leading suppliers in the business, which means consistently good value and competitive prices for any duration holiday - all live and calculated at the time of booking. This project includes the production support for Oracle Applications.
Responsibilities:

  • Involved in defining users and assigning responsibilities to new users based on business approval.
  • Uploading bulk data using data loaders.
  • Managing Natural Account values according to business requirement.
  • Involved in defining cross validation rules.
  • Involved in updating Supplier & Customer details.
  • Worked on iSupplier & iExpense modules.
  • Involved in resolving production issues for AP modules.
  • Involved in running customized reports based on client’s requirement.

Environment: Oracle Apps 11.5.10 (AP, GL, Sys Admin, iExpense & iSupplier)

Hire Now