MACSON OGIERIAKHI
Fayetteville,AR
Summary
Analytical data enthusiast with over 10 years of experience and a passion for turning raw data into actionable insights. Experienced in data filtering, processing, analysis, visualization, and interpretation using tools like Microsoft Excel/Google spreadsheets, SQL, Tableau, R, and Python. Proficient in machine learning skills like logistic regression and random forest techniques.
Overview
10
10
years of professional experience
1
1
Certification
Work History
CRASH ANALYST
Texas Transportation Institute
Bryan, TX
08.2022 - 07.2023
- Utilized R and Stata to extract, clean, transform, and analyze Texas crash data in an efficient way leading to completing deliverables at an accelerated pace by 10%.
- Analyzed traffic patterns to identify high-risk areas, decreasing crash rates in Bryan/College Station area by 15%.
- Developed and refined predictive models that reduced emergency response time by 25%
- Conducted predictive crash analysis to enhance better resource allocation, quicker dispatch, and efficient proactive measures
- Created excellent reports using R Markdown and gave compelling presentations to crash analytics team
- Conducted exploratory data analysis on crash incidences in the US and wrote literature reviews on the subject matter
RESEARCH DATA SCIENTIST
Texas A&M University
College Station, TX
08.2018 - 07.2023
- Utilized machine learning techniques such as logistic regression, random forest, and decision trees to enhance classification and make yield predictions, achieving a 25% improvement in harvest accuracy.
- Developed custom R functions to automate complex statistical analyses, enhancing process efficiency by 50% and significantly reducing time-to-insight for key decision-making metrics
- Conducted statistical analysis of consumer behavior of Greek and non-Greek yogurt purchases in the USA, conveying price elasticity estimates to stakeholders
- Used quasi-experimental modelling techniques such as the two-way fixed effects difference-in-differences model to investigate the impact of California mandatory recycling policies on amount of waste deposited on landfills (9% reduction due to the policy).
STATISTICAL RESEARCH ANALYST
University of Benin
Benin, Edo, NG
03.2013 - 07.2018
- Used statistical methods such as linear and logistic regression techniques to draw meaningful conclusions from agricultural data. My findings coupled with the dissemination of the information to farmers led to an increase in cassava yield by 10% in my local government area.
- Trained undergraduate students in statistical packages such as Microsoft Excel and R to do qualitative and quantitative data analysis and data visualization. This led to an improvement in student scores by 12% on average.
Education
PH.D. AGRICULTURAL ECONOMICS -
Texas A&M University
12.2023
M.SC. AGRICULTURAL ECONOMICS -
University of Benin
07.2016
B.SC. AGRICULTURAL ECONOMICS -
University of Benin
08.2010
Skills
- Visual Basic querying
- Create data visualizations using Power BI, Tableau, ggplot2 and Excel
- Machine learning tools such as random forest
- Perform SQL queries
- Use tidyverse package in R
- Create Reports in R Markdown and Jupyter Notebooks
- Proficient in Python
- Use of pivot tables in spreadsheets for data summary
- Excellent presentation of results
- Interpersonal skills
- Teamwork, creativity, and problem-solving
Certification
- Google Data Analytics Certificate
- John Hopkins University R Programming Certificate
- John Hopkins University Getting and Cleaning Data in R Certificate
- Learning SQL Programming Certificate - LinkedIn
- Intermediate SQL Certificate - Sololearn
- Advanced Professional Development Certificate - Texas A&M University
- Intermediate Professional Development Certificate - Texas A&M University
- Basic Professional Development Certificate - Texas A&M University
- Getting Started with Tableau Certificate - Skilljar
Timeline
CRASH ANALYST
Texas Transportation Institute
08.2022 - 07.2023
RESEARCH DATA SCIENTIST
Texas A&M University
08.2018 - 07.2023
STATISTICAL RESEARCH ANALYST
University of Benin
03.2013 - 07.2018
PH.D. AGRICULTURAL ECONOMICS -
Texas A&M University
M.SC. AGRICULTURAL ECONOMICS -
University of Benin
B.SC. AGRICULTURAL ECONOMICS -
University of Benin
- Google Data Analytics Certificate
- John Hopkins University R Programming Certificate
- John Hopkins University Getting and Cleaning Data in R Certificate
- Learning SQL Programming Certificate - LinkedIn
- Intermediate SQL Certificate - Sololearn
- Advanced Professional Development Certificate - Texas A&M University
- Intermediate Professional Development Certificate - Texas A&M University
- Basic Professional Development Certificate - Texas A&M University
- Getting Started with Tableau Certificate - Skilljar
Similar Profiles
Ethan PorterEthan Porter
STUDENT RESEARCH COORDINATOR at Texas Transportation InstituteSTUDENT RESEARCH COORDINATOR at Texas Transportation Institute
Christopher ArringtonChristopher Arrington
Business Administrator II at Texas A&M UniversityBusiness Administrator II at Texas A&M University
Roya Etminani-GhasrodashtiRoya Etminani-Ghasrodashti
Associate Transportation Researcher, Transit Mobil at Texas A&M Transportation InstituteAssociate Transportation Researcher, Transit Mobil at Texas A&M Transportation Institute