Oracle Project

Tarek Eid

Tel.: 647-***-****

********@*******.***

Toronto, ON, Canada

CAREER OBJECTIVE

A functional consultant and senior Business system analyst seeking to secure a job with challenging responsibilities that will fully utilize my project management and functional experience in the field of software and application development; where I can make a valuable contribution to the growth of your organization and provide me the opportunity for personal growth and career development.

ACCOMPLISHMENTS

Over 10 years of hands on experience as an Oracle Application Consultant, Senior Business Analyst, and System Analyst/Programmer with reputable organizations

Implemented/upgrade numerous IT projects including Oracle Financial - Oracle E-Business Suite R12 and R11i (GL, AP, FA, AR, CM, P2P, SLA, and E-Business Tax), with four FLC R12 Implementations and five R12 upgrades.

Build positive client and peer relationships by developing an understanding of the clients, their business and the project needs.

Results oriented and objective in dealing with client’s requirements and has the ability to build healthy relationships with clients/customers.

TECHNICAL SKILLS

ERP

Oracle E-Business Suite – Oracle Financial R12 (12.0.4), (12.0.5) (12.1.3) (12.2.3) (12.2.4), 11, 11i (11.5.8, 11.5.9, 11.5.10)

Database

Oracle 10g, 10.2.0.3.0, 9i, 9.0.1.4.0, 8.1.7, DB2

Operating Systems

NT 4.0, Unix SVR4 (AT&T), UNIX Solaris, AIX Unix, DOS/VSE, VSE/SP, AOS/VS, VS/5600

Hardware

Compaq Proliant 6400R, SUN Enterprise 450, IBM RISC 6000, AT&T 3435, DATA GENERAL (MV/15000), WANG (VS/5600), NCR 9020, IBM43xx

Protocols

TOAD, SQL& PL/SQL, FSG/ADI (Oracle), TRITON TOOLS (BaaN), ICCF, JCL (IBM)

Computer Languages

Cobol, Basic, Fortran

Education: B. Com - Bachelor of Commerce (Accounting).

Managing Projects (George Washington University) – USA.

Cloud Fusion Bootcamp at Oracle Education Center, Denver, Colorado.

WORK EXPERIENCE

Re-Insurance company Jan 2017 – Apr 2018

Sr. Oracle Business Consultant

Lead the Oracle team to deliver an integrated Oracle Financials (GL, AP, AR, Web-ADI and CM) (Version 12.2.4) with consideration of the current legacy systems.

Analyze the current client’s business process, requirements and workflow structure for the different business areas.

Provide a proposed Ledgers and Legal Entity Structure to accommodate the future expansion.

Support the development team by providing them with the EBS accounting workflow.

Work on the integration of the financial modules specially AR, AP, and CM.

Setup/Configure the Oracle EBS test instance based on the requirement gathering sessions conducted with the business SMEs.

Complete CRP1 and CRP2 with the client, going through all the business processes for the Oracle Financial modules based on the client requirements.

Design, development, and integrate of different inbound and outbound interfaces with Oracle EBS.

Verify that the appropriate business procedures are created.

Validate the competence and accuracy of the data conversion.

Ensure that solution architecture (software and programs) designed are in sync with the business needs.

Conduct sessions with the business users to define their needs an document them in the Business Requirement Document (BRD).

Analyze the business needs and develop solution on how to meet those needs in Oracle EBS.

Design, review and approve the UAT (User Acceptance Testing).

Prepare the test cases, test scenarios, and execute the tests to determine the system stability for taking the Go/No go decision in production.

Utilize SQL queries, PL/SQL procedures to look at the tables values from the back end.

AVIVA Canada Ltd. June 2016 – Oct 2016

Sr. Oracle Financial Consultant (Contract)

Integrate Guidewire Policy center and Billing center into Oracle Financials (Version 12.2.4)

Analyze the inbound and outbound legacy interfaces.

Prepare a strategy document on the interface integration from the legacy system to Oracle EBS.

Map the Guidewire fields to the appropriate column in Oracle EBS.

Complete the requirement gathering and document the required documents.

Collaborate with the stakeholders, project managers, project sponsors and business process owners to determine the project scope.

Prepare the UAT master work plan, and the detailed business scenarios that represent the user daily work.

Configure Oracle Financial EBS modules and complete the BR100 document for (GL, AP, AR, I-Procurement and Purchasing) R12.2.4.

Document detailed solution design to close the gap between the architecture and development team.

