Sql Server Sharepoint

VITO VITTORE

(***) *** – ****

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

I am a Senior Microsoft .NET architect and developer, with over 20 years experience creating and re-organizing systems and solutions. I am looking for a position that will utilize and grow my extensive knowledge and personal interaction skills in order to create new solutions for your old problems.

TECHNICAL COMPETENCIES

Languages Jquery, Javascript, C#, VB.NET, ASP.NET, Visual Basic 6.0, VC++, XML, C, Java Database Oracle, SQL Server 2008, SQL Server 2005, Access, dBase, Btrieve Software

SharePoint 2010/2013/2016, 3.0, Entity Framework, MS Visual Studio .NET, SQL Server Reporting Services

EDUCATION

Boston University, Boston, MA Masters of Information Systems, MIS DePaul University, Chicago, IL BA, Accountancy

SETFOCUS, LLC, Parsippany, NJ Certificate, C# Masters Program CERTIFICATIONS

MCTS : .NET Framework 2.0 - Windows Applications

MCTS : .NET Framework 2.0 - Web Applications

MCTS : Microsoft Windows SharePoint Services 3.0 – Application Development MCSD

PROFESSIONAL SUMMARY

Alight Solutions May 2017 – March 2018

SharePoint Architect

Aon April 2011 – May 2017

SharePoint Architect

Aon is a primarily re-insurance company that has a variety of related businesses. One of those businesses was a human resources and benefits administration company which Aon sold off and the new owners renamed as Alight Solutions, where Mr. Vittore has accomplished the following:

SharePoint

Designed and wrote a series of business processes utilizing a Dedicated 365 Cloud farm that could be utilized by associates across the globe.

o Wrote multiple custom new and edit forms using SharePoint Designer editing the HTML and adding javascript/jquery to give the form additional capabilities and validation. o Wrote multiple workflows using SharePoint Designer utilizing custom task forms, re-occurring phases, and REST calls to give users a full experience with optimal security and ease of use. o Wrote multiple aspx pages for a pleasant, invigorating home page experiences and specific editing and reporting functionality.

o Ran multiple design meeting with users to pull out requirements and data structures needed for an upcoming system. o Managed users to ensure that projects were completed with satisfied stakeholders in a timely fashion.

Acted as a one-man consulting shop instructing associates from a variety of divisions to help instruct and troubleshoot problems that occurred on multiple SharePoint farms located throughout the company. o Did spec work on ideas proposed by different departments so managers can make informed decisions on how to proceed. o Sat down with users to explain the capabilities of our SharePoint Dedicated farm in order to increase usage and acceptance of the company’s SharePoint investment.

o Helped users on an ad-hoc basis to solve problems and answer questions with SharePoint. Users would get my contact information from other users in the company that would recommend me.

Worked on teams responsible updating and transferring information from depreciated servers to servers that would be exclusively used by Alight Solutions and external clients.

o Maintained a PnP provisioning program in order to ease the creation of new sites on the farm. o Created multiple powershell scripts to deploy various files to enhance functionality among client sites and help convert the User Profile service to a new domain.

Office Add-Ins

Designed and wrote an Office Add-In for Outlook utilizing COM+ Office Interop. The add-in accessed a 3rd party database to look up clients, added a dialog to allow custom properties to be added to selected emails, a display panel a review at a glance the properties selected for an email, and an options dialog to select language, process options, and diagnostic logging information. VISANOW April 2009 – April 2011

Software Architect

VISANOW is an internet legal firm that specializes in U.S. visas, international visas, and I-9 employment compliance, where Mr. Vittore has accomplished the following:

.NET Architecture

Designed and wrote a series of business tier DLLS that utilized the ADO.NET Entity Framework. These DLLs replaced a series of hard-coded SQL calls and stored procedures and allowed for increased flexibility and complexity. Designed and built a Product DLL which allowed the company to expand to new products, like international visas and I-9 employment. Designed and built a Finance DLL to handle different payment types, track fees for various types of products, and give discounts to various company and product combinations.

For Questionnaire reorganized the SqlServer question tables for easier maintenance, foreign languages, and pagination. Questionnaire page rewritten with jquery to save answers with callbacks and go the next and previous page of questions.

