◆ Egypt-Japan University For Science and Technology (E-JUST) — 2025

Architecting Mission-Critical Business & ERP Systems.

I bridge financial accounting discipline with full-stack software engineering. I design and build secure distribution management systems, multi-branch ERP solutions, and executive business intelligence dashboards that eliminate phantom inventory, enforce discount governance, and safeguard cash flows.

Explore Featured Systems View GitHub Profile
6+ Production Systems
100% Audit Precision
3 Multi-Branch Hubs
BusinessControlEngine.ts RLS Active 
// Transactional Inventory & Discount Gate
export async function processOrderGate(order: SalesOrder) {
  // 1. Enforce strict Available Stock check
  const available = onHand - reserved;
  if (order.quantity > available) 
    throw new StockDeficitError('Zero Phantom Stock');

  // 2. Hard discount ceiling authorization
  if (order.discountPct > 0.05) 
    return await queueForManagerApproval(order);

  // 3. Atomic double-entry movement ledger write
  return await ledger.commitTransaction(order);
}
✓ Accounting Controls: Double-entry inventory movements & cash audit.
✓ Security: PostgreSQL Row-Level Security (RLS) territory isolation.
✓ Cross-Platform: Native Windows Electron + Cloud Web + Google Apps Script.
Professional Background

Where Accounting Rigor Meets Software Engineering

Building business software requires more than knowing how to code; it requires understanding chart of accounts, credit exposure, gross margins, and inventory lifecycles.

I am a Business Systems Developer graduating from Egypt-Japan University For Science and Technology (E-JUST, Class of 2025) with a degree in Accounting and Information Systems. This dual foundation enables me to design software solutions that directly reflect commercial reality and eliminate operational vulnerabilities.

Most operational errors in growing businesses occur because off-the-shelf software doesn't fit custom commercial workflows, while pure software developers often misunderstand inventory valuation (WAC/FIFO), credit risk limits, and double-entry transaction ledgers.

My Core Philosophy: Business systems must guarantee data integrity at the database layer. By enforcing business rules—such as deterministic stock availability, discount authorization gates, and multi-tenant row security—I eliminate revenue leaks and deliver frictionless tools for field teams and executives alike.
📊

Financial & Commercial Discipline

Trained in managerial accounting, receivables aging, cash flow reconciliation, VAT compliance, and inventory valuation models for high-velocity FMCG markets.

⚡

Enterprise System Architecture

Designing relational database schemas (PostgreSQL), serverless Google Apps Script engines, and native Windows desktop apps (Electron + React) with strict role isolation.

🛡️

Data Security & Auditability

Implementing PostgreSQL Row-Level Security (RLS) policies that enforce territory boundaries per sales representative, combined with tamper-evident audit logs.

Core Competencies

Technical & Business Systems Stack

A balanced skill set combining full-stack development, database architecture, and operational business acumen.

🏢

ERP & Operations

Distribution Management (DMS) FMCG & Wholesale
Double-Entry Inventory Ledgers Zero Stock Drift
Credit Control & Discount Gates Risk Mitigation
Multi-Branch Scoping Cairo • Alex • Mansoura
💻

Software Engineering

React 18 & TypeScript High-Performance UIs
Electron Desktop Packaging Native Windows NSIS
Google Apps Script (GAS) Serverless Automation
Tailwind CSS & Vite Modern Tooling
🛡️

Databases & Security

PostgreSQL 16 & Supabase Relational Modeling
Row-Level Security (RLS) Territory Isolation
Financial Precision (NUMERIC) Zero Rounding Error
Automated Testing & QA Financial & Auth Suites
📈

Analytics & BI

Advanced Excel & Power Query Automated ETL & DAX
Gross Margin & Pareto 80/20 Profitability Analysis
Receivables Aging & DSO Cash Flow Risk
Executive KPI Dashboards Recharts & BI Modeling
Real Systems Showcase

Mission-Critical Business Systems

Every project represents genuine software architecture solving concrete business problems in inventory, distribution, sales governance, and financial reconciliation.

Al OFUK Food Distribution Management System Enterprise Web ERP

Al OFUK – Food Distribution Management System

Full-stack B2B wholesale distribution ERP addressing inventory blindspots, unauthorized rep discounts, and bad debts across FMCG accounts.

✓ Real-Time Stock Gate: Available = Physical - Reserved.
✓ Automated 5% Discount Gate requiring managerial override.
✓ Immutable double-entry inventory ledger (zero stock drift).
React Vite PostgreSQL Supabase RLS Tailwind CSS
Live App ↗ Private Repo
Al Amal Distribution Management Desktop Application Desktop ERP (Windows)

Al Amal Distribution Management System (Desktop ERP)

Enterprise Windows desktop application with strict PostgreSQL Row-Level Security isolating North Cairo, Giza, and East Cairo sales routes.

✓ CEO Consolidated Suite vs Field Rep isolated route views.
✓ Central warehouse batch tracking & expiration warning triggers.
✓ Automated test suite: auth.test, financial.test, inventory.test.
Electron React 18 TypeScript Supabase RLS Recharts
Interactive Demo ↗ GitHub ↗
Google Apps Script Distribution Management System Serverless Cloud DMS

