Data Scientist with five years experience in BI

CHARLES HOPGOOD, M.Sc.

+*(***)***-*** *****************@*****.*** linkedin.com/in/charles-hopgood PROFESSIONAL SUMMARY

Results-driven Data professional with five years of experience and a strong academic background in economics and data analytics. Skilled in transforming complex datasets into actionable insights and bridging technical and non-technical teams. Proficient in data engineering, econometrics, GIS, and machine learning. EXPERIENCE

Estudios Técnicos, Puerto Rico

Data Scientist 09/2020 – Present

• Built Machine Learning algorithms to predict multiple variables for multi-million-dollar projects, including a U.S. county's early flood detection system with a 99.9% accuracy.

• Created company-wide data infrastructure, organizing, cleaning, and managing millions of observations of data in Postgres databases. Used fuzzy matching techniques to clean and create commonality between datasets.

• Led a team in the collection and mapping of primary market areas for hundreds of financial institutions and businesses.

• Spearheaded a project for McDonald's to identify high-opportunity zones.

• Managed, visualized, and analyzed real estate and short-term rental data from diverse sources, incorporating factors that could impact markets.

• Developed SARIMA forecasts with R and identified trends via statistical analysis and Exploratory Data Analysis (EDA).

• Geocoded millions of addresses and mobile device data to calculate market penetrations for Puerto Rico's State Department.

• Designed dashboards and data models in Power BI for clients to comprehend their business data and competitive landscape.

• Assessed financial statements to determine appropriate import tariffs for Puerto Rico's Environmental Department.

CORE COMPETENCIES

• Data Analysis & Visualization: Excel, Power BI (DAX), Stata, Python, SQL, R

• Geospatial Analysis: QGIS, ArcGIS, PostGIS

• Database Management: PostgreSQL

• Languages: English (Native), Spanish (Native)

EDUCATION

• Master’s in economics, University of Valencia, Valencia, Spain 2023–2024 Published thesis. Awarded 1st Place in Port Valencia Award for Best Thesis

• Bachelor of Business & Economics, University of Kentucky, Lexington, KY 2008–2012 Alpha Lambda Beta & Phi Sigma Theta Honor Society Member

Contact this candidate