Keefe O Goldfisher

*** * **** **

Carlton, OR ***11

(C) 949-***-****

ad2wd0@r.postjobfree.com

EDUCATION:

Claremont McKenna College — B.A. Russian / Mathematics

UC Irvine — B.S. Mathematics / Computer Science

Western State University College of Law (general – no degree)

TOOLSETS:

Primarily Microsoft stack (20+ years’ experience) with project lead experience at Carousel and Epiq. Microsoft, Oracle, work with Linux and Neo4j—recent use of the following in last 5 years:

C#/ VB.Net JavaScript/JQuery/ JavaScript with Node.js /React /Angular with Typescript 1 & 2/SPA; Angular after AngularJS (version 9 and familiarity with versions 10 through 13); REST with WebAPI/ ASP Classic & ASP.Net (all versions) /MVC 3, 4, 5/Web API with REST and Postman; various .js frameworks like Bootstrap, Knockout, Aurelia, Julia; familiar with Vue, Ember and Backbone/ Spotfire 7.11/ (WCF ASMX (AJAX) Web Services with SOAP & XML/XSLT) Restful APIs VB/ASP/HTML through HTML5/CSS through CSS3; Java 8 and 11, Python through labs and online Kaggle self-paced Pandas with Jupyter notebooks C

SQL Server / Oracle SQL (PL/SQL) database design, maintenance, DBA work; ETL job development, SSIS/SSRS/SSAS; BI/Data Warehouse development and maintenance/ Spotfire, Jet Reports (for BI/DW), Tableau, PowerBI, Qlik, Dundas; algorithm development, debugging and optimization; all versions of SQL Server through 2019, and 2012/2017 with Azure DevOps pipelines and CI/CD (cloud-based, all in 2018-2019); lab exposure to Azure Data Factory and Databricks; some Docker/container experience; Entity Framework (versions 4, 5, 6 and Core in VS2017) with MVC/LINQ; Big Data analysis with R, RShiny, R in SQL, Python in SQL and SQL Server; NoSQL (Neo4J and CouchDB).

Linux (RHEL 6 and 7) with Bash and CShell scripting; Neo4j graph database and Cypher query development with Java; Spotfire (7.6, 7.7 and 7.11) data visualization using R and Shiny for Web publishing, IronPython and JavaScript to customize maps; some Java with Cypher query language and Java with Camel for Web Services; Git/GitHub/Smart-Git/SVN; data science online coursework with Python and Jupyter notebooks and on Kaggle; R with Bayesian analysis.

Limited exposure: testing with DAX (also with PowerBI) and MDX for SSAS cubes; some large dataset studies with Hadoop and Big Data; NoSQL and MySQL; MVVM; / SharePoint (ODATA queries from SSIS); Silverlight; VMWare; some ESXi; ontology work in RDF and OWL, M-Query with PowerBI; labs with Azure Data Factory using Databricks.

EXPERIENCE:

CYSTIC FIBROSIS FOUNDATION, BETHESDA, MD (CONTRACT) 7/2022 TO 7/14/2023

R SCRIPTING AND FULL STACK DEVELOPMENT: SQL SERVER, REACT, C#, MVC, ENTITY FRAMEWORK

Develop Web app with normal file selection and menus to render plots and data tables with R processing in Web page. React app overlay of C# MVC design pattern for a backend with custom API endpoints and embedded R in C#-based process. Endpoint testing with Swagger. Later testing moved functionality from R to SQL to R in SQL with R Services. The application was to allow quick visuals for lab work examining treatments for Cystic Fibrosis. SQL work had two phases, Entity Framework for initial setup to match data structures to project, triggers to prep and fill tables as experiments are saved and stored procedures to call R in SQL, including Plotly rendering from .js libraries. Azure DevOps with CI/CD.

TUALATIN VALLEY WATER DISTRICT, TUALATIN, OR (CONTRACT WITH EVEREST) 11/2020 TO 7/2022

SQL, DATA WAREHOUSE, BI, DATA MIGRATION

SQL development on SQL Server 2014/2017/2019 for migration of existing billing system to Oracle-based 3rd party vendor; requires data modeling for translation to new platform; duties include about 50 maintenance tasks on development of data warehouse in preparation for BI development; conversions work requires use of Visual Studio and C# to view existing code running the current system; some Oracle work to interface with testing team at 3rd party vendor.

STATE OF OREGON, SALEM, OR - DHS/OHA (CONTRACT) 4/2020 TO 11/2020

SQL, JAVA, ANGULAR

SQL development on SQL Server 2014/2017/2019 for migration of child services programs to SQL Server platform, including development of database projects (SQL/VS) for synthesizing work from various databases; Java development of Web Service processing for check processing; Angular 11 development of interfaces for staff to intake information about potential submitted cases.

