sharepoint at dnr
DESCRIPTION
Washington State Department of Natural Resources. SharePoint at DNR. Intranet – slow roll out. Started with pilot region and division Stay as much out of the box as possible 3 DNR IT Consultants provide support along with 2 server guys Find an owner for each region and division - PowerPoint PPT PresentationTRANSCRIPT
SharePoint at DNRWashington State Department of Natural Resources
Intranet – slow roll out Started with pilot region and division Stay as much out of the box as possible 3 DNR IT Consultants provide support along with 2 server guys Find an owner for each region and division Site collection grew to 40 GB – 200 sites, in < 2 years
Internet SiteBefore… After…
Before… About 5000 pages Zillions of documents
80 – 100 web editors Many different web
tools Valiant attempt at
consistent navigation Loose enforcement of
content reviews Redundant content
About 900 pages 1800+ unique
documents – and growing
30 trained web editors
20 template pages Consistent navigation
throughout site Content approval
enforced by workflow Created once and
shared across audiences
After …
The Hard Stuff SharePoint Color choices Label choices Deconstructing the
old site Asking for more
time and more money
First attempt at launch
Internal adoption
The Easy Stuff
Engaged executive sponsors
Collaborative contractors
User research results
Second attempt at launch
External acceptance
Results
PLANNED ACTUALBudget $300,000 $520,000Schedule 8 months 14 monthsAcceptance > 40% 82%Ability to make a seamless change to a new administration
None Priceless
TSDC – Timber Sales Document Center
32 TRUST BENEFICIARIES, The principal source of this revenue is from the sale of timber
DNR produces 250 timber sales per year with a revenue stream of approximately 200 million dollars
Paperwork load is extremely heavy and time consuming
Forms change often Document reviews need to take place from many
locations Need corporate memory
TSDC – Timber Sales Document Center
Workflow creates SharePoint site for timber sale Permissions transferred from existing Oracle application Creates and launches Oracle Report - displays Oracle data Link to mapping system Master document library Field notes and compliance document library
TSDC – Timber Sales Document Center
Custom workflow uses 3rd party tool to build a PDF review packet that is stored on SharePoint
TSDC – Timber Sales Document Center
Sale Closeout workflow cleans up site - deletes desired documents and versions
System uses: MS Office – Including InfoPath Adobe Acrobat SharePoint Oracle database
Cost = $150,000
Planning for next phase – more integration with existing applications and data
Intranet moves forward Started with
changing home page only – move entire intranet later
Most agency communication here – no more all-DNR email
Homepage owned by Communications Group
Fewer emails with attachment$
Water Type Modification Tracking Was time consuming process that utilized the
US Mail Easily give permissions to many work groups SharePoint, Excel, and Adobe Acrobat - Scanner
Water Type Modification Tracking Custom Workflows set ID, link to scanned
document, map and FPA
Forest Practice Enforcement Tracking Replaced old FileMaker Pro database – MS
Access ??? Permissions easily dealt with easily
Forest Practice Enforcement Tracking SharePoint column types - data consistency Created Views for reporting
SharePoint at DNR – What’s Next? Implement Corasworks Break up content database Move remainder of intranet Test helpdesk solution Test training solution Install ETAR into production ??? Due to staff cuts
Dave [email protected]