Designed and implemented a database and business classes using Modularis for a system to enter and store I-9 information. This system also allowed users to access the E-Verify system with full functionality through the website. Windows SharePoint Services

Designed and implemented a Record Center site to hold all the documents submitted by clients. This site allows a client to email or upload a document to the website. A workflow then starts that assigns the document a content type, inserts the document into the proper list, and loads the content type fields from the database. A custom web service was built to allow web site users to view the documents that they submitted. This company has submitted this process for a patent.

Designed and coded a web part that lets the lawyers and paralegals view and approve documents submitted by clients. This web part allowed employees to arrange the documents in order and send emails to clients.

Wrote a SharePoint timer job that creates a weekly spreadsheet sales report.

Upgraded a custom SharePoint web service to utilize Windows Communication Foundation.

Oversaw a conversion from SharePoint 3.0 to SharePoint 2010. Encore Consulting Services, Inc. Sept 2004 – Feb 2009 Senior Microsoft Developer and Architect

As a consultant with Encore Consulting Services, Mr. Vittore has accomplished the following: Windows SharePoint Services

Designed and wrote a .NET ASPX data entry screen that displayed the scanned invoice, allowed line item entry by GL account/sub- account, and saved the results to the appropriate SharePoint list using VS 2008 and Javascript.

Helped designed and code the SharePoint sequential workflow to assign an invoice to the appropriate user. Used VS 2008 to derive a list from the content type Workflow Task.

A set of webparts written in C#(2008) which contains and ASP.NET(2008) user control with ASP AJAX. The user control allows users to create and edit items selected from the list webpart utilizing LINQ (via a connection object). All data is stored in a SQL Server 2005 database and updates the SharePoint list.

An insert/edit form, utilizing SharePoint Designer, which edited data in a list. Made extensive use of javascript and ASP.NET controls to apply business rules to the user entries.

An insert/edit form, utilizing SharePoint Designer, which replaced paper forms for employee evaluation. Layed out the new online form based on the old paper forms. Edited a SharePoint workflow to ensure that the proper employees received the correct email notifications.

.NET Web Applications

Analyzed, designed and built a series of classes and stored procedures utilized in a capacity planning ASP.NET 2.0 web application utilizing ASP AJAX controls. Supervisors used the application to assign time to employees for different tasks. Lab managers then used this information to best utilize laboratory hours. Senior supervisors could view the assignment information to improve product turnaround times. Designed and implemented the procedure to update the Oracle database from two data sources.

.NET Enterprise Applications

Analyzed, designed, and built a series of applications to replace mainframe legacy applications. One application was a custom FTP server (installed as a Windows Service) that immediately parsed, verified, and saved an incoming file to the proper SQL Server table and responded to the sender the result of the file transfer. Wrote a series of applications in VB.NET that allowed the client to schedule a series of daily and monthly operations running under a single transaction state. Implemented practices and procedures for future .NET projects for a client that had very limited .NET experience. Assigned as the main technical contact to the programming team on the project. Used as a spot-on resource on other internal projects when roadblocks occurred with Web security, database image storage, and the Crystal Reports Web Control.

As part of a 25 man team for a financial services client, wrote a series of C# business objects that tracked the progress of a portfolio valuation from initialization to approvals to publishing. At the start of the process a series of reports had to be saved to the database to be recalled by the presentation layer. Created a process utilized by SQL Server 2005 to store the report information into a SqlXml column enforced by and XML Schema.

Wrote a Windows application in C# (2005) that sent and read messages from a Websphere MQ, a Microsoft Sql Server, and a web service. Devised a business class to allow easy non-compile alteration of the output XML document with input field assignments.

Designed and implemented a process to encrypt credit card information to a SQL database.

Analyzed, designed, and built a series of applications that takes multi-national sales data from each franchise and posts them to the Accounts Receivable system. The system had the following capabilities: captured electronic revenue statements over the Internet, allowed manual entry of revenue statements, calculation of royalties due the corporate office, supervisor overrides of entered amounts, automated estimations for franchises that do not submit a revenue statement, and postings to an A/R journal on an AS/400 system.