Work on the cross-functional solution designs with the other team members.

Aramark Canada Ltd. Dec 2015 – May 2016

Sr. Oracle Business Consultant (Contract)

Perform requirement gathering sessions with the client business SMEs.

Analyze and document the business process, requirements and work breakdown structure for the different department’s activities.

Upgrade Oracle Financial modules (GL, AP, AR and Web-ADI) from 12.1.3 to 12.2.4 based on the client business process for each area.

Complete the MD-50 functional design documents (interfaces/reports) for the different Oracle Financial modules.

Work on the integrated legacy systems inbound/outbound interfaces with Oracle EBS.

Review the MD-50s document with the technical teams.

Follow the change management protocol and apply changes on different Oracle environments.

Ensure the financial requirements are met and the deliverables are within the scope.

Coordinate with the business users the UAT testing and ensure that the tests are representing the different business cycles.

Use SCRUM project management methodology for managing EBS upgrade.

Conduct CRP sessions with the client business users, to demonstrate how their business requirements were translated to Oracle functionalities.

Amend the Oracle setup based on the CRPs discussions.

Update SharePoint with the different project documentations.

Manage and track the status of requirements throughout the project lifecycle; enforce and redefine, as necessary.

Collaborate with project managers, project sponsors and business process owners to determine project scope.

Communicate changes, enhancements and modifications – verbally or through written documentations so issues and resolutions are understood.

Work with Discoverer to facilitate he client requirements.

Use TOAD (PL/SQL) to look at the back end of the table’s values to investigate the different application issues.

Identify problem areas for the effected Oracle modules and recommend improvements concerning new application’s change.

Oracle Consulting (Canada) Jul 2014 – Nov 2015

Sr. Oracle Principal Consultant (Full Time-Perm)

AECL (Atomic Energy of Canada Limited) - R12 Upgrade, Las Vegas Valley Water – R12 Upgrade, Metrolinx – R12 Upgrade.

Communicate with project managers, application developers’ subject matter experts, end users and executives.

Champion and drives proposed system development or business process resolution.

Identify the current financial business process gaps, and provide best practice to the stakeholders to fulfill the business needs.

Perform the pre-upgrade and the post-upgrade steps for the Oracle Financial Bundle from 12.1.3 to (12.2.3) (GL, AP, AR, CM, FA, E-Bus Tax, SLA, Purchasing, WEB ADI, I-Procurement and i-Exp).

Prepare the impact analysis document and the test plan for the upgrade.

Conduct the CRP0, CRP1, CRP2, SIT and UAT sessions with the client business SMEs.

Complete the FIT/GAP Synopsis Report and review it with the client SMEs.

Test the delivered CEMLIS with the off-shore team, and recommend resolutions from the functional perspective.

Amend the BR100 document to include the R12 setup updates.

Complete CRP0 test scripts for the financial bundle, and review the CRP1 and CRP2 test scripts with the client SMEs.

Provide post implementation support after go-live.

Sun Life Financial (Canada) Apr 2013 – May 2014

Sr. Oracle Functional Consultant (Contract)

Post Implementation Support for Oracle applications Oracle E-Business Suite (11.5.10) (GL, AP, Purchasing, I-Proc, P2P, SOX, and application security), and the customized interfaces by providing day-to-day support and administrative functions to the end user.

Provide on-going feedback to Management with respect to enhancements to processes and systems that would result in improved efficiencies.

Analyze the user ticket and utilize Oracle support as assistance with problem resolution.

Conduct a detailed review of the business key financial process activities and recommend solutions (business process re-engineering).

Assess the impacts on proposed solution on the current functionality, and the related integrated Oracle modules.

Monitor the ticket resolution with the user until the final completion.

Raise maintenance/change requests as required to resolve the various Oracle user issues.

Apply the resolution on the User Acceptance Testing (UAT) instance to ensure that the application functions as per specifications.

Follow up with on applying the resolution on the Production environment.

Coordinate all required on-site and off-shore resources to ensure timely completion of deliverables.

Identify business processes/data requirements; conduct business analysis, construction, and testing.

Update system support and maintenance process documentation.

Proactive review and recommendation on work flow improvements in the system to achieve the required business processes.

Oracle Consulting (Canada) Jul 2011 – Feb 2013

Sr. Oracle Principal Consultant (Contract, Full time-Perm)

