Andrew Gettings

Objective

Consultant work for analysis, design, development or management of software systems on a Corp-to-Corp basis.

Summary

Andrew Gettings is the president of Bullseye Consulting which develops and manages customized SharePoint applications and other software and databases for businesses. He has run several businesses, and with over 25 years of experience in computer technologies, can deliver well-designed IT solutions tailored for business.

SharePoint Experience Summary

  • SharePoint 2010 Server Enterprise, Standard and Foundation; WSS 3.0, MOSS
  • Best practices consulting – Microsoft Certified Professional
  • Discover, Analyze, Design, Configure, Develop, Test, Deploy, Train
  • Out of the Box – Farm Configuration, Taxonomy, Content Types, Governance, Workflows, Search Center Customization, Custom Document Libraries, Picture and Video Libraries, Content Deployment, Blogs, Site Templates, List Templates, more

Custom Development

  • Visual Studio 2005, 2008 and 2010, Event Handlers, Custom Navigation, Workflows, Feature Creation Deployment and Management, SP Web Services Consumption
  • SharePoint Designer, Workflows, DataFormWebPart Customization, MasterPage Customization, Page Layouts, Reports

  • Solutions – Branded Web Site via Web Content Management (WCM), Forms Based Authentication (FBA), Anonymous access, Enterprise Content Management (ECM)
  • Third party integration and usage – Knowledge Lake (easy metadata for scanning), Perfectus, Telerik RAD controls (menu (evaluation) and dynamic chart image (used in production)), Bamboo Dataviewer and Rollup (evaluations), Sharepoint Shared Services Search Provider Property Creation (SSSPPC on CodePlex - managed properties migration), Logviewer (CodePlex), more

Languages

C#, VB.Net, XML, XSL, XSLT, SQL, JavaScript, jQuery, HTML, Delphi, Java, C++, VB, ASP

Database

MS SQL Server, Firebird SQL, Interbase, MS Access, ADO, ODBC, SQL, Stored Procedures, Design, Normalization, Optimization

Operating Systems and Virtualization

Windows 2008 Server, Windows Vista, 2003 Server, XP, 2000 Server, NT, others

VMWare Workstation, VMWare Server, VMWare ESX, Microsoft Virtual Server, Microsoft Virtual PC

Web Technology


SharePoint 2010, MOSS & WSS 3.0, ASP.Net 1.0, 2.0, 3.0, 3.5, C# (C Sharp), .NET framework, DotNetNuke, SOAP, XML, XSL, Atlas, AJAX, ASP, JavaScript, VB Script, ADO, SMTP and POP3 (email) Automation

IIS, Application Pools, Client/Server & Multi-tier, Backend (server-side) Development, Web Hosting

CSS, Web Site Design and Maintenance, Search Engine Optimization (SEO)

Experience

 
 

1997–Present Bullseye Consulting Chelmsford, MA

President

Create and manage IT resources.

SharePoint 2010 Clients

  • Kiva Systems – Helped roll out initial implementation of SharePoint for 200-plus users. Led projects for workflows, custom event handlers for site creation. Worked on governance, training, records management, upgrade from Standard to Enterprise, 3rd-party tool evaluations, My Site implementation, etc.
  • Power Plant Management Services – Assist creating special SharePoint site collections for Power Plant compliance.
  • KleenEnergy – Assist moving web site to new SharePont Farm
  • SchoolWorks – Custom workflows with list-based configuration, migration from WSS 3.0 to SharePoint 2010, more.
  • Edimer –Recommendations for using WSS 3.0, help with periodic SharePoint backup
  • First Professional – AJAX charts based on SharePoint lists, import of FTP XML into SharePoint lists using both WSS 3.0 and SharePoint 2010.
  • CakeWalk – Gather requirements and install WSS 3.0.
  • JPal – analyze performance problems and recommend steps for improvement.

  • SkyRope – Maintain ASP.Net web site showing parts and prices is stored in a SQL Server Database.
  • TAC Worldwide Commission Calculations Engine – Help design and write web application which spawns asynchronous threads to determine weekly and monthly values using nine different modules. Designed and helped implement architecture to make each module modifiable without the need to retest and deploy all the other modules.

