(Government of Ontario) Programmer/ Developer --– Oracle Financials ERP Applications Environment

SCT resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to our offerings. We learn continuously, both on the job and through formal training programs.

Company: SystemCanada | www.systemcanada.com

World wide office:  Canada - USA - Australia - UK - South Africa - New Zealand - Ireland - Japan

Job Description

Duration: 1 Year PLUS long contract

BACKGROUND INFORMATION

The Integrated Financial Information System (IFIS) is the Ontario Government’s ERP application used by every ministry for recording financial transactions, A/P, A/R, loading budgets, managing case, BI reporting, etc. The main component of IFIS is Oracle E-Business Suite R11. The IFIS technology is managed by the Enterprise Services Cluster within the Ministry of Government Services (MGS).

In addition to Oracle’s e-Business Suite, IFIS also incorporates the Oracle’s Financial Analyzer (OFA) tool. OFA provides the ability for OPS financial analysts to report on transactional data to support managerial decisions. In addition to supporting financial analysis and reporting, OFA is used in the following critical enterprise financial management processes:

• • Preparation of the Ontario Budget and the Fall Economic Outlook and Fiscal Review
• • Monthly forecasting of Ministries’ cash flow requirements
• • Preparation of the Public Accounts

CLIENT’S REQUIREMENTS

SCOPE OF SERVICES AND DELIVERABLES - The Services and Deliverables to be provided by the Vendor will include the following:

Development Team 1 – GL (General Ledger)

The development team will provide customization and retrofitting of business function to the upgraded IFIS environment. The developers are expected to possess current skills in Oracle E-Business Suite development tools as well as a very strong functional understanding of the General Ledger, Cash Management and Fixed Assets modules of Oracle E-Business Suite.

The Vendor’s Personnel will also be required to:

• • Complete work and achieve milestones within the assigned deadlines;

• • Notify the Cluster/Ministry project Manager in writing of any issues or other material concerns related to the assignment deliverables, as soon as the he/she becomes aware of them;
• • Submit deliverables for the Cluster/Ministry approval as they are completed;

• • Comply with the Ontario Government and the Cluster/Ministry security procedures and practices;

• • Comply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practices;
• • Comply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality Guidelines;
• • Provide knowledge and skill transfer to a designated Cluster/Ministry staff; and

• • Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedure.

SKILL SET REQUIREMENTS:

Each proponent may propose up to two (2) resources per R12 E-Business Suite Modules as shown in the table below. Proponents must propose resources that have experience with the Oracle E-Business Suite General Ledger, Cash Management and Fixed Assets modules. In addition, proponents may also propose consultants who have experience with the other Oracle E-Business Suite application modules listed in the table below. A maximum of six (6) consultants in total may be proposed.

The following points describe skills and experiences which would make a consultant suitable for this position:

• • Strong understanding of key functionality of Oracle E-Business General Ledger, Cash Management and Fixed Assets.
• • • At least 5 years of Oracle ERP implementation, development and support experience
• • Knowledgeable in the customizing, enhancing, applications and business processes, integration with Oracle EBS and other source systems
• • Experience with at least 2 Oracle R12 upgrade implementation projects in the role of developer or development lead
• • Experienced with customization with Oracle EBS R12 Applications
• • Experience as developer or development lead in a 24x7 customized and integrated Oracle EBS R12 IT team
• • Experience supporting customized Oracle EBS R12in a production environment, with external and internal integrations
• • Working functional knowledge and hands-on experience of the inter-relationships between Oracle E- Business suite of Applications and 3rd party Applications
• • Knowledgeable in development basics, security, configuration and maintenance of customizations
• • Experience with most or all of the following technologies:

• o Oracle Forms,
• o Oracle Reports,
• o Oracle SQL, PL/SQL (packages, procedures, functions, triggers),
• o Oracle Applications Alerts and Oracle E-Business APIs,
• o Oracle SQL*Loader, SQL, SQL*Plus,
• o Oracle Workflow Builder,
• o Unix Scripting
• • Hands-on technical knowledge and experience with reports, extensions, customizations, interfaces, and conversions
• • Knowledge of Oracle AIM Methodology, including Business Requirements documentation, Solution Design documentation, and testing documentation
• • Strong verbal and written communication skills
• • Strong team player, able to contributes to a team effort by accomplishing related results as needed, and sharing technology knowledge with the group and others in the team
• • Work in a cross-functional environment to understand the data and information needs of users, developing solutions that integrate information technology and business process changes to support strategic business requirements
• • Proactively takes responsibility for problems when they are identified
• • Provide user and production support, react quickly and responsively to users and production issues.
• • Proven experience in working on large-scale complex projects for scalability and high availability,
• • Ability to facilitate and conduct effective analysis and research, including needs assessment/requirements analysis, quantitative analysis and qualitative analysis,
• • Knowledge of public sector structure and policies, including relevant public policy,
• • Objectives, principles and constraints, organizational culture/unionised public sector environment and application of relevant legislation and policies. (e.g. Conflict of Interest, FIPPA),
• • Knowledge and experience with the OPS Unified I&IT Project Management Methodology (UPM) including gates and checkpoints.

Proposed consultants must be able to demonstrate knowledge of and experience in Oracle E-Business Suite development skills. The knowledge and experience must have been gained through work on similar projects in size and scope to this project. The developers proposed must have similar experience on prior R12 Oracle E-Business implementations and be able to support both functional and technical team members.