dbdocs

Designed an efficient banking database using PostgreSQL and pgAdmin. Focused on optimizing transaction management included key aspects like data modeling, database architecture, security, and performance.

This Database Design and Optimization Project, utilizing PostgreSQL, encompassed a thorough initiative aimed at elevating data management. Through strategic enhancements to the database structure, performance improvements, and operational streamlining, the project has successfully transformed the system.

GLPI dbdocs generator/publisher

Optimized business operations with a comprehensive database system. Streamlined inventory management, order processing, manufacturing processes, and logistics. Ensured quality control and efficient employee management for a seamless end-to-end solution.

Sample of GitHub Actions to execute CI for dbdocs.

Go project with Gin framework

End-to-end SQL analytics for market expansion. Designed schema, applied normalization, and used advanced SQL (CTEs, Window Functions, Cohorts) to analyze sales. Created a composite city score and 30+ metrics to recommend top cities for a coffee company's physical store rollout.