Sr.Software Engineer
True Refined Solutions
Sep 2024 — Mar 2026
About
The Story Behind the Code
Designing and building tomorrow's digital landscape.
I'm a passionate software engineer who thrives on transforming complex requirements into clean, well architected, and high performing systems. I specialize in building scalable full-stack applications using modern tools like TypeScript, React, Node.js, and Supabase. Beyond writing features, I focus on database schema design, performance optimization, and maintainable codebases that can grow with the project. I enjoy collaborating on challenging projects, continuously sharpening my craft by exploring new technologies and best practices.
0+
Years Experience
Web
Standards Contributor
Journey
Professional Experience
Fullstack Developer
Stepway
Aug 2022 — May 2024
Expertise
Technical Toolkit
Aws services
Node / Express Js
Supabase
Liveblocks
Cloud flare workers
Dynamo db
Spring Boot
NextJs
My Sql
Webhooks
Sanity
Framer Motion
Vercel
Git
Stripe
Biome
JavaScript
Claude
Github
TypeScript
Shadcn/UI
Firebase
React
Postgres
Clerk
Tailwind CSS
Angular
Java
Portfolio
Selected Case Studies
Case Study
Supabase (open source contribution)
Project #1
#1 Selected Works
Supabase (open source contribution)
## The Problem Empty cells during Supabase CSV imports were treated inconsistently, admins couldn't control whether they became NULL or empty strings, causing confusion across large dataset workflows. --- ## Collaboration Worked with Charis Lam and Deni Mintsaev (issue #43258) to identify a better UX for nullable imports after reviewing PR #43281. --- ## The Solution Implemented PR #44515, a **multi-select dropdown** letting admins choose which columns treat empty CSV cells as NULL. - Selected columns → empty cells become `NULL` - Unselected columns → empty cells remain `""` --- ## Impact - Cleaner import clarity - Better admin control - Improved database consistency - More predictable workflows
Case Study
Nodepad
Project #2
#2 Selected Works
Nodepad
## Overview Nodepad is a lightweight, Notion-inspired team management app helping teams organize work, collaborate efficiently, and stay productive in a unified workspace. Built **mobile-first**, it delivers a seamless experience across desktop, tablet, and mobile, productivity isn't limited to one platform. --- ## Core Features - **Team Workspace Management**, Create and manage shared workspaces for teams and projects - **Task Management**, Organize tasks with status tracking and structured workflows - **Notes & Documentation**, Store project-related notes in a centralized system - **AI Document Assistant**, Chat with documents or translate content for faster insights - **Mobile-First Design**, Optimized across all devices - **Fast & Intuitive UX**, Lightweight interface focused on speed and productivity --- ## AI Integration A key enhancement is AI-assisted functionality, users can translate documents or **chat directly with document content** to quickly extract insights without manually reading through everything.
Case Study
Smsa fleet management system
Project #3
#3 Selected Works
Smsa fleet management system
## Overview SMSA Fleet and SMSA Tracking are logistics workflow platforms where I contributed as a Java Full-Stack Developer, working across both Angular frontend modules and Spring Boot backend APIs from requirements through to go-live. --- ## My Contributions - **Search API Development**, Built a advanced search system with multiple filters and criteria using JPA queries, enabling powerful data lookup across large logistics datasets - **REST API Development**, Designed and implemented Spring Boot endpoints handling core logistics workflow operations - **Angular Modules**, Built and maintained frontend modules for fleet and tracking interfaces --- ## The Search Challenge Logistics data is complex, fleet records, tracking entries, routes, and statuses all need to be queryable in combination. I engineered the search API using **JPA Specifications** to support dynamic multi-filter queries, making it flexible enough to handle any combination of search criteria without hardcoding individual query paths. --- ## Tech Stack Built with **Angular**, **Java Spring Boot**, **JPA**, and **REST APIs**, contributed across both frontend and backend layers in a production logistics environment.
Case Study
Valorem
Project #4
#4 Selected Works
Valorem
## Overview Built a scalable serverless backend for Valorem, a modern real estate marketplace, using AWS Lambda and DynamoDB, delivering reliable REST APIs and cloud infrastructure designed for scale. --- ## What I Built - **Serverless Architecture**, AWS Lambda functions handling all backend logic with no server management - **REST APIs**, Clean, reliable endpoints powering the marketplace's core functionality - **DynamoDB Integration**, NoSQL data layer optimized for fast reads and scalable storage - **Cloud Infrastructure**, Fully managed AWS setup built for production reliability --- ## Role Contributed as a **Backend Engineer**, responsible for architecture decisions, API design, and cloud infrastructure setup for the Valorem platform.
Case Study
Printlab
Project #5
#5 Selected Works
Printlab
## Overview PrintLab is a digital printing platform built for 5,000+ users, modernizing traditional print operations through automated workflows and a clean, intuitive interface. I led the full-stack development end to end, handling client communication directly, mentoring two junior developers, and engineering the core pricing logic that made the platform viable. --- ## The Engineering Challenge The hardest part wasn't the code, it was cracking the **actual cost formulas** behind print products. Print pricing involves complex variables like paper size, ink coverage, material cost, and quantity tiers. Getting these calculations accurate was critical for the business to function correctly. --- ## My Role - **Client Communication**. Worked directly with the client throughout the project, translating business requirements into technical solutions - **Team Leadership**, Mentored two junior developers, reviewing code and guiding implementation decisions - **Pricing Formula Engineering**, Researched and cracked the real-world cost formulas behind print product pricing, ensuring accurate and profitable calculations - **Full-Stack Development**, Built the entire platform from scratch using Angular, Java Spring Boot, and MySQL --- ## What I Built - **Product Pricing Engine**, Custom formula-based cost calculator handling complex print variables - **Automated Workflows**, Streamlined order processing replacing manual print operations - **Angular Frontend**, Clean, responsive UI for browsing, configuring, and ordering print products - **Spring Boot Backend**, Robust REST APIs handling orders, products, and pricing logic - **MySQL Database**, Structured data layer managing products, orders, and user accounts --- ## Tech Stack Built with **Angular**, **Java Spring Boot**, and **MySQL**, serving 5,000+ users in production.
Case Study
Biosonic
Project #6
#6 Selected Works
Biosonic
## Overview BioSonic is a bat-acoustic research platform used by **5,000+ scientists** worldwide. I worked as a shadow developer building the platform end to end, shipping production-grade infrastructure handling data at a scale most platforms never encounter. --- ## The Engineering Challenge The core problem was scale. Bat acoustic research generates data in the **millions of records**, so large that even Supabase's newly launched analytics bucket couldn't handle it at the time. Custom solutions were engineered from scratch to ingest, store, process, and display this data reliably on the web. --- ## What I Built - **Browser-Based Batch Upload System**, Processed millions of files in a single session using the WHATWG File System API, with no Electron dependency - **1,000-File Batch Processing**, Chunked upload architecture for fault-tolerant large-scale data handling - **Custom RPC Functions**, Built Supabase RPC calls for large data aggregations and complex data handling that standard queries couldn't efficiently support - **Custom SQL Layer**, Highly optimized queries on Supabase and PostgreSQL handling millions of records where off-the-shelf solutions fell short - **Web Data Visualization**, Rendered massive datasets in the browser without performance degradation - **Real-Time Processing**, Audio files processed and surfaced to researchers as they arrive --- ## The Scale Problem When Supabase launched their analytics bucket, our dataset was already beyond what it could handle. The solution required custom RPC functions, query optimization, batching strategies, and architecture decisions built specifically for this level of scale. --- ## Tech Stack Built with **React**, **TypeScript**, **Supabase**, **custom SQL**, and **Supabase RPC**, deployed for production use by thousands of active researchers globally.
Case Study
AI-Post-Agent
Project #7
#7 Selected Works
AI-Post-Agent
## Overview A fully automated LinkedIn (and optionally X/Twitter) posting agent built for software architects targeting investors and clients across ecommerce, hospitality, and healthcare, runs completely free with zero server required. --- ## How It Works - Researches recent **source-backed stories** relevant to your niche - Validates niche fit and factual accuracy before posting - Falls back to **vetted evergreen source packs** when live discovery is weak - Posts automatically on a schedule, no manual intervention needed --- ## Infrastructure - **Runs on GitHub Actions**, completely free, no server required - **Controlled via GitHub Secrets**, change behavior without touching code - **Zero maintenance**m set it up once and let it run --- ## Target Niches - Ecommerce - Hospitality - Healthcare --- ## Why It Matters Consistent, credible thought leadership on LinkedIn is one of the highest ROI activities for software architects winning enterprise clients and investor attention, this agent automates that entirely.
Case Study
AI Commerce
Project #8
#8 Selected Works
AI Commerce
## Overview A full-stack AI-powered e-commerce platform combining traditional online shopping with intelligent automation, built for both customers and store owners with real-time content management and seamless payments. --- ## Customer Experience - **AI Shopping Assistant**, Find products, check prices, and get recommendations using natural language - **Secure Checkout**, Stripe-powered payments with webhook-based order creation - **Order Tracking**, Personalized order history tied to authenticated accounts - **Persistent Cart**, Real-time stock validation across sessions --- ## Admin Experience - **Product Management**, Create, edit, and publish products instantly via Sanity CMS - **Real-Time Inventory**, Stock updates appear without page refreshes - **Low Stock Alerts**, Automated notifications for inventory management - **AI Sales Insights**, Data-driven recommendations powered by Claude Sonnet --- ## Tech Stack Built with **Next.js 16**, **React 19**, **TypeScript**, **Tailwind CSS**, **Shadcn UI**, **Sanity CMS**, **Clerk Auth**, **Stripe**, **Zustand**, and **Claude Sonnet** via Vercel AI Gateway. --- ## Architecture Clerk handles authentication and personalized AI interactions. Stripe manages payments and order creation via webhooks. Sanity delivers real-time content updates, making the entire platform fast, scalable, and maintainable.
Case Study
Codeway LMS
Project #9
#9 Selected Works
Codeway LMS
## Overview A modern, full-stack Learning Management System delivering a structured and intuitive digital learning experience, built for students and admins alike with a focus on performance and usability across all devices. --- ## Core Features - **Course Discovery**, Browse and explore courses with structured detail pages - **User Authentication**, Secure login with protected routes - **Student Dashboard**, Track learning progress and manage enrolled courses - **Progress Navigation**, Course flow adapts based on learning progress - **Admin Management**, Create and organize courses and learning content - **Responsive Design**, Optimized for mobile, tablet, and desktop --- ## Architecture Built with scalability in mind, the system serves as a solid foundation for a full-featured LMS product, with clean separation between student-facing and admin-facing functionality. --- ## Goal Demonstrate how structured online learning platforms can be built using modern web technologies, with a strong emphasis on course management, progress tracking, and a clean learning experience.
Case Study
Feasina
Project #10
#10 Selected Works
Feasina
## Overview Feasina is an instant drink solution that transforms ordinary water into flavorful summer beverages. A healthier alternative to sugary drinks, made with real fruit extracts, essential vitamins, and electrolytes, all with zero artificial preservatives. At just 25 calories per serving, it delivers bold taste without the guilt. --- ## Flavors Feasina offers five distinct flavors, each crafted for an authentic summer experience: - **Tropical Mango**, Our #1 bestseller. Rich, creamy, and unmistakably tropical with the juicy sweetness of a fresh mango. - **Zesty Orange**, Bright and tangy with a citrusy kick, naturally packed with Vitamin C to energize your day. - **Sweet Peach**, Delicately sweet with soft floral notes, smooth and refreshing like summer in a glass. - **Vimto Cola**, The timeless fizzy flavor you love, reimagined in instant powder form. - **Lemon Twist**, Clean, crisp, and sharp, a refreshing citrus burst for the summer heat. *(Currently out of stock)* --- ## Core Features - **Instant Preparation**, One sachet, 200ml of water, stir for 10–15 seconds and your drink is ready. No blender, no measuring, no cleanup. - **Health Benefits**, Essential Vitamin C, electrolytes for better hydration, and only 25 calories per serving, enjoy it guilt-free any time. - **Natural Ingredients**, Real fruit extracts and natural flavoring. No artificial colors or preservatives, just clean ingredients you can feel good about. - **Convenient Packaging**, Individual sachets, lightweight, no refrigeration needed, and a long shelf life so you can carry them anywhere. --- ## Why Feasina Feasina is built for people on the move who won't compromise on taste or health. Whether you're at the office, gym, or outdoors in the summer heat, it fits seamlessly into your lifestyle. Lightweight, affordable, and ready in seconds, just add water and enjoy.
Case Study
IHEMS
Project #11
#11 Selected Works
IHEMS
## Overview IHEMS is an innovative home energy management solution designed to monitor, analyze, and optimize residential energy consumption, empowering users to reduce costs and promote sustainable living. --- ## Core Features - **Menu Dashboard**, Centralized navigation through all system features - **Room Dashboard**, Real-time energy consumption and spending per room - **Solar Predictor**, Estimates solar energy generation based on environmental conditions - **Electricity Predictor**, Forecasts future usage from historical data for better budgeting - **Energy Calculator**, Calculates potential savings based on current consumption patterns --- ## Energy Monitoring - Tracks weekly consumption and total spending - Shows average daily usage and cost breakdowns - Compares current vs previous weeks to identify trends - Sets daily budget targets to promote financial awareness --- ## Actionable Recommendations The system delivers practical suggestions such as: - Keeping solar panels clean for better energy generation - Using energy-saving bulbs and turning off lights in empty rooms - Closing windows and doors while running air conditioning --- ## Skills Demonstrated - UI Design & Data Visualization - Energy Management & Forecasting - Budgeting Tools & Sustainable Practices
Availability: Open for Projects
Let's build something
extraordinary together.
Direct Access
Call
+92 3161585989
usamanadeemparacha@gmail.com
Location
Gulshan-e-maymar, Karachi
Driven by precision, built with passion. I'm currently looking for new opportunities to solve complex problems.