# David On Cloud - Home (Markdown)
> Systems and Data Analyst portfolio focused on academic information systems, data quality, reporting automation, and operational reliability.

## Core Pages
- [Projects (Markdown)](https://www.davidoncloud.com/projects.html.md): Full project index with project summaries, technical notes, impact, and deliverables.
- [Projects (JSON)](https://www.davidoncloud.com/js/projects.json): Canonical CMS-managed project records used by the website UI.

## Professional Summary
- I work as an Information Systems Analyst, Data Analyst, and IT Administrator with a Master’s degree in Computer Science, supporting academic IT environments, data operations, and enterprise-style reporting workflows.
- I analyze existing systems, improve data processes, support implementations, and maintain operational reliability across Windows and Linux platforms. I focus on clear documentation, data accuracy, and steady support for high-volume institutional workflows.

## Education
- M.Tech. in Computer Science - Federal University of Technology, Akure (FUTA) (2019)
- B.Tech. in Computer Science - Federal University of Technology, Akure (FUTA) (2014)

## Additional Practical Experience
- In my personal home lab, I run systems and networking experiments using enterprise switching equipment like the Cisco Catalyst 3850 WS-C3850-48U-S, plus routing, VLAN configuration, IP addressing, DNS & DHCP, and isolated test environments.

## My Skills
### Systems Implementation & Support
- Systems Analysis
- Implementation & Testing
- Troubleshooting
- QA Support
- Documentation
- Process Improvement

### Data Analysis & Reporting
- Excel
- Power BI
- Google Sheets
- SQL / MySQL
- Data Validation
- Reporting Dashboards

### Automation & Collaboration
- Python
- PHP
- ETL Automation
- Workflow Automation
- Git / GitHub
- End-User Training
- Stakeholder Communication

### Operating Systems
- Windows
- Linux
- Security Baselines
- Updates & Patching

### Infrastructure & Virtualization
- Windows Server
- Active Directory
- VirtualBox
- VMware
- Lab Deployment

### Networking Fundamentals
- TCP/IP
- DNS/DHCP
- VLAN Basics
- VPN Basics

### Web & Deployment
- HTML / CSS / JS
- Tailwind CSS
- Netlify
- Vercel
- Decap CMS
- CI/CD Pipelines

## Tools & Platforms
### Data & Analytics Tools
- **Power BI**: Build KPI dashboards, trend analysis views, and operational scorecards for leadership reporting.
- **Excel**: Run validation formulas, reconciliation checks, and structured data review before publication.
- **Google Sheets**: Coordinate shared review queues and live status tracking with distributed teams.

### Databases & Query Tools
- **SQL (MySQL/PostgreSQL)**: Audit records, detect anomalies, and reconcile source-vs-target datasets with repeatable query templates.
- **MySQL Workbench**: Inspect schema structures, validate query outputs, and manage reporting datasets during analysis cycles.
- **Gradent Platform**: Extract admissions and academic processing exports for institutional data cleanup and reporting workflows.

### Automation & Scripting Tools
- **Python**: Automate ETL, quality checks, reconciliation routines, and scheduled report generation tasks.
- **Bash**: Orchestrate repeatable execution steps, scheduled runs, and lightweight operational workflows.
- **GitHub**: Version script libraries, track workflow improvements, and publish reusable technical assets.

### Systems & Infrastructure Tools
- **Windows Server**: Configure Active Directory, policy baselines, and lab-ready system administration environments.
- **Active Directory**: Manage user/group structures, access policy testing, and organizational unit setup in lab deployments.
- **VirtualBox & VMware**: Provision repeatable virtual labs for systems implementation, testing, and training delivery.

### Networking & Security Tools
- **Cisco Packet Tracer**: Model VLAN, routing, and VPN scenarios before applying configurations in practical labs.
- **Managed Cisco Switches**: Practice trunking, segmentation, and troubleshooting for enterprise-style network workflows.
- **Biometric & CCTV Operations Stack**: Support exam integrity workflows through identity verification checks and monitored incident logging.

### Delivery & Collaboration Tools
- **Issue & SLA Tracker (Excel/Google Sheets)**: Track incident queues, assign owners, monitor response timelines, and report service performance across operations cycles.
- **Deployment & UAT Checklists**: Coordinate pre-deployment validation, user acceptance testing, and go-live sign-off for systems updates.
- **Implementation Handover Playbooks**: Standardize transition notes, support escalation paths, and user guidance for stable post-rollout operations.

## Work Experience
### Computer IT Instructor (Computer Science & Applied Computing)
- Organization: Pures College of Technology
- Location: Scarborough, ON
- Period: Jan. 2024 - Aug. 2025
- Work Context: Delivered hands-on instruction while managing lab environments, software installations, and networking practicals for 250+ students.
- Key Outcomes:
- Supported 250+ students with hands-on lab guidance across laptops, desktops, tests, and project sessions.
- Built and maintained Windows Server/Windows client virtual labs in VirtualBox/VMware, including Active Directory setups.
- Installed and troubleshot course tooling (VS Code, Eclipse, MySQL, Python/HTML/CSS/JS environments).
- Ran networking practicals covering VLAN basics, cabling, and connectivity troubleshooting, documenting repeatable lab setups.
- Processed results and verified student records through Google Classroom workflows.

### Systems & Data Analyst / System Programmer
- Organization: Federal University of Technology, Akure (FUTA) - Centre for Continuing Education (CCE)
- Location: Nigeria
- Period: Mar. 2017 - Aug. 2023
- Work Context: Supported academic information systems, data processing, and reporting workflows across admissions, examinations, and results processing.
- Key Outcomes:
- Processed and validated admissions, examinations, and results datasets using Excel, Google Sheets, SQL, and Gradent for 4,000+ users.
- Built data-cleaning and validation workflows to improve accuracy, audit readiness, and lifecycle record integrity.
- Produced executive performance reports and analytical insights to guide planning decisions.
- Managed exam operations tools (biometric verification, CCTV workflows) and secure incident record handling procedures.
- Automated recurring data preparation with Python and performed readiness checks on exam systems.

### Computer Science (ICT) Teacher
- Organization: Community Secondary School, Agulu-Awka
- Location: Nigeria
- Period: Dec. 2014 - Aug. 2015
- Work Context: Delivered foundational computer science instruction with emphasis on logical reasoning and structured problem solving.
- Key Outcomes:
- Delivered foundational computer science instruction focused on logical reasoning and problem-solving.
- Reviewed and assessed student work to ensure understanding and accuracy.

## Contact
- Email: matthewtopedavid@gmail.com
- Location: Toronto, ON