Great score on Find Indices of Two Numbers That Add Up to Target, Difficulty Easy
Great score on Design an ETL Pipeline for Healthcare Data Integration, Difficulty Hard
Great score on Design a Secure Data Storage System on AWS S3, Difficulty Easy
Built Infrastructure-as-Code using Terraform to provision AWS platform infrastructure.
Implemented AWS networking components including VPCs, subnets, route tables, internet gateways, NAT gateways, and security groups.
Designed IAM roles and permission policies to enable secure access for platform services and engineering teams.
Implemented observability infrastructure using CloudWatch dashboards, log groups, and metric alarms for platform monitoring.
Created an EC2 onboarding and connection guide documenting the process for engineers to securely access and manage EC2 instances.
Supported application availability and reliability by setting up and maintaining local development environments using XAMPP, troubleshooting configuration issues, and ensuring stable application operation during development and testing.
Assisted with system maintenance tasks including configuration changes, updates, and validation of application behavior.
Monitored application behavior and user-facing functionality during development, identifying issues early and collaborating with team members to troubleshoot and resolve defects efficiently.
Contributed to documentation of setup procedures, configuration steps, and troubleshooting guidelines to support team operations.
Built and customized forms and UI components using plugins, shortcodes, and CSS.
Designed and managed data pipelines that collect, process and analyze data from fire safety systems.
Managed AWS infrastructure including S3, Lambda, and EC2 for scalable workloads.
Created CI/CD pipelines with GitHub Actions for seamless deployments.
Developed data models and implemented storage solutions to support analytics for fire risk assessments, maintenance schedules and incident reporting.
Created and tested frameworks to validate the performance and reliability of data-driven solutions, including machine learning models.
Automated 20+ ETL/ELT jobs using Airflow and GCP (BigQuery, GCS, Pub/Sub).
Improved job reliability and reduced manual intervention by over 70%.
Modeled analytics-ready data marts with dbt, consolidating data from 7+ sources.
Developed data pipelines with Python/SQL, improving accuracy by 15% and processing efficiency by 50%.
Deployed containerized ML workloads in Kubernetes and Docker, supporting reproducibility and scalable inference.
Contributed to ML models for electrification prediction (95% accuracy), enabling better business resource allocation.
Manage and optimize databases to ensure high performance, availability, and reliability.
Designed and implemented RESTful API endpoints for booking management
Built authentication system with email-only signup, OTP verification, JWT token issuance and refresh, and UUID-based user identity using PostgreSQL migrations
Developed admin dashboard APIs for managing clients, trainers, subscriptions, transactions, and revenue snapshots, enabling full platform visibility for operations teams
Implemented trainer-facing features including profile editing, availability toggling, soft delete, password reset, and client list retrieval
Integrated Resend email service for transactional emails — OTP delivery, session reminders, trainer setup emails — with log redaction to protect sensitive data
Contributed to subscription and payments infrastructure, including subscription plan management, active subscription tracking, and session platform support with database migration handling
Built a real-time data pipeline using Kafka, Spark Structured Streaming, AWS S3, DuckDB, and Streamlit to process and visualize live cryptocurrency trades.
A containerized microservices job-processing system with a full CI/CD pipeline built with Docker, FastAPI, Redis, and GitHub Actions.
Built a SQL data warehouse with structured schemas, ETL workflows, and optimized analytical queries.
Built an ELT pipeline ingesting financial market data from the Alpha Vantage API into a structured analytics database.
Developed a full-stack CRUD Todo application with authentication, REST APIs, and persistent storage.
Designed and deployed a fully functional National Single Window (NSW) Database Platform, a high-availability system built to power real-time data exchange between Nigerian government agencies (Customs, Ports, NAFDAC, SON, NESREA).

Mairo G. is mid-senior Level Developer