Data Process Analyst

DAVID ADUROGBOLA

**** ********* **** ** **** *** MN 55433 612-***-**** ********@*****.***

Professional summary: Versatile in data handling and Analysis. Proficient in Geographic Information Science concepts with proven history of reducing errors to increase analytics quality.

Skills and competences:

ArcGIS (Enterprise, Pro, Online)

Advanced Internet Mapping

Non-Spatial and Spatial (GIS) data Visualization

Process Automation

Render data in Flask

Data Engineering

HTML/CSS

JavaScript

Python

Data Modeling

Project Management

Github

VBA

Relational Database Management

SQL Database Design and Administration

Advanced SQL Queries

Data Collection (APIs & Web Scraping)

Python Numpy & Pandas

Graphs, Plots and Maps

Work Experience

Center Point Energy May 2021 - Date Houston, TX

Geographic Information System Data Quality Analyst (Remote, Full time)

Apply best practice for capturing, utilizing, and automating field data. And determine appropriate data formats for given situations.

Analysis reports writing and ArcGIS process automation using Python programming language.

Connect to SQL database and perform SQL query with Python SQL toolkit and Object Relational Mapper (ORM).

Perform CRUD, model tables, and reflect existing databases using Python SQL toolkit and ORM.

Perform extract, transform, and load (ETL) processes using structure and unstructured data formats.

Create and manage spatial datasets including file geodatabase, shapefiles, KLM, and feature class files for GIS analysis.

Ramsey County Public Works Mar 2020 - Jan 2021 Arden Hills

Geographic Information System Intern (50%Remote, Full Time)

Utilize instruments such as GPS and total station surveying technology to effectively capture spatial data in the field and import it into GIS environment.

Design and document processes for converting raw data into products suitable for analysis.

Create data model to represent objects and relationships in dataset and apply data modeling techniques to database design.

Create data schemas, tables, and databases for relational datasets.

Create Aggregate queries and create subqueries for further data exploration.

Create visual representations of a database through entity relationship diagrams.

Connect to SQL database with Python SQL toolkit and Object Relational Mapper (ORM) and perform SQL query.

Apply advanced knowledge of relational database management systems such as SQL Server and ArcSDE.

Create and run Flask serve and Return API query results in JSON format.

Create static query endpoints in Flask and execute dynamic database queries with Flask.

Create and effectively utilize interactive maps and figures on the Internet as a vehicle to acquire and disseminate spatial data and solutions.

Juno Pacific Sep 2016 - May 2018 Anoka

Medical Device Process Analyst Assistant (Full Time)

Assess data for error and implement advanced data handling concepts to improve data integrity.

Clean data received via web application forms using Microsoft Excel, VBA, and python.

Create data model to represent objects and relationships in a dataset and apply data modeling techniques to database design.

Create schemas, tables, and databases for relational data and perform CRUD in PostgreSQL.

Create Aggregate queries, subqueries, and views and run subqueries off them.

Normalize data and Identify data relationships.

Create visual representations of a database through entity relationship diagrams.

Toema Nig Ltd Mar 2013 - May 2014 Port Harcourt, Nigeria

Cartographic and Geographic Information System Intern (Full Time)

Detailed collection of data in the field using GPS and synchronizing field data into appropriate GIS files.

Design and develop geodatabases, shapefiles, KLM, and feature class that promote data integrity and usability for spatial analysis in GIS environments.

Create data model to represent objects and relationships in a dataset and apply SQL Database and Advance Data Storage and Retrieval techniques.

Create schemas, tables, and databases for relational data.

Develop custom web applications and functional user interface.

ArcGIS process automation using Python programming language.

Create visual representations of a database through entity relationship diagrams.

Create and utilize interactive maps and figures using ESRI ArcGIS online and other platforms such as leaflet.

Use GeoJSON data to produce maps, plots, and graphs.

Education

University of Port Harcourt

PMB 5323 Choba East-West Rd, Port Harcourt, Nigeria

Saint Mary’s University of Minnesota

2500 Park Avenue Minneapolis MN 55404 612-***-****

BS Geography and Environmental Management.

(Evaluated by World Education Services, WES)

2009-2013. Credit units completed: 149.

MS Data Intelligence and Geo-Analytics. August 2016 – June 2020.

Credit units completed: 48

Relevant Projects

In fulfillment of my graduation requirements at Saint Mary’s University of Minnesota, I did an analysis of change in land-use in the Twin Cities between 2008 to 2017 using imagery data sourced from USGS (US Geological Survey) website. I used Supervised land-use classification and land-use transfer matrix methods to generalize land-use trends in the Twin Cities. The project titled ‘Exploring Land Use Change in a Twin-Cities Metro Suburban Area Between 2008 to 2017: City of Chaska Case Study’ is published in http://gis.smumn.edu/research-at-smu/grad-papers.shtml

Personal GitHub Link: https://github.com/5t4david

Linkedin: https://www.linkedin.com/in/david-adurogbola-62678a1b3/

Contact this candidate