About
Market Prospector is a self-serve, web-based tool designed to help distributors in North America optimize their strategic planning and sales programs. By integrating proprietary data with customer files, it identifies market opportunities and gaps, enabling businesses to segment markets, grow wallet share, and target qualified prospects.
Challenge, approach, and impact
AWS Infrastructure Management
Setting up and managing AWS services to support scalable, reliable, and cost-effective hosting. Ensuring the system utilized appropriate services like EC2, S3, and RDS while optimizing resource allocation to handle fluctuating loads without overspending.
TypeScript and React Integration
Handling the intricacies of integrating TypeScript with React to ensure strong typing and proper state management. Ensuring that TypeScript's static typing did not introduce complexity in the development process, especially with dynamic React components.
State Management in React
Designing an efficient state management system for handling complex data states across multiple components, particularly when dealing with large datasets and dynamic reports. Choosing the right libraries (e.g., Redux or Context API) while minimizing performance overhead was crucial.
gRPC Integration & Performance
Ensuring smooth and efficient integration of gRPC for communication between microservices. The challenge was in configuring gRPC properly to support high-performance, low-latency, and bidirectional streaming without encountering connection issues or downtime.
API Versioning & Backward Compatibility
Managing API versioning in ASP.NET Core and ensuring backward compatibility across different versions of the platform. The challenge was in making sure that the API could evolve without breaking existing functionality for users or integrations.
MySQL Query Optimization
Optimizing complex queries in MySQL, especially when dealing with large-scale data processing, filtering, and aggregation. Ensuring queries executed quickly without impacting the user experience, even with high volumes of market data.
Microservices Architecture & Communication
Managing communication between various microservices in the platform. Ensuring services interacted effectively and handled failures gracefully was crucial, especially when using technologies like gRPC for inter-service communication.
Testing & Debugging Complex Interactions
Testing the integration of React front-end with ASP.NET Core back-end services, ensuring that the data was rendered properly and the user interface was responsive. Debugging interactions between the two, particularly with TypeScript and React’s lifecycle methods, posed challenges in ensuring stability.
Platform Migration
The project faced the challenge of migrating from an outdated platform to a more modern tech stack. We had to transition to a new programming language that would improve scalability, speed, and performance, allowing us to better serve a growing number of clients and meet their increasing demands.
Reporting and Forecasting Calculations
Another challenge was designing and implementing an accurate and efficient system for generating reports and forecasts. We had to ensure that the calculations for market opportunities, trends, and future forecasts were reliable and fast, enabling clients to make data-driven decisions in real time.
How we built
Testimonials
Anonymous
Diligent Solutions DOO
“Leading the MDM Market Prospector project was a rewarding experience. As team lead, I guided a five-member team using SCRUM methodology to develop a web-based tool that helps North American distributors optimize sales and strategic planning. By integrating data with customer files, the tool identifies opportunities and supports data-driven decisions, driving profitability. Using AWS, React, TypeScript, ASP.NET Core, gRPC, and MySQL, we created a scalable solution that improves market segmentation and prospect targeting. This project has been both challenging and fulfilling, knowing it directly contributes to distributor growth and success.“
Team structure
Client team
Donnie W
Director of Analytics
Daily point of contact
The client stakeholders were working closely with the team at Diligent Solutions
Agency team
1 x Solutions Architect
Production
2 x Project Manager
Production
1 x Team Lead, Full Stack Engineer
Production
3 x Full Stack Engineer
Production
