Data modelling and database management for E-pharmacy platform Key Highlights:
- Designed and implemented conceptual and logical data models using E-R diagrams, ensuring accurate representation of database requirements and facilitating efficient data management.
- Developed and implemented a robust SQL database consisting of over 18 tables, views, and stored procedures, resulting in improved data organization and increased productivity.
- Optimized SQL queries on SQL Server, achieving 30% improvement in database server performance enabling faster response times for team members accessing the data.