RNSG CRM (Internal Operations Management)

Engineering & Architecture

• Cloud Architecture & Routing: Architected AWS EC2 infrastructure for staging and production. Configured Nginx reverse proxies for secure subdomain routing and utilized PM2 for zero-downtime deployments.
• Backend & Database: Developed scalable Node.js/NestJS services using PostgreSQL and Prisma to manage complex financial tracking and logistics relational data.
• Core Features: Built modules for retailer profile management, tiered promotions, and a delivery logistics system featuring photo proof-of-delivery.

Security & OWASP Compliance

Security was prioritized from day one, adhering to OWASP Top 10 guidelines:

• Access Control (A01): Implemented strict RBAC to enforce data isolation among sales staff and automated administrative approval gates.
• Injection Defense (A03): Leveraged Prisma for parameterized queries and rigorous input sanitization on all API endpoints.
• Misconfiguration (A05): Hardened AWS environments by resolving port collisions and securing Nginx configurations.

Coordination & QA Testing

Directed the technical integration between the web-based admin portal and a Telegram Mini-App workflow. Established rigorous staging-to-production release pipelines and translated complex business needs into automated system workflows.

Designed comprehensive unit and integration testing pipelines to validate business logic, access control matrices, and seamless data flow across the entire platform.