Brian Osgood

Data Professional

Experience

2019 - Present

AIM Consulting - Microsoft - Azure Ops

Data Analyst 2

Spearheaded a project to automate the processing of Azure Enterprise accounts through the bill pay processing system.

Interacted with multiple teams around the globe to facilitate the automation process.

Automation led to an 82% reduction in incorrect ticket submissions

2018 - 2019

Empire Strategists

Web Designer

Managed WebDesign and Data Analytics for multiple clients/stakeholders

Integrating SEO and GoogleAds to increase traffic to client’s pages

Designing of E-Commerce Storefronts

Built and deployed a SQL database to track store inventory

Designed machine learning algorithm to predict sales for the upcoming week

Built Dashboards for client’s web page analytics

2015 - 2018

AECOM

Geotechnical Engineer | Data Professional

Used Python and Pandas for ETL to breakdown pumping information over multiple iterations to feed into ArcGIS Database

Created and implemented a PowerBI dashboard built on top of 3PostgreSQL databases. Dashboard saved ~2 million dollars and accelerated project completion by 2 months.

Designed and deployed a cloud-based recording tool for non-technical workers to gather field data that would feed PostgreSQL database with Django.

Automated weekly report generation on a project by consolidating multiple excel files into one master file.

Managed field data collection and data cleansing in Excel, leveraged PivotTables and V-Lookup functions.

About Me

My background is in engineering, with field experience ranging from the arctic circle to war zones in the middle east. This has led me to always look for a better, faster way to accomplish any task while using the best means available. I enjoy unraveling the mysteries in data using machine learning and presenting clear, easy to interpret results.

Education

2018

General Assembly - Data Science Immersive

2015

B.S. Mining Engineering - University of Arizona

Skills

Python
SQL
ETL
PowerBI
Tableau
Data Visualization
Machine Learning
Regression
Git
NLP
Spark
Excel
Automation
Time-Series Analysis

Contact