Joseph Kelly, Database Developer / DBA – SQL Server adxcuq@r.postjobfree.com
San Francisco, CA 94109
https://github.com/jksfoTemp/SQLTools
https://www.linkedin.com/in/jksfo/
Profile: SQL Server query optimization and administration (RDBMS database engineering); business intelligence (ETL); 3rd-party integration and customization; web development; n-tier SOA development Proficiencies: T-SQL, SQL, SQL Server, JavaScript, C#, ASP.Net, .Net Supporting Technologies: SQL Server (SSMS, SSIS, SSRS, SSAS; 6.5-2022), PowerShell, jQuery, JSON, HTML5, CSS3, Bootstrap, VSS, TFS, Git, DevOps, Data Analytics, Tableau, JQL (Jira) Independent Contractor, Self, San Francisco, CA, 2021 – Present (Small business growth, volunteering, patent and entrepreneurial work)
Database design, administration and optimization
Website design, creation, delivery, maintenance and administration
Home networking and computer repair
COVID-19 relief volunteer
Hospice care
Mathematics tutor (probability, statistics, linear algebra, matrices)
Entrepreneur, patent in progress for software that assists the visually impaired Staff Software Engineer, Rev.com, San Francisco, CA, 2020 – 2021 (Transcriptions and captioning)
Query optimizations and C# development
Database Developer, American Academy of Ophthalmology (AAO), San Francisco, CA, 2016 – 2020
(Medical non-profit – Database development and administration, application support, mentoring)
Multiple query optimizations resulting in an order of magnitude in performance improvement (10 times faster)
Multiple third-party systems integration, including implementing ETL with SSIS and Powershell
Creation of a soundex tool using the Levenshtein distance algorithm enabling analysis of 30000+ members across multiple languages and code pages with customizable accuracy enabling effective demographic targeting, essentially leveraging statistics
Care and feeding of over 30 on premises SQL Servers containing 1000+ databases, several of which were half a terabyte or larger with an emphasis on optimization, durability and security
Mentoring, tutoring and general professional development
Implementation of transparent data encryption (TDE) across the enterprise Web Application Programmer, University of California Medical Center, San Francisco, CA, 2010 – 2014
(Financial Services – Internal application and database development, administration, ETL)
Design, creation and automation of numerous ETL systems (with SSIS and PowerShell) which consolidated myriad previous implementations, increasing accuracy and repeatability, resulting in the savings of 100's of hours of employee time along with immediate error notification, debugging and resolution
Creation of hybrid single page application (SPA) for resource allocation allowing for traceability and management of organizational staffing requests
Integration of financial systems, creation of technique for organizational hierarchical and user management synchronization saving 100’s of hours of employee time; effective use of linear algebra to morph multiple orthogonal sets
Maintenance and customization of university web based portal for financial reporting allowing rapid delivery of financial information to 1000+ customers
Reverse engineering and customization of numerous custom and off-the-shelf financial management systems extending the life of existing products and enabling the transition to new software systems
IIS administration and troubleshooting
Software Support Engineer, McCann Erickson (IPG – Interpublic Group), San Francisco, CA, 2007 – 2009 (Marketing and Advertising – Internal and external application development)
Enterprise solution architecture design & review
Infrastructure support, data analysis and systems optimization
3rd party vendor coordination, integration and product validation
Leading software solutions from “Proof of Concept” to production release
Reverse engineering and enhancement of externally facing, n-tier, enterprise application for account and security management of over 30,000 users across a global network with multiple forests and domains, allowing for enhanced credential management and security, lessening support time by 100’s of hours
SQL Server optimization: Query optimizations improving performance by a factor of 10
MOSS/SQL Server/Infrastructure: Identification and remediation of errant configurations leading to 5x increase for file IO across internationally distributed networks
Internal tool creation: screen scrapers for process automation; custom application for preloading compiled and cached sites resulting in faster user experiences Software Applications Engineer, United BioSource Corporation, San Francisco, CA, 2006 – 2007 (Bio- pharmaceuticals Industry, Clinical Trials – External application development)
Design and creation of 3-tier ASP.Net web portal for project and resource scheduling resulting in improved resource allocation
Increased performance of customer-facing, data-driven, FDA compliant websites for pharmaceutical trials by more than 20x (database and page optimization) while reducing code volume by more than 50% (object reuse & library creation)
Senior Data Processing / Programmer Analyst, County of Santa Cruz, Human Resources Agency, Santa Cruz, CA, 2006 – 2006 (Public Service Agency – External and internal application development)
Design, creation and delivery of custom web-based accounting application that replaced an antiquated multiple spreadsheet system that allows for secure access, process automation, auditing and multiple systems integration
Database and version control management and administration (Perforce)
Creation, automation and customization of data integration packages (SSIS/ETL) Independent Contractor, Santa Cruz, CA, 2005 – 2006 (Manufacturing application creation)
Design, creation and development of 3-Tier database application for data extraction (ETL), analysis, manipulation and reporting including full cycle data feeds, incorporating Sage MAS 200 (ERP and CRM), Excel and other file system data stores, reducing import times by 50% Senior Software Engineer, Kronos, Inc., Portland, OR, 2000 – 2005 (Workplace talent management solutions – web application development and database optimization)
Design and creation of software bridge (SSIS) for next generation product allowing maximum reuse of components and functionality, substantially reducing time for new product development and disparate systems integration
Design and implementation of highly scalable .Net based image generation engine capable of rendering 1000’s of customized PDF forms per minute b
Creation of web-based internal tools for process automation and production support as well as managing software deployment and version control of 12,000+ offline devices (POTS) Education:
B.S., Computer Science, Hawaii Pacific University, Honolulu, HI (1999)
A.S., Mathematics, Hawaii Pacific University, Honolulu, HI (1997)
Azure data certification in progress
Honorably discharged U.S. Navy veteran, 7+ years, electro-mechanical calibration, Top Secret clearance (expired), Desert Storm and Somalian campaigns, Petty Officer Second Class (E-5)