Functional Consultant - Oracle Ebs R12 Resume
Silver Spring, MD
SUMMARY:
- Enterprise Resource Planning (ERP) professional with more than twelve years of hands - on experience in Oracle Financials Application. Worked on several Oracle Financials Application engagements including full life cycle implementations, upgrades and Operations and Maintenances.
TECHNICAL SKILLS:
Financials Application Software: PRISM 6.3 (Procurement) ADP Payroll
Methodologies: AIM implementation Methodology Oracle Unified Method (OUM)
Utilities & Tools: Dataloader Oracle SQL Developer TOAD QTP version 9
Database Tools: Putty Refection
RDBMS & Languages: Oracle 7.x, 8.x, 9i SQL, PL/SQL
Software Packages: MS. Office and MS Project Visio
Operating Systems: Windows (95, 98, NT, 2000, XP) HP-UX UNIX and UNIX Sun Solaris
PROFESSIONAL EXPERIENCE:
Confidential, Silver Spring, MD
Functional Consultant - Oracle EBS R12
Responsibilities:
- Conducted end users workshops to define and to document the "As-Is" functional business processes, Procure to Pay (P2P), Order to Cash (O2C), Record to Report (R2R) and the specific business rules required in the US Office of Personnel Management (OPM) agency business environment
- Reviewed and updated the current functional architecture diagram of the legacy Trust Fund systems application and its interfaces with other external systems based on the input from technical and functional end users
- Provided all the deliverable documents to the end users for reviews and approvals
Confidential, Chicago,IL
Functional Consultant - Oracle EBS R12
Responsibilities:
- Assisted Functional implementation team members using BR 100 documents, in completing the setup and configuration of AP, FA and AR modules for Newedge Paris branch office
- Administered the end to end F10 interface program data load into Oracle R12 Financial Accounting Hub (FAH) and sent various financial reports to Brokers and Accounting teams
- Provided operations and maintenance of FAH, GL, AGIS, EB Tax, AP, FA and AR modules to Brokers and Accounting team members; resolved issues by using SQL queries and analyzing PL/SQL, stored procedures, triggers and Oracle Workflow
Confidential, Washington, DC
Techno- Functional Consultant - Oracle Financial Application
Responsibilities:
- Provided end-users support for Oracle Project Accounting (Costing, Billing) of Release 11i (11.5.10)
- Reviewed the setup for Oracle project templates, project agreements and project funding
- Ran end to end test scripts to validate the integration between Oracle Project, Procure to Pay and Fixed Assets modules; tested also the integration between Oracle Project Billing and Accounts Receivable modules
Confidential, Silver Spring, MD
Techno- Functional Consultant - Oracle Financial Application
Responsibilities:
- Provided end-users support for Oracle E-Business Suite Release 12 (12.1.2)
- Assisted the Client in resolving all the issues related to Oracle General Ledger, Oracle Subledger Accounting (SLA) and Procure to Pay (P2P) modules
- Created Oracle Metalink Service Request tickets; implemented Oracle support recommendations
Confidential, Washington, DC
Techno- Functional Consultant
Responsibilities:
- Reviewed the setup for Inventory and I-Procurement modules in the System Testing instance
- Ran test scripts for I-Procurement, I-Supplier and Sourcing modules in the System Testing instance
- Assisted users during Users Acceptance Testing (UAT).
Confidential, Washington, DC
Techno- Functional Consultant - Oracle Financial Application
Responsibilities:
- Documented procedures for processing additional funds (trigger funds) received by the agency and produced end-users documents
- Tested custom reports developed to track Trigger Funds processing
- Participated to Operations and Maintenance weekly status meeting
Confidential, Crystal City, VA
Techno- Functional Consultant - Oracle Financial Implementation
Responsibilities:
- Reviewed Oracle Project Accounting (Costing, Billing) work instructions materials for train the trainers sessions
- Created Oracle Project Accounting (Costing, Billing) exercises and ran the exercises in the classroom labs
- Ran test scripts for Oracle Project Accounting (Costing, Billing) module in the test instance
Confidential, Reston, VA
Oracle Procure to Pay Team Lead
Responsibilities:
- Provided support for transactions processed between Oracle Financials, CompuSearch PRISM procurement application and Sunflower Asset Management application
- Assisted users during month-end closing resolving issues related to HRMS and Accounts Payable reconciliationwith General Ledger
- Met with end user to define and to document the "As-Is" and "To-Be" business processes, business rules, for the upgrade from Oracle Financial Release 11i (11.5.10 CU2) to Release 12
Confidential, Reston, VA
Senior Oracle Techno- Functional Consultant
Responsibilities:
- Provided Oracle Federal Financials “Procure to Pay” end-users support after go-live
- Tested and documented Oracle Financials Applications disaster recoveries scenarios
- Created Tars, implemented Oracle support recommendations, tested and documented deployment process
Confidential, Vienna, VA
Senior Oracle Functional Consultant
Responsibilities:
- Assisted in the resolution of Purchase Order (PO), Accounts Payable (AP) and General Ledger (GL) modules issues
- Exported Oracle reports into Microsoft Excel and analyzed data
- Provided Oracle Federal Financials “Procure to Pay” end-users
Confidential, Linthicum, MD
Senior Oracle Functional Consultant
Responsibilities:
- Developed and maintained MS Access database to Load users and assigned them responsibilities in all the 17 instances (Test, Development,, Configuration, Conversion, Production and Post-Production support)
- Exported users and responsibilities information before the clone and reload the data when cloning is completed
- Used BR100 documents to verify configuration of new custom responsibilities of the cloned instance to match latest requirements from UAT
Confidential, Bethesda, Maryland
Senior Oracle Functional Consultant
Responsibilities:
- Prepared materials and conducted Accounts Payable (AP) super users
- Supported Accounts Payable (AP) team in resolving issues regarding AP
- Tested and documented Oracle Financials Applications disaster recoveries scenarios
Confidential, Douala, Cameroon
Senior Oracle Functional Consultant
Responsibilities:
- Worked in Douala, Cameroon using Oracle Application Implementation Methodology (AIM) to implement FA from business requirements gathering, solution design, system configuration, Conference Room Pilot (CRP) testing, User Acceptance testing (UAT), data conversion, user, production transition, and post implementation support.
- Performed BPR analysis and interact with different levels of management to redesign business process flows. Participated in the creation and mapping of the chart of account and in defining financial management reports; communicated with users and developers for custom reports and data conversion format.
- Prepared materials, conducted super user and post implementation support.
Confidential, Herndon, VA
Senior Oracle Functional Consultant
Responsibilities:
- Supported Equant Fixed Asset team in resolving issues regarding Asset Acquisitions, Modified values, Modified Attributes, Disposals and Transfers
- Ran monthly procedures to import and upload financials data from the European business units into the Equant headquarter financial consolidation instance
- Assisted Controller and accountants in the resolution of Equant month-end global consolidation issues
Confidential, Herndon, VA
Senior Oracle Functional Consultant
Responsibilities:
- Worked in Paris, France to train and lead the Oracle support team EMEA (Europe Middle East and Africa) operations in resolving issues in General Ledger, Fixed Asset, Accounts Payable, Accounts Receivable and Global Accounting Engine
- Created set of books for the Euro currency in General Ledger and in Fixed Assets modules; ran Mass Additions to load converted data into the Euro Fixed Asset books; performed testing to ensure accuracy of conversion
- Contributed on the chart of accounts mapping between France GAAP and US GAAP for the acquisition of Transpac by France Telecom; transferred more than 100,000 Assets into Equant Fixed Asset Books
Confidential, Vienna, VA
Senior Oracle DBA
Responsibilities:
- Automated daily database backup using batch files and Windows NT scheduler
- Cloned production databases to allow to Microsoft ASP developers to implement and test new requirement functionality
- Migrated Unix database to NT using the Oracle export/import utility
Confidential, Falls Church, VA
Database Conversion Analyst
Responsibilities:
- Installed and tested Oracle 7.3 database creation and data load processes
- Installed front-end oracle applications databases on the Windows NT workstations; configured Windows NT 4.0 workstations and servers; provided connectivity to wide area network using TCP/IP
- Migrated data from Wang database into the Oracle Server; loaded text files into Oracle using SQL*Loader
Confidential, Washington, DC
Project Assistant
Responsibilities:
- Entered approximately 500 datacommunications connections in oracle database application; Improved database accuracy by working with engineers, technicians and users
- Helped Project and Task Manager in the elaboration of future projects using Microsoft Project
- Maintained Lotus Note Contact Database for the Department head
Confidential, Washington, DC
Program Coordinator
Responsibilities:
- Created a database for courses schedule using Paradox 5.0
- Maintained inventory and replacement schedule on all equipments for classroom labs
- Provided assistance to students on software such as Lotus and Paradox