Database Development Projects in PunjabDatabase Development Projects in PunjabOracle to Amazon RDS PostgreSQL
Designed and Implemented a secure, scalable architecture to migrate an on-prem Oracle database to Amazon RDS for PostgreSQL.
Data Flow: Modeled end-to-end flow, used AWS Glue (SCT) for schema conversion and DMS for full-load and CDC. Stored artifacts in S3 and loaded into RDS.
Services: Glue for conversion, DMS for Migration , S3 for artifacts, and RDS as target.
Security: IAM roles with least privilege, KMS for encryption at rest.
HA & DR: Architected in us-east-1 with Glue, DMS, RDS, S3, and monitoring via CloudWatch. E‑commerce Order Management System
Tools: Airtable | Softr | Make.com
(http://Make.com)Description:
End‑to‑end order management system for an online store. Tracks products, customers, orders, and inventory in real time. When a customer places an order, stock is automatically deducted, and confirmation emails are sent to both the customer and the admin. Includes a dashboard for order status tracking (Pending → Processing → Shipped → Delivered) and low‑stock alerts.
Key features:
· Airtable tables: Products, Customers, Orders, Order Items (linked records, rollups for totals)
· Softr admin dashboard: view all orders, update status, see low‑stock products
· Softr customer portal (optional): customers can view order history
· Make.com (http://Make.com) automation:
· On new order → deduct inventory, send order confirmation email to customer
· On status change → send shipping notification email
· Daily stock check → email alert if any product stock < 5
· Mobile‑responsive design
Built independently – full database schema, frontend dashboards, and multi‑step automation logic A professional Finance Management Dashboard designed to help businesses organize and monitor their financial activities in one place.
The dashboard provides a clean and easy-to-use interface for tracking income, expenses, cash flow, customer transactions, loans, financial summaries, and reports. The design focuses on clear data presentation, simple navigation, and practical business use.
This work sample demonstrates my ability to design professional business dashboards, financial management interfaces, data-driven layouts, and user-friendly web application interfaces with a focus on usability and organized information.
Key Features:
Finance overview and financial summaries
Income and expense tracking
Cash book management
Customer ledger
Loan tracking
Financial reports
Clean and responsive dashboard interface
Organized data visualization
Business-focused UI/UX design NestFind is a rental property listings platform built in Bubble. Landlords can post properties and tenants can browse, filter by location, price, and bedroom count, and contact landlords directly.
I handled everything from database design to UI and workflow logic. Features include dynamic listings, availability status, contact forms, and a fully responsive layout for desktop and mobile.
Built using repeating groups, conditional visibility, dynamic filtering, and multi-role data handling — core Bubble skills clients look for.