Tom Keller Consulting

Technical Skills Summary

20 Years of Experience and Accomplishments

     Maintained and improved SQL 2000 database and ASP.Net/JavaScript website/intranet, with audio streaming, podcasts, and RSS. Upgraded to SQL 2005, separated SQL server from IIS server. Created process to log and report on stream listener statistics for royalty purposes. Created process to detect timeouts and restart IIS. Created ASP.Net controls to analyze transaction and survey data, and export to Excel. Launched calcaponline.org site for syndicating news content to other stations, by integrating the intranet user database. Prevented public viewing of future playlist information. Created process to import playlists from MusicMaster. Separated content from code, moved content into database, and simplified website structure. Automated date-driven content changes, such as splash page during fund drives.

     Maintained and improved ASP.Net/JavaScript/SQL 2005 website/intranet, upgraded from ASP/SQL 2000. Integrated with autoims.com and blackbookusa.com website/databases. Setup VSS source control. Implemented SQL trigger audit trail. Exported binary data to reduce database size. Generated reports as HTML which opens directly in Word or Excel. Separated SQL server from IIS server. Implemented and optimized Damerau-Levenshtein algorithm for “fuzzy” searching (finding information which is slightly misspelled). Added CRM functionality to track client contact information, and follow-up to client requests.

     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.

     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.

     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.

     Synchronized SQL 2000 with the DBISAM database of activitylinksystems.com, using SQL views to minimize web changes, and Access to transfer data. Improved ASP/JavaScript websites.

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

     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. Integrated with ASP/JavaScript websites; created intranet IT trouble-ticket system.

     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.

     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.

     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.

     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.

- References available upon request -

www.TomKellerConsulting.com