John L. Email and Phone Number

STAFF SOFTWARE ENGINEER, COLLATERAL (3/2018 - 4/2019) - Technical lead supporting an internal application responsible for debt management at SoFi. The main functionality of the tool is to transfer loans from the balance sheet to the various company credit lines, and to conduct sales and securitizations of loan assets. - Ensure investor vehicle criteria, rules, and restrictions are satisfied prior to transferring assets- Provide technical support to users during major financial transactions, such as sales and securitizationLEAD DATA ENGINEER, DATA WAREHOUSE (1/2018 - 3/2018) MANAGER, DATA WAREHOUSE (9/2017 - 1/2018) SENIOR DATA ENGINEER, DATA WAREHOUSE (11/2016 - 9/2017)Manager and ETL developer for the SoFi Data Warehouse, which is used by internal customers for report generation, data analysis, loan sales, and marketing.- Led project planning and provided technical direction of the data warehouse team- Developed ETL solutions to extract and load data from both internal and external data sources, loaded into a dimensionally-modeled Postgres data warehouse- Developed new dimensional data models and modified existing schemas to meet customer requirementsSENIOR SOFTWARE ENGINEER, COMMUNICATIONS (11/2015 - 11/2016) - Software development on the Communications team. Major project entailed migrating to a new email and marketing platform.

Supported development of CourtView’s JWorks court case management system, a cross-platform case flow management application. - Partnered with a variety of counties, municipalities, and law firms to provide criminal and civil case management. This covers the case progression process from citation entry to charging and restitution.- Software developed on a programming stack consisting of Java, JPA, JSP, jQuery using RESTful services while supporting a SQL Server, MySQL or Oracle database layer- Application utilizes a Jenkins continuous integration environment hosted on Amazon Web Services- Unit tests are developed on a robust test stack with DbUnit, Mockito, and Jasmine technologies

Analyst position funded jointly by the IT application development team and the Assessment department. Major projects have included:- Supporting the transition of the County assessment valuation software to a new vendor through mapping, scripting, and migrating assessment data via T-SQL- Developing an internal web application written in C# MVC to manage data warehouse metadata

Technical lead for a phased-developed, eligibility determination system contracted by the State of Montana. The program provides financial assistance to over 20,000 low-income seniors and generates 130,000 payments and 50,000 notices a year.- Modify code modules and data on an Oracle 10g database with an Oracle Forms and Reports front-end- Write functional and technical design documents for IT staff and clients - Participate in system requirements gathering with clients- Coordinate unit, system, and integration testing

Offer regular tutoring hours for Computer Science students- Provide tutoring in the following courses: Java Programming I/II/III, Databases, Web Development

Worked with the Legislative Applications Development team to support in-house database systems and web site applications● Provided technical support for Capitol Staff ● Wrote technical and user documentation for supported systems● Researched and tested new technologies, such as application upgrades