|
Hello, Hope
you are doing well, Please go through the following requirement and let me know on [email protected] if you have any
available resources Please send me profile along with contact detail so we can save our
time………. 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. Skills:
Samir
Reddy Technical Recruiter Contact:
980-272-1261 Alter :
850-810-5234 E-mail:
[email protected] Web: www.riderconsultinginc.com You received this message because you are subscribed to the Google Groups "US_IT.Groups" 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 http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout. |