Best Buy - Calendar Change project, City of Laval in Montreal - R12 upgrade, Calgary Board of Education - R12 upgrade, Ministry of Labor in Quebec City (E-Business Tax R12).

Ensure projects align with the business and IT strategies at the project and business unit level.

Setup and implement E-Business Tax module in addition to the integration between E-Business tax and the other financial modules, including building different tax rules to satisfy the client requirements.

Configure, validate the application and document the BR100 (Setup and configuration) for E-Business Tax.

Understand industry trends and practices for the client business and for areas of domain expertise.

Complete and document the Business Process Redesign to align with the new Oracle version.

Contribute to the development of firms and industry standards and supported adoption of best practices.

Conduct interviews and complete analysis to gather user requirements for the Oracle calendar change via workshops, questionnaires, surveys, site visits, workflow storyboards, scenarios, and other methods.

Complete the MD-50 functional design document for the calendar change project.

Identify and establish scope and parameters of requirements analysis in order to define the impact of the Oracle calendar change for different Oracle modules GL, AP, AR, FA, CM, PO, P2P and PA (11.5.10).

Use TOAD to investigate the different table’s contents related to the different Oracle modules.

Support the client upgrades to R12 (12.1.3) of the financial bundle (GL, AP, AR, FA, SLA, P2P and CM).

