Project Server Administrator / Sharepoint & Sql Developer Resume
Charlotte, NC
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 .NET (C#, VB, ASP . NET, ADO.NET).
- Substantial experience analyzing requirements, designing, building and implementing system solutions for Manufacturing, Supply Chain Logistics, Finance and Local Government.
- 20 years Software Development as an individual contributor and as a member of a team.
- 15 Years of successful Sales and Sales Management experience
- 6 years Small Business ownership
SKILLS:
Industries: Manufacturing, Logistics, Finance, Utilities and Document Imaging
Functional Areas: Software Development, Database, System and Business Analysis
Technologies: SharePoint, Project Server, SQL Server (2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017) SSRS, PowerShell, MS Project, Visual Studio, C#, VB.NET , ASP .NET, MVC. .NET Core, Excel Services, HTML, JavaScript, CSS.
PROFESSIONAL EXPERIENCE:
Confidential, Charlotte, NC
Project Server Administrator / SharePoint & SQL Developer
Responsibilities:
- A SharePoint Site is structured under each Project. Using PowerShell, I have scripted dozens of SharePoint Site additions and modifications. Some of the scripts deploy and publish Nintex Workflows, add and modify SharePoint Groups, folder structures, lists, libraries and views.
- Scripting these changes provide a consistent and productive way to deliver requested modifications to the business while maintaining the structure of hundreds of SharePoint Sites ‘standard’ and the same.
- Repaired, replaced and created SSRS reports inside the Project Servers’ Business Intelligence Center to improve performance and accuracy as well as increase the value of the reports.
- I redesigned one particularly complex report and improved presentation time from 12 minutes to less than 10 seconds.
- I constructed approximately 40 new (SSRS) reports.
- The Project Server instances require very little attention now.
- The instances are running well and perform as expected. Most recently I have become part of a team building an External User authentication system.
- My contributions include the design and implementation of the underlying SQL Server database. I designed and built all of the Tables, Stored Procedures, Functions and Triggers for the project.
- I am using C#, ASP MVC and .NET Core as a member of the team coding this application.
Tools: used include: SharePoint 2013, Project Server 2013, SQL Server 2012, 2014 & 2016, SSRS (Reporting Services), PowerShell, SharePoint Designer, Excel Services and Nintex Workflow for SharePoint, Nintex for Project Server 2013, Visual Studio 2017, C# .NET Core, Excel Services (Project Server BI Center), Sharegate and Fluent Books.
Confidential, Raleigh, NC
SharePoint Consultant
Responsibilities:
- Successfully worked through a substantial backlog list of SharePoint Site refinements and new SharePoint Application requests for The Confidential Generation Technical Applications Group.
- Also provided to internal developer resources and end users.
Tools: used included: SharePoint 2010, SharePoint Designer, Notepad ++, Nintex Workflow, InfoPath forms, Bamboo Controls, Chrome Debugger, JavaScript, JQuery, SPUtility and AJAX.
Confidential, Oxford, NC
Manager, SharePoint Development / SharePoint & Project Server Administrator
Responsibilities:
- Production Farm includes 500+ Sites, 200+ applications and 400 Projects each with a Project Workspace (SharePoint Sites). 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.
- Conducted SharePoint, Project Professional and Project Server user . Supported a population of 5000 SharePoint users and 750 Project Server users across the world.
- Educated Business owners on Site Collection security and governance.
- Migrated 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.
- Migrated SharePoint and Project Server from and from .
Tools: ets used included: SharePoint / / 2013, SharePoint 365, Project Server / 2010, PowerShell 2.0, Notepad ++, SharePoint Designer, Nintex Workflow, InfoPath forms, Bamboo Controls, C#, JavaScript, SQL Server R2, / 2012, SSRS, SSIS, Chrome Debugger.
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# and ADO.NET (VS 2005).
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
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
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.
- Hanson Building Materials America, Morrisville NC
- 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 Regions to North American Corporate 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