We provide IT Staff Augmentation Services!

Oracle Functional Consultant Resume

5.00/5 (Submit Your Rating)

Hightstown, NJ

SUMMARY

  • More than 7.1/2+ years of diverse experience as an information technology professional, wif over 6+ years of managing substantial components of large - scale ERP Implementations, CRM, System Integration, Test Management, Change Management and O&M experience, I’m very proficient in system development life cycle, requirement analysis, solution design and deployment of technology solutions.
  • I have very strong background in Oracle Financial and Oracle Federal Financial Applications modules such as Oracle General Ledger, Oracle Purchasing, Oracle Receivables, Oracle Payables, Budget Execution, and Oracle Projects, Oracle Workflow (WF), PRISM, Oracle Compusearch Interface (OCI), SQL and PRISM Data structures and Oracle database.
  • PRISM Export Jobs, DCIS/FPDS system. I have In-depth experience on implementing financial management and procurement solutions.
  • I’m highly knowledgeable of federal government acquisition processes from Requisition through Award closeout and how the PRISM suite supports those processes.
  • In addition to strong background in Oracle Federal Financials I have very good understanding of Federal Accounting & FARFAC.
  • Working wif Oracle Federal Financials and Commercial Oracle Financials products.
  • Management and Deployment of key functional areas in major federal agencies.
  • Involved in full life cycle of implementations, including requirements gathering, business process flows, system configuration, training and stabilization of implemented systems and support in an integrated environment using various implementation methodologies like AIM.
  • Excellent knowledge and experience in core Federal Financial Modules like General Ledger, iProcurement Accounts Payables and Purchasing.
  • Excellent communication and presentation skills coupled wif ability to build long-lasting client relationships.
  • Set Up configuration, CRP, UAT, Conversion, and Customization Functional specification definition and documentation.
  • Extensive working experience Oracle E-Business suite R12 for GL, AP, AR, PO.
  • Worked in Oracle SCM, Financials (GL, AP, and AR), Manufacturing (INV, WIP, and BOM), PO (Oracle Purchasing), OM (Order Management/Advanced Pricing) and AOL (Application Object Library).
  • Experience in set-up, configuration, and functionality checks, building Forms, generating Reports and registering them as concurrent programs in Oracle applications using AOL, UNIX shell scripts.
  • Experience in developing detailed functional design documents for business solution components and prototypes for Oracle Applications Suite and Prism.
  • Conduct Test Readiness Review before IT and UAT Testing, daily and weekly test status meetings wif PMO (Project Management Office), end users and team members. Also worked closely wif PMO on Project Plans, Test Schedules and Project Milestone activities.
  • Extensive experience in writing Test Plans, Testing Procedures, Test Matrices, Test Data Generation and execution of Test Plans.
  • Implemented the software development lifecycle (SDLC) to follow the Standards process in the application

TECHNICAL SKILLS

Oracle ERP: Oracle Financials R12&11i - GL, AP, AR, CE, FA, E-B Tax, PO, iExpense, Sys Admin, SLA, P2P, O2C and A2R. and MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Hightstown, NJ

Oracle Functional Consultant

Responsibilities:

  • Drove an accelerated solutions environment process where a high level set of requirements were defined in a week, by leading a team of senior executives through a series of guided brain storm session.
  • Review and scope new requirements, requests for change and problems for modules.
  • Created BR100 documents (Application Setups) for new modules lined up for implementation.
  • Prepared AS-IS understanding document for GL, AP, CM, PO, and INV
  • Requirement analysis ofpresent financial system and suggesting the new system based onOracle Financials.
  • Helped inarriving toanappropriate CoA structure.
  • Performed GAP analysis and prepared solution presentation for review.
  • Performed functional assessment for GL, AP, PO, OIE and custom modules.
  • Involved in Analysis, Design, Business Process mappings for Integration project.
  • Impact analysis in current business process due upgrade changes/enhancements.
  • Business process Mapping wif all standard and customized modules.
  • Develop Open Purchase Orders report using XML that queries all Open PO's at header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.
  • Design test scripts of all sub-process identified in assessment phase.
  • Coordinated wif the offshore team to get the requests done.

Environment: Oracle Apps (R12.1.3), PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2 and UNIX. Modules: SCM (PO, INV), Financials (AP, AR, GL, FA), CM, OPM; SQL, PL-SQL, Forms 6I, Reports 6i, XML Publisher, Putty, Winscp 3, FTP, Windows XP and UNIX.

Confidential, Fairfield, IL

Oracle EBS Functional