Tools: C#, ASP.Net, Oracle 9.2, Oracle 8i, SQL, SQL Server 2000, Multiple Asynchronous Threads under IIS, Custom IIS Thread Pools, Dynamically Loaded Class Libraries, Windows Server 2003 Enterprise Edition, CSS

Price Reporting Company:

Sole developer then project manager for many programs.

  • Price Change Alert – Design, implement reports using "push technology" where reports are generated and emailed to customers via custom native Windows 2000 service.
  • Web Reports – Designed, implemented, maintain and host web application and database changes to generate standard and ad-hoc Adobe Acrobat (PDF), MS Excel and HTML reports for categories to which users have subscribed. Administered entire program development life cycle. Provide web hosting.
  • CPR – Provide maintenance work for custom software: additional import formats, tweaking UI, and reports

Tools: Delphi 2-5, Interbase 4.1, Firebird 1.50, SQL, Stored Procedures, IBObjects, Report Builder, Report Smith, ISAPI DLL, JavaScript, Web Application, IIS 5.0, Windows Server 2003, Database Replication, Interdev, Delphi 2.0, Windows NT services, SMTP, POP3, Indy, BDE

Tools: ASP.NET, ASP, .NET framework, Firebird SQL 1.50, Stored Procedures, SQL, HTML, JavaScript, IIS, CSS, Web Design

Tools: ASP.NET, JavaScript, CSS, IIS, Web Design

  • Many others – see below.

2006 - Present Corridor Consulting Burlington, MA

SharePoint Consultant

First Data Corporation

  • Create custom Workflows
  • Customize advanced search center scopes, filtering and output
  • Conditionally populate list item meta-data from parent folder via event handlers
  • Create custom page to permit users kick off specific workflows based on user selections and privileges
  • Migrate managed properties from development using SharePoint Shared Services Search Provider Property Creation (SSSPPC) from CodePlex.

Tools: MOSS, VS 2005, VS 2008, ASP.Net 2.0, 3.0, 3.5, C#, SharePoint Designer 2007, SharePoint features, XML, XSLT

Gulf Oil

  • Design, implement and deploy Enterprise Contract Management (ECM) site

Tools: WSS 3.0, SPD 2007, Knowledge Lake

Pentair

  • Integrate custom multi-level navigation into customized SharePoint master page so that static and dynamic links appear on every page with a menu via two ASPMenu instances

Tools: MOSS, Visual Studio 2005, C#, SharePoint Designer 2007

Invensys

  • Assist in design of Enterprise contract management system for multiple international companies
  • Specify migration of existing MOSS lists with attachments to MOSS document library
  • Evaluate, specify strategy for executive summary

Tools: MOSS

Forest

  • Consult on MOSS implementation, best practices and migration

Tools: MOSS

Centerwatch

  • Prepare to take over role of developer

Tools: MOSS, Infopath

CWCapital

  • Implemented Web Content Management for corporate website – CWCapital.com
  • FBA and anonymous access
  • Use HTML and CSS from design and implement it into two SharePoint master pages (one for splash) and multiple page layouts for completely new look and feel.
  • Set up DMZ SharePoint environment using SQL logins for SharePoint (yes, this can be done without AD or Windows login).
  • Create custom navigation integrating with .Net navigation provider
  • Implement multiple dropdowns on single page layouts to dynamically filter data on DFWP (dataform webpart)
  • Custom user controls for news spotlight, other functionality
  • Integrate Telerik RAD tools Chart Image with SharePoint for dynamic graphs
  • Implement WCM approval workflows

