SUMMARY:

• SharePoint Administration and Development - 10+ years
• Project Server Administration and Development 10+ years
• SQL Server 15+ years
• Database and Software Developer, Analyst, Project Manager, Development Manager.
• Extensive development experience with SQL Server and .NET (C#, VB, ASP. NET, ADO.NET).
• Substantial experience analyzing requirements, designing, building and implementing system solutions for Manufacturing, Supply Chain Logistics, Finance, Human Resources and Local Government.
• 20 years Software Development and Systems Integration in dedicated and mixed roles
• 15 Years of successful Sales and Sales Management experience
• 6 years Small Business ownership

TECHNICAL SKILLS:

Industries: Manufacturing, Logistics, Finance, Utilities and Document Imaging

Functional Areas: Database / Software Development, System / Business Analysis

Technologies: SharePoint (2003, 2007, 2010, 2013) Project Server 2007, 2010, 2013), SQL Server (2000, 2005, 2008, 2008R2, 2012, 2014, 2016) SSRS, PowerShell 2.0, MS Project, Visual Studio 2003/2005/2008/2010/2012/2013 , C#, VB.NET, ASP.NET, Excel Services, HTML, JavaScript, CSS.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

SharePoint / Project Server Consultant

Responsibilities:

• Collaborated with third party consulting firm to complete production Project Server 2013 implementation.
• Migrated production farm functionality back to User Acceptance Test Farm, System Integration Test Farm and Development Farms to reestablish valid and useful development and test platforms.
• Repaired and in some cases recreated SSRS reports to improve accuracy and performance.
• Meet with the business to collect and document the business requirements, functional requirements, use cases and then produce new functionality in SharePoint and Project Server.
• Designed and implemented ten Nintex workflows to route files submitted to existing Project related SharePoint sites through subject dependent approval processes.
• Created 27 separate PowerShell scripts to deploy and publish these workflows to the existing project sites and additionally to add, modify and augment the Libraries, Item fields, Folders, Views and permissions of these 350 existing Project related SharePoint Sites.
• The PowerShell scripts were created to accomplish current requirements and also to position the organization to make mass future modifications to the hundreds of Project SharePoint sites as new requirements are presented by the Business.

Tools: ets used include: SharePoint 2013 & 2010, Project Server 2013, PowerShell, SharePoint Designer, Excel Services and Nintex Workflow for SharePoint, Nintex for Project Server 2013, SQL Server2012, 2014 & 2016, SSRS (Reporting Services), Excel Services (Project Server BI Center) and Fluent Books.

Confidential, Raleigh, NC

SharePoint Consultant

Responsibilities:

• Engaged to working through a demand backlog for Site refinements and new SharePoint Applications for Generation Technical Applications Group.
• Also providing training to internal developer resources and end users.

Tools: ets used include: SharePoint 2010, SharePoint Designer, Nintex Workflow, InfoPath forms, Bamboo Controls, JavaScript, JQuery, and AJAX.

Confidential, Oxford, NC

Manager, SharePoint Development / SharePoint & Project Server Administrator

Responsibilities:

• SharePoint and Project Server Administrator on Production, Test and Development Farms. Develop SharePoint solutions and manage a team of six SharePoint focused developers.
• Production Farm includes 500+ Sites, 200+ applications and 400 Projects each with a Project Workspace. Production Content includes approx. 8 Million files.
• Collect and Analyze requirements from user departments
• Scope, create and implement wide variety of SharePoint applications.
• Create and maintain Content Types and Features.
• Conduct SharePoint, Project Professional and Project Server user training. Support a population of 4000 SharePoint users and 750 Project Server users on six continents..
• Educate Business owners on Site Collection security and governance.
• Migrate new Sites and Applications from Development to QA and ultimately to Production Farm
• Troubleshoot and repair SharePoint Site and Application issues.
• Work closely with PMO and Project Managers on active Projects across the Enterprise.
• Restructure SQL Server Content DBs to maintain ease of migration and balance.

Tools: ets used include: SharePoint / / 2013, SharePoint 365, Project Server / 2010, PowerShell 2.0, SharePoint Designer, Nintex Workflow, InfoPath forms, Bamboo Controls, C#, JavaScript, SQL Server R2, / 2012, SSRS, SSIS.

Confidential, Jefferson City MO

IT Project Manager / Technical Lead / Interim IT Manager

Responsibilities:

• Identified roadblocks to project completion, quantified approach to each issue and coordinated the application of development resources to address these challenges.
• Served as member of Core Team assisting the business in refining remaining requirements and in doing so protected the project from what had been habitual and substantial scope creep.
• Mentored 12 Developer direct reports.
• Provided the functional areas of the business with a single point of contact for project’s IT assets. Made very positive impact on each developer’s ability to stay focused on completion of goals and the forward momentum of the project in general.
• Developed DB processes and interfaces between Engineering, ERP and MES.

Confidential, Jefferson City MO

Consultant Software Engineer

Responsibilities:

• Designed and created VB.net and C# programs and complex SQL Server Stored Procedures to load existing Parts; constructed and loaded Bills of Material and manufacturing routing instructions to new MRP and MES systems.
• Created automation processes to integrate newly designed parts data from Engineering design system to MRP and MES.
• Replaced Mainframe program used to attribute and validate part and structure information prior to submission to MRP.

The software tools used include: SQL Server 2005 including TSQL, Stored Procedures and Business Intelligence Development Studio (SSIS and SSRS), VB.NET, C#, ADO.NET (VS 2005) and BizTalk.

Confidential, Cary, NC

Consultant Software Engineer

Responsibilities:

