SharePoint Builder

Providence Health & Services Vanderhouwen Contractor Portland, Oregon June 2010 to October 2013

Raised caregiver collaboration, productivity, and awareness of regional and enterprise-level mission, facilities, departments, initiatives, and resources in a six-month contract that lasted three years by developing out-of-the-box and custom SharePoint platforms, websites, applications, forms, workflows, document management, and business intelligence solutions.

Specialized in client-side web application architecture and development on enterprise .NET, SQL, and SharePoint platforms as an enterprise expert in SharePoint, Access, JavaScript, InfoPath, and Nintex.

Designed, built, and maintained numerous SharePoint intranet websites, workflows, forms, utilities, and single-page apps that survived system upgrades and seismic changes in organizational culture. Authored web content, wrote procedures, documented development, diagrammed processes, and organized taxonomies.

Maximized out-of-the-box SharePoint search and document management capabilities. Trained the trainers on platform user tips and tricks. Set up and administered separate development and production SharePoint farms and SQL servers. Rolled out SharePoint Business Intelligence (BI) tools for the enterprise data group. Built 50+ collaboration websites with feature and function improvements that closely matched wireframes and customer requirements.

Flipped conventional views of SharePoint platform opportunities by exceeding expectations in graphics, client-side web development, content editing, documentation, written procedures, process diagrams, and training. Helped the team win an additional year of contract work through proof-of-concept prototypes and a rapid delivery process.

Webify Self-Service Analytics

A newly formed enterprise data group with 150+ data, reporting, and analytics caregivers sought to host self-service SharePoint 2010 Business Intelligence tools on an existing IS-supported enterprise platform. Filled platform admin and DevOps roles on seven datacenter VM servers. Rolled out platform updates, hotfixes, and bug fixes. Drove architecture, integrations, and rollout of the BI tool stack. Ensured products adhered to security policies. Authored web content, diagrammed and documented platform processes. Became an enterprise expert in platform tools and trained the trainers. Oversaw successful migration and maturation of sites and services onto the enterprise IS SharePoint platform.

Maximize Product Shelf Life

Seismic changes in leadership and organizational priorities eliminated the eHealth team and contract, jeopardizing the in-flight and legacy SharePoint products of seven Providence Health and Services departments without an FTE budget. Worked with the contract employer to combine multiple small contracts into a single engagement. Ensured 50+ enterprise SharePoint sites sailed through the 2007 to 2010 platform migration without incident. Redesigned and developed new client-side web applications, forms, workflows, websites, and analytics products. Extended product service life by five years.

Display Tableau dashboard in SharePoint web part

When the business needs to view Tableau dashboards or visualizations in SharePoint 2010, the most complete solution is to install the Tableau Server Service Application into the SharePoint farm. But what if it is not installed or supported on the farm?

January 29, 2013

2 min read

Remove HTML formatting from SharePoint Rich Text Editor content with JavaScript

People like to avoid SharePoint 2010’s Rich Text and Enhanced Rich Text editors until they find out they can paste in their Word document.

January 13, 2013

2 min read

One Intranet

Migrated the Oregon region of Providence Health and Services's intranet from a regionally hosted Microsoft FrontPage website to an enterprise-wide SharePoint platform.

December 06, 2012

4 min read

Standard Workflows Dial

An enterprise SharePoint web application for finding best practice clinic workflows.

July 04, 2012

6 min read

Reporting Services web parts on SharePoint page

Adding Report Builder web parts to SharePoint 2010 made the page colorful and intelligent, but the UI lacked a bit.

May 26, 2012

2 min read

Using “Append Text to Query” in Search Core Results

SharePoint Search indexes and returns as much as it can, and it depends on you to filter out what you don’t want.

May 20, 2012

2 min read

Open SharePoint List/Library Link in New Window

Why can’t a SharePoint list/library web part open links in a new window by default?

May 20, 2012

1 min read

Calculated Columns for Cascading Drop-Downs in SharePoint Lists and Libraries

SharePoint list or library users need a simple way to enter data in one column that depends on what was entered in another, but out-of-the-box SharePoint 2007 or 2010 does not support direct cascading functionality.

May 13, 2012

3 min read

Generate a hierarchical XML file from SharePoint list

Get data from a SharePoint 2010 list and generate a hierarchical XML file that can be used as a data source for a Flash movie on a site without SharePoint Designer.

May 12, 2012

5 min read

Using HTTP-EQUIV to refresh a page

Using an HTTP-EQUIV meta tag is a simple way to automate this thank-you and form refresh process. The InfoPath form’s meta tag just needs to contain an &Source reference back to the original page.

April 27, 2012

1 min read

Access Denied for Visitors on a SharePoint Page with Reporting Services Webpart

If you are working in SharePoint 2010 and discover that users in the Visitors group or All Authenticated Users are unable to open pages that contain a Report Services web part with an Access Denied error.

February 20, 2012

1 min read

Get the BDC Identity value from a SharePoint 2010 External List to SQL Server

Say you have a Reporting Services web part, and you want to change an indicator on the report from red to green with a single click. To do this, without relying on SharePoint Server Admins, build a Visual Studio 2010 C# Express Console Application following the Client Object Model.

February 03, 2012

1 min read

Health Plans KMS

A high functioning SharePoint Intranet website and web application for health plan content.

July 03, 2011

7 min read

Clinics Directory

A SharePoint Intranet website for Providence caregivers to find Clinic providers, locations and specialties in Oregon.

July 04, 2010

3 min read