Python

Andrew Rochat

* ********* ***, ***, *** York, ***80

******.******.**@*****.*** / (914) 417 – 7189

https://www.andrewrochat.com - https://my-stock-dashboard-app.herokuapp.com/ EDUCATION

Washington University in St. Louis St. Louis, MO

Bachelor of Science Degree May 2020

Major: Computer Science, Finance

Cumulative GPA: 3.8/4.0, Honors: Dean’s List, Cum Laude PROFESSIONAL EXPERIENCE

Hungry Jacks Pty Ltd Sydney, Australia

Data Science Intern March 2019 – May 2019

• Used Python to create a historical weather database. Used a weather API to pull historical weather data, and then filtered and sanitized data to blend it with sales data. Subsequently developed a Tableau dashboard with blended information, which displayed hourly weather correlation down to a store level.

• Aggregated school and public holiday information and created a presentation that showed sales growth by holiday, store, and product. Information was used for targeted marketing campaigns, as well as variably increasing staff to match historical sales percentage increases Axegine Capital Management LLC New York City

Software Engineering Summer Intern June 2018 – August 2018

• Adapted to and refactored large legacy code base in python. Also built multithreaded system for asynchronously running back testing trading strategies

• Created a login security page using an LDAP protocol for automatically authenticating users based on Axegine's active directory. Also responsible for creating varying access levels for different security groups

• Used Python and Plotly Dash framework to build front end data visualization tools that showcased graphical representations of the market, leading to a streamlined process for traders to access their analytics LEADERSHIP EXPERIENCE

Computer Science Department at Washington University in St. Louis St. Louis Head Teaching Assistant December 2019 – January 2019

• Employed as a teaching assistant for CSE330 Rapid Prototype Development where I taught students how to create various websites with AWS, Apache, PHP HTML/CSS, and JavaScript with SQL databases

• Also covered more advanced topics such as .NET and JavaScript frameworks like React, XML, Node.JS

• Collaborated with professors and a dedicated team of fellow teaching assistants to create an effective and efficient learning environment by holding weekly office hours and grading assignments INDEPENDENT & RESEARCH PROJECTS

Stock Tracking Application 2020-2021

• Recently, I used Python with a Dash Framework to create a stock dashboard that provides market analytics

• To launch app, I used the Python web server Gunicorn, and I used Heroku’s free dyno to host it

• The app works by using a stock API called yfinance, which I use to pull stock information and pricing

• I also used an AP Scheduler with a Cron job and a second Heroku worker to update the market data in the background once a day. To store my stock market data, I used a PostgreSQL database Research Project for Washington University in St. Louis St. Louis Climate Data Preservation Research Employee 2018-2019

• Built an advanced web crawler to collect climate and other environmental data from federal government websites to ensure that it remains publicly available for research, advocacy, and citizen enforcement

• Built selenium web scraper using Python that archived several thousand government dockets

• Upgraded and expanded the web crawler’s versatility to work for a variety of government dockets such as standards for greenhouse gas emissions from various sources SKILLS + CERTIFICATIONS

• Computer Science Skills: Java, C++, JavaScript, React JS, HTML, CSS, SQL, MySQL, PostgreSQL, Python, Plotly, Plotly Dash, Flask, .NET

• Software: Microsoft Excel, PowerPoint, Tableau, Matlab, Unity, Xcode, GitHub, Heroku, AWS

Contact this candidate