• Engaged to resolve a list of defects in the release candidate version of the software.
• Executed Test plans to verify and isolate problems and make code modifications then resubmitted for testing and acceptance.
• Identified and created missing functionality detailed in the design specification but not implemented in code.

The technologies used include: C#, VB (COM), HTML, XML, CSS and the Excel and Word Document Object

Confidential, Raleigh, NC

Senior Business Analyst (Consultant)

Responsibilities:

• Created analytical tools for this Practice to be able rapidly acquire and process client data to identify opportunities to cut cost and improve processes.
• Automated and standardized tools to speed client supplier restructuring processes. Resulted in the ability of the Practice to bring cost reductions and improved financials to its clients more rapidly.
• Provided IT expertise and application development to Managed Transportation Department functions provided by this practice to its clients including Web Site to provide supplier Motor Carrier shipping instructions based on load type and Origin point Zip Code.

Technology employed includes: VB.NET, Access, ASP.NET, ADO.NET, Data Access Layer and SQL Server 2005 as well as Excel and Word automation.

Confidential, Cary, NC

Software Engineer

Responsibilities:

• Integrated a large and critical proprietary customer software system into the Confidential (WMS) Warehouse Management System.
• Created, tested and implemented custom modification into Confidential ’s standard Warehouse Management and Transportation Management Logistics application software system.

Tools: used: C#, VB, C and Oracle.

Confidential, Rocky Mount, NC

Software Developer and Project Manager (Consultant)

Responsibilities:

• Stabilized existing versions of released Document Imaging software products (VB6, SQL Server 2000)
• As part of a two person team, designed and created the next generation of the company’s product set using (Visual Studio 2003) VB.NET, ADO.NET, Active Reports, Visual SourceSafe, On-Time development task / defect tracking and SQL Server 2000).
• Provided direct Customer Support for difficult and technically complicated issues
• Collected customization requirements and produced Functional and Design Specifications as well as Scope document to clarify and quantify (as a post sale activity) customer expectations and requirements.
• Created dozens of add-on and utility programs for the existing Customers
• Researched and then documented the applications’ embedded workflow architecture to help the company to better support its’ customers.
• Managed the custom implementation of several key client systems.

Tools: used: VB and SQL Server.

Confidential, Morrisville, NC

IT Development Manager

Responsibilities:

• Led a team of six developers and one technical writer.
• Worked with the business leaders and user departments to gather, analyze and refine application requirements.
• Authored the Functional Specification, Design Specification and Application Scope documentation.
• Built and presented annual Budget request for required resources.
• Produced development and national deployment plans
• Designed Application and Database Architectures for these enterprise scale systems.
• Managed the development, integration and deployment of several enterprise-wide systems.
• Coordinated the activities of the development team and directly participated in development activities.
• VB6 / VB.NET / ASP.NET application to support the annual performance and compensation review process.
• The application tracked the entire organizations progress toward completing the annual review cycle. It provided each level of management with a view of their subordinates as well as subordinate organizations to provide opportunity for intervention and corrective actions if planned compensation increases would violate budget constraints. It allowed each manager to conduct “what if” analysis, to determine if intended compensation increases would fit into their assigned budget.
• Repaired and dramatically extended the capabilities of a third party (VB6) Image enabled Accounts Payable workflow approval system. The system is operated by hundreds of users, located across the United States and Canada, with varying limits of signature authority and houses millions of documents. The system has dramatically reduced costs and improved the organizations ability to negotiate payment terms.
• Accomplished Integration of the Imaging system to Web Based Financial Analytics to provide source document visibility.
• Designed and deployed a suite of Image enabled Invoice Audit systems to identify incorrect payment and overpayments to vendors.
• Produced a Web-enabled (ASP.NET) time and attendance application that collected data from approximately 600 time clocks located in 28 States, populated that data to a SQL Server then presented it for editing and approval to geographically dispersed clerks and region Payroll managers. After completing the process, data submitted to external payroll application.
• Designed, piloted and deployed SharePoint portal server for document collaboration; information dissemination; software distribution and dozens of other uses.
• Migrated the five major divisions of the company to a Standardized Financial (Hyperion Essbase) OLAP models.
• Created a consolidated national financial model and using automation, pulled the financials of five Divisions and their twenty to support streamlined analytics and month end consolidation to the UK parent company.
• Handled modification, maintenance and Excel based (VBA intensive) reporting.
• Created a VB6 application front end application and SQL database to collect major mobile equipment usage data and produced an (Hyperion Essbase) OLAP cubes and reporting system to support monitoring costs and to provide analytics that were essential for creating capital expenditure request for heavy equipment purchases

Tools: Microsoft VB.NET, Visual Basic, VB Script, VBA, Access, Excel VBA, ASP, SQL Server, Essbase (On Line Analytical Processing Database), Legato (Application eXtender) Imaging, SharePoint Portal server, Crystal Reports and MS Project). The Back end severs were Windows (2000 and 2003) with SQL Server 2000 as well as DB2 on an I875 Series IBM AS400.

Confidential, Raleigh, NC

Managing Partner / Software Developer

Responsibilities:

• Designed, developed and implemented the North American In-Bound Freight System for Confidential .
• The system was used to manage supplier shipping permissions, Motor Carrier assignment, delivery scheduling, on-site trailer inventory tracking, security and receiving operations at (3) one million plus square foot distribution centers.
• It offered visibility to Warehouse, Manufacturing, Planning and Purchasing as well as handling consignment shipments to third party locations.
• The system was tightly integrated to the client’s Oracle Financials.
• A membership tracking and donations development system for a sizable Non-Profit organization
• A Manufacturing plant scheduling system, a backorder tracking system for materials purchasing and a variety of other interesting solutions.