Josh Trewhella

Austin, TX Phone: 281-***-**** Email: adxslz@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/josh-trewhella-mba/ GitHub: http://github.com/JoshTrewhella Business/database analyst with a background in business administration and skills in Excel, VBA, Python, and SQL from University of Texas’s data analytics boot camp. Technical Skills

Python, R, JavaScript, HTML5, SQL, GitHub, MongoDB, MySQL, PostgreSQL, GIT, AWS, Flask, Command Line, Shiny, Tableau, Excel, Scikit learn, TensorFlow, Databasing, Pandas, Jupyter Notebook Projects

Austin Crime vs COVID Cases Regression https://github.com/jenchick/Austin_Pandemic_Crime The purpose of this project was to analyze the rise in COVID cases against the crime rates in Austin’s zip codes.

● Tools: Postgres, SQL, SQLAlchemy, Tableau, Jupyter Notebook, Python, SKlearn, Matplotlib, Pandas

ERD and Postgres https://github.com/JoshTrewhella/Pewlett-Hackard-Analysis The purpose of this project was to clean sets of CSV employee data files to determine how many people will be retiring and be eligible for a retirement package.

● Tools: SQLAlchemy, PostgreSQL, PrimaryKeys, ForeignKeys Python Data Visualization https://github.com/JoshTrewhella/PyBer_Analysis Investigation on data analysis of ride data for a ride-sharing business. This shows the mean, median and mode of the total number of rides per city type, the average fares per city type and the total number of drivers per city type.

● Tools: Matplotlib, Python, Jupyter Notebook

Work Experience

Contract Analyst II 2020 – 2022

KGI Wireless Austin, TX

● Worked closely with Samsung, general contractors, and many jurisdictions to coordinate and forecast right of way and traffic control permit approvals to meet construction dates. Also participated in weekly meetings with Samsung to report on forecasting and status of applications.

● Applied for Right-of-way and traffic control permits and prepared Real Estate Construction packages for Verizon in the central Texas jurisdictions for 4G and 5G small cell installations.

● Coordinated with our engineering department to create and revise construction drawings and traffic control plans to satisfy jurisdictional requirements Contract Analyst 2018 - 2020

KGI Wireless Austin, TX

● Conducted audits on telecommunication real estate leases.

● Contacted local jurisdictions to determine zoning regulations for work on various telecommunication sites.

● Researched potential candidates for new telecommunication sites. Founder 2017 - 2018

Trejam Technologies Austin, TX

● Sold computer hardware online and invested in cryptocurrency Project Performance Analyst 2015 - 2017

Accenture Austin, TX

● Priced contract amendments that add additional scope to the current contract for Accenture’s leadership and the clients.

● Responsible for analyzing and consolidating performance data into deliverables for the client.

● Submitted periodical reports to the client based on desired metrics.

● Made improvements to the enterprise reporting process to allow generation, verification, and delivery of performance metrics to be more efficient. Human Resources Intern 2012 - 2013

Bristow Group Houston, TX

● Used organization skills to sort and record expenses of expatriate employees from different business units

● Updated employee salaries using Workday

● Created and submitted employee surveys

● Summarized company insiders’ 10B5-1 plans

Education

Certificate, Data Analytics

University of Texas, Austin Austin, TX

Masters, Business Administration

Texas State University, San Marcos San Marcos, TX

Bachelor of Arts, Psychology

Texas State University, San Marcos San Marcos, TX