Experience:
Rheem, Remote
Sustainability Data Analyst, May 2024 – Present
• Lead data transfer efforts to new data management platform (Watershed) from legacy data system.
• Validated and cross-referenced GHG emissions data ensuring accurate and complete data transfer.
• Created PowerBI dashboards displaying GHG, electricity, and HFC emission trends.
MNM LLC Conoco, Aurora, CO
Junior Data Analyst, January 2023 – Present
• Increased sales 15% year-on-year by identifying trends and recommending promotion strategies.
• Used PowerBI to create monthly sales reports regarding fuel, merchandise, and grocery sales.
• Performed SQL joins with data imported from National Weather Service to conduct seasonality analyses.
• Collected customer survey data to guide analysis and tweak marketing campaigns.
• Visualized fuel price/demand relationships using time series data in Python.
PepsiCo, Plano, TX
Data and Analytics Intern, June 2022 – August 2022
• Discovered performance cannibalism among simultaneous promotion campaigns using time series sales, price, and
demand data.
• Revealed product promotion sensitivity via multivariate visualizations using Python which resulted in exposing
significant contrasts in different market regions.
• Completed backlogged back-end code review for optimization models in Azure DevOps environment.
• Suggested improved pricing strategies by forecasting product price/demand via XGBoost model.
• Advised data science management with curated action strategies by finding trends in price/demand among correlated
promotions.
• Reported my findings to fellow interns, managers, and executive leadership within the Data Analytics division.
Vexcel Imaging, Boulder, CO
Production Support Specialist II, May 2021 – October 2021
Production Specialist, May 2019 – May 2021
• Enhanced data processing efficiency over 20% by swiftly resolving production issues via Jira environment.
• Saved over 30% (~$300k) in AWS storage costs through data cleanup and organization efforts.
• Eliminated 6 hrs./week of manual data entry by using python to automate process for myself and team.
• Achieved over 90% deliverable acceptance rate from offshore counterparts through training in production pipeline
tasks, DXM editing, and quality control measures resulting in optimized offshore team workflows.
• Improved client satisfaction by consistently producing high-quality deliverables in aggressive deadline environment.
City of Fort Collins Utilities, Fort Collins, CO
Spatial Analyst Intern, June 2018 – May 2019
• Played key role in department's 100% conversion from CAD to GIS through high profile data cleanup efforts.
• Utilized SQL queries, construction development plans, and UView to conduct project research and asset management.
• Supported lead GIS Analyst by performing heads up digitizing, and geoprocessing.
• Ensured data integrity of Geospatial Sensor data through QA/QC analytical tools in Enterprise-based databases.
Geospatial Centroid, Colorado State University, Fort Collins, CO
Spatial Data Consultant, March 2018 - December 2018
• Partnered with The Nature Conservancy: Global Lands science team in creating foundational data sets resulting in
priming renewable energy projects in India.
• Assisted with GIS related inquiries from Geospatial Centroid visitors.
• Provided deliverables for professors to use in lecture in the Semester at Sea program at CSU.
• Generated a database which contained a list of free, open sourced, global data sets.
Education:
Western Governors University
M.S. in Data Analytics
Colorado State University
B.S. in Ecosystem Science and Sustainability
Minor in GIS
Skills:
CS Languages SQL, Python, DAX, Git. Exposure to R, HTML, Java, C
Data Visualization Tableau, PowerBI, Python, R, Excel
Data Management AWS s3, Azure DevOps, GitHub, Reliance, Watershed
Geospatial ESRI Suite
Version Control Jupyter Notebook, Databricks, GitHub, and ArcGIS Enterprise
Additionally:
https://drive.google.com/drive/u/1/folders/11JLdN0WhzvQGmlBh_rDkMgIWOwA6gZU9