*Hi,*
*Please reply to ,* * [email protected] <[email protected]>* *Position: Developer/Programmer* *Location: State of Minnesota, St. Paul* *Duration: 6 Months+* Project Title: Budgeting By Products and Services (BBPS) Phase 2 Category: Developer/Programmer Minnesota IT Services (MNIT) in partnership with the Minnesota Department of Transportation (MnDOT) is seeking two (2) Oracle Forms developers to support Salary Projections and one (1) Microsoft Access developer to support the Base Budget Tracking. Not all positions will necessarily be filled by the same vendor. Business Need MnDOT has been directed by the Minnesota Legislature to report on its products and services annually. We are required to report the annual budget for products and services for each office and district, with a comparison to the actual spending. Beyond the legislative requirement, budgeting by products and services will also enable MnDOT: ? Demonstrate effective and efficient use of resources ? Make financially effective prioritizations and decisions MnDOT and MNIT@ DOT developed and implemented a Budgeting by Product and Services (BBPS) application to supplement the functionality in the State’s Oracle PeopleSoft system (SWIFT). The first phase of the project was implemented on June 30, 2015. The second phase of the project requires moving more functionality into SWIFT and adding additional functionality into the BBPS application. The work is targeted for completion for the start of FY18, which begins on July 1, 2017. MNIT @ MnDOT will perform most of the development work, but we have a need for additional development staff for the following two functional areas: 1) Salary Projections which uses data from the statewide payroll system (Oracle PeopleSoft). Develop Oracle forms that will allow users to review, analyze, and update the data to provide accurate salary projections by products and services. The business needs two (2) expert Oracle Forms developers to supplement the MNIT @ MnDOT current Oracle Form developers. 2) Base Budget Tracking database will track the base budget by office/district. The business will store this information in an Oracle table by office/district and the products and services code. The business intends to extract and analyze all SWIFT budget transactions to determine the type of adjustment as well as the appropriate product and service. The data will be stored in the MnDOT warehouse, so that reports can be generated for the current base budget by office/district and product and service. The business needs one (1) Microsoft Access developer with experience using Access as a front end to an Oracle database. Project stakeholders are the MnDOT management groups and financial professionals across the agency. RFO0157 Final: 10/25/16 Page 2 of 9 Project Deliverables The selected vendor(s) will provide key personnel who will supplement MNIT @ MnDOT’s current staff to assist in the upgrade and modify multiple systems in order to meet the project schedule. Design, develop, code, test, debug, and implement modifications using the business rules and specifications to create new Oracle Forms for Salary Projections according to the approved design and technical models incorporating the business rules and data requirements. Design, develop, code, test, debug, and implement modifications using the business rules and specifications to create new MS Access for Base Budget Tracking according to the approved design and technical models incorporating the business rules and data requirements. The developers will provide sufficient documentation so that a user manual can be generated by MnDOT staff for training users on the modifications. Provide informal training and knowledge transfer to key MNIT @ MnDOT staff so that may support the system and preform any additional modifications or enhancements after the contract is completed. Project Milestones and Schedule ? Anticipated project engagement start date: November, 2016 ? Anticipated project engagement end date: June 30, 2017 Project Requirements The selected vendor(s) will: 1) Follow all technical specifications and processes identified in this Request for Offers (RFO). 2) Provide informal training and knowledge transfer to key MNIT @ MnDOT staff, including but not limited to the following: ? The selected vendor(s) will be expected to have the necessary communication skills so that the Accounting System staff will be able to actively participate in the development of the system and to facilitate the hand-over process upon completion of the development. ? The selected vendor(s) will provide sufficient documentation so that a user manual could be generated for training users on the development. 3) Adhere to MNIT @ MnDOT’s testing and acceptance criteria. 4) Report all work plans and completed requirements to the project manager. 5) Perform unit and integration testing. 6) Update User and System Documentation for the applications developed. 7) Adhere to MNIT @ MnDOT’s Project Documentation. 8) Weekly time reporting is required. Responsibilities Expected of the Selected Vendor(s) The selected vendor(s) will provide up to two (2) experienced Oracle Forms developers for the period of November, 2016 through June 30, 2017 that meet the mandatory qualifications listed below. Each developer is needed for approximately 1,496 hours. The selected vendor will provide one (1) experienced MS Access developer for the period of November, 2016 through June 30, 2017 that meets the mandatory qualifications listed below. This developer is needed for approximately 1,496 hours. Total developer/programmer hours of 4,488. All work will be performed onsite at the Transportation Central Office Building alongside the MNIT@ MnDOT staff. Work will be performed according to the State’s schedule during normal State business hours. RFO0157 Final: 10/25/16 Page 3 of 9 *Mandatory Qualifications* *To be initially scored as pass/fail. Thereafter, proposed resource(s) that meet the Mandatory* *Qualifications will be scored in part on the extent to which the resource exceeds these mandatory* *minimums. See RFO Evaluation Process, below.* *Vendor must propose hourly rates at or below the vendor’s Max Hourly Rate for the category.* *Salary Projections (2 Resources needed)* *? 2 years of experience using Microsoft Word 2013.* *? 2 years of experience using Microsoft Excel 2013.* *? 2 years of experience using Oracle Client Service and Linux 6 (and Linux 7) Environment* *Application Server Deployment.* *? 2 years of experience working with Oracle Forms (11.1.1.3) on (Red Hat) Linux 6 Servicer* *(Oracle Forms (12.1.x) on (Red Hat) Linus 7 Server).* *? 2 years of experience using Oracle Form Builder version 11.1.1.3 (12.1x).* *? 3 years of experience writing PL SQL and using Toad – Oracle Database 11.2.0.4* *(12.2.1.0.0).* *Base Budget Tracking (1 Resource needed)* *? 2 years of experience using Microsoft Access 2013.* *? 2 years of experience with Visual Basic for Applications (VBA).* *? 2 years of experience writing Access Form Front End on Oracle Database 11.2.04.* *(12.2.1.0.)* *? 2 years of experience writing Oracle PL SQL.* *Desired Skills* *Proposed resources that meet the Mandatory Qualifications will be evaluated on the following Desired* *Skill. Responder should demonstrate in its proposal the length, depth, and applicability of the proposed* *resource’s prior experience in the desired skill below.* *? Experience working with enterprise financial systems, such as Oracle PeopleSoft or SAP.* *? Experience working with the State’s Oracle PeopleSoft system (SWIFT).* *Vineet Mishra* *Technical Recruiter* 1 Point System LLC Unit 103, 206 N College St, Pineville, North Carolina, 28134 *P*: *803-317-2541* *E* : [email protected] -- You received this message because you are subscribed to the Google Groups "Exact Match" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/exact-match. For more options, visit https://groups.google.com/d/optout.
