Www.emarketplace.state.pa.us



APPENDIX LORACLE ERP POSITION SUPPORT MATRIXCOMPLETE THE ACTUAL YEARS EXPERIENCE COLUMN AND INCLUDE WITH THE TECHNICAL SUBMITTALTable A – Positions for Lot 1 (minimum one of each position)Experience/SkillPreferredPositionA.1Senior EBS Oracle Database Administration with Application Technology SupportA.2Senior EBS Oracle Applications Business/Systems Analyst/Functional ExpertA.3Senior Oracle Cross-functional Technology Applications DeveloperA.4Senior Web Services/Oracle ADF/Java Applications DeveloperTable A.1 – Senior EBS Oracle Database Administration with Application Technology Support DutiesExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of Proposed Offeror Staff – To be completed by OfferorOracle Database Administration (11g) of Large scale (> 500 GB) database management with multi-hundred million row tablesStart, stop, back up databasesReorganize dataPurge and/or archive outdated dataInstall, update, delete stored procedures, tables, indexes, etc.Configure, monitor and manage data replication“Clone” applications, databases and environments in support of projects and production support issuesCoordinate batch job schedule, module or parameter changes with the PLCB’s Operations Staff. Maintain the patch inventory and patch logs4Oracle eBusiness Suite AdministrationOracle application technology administration and support. 4Oracle Hyperion Oracle application technology administration and support 1Oracle Forms Server to include Oracle Application Framework (OAF) and Oracle Application Development Framework (ADF)AdministrationOracle application technology administration and support. 2Oracle (or BEA) Weblogic AdministrationOracle application technology administration and support.1Oracle SOA Suite (BPEL) AdministrationOracle application technology administration and support. 2Linux/Unix use and shell scriptingFundamental Linux/Unix skillset2Table A.2– Senior EBS Oracle Applications Business/Systems Analyst/Functional ExpertExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of Proposed Offeror Staff – To be completed by OfferoreBusiness Suite (EBS). Including but not limited to: General Ledger, Fixed Assets, I-Supplier Portal, Accounts Payable, Accounts Receivable, Cash Management, Project Costing, Property Manager, Purchasing and Order Management business/systems analysisWork with PLCB production support resources to analyze the root cause of the problemDevelop new functional specifications (MD50’s/MD60’s) for new projects, enhancements or production support updates.Make changes in application setups (configuration)Make changes in application security setupsDesign and support the development and test of changes to existing custom programs (RICEW objects) required to resolve production support or in support of projects or enhancements Perform programmatic corrections to production dataWork with Oracle Support to resolve application-related issuesTest Oracle-provided patchesProvide Knowledge Transfer of solutions design and Oracle productsParticipate in capacity planningParticipate in disaster recovery exercises5Hyperion business/systems analysisOracle application technology administration and support.2Oracle Application Framework business/systems analysisOracle application technology administration and support.3Ability to write SQL Queries to query dataFundamental SQL skillset4Table A.3 – Senior Oracle Cross-Functional Technology Applications DeveloperExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of Proposed Offeror Staff – To be completed by OfferorOracle’s BI Publisher (10g and 11g) development Design and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects2Oracle Forms developmentDesign and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects2BPEL or similar enterprise service bus products such as WebMethods or MQ Series developmentDesign and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects1Crystal Reports or similar tools Design and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects2PL/SQL and SQL developmentDesign and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects2Java, ProC, .NetDesign and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects1Oracle Database AdministrationFundamental database administration skillset1Unix / Linux Shell or equivalent Scripting ExperienceFundamental Linux/Unix skillset1Table A.4– Senior Web Services/Oracle ADF/Java Applications DeveloperExperience/Skills PreferredTasks to be performedYears Experience DesiredActual Years Experience of Proposed Offeror Staff – To be completed by OfferorOracle ADF – Development with production application deployments utilizing ADF as the primary framework.Design and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects2Java – Experience developing large scale (multi-tier or high volume) applications in JavaDesign and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects 3Table B – Positions for Lot 2 (minimum one of each position)Experience/SkillPreferredPositionB.1Senior Retail Oracle Database Administration with Application Technology Support B.2Junior Cross-functional Oracle Application Technology Support and Database AdministrationB.3Senior Retail Oracle Applications Business/Systems Analyst/Functional ExpertB.4Junior RMS Oracle Applications Business/Systems Analyst/Functional ExpertB.5Senior Oracle Cross-Functional Technology Applications DeveloperB.6Junior Oracle Cross-Functional Technology Applications DeveloperTable B.1– Senior Retail Oracle Database Administration with Application Technology Support DutiesExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of ProposedOfferor Staff – To be completed by OfferorOracle Database Administration (11g)Large scale (> 1 TB) database management with multi-hundred million row tablesStart, stop, back up databasesReorganize dataPurge and/or archive outdated dataInstall, update, delete stored procedures, tables, indexes, etc.Configure, monitor and manage data replication“Clone” applications, databases and environments in support of projects and production support issuesCoordinate batch job schedule, module or parameter changes with the PLCB’s Operations Staff. Maintain the patch inventory and patch logs4Oracle Forms Server to include Oracle Application Development Framework (ADF) AdministrationOracle application technology administration and support.2Oracle MerchandizingOperations Management (RMS, Allocations, REIM, RPM, ReSA) AdministrationOracle application technology administration and support.2Oracle SIM AdministrationOracle application technology administration and support.2Oracle RIB AdministrationOracle application technology administration and support.2 Oracle RDW AdministrationOracle application technology administration and support.2Oracle RDF AdministrationOracle application technology administration and support.1Oracle (or BEA) Weblogic AdministrationOracle application technology administration and support.1Oracle SOA Suite (BPEL) AdministrationOracle application technology administration and support.2AppWorx AdministrationFundamental AppWorx skillset2Table B.2 – Junior Cross-functional Oracle Application Technology Support and Database AdministrationExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of Proposed Offeror Staff – To be completed by OfferorOracle Database Administration (11g) Large scale (> 1 TB) database management with multi-hundred million row tablesStart, stop, back up databasesReorganize dataPurge and/or archive outdated dataInstall, update, delete stored procedures, tables, indexes, etc.Configure, monitor and manage data replication“Clone” applications, databases and environments in support of projects and production support issuesCoordinate batch job schedule, module or parameter changes with the PLCB’s Operations Staff. Maintain the patch inventory and patch logs2Oracle eBusiness Suite Administration Oracle application technology administration and support.1Oracle MerchandizingOperations Management (RMS, Allocations, REIM, RPM, ReSA) AdministrationOracle application technology administration and support.1Oracle SIM AdministrationOracle application technology administration and support.1Oracle RDW AdministrationOracle application technology administration and support.1Oracle Forms Server including Oracle Application Development Framework (ADF) AdministrationOracle application technology administration and support.1Oracle (or BEA) Weblogic AdministrationOracle application technology administration and support.1Oracle SOA Suite (BPEL) AdministrationOracle application technology administration and support.1Oracle Retail Central Office, Back Office AdministrationOracle application technology administration and support.1Linux/Unix use and shell scriptingFundamental Linux/Unix skillset2 Table B.3 – Senior Retail Oracle Applications Business/Systems Analyst/Functional ExpertExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of Proposed Offeror Staff – To be completed by OfferorOracle MerchandizingOperations Management (RMS,Allocations, REIM, RPM, ReSA) business/systems analysisAnalyze and help resolve “Level II” and “Level III” production support issues related to the applicationsWork with PLCB production support resources to analyze the root cause of the problemDevelop new functional specifications (MD50’s/MD60’s) for new projects, enhancements or production support updates.Make changes in application setups (configuration)Make changes in application security setupsDesign and support the development and test of changes to existing custom programs (RICEW objects) required to resolve production support or in support of projects or enhancements Perform programmatic corrections to production dataWork with Oracle Support to resolve application-related issuesTest Oracle-provided patchesProvide Knowledge Transfer of solutions design and Oracle productsParticipate in capacity planningParticipate in disaster recovery exercises5Oracle SIM business/systems analysisOracle application technology administration and support.5Oracle RDF business/systems analysisOracle application technology administration and support.3Oracle BI Publisher business/systems analysisOracle application technology administration and support.2Ability to write SQL Queries to query dataFundamental SQL skillset4Table B.4 – Junior RMS Oracle Applications Business/Systems Analyst/Functional ExpertExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of Proposed Offeror Staff – To be completed by OfferorOracle MerchandizingOperations Management (RMS,Allocations, REIM, RPM, ReSA) business/systems analysisWork with PLCB production support resources to analyze the root cause of the problemDevelop new functional specifications (MD50’s/MD60’s) for new projects, enhancements or production support updates.Make changes in application setups (configuration)Make changes in application security setupsDesign and support the development and test of changes to existing custom programs (RICEW objects) required to resolve production support or in support of projects or enhancements Perform programmatic corrections to production dataWork with Oracle Support to resolve application-related issuesTest Oracle-provided patchesProvide Knowledge Transfer of solutions design and Oracle productsParticipate in capacity planningParticipate in disaster recovery exercises3Oracle SIM business/systems analysisOracle application technology administration and support.2Oracle RDF business/systems analysisOracle application technology administration and support.2Ability to write SQL Queries to query dataFundamental SQL skillset2Table B.5– Senior Oracle Cross-Functional Technology Applications DeveloperExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of Proposed Vendor Staff – To be completed by OfferorOracle MerchandizingOperations Management (RMS,Allocations, REIM, RPM, ReSA, etc.) and SIM development Design and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects2Oracle Forms developmentDesign and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects2RIB or similar enterprise service bus products such as WebMethods or MQ Series developmentDesign and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects1Crystal Reports or similar tools Design and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects2PL/SQL and SQL developmentDesign and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects2Java, ProC, .NetDesign and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects1Oracle Database AdministrationFundamental database administration skillset1Unix / Linux Shell or equivalent Scripting ExperienceFundamental Linux/Unix skillset1Table B.6– Junior Oracle Cross-Functional Technology Applications DeveloperExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of Proposed Offeor Staff – To be completed by OfferorOracle MerchandizingOperations Management (RMS,Allocations, REIM, RPM, ReSA, etc.) and SIM development Design and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects1Oracle Forms developmentDesign and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects1RIB or similar enterprise service bus products such as WebMethods or MQ Series developmentDesign and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects1Crystal Reports or similar tools Design and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects1PL/SQL and SQL developmentDesign and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects1Java, ProC, .NetDesign and/or redesign, program, unit test and support migration of changes to new or existing RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) objects1Oracle Database AdministrationFundamental database administration skillset1Unix / Linux Shell or equivalent Scripting ExperienceFundamental Linux/Unix skillset1Table C – Positions for Lot 3 (minimum one of each position)Experience/SkillPreferredPositionC.1Senior ORBO/ORCO Retail Oracle Database AdministrationC.2ORPOS Programmer/AnalystC.3ORBO/ORCO Programmer/AnalystC.4Payment Business/Systems AnalystC.5POS Business/Systems AdministratorTable C.1– Senior ORBO/ORCO Retail Oracle Database AdministrationExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of Proposed Offeror Staff – To be completed by OfferorOracle Database Administration (11g) Large scale (> 1 TB) database management with multi-hundred million row tablesStart, stop, back up databasesReorganize dataPurge and/or archive outdated dataInstall, update, delete stored procedures, tables, indexes, etc.Configure, monitor and manage data replication“Clone” applications, databases and environments in support of projects and production support issuesCoordinate batch job schedule, module or parameter changes with the PLCB’s Operations Staff. Maintain the patch inventory and patch logs4Oracle Retail Central Office Administration and Oracle Retail Back Office AdministrationOracle application technology administration and support.1Oracle (or BEA) Weblogic AdministrationOracle application technology administration and support.1Linux/Unix use and shell scriptingFundamental Linux/Unix skillset2 Table C.2 – ORPOS Programmer/AnalystExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of Proposed Offeror Staff – To be completed by OfferorOracle POS, ORCO and ORBO Customization DevelopmentDesign and/or redesign, program, unit test and support migration of changes to new or existing POS objects3Java DevelopmentDesign and/or redesign, program, unit test and support migration of changes to new or existing POS objects 3Oracle Advaned Queues/Weblogic DevelopmentDesign and/or redesign, program, unit test and support migration of changes to new or existing POS objects 2Oracle Database DevelopmentAssist with monitoring store operations, including extracts, application, databases, reboots, register freezes, network issues and performance, store conduits, end of day status, payment switch operation1SUSE Linux AdministrationAssist with trouble shooting, diagnostic, and service issues with the system hardware and software1Basic network and register hardware trouble shootingAssist with trouble shooting, diagnostic, and service issues with the system hardware and software1PL/SQL DevelopmentFundamental SQL skillset3Linux/Unix shell scriptingFundamental Linux/Unix skillset3Table C.3 – ORBO/ORCO Programmer/AnalystExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of Proposed Offeror Staff – To be completed by OfferorJava DevelopmentDesign and/or redesign, program, unit test and support migration of changes to new or existing POS objects3Oracle ORBO and ORCO Customization DevelopmentDesign and/or redesign, program, unit test and support migration of changes to new or existing POS objects3Oracle Advanced Queues/WebLogic DevelopmentDesign and/or redesign, program, unit test and support migration of changes to new or existing POS objects2Oracle Database DevelopmentAssist with monitoring store operations, including extracts, application, databases, reboots, register freezes, network issues and performance, store conduits, end of day status, payment switch operation1SUSE Linux AdministrationAssist with trouble shooting, diagnostic, and service issues with the system hardware and software1Basic network trouble shootingAssist with trouble shooting, diagnostic, and service issues with the system hardware and software1PL/SQL DevelopmentFundamental SQL skillset3Oracle Retail accelerator integration and trouble shootingAssist with trouble shooting, diagnostic, and service issues with the system hardware and software1Unix / Linux Shell ScriptingFundamental Linux/Unix skillset3Table C.4– Payment Business/Systems AnalystExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of Proposed Vendor Staff – To be completed by OfferorORPOS, ORBO and ORCO, RMS and POS Pricing Business/Systems AnalysisWork with applications team and project managers to prioritize tasks and projectsProvide work effort estimates and task plan for new programs or program changesAssist with data analysis required to resolve production support issues or to support new projects or enhancementsAssist with providing scripts for data fixes3Payment System IntegrationAssist with monitoring performance of the payment card system.Assist with trouble shooting, diagnostic, and service issues with the system hardware and software2ReSA Integration with POSAssist with repairing any missing transactions or financial discrepancies that occur within the POS environment. Assist with the reconciliation of invoice issues, SLO issues, Gift Card Issues, Charge Back issues.2Table C.5 – POS Business/Systems AdministratorExperience/Skills PreferredTasks to be PerformedYears Experience DesiredActual Years Experience of Proposed Offeror Staff – To be completed by OfferorORPOS, ORBO and ORCO, RMS and POS Pricing Business/Systems AnalysisWork with applications team and project managers to prioritize tasks and projectsProvide work effort estimates and task plan for new programs or program changesAssist with data analysis required to resolve production support issues or to support new projects or enhancementsAssist with providing scripts for data fixes3Troubleshoot POS HardwareAssist with trouble shooting, diagnostic, and service issues with the system hardware and software2Linux SUSE AdministrationAssist with trouble shooting, diagnostic, and service issues with the system hardware and software2VeriFone or similar pinpad configuration/administrationAssist with trouble shooting, diagnostic, and service issues with the system hardware and software1 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download