Hello, my name is Brian Osgood and I am a Geotechnical/ Mining engineer turned Data Professional.
I started my journey into data science in college at the University of Arizona. I was offered an internship at MISOM technologies, which at the time was starting to gather thousands of data points each day on mining activities at some locations around the USA. I was tasked with generating graphs and showing trends in the equipment and I found it fascinating.
After graduating with a B.S. in Mining Engineering – Operations. I was hired at AECOM here in Seattle, to work on a Mining project in the Arctic Circle. While on that project I found myself gravitating towards streamlining reporting and attempting to gather all the extra operations data I could, I built several large excel sheets (10,000+ rows) as we had data from nearly 30 years of the project. These sheets gave us new insight into some key metrics we were monitoring and even changed the course of future operations.
My second project of note at AECOM was a 12-month deployment to Iraq in October of 2016 to work on the Mosul Dam\’s foundation emergency rehabilitation.My skills involving drilling and geotechnical monitoring had made me a perfect candidate for the position. The project was a combination of US engineers, and Italian Drilling Company (Trevi), Italian soldiers and the Iraqi Ministry of Water. While onsite, I was once again gravitating towards the automating of tasks and collecting data. My first automated action, was the collection and subsequent uploading of our drill/grouting logs to a Sharepoint server for personnel in the USA could perform a QA analysis. This saved every team member ~1-2 hours per day of transcribing from paper into Excel and then uploading to Sharepoint.
My next task came from the Project Manager, the United State Army Corps of Engineers (USACE) had spent millions installing an automated monitoring system that had to be joined with the onsite Italian database , use it hopefully, to help answer some very pressing questions that could affect the entire future of the project. I was chosen due to my history of getting the data set up correctly and having the best domain knowledge of the people onsite. After I received the necessary information, I was able to view both databases, only problem was they were SQL databases and I had never heard of SQL before. I told my PM to give me a week and I would have a strong enough knowledge of SQL to get the job done. The next hurdle for me was creating an interactive dashboard for everyone from the PM\’s boss to the Iraqi field worker. I was told to use Microsoft products only and discovered PowerBI. After several weeks of building, combining, cleaning, more cleaning and analyzing the data, I was able to fulfill the initial scope of work and made some other discoveries (sorry can’t tell you what it was on here).
After returning back to the USA, I returned to the mining project in the arctic circle, after 5 months, I was laid off from AECOM due to their subsequent loss of project. I decided making the big jump to Data Science was the best thing I could do for my future and researched Data Science courses in Seattle (I will mention here that I started learning Data Science through DataCamp.com after I completed my PowerBI project) I decided to take General Assembly’s Immersive Data Science course because I wanted to polish off my skills, and build a stronger foundation in Data Science.
I am now a Data Analyst 2 at Microsoft on contract through AIM Consulting!