nexum crm
Personal project for the development of a comprehensive CRM system (actively being developed), created to optimize internal processes, manage client data, and automate routine tasks. The main focus is on speed of operation, reliability of the database architecture, and maximum data security.
Technical stack and architectural solutions:
Backend: Node.js using the Express.js framework. A clean REST API architecture has been built with a clear separation of responsibilities (routes, controllers, services).
Database & Infrastructure: Supabase (PostgreSQL) has been used. A relational table structure has been designed, relationships (One-to-Many, Many-to-Many) have been set up, indexes for optimizing complex queries, and mechanisms for cascading data deletion have been configured.
Security & Authorization: A robust user authentication and authorization system has been implemented (JWT tokens / Supabase Auth). Row Level Security (RLS) has been introduced in the database, completely eliminating information leakage between different accounts.
Quality Assurance (QA) and Testing Process (Your main feature):
Since I combine the roles of developer and QA engineer, the project is developed according to high code quality standards:
API Testing Automation: A complete collection of integration tests in Postman has been created and maintained. The verification of status codes, validation of JSON response schemas, and correctness of data transmission between endpoints have been automated.
Business Logic Testing: Scripts have been written to simulate critical user scenarios (creating a lead -> changing status -> generating a report) to check the integrity of the database under load.
Current Status: The project is in the active expansion phase (adding analytics modules and integrating external APIs). The code is maintained in Git following the Git Flow methodology.
Technical stack and architectural solutions:
Backend: Node.js using the Express.js framework. A clean REST API architecture has been built with a clear separation of responsibilities (routes, controllers, services).
Database & Infrastructure: Supabase (PostgreSQL) has been used. A relational table structure has been designed, relationships (One-to-Many, Many-to-Many) have been set up, indexes for optimizing complex queries, and mechanisms for cascading data deletion have been configured.
Security & Authorization: A robust user authentication and authorization system has been implemented (JWT tokens / Supabase Auth). Row Level Security (RLS) has been introduced in the database, completely eliminating information leakage between different accounts.
Quality Assurance (QA) and Testing Process (Your main feature):
Since I combine the roles of developer and QA engineer, the project is developed according to high code quality standards:
API Testing Automation: A complete collection of integration tests in Postman has been created and maintained. The verification of status codes, validation of JSON response schemas, and correctness of data transmission between endpoints have been automated.
Business Logic Testing: Scripts have been written to simulate critical user scenarios (creating a lead -> changing status -> generating a report) to check the integrity of the database under load.
Current Status: The project is in the active expansion phase (adding analytics modules and integrating external APIs). The code is maintained in Git following the Git Flow methodology.
Warszawa 
Available for hire