Sharepoint Project

Edward C. Stotz, Jr. CPA, PMP, MCPD, CISSP, ITIL

**** ******* *****

Silver Spring, MD 20902

*******@*****.***

SharePoint: Installed, Administered, Migrated and Developed Solutions for SharePoint 2003, 2007, 2010, 2013 and 2016

Software Certification:

Microsoft Certified Professional Developer - Enterprise Application Developer

Microsoft Certified IT Professional: Database Developer SQL Server 2005 and 2008

Microsoft Certified Technology Specialist – SharePoint 2010, Application Development

Microsoft Certified Technology Specialist – MS Office SharePoint Services 2007, Configuring

Microsoft Certified Technology Specialist – SharePoint Services 3.0 – Application Development

Microsoft Certified Technology Specialist - SQL Server 2005 and 2008

Software Development:

SharePoint Designer 2007, 2010, 2013

Microsoft Visual Studio, Team Foundation Server (VB.NET and C#)

Crystal Reports (versions 8 to 11), JavaScript, JQuery, Angular, Backgrid, Kendo UI, XML, CAML

Databases:

SQL Server 6.5, 7.0, 2000, 2005, 2008 and 2012

Oracle 7.3, MS ACCESS, Sybase, Ingres, Progress, and Paradox

Virtual Environments - Hyper-V and VMware

Project Management Tools:

Microsoft Office Project Server 2010, 2007 & 2003

Microsoft Office Project Professional 2010, 2007

Rational Rose, HP Quality Center, Fogbugz

Test Tools:

HP QuickTest Professional, HP WinRunner

AutomatedQA - TestComplete 3, Webperformance – Load Tester

Third Party Controls:

Metalogix - Content Matrix – Migration Software for SharePoint 2007, 2010 and 2013

Metalogix – StoragePoint

Kendo UI Grid

K2 Black Pearl, Nintex

Infragistics NetAdvantage for .Net, Telerik RadControls for ASP.Net – AJAX

Dundas Chart for ASP.Net, Dundas Chart for SharePoint, Dundas Chart for Reporting Services

PGP Encryption, Rebex FTP Software, Bamboo Solutions

Utilities: Symantec Backup Exec 12.5, Remote Agents - SQL Server 2005, 2008 and SharePoint 2010

Accounting Software: Microsoft Dynamics AX, Microsoft Dynamics SL (Solomon)

Security Clearance: Full Secret (DOJ)

Masters of Science in Information Systems Technology (GPA 3.5)

George Mason University, Fairfax, Virginia - School of Information Engineering and Technology

Primary field of study: System Development

Bachelor of Science in Accounting (GPA 3.0)

Frostburg State University, Frostburg, Maryland

Minor in Business Administration

Certified Public Accountant - Passed CPA exam on first attempt.

Project Management Professional

ITIL V3 Foundation Certificate in IT Service Management

Certified Information System Security Professional

Board of Directors Federal Reserve - Washington DC 04-2016 to Present

Developed a series of SharePoint applications that regulated access to the Boards highly confidential data. These systems were hosted in SharePoint 2016. They were constructed using jQuery, Font Awesome, KendoUI, Backbone and ASP.NET MVC. SQL Server 2016 was the database. Additionally, developed three .Net MVC applications using Visual Studio 2017.

Department of Agriculture - Washington DC 11-2015 to 4-2016

Developed a series of custom SharePoint stylesheets that were used throughout the organization. Installed the ArcGIS Maps for SharePoint web part and worked with ArcGIS staff to configure.

District Department of Transportation - Washington DC 9-2012 to 9-2015

SharePoint 2013:

Developed a SharePoint 2013 environment consisting of two front end SharePoint Web servers, two SharePoint SQL Servers (one active one passive), an office web application server, an app server and a large document storage server.

Created a dedicated public facing SharePoint 2013 environment consisting of a Front End Web Server and SQL Server 2012 backend. This site provided the public with a detailed listing of all the organizations policies.

In less than an hour, set up a SharePoint 2013 “Notice of Intent” site. This site is publicly accessible and its objective is to provide the public with notification of road construction in their neighborhood. To facilitate its immediate setup, a third party hosting company was used.

Using Microsoft Word and Access (in a SharePoint environment) created an incident processing application. This application used VBA to populate the information in the new incident form. A SharePoint 2010 workflow notified reviewers and approvers of the form.

Installed the ArcGIS Maps for SharePoint web part and worked with ArcGIS staff to configure.

Migration:

SharePoint 2007 to 2010. I developed a “low impact” migration plan. The objective of this plan was to minimize the impact of migration on the systems end users. Using a phased approach, and repointing the navigation menus, all content was moved and the impact on end user was minimal. Content was migrated, using Metalogix Content Matrix.

SharePoint 2010 to 2013. The “low impact” migration plan developed earlier was used again. A series of training on SharePoint 2013 for end users was added. The training emphasized the “Check In Check Out” process, the ability to edit user documents in the browser and the use of new Project Site templates. As in the 2007 to 2010 migration, content was migrated, using Metalogix Content Matrix.

Development:

Electronic Procurement Management System - The purpose of this system was to track the status of the organizations procurements. It consisted of:

6 SharePoint web parts

SQL Server Database (16 Tables, 28 Stored Procedures, 4 Views)

16 SQL SERVER Report Writer Reports

5 Document libraries

Inspector Weekly Status – The purpose of this system is to record the activities of DDOTs road inspectors. It consisted of:

4 SharePoint web parts

SQL Server Database (11 Tables, 23 Stored Procedures)

10 SQL SERVER Report Writer Reports

Document Finder – This SharePoint feature is called from an icon in the ribbon of a document library. It lists all the files in a document library and lists a link to them. For libraries that have a complex folder structure, this feature makes finding files a snap.

Meeting over 1 Year Identification and Correction – A SharePoint feature, this application is called from a link in site settings. It presents a page that lists all recurring meetings over one year in length. To reset the meeting to a one-year length the administrator presses a button. The system presents the meeting in the edit mode allowing the administrator to make the required adjustments.

Meeting Conflict Notification – This SharePoint feature prevents the double booking of a meeting room. On the save event this program checks for a double booking conflict. If a conflict is found, the save is prevented and the user notified of the conflict.

National Oceanic and Atmospheric Administration – Silver Spring 11-2009 to 8-2012

Microsoft SharePoint Architect responsible for the administration of the “Port of Call” the NOAA (OCS) SharePoint site. Initially a SharePoint 2007 portal, I converted the site to SharePoint 2010.

Working closely with the NOAA (OCS) staff, I constructed over 30 sites that provided the organization with a centralized place to work. This effort retired 8 independent web sites.

Customized Microsoft 5 “Fabulous 40” templates

Define audiences for different company departments and locations.

For the portal branding, create external cascading style sheets and attach it to the main master page.

Develop different types of SharePoint WebParts and ASP .Net WebParts using C# as well as custom Workflows.

Define custom site templates depending on the needs of each department.

Design and develop InfoPath forms and make use of web services for cascading drop downs.

Responsible for applying latest updates and monitor farm health and maintain services.

Provide support to users during pilot testing.

Conducted a series of training classes to introduce OCS users to SharePoint

Installed and configured Project Servers 2007 and 2010

Configured incoming and outgoing email

Configured Syntergy Replicator to provide a remote failover site and to assist in the migration to /SharePoint 2010

Created a “SharePoint” development process that incorporated Agile development practices

US Department of Justice / White House - Washington DC 11-2008 to 11-2009

Senior Developer on the Department of Justice’s, Cyber Security Assessment and Management System (CSAM). CSAM is a web-based Federal Information and Security Act (FISMA) compliance toolkit. Developed by DOJ, it is now used by over 65 federal government agencies.

The development methodology made use of a number of “Agile” methods. Particularly productive was the iterative approach. It allowed the “look and feel” of the system and several of its key processes to be refined by several iterative reviews.

Deployed SharePoint 2007 as the bug tracking and release management system for a series of custom .Net projects.

Developed the “Customizable Dashboard” feature. This feature identified the organization systems security status on a one page dashboard. This system used 21 SQL Server stored procedures, 10 Visual Studio 2008 forms and several Infragistics controls.

Developed the “CSAM Unified Point of Contact” feature. This feature replaced four separate contact systems with a single contract screen. This system required the use a detailed SQL Server 2005 conversion script, 5 Visual Studio 2008 forms and several Dundas controls.

Senior Developer on the White House directed CyberScope System. This system is used by over 600 federal entities to submit FISMA information. Its development required the use of Crystal Reports 11, Visual Studio 2008, Dundas and Infragistics controls.

Performed a “load test” to determine the number of concurrent user for the CyberScope system. This was accomplished using the “Web Performance Load Tester 4.0” tool. This test required the approval of the tool by the DOJ IT Software Group, detailed co-ordination with the DOJ Network staff.

Severed as the CSAM 508 Compliance Officer

Hanger Orthopedic, Inc. April 2008 to June 2008 (Short Term Assignment)

A web based invoicing system; the application was developed using Microsoft Visual Studio 2008 Team Suite, C# and SQL Server 2005. The system made extensive use of Telerik web controls.

The project started using a traditional functional requirements gathering but due to a fast approaching deadline and the “newness” of the process, the project adopted the agile approach to software development. The result was a project that was deployed on time, and within budget.

My role in the project was as the programmer of the most important screen, “OPS Data Entry Screen”. This screen was the starting point for invoice generation. Additionally, I developed the screens related to user movement through the system.

Created, maintained and trained user in the use of a SharePoint Team site, built from a “fab forty” site template, to record project documents, source code and bugs.

American Capital Strategies, Inc. January 2004 to March 2008

Installed the organization first SharePoint site (SharePoint 2003) In this site, Project Server 2003 was installed and evaluated by the IT Project Staff. Created and trained the end users in SharePoint 2003 and set up over ten departmental sites.

Originally hired to initiate the PRiSM project and bring the project to the state were it could be managed by in-house staff. My accomplishments as Project Manager were:

Responsible for defining and documenting the project scope

Initiating the database design

Developing and implementing the hardware requirements

Developing the early prototype code

Wrote initial system requirements

Wrote initial development guidelines

Identified and hired three additional software developers

Turned over management of the project to ACS staff

My next role in the project was Developer. My accomplishments in this role were:

Programmed the initial Journal Entry screen

Developed the general ledger search screen

PRiSM to Solomon interface

My final role in the Project was Test Manager. My accomplishments in this role were:

Trained the testing staff

Documented and implemented the testing process

Wrote initial test plans

Identified and programmed testing software (HP QuickTest Professional)

Trained development and testing staff in the use of the bug tracking software HP Quality Center (initially Fogbugz)

In addition to the above, I developed several applications to automate routine accounting functions. These applications are:

Check Reconciliation – A windows service, this application used the file watcher tool to “wake up” when the bank deposited an encrypted file onto an ACAS server containing canceled checks. This program then performed the following steps:

Unencrypted the file

Placed the cleared check amount in the Microsoft Dynamics SL Accounts Payable System

Emailed to the administrator the success or failure of the process

Expense Report Validation - A windows service, this application was scheduled to run once a day. It validated employee logins and email accounts against active directory. If an employee login or email was not found in Active Directory, the system emailed the administrator.

Expense Report Single Login – ASP.Net web application, this system extracted the Active Directory login of the user, encrypted it using RC4 algorithm and passed it to the Expense Report System. This system allowed the user to enter the Expense Report System without re-entering Active Directory credentials. It is very popular with heavy users of the system.

Expense Report Systems Interface to Accounting System – Developed initially for the PRiSM system and then adapted for the Expense Report System, this windows service application “woke up” on a scheduled basis and extracted approved expense reports and inserted them into a Microsoft Dynamics SL system using the systems api.

Bank Feeds – Created several windows services that performed the following process:

1.In accordance with a pre-defined schedule “Woke Up”

2.Selected the financial information

3.Using PGP software, encrypted the information

4.FTP’ed the information using a third party tool (Rebex FTP Software)

5.Created and sent an email documenting the success or failure of the operation

NASA July 2003 to January 2004 (full time)

February 2004 to June 2013 (part time)

Installed and maintained SharePoint 2003 and 2007 on several servers. Trained end users in its use and built over 15 sites. Installed Project Server 2003 and assisted in its evaluation by Goddard Staff.

Initial System - Transformed the NASA “Next Generation Integrated Network” (NGIN) project management system from a single project system to a multiple project management system. The “Multi” NGIN system allowed large numbers of related projects to use the same system. This single system provided an efficient and effective way for NASA to manage a complex series of related projects.

The system was developed using ASP with a SQL Server back end. My role in the project was Senior Developer. Developed and implemented the multi user approach. This required the editing of 37 existing ASP pages, the creation of 10 new pages and over 21 stored procedures.

Additionally, installed a Crystal Reports based reporting system.

System Re-Write – The NGIN system was re-written to be deployed in a SharePoint Portal Server 2003, later upgraded to the SharePoint MOSS 2007 with SQL Server 2008 database. This system has served as the standard configuration management system for NASA Goddard Space Flight Center.

BAE (Pointe Technology, Inc.) July 2002 to July 2003

Developed a project budget system for the Nuclear Submarine Division. This system retrieved information from the organizations Oracle based accounting system and inserted into the Oracle based project budget system.

The system was developed using ASP.NET with an Oracle database backend. This system had 16 forms, 12 Crystal Reports and made extensive use of Oracle stored procedures. The most complex part of the project was a weekly accounting information retrieval stored procedure. It queried the BAE accounting server, retrieved the updated accounting information and converted it into the project budget format.

My role in the project was project manager. I was responsible for the gathering of the initial requirements, putting together the bid and all project billing. I supervised a staff of four; a full time programmer, a part time dba, a part time programmer and a part time tester.

I programmed the Budget Reports, Budget Entry Modification forms. I wrote over 35 Oracle stored procedures as well as 50% of accounting information retrieval queries.

Contact this candidate