Hello,
Hope you are doing well.
As discussed please find the requirement below.
Please let me know are you comfortable with this position?
Title: SharePoint Developer
Req ID: 382352
Location: 2045 Morse Road, Columbus
OH
Client: State of OH-Natural Resources
Duration: 3 months+ 1 Year extension
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.
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.
Thanks.
Kevin*Patel*
Ph No:- 980-819-0687
E-mail:- ke...@riderconsultinginc.com
G-Talk : kevinpatel.ri...@gmail.com
Web Site :- www.riderconsultinginc.com
--
You received this message because you are subscribed to the Google Groups
"project managment" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to project-managment+unsubscr...@googlegroups.com.
To post to this group, send email to project-managment@googlegroups.com.
Visit this group at http://groups.google.com/group/project-managment.
For more options, visit https://groups.google.com/d/optout.
