Daniel Loughran

GIS & Data Analyst   |   Greater Toronto Area

GIS & Data Analyst
Greater Toronto Area

Learn More

About Me

Skydiving

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.

So why are we here? Due to the technologically advanced time period that we live in, I decided to make a website that would help showcase my abilities and understanding of GIS, HTML, CSS, JavaScript, Bootstrap, and SQL. I feel it provides a platform for peers, colleagues, and prospective employers to learn a little more about who I am, including my drive and motivation to learn new things. I regularly update the website with my progress as well as present any new skills that I am learning, which currently includes Python, Alteryx, and AutoCAD.

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.

Parallax Alternative

Resume

  • Refined relationship-building skills and experience working collaboratively with clients and customers
  • Thirst for knowledge, able to quickly acquire new skills and adapt to new systems

Education

Certificate, Applied Digital Geography and GIS

Ryerson University (Toronto, ON. Apr 2016 - Apr 2018 (expected))

  • Courses focus on GIS principles including analysis of spatial data, the relational database model, and other cartographic standards.

Bachelor of Science - Geoscience, (Hons)

Liverpool John Moores University (Liverpool, UK. Sep 2006 - Jul 2009)

Professional Experience

GIS Analyst, Contract

Targeo, TC Transcontinental (Brampton, ON. Sep 2017 - Present)

Awarded contract extension following successful completion of summer internship. In addition to internship duties below:

  • Maintain spatial database following updates from distributors
  • Create distribution maps on client request
  • Communicate with distributors via phone/email to confirm geographic boundaries of distribution and provide help as required

GIS Analyst, Intern

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.

  • Daily use of ArcMap, Excel, Access, and Adobe Acrobat
  • Apply geoprocessing tools and toolbar commands including dissolve, create features, explode multi-part features, cut polygons, trace segments, and edit vertices
  • Utilized ArcPy to create a script that simplified the creation of a new field common to all shapefiles

Sr. Data Analyst & Unit Supervisor

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.

Skills

  • Windows Operating Systems
  • Microsoft Office Suite
  • HTML
  • CSS
  • JavaScript (including jQuery)
  • Bootstrap
  • SQL
  • ArcGIS, MapInfo, and ERDAS Imagine
  • Python (including arcpy)
  • Data formats including JSON, XML, KML, and GeoJSON
  • ArcGIS Online
  • Web Mapping JS API’s including Google, Bing, Leaflet, Esri, and Mapbox

Highlights

  • Top mark in the class with 99.6% in Spatial Databases and Digitial Cartography (July 2016) and 100% in Web Mapping (April 2017)
  • Helped train more than 30 employees over last 5 years
  • Recognized by both ExxonMobil and Seadrill for safety in the workplace

Community Involvement

  • Associate of the Toronto geospatial community with groups including:
  • Toronto GoGeomatics
  • Toronto OpenStreetMap Enthusiasts

Other Certifications

  • Esri: Do It Yourself Geo-Apps
  • Esri: Going Places with Spatial Analysis
  • Esri: Earth Imagery at Work
  • Standard First Aid with CPR C + AED
  • Permanent Resident of Canada
  • Driver’s License (Ontario) - Class G

Timeline


My Timeline

Education


Chang School Logo

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
Required Courses
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
Web Mapping A+ 4.33
Advanced Course: First Level
Spatial Statistical Methods A+ 4.33

Portfolio


My Maps



Mapping API's


Google Maps API w/ KML - NFL Directions Tool

NFL Directions Tool

Mapbox API w/ JSON - TTC Subway Times

TTC Subway Times

Leaflet API - My Work Sites

Work Sites

Web Mapping


Esri ArcGIS Online - NFL Teams & Stadiums vs State Population, 2010


SQL


Code (SQLite)

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:

SQLFiddle

Contact

Portrait

Dufferin St & Lawrence Ave W, Toronto, ON M6A