# Francheska Orellana

> Software Engineer

Location: New York City Metropolitan Area, United States
Profile: https://flows.cv/francheska

Software Engineer excited about building and optimizing full stack applications in using JavaScript, TypeScript, React, Node, and SQL. Always down to learn new technologies too!

You can find me on GitHub: github.com/frorellana

On my off days, you can find me training some jiu jitsu, attempting to draw some pet portraits, or taking a nap with my cat.

## Work Experience
### Full Stack Engineer @ PayStandards
Jan 2023 – Present | New York City Metropolitan Area

### Software Engineer @ Indema
Jan 2023 – Jan 2024
• Volunteer as a software engineer, currently working on the frontend making bug fixes and implementing new features

### Software Engineer (Open Source) @ QLache
Jan 2022 – Jan 2023
• Designed and built a lightweight, eviction-conscious GraphQL caching library under the OSLabs tech accelerator
• Incorporated GraphQL library to implement partial query caching by parsing the Abstract Syntax Tree of the query string, improving the cache hit and miss rate and decreasing latency
• Implemented cache eviction policies with constant-time complexity across all dictionary operations - insertion, deletion, search - allowing the cache to scale and handle large amounts of data without sacrificing speed
• Applied TypeScript's powerful type-checking capabilities during development to proactively identify and fix potential issues before code execution, resulting in a more stable and reliable final product
• Employed Next.js to build a multi-page application, utilizing its file-based routing system and support for dynamic routes to create a demo website that showcases QLache and its speed in caching queries
• Used Jest's built-in assertion to conduct unit tests on all algorithms, ensuring their reliability and accuracy through thorough validation of expected output, resulting in fewer regressions and a more efficient development process

### Software Engineer | JobFile | An app enabling easy job application tracking @ Open Source
Jan 2022 – Jan 2022
• Designed a Postgres relational database to store and manage all applications related to a specific user, as well as all associated user information, ensuring security through the use of salting and hashing passwords
• Utilized React to handle multiple views, data fetching using RESTful APIs, state management, and component composition, creating a dynamic and interactive user experience

### Software Engineer | LinkPack | Bundle multiple links into a single easy-to-share short URL @ Open Source
Jan 2022 – Jan 2022
• Leveraged WebPack to optimize and bundle assets, using minification and uglification features to decrease bundled file size, resulting in faster load times and improved performance
• Adopted Redux to manage the global state, and created reusable components using the container pattern in React, resulting in a more manageable and uniform codebase via abstractions and the Flux architecture

### Software Engineer | Query Fairy | An API querying tool @ Open Source
Jan 2022 – Jan 2022
• Implemented a Node.js Express backend server with routes and controllers to handle HTTP requests and define endpoints, using middleware design patterns to modify incoming requests and outgoing responses

### Payroll Analyst @ New York City Department of Transportation
Jan 2018 – Jan 2022
• Utilized canned queries by the CITY HUMAN RESOURCE MANAGEMENT SYSTEM (CHRMS) to audit payroll
• Calculated payments owed to employees under union contracts using ad hoc queries in Query Studio (CHRMS)
• Performed thorough audit of past payroll records, detecting discrepancies resulting in incorrect payments totaling over $200,000 and applied enhanced processes to prevent future errors


## Education
### Bachelor’s Degree in Mathematics
Baruch College
Jan 2015 – Jan 2018

### Computer Software Engineering
Codesmith
Jan 2022 – Jan 2023


## Contact & Social
- LinkedIn: https://linkedin.com/in/francheska-orellana

---
Source: https://flows.cv/francheska
JSON Resume: https://flows.cv/francheska/resume.json
Last updated: 2026-03-23