GIS & Data Analyst | Greater Toronto Area
GIS & Data Analyst
Greater Toronto Area
I was born and raised just outside of Liverpool, United Kingdom. In 2010, I moved to Toronto on a temporary work permit and spent 6 months exploring the city and meeting some great people. I had so much fun that I wanted to make the switch permanent. It took a few years but I was finally able to move back in July 2013, and in 2016 I obtained my permanent residency! After 6 years of professional experience in the oil and gas industry, the time is right for me to follow my ambitions of a career in GIS. At present I am hired as a GIS Analyst intern with Targeo, a Transcontinental Company.
I have had a keen interest in GIS ever since my first introduction at Liverpool John Moores University but my passion for maps goes back to my childhood when I would often spend countless hours scrutinizing the world atlas and my illuminated globe that I inherited from my older brother. This coupled with my knack for data and computers makes GIS and digital mapping the career choice for me.
Ryerson University (Toronto, ON. Apr 2016 - Apr 2018 (expected))
Liverpool John Moores University (Liverpool, UK. Sep 2006 - Jul 2009)
Targeo, TC Transcontinental (Brampton, ON. Sep 2017 - Present)
Awarded contract extension following successful completion of summer internship. In addition to internship duties below:
Targeo, TC Transcontinental (Brampton, ON. Jun 2017 - Aug 2017)
Joined the GIS marketing team to assist on internal project to standardize database and associated shapefiles.
Schlumberger Canada Ltd. (St. John's, NL. Feb 2011 - Jun 2017)
Hired as Jr. Mud Logger and promoted to Sr. Mud Logger within 12 months. This was followed with promotion to Jr. Data Analyst in August 2012. A series of increasingly responsible supervisory duties were added based on strong leadership performance.
I am currently enrolled in the 'Applied Digital Geography and GIS' certificate at Ryerson University. The certificate consists of six courses and is designed for professionals currently practising or anticipating careers in digital geography and geographic information systems (GIS).
The first four courses of the certificate were taken online using the distance option available to continuing education students. The courses thus far have really helped to build upon the skills that I acquired at LJMU, while also introducing newer technologies and concepts that I am getting a really good grasp of. My hope is that the certificate will help lead me onto a successful career path in the GIS industry. I will be taking the two remaining courses in the classroom.
The following table displays my progress:
|Course||Letter Grade||Grade Point Average|
|Spatial Databases and Digital Cartography||A+||4.33|
|Digital Geography and Spatial Analysis||A||4.00|
|Electives: Group A|
|Digital Geography Applications in Community & Social Services||A+||4.33|
|Electives: Group B|
|Customizing GIS Software: Applications Programming||A||4.00|
|Advanced Course: First Level|
|Spatial Statistical Methods||In Progress|
Using SQLite, a relational database management system, it is possible to create, read, update, or delete data. The following example code is used to create two tables called 'NFL Teams' and 'NFL Stadiums'. Then using a select statement with a join clause, the two tables can be joined using a common attribute, which in this case is the 'NFL ID'.
This code can be tested at SQLFiddle. Below is a screenshot of the result: