# Yelena Mishkin

> Senior Software Developer

Location: San Rafael, California, United States
Profile: https://flows.cv/yelena

## Work Experience
### Senior Software Engineer @ Pearl Health
Jan 2023 – Present

### Senior Software Developer @ Lone Wolf Technologies
Jan 2021 – Jan 2023
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.

### Senior Software Developer @ Terradatum
Jan 2015 – Jan 2021
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)

### Software Developer @ McGraw-Hill Education
Jan 2010 – Jan 2014
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

### Software Developer @ JPMorganChase Bank
Jan 2001 – Jan 2006
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.

### Software Developer @ QWEST COMMUNICATIONS CORP
Jan 2000 – Jan 2001
Created Oracle jobs and PL/SQL apis to automate the process of disconnecting, suspending, and reconnecting toll-free components in the national SMS, in synch with Qwest transactions
	Designed and developed a web-based support system that pulled together a number of different SQL and PL/SQL scripts used by IT support personnel. 
Used SQL, PL/SQL, JSP/Servlet, XML, DTD


## Education
### Bachelor of Science (BS) in Computer Science
St.Petersburg State Technical University, Russia

### High School 239 St.Petersburg, Russia


## Contact & Social
- LinkedIn: https://linkedin.com/in/yelena-mishkin-080220a7

---
Source: https://flows.cv/yelena
JSON Resume: https://flows.cv/yelena/resume.json
Last updated: 2026-04-01