Steven Lineses

Created a native mobile app beat sequencer and beat pads that trigger audio samples and allow looping.

Built with React Native and expo-av library for UI and audio handling. Implemented JavaScript interval timers to provide clock to sequencer tracks. Sound pads support instant tap playback and long-press for indefinite looping.

Reverse engineered a website's REST API (with permission) to provide searchbar functionality and built a custom frontend on top of it.

Inspected network calls from the website's frontend to backend, determined necessary API endpoints and JSON payloads, then built a backend wrapper and frontend component communicating via AJAX. This provided unique functionality not available to other customers.

ETL'd hundreds of millions of State of Idaho financial and payroll records into the OpenGov reporting platform.

Created a comprehensive suite of tools to extract, transform, load, and validate data end-to-end using MySQL, SQL Server, SSIS, Python, Bash, and Selenium.

Created centralized online administration tool for the League of Legends esports club at Boise State.

Provisioned and secured a VPS with OctoberCMS. Built features including user registration, email validation, player/team management, statistics, leaderboards, and opponent tracking using various CSS and JavaScript libraries.

Consumed NBA API for player statistics and created novel analyses on the data.

Used Python to request NBA API data, parsed JSON responses into MySQL tables. Wrote SQL scripts for analysis and visualized results with Matplotlib. Frontend built with HTML, CSS, JavaScript, Bootstrap, and DataTables.

Star Wars character lookup tool using SWAPI with AJAX-powered search by height.

Extracted data via Star Wars API and loaded into MySQL. Users can search characters by height (feet/inches). Color palette generated from Star Wars poster artwork.

Career outlook tool extracting and ranking job data from Bureau of Labor Statistics.

Extracted tabular data from PDF sources into MySQL. AJAX-powered search with direct links to BLS for detailed information. Results ranked based on study findings.

Random cocktail generator using the CocktailDB API.

Fetches random cocktail data from external API, processes through Jinja template engine, and renders beautifully in HTML.