Analyze the integration between the different R12 modules like (AP, AR, FA, CM and the GL.

Offer best solutions to new initiatives that are brought forward within the Oracle applications and the interfaces that interact with Oracle from other legacy systems.

Understanding the existing Business process across various departments and providing consultation / recommendations to the stakeholders for possible improvements and map it to the application.

Build and foster ongoing relationships with stakeholders and users.

Manage / Contribute to new or ongoing project initiatives by identifying risks and providing potential solutions to meet the needs of the organization, clients.

MTS - Allstream Apr 2009 – Jun 2011

Managing Consultant/Sr. Oracle Financial Consultant (Full Time-Perm)

Government of Newfoundland & Labrador project:

Lead Oracle AP & AR modules.

Conduct workshops with functional, technical and business stakeholders.

Complete detailed Business Requirements \ Business Narratives Documents.

Review Requirements \ Business Narratives Documents with Program leads and client stakeholders.

Evaluate the current financial system deficiencies and recommend options.

Document the current business process and conduct CRP sessions for discussion with the business on improvements.

Prepare the R12 Approach and Recommendations Document.

Contribute to the Design to Implementation Program plan with respect to efforts and resourcing.

Ensure issues, pain points, recommendations for improvement and future requirements of the assigned modules are communicated amongst the Program team.

Inventory all, reports, configurations and other customizations related to the current state of FMS that are provided to the Program team through documentation and/or workshops/meetings and identify customizations that can be eliminated.

Complete a high level review of current work flows and business processes and identify and prioritize areas for improvements.

Assess the impacts on current functionality, customizations, technical environments and architecture of FMS and related environments of implementing R12i.

Analyze re-implementation of Oracle Financial versus upgrade approaches to R12i and make a justified recommendation on which approach the Government should pursue.

ADP Canada Project:

Conduct interviews and product analysis to gather and compile user requirements to convey to development teams and follow through the software development life cycle.

Review and analyze business and functional specifications for test planning purposes, as well as create and revise test cases for product features and capabilities.

Develop and utilize standard templates to accurately and concisely write the BRD’s (Business Requirement Document).

Translate the user requirements into functional requirements in a clear manner that is comprehensible to developers.

Identify and establish scope and parameters of requirements analysis in order to define impact, outcome criteria, and measure-taking actions.

Research, review, and analyze the effectiveness and efficiency of existing requirements-gathering processes and develop strategies for enhancing or further leveraging these processes.

Manage and/or provide guidance to junior members of the IT Team and to business process owners.

Configure the Oracle GL, AR, AP and CM R12 (12.0.4) of Oracle E-Business Suite taking into consideration the integration with the IMMS (International Money Movement System) as an international solution for ADP business requirements.

Analyze and verify requirements for completeness, consistency, comprehensibility, feasibility, and conformity to standards.

Facilitate JAD sessions (Joint Application Development) with the business to get their feedback on the developed forms and functionality.

Saxon Energy Services Inc. Oct 2008 – Jan 2009

Sr. Oracle Functional Consultant (Contract)

Write and execute unit test cases for the upgrade from 11.5.10.2 to R12 (12.0.4) of Oracle E-Business Suite financial modules (GL, AP, AR, P2P and CM).

Define detailed business requirements for P2P cycle, including recommended implementation plan/business case.

Assist the project team with integration and user acceptance testing (UAT) as required to ensure that the application functions as per specifications.

Complete the pre-upgrade and post upgrade activities to upgrade from 11i to R12.

Collaborate with key stakeholders on business issues and create requirements for integrated Oracle application solutions.

Work with the financial team ensuring financial business processes are standardized and following practices which optimize the financial system environment.

Coordinate with members of other functional teams, development team and business teams in issue resolution.

Track requirements through downstream processes to ensure consistent, accurate translation of proposed solution through the SDLC or project phases.

Support and assist Finance with the month-end accounting close cycle.

Establish and deliver training and training materials including (UPK) User Productivity Kit for all financial system processes.

Utilize the application Architecture Strategy to ensure the applications and the integrations align with the growth strategy of the Organization.

Validate and document the BR100 (Setup and configuration) for (GL, AP, AR, and CM).

Perform in-depth analysis on production problems, identifies root causes, and recommends solutions to resolve application malfunctions and prevent recurrence.

Interact and collaborate with team members and other departments, as appropriate, in order to gain knowledge relevant to application support (such as understanding new functionalities, what parts of the system is being changed, and required environmental changes) to ensure successful implementation of the environment changes.

MDS Inc. - CBS (Common Business System) Jan 2008 – July 2008

Sr. Oracle Functional Consultant (Contract)

Understand end-to-end business processes and associated systems implications.

Support the Oracle applications Oracle E-Business Suite (11.5.10) (GL, AP, FA, CM, AR, Enterprise Asset Management (EAM), I-Expense, P2P, O2C, Purchasing, Procurement, Projects/Contracts, and OPM Quality) and the customized interfaces by providing day-to-day support and administrative functions.

Recommend solutions and resolve complex functional problems.

Utilize Oracle METALINK and Oracle support as assistance with problem resolution.

Raise, monitor and track Oracle service requests.

Provide functional guidance to the users on complex matters within general and specific areas of Oracle application.

Propose system solutions and provide recommendations that align with business objectives and corporate strategy.

Self-manage multiple tasks and handling priorities.

Use TOAD (PL/SQL) to investigate the different table’s contents.

Raise CCFs (Change Control Form) to apply the data fix/Oracle patches on the test instant and complete the required tests before pushing the fix to production.

CWB (Canadian Wheat Board) - Supply Chain Transformation project (Contract) Sr. Oracle Functional Consultant/ Sr. Business Analyst Jun 2007 – Nov 2007

Analyze the client’s business processes/requirements and translate these into appropriate configuration specifications.

Assist in developing Specifications of RICE (Reports, Interfaces, Conversion programs and enhancements).

Use the knowledge of best practices and functional expertise within the scope of the Oracle Applications to drive change in the organization through technology and business process redesign, maximizing the return on investment of the Oracle Applications implementation.

Validate, document business needs, and distinguish between needs and wants.

Identify gaps between business needs and standard Oracle functionality.

Design and document solution that fills gap, and provide detailed business requirements specification for developers as appropriate as well as facilitate JAD sessions (Joint Application Development).

Prepare level 3 and level 4 processes design documents for Oracle Inventory, and OPM quality using Tutor 11i.

Submit the process design documents for approval.

Define the data components associated with each level 4 processes.

Determine the master data dependencies across the different pods.

Confirm the master data ownership and manage the requirements on a consolidated basis.

Identify the appropriate change management and maintenance processes across multiple CWB business areas.

Define and review the business process objectives/changes in the SCT inventory, quality management and operations during the Conference Room Pilot (CRP).

Specify the process steps and design elements for inventory, OPM quality, quality management, P2P and purchasing within CRP.

Set up and configure the Inventory, OPM quality, quality management, and purchasing modules according to each department business process and requirements.

Demonstrate the inventory, OPM quality, quality management, and purchasing suggested solutions to the business leads during the CRP, document their feedback, and reconfigure the modules accordingly.

Document, and fully execute testing plans of Oracle Inventory, OPM quality, quality management and purchasing modules to assess the integrity and accuracy of business processes, module functionality setups and modifications.

Pfizer Canada Inc. – Pf@st project Oct 2006 – Apr 2007

Sr. Oracle Functional Consultant (Contract)

Prepare and document the test masterwork plan, test cases and test scripts for P2P (Procure to Pay), Oracle Payable and Purchasing to ensure that the application meets the organization standards and end user requirements (11.5.10).

Coordinate and execute the tests cases that relevant to the legacy system and different interfaces, document the test results and get the sign off for the passed tests.

Work closely with business users to ensure the products meet the expected level of quality defined by each business area.

Identify the failed tests; take the correction steps to re-execute them until we reach a passed status.

Develop and maintain the end user training documentation and deliver training /demos /presentations as required.

IBM Canada – GBS (Global Business Services) Sept 2003 – Sep 2006

Oracle Functional Consultant (Contract, Full Time-Perm)

IFIS project (Integrated Financial Information System)

The IFIS project is a large, multifunctional project. It is one of the largest implementations of Oracle Financial within the public sector (Ministry of Government Services) Ontario Government.

Provide professional and effective Oracle application consulting services including input and advice regarding Oracle Applications capabilities (Oracle E-Business Suite).

Submit, review and follow up with Oracle support for the service requests (TARs) to different modules (P2P, GL, AP, CM, and FA), purchasing, I-procurement and PA.

Assess and evaluate functional/application patches for impact on functionality process, training, customizations and assist with implementation of new patches.

Resolve the client problems in order to ensure that the project is completed within budget, to the highest quality, meeting or exceeding client expectations.

Prepare the test master work plan; making sure that the test cases objectives and the expected test results will fulfill the business cases for each ministry, and communicate the test results with the ministries.

Share experiences, transfer skills and learning, enable knowledge and sharing of resources.

Work with developers on understanding BRDs (Business Requirements Document) and generating FRDs (Functional Requirements Document).

Review, analyze and develop business requirements, including the preparation of the BRDs.

Configure setup for Oracle accounts payable module (Wave 4, 5) ministries and test the ministries AP files using APSSI – Account Payable Simple Standard Interface.

Provide production support to the IFIS ministries using the tool (Applix tickets).

Prepare and document the impact analysis document, masterwork plans and test scripts for the upgrade from 11.5.8 to 11.5.10.

Complete and lead the 11.5.10 upgrade test for P2P (Procure to Pay), AP, Encumbrance, PO, AP outbound interfaces and APSSI’s.

Softchoice (Retail Company) May 2003 – Sept 2003

Oracle Functional Consultant (Contract)

Implement the Oracle GL, AR and cash management module.

Fine-tune the integration of the CM and Oracle GL (11i).

Map the Oracle CM data with Triton system.

Set the descriptive and key flex fields according to the department’s needs.

Use Oracle’s AIM methodology for applications implementations.

Develop a strong working relationship with the operations management and project management teams and provide IT solutions to meet the expecting business growth and operational responsibilities.

PROFESSIONAL DEVELOPMENT

Oracle Partner Advanced Training and Pre-Sales Presentation Skills Workshop.

Managing Projects (The George Washington University – USA).

R9 Fusion Bootcamp at Oracle education Centre, Denver, Colorado.

R12.x Oracle Purchasing Fundamentals (Ed 1 LVC).

OPM Oracle Process Manufacturing.

Oracle Financial Bundle - GL/AP/CM and Consolidation release11 and 11i & Defining Flex Fields.

Introduction to Oracle SQL& PL/SQL, Oracle Database Administration

American Chamber of commerce Time Management & Managerial Skills

IBM Management Center Project Management & Intermediate Management Skills.

Facilitation skills for meetings and consultations.

Group Problem Solving and Decision Making.

Communication Skills, Leading without Authority.

Difficult People in the Workplace Environment.

Leading Teams Launching a Successful Team.

Leading Teams Managing Virtual Teams.

UMX (User Management)

Effective Relationships with Customers.

OUM (Oracle Unified Method) Certifications

Oracle Unified Method Level 1 Overview and Awareness.

Level 2- Use case overview

Level 2- Estimating Overview

OUM Level 2 Manage Focus Area Overview

Oracle OUM L2-Envision Overview

Level 2 Implement Focus Area Overview

Areas of strength

Results-focused, tenacious, multi-task problem solver, capable of complex thinking and analysis.

Career history of consistent advancement based on achievements, troubleshooting, dedication.

Vendor management, strong leadership, team building, multitask abilities and teamwork.

Strong analytical skills with ability to pay close attention to accuracy and details.

Communicates well with all levels of management, vendors and team members.

Ability to work with limited to minimal supervision.

Excellent oral and written communication skills.

REFERENCES Available upon request

Contact this candidate