ACS, HILLSBORO, OR (CONTRACT) 1/2020 TO 4/2020

SQL, SSRS, ETL AND SSIS, DW/BI DEVELOPER AND ANALYST

SQL development on SQL Server 2014 for large-scale system migration at Alaskan telecommunications company, ACS; analysis of ETL and Data Warehouse processing for moving data over to the OMNIA system. Supplementing required analysis with new SSRS reporting and automation of prior manual processes; creation of many SSIS packages.

HURON CONSULTING GROUP, LAKE OSWEGO, OR (CONTRACT) 2/2019 TO 12/2019

SQL, SPOTFIRE, ETL APPLICATIONS DEVELOPER AND ANGULAR

Spotfire development with SQL Server 2014 backend for large national Hospital clients reporting product suite; applications are used by the largest hospitals in the country. Half maintenance, some new development and frontend Angular debugging/development in .Net with Typescript. Visual Studio on top of Azure DevOps CI/CD pipelines. Generated pull requests from VS 2015 using Git; Agile team based on 3-week sprints. ETL modifications to facilitate Data Warehouse refreshes on existing and new entities, and SCD with new and historical data persisting conditionally before purging; PowerShell scripting for new features were created and debugged; statistical work for visualizations to do income projections; Angular 9 debugging for separate intake/reporting interface.

EPIQ, PORTLAND, OR (FULL-TIME EMPLOYEE) 6/2017 TO 2/2019

SQL / SSIS & ETL / POWERBI DEVELOPER AND CASE MANAGER

Developed SQL programming methods in class action sphere to ingest and transform data for notice and payment to class members, including stored procedures, functions, SSIS with ETL and report development (SSRS) for Data Warehouse aggregation and use with business intelligence software (PowerBI). Microsoft Stack using C# in SSIS packages and standalone apps. Assisted Project Management for including separate NY-based bankruptcy business in standard application interface. Worked on JavaScript Web-based utility to prepare mailing data on business that allowed user interaction with jQuery/JSON replacement of data. Visual Studio IDE for most of the programming work; SSMS for the SQL work; assisted DBA on production dacpac deployments in coordination with code deployments team; worked with DBAs to keep team from being slowed up by old software.

CRC, BAKERSFIELD, CA (CONTRACT) 8/2016 TO 5/2017

SQL / ORACLE / LINUX / NEO4J / JAVASCRIPT / WEB APPLICATIONS DEVELOPER

Installed and configured Windows Development Server and 3-node Linux Development Cluster in support of new project development using Neo4j (NoSQL) graph database technology (with transaction capability). Three phases of development included (1) processing jobs with MS SSIS projects (using VS2012/15 data tools) from Microsoft SQL Server (through 2016), Oracle and OSI PI databases to move data to Neo4j and then supply timely business information to Spotfire and ArcGIS reporting dashboards and Oracle systems for data governance; (2) adapting subject matter experts’ knowledge to templatized processing in Windows/Linux/Neo4j; (3) developing self-serve BI infrastructure for use by several groups within CRC. Installing 2017 SQL Server to push R scripts back to SQL Server, which supports R natively, and development in R Studio, operating on SQL and Ingres databases to schedule SSIS processing on newer database system. Adapting SSAS financial info to simple Web-based (JavaScript-based processing) printout results, and automated processes. Created Financial Web page for Monthly Reporting along with ETL of data from Finance; did study of Node.js project with Angular/C# version 5 and latest .Net frameworks (was not full-blown approved project, but rather POC); did setup and testing for Azure conversion from 2016 VM-based instance of SQL Server to cloud-based instance as prototype for ETL work on various database platforms. Some SharePoint integration with OAuth to enable distribution of geologic reports.

JPL, PASADENA, CA (CONTRACT) 3/2016 TO JULY 2016

ASP.NET/SQL APPLICATIONS DEVELOPER

Maintained and developed several projects and modules for existing Problem Reporting System used by all JPL projects and NASA missions. Duties required use of Visual Studio 10, 12, 13, 15 and ASP.Net Frameworks from 2.0 through 3.0 and .Net Frameworks 1.1 through 4.6. Some Oracle work with TOAD. Hardly any work was done on Classic ASP, but there was some. All primary programming was in C#; occasional work arose in VB.Net. Microsoft technologies included SSMS 2008, with some work in SSRS and SSIS (job creation/not BI), LINQ, Web Services (.asmx and WCF), Entity Framework (early versions) and multiple JavaScript frameworks (Bootstrap, Knockout, Node.js). Visual Studio 2010/12/13/15 and SSMS 2008/12 were primary tools.

