Objective
To design and develop a database for a logistics company to manage all orders to be transported from suppliers to buyers
along with the warehouse details and various modes of transport.
Achievements
Created detailed entity-relationship (ER) diagrams to model relationships among key entities and restructured tables by applying
normalization and indexing techniques, eliminating redundancy and accelerating query performance by 60%.
Defined SQL functions, stored procedures, views, triggers and integrated transaction management control strategies to generate
custom reports, providing insights into KPIs, leading to a 25% boost in operational efficiency.
Tech Stack
SQL, Numerical Analysis, Financial Reporting
