Sales Rep Performance Dashboard – SAP-Integrated Analytics (SoficoPharm)

Internal analytics web app that gives SoficoPharm's management and sales teams a live view of sales performance across 29 branches, 50K+ customer accounts and 130+ vendors. Built from scratch (no off-the-shelf BI tools). It's a private company system, so screenshots are shown below.

• Sales vs. target with daily and monthly trends, Today / MTD / QTD / YTD views and achievement tracking

• 18 KPI cards: total sales, remaining target, invoices, active vs. coded customers, products sold, average invoice, growth, collections and open invoices

• Gross sales breakdown with discounts (vendor, company, deals, cash) and valid vs. expired returns

• Drill-downs by tree sector, distribution channel, customer group, branch, vendor and product

• Customer debt analysis, open-invoice aging and collections by cash, bank transfer and checks

• Dynamic filters (date range, sales office, customer group, customer, product, channel), one-click Excel export and a "last sync" indicator

• Light / dark themes, Arabic / English, and an AI Assistant powered by Claude (Anthropic) that answers questions from live data

• JWT authentication and role-based access, so each user sees only the branches and data their role allows

Tech: Angular, TypeScript, RxJS, ASP.NET Core Web API, Entity Framework Core, SQL Server, SAP OData, SignalR, background services, in-memory caching, IIS