| Bullseye Consulting | |
| Software Consulting | |
| Web Portals, Web Applications, C#, ASP.Net, MS SQL Server, ... |
Andrew Gettings
|
Languages |
C#, VB.net, Delphi, Java, C++, C, Visual Basic, ASP, SQL, HTML, XML, JavaScript, VB Script, VBA, Pascal |
|
Database |
MS SQL Server, Firebird SQL, Sybase Adaptive Server Anywhere, Interbase, MS Access, Paradox, Advanced Database Systems, ADO, ODBC, OLE, BDE, SQL, Stored Procedures, Replication, Design, Normalization, Optimization |
|
Operating Systems |
Windows 2003, XP, 2000, NT, 98, 95, DOS, UNIX |
|
Web Technology |
IIS, Client/Server & Multi-tier, Backend (server-side) Development, Sybase Power Dynamo, Web Hosting HTML, CSS, GIF Animation, Streaming Video, Streaming Audio, MP3, Graphic Design, Web Site Design and Maintenance, Search Engine Optimization |
|
Other Technology |
PDF (Adobe Acrobat), InstallShield, SourceSafe, Visio, OOD, OOP, Document Imaging, DDE, Specification Writing |
|
Experience |
2001- Present e-numera Billerica, MA Consultant § TAC Commission Calculations Engine – Helped design and wrote 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 § Eliza – Took over development of web application which invokes stored procedures in background threads. Tools: C#, ASP.Net, SQL, SQL Server 2000, Multiple Asynchronous Threads under IIS, CSS §
.Net Data Access Layer –
Designed and implemented lightweight interchangeable modules for both Oracle
and SQL Server data access. Tools:
ASP.Net, C# (C sharp), SQL Server, SQL, Oracle 9.2, stored procedures § TIAA-CREF (2003-2005) 1. Production Intranets: Risk Management, Business Continuity. Converted web site from ASP to ASP.Net., extensive database modifications, site architecture. Demo Intranets: Sinkable Funds, Credit Analysis Tools: ASP.Net, C# (C sharp), SQL Server, SQL, stored procedures, ASP, JavaScript, DHTML, HTML, PGP Disk, C# Web App, C# Console App, C# Native Windows service, C# Windows app, ASP.net user controls 2.
Technical Analysis Charting:
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, XML, consume web service, ChartDirector graphing tool, JavaScript, DHTML 3.
Portfolio Tree Web Service and
Demo Web Application: Designed and wrote a web service to expose data
from a database. Tools: ASP.Net, C# (C sharp), SQL Server, SQL, XML, Web Services, JavaScript 4. Digester: Console application and then native Windows service which waits for and moves inbound files to appropriate directory for use in web sites, and records the file's attributes in a database Tools: Multi-threading C# Windows Service, FileSystemWatcher § Eagle Eye (2003-2004) – Helped design and develop web application. Tools: ASP.net, C# (C Sharp), JavaScript, HTML, Visual Studio .net 2003 enterprise, Visual Studio .net 2002, Firebird 1.5, Firebird 1.03 Access 2002, Access 2000, SQL, IIS, Windows 2000, Windows XP, charting § Teleglass – Converted flat-file application to MS SQL Server. Tools: Delphi 5, SQL Server, ADO, SQL, Stored Procedures, DDE |
|
|
1997–Present Bullseye Consulting Arlington, MA President Create and manage IT resources. Price Reporting Company: § Price Change Alert – Designed, implemented reports using “push technology” where reports are generated and emailed to customers via Windows 2000 service. § Web Report – 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. § Price Change Report – Designed and implemented database and Windows application to import data and generate reports from the data. § CPR – Provide maintenance work for day to day custom software: additional import formats, tweaking UI, and reports Provide web hosting. Tools: Delphi 2-5, Interbase 4.1, Firebird 1.02-1.50, SQL, Stored Procedures, IBObjects, Report Builder, Report Smith, ISAPI DLL, HTML, Javascript, Web Application, IIS 5.0, Windows 2000, Database Replication, Interdev, Delphi 2.0, Windows NT services, SMTP, POP3, Indy, Web Broker, BDE §
Firebird
Host – Web hosting business on colocated server. Tools: ASP.NET, ASP, .NET framework, Firebird SQL 1.50, Stored Procedures, SQL, HTML, JavaScript, IIS, Windows 2000 Server, HTML, CSS, Web Design §
BullseyeConsulting.com
– Marketing, information site for company Tools: ASP.NET, ASP, .NET framework, ASP, HTML, JavaScript, CSS, IIS, Windows 2000 Server, Web Design § Freight Forwarding Company – Provide freight tracking information to customers via web browser using ad-hoc queries, provide web hosting. Tools: ASP.NET, VB.Net, ASP, MS Access, SQL, OLE db, .NET framework, IIS, JavaScript, HTML § Custom Shutter Company – Provide maintenance work for custom day to day software, web site updates, web hosting and other IT needs. Tools: VB 6.0, MS Access, SQL, Windows 2000, ASP, HTML, CSS Soszey Productions: § Helped design and Implemented HopeAndFear.com web site for an independent photographic documentary project. § Designed, implemented and maintain Wedding-Advice.com web site to promote Wedding Advice: Speak Now or Forever Hold Your Peace, an independent documentary film, and provide Web Hosting. Tools: ASP.Net, ASP, HTML, CSS, Streaming Video, Streaming Audio, mp3, GIF Animation, Graphic Design, JavaScript, Interdev, Search Engine Optimization, digital photography § G. L. Gettings, Inc. – Provide IT help, designed, implement and maintain and host LandInFLcom and LandInNH.com web sites for marketing real estate. Tools:
ASP, HTML, CSS, Graphic Design, JavaScript, Interdev, Search Engine
Optimization, digital photography §
St.
John the Evangelist Parish – Provide IT help, designed, implement
and maintain web site, provide web hosting. Tools:
ASP.NET, C#, ASP, HTML, CSS, JavaScript, Web design, digital photography § StorkBundles.net – Oversee design and development of marketing web site, provide web hosting. § Tools: ASP, HTML, CSS, IIS, Windows 2000 § EyeTownCenter.com – Assistant to web master for community-based medical web site, including forums, classified ads, articles, newsletter, etc. Tools: Sybase, Sybase Power Dynamo, Sybase Adaptive Server Anywhere, HTML, SQL, ODBC, CSS, Stored Procedures, JavaScript, DHTML § Podiatrist – Worked on marketing and management program for diabetics’ therapeutic shoes from pre-beta into release to general public. Tools: Delphi 5, SQL, Advanced Database Systems, Database design, Fast Reports, SMTP, POP3, Indy, XML, RTF, HTMLSQL, Windows 2000 |
|
|
1999–2001 Sapphire Six Waltham, MA Consultant § TAC – Wrote report engine for time card reports Tools: VB, Oracle 8i, ASP, VBScript, SQL, HTML, InterDev, COM § TAC – Enhanced 4 different web sites all accessing the same SQL Server database and made UI and database specifications for overhauling an existing web survey maker. Tools: ASP, VBScript, JavaScript, SQL, SQL Server 7.0, Stored Procedures, HTML, InterDev, VB, COM, IIS, PWS § PartsTree – Parsed XML data to create a tree using a Java applet. Tools: Java, Borland JBuilder, XML, HTML, JavaScript § GoldLink – Made major contributions to all parts of three-tier system which controls networks of tools with cryopumps and waterpumps on them. Tools: Delphi 5.0, D/COM, HTML, XML, Javascript, Java, SQL, IIS & PWS, MS Visual InterDev, Borland JBuilder, Paradox, Internet Express, MIDAS, Web Broker § MRS – Management Replenishment Systems using BOM and Kanban. Implemented rewrite of existing MS Access application using a multiple-threaded UI and client-server architecture. NT services work for automated emailing and faxing. Tools: Delphi 4.0 & 5.0, SQL Server 7.0, Windows NT, COM, SQL, Access §
CPR2 – Crisis, Prepare,
Respond, Recover. Wrote user
interface and engine for generating crisis response manuals. Tools: Delphi 3.0, MS SQL Server 7.0, COM, SQL, Rich Text Format, MS Access |
|
Other Experience (Before 2000) |
TPMS Db Programmer Natick, MA Basic Car Rentals Web Developer Manchester, NH Mount Sinai Hosp. VBA Developer 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 |