SUMMARY:

Over 26 years of experience with solution architecture design, software development, and technical management with the past 15 years concentrating on B2B integrations, business intelligence, SharePoint development and customization, and corporate business process automation.

SKILL:

Languages:

Proficient in: C#, SQL, T - SQL, PL/SQL, VB.NET, VBA

Familiar with: Java, JQuery, C++

Software:

Database: Microsoft SQL Server (The entire stack, SSIS, SSAS, SSRS), Sql Azure, Oracle

Platforms: Microsoft SharePoint (versions ), Team Foundation Server (TFS), Project Server, DelTek CostPoint, SalesForce, Tableau Confidential - Student Information System

Development Tools: Visual Studio (versions ), TOAD (PL/SQL), SQL Data Tools

Other Technologies: Azure, Azure Sql Database, Azure WebJobs/Functions, ASP.NET, WCF, Entity Framework, Microsoft Office (including Project Professional, and Visio), TOAD Data Modeler, Azure for development virtual machines.

EXPERIENCE:

Confidential

Lead Architect

Responsibilities:

• Designed and developed the ‘Platform’ that consists of loosely coupled components (providers) that extract, transform, and load data via an orchestration component, all residing in Azure and executed via scheduled and on-demand web jobs.
• Developed Team Foundation Server (visual studio online) source code structure and configuration management processes.
• Developed and evangelized coding standards and guidelines with the team.
• Developed numerous provider libraries to get/push data to business systems including BlackBaud Sky, NetSuite, InforVisual, Invapay, Kronos, Comdata, Salesforce, Infor, ForthShift, CDK, Concur, Namely, BlackBaud, using their specific APIs.
• Developed an Asp.net core MVC Web API to wrap an on-premise Infor implementation. This provided a secure set of end points to pull/push data.

Confidential

Supervisor of Student Information

Responsibilities:

• Implemented SharePoint 2013 to support student data reporting and analysis, task management, issue tracking, and overall organizational reporting.
• Developed automated integrations using custom .NET components support Secure FTP and consume web APIs (SOAP and REST).
• Developed a warehouse in SQL Server 2014 to capture historical and current student data.
• Developed custom solutions to supplement the Student Information System ( Confidential )
• Supported ad-hoc data requests consisting of SQL, reporting services, and Excel
• Developed DEXTAR (Data Exception Tracking and Reporting) system to identify data errors entered by individual schools and links to the appropriate system to reconcile the exceptions.

Confidential

Director of Internal Solutions

Responsibilities:

• Designed, developed, and implemented a data warehouse that pulls data from disparate systems, both financial and HR related, both in-house and in the cloud, into a centralized database to support pervasive business intelligence. On the back-end, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and some custom code, was used to gather, assemble, and prepare the data for reporting. SharePoint 2010/2013 along with Excel, SQL Server Reporting Services (SSRS), Performance Point Services, and other custom reporting capabilities.
• Refined an existing budget and forecast system that consisted of disparate Excel workbooks and multiple systems (CostPoint, Hyperion Desktop, and SalesForce) by centralizing the functionality using Microsoft SharePoint, Office customizations (Excel), and automated workbook generation and parsing. This implementation saved the company up to two weeks of manual, duplicate data entry per month as well as provided comprehensive view the company’s financial status and outlook.
• Using Visual Studio 2013, C#, and .NET, created an Excel Add-On to pull SalesForce data to support self-service pipeline business intelligence. This capability is used weekly for company reviews of pipeline status and forecasting.
• Utilizing SharePoint and some custom code, developed an Employee Appraisal System that captures manager and employee self-assessment data to be used for annual reviews.
• Performed Oracle 11g PL/SQL development for an aircraft maintenance system. Tasks included developing packages and stored procedures that supports a scheduling engine.
• Lead a team that was responsible for developing a SharePoint 2010 custom solution that captured goals, objectives, measures, and SWOT (Strengths, Weaknesses, Opportunities, and Threats) to perform strategic planning. This solution consisted of custom master pages, workflows, web parts, document generators, and a web based graphic powered by Syncfusion. A Scrum-like agile approach was used which included developing and tracking product backlog items in Team Foundation Server (TFS).

Principal Software Consultant

Confidential

Responsibilities:

• Participated in a joint Confidential Gioia/Microsoft team that participated in developing an application for the US Coast Guard. Responsibilities included: developing middle tier code that mapped database structures to domain objects, created templates for visual studio and T-SQL stored procedures, and designed and presented a source control configuration strategy using Team Foundation Server 2008 that aligned with the product teams supporting the agile Scrum methodology.
• Worked on-site with the US Army to design, develop, and implement a vehicle maintenance tracking and reporting system (AIM) using Visual Basic.NET and Microsoft SQL Server 2000. Responsibilities included: Interviewing customers to gather and understand requirements, Designing and implementing a SQL Server database and developing T-SQL stored procedures.
• Utilizing ASP.NET, Visual Basic.NET and Oracle 9, designed, developed, and implemented a web based aircraft maintenance tracking and reporting system (PMCAT). Responsibilities included the development of: a data mode using Sybase PowerDesigner, PL/SQL stored procedures using TOAD, middle tier components using Microsoft Visual Basic.NET, ASP.NET web user interface.
• Supported proposal development, custom solution demos, and other ad-hoc tasks that supported various customer engagements.