William (Chunjin) Gao
Data Analyst | U.S. Army Veteran | CPA | MySQL | R | Python | Javascript seeking full-time Data Analyst Opportunities
I am a task-oriented developer, passion in coding and make things happen!
With previous work experiences as a full stack developer and a data scientist. I am proficient at python, Node JS, ETL building, machine learning models, visualizing business analytic findings and conducting high-quality presentations. Also, I am a client facing professional who put both internal and external clients’ needs first and I am comfortable working with people from all levels of an organization. Leadership skills are embedded in my blood and I am willing to take responsibilities and influence people around me to deliver excellence all the time.
Skills
Programming Languages & Tools
Projects & Experience
Data Analytics Projects
Zillow Housing Price Prediction | GitHub Link
Time series forecast and visualization
Technologies Used:
Python | ARIMA | plotly | seaborn | matplotlib | Pandas| Numpy | statsmodels | sklearn| yellowbrick | Colab | Jupyter Notebook |
Profanity In Lyric | GitHub Link
Machine learning clustering of songs with profanity lyrics in U.S. Billboard
Technologies Used:
API | Python | urllib | requests | scipy | pickle | sklearn | yellowbrick | wordcloud | plotly | seaborn | matplotlib | Pandas| Numpy | Colab | Jupyter Notebook |
Recommender Model | GitHub Link
Recommender machine Learning model using collaborative filtering with Book Crossing Datesets
Technologies Used:
Python | plotly | seaborn | matplotlib | Pandas| Numpy | surprise | Colab | Jupyter Notebook |
Travelman Problem | GitHub Link
Fly through all 50 U.S. state capitals without revisiting and back to origin with smallest distance
Technologies Used:
Python | Kepler.gl | Pandas| Numpy | time | geopy.geocoders | itertools | Jupyter Notebook |Explore more analytics projects Here
Full Stack Web Projects
Rich Core Checkout | GitHub Link
Course Catalog Site with Crypto Currency Checkout Module
Technologies Used:
MongoDB | Express | React JS | Node JS | Cripto JS | RichCore Payment API | DotENV | Nodemailer | Dropzone | Cloudinary Storage | Cookie-session | JavaScript | Material Design BootStrap | HTML5 | CSS3
DentSoft | GitHub Link
MERN Stack Dental Clinic Patient Management System
Technologies Used:
MongoDb | Express | ReactJs | nodeJs | coockie | Bcrypt | ReactStrap | html5 | css3 | Javascript| bootstrap4 |
Dent-Soft is a streamlined and standardized electronic system specially designed for multiple users in dental clinics, and it can be used by dentists to maintain daily records of their patients. DS provides user-friendly and comprehensive functionalities, covering treatment plan, schedule appointments, record medical exams, and accounts report management with all the facilities to maintain patient history.
Ramen-Ramen | GitHub Link
Restaurant Food Processing App
Technologies Used:
html5 | css3 | javascript | bootstrap4 | jQuery | node | express | MySQL | sequelized npm | Heroku | JawsDB
Coders Corner | GitHub Link
Students and Tutors Platform
Technologies Used:
html 5 | css 3 | Javascript | bootstrap4 | jQuery | Google Firebase | Mozilla API | Anime.js | AJAXExplore more games and tools here
Institute of Transportation Studies - Davis (ITS - Davis)
- Analyze Electric Vehicle (EV) charging event data in collaboration with ITS-Davis researchers to design sustainable business models and capacity expansion strategies for charging station providers
- Identify five consumer segments from a large EV charging dataset using R and MySQL
- Analyze EV charging patterns of the segments to recommend differentiated marketing strategies
- Geocode 71,000 addresses using Google API in Python to support urban vs highway charging network strategies and capture potential EV customers
- Propose and conduct feature engineering of existing EV charging sites with an Agile team and adeptly identified three attributes that could significantly increase the utilization of EV charging stations
- Project EV charging demands for the next five years using time series model
Davis CA
University of California - Davis
- Conduct sentimental analysis on business school forums to identify opportunities and threats to UC Davis
- Facilitate a military applicant strategy and tactics with the director of the MSBA program
- Collaborate with a team to support admissions efforts which preliminarily boosted applications by 15%
San Francisco CA
Accountant & Accounting Manager
- Analyzed inventory and cost data to facilitate ERP system upgrades in a midsize Ecommerce company
- Managed personal tax and business tax sector: assigned engagements, performed Quality Control, prepared more than 160 personal tax returns and 60+ C Corp, S Corp, LLC, and Partnerships returns using Drake System
- Managed 3 associates and prepared monthly financial statements for 20 companies using QuickBooks
- Built and maintained financial models in Excel for sales and payroll data analysis
- Processed periodic payrolls and filed payroll tax returns with 100% accuracy using Client Write Up
- Effectively interacted with IRS to resolve tax issues and saved up to $20k for clients overall
Columbus OH
Diesel Mechanic, Team Leader
- Monitored service schedules of more than 100 military vehicles and equipment to ensure full deployability
- Troubleshoot and repair equipment with analytical skills acquired through training and research
- Designed and implemented a new archive system for service packets and cut half of the processing time
Fort Wainwright AK
Education
University of California - Davis
GPA: 3.80
University of Berkeley Extension
Ohio State University
GPA: 3.56
Awards & Certifications
- AWS Certified Cloud Practitioner - Amazon Web Services
- SQL for Data Science by University of California, Davis on Coursera
- Python for Data Analysis on Codecademy
- Pandas Foundations Certification on DataCamp
- Certified Public Accountant - State of Washington