Alvin Ruan

Experience

• 

  All New Tile

  Mar 2015 - Sept 2015

  Office Assistant

  • Promotion of available sales to current and former consumers • Optimized and organized products for distribution, profits, losses, and assets • Recalculated and reallocate leftover products to minimize error margin • Catalogued inventory to make it more accessible for consumers • Helped decipher new item introductions and discontinuation of less marketable items • Estimated quotations.

• 

  Facade Construction

  Sept 2015 - Dec 2015

  Marketing Associate

  • Assisted with budget planning by preparing financial statements and reports through in-house software • Created, received, and entered invoices using MS Excel • Processed all bills for the company and settled financial disputes • Calculated assets, losses, and profits for the company, and recommended more profitable investments • Reached out to former customers to discuss existing projects in relations with the company

• 

  Personal Trader

  Feb 2016 - May 2017

  Personal Trader

  • Use of macro-economic outlook, market trends, researched statistical patterns, and technical analysis to develop profitable trading ideas• Generated 40% profits through trading with the initial funds• Monitor daily stock market activities and performance of individual shares for potential entries• Maintain both day-to-day and medium-term strategies • Implementing risk management and position sizing strategies

• 

  Oppenheimer & Co. Inc.

  Jun 2017 - now

  - Identified and helped managing directors developed more efficient workflow through use of Microsoft VBA - creating 1 button spreadsheets retrieving LIVE data from Bloomberg’s database - helping identify opportunities during New Issues- Focused efforts in improving current infrastructure in Sales & Trading by implementing by creating numerous template spreadsheets - optimized and reduced work by 80% - Developed 5 reports for senior management to help gauge & improve fixed income production- Helped each sales desk identify production opportunities with existing accounts within firm - average of 2x opportunities Show less • Identifying and establishing more efficient ways to accomplish projects• Match VSPs to corresponding dates and cost basis to help clients optimize their tax profit and loss• Process the daily exchanges of securities as well as name changes, stock split, stock dividends, mergers, and ACATs• Assisted in identifying and correcting errors found on both the Insight program and 1099 tax forms• Check and correct inconsistencies in options and receive & deliver reports ensure the correct information is provided for anyone whose viewing the Insight generated reports • Reach out to financial advisors to establish whether certain clients are eligible to certain cost basis updates due to IRS regulations Show less

• 

  Personal Software Engineering Projects

  Apr 2023 - Jul 2023

  P2P donation app facilitates people seeking local donations and donors.- Designed and created the Location & Map Page of the application as well as built an reusable map component for teammates to use on individual item pages.- Utilized OpenCage geocoding API to convert string addresses to longitude & latitude, and passed the data to Google Maps API to generate a visual representation of where the user’s surrounding donations are.- Collaborated with team to structure a Non-Relational DB Schema in MongoDB to organize the information that would be required & passed throughout the application- Adopted 5 new technologies - (Typescript, Next.js, Prisma, Vercel, Tailwind CSS) within a limited timeframe and successfully delivered on all business requirements. Show less Refactored monolithic ecommerce backend microservice optimized to support high traffic- Built multi-layered backend system with initial capacity of 200 RPS optimized to handle 4000 RPS, an average of 1200% increase in throughput performance- Improved PostgreSQL DB queries speed from 25s to 0.30ms by analyzing execution plans and implementing indexes and aggregations- Utilized Loader.io and K6 to identify and resolve bottlenecks and performance issues- Scaled application to sustain 4000 RPS by horizontally scaling with NGINX through 4 AWS instances and Redis caching Show less Ecommerce fashion store application for users to shop and browse products.- Designed and created single page React application drawing data from RESTful API backend- Increased Google Lighthouse performance to 98 and accessibility to 96 through alt tagging - Constructed the review functionality with ability to customize and sort for specific criteria's- Utilized Jest, Mocha, & Chai to implement a thorough testing suite, ensuring the code's quality through comprehensive testing procedures - achieving 80% code coverage Show less