Building the systems
behind retail.
3+ years delivering 40+ projects across 11 departments for Grand Hypermarket Kuwait — from Oracle PL/SQL data warehouses and .NET 8 APIs to 15+ web portals, Python automation scripts, and delivery aggregator integrations. The full stack, from database to dashboard.
Where the database meets the business.
I'm a full stack developer and Oracle PL/SQL engineer working inside Grand Hypermarket, one of Kuwait's high-volume, multi-branch retail chains operating across Kuwait,UAE,Qatar,Oman,KSA and India. My work spans the entire retail technology stack — from Oracle database architecture and PL/SQL procedures to 15+ ASP.NET web portals, a .NET 8 Web API, 11 Python automation scripts, and integrations with WhatsApp, Talabat, Deliveroo, and e-commerce platforms.
Every project started as a manual process. My job was to make it automated, indexed, and reliable.That's meant architecting a Star Schema data warehouse from scratch, building a loyalty platform with WhatsApp OTP and card allocation, migrating ~500,000 customer records, automating purchase orders off live stock rules, and delivering 53 production reporting queries that cut ad-hoc report delivery from days to under an hour.
I work across three Oracle database instances with cross-database links, build with C# (.NET Framework and .NET 8 Core), automate with Python (cx_Oracle, pandas), and integrate with REST APIs, SOAP services, SFTP, SMTP, and SMB. Currently finishing my B.C.A. in Computer Applications.
Four disciplines, one stack.
From database design to web portal to scheduled automation — I build end-to-end solutions for retail operations.
Database & PL/SQL Engineering
Oracle PL/SQL stored procedures, functions, packages, DB links, and star-schema data warehouse design. 3 Oracle instances managed with cross-database queries. 53-query reporting library in production serving 5+ departments.
Full Stack .NET Development
15+ ASP.NET Web Forms portals with role-based access control and a .NET 8 Core Web API with Dapper and Swagger. jQuery, AJAX, DataTables, Bootstrap, and Tailwind CSS frontends.
Python Scripting & Automation
11 scheduled Python scripts in production for data sync, reporting, and notifications. Loyalty point sync, live sales summary, online price updates, POS file access via SMB, DMS document distribution.
Systems & API Integration
REST APIs, SOAP web services, WhatsApp API, SFTP, SMTP, and SMB integrations. E-commerce sync, CRM sync, delivery aggregator integration (Talabat, Deliveroo, Huawei, Tap Payments).
What I've been building.
Full Stack Developer / Oracle Developer
Database Architecture & PL/SQL Development
- Architected a Star Schema data warehouse in Oracle PL/SQL with full ETL procedures, indexed views, and temp tables — the single source of truth for all BI and executive reporting.
- Managed 3 Oracle database instances DB link for cross-database queries between Gold ERP/POS and Vision systems.
- Engineered a library of 53 production reporting queries — cutting ad-hoc report delivery from days to under 1 hour across 5+ departments.
- Built an automated Purchase Order PL/SQL procedure triggered by stock-level rules, reducing manual PO creation by ~80% across multiple branches.
- Designed Oracle DB schema (tables, constraints, indexes) for the retail operations web portal with concurrent multi-location transaction integrity.
Web Application Development (.NET)
- Developed 15+ ASP.NET Web Forms portals with role-based access control (ADMIN, MANAGEMENT, PURCHASER, STOREMANAGER, CASHOFFICER) across 6 departments.
- Architected GrandApiMaster — a .NET 8 ASP.NET Core Web API with 3 controllers (Ecommerce, Loyalty, Product) using Dapper, Swagger, and HttpClientFactory.
- Built GrandME enrollment portal with WhatsApp OTP verification, dual-database writes, SOAP CRM sync, and REST API sync with audit logging.
- Created DN Upload Portal with Excel paste-to-insert, batch processing (1,000 rows/request), and Oracle array binding for bulk inserts.
- Developed voucher and promotion portals with ZXing.Net barcode generation and dynamic promotion rule engine.
Automation & Data Engineering
- Developed 11 scheduled Python scripts in production for daily data sync between Gold ERP and Vision systems — loyalty point sync, live sales summary, online price updates, DMS distribution.
- Migrated ~500,000 customer records from legacy DB to new DB database with deduplication and inactive-customer cleanup.
- Built Python daily Sales & YTD comparison report, replacing a 3-hour manual process with a sub-5-minute automated run.
- Pre-aggregated Oracle views and indexed tables to reduce Power BI dashboard refresh time by ~60%.
Systems Integration & Technical Support
- Integrated with REST APIs (e-commerce), SOAP (Gold CRM), WhatsApp API (OTP, alerts), SFTP (Talabat), SMTP (emails), and SMB (POS files).
- Built 4 delivery aggregator portals (Talabat, Deliveroo, Huawei, Tap Payments) for bill registration, 2-step verification, and return tracking.
- Designed and maintain a full Power BI dashboard suite (Sales, Stock, Fast-lines, Customer, HR) — the primary reporting tool for management.
- Provided technical support across 10 issue areas: POS, vouchers, weight scales, auto PO, reception, card issues, suspended bills, mix-and-match, and entry corrections.
The work behind the résumé.
Eight projects from a portfolio of 40+ — each replaced a manual process with something indexed, automated, and owned end-to-end.
Retail Data Warehouse
(Star Schema)
Architected a Star Schema warehouse in Oracle PL/SQL with full ETL procedures, indexed views, and temp tables — serving as the single source of truth for all BI and executive reporting across Sales, Inventory, Finance, and HR. Pre-aggregated Gold-layer views power the Power BI dashboard suite.
GrandApiMaster
(.NET 8 Web API)
Built a .NET 8 ASP.NET Core Web API with 3 controllers: Ecommerce (order sync with transactional multi-table inserts), Loyalty (customer batch sync in batches of 1,000, point sync, purchase sync), and Product (price check with Arabic conversion, promotion images via HtmlAgilityPack). Dual Oracle connections with Dapper ORM and Swagger documentation.
GrandME Loyalty
Program (6 Modules)
Built a complete loyalty platform: customer enrollment portal with WhatsApp OTP (4-digit, 3-min expiry), card allocation from pre-loaded pool (FOR UPDATE SKIP LOCKED), voucher creation with ZXing.Net barcode generation, ~500K customer migration with deduplication, customer update portal with validation, mobile capture campaign tracking, and loyalty reporting.
11 Scheduled Python
Automation Scripts
Developed 11 production Python scripts using cx_Oracle for: loyalty point sync (with slab structure calculation), live sales summary sync across 2 databases, online store price/stock updates pushed to e-commerce server, POS file access via SMB, DMS document download + email distribution, missing bill recovery from POS XML files, promo flag updates, and WhatsApp image distribution.
Talabat Delivery
Aggregator Suite
Built 4 integration portals: bill registration with 2-step verification workflow (Store Manager to Cash Officer), price/stock SFTP update to Talabat server (SQL*Plus SPOOL to CSV), return registration with missing-item tracking for stock correction, and return reporting. Supports 6 aggregator types: Talabat, Deliveroo, Huawei, Tap Payments, Katch, Wiyak.
Automated Purchase
Order Engine
Built a PL/SQL function generating warehouse-to-store replenishment orders based on stock movement, pending shipments, damage data, and orderable pack conversion. Uses GOLD_SERVER DB link for real-time stock data across all branches.
Inventory Management
Suite (6 Projects)
Built 6 inventory projects: full stock movement ledger (sales, purchases, returns, transfers, adjustments), annual physical inventory with PDT scanners and PL/SQL variance procedures, daily stock take batch creation, inconsistency/sales-loss analysis portal with remarks workflow, negative stock management, and fresh inventory view.
Tools I reach for.
Databases
- Oracle SQL (10g)
- Oracle PL/SQL
- MS SQL Server
- DB Links & MERGE
- Stored Procedures
Backend
- C# (.NET Framework 4.6)
- .NET 8 / ASP.NET Core
- ASP.NET Web Forms
- Dapper ORM
- .NET Console Apps
Scripting
- Python (cx_Oracle)
- Python (pandas, openpyxl)
- Batch Scripts
- SQL*Plus SPOOL
Frontend
- HTML / CSS
- JavaScript
- jQuery & AJAX
- Bootstrap 3/5
- Tailwind CSS
Integrations
- REST APIs
- SOAP Web Services
- WhatsApp API
- SFTP / SMTP / SMB
- Swagger / HttpClient
BI & Reporting
- Power BI
- ETL / Star Schema DWH
- ClosedXML (Excel)
- ZXing.Net (Barcode)
- wkhtmltoimage
Tools
- Visual Studio
- VS Code
- Toad / SQL Developer
- Git
- WinSCP
Domain
- Retail ERP / POS
- Loyalty Programs
- Inventory Management
- GP Reporting
- Delivery Aggregators
Soft Skills
- Root Cause Analysis
- Cross-team Coordination
- Technical Support
- Process Documentation
Grounding.
Let's build something.
Open to Full Stack, Backend, Data Engineering, and Retail IT roles across Kuwait, the GCC, and remote.