Tsunagu — Customer Management (CRM) System

• Customer and partner data was scattered across spreadsheets and personal files, with no central view.
• No history of who contacted whom and when, making follow-ups and outreach easy to miss.
• Customer information was underused, with no mechanism to turn data into revenue growth.
• Updating and sharing data depended on individuals, so the organization couldn't accumulate customer assets.

Centrally manage customer and business data with CRM features, visualize interaction history and deal status, and streamline sales to drive data-driven revenue growth.

• Build a CRM platform that centrally manages customer and partner data so the whole organization shares one source of truth.
• Provide a searchable, filterable admin UI with a React frontend and a Django (Python) backend.
• Provision infrastructure as code on AWS with CDK for a reproducible, maintainable operating platform.
• Stand up a new MySQL database; when the client already has a database, coordinate with their infrastructure to design a tailored migration/integration plan.
• Set up the GitHub repository, member permissions, and development operating conventions.

• Manage customer/business data (create, search, filter, update).
• Manage organizational info (owners, departments) and link it to customers.
• Record and visualize interaction history and deal status.
• Quickly look up customer information via lists and search.
• Data import / migration and integration from existing databases.
• User permission management for access control.

• Centralized customer/partner data, eliminating fragmentation and personal dependency.
• Accumulated and visualized interaction history, reducing missed follow-ups.
• Visualized customer information to support more efficient sales and revenue growth.
• Infrastructure as code with CDK for a maintainable, reproducible operating platform.