Data Analyst Python

Justin Collins

SKILLS AND CERTIFICATIONS

Skills: SQL • Python (NumPy, Pandas) • Excel (Macros, Pivot Tables, VLOOKUP) • Linux • Git • GCP • Scala • JavaScript Certificates: Tableau Desktop Certified Associate • AWS Certified Solutions Architect – Associate EXPERIENCE

Data Analyst (Commerce) Analytiks Seattle, WA Jan 2020-March 2020

• Using Tableau crafted detailed commerce-based dashboards which clients then used for budget and sales analysis.

• Parsed and cleaned unstructured and inconsistent data across multiple SQL server tables with 100 plus line queries.

• Automated Google Sheets data ingestion and transformation from a database with JavaScript application.

• Enhanced client’s peer review survey analysis by processing open-ended responses with AWS’s NLP and Python. Software Engineer Intern SoundCommerce Seattle, WA July 2019-Sept 2019

• Developed continuous integration pipeline to build repository on each commit using GCP, Git, Linux, and Docker.

• Fixed all twenty broken tests written in Scala. Subsequently added testing into the continuous integration pipeline.

• Notified developers of repository build status using GCP serverless function and Bitbucket API.

• Enhanced security by encrypting account information on serverless function using GCP’s Key Management Service.

• Deployed Kubernetes cluster running Kubeflow pipeline to be used for AI training and prediction. Data Analyst (Astronomy) University of Washington Seattle, WA Sept 2016-June 2017

• Saved department hours of work by significantly automating human involved categorization process with Python.

• Wrote Python program which analyzed and compared a spectral dataset against a SQL query. The program automatically produced a report later used by galaxy halo researchers. Visual example Math and Coding Tutor Self-employed Seattle, WA Sept 2014-Nov 2019

• Administered small business. Self-promoted marketing and networking. Acquired twenty-five plus clients.

• Improved grades. Highly recommended by students and parents. Recommendations PROJECTS

Connect Four AlphaGo-like AI (Python, Keras) Project

• Built Monte Carlo Tree Search to select nodes (game states) which are evaluated by rollout simulations.

• Trained convolutional neural network to use learned intuition to influence node selection during tree search.

• Excels in play with 100% win rate against its ten plus human competitors. SNP500 Stock Prediction (Python, Pandas, Scikit-learn, Keras, Excel) Project

• Automated ETL on minute granular data for 100+ stocks later cleaned and used for prediction with LSTM networks. EDUCATION

University of Washington Seattle, WA Sept 2014-June 2017

• Bachelor of Science in Physics and Astronomy with Honors. GPA: 3.7 ADDITIONAL EXPERIENCE

• Debated in high school and coached for two years. Judged at national tournament in Beijing. Recommendation

• Taught English in China, Korea, and West Africa with three separate organizations.

• Physics teaching assistant at the University of Washington.

• Self-taught programmer and avid puzzle solver.

206-***-****

***********@*****.***

18004 1st

Ave NW Shoreline WA 98177

Linkedin.com/in/Justintc217

github.com/Justintc217/portfolio/

suzhiquest.wordpress.com/

Contact this candidate