(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

TheIntegratedFinancialInformationSystem(IFIS)istheOntarioGovernment’sERPapplicationusedby everyministryforrecordingfinancialtransactions,A/P,A/R,loadingbudgets,managingcase,BIreporting, etc.ThemaincomponentofIFISisOracleE-BusinessSuiteR11.TheIFIStechnologyismanagedbythe EnterpriseServicesClusterwithintheMinistryofGovernmentServices(MGS).

InadditiontoOracle’se-BusinessSuite,IFISalsoincorporatestheOracle’sFinancialAnalyzer(OFA)tool. OFAprovidestheabilityforOPSfinancialanalyststoreportontransactionaldatatosupportmanagerial decisions.Inadditiontosupportingfinancialanalysisandreporting,OFAisusedinthefollowingcritical enterprisefinancialmanagementprocesses:

• •PreparationoftheOntarioBudgetandtheFallEconomicOutlookandFiscalReview
• •MonthlyforecastingofMinistries’cashflowrequirements
• •PreparationofthePublicAccounts

CLIENT’S REQUIREMENTS

SCOPE OF SERVICES AND DELIVERABLES - TheServicesandDeliverablestobeprovidedbythe Vendorwillincludethefollowing:

Development Team 1 – GL (General Ledger)

Thedevelopmentteam willprovidecustomizationandretrofittingofbusinessfunctiontotheupgradedIFIS environment.ThedevelopersareexpectedtopossesscurrentskillsinOracleE-BusinessSuite developmenttoolsas wellasaverystrongfunctionalunderstandingoftheGeneralLedger,Cash ManagementandFixedAssetsmodulesofOracleE-BusinessSuite.

TheVendor’sPersonnelwillalsoberequiredto:

• •Completeworkandachievemilestoneswithintheassigneddeadlines;

• •NotifytheCluster/MinistryprojectManagerin writingofanyissuesorothermaterialconcerns relatedtotheassignmentdeliverables,assoonasthehe/shebecomesawareofthem;
• •SubmitdeliverablesfortheCluster/Ministryapprovalastheyarecompleted;

• •ComplywiththeOntarioGovernmentandtheCluster/Ministrysecurityproceduresandpractices;

• •ComplywiththeOntarioGovernmentandtheCluster/Ministryarchitecture/technologystandards andbestpractices;
• •ComplywiththeOntarioGovernmentandtheCluster/MinistryConflictofInterestandConfidentiality Guidelines;
• •ProvideknowledgeandskilltransfertoadesignatedCluster/Ministrystaff;and

• •ComplywiththeOntarioGovernmentI&ITDirective,OperationalPolicyontheI&ITProject GatewayProcess,andotherapplicableGuidelines,StandardsandProcedure.

SKILL SET REQUIREMENTS:

Eachproponentmayproposeuptotwo(2)resourcesperR12E-BusinessSuiteModulesasshowninthe tablebelow.ProponentsmustproposeresourcesthathaveexperiencewiththeOracleE-BusinessSuite GeneralLedger,CashManagementandFixedAssetsmodules.Inaddition,proponentsmayalsopropose consultants whohaveexperiencewiththeotherOracleE-BusinessSuiteapplicationmoduleslistedinthe tablebelow.Amaximumofsix(6)consultantsintotalmaybeproposed.

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

• •StrongunderstandingofkeyfunctionalityofOracleE-BusinessGeneralLedger,CashManagement andFixedAssets.
• ••Atleast5 yearsofOracleERPimplementation,developmentandsupportexperience
• •Knowledgeableinthecustomizing,enhancing,applicationsandbusinessprocesses,integrationwith OracleEBSandothersourcesystems
• •Experiencewithatleast2OracleR12upgradeimplementationprojectsintheroleofdeveloperor developmentlead
• •ExperiencedwithcustomizationwithOracleEBSR12Applications
• •Experienceasdeveloperordevelopmentleadina24x7customizedandintegratedOracleEBSR12 ITteam
• •ExperiencesupportingcustomizedOracleEBSR12inaproductionenvironment,withexternaland internalintegrations
• •Workingfunctionalknowledgeandhands-onexperienceoftheinter-relationshipsbetweenOracleE- BusinesssuiteofApplicationsand3rdpartyApplications
• •Knowledgeableindevelopmentbasics,security,configurationandmaintenanceofcustomizations
• •Experiencewithmostorallofthefollowingtechnologies:
• oOracleForms,
• oOracleReports,
• oOracleSQL,PL/SQL(packages,procedures,functions,triggers),
• oOracleApplicationsAlertsandOracleE-BusinessAPIs,
• oOracleSQL*Loader,SQL,SQL*Plus,
• oOracleWorkflowBuilder,
• oUnixScripting
• •Hands-ontechnicalknowledgeandexperiencewithreports,extensions,customizations,interfaces, andconversions
• •KnowledgeofOracleAIMMethodology,includingBusinessRequirementsdocumentation,Solution Designdocumentation,andtestingdocumentation
• •Strongverbalandwrittencommunicationskills
• •Strongteamplayer,abletocontributestoateameffortbyaccomplishingrelatedresultsasneeded, andsharingtechnologyknowledgewiththegroupandothersintheteam
• •Workinacross-functionalenvironmenttounderstandthedataandinformationneedsofusers, developingsolutionsthatintegrateinformationtechnologyandbusinessprocesschangestosupport strategicbusinessrequirements
• •Proactivelytakesresponsibilityforproblemswhentheyareidentified
• •Provideuserandproductionsupport,reactquicklyandresponsivelytousersandproductionissues.
• •Provenexperienceinworkingonlarge-scalecomplexprojectsforscalabilityandhighavailability,
• •Abilitytofacilitateandconducteffectiveanalysisandresearch,includingneeds assessment/requirementsanalysis,quantitativeanalysisandqualitativeanalysis,
• •Knowledgeofpublicsectorstructureandpolicies,includingrelevantpublicpolicy,
• •Objectives,principlesandconstraints,organizationalculture/unionisedpublicsectorenvironmentand applicationofrelevantlegislationandpolicies.(e.g.ConflictofInterest,FIPPA),
• •KnowledgeandexperiencewiththeOPSUnifiedI&ITProjectManagementMethodology(UPM) includinggatesandcheckpoints.

ProposedconsultantsmustbeabletodemonstrateknowledgeofandexperienceinOracleE-Business Suitedevelopmentskills.Theknowledgeandexperiencemusthavebeengainedthrough workonsimilar projectsinsizeandscopetothisproject.Thedevelopersproposedmusthavesimilarexperienceonprior R12OracleE-Businessimplementationsandbeabletosupportbothfunctionalandtechnicalteam members.