Joseph Kelly
*********@*******.***
San Francisco, CA 94108
Seeking: Administrative or support role in an information technology capacity employing my attention to detail resulting in measurable impact WORK HISTORY
Data Entry, Tutor, Volunteer - Freelance (Re mote) San Francisco, CA, February 2021 – Present
Data entry, transcription and validation
Data extraction and mapping; PDF form enhancement; web scraping
Data systems implementation (ERP/CRM) - Zoho, Salesforce, Monday
Small business assistance (GL/AR/AP; org structure; lead generation)
Tutor: Mathematics, Technology and Computer Science
Human resource management; Cognitive Behavioral Therapy (CBT) Staff Software Engin eer, 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
Data transfers, systems automation and integration (ETL/ELT)
Administration of 30+ on-prem SQL Server instances, 1,000+ databases
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
Database integration of ‘Commercial of the Shelf’ (COTS) and custom financial management software with new systems while enabling business continuity (EPSI and Epic migration (EHR, EPR, CRM and HRMS systems))
Data systems consolidation 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 (Remote) 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 (MRP), 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, ANSI SQL, JavaScript, Python, Bash
SUPPORTING TECHNOLOGIES and DATABASES
Linux, SQL, PHP, HTML, CSS, jQuery, JSON, Git, Google Apps Script and VBScript (macros), JQL (Jira), SQL Server (SSMS/SSIS/SSRS), MariaDB, Azure, Perl, C#/ASP.Net, PowerShell
VERTICALS
Non-profit, Medical, Education, Biotechnology, Human / Business / Financial Services, Manufacturing, Government, Military jksfo.Blogspot.com LinkedIn.com/in/jksfo GitHub.com/jksfo Temp