Joseph Kelly
***********.******@*****.***
San Francisco, CA
Administrative or support role in an information technology capacity
where I can employ my attention to detail making a measurable impact
WORK HISTORY
Educator, Volunteer and Caregiver - Freelance (Remote)
San Francisco, CA, February 2021 – Present
Tutor - Mathematics, Technology and Computer Science
Small business assistance (AR/AP; lead generation and SEO)
Data administration/analysis; trend, advantage and inventory projection
Implementation and customization of multiple data–centric (ERP-CRM-MRP-HRMS) systems (Zoho, Salesforce,, Monday, Amazon, Azure)
Human resource management; Cognitive Behavioral Therapy (CBT)
Staff Software Engineer, Rev.com (Remote)
San Francisco, CA, September 2020 – January 2021
Database optimization
Software development and library refactoring
Senior Database Developer, Academy of Ophthalmology (AAO) (Remote)
San Francisco, CA, February 2015 – June 2020
Administration of 30+ on-prem SQL Server instances, 1,000+ databases
Data transfers, systems automation and integration (ETL/ELT)
Soundex utility identifying pattern matches among disparate languages and code pages enabling demographic targeting; Levenshtein algorithm
Web Programmer, University of California Medical Center (UCSFMC)
San Francisco, CA, February 2010 – November 2014
Integration of ‘Commercial of the Shelf’ (COTS) and custom financial management software with new systems while enabling business continuity (Epic migration (EHR))
Consolidation of myriad disparate data systems increasing accuracy and supportability, lessening repetition, saving innumerable person hours
Development and customization of web-based portal for financial dashboards allowing rapid delivery of time-sensitive information
Software Support Engineer, McCann Erickson (IPG)
San Francisco, CA, June 2007 – December 2009
Development of n-tier, enterprise application for account management
Software Engineer, United BioSource Corporation (UBC)
San Francisco, CA, September 2006 – May 2007
Doubled performance of customer-facing websites; halving code volume
Senior Data Analyst, County of Santa Cruz Human Resources Agency
Santa Cruz, CA, February 2006 – August 2006
Custom web accounting application enabling systems integration, role based permissions and replacing multiple spreadsheets
Independent Contractor, Kelly IT Systems
Santa Cruz, CA, August 2005 – January 2006
Creation of 3-tier application for ETL and reporting including full cycle data feeds, consolidating Sage MAS 200, Access, Excel and other file system data stores, reducing processing and import times by 50%
Senior Software Engineer, Kronos, Inc. (Unicru) (Remote)
Portland, OR, January 2000 – July 2005
Manifest automation for > 25,000 offline devices (DSL on POTS)
EDUCATION
B.S., Computer Science, Hawaii Pacific University, Honolulu, HI (1999)
A.S., Mathematics, Hawaii Pacific University, Honolulu, HI (1997)
MILITARY SERVICE
Honorably discharged U.S. Navy veteran, Electro-mechanical calibration
PRIMARY LANGUAGES/SCRIPTS
T-SQL, JavaScript, Python, Bash
SUPPORTING TOOLS and DATABASES
SQL, PowerShell, Perl, Google Apps Script and VBScript (macros), HTML, CSS, jQuery, JSON, ASP.Net, Git, TFS, Perforce, JQL (Jira), SQL Server (SSMS/SSIS/SSRS), MySQL, MariaDB, Couchbase, AWS, Azure, Linux
VERTICALS
Medical, Education, Biotechnology, Non-profit, Human / Business / Financial Services, Manufacturing, Government, Department of Defense
jksfo.Blogspot.com LinkedIn.com/in/jksfo GitHub.com/jksfo