Short Description:
The Programmer is responsible for analysis, design, coding, component and assembly testing of all application code owned by the Application Team.
Complete Description:
The Programmer is responsible for creating and customizing InfoPath forms in a SharePoint 2010 environment, creating SQL Server Reporting Server reports in an SharePoint 2010 or MS SQL 2008 R2 environment, along with Nintex Workflow experience, Visual Studio 2010 C#, and a MS TFS environment. Experience with KnowledgeLake Imaging and VBA would be of benefit to the role. This role will be a hands-on lead worker/architect for the design and development of a project management, contract management, and contract payment system that is being integrated and migrated from QuickBase and Access 2000.
Interviews the week of 10/6/14
Project Scope/Background
Integrating the Contract Management, Contractor Payments, and QuickBase AML project tracking system into a SharePoint Portal
1. Combine the functionality of DMRM’s existing Access 97 pay estimate system and Access 2000 contract database with the QuickBase project tracking system, into a SharePoint Portal.
2. Create a functional system for the following:
a. Construction Project Management: tracking and management of construction projects
i. Currently in QuickBase
b. Contract Management: tracking and administration of contracts
i. Currently in Access 97
c. Payment Management: including payment requests, online approval, and compilation of PO and payment information. The payment management system will be used primarily for progress payments and calculations to construction contractors.
i. Currently in Access 2000
3. An integrated system to track and manage our construction projects through the full lifecycle of an AML project which will include the following:
a. design
b. bidding
c. contract issuance
d. change orders
e. payment
f. completion
Primary goals of the new system will include the following:
• Replace the current MS Access 2000 Contracts database, MS Access 97 Pay Estimate System application and QuickBase application with an integrated centralized SharePoint based system.
• Produce Contracts
• Produce bid tabulation reports
• Produce Contractor Pay Estimate report for payment authorizations.
• Produce the following letters
o Authorization to Proceed Letter
o Loss of bid Letter
o Notice of Furnishing Letter
• Ability to merge information from the system into form letters
• Ability to create forms
• Allowance of ad hoc querying and reporting across the functional program areas
• Unit Price Contracts (UPC) accounting by contract and by project
Existing Software and Services:
The existing Department of Natural Resources computing environment used in day-to-day business operations are outlined below:
• Desktop OS: MS Windows 7, MS Windows 8
• Smaller Database Applications: MS Access 2000, MS Access 97, MS Office 2010
• Enterprise Databases and Systems: SQL Server 2008, SharePoint 2010
• Email: MS Outlook, MS Exchange
• Intuit QuickBase (Hosted/ASP Team Plan)
• SharePoint Environment consists of a 3 environments (development, testing, and production) with the following: SharePoint 2010 Enterprise, Nintex Workflow 2010, Muhimbi, KnowledgeLake Imaging, KnowledgeLake Capture, KnowledgeLake Capture Server, MS SQL 2008R2, MS SSRS Server
• Current Development Environment: InfoPath 2010, MS Visual Studio
Existing Datasets:
The current Contracts system is a Microsoft Access 2000 database. It contains numerous queries that are used for reporting and to populate MS Word 97-2003 templates that generate contract-related correspondence and documents. This system currently tracks approximately 381 construction and non-construction contracts. In addition, the Contracting Section also uses an Excel spreadsheet to track contract status. Because of the low volume, data from the Contracts system will either be imported or manually converted to the new system.
The current Pay Estimate System is a Microsoft Access 97 application and database, which has some table linkages to the Contracts database. The Pay Estimate System database contains records from 1991 forward. Records with a bid opening date of 2010 and beyond will either be imported or manually converted to the new pay estimate solution. The master Item List table in this database contains approximately 700 line items. This table is used for engineering cost and bid creation and needs to be part of the new system.
The current Intuit QuickBase is currently using 5.3 MB application space (this includes a test copy of the database) and 215 MB attached file storage space. Approximately 500 projects are currently tracked in the database, dating from 2006.
User Counts:
There will be approximately 65 internal users of the implementation. There are approximately 500 active contractors in the contacts spreadsheet, with less than 100 contractors bidding per year.
Construction projects usually receive 3 to 5 bids from contractors, but ODNR has received up to 15 bids for a project.
Skills:
Skill
Required / Desired
Amount
of Experience
SharePoint 2010
Required
2
Years
InfoPath 2010
Required
2
Years
Visual C#
Required
2
Years
Visual Studio 2010
Required
2
Years
MS Team Foundation Server (TFS)
Required
2
Years
Muhimbi
Desired
2
Years
Nintex WorkFlow
Required
2
Years
Knowledge Lake
Desired
2
Years
VB6
Desired
2
Years
SQL Server 2008 Stored Procedures
Desired
2
Years
Web Services
Desired
2
Years
MS Access 2000/VBA
Highly desired
6
Months
QuickBase
Highly desired
6
Months
SQL Server Reporting Server (SSRS)
Desired
1
Years
Experience as a Sharepoint architect
Required
2
Years