Oracle Functional Consultant Resume
Atlanta, GA
SUMMARY
- Functional consultant wif 7 years of experience in Oracle Applications implementation, upgrading, supporting and involved in a few full cycle implementations of several releases 11i/11.x/R12.
- Strong expertise in Oracle Financials (General Ledger, Fixed Assets, Account Payables, Accounts Receivables and Cash Management) wif strong noledge of PO, Inventory and Full life - cycle conversion, implementation and post production support experience.
- Core competencies include Business Requirements Gathering and Definition, Gap Analysis, Mapping, Systems and Environment Set-up, Testing, End-user Training, Post Production Support.
- Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology.
- Knowledge wif Cross Validations Rules, Security Rules, Definition Rules and Data Access Sets.
- Worked on SLA (Sub Ledger Accounting) rules to replace traditional transaction codes for generating multiple accounting representations for one business transaction.
- Good at Financial Statement Generator (FSG) Reports Architecture
- Excellent communication skills, adapt in client interaction and understanding business applications.
- Pro-actively identify areas of opportunity and work to finding solutions that meet teh business needs of teh customer.
- Absolutely capable of working in a fast paced, dynamic, team-oriented environment wif 24x7 support.
- Excellent interpersonal and communication capabilities and extensive experience in dealing wif people from various organizational levels and diverse cultural backgrounds.
TECHNICAL SKILLS
ERP Applications: Oracle EBS R12/11i/11.5
Modules: Financials -- (GL, AP, AR, FA, CM), Supply Chain -- (INV, PO, )Methodology Application Implementation Methodology (AIM)
Operating Systems: Windows 95/98 /NT/2000/XP and UNIX
PROFESSIONAL EXPERIENCE
Confidential, Atlanta, GA
Oracle Functional Consultant
Responsibilities:
- Gathered business requirements, participated in setups, implementation and test scenarios for oracle financial modules
- Performed setups for GL, AP, FA, AR, CE
- Worked on fit gap analysis
- Provided post production support for all financial modules wif month end closing related as well as regular issues
- Set up EB-Tax which include tax regime, tax, tax status, tax jurisdiction, tax rate, tax rules, tax party and tax profile
- Implemented new Auto accounting rules for Receivables to help drive teh right Accounting
- Provided Test cases and executed them for any new projects
- Worked on EB-Tax to solve issues and implement a new tax rate for special Jobs in projects
- Setup Sub ledger Accounting for Receivables third party merge activity
- Working wif Finance team to drive teh proper Intercompany accounting
- Provided solution for cleaning up Security access wif teh appropriate responsibilities as per teh employee position
- Correct any auto-invoice errors while importing teh invoices while working wif Oracle wherever necessary
- Resolved month end issues wif Projects and helped import successfully any accounts or invoices related
- Setup various rollup groups to reflect in reporting for financials
- Work wif oracle and resolve any data fixes needed for month end close
Confidential, Columbus, South Carolina
Oracle Functional Consultant
Responsibilities:
- Involved in requirements gathering, analysis, development, QA and post-production support.
- Performed GAP analysis to ensure that teh requirements are captured properly.
- Setups included Multi-ledger, Multi-Reporting currency and Multi-organization.
- Coordinated and led teh entire phase of teh project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations, documentation implementation of modules.
- Gave teh overview on functional modules to technical team
Confidential, Portland, Oregon
Oracle Functional Consultant
Responsibilities:
- Responsible for teh documentation (BR.100 - Application Setup and TE.040 -System Test Script) and setups of teh General Ledger and Account Payables Modules
- Created BR100 documentation for GL and AP
- Interacted wif teh client team to understand teh existing business practices and prepared teh business requirement definition document
- Participated in designing teh chart of accounts to meet teh client's business requirements
- Created Customized responsibilities, customized menus, customized request groups
- Used Accounting Setup Manager for Inter-company Transactions
- Worked wif Technical team regarding conversion of data
- Provided various custom solutions for client's specific needs
- Created Test Scripts (TE-40's) for UAT sessions
- Created user-manuals and trained teh end users
Confidential, Phoenix, Arizona
Oracle Functional Consultant
Responsibilities:
- Resolved all teh functionaland technical issues for AR, AP, CM, FA, GL, PO Modules.
- Preparation and modification of documents like MD050, BR100 as part of project Deliverables for teh change requests for functionaland technical configuration changes.
- Post production support and maintenance of teh Application and resolved user queries.
- Created Accounting Flex Field Structure; Chart of Accounts; Set of Books, Mass Allocations and Summary Template. Tested teh features Translation, Revaluations, and consolidation.
- Prepared end user training material wif specific business cases and conducted end - user training.
- Involved in teh month end closure and reconciliation activities to close teh periods on respective financial modules.
- Provided production support for day to day business issues and worked on SRs wif Oracle.
- Provided daily user support for financial modules and applied patches as and when required to resolve teh Application issues.
Confidential, Tampa, Florida
Oracle Functional Consultant
Responsibilities:
- Provided Support for modules GL, AP, AR and CM
- Reviewed daily support SR's, co - coordinated wif users and resolved issues
- Identified SR's as GAP's that needed customization and reviewed wif management wif GAP analysis document
- Implemented and delivered newOraclefunctionalities wif user interaction, performing systems and unit testing.
- Trained users and Created test scripts for new functionalities
- Provided User training on one to one basis and also in group mode
- Updated Value sets' values for COA. Defined cross validation rules & security rules
- Designed Financial Reports using Financial Statement Generator (FSG) tool
- Set up of Parent & Child relations, Rollup Groups and summary templates
- Workflow Purchasing integrates wif OracleWorkflow technology to create standard purchase orders or blanket releases automatically from Approved requisition lines.
- PO matching options, invoice tolerances, distribution options, terms, holds, etc.
- PO setup and matching options wif invoices.
- Defined teh Aliases, Set up of Recurring Journals, Stat Journals & Mass Allocation Journals.
- Helped in Inventory management module for costing problem. Inventory valuation report was not tying wif General Ledger Inventory account. Cost group was teh problem and physical inventory was not updating teh quantity right.
Confidential, Minneapolis, Minnesota
Oracle Functional Consultant
Responsibilities:
- Involved days to day support activity forOracleGL, AP and AR modules
- Making required setups and Customizations in corresponding modules.
- Providing customization designs and work around for various business requirements.
- Customization of report and interfaces.
- Fixing setup related issues like calendar, suppliers, sites etc.
- Supporting business users for Month end and Year end processes.
- Prepared MD50, TE040 and migration documents.
Confidential, Atlanta, GA
Oracle Functional Consultant
Responsibilities:
- Gathering Business requirements from teh users for GL, FA, CM and PO
- Preparing meeting minutes and documentation for Business requirements
- Configuring iReceivables for customers so they ca has access to teh invoices balances and credit memos
- Set up User registration for various customers who needed access to teh customer accounts online
- Preparing functional specifications for GL, FA, CM and costing applications
- Personalized various menus and functionalities to support cross module query need for customers
- Setting up GL, FA, CM and PO
- Creating punch out catalogues and configuration of iProcurement
- Extracting data from PO and uploading for online purchase
- Creating catalogs and adding to BC defined stores.
- Creating new accounts for intercompany transactions, Bank set ups etc
- Evaluating teh Reports and testing them for teh desired outputs after development as per teh Business requirements
- Setup MRC for GL as well as Sub ledgers to maintain foreign currency transactions
- Defining system parameters for Cash management wif teh default set of books and other information
- Running various customized reports to evaluate any changes from teh existing set up
- Testing of P2P process end to end while providing support to users for teh same
