# 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://davidoncloud.com/projects.html.md): Full project index with project summaries, technical notes, impact, and deliverables.
- [Projects (JSON)](https://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 and 9+ years leading academic and enterprise IT operations, including ERP-backed workflows, implementation support, and data governance.
- I analyze systems, improve data processes, and maintain reliability across Windows and Linux using Active Directory, Microsoft 365, domain and DNS operations, and structured automation — with a focus on documentation and data accuracy.
- Recent contract work extended that range: building booking, payments, and documentation features for Anchor Coaching's platform (300+ reviewed code changes, 127+ documentation chapters), and reviewing rubric and test quality for AI training data at Outlier. Both run on the same foundation as my systems work — verify the data, document the system, make it repeatable.

## 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 home lab and consultant workflows I run enterprise-style systems and networking scenarios — Cisco Catalyst switching, VMware/VirtualBox, Docker utilities, routing, VLANs, DNS and DHCP. On the development side I work in a Git-based, AI-augmented workflow with GitHub Actions CI and automated tests.

## My Skills
### Systems Implementation & Support
- Systems Analysis
- ERP Administration
- Business Application Workflow Support
- Implementation & Testing
- Go-Live & Cutover Support
- Troubleshooting
- QA Support
- Documentation
- Process Improvement

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

### Automation & Collaboration
- Python
- PowerShell
- Bash
- 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
- Identity & Access Administration
- Microsoft 365 Admin Center
- Docker
- VirtualBox
- VMware
- Lab Deployment

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

### Web & Deployment
- HTML / CSS / JS
- Domain & DNS Management
- Netlify
- Vercel
- Decap CMS
- CI/CD Pipelines (GitHub Actions)

### Full-Stack Development
- Next.js
- TypeScript
- PostgreSQL
- Stripe
- Supabase / InsForge
- TipTap
- Google OAuth
- REST API Integration
- Automated Testing (CI/E2E)

### AI & Data Evaluation
- Rubric & Test-Design Review
- LLM Evaluation Methodology
- pytest
- Ground-Truth Verification
- Coverage-Gap Analysis
- Dataset Integrity Assessment

## 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**: 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.
- **Microsoft Dynamics 365**: Support ERP-style workflows across admissions, reporting, identity alignment, and departmental process coordination.

### 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.
- **Docker**: Package repeatable troubleshooting utilities and deployment checks for consistent execution across environments.
- **Domain & DNS Operations**: Manage domain records, routing validation, and service continuity controls for web and email operations.
- **Microsoft Entra ID**: Manage directory synchronization, access assignments, and identity lifecycle controls across distributed systems.
- **Microsoft 365 Admin Center**: Handle user provisioning, licensing, and service-access administration for day-to-day operations support.

### 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.
- **Cisco Routers**: Configure static and dynamic routing, baseline ACL policies, and inter-site connectivity troubleshooting in lab and operations scenarios.
- **Biometric & CCTV Operations Stack**: Support exam integrity workflows through identity verification checks and monitored incident logging.

### Delivery & Collaboration Tools
- **Monday.com**: Coordinate task boards, delivery timelines, and team status updates across implementation and operations cycles.
- **GoHighLevel**: Manage client communication workflows, appointment scheduling, and operational follow-up sequences for service delivery.
- **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.

### Web & Application Development
- **Next.js & TypeScript**: Build and ship production features across a multi-tenant SaaS platform serving four distinct user roles.
- **PostgreSQL**: Model relational data and enforce rules at the database layer, including a safeguard that prevents overlapping bookings.
- **Stripe**: Handle client card payments, coach payouts, and reconciliation checks confirming charged fees match fees actually deducted.
- **Supabase / InsForge**: Manage backend data services and authentication for application features.
- **TipTap & Google OAuth**: Implement rich-text composition for staff mail systems and federated sign-in for platform accounts.
- **GitHub Actions**: Run CI checks, nightly end-to-end test suites, and documentation link validation on every pull request.

### AI & Data Evaluation
- **Rubric & Test-Design Review**: Assess training-data rubrics and unit tests for overfit assertions, self-referential logic, and scoring errors.
- **pytest**: Read and evaluate Python test suites used as programmatic verification criteria in AI training tasks.
- **LLM Evaluation Methodology**: Separate deterministic, programmatically-verifiable criteria from natural-language judgment criteria in written analysis.
- **Ground-Truth Verification**: Validate dataset integrity through coverage-gap analysis and cross-validation against independent analysis.

## Work Experience
### IT Administrator, Full-Stack Developer & Systems Consultant
- Organization: Independent Practice — client: Anchor Coaching (www.theanchorcoach.com)
- Location: North York, ON — contract work remote
- Period: Aug. 2025 – Present
- Work Context: Running an independent practice covering IT systems administration and full-stack contract delivery — currently building booking, payments, and documentation features for a live coaching platform.
- Key Outcomes:
- Anchor Coaching (contract, Mar 2026 – present): delivered features for a coaching platform serving four user types — administrators, staff coaches, independent coaches, and clients.
- Fixed a scheduling fault that could let two clients book the same session, moving the safeguard into the database so it applies to every booking route rather than one screen.
- Built the payments and payouts process, including coach payouts and a reconciliation check confirming the fees charged match the fees actually deducted.
- Wrote 127+ chapters of user documentation tailored to each role, with automated checks that catch broken links before release.
- Administered the platform's infrastructure: custom domain setup and verification, business email delivery, and scheduled backups.
- Shipped 300+ reviewed code changes using AI-assisted development workflows and automated nightly testing.
- Independent systems consulting: standardized staff onboarding and offboarding with account controls across Active Directory, Entra ID, and Microsoft 365.
- Built and maintained small-business network and server infrastructure using Cisco switching, network segmentation, and virtualization, sustaining 99.9% availability.
- Managed domain and DNS operations for davidoncloud.com, and resolved network and system faults through structured diagnosis and root-cause analysis.
- Produced technical runbooks and automation scripts for repeatable rebuilds, cutting manual setup effort by an estimated 40%.

### AI Training Data Scientist / Data Analyst
- Organization: Outlier (OpenClaw Atlas Program)
- Location: Remote
- Period: Feb. 2026 – July 2026
- Work Context: Checking whether the rubrics and tests used to train AI models actually measure what they claim to measure.
- Key Outcomes:
- Reviewed the rubrics and automated tests used to grade AI training data, checking each criterion had exactly one defensible interpretation.
- Flagged tests that only passed for one specific solution, tests that validated their own output, and criteria with incorrect scoring weights.
- Wrote structured analysis reports separating checks a machine can verify from those needing human judgment, and cross-checked findings against independent analysis.

### 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, networking practicals, and Active Directory identity workflows 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 and identity-access practicals.
- Installed and troubleshot course tooling (VS Code, Eclipse, MySQL, Python/HTML/CSS/JS) plus collaboration and access workflows.
- Ran networking practicals covering VLAN basics, cabling, and connectivity troubleshooting, documenting repeatable lab setups.

### Systems & Data Analyst / System Programmer (Head, System Programmer’s Office)
- Organization: Federal University of Technology, Akure (FUTA) - Centre for Continuing Education (CCE)
- Location: Nigeria
- Period: Mar. 2017 - Aug. 2023
- Work Context: Led enterprise academic ERP operations and data automation for 4,000+ users, combining identity governance, cross-system integration, and examination reliability.
- Key Outcomes:
- Led and administered the academic ERP ecosystem (admissions, examinations, reporting, identity, RBAC) for 4,000+ users.
- Led production cutover from the legacy Smarty workflow to the Gradent platform, with migration checks and rollback safeguards.
- Cut result processing from 3–5 days to same-day, reclaiming 200+ hours annually through Python, SQL, ETL, and validation controls.
- Governed onboarding/offboarding for 4,000+ stakeholders via Active Directory and role-based access.
- Oversaw secure examination technologies, running readiness checks and biometric verification for 300+ candidates per session.

### 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 (open to relocate)