Microsoft Sql Server

Upgraded the three production and one development environment from SQL Server 2000 to SQL Server 2005. Responsible for creating the upgrade plan, creating the migration and testing procedures, and creating and testing the upgrades in a ‘sandbox’ environment. Ensured the backward-compatibility (especially for DTS objects) was maintained.

Optimized a SQL Server 2000 database by removing cursors from the stored procedures and adding indexes to the tables which resulted in an 80% reduction in the execution plans. Optimized a series of ASP classic pages with code and stored procedures which reduced roundtrips to the database from 120 to 24.

Altered a series of SQL Server 2000 stored procedures to utilize multiple warehouse centers instead of one warehouse center. Responsible for creating test data and documenting the changes to the stored procedures.

Installed, written numerous reports, and enacted security for Reporting Services 2000/2005.

Taught a three day course in SSIS modules which included on-line debugging, script objects, and deployment and a one-day seminar on the new features of Sql Server 2005.

Analysis & Design

Presented with a problem of how best to represent data from numerous companies over a series of years (going 15 years back and into the future). Designed a database that would allow the company entities to be represented within a given time slice (initially one year but could evolve into quarterly). The database deign had to reflect multiple addresses, contact personnel, subordinate companies, and parent companies. Time slicing also had to be utilized to indicate which lines of business a company was operating and in which markets. Designed a n-tier architecture for the web site to allow for easy reuse of any stored procedures and business objects.

Key Auto Finance July 2002 – July 2004

Senior Analyst

As part of a team, built a multi-tiered, multi-phase replacement system in Visual Basic 6.0 for an automobile loan origination system written in DOS FoxPro. Overhauled the business middle tier and the front end. The overhaul resulted in an application reduction of maintenance and errors. The tasks that he delivered included:

Managed a team of 3 developers as a hands on technical lead; programmed the credit analyst phase in Visual Basic 6.0, ensured deliverables were on schedule and mentored team on middle tier development.

Designed and programmed a COM+ object that received applications from DealerTrack (via WebMethods) and wrote the results to an Oracle database heavily utilizing XML. The COM+ object allowed 95% of the loan applications to be electronically entered increasing dealer loan process-reducing turnaround time by 3 hours per application.

Resolved issues through various releases of the product as direct customer liaison, maintained excellent client relationships. Covansys (formally CBSI, C.W. Costello & Associates) Sept 1994 – Feb 2000 Senior Consultant

Assigned to the Medical Delivery Application Project. Designed, programmed, tested, and documented the business classes and the front end screens in Visual Basic 6.0. Applications interacted with a map program to schedule driver routes and a bar-code printer to print labels for the drivers. Wrote stored procedures, designed databases and implemented a backup plan for SQL Server 7.0. The program was used by company founders as a sales tool to demonstrate to medical lab clients delivery route capabilities.

Conducted tech interviews on potential new hires and taught beginning and intermediate classes in Visual Basic and Access to employees as well as developers.

Discovery Products April 1992 – Sept 1994

Senior Programmer Analyst

Designed and wrote commercial software for lawyers to add notes to witnesses' depositions entirely in Visual C++ utilizing MFC. As part of a team, he designed the internal class structure of the application. The tasks that he delivered included:

Fashioned the classes that searched, parsed and indexed every word of a deposition document, then loaded the deposition contents into an internal database.

McClure Consulting Feb 1990 – April 1992

Consultant

Wrote a series of Windows 3.1 programs in C and Visual C++ using the MFC. He interfaced with SQL Server, Oracle, Access, and Btrieve using DAO. Wrote a security system used for a series of applications saving consultant time and increasing consistency to security operations in VC++. The tasks that he delivered included:

Created a DLL interface and timeout functionality based on keyboard typing and mouse movements.

Created two sub-classed listboxes acting in unison to implement translation functionality; listboxes were synchronized to match to the proper phrase, preventing the user from typing in a phrase with too many characters or dialog units, and seamlessly load and unload portions of a very large Btrieve table; allowed users to implement the application for another language quickly.

Contact this candidate