Oliver Balen

- Utilized React Tables to create an interactive GUI displaying SQL and non-relational database visualizations and implemented manual and auto-generated SQL query functionality, allowing the user to manipulate a database through async calls in GUI - Reverse engineered NoSQL document data to dynamically generate schemas from the user’s NoSQL database connection - Implemented GitHub OAuth using Node.js Passport module to allow users to save, access, and execute past queries

- Built new features for admin and consumer-facing React/Redux app, a refactored app to use React Hooks, enforced linting, wrote unit tests, and created reusable components/helper functions - Contributed to optimizing SQL queries and replacing REST API with GraphQL reducing the need for redundant endpoints which sped up the app and created a better developer experience - Onboarded new developers, led technical planning, wrote SCRUM stories, and assisted in creating processes for working with a large team

- Built e-commerce pages with React, MobX, and hooks to manage complex UI behavior and state management - Outlined technical implementation of web application features with managers to properly size and delegate tasks - Configured Webpack pipeline to maximize code reuse and automate exporting multiple versions of HTML banners - Built HTML banners with an internal React-like ad library for Apple product campaigns - Improved internal libraries with components to integrate new features such as video playback

- In partnership with OS Labs, built an Open-Source dynamic TypeScript React prototyping tool with the ability to create local state with React-Hooks, or select Redux as a state management option - Designed a D3 tree to dynamically visualize the application’s React component hierarchy due to its streamlined implementation and ease of customization, while utilizing lifecycle methods to avoid shared DOM control

- Developed a very critical tool called Revenue Pricing and Management with Angular, Typescript and third-party libraries. - Created middlewares in ExpressJS to resolve Cross-Origin- Resource-Sharing (CORS) issues. - Developed REST api in NodeJS to imitate the back-end API response before it was made available. - Worked with SQL Server to write and execute SQL queries meeting the current user-requirements. - Developed code in C# .Net Entity Framework and wrote unit test-cases using MSTest.