Design a software for supply chain management from purchasing raw material with special coding that received in warehouse and compute BOM for cost price then scheduling production depends on sale order weekly. Releasing production order with computing timing in each work center and put the data in SQL Server that had schema in sale, production, purchasing, inventory (stores) and export the report to Excel format cause then import data to Power BI and data modeling for Power BI Report Server in holding that could show reports to managers of any departments such as financial and sale manager.Also, the system have a module that could handle PM (Preventative Maintananc) with analysis amount of used machine parts for historical failures.

Coding of agricultural seeds entering the plant (for Sorting, ...) and Design of a tracking system till Final Product. After all, create a system for Supply Chain Management by Excel and Access. Then definition KPIs in Financial and Production that was shown in Power BI Report Server for Managers.