Google Apps Script Distribution Management System

Zero-infrastructure cloud ERP running directly on Google Workspace, converting Google Sheets into a high-reliability relational database.

✓ Modular backend architecture: Config, Auth, Database, Audit.
✓ Automated sequential document codes: INV, PO, RCP, RET.
✓ Concurrency write locking avoiding multi-user sheet overwrites.
Google Apps Script Google Sheets API JavaScript V8 HTML Service
View Architecture & Code ↗
Premium Sales Intelligence Dashboard Excel Executive Excel BI

Premium Sales Intelligence Dashboard – Excel

C-suite executive BI model replacing manual spreadsheet assembly with automated Power Query ETL, margin decomposition, and DSO aging.

✓ Dynamic multi-dimensional slicers: Branch, Rep, Product Category.
✓ Pareto (80/20) analysis isolating top-margin wholesale accounts.
✓ Receivables aging schedule evaluating bad debt exposure.
Microsoft Excel Power Query (M) Dynamic Arrays Financial Modeling
Request a Custom Dashboard ↗ GitHub ↗

Need a dashboard tailored to your business? I can build a customized Excel or Power BI solution using your own business data, KPIs, and reporting requirements.

Sales Executive Performance Dashboard Performance Analytics

Sales Executive Performance Dashboard

Field sales quota analytics and incentive engine tracking 3,190,000 EGP team targets across Cairo, Alexandria, and Mansoura branches.

✓ Automated 2% Net Sales tiered commission calculation.
✓ Cash Collection Gate (>80% required for commission release).
✓ Multi-branch leaderboard and customer visit frequency metrics.
React TypeScript Recharts PostgreSQL Tailwind CSS
Live Demo ↗ GitHub ↗
Enterprise Multi-Branch Desktop ERP Multi-Branch ERP

Enterprise Multi-Branch Desktop ERP & Analytics Backend

Centralized enterprise architecture connecting Cairo, Alexandria, and Mansoura hubs with strict server-side branch scoping and financial rounding safeguards.

✓ Strict Server-Side Branch Scoping (403 on cross-branch tampering).
✓ PostgreSQL NUMERIC(14,2) precision eliminating rounding drift.
✓ Complete SDLC specifications, schema definitions, and Docker setup.
PostgreSQL 16 Express.js Prisma ORM Docker Electron
Interactive Demo ↗ GitHub ↗
Freelance & Consulting

Specialized Business Systems Services

Tailored solutions designed for SMEs, wholesale distributors, and commercial enterprises seeking robust operational software.

📦

Custom ERP & Distribution Systems

Complete design and development of web or desktop distribution platforms tailored to Egyptian and regional trading operations.

  • ✓ Deterministic stock check & zero phantom stock
  • ✓ Rep discount authorization rules (>5% gate)
  • ✓ Customer credit limits & receivables monitoring
  • ✓ PostgreSQL Row-Level Security route isolation
📊

Executive BI & Excel Modeling

High-level executive dashboards and financial models that turn chaotic spreadsheet records into real-time decision intelligence.

  • ✓ Automated Power Query (M) ETL data pipelines
  • ✓ Gross margin decomposition by SKU and branch
  • ✓ Overdue aging analysis & cash flow forecasts
  • ✓ Dynamic slicers, DAX measures, and zero errors
⚡

Google Workspace Automation

Cost-effective cloud automation eliminating SaaS license fees by turning Google Sheets into auditable, multi-user business tools.

  • ✓ Custom Google Apps Script V8 backends
  • ✓ Automated sequential numbering (Invoices, POs)
  • ✓ Tamper-evident financial audit logs
  • ✓ Multi-user concurrency lock protection
🛡️

Database & Internal Controls Architecture

Structuring database schemas and operational business logic to prevent revenue leaks, stock variances, and employee error.

  • ✓ Relational PostgreSQL 16 schema optimization
  • ✓ Multi-branch tenant scoping & security policies
  • ✓ Data migration from legacy Excel workbooks
  • ✓ Integration testing for mission-critical flows
Direct Channel

Ready to discuss your business system or analytics project?

Whether you are an enterprise seeking a custom distribution platform, an SME migrating away from chaotic spreadsheets, or an employer looking for a hybrid Business Systems Developer, I am available for consultations and projects.

✉
Direct Email
moaz14714@gmail.com
Email
📍
Location / Focus
Alexandria, Egypt • Remote Worldwide
GitHub Profile
Review repositories, database schemas, and codebase commits.
Explore ↗
LinkedIn Connection
Connect for professional inquiries, full-time roles, or consulting.
Connect ↗
Fiverr Service — Excel Dashboards & Analytics
Order custom sales intelligence models, Power Query ETL, and executive reports.
View Gig ↗
Fiverr Service — Cloud Automation & Business Systems
Order Google Apps Script automation, Sheets ERPs, or custom workflow systems.
View Gig ↗