Summary
Websites
Overview
Skills
Project
Work History
Timeline
Work Preference
Work Availability
Software
Languages
Interests
Accomplishments
Certification
Education
Quote
c3
Collins Anyanwu

Collins Anyanwu

GIS/Data Engineer Consultant
Lagos,LAG

Summary

GIS Coordinator | Data Engineer who delivers measurable results through spatial technology. At Ikeja Electric, I have improved operational tracking by 75% and data access efficiency by 65% through strategic implementation of GIS solutions and database architecture.

My expertise spans ArcGIS Enterprise, SQL/PostgreSQL, Python automation, and Power BI visualization—transforming complex spatial data into actionable business intelligence.

Known for bridging technical expertise with business needs, I excel at developing end-to-end solutions from field operations to executive dashboards. My focus: delivering practical geospatial innovation to the utility sector through cloud platforms, predictive maintenance systems, and automated workflows.

Overview

20
20
years of professional experience
7
7
Certificate
7
7
years of post-secondary education

Skills

  • GIS: ArcGIS Enterprise, ArcGIS Online, ArcGIS Pro
  • Python (Data Analysis, Automation)
  • Web Technologies (JavaScript, HTML, CSS)
  • Cloud Platforms, Apache Airflow & PySpark
  • Remote Sensing & Spatial Analysis
  • SQL (SQL Server, PostgreSQL/PostGIS)
  • Data Visualization (Power BI, Tableau)
  • Open-Source GIS (QGIS)
  • Data Integration/ETL (FME concepts)
  • Agile & CI/CD Methodologies

Project

Operational Performance Power BI Dashboard — Ikeja Electric Plc
2024 - 2025
• Track load distribution across different parts of the network
• Monitor outage frequency, duration, and resolution times by area
• Visualize transformer and substation performance metrics
• Create KPI scorecards for comparing actual vs. target performance
• Enable drill-down capabilities for deeper analysis by location


Data Science Projects: Predictive Maintenance System for Electrical Infrastructure - Ikeja Electric Plc
2024 - 2025
• Collect and analyze historical failure data from transformers, cables, and other grid components.
• Identify patterns and early warning indicators of equipment failure.
• Build predictive models using classification algorithms.
• Create an alert system for maintenance teams.


Enterprise GIS Platform Migration — Ikeja Electric Plc
2019 - 2020
• Architected and led migration of enterprise GIS data to cloud platform, improving data access efficiency by 40%.
• Implemented ETL pipelines using Python and SQL for seamless data integration across systems.
• Deployed real-time updates capability within a hybrid environment, enhancing operational decision-making.


Field Operations Tracking System — Ikeja Electric Plc
2018 - 2019
• Developed geospatial products using ArcGIS Online, Survey123, and ODK, improving asset and field officer tracking by 55%.
• Created interactive dashboards for management to visualize and analyze field operations in real-time.
• Integrated GIS with enterprise systems (SCADA, Asset Management) for comprehensive operational insights.

Work History

GIS Coordinator

Ikeja Electric Plc
11.2017 - Current

• Evaluated 15+ emerging GIS technologies including ESRI Enterprise and remote sensing applications, implementing 8 Python automation scripts that reduced mapping process time by 35%.
• Coordinated 12 cross-departmental GIS projects utilizing ArcGIS Pro, maintaining 99.7% geodatabase integrity and reducing field data collection time by 45% through customized Survey123 forms.
• Deployed 6 interactive ArcGIS Dashboards integrating mini-SCADA data from 15000+ network assets, improving outage visualization response time by 40% and reducing service restoration delays by 28%.
• Created 4 standardized network analysis workflows and spatial analytics procedures, generating 22 ArcGIS Online applications that increased operational decision-making efficiency by 32%.
• Implemented FME data integration pipelines connecting 5 enterprise systems, automating 18 weekly reports and reducing manual data processing time by 67% through custom ETL processes.

GIS/Data Engineer Manager

PoloSoft Technologies Pvt. Limited
09.2016 - 10.2017

• Orchestrated seamless data architecture integration between database systems and BI platforms using AWS Redshift and Snowflake, engineering robust data warehouse solutions that directly supported core business objectives and enhanced cross-functional data accessibility.

• Established technical training protocols for junior engineers covering PySpark optimization, Databricks notebook workflows, and advanced SQL techniques, resulting in measurable team efficiency gains and reduced production errors.

• Engineered sophisticated data transformation pipelines for complex geospatial datasets using Apache Airflow and AWS Glue, implementing custom ETL workflows that converted raw location information into structured analytical assets for executive decision-making.

• Directed a technical team of 14 GIS data professionals implementing CI/CD practices with GitHub Actions and AWS CodePipeline, ensuring consistent delivery of high-performance data solutions while maintaining project timelines through effective technical leadership.

