JOHN HIESTAND

adkekw@r.postjobfree.com LinkedIn Portfolio Github Indianapolis, IN

SKILLS: React, Redux, Python, JavaScript, PostgreSQL, Flask, HTML, CSS, Excel, R, @RISK, SQL, Docker, Git EDUCATION:

Columbia University - BA Psychology, 2004-2008

Indiana University - Master of Public Affairs, Master of Science in Environmental Science 2010-2012 AppAcademy - 1000 hour immersive full-stack web development course with less than 3% acceptance rate 2020 PROJECTS:

ECOFridge Flask, ReactJS, Material-UI, Docker, Heroku live github A unique grocery item organizer that prioritizes items in the fridge, freezer, and pantry to aid the user in finding recipes.

● Created an algorithm to sort groceries by their storage date, the current date, and food expiration data from the University of Nebraska.

● Built a relational database with FlaskSQL to store user groceries with their corresponding expiration data for the user.

● Implemented a pleasant and educational user interface to notify users of what foods require priority attention. STRABA Flask, ReactJS, Docker, Heroku live github A Strava clone that allows users to upload GPX data and run statistics as well as follow and comment on other athletes’ activities.

● Integrated Google Maps API into React components for users to share their run data with their followers.

● Created a relational database with FlaskSQL and implemented routes to interface between the React UI and Flask backend in order to facilitate in user interactions by following, liking, adding activities, and commenting.

● Developed user autonomy by linking their activities to their account, allowing for fast and efficient posting and deletion.

● Implemented social interactivity components that allow users to comment on and like other users’ activities and updating the state only.

Algo ReactJS, Redux, PostgreSQL, Sequelize live github A Robinhood clone where users can paper trade stocks using real-time API data and track their portfolio performance.

● Integrated fetched data and backend routes with Redux’s global store by dispatching actions only when sharing information across components.

● Ensured user privacy and autonomy by utilizing BCrypt hashing and JSON Web Tokens to prevent storage of plain text passwords and allow access to authorized users.

● Integrated simple data visualization elements with Chart.js 2 with different time intervals so the user can analyze stock performance.

Core Dump Javascript, ExpressJS, PostgreSQL, Sequelize live github A Stack Overflow clone where users can submit technical questions, answer, and rank other users’ questions and answers.

● Planned and built PostgreSQL database in order to facilitate user created questions, answers, and voting.

● Produced sign up functionality to allow users to securely create accounts with encrypted password storage as well integrated as JSON Web Token for user authorization and authentication.

● Enhanced the user experience by incorporating validations and database queries with Sequelize ORM. RELEVANT EXPERIENCE:

OnElectricCars.com

Founder/Owner Aug 2008- Present

● Created a website with a unique domain, hosting, and Wordpress framework with customized CSS, Photoshop images, and HTML.

● Negotiated with clients on sponsored posts, attended press events, and integrated ads to make the website profitable.

Shopwiki

Search Engine Optimization Specialist Sept 2009- Jan 2011

● Created content for merchants to maximize sales by integrating optimal keywords and links to searches.

● Researched the most popular keywords for a myriad of topics and directed daily web traffic to the search engine which grew 15% over the year.

ADDITIONAL WORK HISTORY:

Investor

Self Employed June 2015 - Present

● Utilizing behavioral economics, energy policy, and climate change policy research background with millennial values and global perspective into a diversified portfolio of investments that outperforms the Dow Jones Industrial Average and many investment firms.

● Doubled personal yearly income in 2020.

Head Secondary Science Teacher

CSIS International School Aug 2016 - Feb 2020

● Generated the yearly curriculum for science classes, plan engaging and fun differentiated STEM related instruction, project-based learning, 21st-century skills, laboratory activities for students of all abilities, and report student academic progress to parents.

● Chaired the school’s environmental committee, implemented reduce, reuse, recycle waste reduction techniques to minimize waste at school events by 80%.

● Taught multiple levels and disciplines of Science, including 6th Grade General Science, middle school Life Science, Earth Science, and Physical Science, and high school Biology and AP Biology. Middle School Science Teacher

Soojung Global Vision School April 2013 - July 2016

● I taught multiple STEM-related courses as well as English, including middle school earth science, life science, biology, 4th-grade science, and mathematics.

● Integrated online software to create a faster, easier, and modifiable system to schedule teachers classes. Oak Ridge National Laboratory

HERE Program Research Assistant June 2011 - Aug 2011

● Implemented behavioral economics theory to explain the energy paradox in the automotive industry, i.e. the undervaluation of fuel savings by consumers.

● Integrated @RISK software with Microsoft Excel to predict consumer automotive purchases under uncertainty about future fuel-savings using Monte Carlo simulation. Research was published with coauthor David Greene in Energy Policy and substantiated more strict federal CAFE standard policy during the Obama Administration. Indiana University

Graduate Assistant Jan 2011 - Dec 2011

● Helped edit and proofread briefs written by Professor Clinton Oster for congresspeople in Washington D.C.

● Developed an algorithm that included different climate tax policies into levelized cost of electricity models in Excel.

Contact this candidate