Tom Keller Consulting

Boost your business, with data/web integration!

Technical Skills

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.

Latest presentation:

Excel Pivot Table Best Practices for Loading Data Directly from SQL Server

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)

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.

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

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

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

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.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.