Tom Keller Consulting

Tom Keller Resume: Database + Website, Developer and Administrator

Thomas J. Keller 916-765-9404

8442 Palmerson Drive
Antelope, CA 95843-5800
(Sacramento, California metro area)

Sacramento County Business License # 338942

Sacramento SQL Server User Group

View my Demo site: fuzzy-string.com

Tom Keller 2010 photo by GMPdigital.com

Boost your business, with data/web integration!

I have a proven track record of…
  • translating user desires into technical specifications…
  • building secure and stable systems which exceed expectations…
  • capturing the right data…
  • and getting it into the right hands at the right time.
Latest presentation: Excel Pivot Table Best Practices for Loading Data Directly from SQL Server

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Implementation and Maintenance

Technical Skills

Summary:

DatabaseWebsite
Developer ✓ ✓
Administrator

Objective:

My speciality is Microsoft SQL Database Developer, but my real strength and value is the breadth of my experience. Whether you want a short-term contractor to get your shop into shape, or a long-term staff member to keep it that way, I will figure out how to do what you need done. I am equally comfortable as a lone operative, team leader, or team member.

Lang­uages:

Transact-SQL, ASP.Net, JavaScript, PowerShell, VB, HTML, CSS, C#.Net, Access/Excel VBA

DB and OS:

Microsoft SQL Server 2014, Oracle 11g, MySQL 5, Windows Server 2012R2 (IIS 8.5), VMWare 5.5

Dev Tools:

Microsoft Visual Studio 2012, SourceGear Vault, SolarWinds DPA (Confio Ignite), TeamViewer

Over 25 Years of Experience and Accomplishments (updated 01/28/2014)

Tom Keller Consulting

Jul 2008 - Present
Database and Website Consultant

Antelope, CA — In coordination with ComputerStuff4You (an IT services company), I handled a wide variety of integration and conversion projects.

Skills Used: Microsoft SQL 2000, SQL 2005, SQL 2008R2, SQL 2014; ASP.Net, JavaScript, Visual Basic, Oracle 10g, Oracle 11g, PowerShell, FreePBX, MySQL, Excel VBA and Pivot Tables, Microsoft Access 2003, Access 2007, Access 2013, SalesForce SOQL/SOSL, SharePoint 2007, SharePoint 2010, Windows Server 2008 (IIS 7), Windows Server 2008R2 (IIS 7.5), Windows Server 2012R2 (IIS 8.5), AWS, VMWare, SourceGear Vault

Capital Public Radio

Jun 2007 - Dec 2014
Webmaster and DBA

Sacramento, CA — CPR's CapRadio.org is a regional non-profit high-traffic content-rich public website, with audio streaming, podcasts, and RSS. They typically hired entry-level webmasters, who didn't stay very long, so they frequently needed general mentoring, support during transitions, and help with high-priority projects.

Skills Used: Microsoft SQL 2000, SQL 2005, SQL 2008, SQL 2014; ASP.Net, JavaScript, JQuery, Google Analytics, PowerShell, Umbraco CMS 4, Visual Basic, Windows Server 2003 (IIS 6), Windows Server 2008 (IIS 7), Windows Server 2012R2 (IIS 8.5), SourceGear Vault, IceCast, MusicMaster

Jan 2004 - Aug 2014
Webmaster and DBA

Citrus Heights, CA — RR serves small lenders such as Credit Unions, managing the process of finding, recovering, and selling the vehicles of borrowers in default. I managed their database, website, and intranet until they were acquired by Primeritus Financial Services.

Skills Used: Microsoft SQL 2000, SQL 2005; ASP.Net, JavaScript, JQuery, Google Analytics, Visual Basic, Excel VBA and Pivot Tables, SalesLogix 7.5 CRM, Windows Server 2003 (IIS 6), Windows Server 2012 (IIS 8), Microsoft Exchange 2007, Exchange 2013, VMWare, Visual Source Safe

Oct 2004 - Jun 2008
Database and Software Developer