LIVING SPACES FURNITURE, LA MIRADA, CA (FULL-TIME EMPLOYEE) 12/2015 TO 3/2016

BI/DATA WAREHOUSE / SQL TABLEAU AND POWERBI DEVELOPER

Developed and upgraded existing Data Warehouse nightly processing for 3rd largest furniture retailer in US—used after-market tools, JetReports, PowerBI and Tableau, in addition to SQL Server 2014. Regular production server development work was on SQL Server 2012.

Developed BI tools and datasets from queries and presentations for staff to analyze data in Purchasing, Accounting, Sales and Operations reporting and forecasting; the Data Warehouse refresh ran jobs off-peak that were part of very lengthy overnight ETL.

Worked on various SQL projects in organization in-between BI/DW tasks and helped with accounting migration; assisted converting tables and fields for mapping on a highly normalized schema, and revising Data Warehouse to match the new structures caused by upgrading accounting to Microsoft Dynamics NAV

CAROUSEL INSURANCE SERVICES, IRVINE, CA 12/2002 – 12/2015

(PART-TIME 2009 TO 2013 OVERLAPPING OTHER FULL-TIME WORK; TWO FULL-TIME STINTS AT CAROUSEL FROM 2002 TO 2009 AND FROM 2013 TO 2015)– CAROUSEL WENT OUT OF BUSINESS

ASP.NET/SQL APPLICATIONS DEVELOPER/PROGRAMMER

Developed mixed ASP.Net/Classic ASP web-based application with SQL Server backend to issue auto insurance at dealerships; ASP.Net was migrated to MVC (3,4,5) and developed some RESTful services; pages were being simplified and started migration to Angular.js usage; SharePoint processing with OAuth test POC.

Performed all database design to implement Web-based E-commerce site, and all .Net-based work; some Classic ASP for site maintenance; handled all migration from SOAP-based AJAX implementations to jQuery with JSON for all browsers, and later migration from ASP/ASP.Net to MVC, and redid all frontend pages to include Angular.js to apply SPA approach to the entire site using REST, eventually with WebAPI. Tools: VS 2012/13/15/17 and SSMS 2005 to 2012. Several years of JavaScript and AJAX development and later with Node.js to make REST calls with JSON.

Wrote all internal Web Services and all requests for 3rd party Web Services; database work included development of all SSIS and SSRS jobs that process information overnight and perform replication/ETL (2005/2008/2012) and reporting; worked on SSAS cube design and Data Warehouse reporting for decades old datastores.

CSC (FOR AMERICAN HONDA MOTORS), TORRANCE, CA 12/2011 TO 5/2013

– PART-TIME AND LATER FULL-TIME (overlaps with part-time work at Carousel)

SQL/ C# / WEB APPLICATIONS DEVELOPER (SQL SERVER/C# WEB-BASED APPLICATION)

Wrote stored procedures for implementation of least-cost algorithm to assign cars nationally at the dealer level by American factory (did not include international distribution); applied similar algorithm for storage of cars by warehousing in different geographic regions.

Participated in design, testing and implementation of swapping algorithms for pre-assigning factory output to dealers; followed business rules about multi-sourced versus single-sourced factory production, a high value-added process to lower the number of trades between dealerships during distribution on the new SQL-based recursive algorithm; also analyzed and designed ETL solutions for sales and inventory information to shorten the cycle of business forecasting from 3 months to 1 month; worked with local and offshore Indian personnel.

LHDottie - COMMERCE, CA – PART-TIME 5/2011 to 12/2011

SQL/ Oracle / Web Applications Developer (Oracle-based database system - C#/VB Web-Based Programming; overlaps with part-time work at Carousel)

Develop ASP.Net/Classic ASP Web pages for primary e-Commerce sales site; created Oracle queries, stored procedures and reports for manufacturing results used by management; internal and external Web site development and maintenance; performed odd studies for reporting and assisted with DBA duties for site and some Oracle permissions.

Systemsmith, TORRANCE, CA (FULL-TIME EMPLOYEE) 9/2009 - 5/2011

(overlaps with part-time work at Carousel)

Web/SQL/Silverlight/VB6 Applications Developer/Programmer

Develop mixed Silverlight/VB6 applications for large merchandizing firm as 3rd party vendor.

Silverlight duties: Design of SQL table/triggers/relations/clean-up scripts for in-house development and customer deployment; worked with offshore Indian team.

Part of build team for customer deployment, code and database; implemented class design (unique design with same object model on client and server using conditional compilation)

WCF services and UI design based on customer specs; testing and refactoring on mature app.

Part of long-term project to convert award-winning VB6 app to Silverlight-based application.

Worked in client SharePoint environment and researched SharePoint issues and audited entries.

References: Available upon request.

Contact this candidate