Tom Keller Consulting

Tom Keller Resume: Database + Website, Developer and Administrator

Thomas J. Keller 916-765-9404

9 Ontur Lane
Hot Springs Village, AR 71909-6105
(Hot Springs/Little Rock, Arkansas metro area)

TJ Keller 2019 photo

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.

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, XML, XSLT, HTML, CSS, C#.Net

DB and OS:

Microsoft SQL Server 2016, Oracle 12c, MySQL 5, Windows Server 2012R2 (IIS 8.5), VMWare 5.5

Dev Tools:

Microsoft Visual Studio/TFS 2015, SourceGear Vault, SolarWinds DPA, TeamViewer

Over 30 Years of Experience and Accomplishments (1987-2020)

Tom Keller Consulting

Sep 2002 - Present
Database and Website Consultant

Antelope, CA — In coordination with TrueCourse Solutions (a business and IT management consultancy), I help CPUC manage the current administrator of the California LifeLine program.

In coordination with BMIsmartCloud (formerly ComputerStuff4You), I handle a wide variety of integration and conversion projects.

Jan 2017 - Sep 2019
Technical Solution Architect

McClellan, CA — Conduent is a Business Process Outsourcing company spun off from Xerox.

Skills Used: Microsoft SQL 2008R2, SQL 2012, SQL 2016, SSIS, SSRS; TFS 2010, TFS 2015, ASP.Net, JavaScript, C#.Net, XML, SQLCLR, SOAP web services, SoapUI, PowerShell, Windows Server 2008R2 (IIS 7.5), Windows Server 2012R2 (IIS 8.5), AWS, VMWare

Xerox

Feb 2015 - Dec 2016
Senior Database Developer and Administrator

McClellan, CA — Xerox inherited State and Local contracts when it acquired ACS.

ComputerStuff4You

Jul 2008 - Feb 2015
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, Oracle 12c, 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, XML, XSLT, Praxis EMR, HL7, eMDs Medisoft and Lytec PM, Azalea EHR, SOAPware, Sybase Advantage, PostGres, TotalMD, DBISAM, SQL Server Migration Assistant (SSMA)

Capital Public Radio

Jun 2007 - Dec 2014
Webmaster and DBA

Sacramento, CA — CapRadio.org is a regional non-profit high-traffic content-rich public website, with audio streaming, podcasts, and RSS, based at Sacramento State University.

Skills Used: Microsoft SQL 2000, SQL 2005, SQL 2008, SQL 2014; ASP.Net, JavaScript, JQuery, Google Analytics, PowerShell, Umbraco CMS 4, XML, XSLT, 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 — Repo Remarketing serves small lenders such as Credit Unions, simplifying the process of finding, recovering, and selling the vehicles of borrowers in default.

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 2012R2 (IIS 8.5), Microsoft Exchange 2007, Exchange 2013, VMWare, Visual Source Safe, SourceGear, SOAP web services

2008 - 2012
Database Consultant

Citrus Heights, CA — Optimized monthly data import and reporting processes, using Confio Ignite (now Solarwinds Database Performance Analyzer).

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 Section 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

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 (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 in relational 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.

Computer Sciences Corporation (now DXC)

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.

Bachelor of Electrical Engineering, The Cooper Union, New York, 1989.

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

Active in Sacramento SQL Server User Group; presented at SQL Saturday 2012 and 2014 and 2015.