Oracle Financials Consultant Resume
3.00/5 (Submit Your Rating)
Fremont, CA
SUMMARY:
- Experience in working with Excel and Oracle Applications 11i/12 modules GL, AR, AP and System Administration and AOL
- Excellent experience in Functional Analysis, Application Implementation including Business process reviews and requirements Definition, Gap analysis, Customization analysis, Data Conversion, Preparation of test strategies and Test Plans
- Knowledgeable in Setups/Configurations, and in generation of Accounting Reports
- Strong Communication, Presentation and oral Skills
TECHNICAL SKILLS:
Oracle Application Modules: Oracle General Ledger (GL), Accounts
Receivables: (AR), Accounts Payable (AP)
System Administration: AOL, FA, OM, HR
Operating Systems: Windows 95/98/2000/NT/XP/Vista, UNIX, Linux, OS/2
Databases: SQL Server, Oracle, SAP, SAS, ACCESS
Languages: COBOL, C, C++, Java, JavaScript, HTML, Visual Basic,SQL* Plus, PL/SQL, Perl5, Scripting
PROFESSIONAL EXPERIENCE:
Confidential, Fremont, CA
Oracle Financials Consultant
Responsibilities:
- Responsible for analysis, reconciliation and collection of customer accounts.
- Involved in generation of FSG reports according to client requirements
- System Administration and the corresponding system profile options and application responsibilities.
- Setup of new organization structure (Multiple Organizations), Set of Books, Legal Entities, Operating Units, Chart of Accounts (COA).
- Define setup options, Accounting Flexfields, security rules, recovery journals, roll - up groups in General Ledger module.
- Configure invoicing rules, customer profiles, banks, bank accounts, collectors, dunning letters, statement-aging analysis in Receivables module.
- Define setup options, payment terms, Distribution set up, tax setup, Invoice management (standard, prepayment, credit memo, debit memo, expense report etc), payment set up in Payables module.
- Involved in the complete setup/configuration of the HR, GL, AR and AP modules.
- Unit testing, System testing and Integration testing of General Ledger (GL), Receivables (AR), Accounts Payable (AP), Human Resource (HR).
- Analyze current business process, determine changes to the procedures to achieve optimal results and working with the business community to improve overall operational efficiency.
Application Support Consultant
Responsibilities:
- Set up and support QuickBooks for AP, AR, Payroll, Reconciliation of Bank accounts, P&L reports and Balance Sheets.
- Created Excel reports and tables by collecting data collected from 15,000 servers daily.
- Performed ad hoc query on IT web-based database.
- Collected data to create statistical tables and reports posting on web. Administrated and designed Oracle 8 and MS SQL database.
- Provided technical support for all departments which used Red Hat Linux and Windows XP/NT/2000/2003 computers.
Database Developer/Administrator
Responsibilities:
- Created and published network performance reports from various reporting tools: Crystal Report, SAS ITSV, Concord Network Health, and VitalSigns.
- Designed and implemented a SAS (Solaris) data mining of networking statistics for an enterprise-wide network performance database.
- Administered and maintained MS SQL database systems for data warehouse.
- Programmed in SAS and Perl5 to automate reporting processes.
Computer Network Consultant
Responsibilities:
- Provided technical support for SAP rollout project.
- Computer inventory control for computer lab library.
- Developed and programmed for computer lab usage database system.
- Established network connectivity through WAN and LAN for servers and mainframe.