I refactored EJB and PL/SQL backend components into a series of performant REST microservices built in Scala, Slick, Akka HTTP, and Postgres.

Designed and developed an internal user on-boarding system.

Mentored Java developers in Scala, SQL, and application design.

For the projects above I architected microservice flow, created a database model, built the framework and led a team of 3 backend engineers.

Architected, designed and implemented a lightweight API gateway (microservices orchestrator) to serve as a company API directory, common facade, and endpoint aggregator. (Scala, Akka HTTP, Slick, Postgres)

I designed and developed a microservice to generate PDF reports. The service consumes a number of endpoints as data sources and utilizes the Jasper Report open source library. (Scala, Akka HTTP, Slick, Postgres, Jasper Reports)

Enhanced REST microservices that compute various real estate market statistics, aggregating large amounts of data in real time. Requirements included complicated processing and grouping criteria such as geospatial coordinates. (EDB Postgres, Postgis, Aurora Postgres, ElasticSearch, Scala/Play, Keycloak, Tiger census shapefiles)

Fixed and supported the in-house streaming ETL process. (Scala, Play, Kafka, Aurora, Postgres, ElasticSearch)

Contributed to an Oracle to Postgres(PPAS) conversion. I performed massive package refactoring and built a sophisticated database conversion quality control system.

In the process of legacy application modernization, fixed numerous bugs that had plagued the company for years. This included multi-threading problems and a lack of proper database schema normalization. (Oracle, Java, Spring, Hibernate)

Conversion of warehouse database loading process from Oracle Warehouse Builder generated code to easily tunable and maintainable custom process.

Integrated off-site and in-house applications at the database level.

Developed server-side APIs in PL/SQL and Java.

Worked on numerous data clean-up initiatives. (Improper data entry, identification and removal of orphan data and schema objects)

Used SQL, PL/SQL, Java

Conversion of large mortgage servicing database from Informix/C++ to Oracle/Java. My duties included database redesign with applying relational integrity and datatype corrections. Conversion/redesign of most critical programs utilizing Oracle parallel options. Debugging and optimizing code developed offshore.

Creation of the database for easy reporting and monitoring of all active loans. Development of the daily loading/refresh process via database link that required transfer of large volume of data within fixed amount time. This required extensive SQL tuning.

Conversion of the Lien Release system which included consolidation of many standalone, disorganized SQL files into packages with code cleanup, addition of logging and error handling.

Creation of dynamic system for data transfers between tables or from table to flat files.

Created packages for identification and reporting of in debt loans qualifying for the early resolution process.

Used SQL, PL/SQL, Java, shell scripting.