Northstar CRM: Full-Stack Customer Relationship and Sales Management Platform
I designed and developed Northstar CRM to transform customer relationship management into a focused, visually intuitive, and connected workspace. Instead of overwhelming sales teams with dense tables and fragmented tools, I structured the platform around clear customer insights, actionable sales data, and streamlined daily workflows.
The visual identity combines a soft atmospheric background with glass-inspired surfaces, dimensional cards, and vibrant blue, teal, yellow, and charcoal accents. Carefully layered shadows, subtle gradients, and elevated components create a refined 3D appearance while maintaining clarity and professional usability. The entire interface follows a consistent 4:3 presentation ratio, making every screen suitable for portfolio displays and high-quality screenshots.
The overview dashboard gives users an immediate picture of business performance. Key metrics—including total revenue, pipeline value, completed tasks, priority deals, recent activities, and upcoming meetings—are presented through scannable cards, progress indicators, compact charts, and contextual status colours. This allows teams to identify important changes and required actions without navigating through multiple reports.
The customer management screen provides a searchable directory with company information, recent interactions, account value, relationship status, and assigned ownership. Selecting a customer dynamically updates the detailed profile panel, where users can review contact information, relationship health, next actions, and communication options such as messaging, calling, or scheduling a meeting.
The deal pipeline organizes opportunities into clear stages, including Discovery, Proposal, Negotiation, and Closing. Each opportunity card displays its customer, estimated value, expected closing date, owner, and current stage. The Kanban-style structure gives sales teams a visual understanding of pipeline movement while supporting faster prioritization and opportunity management.
The calendar and reporting screens connect operational planning with performance analysis. The calendar provides monthly scheduling, customer meetings, deadlines, focus time, and team commitments. The reporting workspace combines revenue trends, conversion rates, customer retention, pipeline sources, account health, and period-based performance comparisons through interactive charts and summary cards.
On the backend, I implemented a modular Node.js and Express REST API connected to a PostgreSQL database. The data model supports users, customers, companies, contacts, deals, pipeline stages, activities, tasks, meetings, notes, and reporting records. Structured relationships and indexed queries ensure that customer histories, pipeline summaries, and dashboard analytics remain fast and consistent as the dataset grows.
Authentication is handled through secure token-based sessions, password hashing, protected API routes, and role-based access control. Different permissions can be assigned to administrators, sales managers, and sales representatives, ensuring users only access or modify information relevant to their responsibilities. Input validation, centralized error handling, audit logging, and rate limiting strengthen reliability and application security.
Real-time updates allow changes to deals, tasks, customer activity, and meeting schedules to appear across connected screens without requiring a manual refresh. Background processes handle reminders, notifications, scheduled follow-ups, and reporting calculations, while caching improves the performance of frequently requested dashboard metrics.
Across the complete full-stack platform, I prioritized reusable frontend components, responsive layouts, secure API design, reliable data relationships, and consistent interaction patterns. The result is a modern CRM experience that feels premium and approachable while providing the technical foundation required for scalable customer management, sales execution, and business intelligence.
The backend model is the interesting part here. Once customer history, pipeline stages, tasks, and meetings share relationships, it’s easy for dashboard numbers to drift from the underlying records. Did you calculate those summaries on demand, or keep derived reporting data updated through the background jobs you mentioned?
ARTHADṚṢṬI — Amazon Sales Intelligence & Business Performance System
What started as an analytics project became an opportunity to build something closer to a real-world business reporting system.
I worked with Amazon sales data and took it through an end-to-end analytics workflow:
Raw Data → Data Cleaning → Transformation → Data Modeling → DAX → Power BI → Business Insights
What I worked on
• Data profiling and quality checks
• Cleaning & transformation using Power Query
• Handling missing and inconsistent data
• Business KPI development
• Data modeling
• DAX measures
• Interactive dashboard design
• Sales, product, fulfilment & geographic analysis
The final system provides visibility into:
→ Sales & revenue performance
→ Orders and units
→ Category & SKU performance
→ Fulfilment operations
→ Monthly trends
→ Geographic distribution
→ Interactive filtering & drill-down analysis
But the biggest lesson from this project was simple:
A dashboard shouldn't just look good. It should make the underlying data easier to understand and act upon.
I’m also available for dashboard projects.
If you have Excel, CSV, or other business data that is difficult to analyze, I can help transform it into a clean, professional and interactive dashboard.
Services I can provide:
→ Power BI Dashboard Development
→ Excel Dashboard Development
→ Data Cleaning & Transformation
→ Power Query Automation
→ DAX & KPI Development
→ Business / Sales Analytics
→ Interactive Reporting Systems
Whether you need a dashboard built from scratch, an existing report improved, or messy data transformed into something usable, I'm open to working on it.
Have a dataset or reporting problem?
Send me a message. Let's turn the data into something useful.