Granite Bay, CA — Created ASP.Net/JavaScript/SQL 2005 intranet CRM (Customer Relationship Management) database, upgraded from Access 2003/SQL 2000. Maintained and improved C#.Net client program for managing the process of IRS 1031 tax-deferred exchanges, in a database integrated with CRM, accounting, paperless document tracking, and address verification databases. Automated Word merges for monthly statements mailings. Extracted and formatted data for IRS e-filing (1099-INT). Setup VSS for source control, and Accounting document control. Automated daily status emails to clients, and alerts for accounting inconsistencies. Implemented SQL trigger audit trail, Excel Pivot Table reports.

Tahoe-Wheaton (foreclosureS.com)

Feb 2005 - May 2006
Database and Website Developer

Fair Oaks, CA — Designed and optimized SQL 2000 database for import, de-dup and publish of a million records per year of foreclosure data from one nationwide and multiple regional vendors. Integrated with Goldmine 6.7 CRM database to drive ASP/JavaScript website and intranet. Implemented SQL trigger audit trail on published data, customers’ saved search criteria, and data delivery via web or email. Automated daily import of monthly recurring credit-card billing status from authorize.net payment gateway.

Wells Fargo Bank

Jun 2004 - Sep 2004
Database Developer and Administrator

Folsom, CA — As a contractor in the teller-incentive department, optimized SQL 2000 DTS (Data Transformation Services). Developed table-driven system for parallel job execution, to run DTS packages as input files become available. Improved ASP/JavaScript intranet.

Rainbow Activities

Mar 2003 - Dec 2003
Database and Website Developer

Kihei, HI — Synchronized SQL 2000 database of this vacation-activity reseller with the DBISAM database of activitylinksystems.com, using SQL views to minimize web changes, and Access to transfer data. Improved ASP/JavaScript websites.

Oct 1999 - Dec 2002
Database Developer and Administrator

Pleasanton, CA — Led the team for a CRM/Accounting intranet, using SQL 7, ASP/JavaScript, and Excel Pivot Tables. Used SQL triggers to implement a complete audit trail for customer and loan information. Upgraded epass​business​center​.com corporate datacenter from SQL 6.5 to 7; migrated data from subsidiary to corporate datacenter. Setup hot-backup servers for reporting, fault-tolerance and disaster recovery; exported binary data to reduce database size. Defined XML schema for data transfer. Improved Access97 database used for data entry.

Jan 1999 - Oct 1999
Database Developer and Administrator

Walnut Creek, CA — Maintained the Onyx CRM (Customer Relationship Management) database on SQL 6.5, through two major upgrades with minimal downtime. Put VSS source control, data consistency and duplication checks in place. Integrated with ASP/JavaScript websites; created intranet IT trouble-ticket system.

Rebis (acquired by Bentley)

Aug 1997 - Dec 1998
Database and Website Developer

Walnut Creek, CA — Maintained the Onyx CRM database on SQL 6, improving processes and adding business rules as required. Improved integration with Platinum accounting system. Created reports using Access97, and Excel Pivot Tables. Integrated with ASP/JavaScript website for tech support, with email notification.

Scopus (acquired by Oracle/Siebel)

Apr 1995 - Jul 1997
Database and Software Developer

Emeryville, CA — Became familiar with the organization of the system tables on all databases (Sybase, Oracle, Microsoft SQL 4.2 and 6, and Informix). Wrote tools in TCL, portable between UNIX and NT. Created UNIX Shell, sed and perl scripts to automate capturing development databases, generating change reports from ClearCase source control, and extracting important error information from installation log files.

Nov 1991 - Feb 1995
Software Developer

Walnut Creek, CA — Developed tools to parse and document C programs, using a TCL-like scripting language, C code, Shell and sed scripts, and batch files (portable between UNIX and DOS). Identified and solved weather data reception problems in Real-Time UNIX on Navy ships, increasing the error-free data rate eight-fold.

Aug 1987 - Aug 1991
Software Developer

New York, NY — Created and maintained programs in C and Assembler (portable between DOS PCs and PDP mini-computers), to recover documents from obsolete computer systems, keeping visual formatting intact.

Education: Bachelor of Electrical Engineering, The Cooper Union, New York, 1989.
Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Implementation and Maintenance, 2011.

Active in Sacramento SQL Server User Group; presented at SQL Saturday 2012 and SQL Saturday 2014.
Currently studying for Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014

- References available upon request -