Andrew Graves Email & Phone Number

Oakland, Ca, Us

San Francisco, Ca, Us

San Francisco, Ca, Us

San Francisco, Ca, Us

• Designed dynamic reports in SSRS to assist various departments with data analysis. Scenarios ranged from analyzing the performance of hundreds of in-network providers to analyzing the company’s overall performance in timely claims payment. • Built ETL pipelines using Python and SSIS to automate data flow processes between numerous healthcare clients.• Analyzed incoming and outgoing electronic data interchange files that contained protected health information to ensure HIPAA standards were achieved.

San Francisco, Ca, Us

New York, Ny, Us

Developed comprehensive business-applicable projects in an ACCET-accredited, full-time immersive data science program. • Electricity Load Forecasting: Interpreted electricity consumption of over 70 buildings at UC Berkeley. Created time series models to forecast future electricity use based on multiple years of data. Built interactive Tableau dashboard to display forecasts. • Clustering Climate Change Tweets: Analyzed 20 million tweets using MongoDB in AWS EC2 instance. Utilized NLP techniques to perform topic modeling, then identified clusters in data to determine sentiment trends on climate change by geographic location. • Predicting Top 10 Songs in the Billboard Hot 100: Obtained audio feature data for Billboard Hot 100 songs from Spotify API. Refined logistic regression model to identify the ideal elements of a song that guarantee a top 10 hit. Deployed model through an interactive Flask app that predicts a song's probability of reaching the top 10. https://github.com/gravesa333

Irvine, California, Us

• Analysis Phase: Performed exploratory data analysis on client's energy consumption to identify system issues and recommend potential improvements. • Design Phase: Selected equipment based on energy consumption and payback calculations. Designed construction drawings, wrote construction specs, and generated construction cost estimates. • Construction Phase: Reviewed and approved contractor submittals, e.g. equipment documents, requests for information, and payment applications.

Irvine, California, Us

• Analyzed the AC demand and energy usage of four South Bay buildings in order to design thermal energy storage tanks• Recommended installation of tank at each building based on payback calculation

Phoenix, Az, Us

• Documented daily progress of the construction of two public libraries• Overviewed submittal registers of the primary contractors• Maintained records of contractors’ RFI’s• Recorded minutes of weekly construction meetings