Tools: MOSS, WCM, FBA, VS 2005, C#, ASP.Net 2.0, 3.0, SharePoint Designer 2007, Gemini, SQL Server 2005, VMWare, XML, XSLT

VFA, Inc.

  • Set up WSS, Content Types, Custom Workflows

Tools: WSS 3.0, SharePoint Designer 2007

Darwin Professional Underwriters

  • Consult on MOSS implementation, best practices and migration

Tools: MOSS

RMF

  • Aid in creating taxonomies, design and implement Content Types
  • Stand up MOSS on development and production
  • Customize advanced search center - filtering and output

Tools: MOSS, XML, XSLT, ASP.Net, SQL Server 2005

Past Experience

2005- 2006 Trionia Cohasset, MA

Autopart International - Consultant / Project Manager

Work with client CIO as project manager for 4 projects:

  • ACES Catalogs – Manage project to generate industry standard XML output for generation of automobile parts catalogs from SQL Server database to XML format using C# and .Net.
  • Online Catalogs – Manage offshore development team to update and maintain internal and external auto parts catalogs.
  • Business Intelligence Reports – Assist management of offshore team for generation of Sales Reports by period etc.
  • Zone Picker – Managed and updated Windows system of programs to allocate manpower for generating lists of items to pick at a warehouse to fill orders.

Tools: VB.Net, .Net Windows applications, ASP.Net, SQL Server 2000, stored procedures, SQL, J D Edwards One World

2001 - 2006 e-numera Billerica, MA

Consultant

  • Atlas and AJAX – Installed MS Atlas and created test implementations of AJAX in preparation for a project

Tools: C#, ASP.Net 2.0, VB.Net, Atlas, AJAX, SQL Server Express

  • Henry - Implemented single sign on for Active Directory users into an intranet portal (DotNetNuke).

Tools: Active Directory integration with Dot Net Nuke 4.x (DNN), ASP.NET, IIS, Visual Basic .Net (VB.Net), SQL Server 2000, .Net 2.0, custom modules development, custom skin

  • TIAA-CREF (2003-2005)

Technical Analysis Charting and other projects: Consumed a web service and accessed database to display different charts

  • Tornado graph of largest unrealized gains and losses
  • Moving averages for 5, 10, 50, 100, 200 days
  • Exponential moving averages
  • Bollinger bands

Tools: ASP.Net, C# (C sharp), SQL Server, SQL, stored procedures, XML, consume web service, ChartDirector graphing tool, JavaScript, DHTML, C# Console App, Multi-threading C# Native Windows service, C# Windows app, ASP.net user controls, Web Services, SOAP

Other Clients

Brooks Automation Consultant Billerica, MA

Merrimack College Consultant Andover, MA

Compass Freight Forwarding Consultant Boston, MA

Backbay Shutter, Co, Inc. Consultant Woburn, MA

SosZey Productions Consultant Alexandria, VA

StorkBundles.net Consultant Bedford, NH

EyeTownCenter.com Consultant Florida

Clientele before 2000

Sapphire Six Consultant Waltham, MA

TPMS Consultant Natick, MA

Basic Car Rentals Web Developer Manchester, NH

Mount Sinai Hosp. Consultant New York, NY

Physicians Computer Network Project Leader Needham, MA

Practice Management Systems Project Leader Needham, MA

Access Unlimited Programmer Boston, MA

Contract Work During High School and College

CYR Construction Programmer Lawrence, MA

Time, Tools, and Talent Programmer Hampton, NH

Winco Identification Programmer Tyngsboro, MA

Logicraft Programmer Nashua, NH

Travelodge Programmer Gettysburg, PA

Masi Plumbing and Heating Programmer Nashua, NH

Education

1982–1986 Gettysburg College Gettysburg, PA

  • Bachelor’s Degree, Math; Minor in Computer Science


Member number:6782
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2011 Andrew Gettings and Software Contractors' Guild, Post Office Box 257,Nottingham, NH USA 03290-0257