Responsibilities:

  • Implementing Accounts Payables, Receivables, Cash Management and General Ledger for all business units of UCI
  • Identifying standard functionality, and analyze gaps and complete solution for GL, AR, AP and CE depending on Business requirement
  • Business communications for the system updates and meeting deadlines for the implementation.
  • Setting up Multi-ORG and Multi Currency
  • Set-up of Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar, Currencies
  • Setting up Standard Journals, Statistical Journals, Recurring Journals and Suspense Accounts and Mass Allocation, Defining FSG’s, Creating Ad-hoc Reports, and Open and Close Accounting Periods
  • Setting up Consolidation Ledgers, AGIS for intercompany Transactions
  • Setting up AP for PO matching and non-matching supplier invoices, payment profiles for check and wire, sub ledger accounting of payables transactions and transfer to GL
  • Setup Banks, Bank Accounts and documents
  • Setting-up of AR for invoice transactions including auto invoicing from OM and Service Contracts, auto application of receipt application to invoices using auto lockbox functionality, sub ledger accounting
  • Set-up of invoices, debit and credit memos, guarantees, deposit transaction types
  • Set-up receipt class, receipt methods, receivable activities and setting up accounting information for revenue recognition
  • Defined Customers, organizations, locations, control rules and groups.
  • Defined payables lookup, payables option, tax codes, set up bank details, invoice payment terms.
  • Defined distribution sets, matching tolerances for purchase order matching, payment programs and payment formats.
  • Created different types of invoices and payment methods.
  • Forms Personalization in iExpense and iProcurement using Oracle Application Framework Personalization
  • Setup financials and payables options including all key configurations in Accounts Payable
  • Auto import and reconciliation of bank statement in CE
  • Conducted CRP 1 & CRP 2, Tested RICE components and UAT
  • Prepared BP 40, CV40, BR100 documents and created MD 50 for all RICE components

Environment: Oracle EBS R12, iProc,OM,AP, PO, AP, GL, AR, Quality Center, TOAD

Confidential, San Antonio, TX

Oracle Financial Functional Analyst

Responsibilities:

  • Involved in Month-end support for close and reconciliation for AP and AR modules
  • Prepared impact analysis for critical issues
  • Resolved issues that occurred in the production
  • Have followed up wif the business for approval of the resolved issues
  • Worked wif the business to develop updated business policies based on issues resolved
  • Actively involved in troubleshooting various issues
  • Provided production support on GL, AP, AR, FA, PO, and iExpense modules and resolved period end closing and interface issues in production. Trained user on process design and enhancements
  • Resolved all the issues which were raised in Bugzilla
  • Interacted wif Oracle Support to resolve critical issues through SR/TAR
  • Periodical status updates to PMO and follow up wif pending business input or issue resolutions as part of status meeting

Environment: Oracle Applications 11i (11.5.10/11.5.9 ), GL, AR, AP, FA, PO, OM (Advance Pricing, Shipping), INV, WIP, BOM Oracle 9i, PL/SQL, SQL*Loader, SQL*Plus, TOAD and Discoverer 9i.

Confidential, Rockville, MD

Oracle Financial & PRISM Analyst

Responsibilities:

  • Development of Manual Test Scripts using Quality Center
  • Development of automated test scripts using QuickTest Pro
  • Maintenance and Execution of automated test scripts
  • Setting up of Test client environment.
  • Execution of Navigational and Functional test scripts.
  • Testing of various security levels.
  • Used RTM (Requirements Traceability Matrix) to group and track system requirements to Verify that each of the system requirements have been satisfied.
  • Prepared impact analysis document for upgrading the OCI code from 11.5.9 to 11.5.10.
  • Involved in creating Design documents, RTMs and Unit test plan documents.
  • Actively Participated in Fit/GAP analysis discussions for iProcurement module.
  • Actively participated in scope analysis and design of major technical tasks including workflow development/modifications, interfaces and reconciliation reports. Effort assisted in confirming scope, timelines and estimates.
  • Drafted various functional documents including Process flow diagrams and flow charts.
  • Involved in day-to-day support of AP, PO, iProcurement and PRISM modules from Administration and Technical point of view.
  • Oversaw analysis, design and development of Conversion scripts to load external Contract awards to PRISM instance.
  • Opened service requests wif Compusearch and worked wif Compusearch Support team to resolve PRISM related issues.

Environment: Oracle Applications Rel.11i (11.5.10), PRISM 6.1, Oracle8i/9i/10g (SQL, PL/SQL), Reports6i, TOAD, Workflow, Quality Center

Confidential, Alexandria VA

Software Engineer

Responsibilities:

  • Review of Technical specs
  • Planning of the testing schedule
  • Development of Test plan and review /update of Test Scripts
  • Development of manual test scripts using Quality Center
  • Maintenance and Execution of manual test scripts
  • Setting up of Test client environment
  • Execution of Navigational and Functional test scripts
  • Testing of various security levels
  • Execution of Actuate report test scripts
  • Testing of emailing and Paging functionality for Partner Support application
  • Preparation of project status report for QA

Environment: Siebel 7.0.3, Siebel 6.2.2, Windows NT4.0, IE5.5, Actuate reports, Winrunner, LoadRunner, Test Manager and RequisitePro

Confidential, Washington DC

Junior Business Analyst

Responsibilities:

  • Prepared requirements document based on client specification documents.
  • Conducted reviews wif members of the development team to ensure the accuracy of test cases.
  • Helped wif resource allocation and management skills required for addressing different projects.
  • Kept the team informed wif project progress through weekly status reports and team meetings.
  • Provided weekly status reports to Project management.
  • Performed administrative activities during the project.

Environment: Rational Suites, Clearcase, J2EE, websphere, Momentum, Test Manager, Oracle 10g, Lotus Notes

We'd love your feedback!