Accounting & Information Systems Graduate | Egypt-Japan University For Science and Technology (E-JUST - 2025) β’ Alexandria, Egypt
I bridge the gap between financial accounting discipline and modern software engineering.
Most operational bottlenecks, margin leaks, and inventory discrepancies happen because commercial rules are loosely handled in code. With my background in Accounting and Information Systems, I architect mission-critical Distribution Management Systems (DMS), ERP solutions, and Executive Analytics Engines that enforce internal controls directly at the database and application levels:
- π Deterministic Stock Control: Real-time equations eliminating phantom inventory (
Available = Physical On-Hand - Reserved). - π Discount Governance: Automated authorization gates blocking field representative sales discounts exceeding 5%.
- π Credit Risk Safeguards: Dynamic credit limit checks halting order progression when customer exposure is breached.
- π‘οΈ Row-Level Security (RLS): Strict multi-tenant territory isolation per sales representative using PostgreSQL policies.
- π Double-Entry Ledgers: Immutable transactional logs (
inventory_movements) ensuring zero unexplained stock drift.
|
|
| Repository | Domain / Platform | Architecture Highlights |
|---|---|---|
| π¦ al-ofok-food-distribution | Enterprise B2B Web ERP | React, Vite, Supabase PostgreSQL with RLS, 5% discount approval gate, immutable inventory ledger. |
| π₯οΈ al-amal-desktop | Enterprise Desktop ERP | Electron, React 18, TypeScript, Supabase RLS territory isolation (Cairo, Giza, Alex), automated test suite. |
| β‘ al-amal-dms | Cloud Serverless DMS | Google Apps Script (V8), Google Sheets Relational Engine, automated document numbering (INV, PO), concurrency lock safety. |
| π premium-sales-intelligence-dashboard | Executive Business Intelligence | Microsoft Excel, Power Query ETL, Gross margin decomposition, Pareto (80/20) analysis, DSO aging schedule. |
| π― sales-executive-dashboard | Field Operations Analytics | React, Recharts, TypeScript, 3.19M EGP monthly team quota tracking, regional datasets. |
| π’ egypt-distribution-erp | Multi-Branch Enterprise ERP | PostgreSQL 16 Enterprise, Express.js REST API, Prisma ORM, Electron Desktop, Docker, regional branch scoping. |
- π Portfolio Website: moazawad2002.github.io/moaz-portfolio
- βοΈ Email: moaz14714@gmail.com
- πΌ LinkedIn: moaz-awad-649911376
- π€ Fiverr Gigs: Excel Dashboards & Analytics β’ Cloud Automation & ERP