Alikamatu Osama

Full Stack & Mobile Engineer Building Production SaaS Systems, Native Apps & AI Workflows

I'm a full stack and mobile software engineer based in Accra, Ghana. I design, build, and operate production web and native applications end to end including system design, backend APIs, AI integrations, and the interfaces real users depend on every day across web, iOS, and Android.

US Client

99Solar Automated Bidding Tool

Revenue critical internal ops platform

99Solar is an internal enterprise platform I built for a US based client running high volume Amazon device bidding operations. Before this tool, the team managed bids manually via spreadsheets error prone and time consuming. I replaced that workflow with an automated ingestion pipeline, real time analytics dashboard, and audit trail, now tracking $6.17M in monthly operations with zero duplicate bid errors.

$6.17M

Monthly Revenue Tracked

$925.36

Highest Bid

40+ hrs

Time Saved / Month

0

Duplicate Errors

01.

Screenshots

99Solar bid analytics dashboard

Real time bid analytics dashboard revenue tracking, win rates, and trend charts via Recharts.

99Solar bid management table

Bid management table paginated, filterable records with export and audit log per entry.

99Solar CSV upload pipeline

CSV upload pipeline drag and drop ingestion with real time validation feedback and conflict resolution.

02.

My Role & Scope

Built and maintained the full stack application bid ingestion system, CSV/Excel processing, real time analytics dashboard, REST APIs, and audit logging.

03.

Tech Stack

Next.js
Express.js
PostgreSQL
XLSX Processing
Recharts
04.

Key Engineering Decisions

  • 01

    Chose PostgreSQL for ACID compliance to prevent duplicate bid entries.

  • 02

    Used server side CSV parsing to handle large files without blocking the UI.

  • 03

    Centralized bid validation logic to ensure data integrity across concurrent uploads.

05.

Hard Problem Solved

Challenge

Preventing duplicate bids when processing thousands of rows from multiple concurrent file uploads.

Solution

Implemented database unique constraints with composite keys and transaction based batch inserts with conflict resolution.

06.

What Broke in Production

Large CSV uploads caused memory spikes and timeouts fixed by implementing streaming file processing and chunked database inserts.

07.

What I Would Improve Next

Add background job processing for large file uploads and implement Redis caching for frequently accessed bid analytics.

99Solar Automated Bidding Tool

Revenue critical internal ops platform