G

George Guan

About

Detail

Software engineer at Apexiel, Inc.
Davis, California, United States

Contact George regarding: 
work
Full-time jobs
Starting at USD150k/year

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 0% verified
  • A
    Software engineer
    Apexiel, Inc.
    Sep 2022 - Current (4 years 2 months)
    - Designed and researched an aftermarket recommender system for grassroots racing enthusiasts on
    www.apexiel.com,which included racing events, car parts modification, and vendor recommendations.
    - Enhanced the accuracy and efficiency of recommendation algorithms for car customization playbooks based on user’s goals by A/B testing, user feedback, Large Language Model and diverse datasets.
    - Optimized product search engine accuracy and relevance by integrating chatGPT with advanced NLP
    techniques. Developed a comprehensive answer template and database for enhanced customer satisfaction.
    - Developed and maintained POC/MVP we
  • F
    Product engineer
    FLAGDream
    Dec 2020 - Sep 2022 (1 year 10 months)
    - Deployed a course recommender system for an online courses web app. www.uoffer.com by a hybrid of Weighted Zone Scoring and Popularity algorithms, resulting in a 9.8% increase in user search volume.
    - Created RESTful APIs and hosted a load-balanced Django backend to serve requests from frontends and used MongoDB with Mongoose.js for data management.
    - Improved company model accuracy by designing a comprehensive model training pipeline that includes data collection, feature definition, data cleaning, and model refinement from the CRM system.
    - Increased 15% user engagement time and 24% click-through rates via implemented KNN, simil
  • A
    Software engineer
    AILaw Inc.
    Jul 2020 - Dec 2020 (6 months)
    - Deployed a Flask-based web application (widget.ailaw.ai) that updated Visa Bulletin information monthly from www.uscis.gov, catering to a user base of over 10,000 immigration lawyers and applicants.
    - Designed and implemented web crawler with 5 modules (Downloader, Queue, Parser, Cache, Database) via Beautiful Soup libraries to collect, parse, and store data from www.uscis.gov into a MySQL database.
    - Increased data access efficiency by 20% through d
  • CABA Design
    Data administrator
    CABA Design
    Apr 2020 - Jun 2020 (3 months)
    - Built tags and triggers from google tag manager using CSS selector and JavaScript to track product function usage.
    - Collected data from backend and transform to daily report automatically by Python and GraphQL.
    - Summarized data from backend and provide to specific customer by Python, Power Query, Vlookup and Pivot Table.
    - Customize report from Google Analytics and analyzing the data to supervise and improve specific functions from customers and finally have successfully increased 10% average usage rate for all product functions by providing data analyzing report.

  • A
    Operations manager
    Activity and Recreation Center - UC Davis
    Jun 2019 - Mar 2020 (10 months)
    - Managed more than 1,000 equipment on campus and provide equipment to 5,000 patrons daily.
    - Managed more than 100,000 memberships in UC Davis (like students, staffs and faculties).
    - Managed facilities and equipment booking plan. Budget Management and Expenditure Report.
    - Supervise facility of 320,000-square-foot size.
  • U
    Pavilion technical staff
    UC Davis Student Affairs Marketing and Communications
    Sep 2018 - Jun 2019 (10 months)

    • Help UC Davis host large scale events for the campus community and beyond.
    • Schedule and communicate special project with events holder (including set up and take down event equipment).
    • Managed Event time and schedule appointment with event holder
    • Did internal/external communication.
  • Y
    International volunteer
    Yolo Food Bank
    Sep 2017 - Dec 2017 (4 months)
  • China Everbright Bank
    Assistant branch manager
    China Everbright Bank
    Jul 2016 - Aug 2016 (2 months)

    • Constructed Financial Analysis and Composed Financial Report.
    • Practice risk Management by using Probability Theory and Mathematical Statistics.
    • Practice product Management and Product promotion.
    • Assisted Manager supervise operation in the branch lobby. And summarized and report operation situation daily.
    • Recommended customers with suitable investment products based on customer specific information, and successfully get $700,000 cumulative investment from customers.
Education verified_user 0% verified
  • University of California, Davis
    BS, statistics
    University of California, Davis
    Jan 2015 - Jan 2020 (5 years 1 month)
  • University of California, Davis
    BA, economics
    University of California, Davis
    Jan 2015 - Jan 2020 (5 years 1 month)