Database Development Projects in PunjabDatabase Development Projects in Punjab
Projects
People
Cover image for An imported item’s purchase price
An imported item’s purchase price is only part of its inventory cost. Transport and other related expenses also need to be allocated accurately. This Landed Cost Allocation screen is part of the custom ERP import module I developed using VB.NET (http://VB.NET) and Microsoft SQL Server. It allows users to select an import shipment receipt, allocate each expense across received items, and review the allocated total and remaining difference before finalizing. In this example, a PKR 22,000 transport expense is distributed across three items in proportion to their base values, with no unallocated balance. The module supports Base Value, Basic Unit Quantity, and Manual allocation methods, helping businesses handle different costing requirements within an integrated inventory and accounting workflow. Need a similar import-costing module or an enhancement to your existing .NET business software? Let’s discuss your requirements. #ERP #VBNet #SQLServer #InventoryManagement #LandedCost
1
1
111
Cover image for E‑commerce Order Management System Tools: Airtable
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
0
94
Cover image for 🚀 Building a Graph-Based Fraud
🚀 Building a Graph-Based Fraud Detection System with Neo4j A single transaction may look normal. Its connections can tell a different story. I’m building a learning project using Neo4j and Cypher to explore relationships between customers, accounts, transactions, and devices—and flag patterns worth investigating. 🔍 Patterns I’m exploring: • Multiple customers sharing the same device • Unusually large transactions • Rapid transactions within a short period • Multiple accounts sending money to one account • Circular transfers between connected accounts The focus is explainability: showing the relationships behind each flag so the suspicious activity is easier to understand. Through this project, I’m strengthening my graph data modelling, Cypher queries, and rule-based detection skills. Next: FastAPI integration, transaction risk scores, fraud alerts, and an interactive monitoring dashboard. 🛠️ Currently a learning prototype, with more updates coming as I build. What would you investigate first: shared devices or circular transfers? #Neo4j #GraphDatabase #FraudDetection #Cypher #BackendDevelopment #LearningInPublic
1
292