• Designed and deployed scalable data integration architecture using Databricks Delta Lake and AWS Lambda for event-driven processing, creating automated data pipelines that streamlined ETL workflows and expanded analytical capabilities across multiple business units.

GIS/Database Specialist

Spatial Matrix Limited
10.2012 - 08.2016

• Executed 5 PostgreSQL/PostGIS migrations (500+ GB) with 99.8% uptime, utilizing pgAdmin and FME for ETL processes that reduced transition time by 40%.

• Configured SQL Server and Oracle spatial databases for 12 projects, implementing normalized schema designs that improved query performance by 65% across ArcSDE environments.

• Developed 8 Power BI dashboards integrated with ArcGIS Enterprise, creating 32 custom reports that decreased stakeholder decision time by 47%.

• Performed spatial analysis on 2TB of data using ArcGIS Pro and Python, identifying 14 critical infrastructure patterns that reduced network vulnerability by 28%.

• Created 18 custom cartographic products using QGIS and Adobe Illustrator, delivering map products that increased client satisfaction ratings by 92%.

Geologist

EarthSource Hydrocarbon
06.2010 - 07.2012

• Participated in field investigations, collecting vital geological samples for laboratory analysis and interpretation.
• Contributed to the development of new exploration targets through rigorous data evaluation and synthesis.
• Conducted comprehensive geophysical surveys for accurate subsurface characterization and resource estimation.
• Developed comprehensive reports that communicated complex geological concepts to non-technical audiences effectively.

GIS Technician

Spatial Technologies Limited
01.2005 - 05.2010

• Performed geospatial analyses using advanced techniques such as network analysis and proximity analysis, supporting informed decision￾making for clients.
• Participated in field data collection efforts, utilizing GPS devices and mobile applications to ensure accurate location information was captured.
• Created user-friendly web mapping applications that provided valuable insights for decision-makers across various industries.
• Optimized spatial database performance through regular maintenance activities such as indexing, compressing, and archiving data.

Timeline

GIS Coordinator

Ikeja Electric Plc
11.2017 - Current

GIS/Data Engineer Manager

PoloSoft Technologies Pvt. Limited
09.2016 - 10.2017

GIS/Database Specialist

Spatial Matrix Limited
10.2012 - 08.2016

Geologist

EarthSource Hydrocarbon
06.2010 - 07.2012

Masters of GIS - Geography Information Systems

University of Lagos
09.2008 - 08.2010

GIS Technician

Spatial Technologies Limited
01.2005 - 05.2010

B.Tech in Geology - Geology

Federal University of Technology, Owerri
09.1997 - 11.2002

Work Preference

Work Type

Full TimeGig WorkPart TimeContract Work

Work Location

On-SiteRemoteHybrid

Important To Me

Career advancementWork-life balanceCompany CulturePersonal development programsTeam Building / Company RetreatsStock Options / Equity / Profit SharingHealthcare benefits

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Software

PowerBI

Tableau

ArcGIS Pro

QGIS

MapInfo

Oracle

MongoDB

MySQL

R

Excel

Power Point

Word

PostgreSQL

Jupyter Notebook

AuctoCAD

PySpark

Apache Airflow

Snowflakes

AWS

Languages

English
Full Professional

Interests

Playing Chess

Travelling

Listening to classical music

Playing Lawn Tennis

Accomplishments

Achieved a 15% increase in data accuracy through innovative GIS techniques, leading to improved decision-making processes.

Managed geo-marketing campaigns that resulted in a 20% increase in customer engagement.

Led teams of 10- 15 GIS professionals in various projects, enhancing business processes through the strategic use of GIS technologies.

Certification

• Data Science Internship Program, Edureka | Credential ID: 5ELKFEFXL | Completed March 2024

• Machine Learning Internship Program, Edureka | Credential ID: GSGCFQJ6AY | Completed March 2024

• Tableau Internship Program, Edureka | Credential ID: N9JYR86AQ | Completed March 2024

• Deep Learning Internship Program, Edureka | Credential ID: S1X4P3UAE | Completed March 2024

• Python and SQL Fundamentals Internship Program, Edureka | Credential ID: U1QEX6H6AZ | Completed March 2024

• Big Data Analysis, Power, Power Query, Power Pivot, and VBA Training, UrBizEdge Limited | Credential ID: U1003581 | Completed 2022

Education

Masters of GIS - Geography Information Systems

University of Lagos
Lagos, Nigeria
09.2008 - 08.2010

B.Tech in Geology - Geology

Federal University of Technology, Owerri
Imo State, Nigeria
09.1997 - 11.2002

Quote

The way to get started is to quit talking and begin doing.
Walt Disney
Collins AnyanwuGIS/Data Engineer Consultant