Senior Solutions Architect, CEO, CTO, Team Lead, and Technology Mentor specializing in SharePoint solutions architecture and .Net development. Tools of choice are Microsoft SharePoint, Visual Studio .Net, Office, and SQL Server
Founder of VoteMatrix, Inc. (2011) – SharePoint/Office 365 consulting and political analysis website
Three years as Chief Technology Officer- responsible for corporate technology direction
Seven years as SharePoint Solutions Architect and Certified Configuration and Development Specialist
Community contributor - Published articles, blogs, controls, applications, and code for public use
Eight years as a Database Engineer including T-SQL Scripting (Triggers, Stored Procedures, Functions, Schema Design, and Modification), Imports/Exports, Security, and Admin
Presenter/Attendee: SharePoint Conferences and Sacramento .Net and SharePoint User Groups
EXPERIENCE
VoteMatrix, Inc. - SharePoint Consulting Practice and Political Analysis / Matchmaking Website
Founder and Chief SharePoint and .Net Solutions Architect (Founded 6/09) 10/12 – Present
Environment: SharePoint Services / Foundation / Server 4.0 – 5.0 / 2010-2013,
SharePoint Designer 2007- 2013, ASP.Net 4.0, Visual Studio 2010 / 2012,
SQL Server Express 2008, Dynamic Data Framework, SourceAnywhere Hosted,
GoDaddy Domain Registration, Cloud Hosted Asp.Net and SQL
Summary: Founder, CEO, Chief Architect, and Developer
Responsibilities:
Incorporated (S Corp) 2011
Created a technical consulting division for SharePoint and Office 365
Business development involving partnerships with other consulting firms and direct clients
Founded and architected the VoteMatrix Political Matchmaking (VMPM) prototype – currently under construction
Architected and developed the VMPM SQL database, U.S. legislative data import utilities, and a Asp.Net UI prototype using LinqToSql and the Dynamic Data Scaffolding Framework
Developed a business plan, implemented a public website, and developed a time tracking system in Office 365 (SharePoint 2013)
Client – CalHFA (Housing Finance Agency) (via Providence Technology Group) 7/13 – present
SharePoint Solutions Architect 7/13 – present
Environment: SharePoint Server 2010, MS SQL Server 2008 R2, Windows Server 2008 R2
Summary: SharePoint Solution Architecture, Deployment, Development, Mentoring
Responsibilities:
Worked with the CTO to support a solution with over 90,000 document libraries, over 700 sites, and custom data import processes
Developed an Event Receiver to handle creation and updates of document libraries
Developed a database to list synchronization tool integrating with an antiquated LOB system
Developed a ECM Tools link web part
Integrated the web part into a custom master page and automated the deployment on all 700 sites
Troubleshot various infrastructure and solution issues unsolvable by MS Tech support
Mentored development staff in SharePoint Designer and Visual Studio best practices
Client – Everest Solutions Group (ESG Network) 10/12 – present
SharePoint Practice Manager and Lead Architect 10/12 – present
Environment: SharePoint Server 2013, MS SQL Server 2012, Windows Server 2008 R2
EMC Documentum, Oracle
Summary: SharePoint Practice Manager and Lead Architect
Responsibilities:
Worked with the VP of Development to start the firm’s SharePoint practice
Integrated Office 365 into the project collaboration process
Personally interviewed and reviewed candidates to build a top-tier team of consultants within budget constraints
Developed the SharePoint practice business plan
Analyzed new proposals and initiatives for feasibility and project estimation
Managed customer relationships and business development
Client – California Dept. of Insurance (via ESG Network) 10/12 – present
Project – Market Conduct Examination Collaboration Solution 10/12 – present
Environment: SharePoint Server 2010, MS SQL Server 2008 R2, Windows Server 2008 R2
Idera, Muhimbi, Documentum, Oracle, SQL Developer, OpenText Hummingbird DM, KnowledgeLake, CRM
Summary: SharePoint Solution Architecture, Deployment, Development, Mentoring
Responsibilities:
Architected a SharePoint collaboration solution to facilitate the Market Conduct Division’s examination process daily operations and exam management
Architected, migrated, and implemented a public facing search and publishing solution for the Market Conduct Division’s examination and response records
Migrated content from and replaced the antiquated OpenText Hummingbird DM solution
Built custom BDC models for external content types, pulling data directly from Oracle DBMS
Customized advanced search, managed properties, and refinement panel
Lead the development of cross-farm publishing workflows to facilitate internal to DMZ publishing
Integrated Muhimbi PDF conversion tool and utilized the Idera migration platform
Including: task based workflow design; scheduling; enterprise content management; Documentum end of life publishing; and public web site publishing
MS Dynamics: CRM integration planning and recommendations
Client - Benge Law (Legal Practice) 9/09 – present
IT Services Consulting
Environment: BPOS, SharePoint Online, Office 365, Exchange Online, GoDaddy
LexisNexis Time Matters and PCLaw, DropBox
Summary: Small business infrastructure planning and general support
Client – PixelMill (Web Design Firm) 4/13
Environment: Office 365, Dynamics CRM Online, iOS, Android
Summary: Dynamics CRM and Gmail integration
Kiefer Consulting, Inc. – Consulting Firm
CTO and Senior Lead SharePoint and .Net Solutions Architect 7/06 – 10/12
Environment: SharePoint Services / Foundation / Server 3.0-4.0 / 2007-2010, Visual Studio 05-12
SharePoint Designer 2007-2010, MS SQL Server 2000-2012, SourceGear Vault,
ADFS, Office 365, Lync Online, BPOS, SharePoint Online, Exchange Online, TFS
ASP.Net, CSS, VB.Net, C#, ADO.Net, XML
Summary: Chief Technology Officer and SharePoint Practice Lead Architect
Responsibilities:
Started the firm’s SharePoint practice, working directly with the owner
Grew the practice from scratch to over a million dollars annually in revenue
Helped position the company as the leading SharePoint solution provider in Northern California
Managed the corporate services move to cloud services utilizing Office 365
Included ADFS SSO, Lync Online, Exchange 2010/Online hybrid, and SharePoint Online
Assisted in developing and managing the public, intranet, and extranet web sites utilizing SharePoint Server 2010 and Hyper V virtualization
Consulted on corporate purchases, infrastructure plan, and marketing strategies
Prepared project proposal material including Visio solution diagrams, PowerPoint presentations, live demos, marketing materials, and technical overviews and responses
Helped build a proposal management system in SharePoint 2010 utilizing document sets and a mail enabled document library
Ensured customer satisfaction by delivering quality solutions tailored to the customers’ needs
Architected an expense tracking system for employees and HR on SharePoint 2010
Created a comprehensive, distributable developer virtual box VM to reduce project startup time
Optimized the Business Development portal to streamline requests for proposal and bid processing
Mapped corporate business unit strategies and partners using MindManager
Consulted on MS Dynamics CRM use, SharePoint integration, and custom app development
Lead a team of developers to create the Kiefer Web Conversion Kit product to easily migrate and manage E-Services mandated CA.Gov website templates via the SharePoint Server 2007 web content management system
Installed many SharePoint Server 2007 to 2013 farms for development and production environments
Trained Consulting Firm employees on SharePoint Server 2007/2010 utilization
Prepared and delivered numerous live SharePoint demonstrations
Provided Microsoft SharePoint Deployment Planning Services (SDPS)
Built several MOSS 2007 and SharePoint 2010 Virtual Servers for demonstration and development
Migrated the Consulting Firm’s website into the SharePoint Server 2007 Beta 2 web content management system
Presented on Visual Web Part development at SharePoint Saturday Sacramento 2011, SharePoint Exchange 2010 in Sacramento, a Microsoft open technical session in Sacramento, and the Sacramento .Net User Group. Included SharePoint 2010 Visual Web Part development with SPMetal, custom properties, modules, solution packages, and list instances. Included a SharePoint primer.
Presented “Web Part Creation” at the Kiefer InfoPath Edunarsm (11/07)
Presented “DataGridView with a Detail Edit Form” at the Sacramento .Net User Group (9/07)
Presented “Web Content Management” at the Kiefer SharePoint Edunarsm (9/06)
Beta Tested SharePoint Server 2007 – Beta 2 and B2 Technical Refresh (B2TR)
Client – California Independent Service Operators (CA Power Grid) 10/08 – 10/12
Project – Operations and Procedures Document Management Redesign (PPRLM) 6/12 – 10/12
Environment: SharePoint Server 2010, MS SQL Server 2008 R2, Windows Server 2008 R2
MS Access 2012, K2, Visual Studio 2012
Summary: SharePoint Solution Architecture, Deployment, Development, Access Migration
Responsibilities:
Architected a SharePoint document and records management redesign for the CaISO’s Operations and Procedures Management department
Coordinated and developed a MS Access to SharePoint migration unifying metadata within SharePoint
Developed a taxonomy and schema plan, merging 2 site collections and developing SSRS reports and SharePoint views against the post-migration data
Architected and developed a document version history reporting solution utilizing SharePoint event handlers, workflows, and SSRS
Developed a version history extraction Windows 64 bit application (published on CodePlex)
Project – Market Participant Portal (MPP) 10/08 – 2/10
Environment: SharePoint Server 2007, MS SQL Server 2008, Windows Server 2008, ClearTrust
JQuery, VMWare, AJAX Toolkit 3.5,
Web Services, .Net 3.5, JavaScript, IE6
Return of SmartPart, Oracle, Success Factors SSO, SharePoint Guidance Kit, Bamboo Solutions
Summary: SharePoint Solution Architecture, Deployment, Development, Hiring, Team Lead
Responsibilities:
Architected a SharePoint Extranet Portal site for CaISO’s Market Participants spanning Western North America. The Market Participant Portal was designed as a single point of entry dashboard display of the most common information and links to appropriate applications
Included AJAX automatic refresh and paging of dynamic content web parts
Created SmartCache, a multi-threaded farm level caching solution to reduce back-end server load
Created SmartLog, a logging and tracing implementation of the SharePoint Guidance Kit’s ULS logging system
Created AutoRefreshUserControl inherited class to enable AJAX Auto Refreshing and Web Part independent processing to reduce back-end server load
Web parts utilizing Return of SmartPart User Controls via a custom Return of SmartPart implementation
Security trimmed links and web parts with user targeted and secured content from multiple web services
Performance tested, load balanced farm architecture
Production failover farm with asynchronously mirrored and client aliased content database
Architected and deployed development, test, and staging farms to host MPP and other SharePoint projects
VMware virtualized hardware throughout
Developed 2 workarounds for SharePoint issues, documented in blog and community content
Created the open source HTMLFilter project
A webserver response replacement UserControl for fine tuning out-of-the-box SharePoint and Asp.Net site functionality: http://htmlfilter.codeplex.com/
Theme, layout, and Master Page architecture
Personalization enabled
Audience targeted
Utilized LDAP Authentication and Role Provider with SSL termination via ClearTrust and reverse-proxy servers
Project – ECurrent Intranet Site and Success Factors Single Sign On 10/08 – 10/09
Environment/Summary: Same as MPP
Responsibilities:
Architected a SharePoint Intranet site for CaISO’s internal Employees. The ECurrent Intranet site would act as the corporate wide home page and would also act as the new document management system, replacing DocuShare.
Performance tested, load balanced farm architecture
Production failover farm with asynchronously mirrored content database
SQL clusters configured for each production farm utilizing physical servers
Developed a 3DES encrypted Single Sign On solution for Success Factors
Project – MS SQL Server Reporting Services Proof of Concept 5/09 – 9/09
Environment: SharePoint Server 2007, MS SQL Server 2008 SSRS, Windows Server 2008
Summary: SharePoint Solution Architecture, Deployment, Development, Hiring, Team Lead
Responsibilities:
Architected and deployed a MOSS integrated SSRS solution for CaISO’s internal use
Interviewed and approved Report Designer to develop the ABC reports
Load balanced MOSS integrated architecture for high availability and scalability
Utilized SQL server cluster for SSRS databases
Client – Vanir Construction Management 10/11 – 9/12
Project – CDCR Facilities Planning and Construction Management system 10/11 – 9/12
Environment: SharePoint Server 2010, SharePoint Designer 2010, VS2010, Nevron Charts, SSRS
Summary: SharePoint Solution Architecture, Planning, Analysis, Development, Configuration
Responsibilities:
Architected and lead the team in building a cutting edge Construction Management solution heavy in Business Intelligence (BI) dashboards and charts
Lead the team in preparing detailed business requirements, planning, and architecture documentation to accurately estimate and plan the solution
Architected and installed a SharePoint cloud hosted infrastructure production extranet farm
Utilized industry standard scripted installation
Utilized SharePoint Boost Cascaded Lookup, Lookup Boost, AD Management, and List Collection web parts/columns
Utilized Nevron SharePoint Charts to display aggregated list data throughout site
Worked with team to implement a dynamic and space saving AJAX navigation system utilizing SharePoint standard navigation source as part of a complete rebranding package
Developed a lookup column and other field dynamic default configuration utility as a SharePoint event handler
Developed SharePoint site templating and provisioning PowerShell scripts using PowerGUI
Client – EMF Broadcasting (KLOVE, Air1 Radio) 12/10 – 8/12
Project – Support Contract 1/12 – 8/12
Environment: SharePoint Server 2007/2010
Summary: SharePoint Architecture, 2007/2010 Upgrade, Troubleshooting
Responsibilities:
Consulted on upgrading all SharePoint Server farms from 2007 to 2010
Developed a process to upgrade SharePoint Fab40 Help Desk template
Deployed SharePointBoost’s Batch Check In utility
Architected a content management and retention policy plan
Project – Help Desk, Change Request, and Work Item Management 12/10 – 1/11
Environment: SharePoint Server 2007, SharePoint Designer 2007, KwizCom Cascading Lookup Plus
Summary: SharePoint Solution Architecture, Analysis, Configuration, Mentor
Responsibilities:
Architected, configured, and deployed an enterprise help desk ticket, change request, and work item management system using MOSS 2007 with SP Designer 2007
Solution features: custom alerts; state change based notifications; state machine workflows; customer notifications; change request integration; promotion from ticket; child work items; work item integration; key performance indicators; service level agreement (SLA) calculated fields; deadline notification; approval workflows; custom fields; custom add item forms; linked web parts; and cascaded dropdowns
Client – Evolve Technology Group 1/12 – 10/12
Project –Project Management System (ad-hoc contract) 1/12 – 10/12
Environment: SharePoint Server 2010, SharePoint Designer 2010, Excel 2012, SharePointBoost
Summary: SharePoint Solution Architecture, Analysis, Configuration, Mentor
Responsibilities:
Architected and implemented a SharePoint contract/project management and time keeping system to replace a manual Excel spreadsheet system
Timesheet, rates, and services project lists
Developed 3 SharePoint designer workflows
Client – Ahtna Facility Services, Incorporated 12/10 – 10/11
Project – US Dept. of Energy Naval Petroleum Reserve RIMS Production 3/11 – 10/11
Environment: SharePoint Server 2010, SharePoint Designer 2010, Vizit Essential
Summary: SharePoint Solution Architecture, Analysis, Configuration, Mentor
Responsibilities:
Architected and installed a SharePoint on-premises production extranet farm
Utilized industry standard scripted installation
Lead the team in architecting and configuring the production solution
Lead the development team in building a custom “copy to multiple” workflow
Project – US Dept. of Energy Naval Petroleum Reserve RIMS Prototype 12/10 – 3/11
Environment: SharePoint Server 2010, SharePoint Designer 2010,
AvePoint File Share Document Connector, Vizit Essential
Summary: SharePoint Solution Architecture, Analysis, Configuration, Mentor
Responsibilities:
Architected and configured a public facing Records Information Management System with integrated Collaboration Extranet prototype for archiving and accessing historical Department of Energy Naval Petroleum Reserve (DOE NPR) scanned documents and other NPR geospatially categorized information
Utilized AvePoint’s File Share Document Connector using Remote BLOB storage
Implemented Vizit Essential for search center document preview
Mentored the team in proper SharePoint taxonomy and configuration
Client – Fairfield-Suisun Sewer District 5/11 – 6/11
Project – Facility Monitoring Trend Charts 5/11 –6/11
Environment: SharePoint Server 2010, SharePoint Designer 2010, SQL Server 2008, Dundas Charts
Summary: SharePoint Solution Architecture, Analysis, Configuration, Mentor
Responsibilities:
Configured Secure Store Service for authentication with the Facilities Monitoring SQL Database
Created and secured chart specific database Views in SQL Server
Created External Content Types against the database for use in specific Chart Web Parts
Documented processes and mentored staff
Client – Medtronic 2/11 – 4/11
Project – SharePoint and InfoPath Consulting 2/11- 4/11
Environment: SharePoint Server 2007, SharePoint Designer 2007, InfoPath 2007
Summary: SharePoint Configuration, Troubleshooting, InfoPath Form Design
Responsibilities:
Troubleshot and fixed various InfoPath and SharePoint related issues
Recommended architectural changes as needed
Client – Golamac, Inc. 1/11
Project – Tarlton Corp. SharePoint UI Theme 1/11
Environment: WSS 3.0, SharePoint Designer 2007
Summary: SharePoint UI Design, Firebug, IE Developer Tools
Responsibilities:
Applied the http://www.TarltonCorp.com public web site theme to 20+ SharePoint intranet and extranet sites
Created themes and master pages based on the public web site style utilizing existing styles and images
Client – EM Systems 03/10 – 10/10, 1/11
Project – Response Manager (Emergency Response Management and Alerting) 03/10 – 10/10, 1/11
Environment: MS Search Server 2008, SharePoint Server 2007, SharePoint Portal Server 2001
MS SQL Server 2008, Windows Server 2008/2001, VMWare, .Net 3.5, IE8, VBScript, PowerShell,
SharePoint Designer 2007, FireBug, IE Developer Tools
Summary: SharePoint Solution Architecture, Design, Deployment, Development, Mentor
Responsibilities:
Helped architect a SaaS (Software as a Service) hosted multi-tenancy SharePoint solution for the Response Manager product ensuring data isolation among tenants
Recommended and helped implement a downgrade from MOSS 2007 to 64bit MS Search Server 2008 to save hundreds of thousands of dollars in licensing costs and provide a SharePoint 2010 upgrade path
Recommended and helped develop a stand-alone virtual development environment to dramatically increase developer productivity throughout the RM team, likely saving the company hundreds of thousands of dollars in developer time and project overhead. Prior solution included three VMs per developer, inconsistent deployments, difficult snapshot process, and manual installations of RM multiplied by major release and developer.
PowerShell scripted SharePoint Search Server 2008 search configuration including PDF and MS iFilter installations, crawl scheduling, start addresses, and managed property to crawled property metadata mapping
SharePoint Search interface enhancements including ‘Open Containing Folder’ document shortcuts, Metadata Labeling, Advanced Search updates, iFilter installation, document icon updates, and OSSSearch.aspx to Results.aspx redirection
All changes were deployed as a SharePoint Solution or Feature since RM is a distributed application
Mentored other Development Team Leads on SharePoint Solutions best practices
Designed and implemented a SharePoint hosted OneNote Developer Orientation and Knowledgebase section to decrease new developer ramp-up time
Triaged and repaired several SharePoint related product bugs
Developed a VBScript scrub utility to facilitate document migrations from SPS 2001 to MOSS 2007
Developed a .Net MOSS audit log translator tool to translate cryptic log messages
Implemented UI theme changes
Client – California Department of Corrections 8/09
Project – SharePoint Intranet 8/09
Environment: SharePoint Server 2007, MS SQL Server 2008
Summary: SharePoint Solution Architecture, Deployment
Responsibilities:
Deployed a Large SharePoint Farm using a mirrored automated failover architecture
Client – California Department of General Services 7/09
Project – SharePoint Intranet 8/09
Environment: SharePoint Server 2007, MS SQL Server 2005
Summary: SharePoint Solution Architecture, Deployment
Responsibilities:
Deployed a SharePoint Farm using DBA deployed databases
Architected a workaround for a MS bug with DBA deployed database when running in a highly restricted security environment
Client – California State Lottery 6/07 – 10/08
Project – CaLottery.Com Public Website Architecture and Development 7/08 – 10/08
Environment: SharePoint Server 2007, MS SQL Server 2008, Windows Server 2008
AJAX Toolkit 3.5, .Net 3.5, Silverlight 2.0, Flash CS4, JavaScript, IE6+, FireFox, Opera
Summary: SharePoint Solution Architecture, Development, Hiring, Team Lead
Responsibilities:
Architected a SharePoint Web Content Management and .Net 3.5 solution to replace the existing CaLottery.Com public website
Consulted on database and data load application architecture to store gaming vendor data
Architected and helped develop a Silverlight ad-rotator control, populated via a custom SharePoint list
Lead the development of Master Pages, Page Layouts, CSS, AJAX components, and JavaScript to meet the design requirements
Project – Retail Website Data-load 6/07
Environment: MS SQL Server 2000, Visual Studio 2005
Summary: SQL Data Import, Solution Architecture, VB6 to .Net 2.0 conversion
Responsibilities:
Architected a .Net 2.0 solution to upgrade and consolidate an existing weekly data import application
Automated FTP import, decryption, encryption, data transformation, database inserts, and replication
Highly diverse data types: fixed width, csv, xml, with variable recursive column parsing
Built several SQL Server stored procedures for data import and database migration
Utilized an existing staging database
Client – California Department of Child Support Services 7/07 – 3/08
Environment: SharePoint Server 2007, MS SQL Server 2005, CorasWorks
Summary: SharePoint Solution Architecture, Development, Training, and Implementation
Responsibilities:
Architected an extranet SharePoint solution to provide content management and collaboration to statewide County Child Support Agencies as part of the $1.7 billion CCSAS project
Over 3000 users
Migrated content from a custom ASP content management system to MOSS
5 year deployment plan, including a SAN, 2 application servers, and 2 front end web servers
Designed a single sign on solution to integrate with an existing extranet security implementation
LDAP membership and role providers using an AD user store
Persistent or non-persistent cross-farm cookie by zone (intranet or extranet)
Security hardened extranet network topology utilizing multiple subnets and port configurations
No trust AD domain architecture
DBA installed databases
End user demonstrations and training sessions
Met rollout deadline despite major hardware acquisition delay
CorasWorks integration
TrendMicro Portal Protect
Client – California Gambling Control Commission 5/07
Environment: SharePoint Server 2007
Summary: One on One, Two Day SharePoint Training Class
Responsibilities:
Prepared and taught a 2 day SharePoint 2007 Configuration training course
One on one instruction with a custom curriculum and training manual developed in-house
Client – Sacramento County Municipal Services 8/06 – 5/07
Environment: Visual Studio 2005, ASP.Net, VB.Net
Summary: Lead several developer training sessions
Responsibilities:
Lead a 6 hour course on SharePoint Server 2007 and SharePoint Designer 2007
Lead a 6 hour course on Visual Studio 2005 ASP.Net 2.0 New Web Controls
Lead a 3 hour course on .Net 1.1 to 2.0 Conversion and VB.Net Refactor! for Visual Studio 2005
Client – California Department of Conservation 4/07 – 5/07
Environment: SharePoint Server 2007, MS SQL Server 2005
Summary: SharePoint Analysis and Web Conversion Kit Implementation
Responsibilities:
Consulted on SharePoint web content management architecture and migrating all existing public facing websites to the E-Services mandated CA.Gov website templates
Worked with a team of developers to plan the migration and develop a .Net migration tool
Planned and implemented two SharePoint farms (internal authoring and public deployment) for prototyping and development
Documented installation procedures for installation in production environment
Prepared and presented a customized demonstration of the Consulting Firm’s CA.Gov Web Conversion Kit
Client – Sacramento Municipal Utilities District (SMUD) 5/07
Environment: SharePoint Server 2007, MS SQL Server 2005
Summary: SharePoint Solution Architecture, Training, and Implementation
Responsibilities:
Architected a SharePoint solution to meet team collaboration and content management business requirements
SharePoint infrastructure analysis and design
Trained administrators via guided configuration sessions resulting in a complete solution implementation
Developed a custom solution to allow FTP links within a Document Library
Client – Legislative Counsel Bureau 3/07
Environment: SharePoint Server 2007
Summary: One on One, Two Day SharePoint Training Class
Responsibilities:
Prepared and taught a 2 day SharePoint 2007 Configuration training course
One on one instruction with a custom curriculum and training manual developed in-house
Client – California Employment Development Department 12/06
Environment: Visual Studio 2005, IIS 5.1, SQL Express 2005, VB.Net
Summary: Developer training courses on ASP.Net and ADO.Net
Responsibilities:
Installed Visual Studio 2005, IIS 5.1, and SQL Express 2005 on student workstations
Taught two 6 day courses over 4 weeks. 6 days of ASP.Net and 6 days of ADO.Net
Each course ended with a day of real-world work using the course’s material to redevelop an existing application
Incorporated student lab sessions
Client – California Department of Conservation 11/06 – 12/06
Environment: SharePoint Services 2.0, MS SQL Server 2000
Summary: SharePoint analysis and best practices
Responsibilities:
Discovery sessions to determine current architecture, immediate business needs, and projected business requirements.
Prepared and delivered Microsoft based guidance documents outlining appropriate best practices and recommendations.
Consulted on specific SharePoint issues
Client – Legislative Counsel Bureau 8/06-10/06
Environment: SharePoint Server 2007 B2TR, SharePoint Designer 2007, SQL Server 2005
Summary: SharePoint Server 2007 Proof of Concept
Responsibilities:
Developed an LCB public website prototype using MOSS 2007 B2TR
Installed and configured a dual server MOSS 2007 B2TR farm
Migrated the prototype from the Consulting Firm’s development farm to the LCB test farm
Successfully demonstrated all 12 Business Requirements as defined by the client
Wirestone – IT design and consulting firm
Senior Enterprise Application Engineer and Project Lead 4/08 – 7/08
Environment: SharePoint Services 3.0, SharePoint Designer 2007, Team Foundation Server
Visual Studio 2008, MS SQL Server 2005, C#, ASP.Net
Summary: Developed Security Architecture and Web Parts for MS’s Intl. Innovative Teachers Network
SharePoint site deployment and Technical Lead for the Partners in Learning team site migration
Responsibilities:
Senior SharePoint Solutions Architect and Application Developer
Architected the security plan for the 2.0 deployment of Microsoft’s International Innovative Teacher Network product offering
Modified existing custom SharePoint Web Parts to security trim content based on the new security groups
Engineered and developed Microsoft’s internal Partners in Learning team site
Technical lead for migrating data from the existing Partners in Learning team site to the new site without direct access to the server while retaining modified/created by user info and metadata
JTS Communities – Home Builder
Senior Enterprise Application Engineer and Project Lead 5/04 – 6/06
Environment: Visual Studio 2005, MS SQL Server 2000/2005, SourceSafe, ASP.Net, VB.Net,
C#, ADO.Net, ClickOnce, T-SQL
Summary: Engineered and Managed Asp.Net 1.1 and 2.0 Web Applications
Responsibilities:
Managed an Asp to Aspx (.Net) Enterprise Web Application Suite conversion and the subsequent conversion from Asp.Net 1.1 to 2.0
Successfully architected and developed a multi-tiered, object oriented, ASP.Net and SQL Server based Plot Plan management system including multiple role based views, email notifications, workflow management, plot plan uploads, user management, and a discussion thread allowing collaboration between local drafters and satellite sales offices
Successfully architected and developed a Loan Approval system with the same features as the Plot Plan system for use by satellite sales offices, the local finance department, and the Wells Fargo loan representatives
Developed custom Web and User Controls
Designed and developed database schemas, stored procedures, views, triggers, and functions
Developed a common component library and reusable database objects
Client – Blue Lake Construction (Home Construction) 1/05 – 6/06
Environment: Visual Studio 2005, Infragistics NetAdvantage 2006, MS SQL Server 2000/2005,
SourceSafe, ASP.Net, VB.Net, C#, ADO.Net, ClickOnce, T-SQL
Summary: Application Engineer and Project Lead for a construction management system
Responsibilities:
Engineered and lead the development of an enterprise purchasing and estimating construction management application
Implemented a 3-tiered, SQL server based ClickOnce Windows client architecture utilizing the Infragistics NetAdvantage UI suite
Implemented highly complex business requirements and highly efficient user interfaces
Included many hierarchical (drill-down, expandable) UltraGrid and UltraTree controls with user customizable views
Developed custom base classes, extender providers, components, and user controls
Intercare Insurance Services – Workers Compensation Third Party Administrator
Software and Data Systems Engineer 1/03 – 5/04
Environment: Visual Studio 6.0/2003, MS SQL Server 2000, SourceSafe, ASP.Net, VB.Net, C#,
ADO.Net, ActiveReports .Net, T-SQL, MS Access, Valley Oaks Portal
Summary: Systems Analysis, Data Imports/Exports, and Application Development
Responsibilities:
Developed an object oriented, database driven .Net command line application to automatically extract, convert, encrypt, and send any local data source via multiple transportation methods (email, FTP), using appropriate encryption algorithms (PGP, WinZip)
Developed a .Net reporting engine and other object-oriented components for an n-tiered .Net Windows Application utilizing .Net Remoting with Visual Studio .Net 2003, VSS, SQL 2000, and ActiveReports .Net
Importing, exporting, and reporting of confidential (HIPAA) data
Database design, including tables, relationships, constraints, stored procedures, triggers, views, and functions
Developed SQL Server 2000 queries and views for use in SQL Reporting Services and Crystal Reports
Developed electronic data interfaces with third party administrators, insurance companies, government agencies, bill review companies, and an equipment sales company
Process analysis for the claims management department
Provided process flows and recommendations
Adecco – Consulting/Temp agency
Network Engineer 10/98 – 8/02
Summary: Network Engineering Contractor
Client – Peoplesoft 12/99 – 8/02
Environment: MS SQL Server 2000, Windows NT4.0/2000/XP/98, MS Office
Summary: Network Engineer for the Davis and Gold River offices
Responsibilities:
Workstation rebuilds, media station build, problem solving, cabling, and upgrades
Responsible for the Davis office mail, facility requests, and supplies
Client – Vantive Inc. 12/99 – 8/02
Environment: MS SQL Server 7.0/2000, Windows NT4.0/2000/XP/98, MS Office
Summary: Network Engineer for the Davis and Gold River offices
Responsibilities:
Workstation rebuilds, problem solving, cabling, and upgrades
Installed Compaq server rack/cabinet and rack mounted Enterprise Server
Davis Christian Fellowship – Campus Religious Organization
Networking Team Leader 10/00 – 8/02
Environment: Windows 98/XP, MS Office
Summary: Volunteer work for a nonprofit campus organization
Responsibilities:
Workstation rebuilds, media station build, problem solving, cabling, and upgrades
Modified and updated website (HTML)
Started and maintained email lists
Recruited, trained, and coordinated members for the team
Prepared PowerPoint presentations for weekly meetings
Built and networked three computers and a DSL line
Mengali’s Florist
Website Consultant 10/01
Environment: Macromedia DreamWeaver MX, Jasc PaintShop Pro
Summary: Consulted on and developed www.mengalis.com
Responsibilities:
Built www.mengalis.com v1 using Macromedia DreamWeaver (HTML) and Jasc PaintShop Pro
Digitally transferred a video commercial to stream from website
Consulted on domain name registration and web hosting provider
Provided an easily modifiable specials page with a one step upload script
Hotel Woodland – Venue
IT Consultant 10/01
Environment: MS Word
Summary: Developed an MS Word template to automate facilities reservation form entry
The End Zone – Gaming Store
IT Consultant 6/98 – 6/01
Environment: Macromedia DreamWeaver, Jasc PaintShop Pro
Summary: IT consultant for a gaming store
Responsibilities:
Built and maintained www.davisendzone.com
Installed and ran DCI tournament management software
Scotch Bonnet Integration Inc. – Consulting Firm
Systems Engineer and Access Developer 6/97 – 10/98
Environment: SQL Server 6.0/7.0, Windows NT4.0/NT/2000/XP/98/95/3.11
Summary: Systems Engineer and Access Developer
Responsibilities:
CA Department of Corrections – Developed a MS Access facilities maintenance review application using a SQL database back-end
Sole engineer responsible for the IT infrastructure
Built computers and servers from components
Installed server and workstation operating systems
Purchased, installed, and maintained an smtp/pop mail server
Converted network to 10baseT from coaxial
EDUCATION
Microsoft SharePoint Conference 2012 – link – notes on my blog 11/12
Microsoft SharePoint Conference 2011 – link – notes on my blog 9/11
SharePoint Saturday Sacramento 2011 – link – notes on my blog 6/11
Microsoft Cloud Intelligence Conference 2011 – link – notes on my blog 6/11
SPTechCon Burlingame 2011- notes on my blog 2/11
SharePoint Exchange 2010 6/10
Microsoft SharePoint Conference 2009 1/09
Scaling With SharePoint – Jie Li
SharePoint Administrators: The Reluctant SQL Server DBAs – Todd Klindt
Fast Track to SharePoint Feature Generation – Bjorn Furuknap
SharePoint Designer 2007 – Tom Rizzo
SPTechCon Burlingame 2009 1/09
Microsoft Office SharePoint Conference 2008 3/08
Build Interactive User Experiences with the Silverlight Blueprint for SharePoint
InfoPath Crash Course for SharePoint IT Professionals
SharePoint as a BI Platform
Build an Automated Expense Reimbursement Process Using InfoPath and SharePoint
Leveraging the Power of Excel Services to Build Rich SharePoint Applications
Creating Solutions with the Business Data Catalog
Deploying EPM 2007 Solution into an Existing MOSS Environment
SharePoint Tools for Style: How to Start Branding SharePoint
SharePoint Tools for Style: Advanced Techniques for Branding SharePoint
Rendering Data in SharePoint using AJAX and LINQ
Creating Solutions with the MOSS Single Sign On Service
SharePoint Designer: I Didn’t Know You Could Do That!
Migrating a SharePoint Designer Workflow to Visual Studio .NET
CorasWorks Workplace Builder and Architect Training Course 2/08
SharePoint and DotNet User Group Sessions
Windows Workflow Foundation Essentials – Stuart Celarier
SharePoint Governance and Taxonomy – Mark Schneider
Bachelor of Science in Mathematics, Minor in Education 2002
University of California: Davis
CERTIFICATIONS