Co-op Competitor Pricing Reports Project
This project, undertaken at Co-op’s Food Retail Business Intelligence Team, focused on developing a Java-based solution to generate competitor pricing reports. By integrating weekly data for 50,000 products from Assosia across 30 different providers via REST APIs, the solution produced management reports to assist the pricing team in optimizing prices based on store demographics and local market needs. The project enhanced Co-op’s competitiveness in the retail sector, leveraging pure Java worker services, Agile methodologies, and Test-Driven Development (TDD) for reliable and accurate data processing.
Features
- Competitor Pricing Reports: Generated comprehensive management reports from weekly data on 50,000 products across 30 providers, enabling data-driven pricing decisions.
- Third-Party Data Integration: Integrated with Assosia’s REST APIs to pull competitor pricing data, ensuring up-to-date and accurate market insights.
- Java Worker Services: Developed pure Java services for seamless API integration, efficiently processing large datasets for reporting.
- Price Optimization: Provided actionable insights for the pricing team to tailor prices to store demographics and local market conditions, enhancing Co-op’s competitiveness.
- Test-Driven Development (TDD): Applied TDD principles with JUnit to ensure reliability, accuracy, and maintainability of data integration and reporting services.
- Agile Methodologies: Utilized Agile practices for flexible and iterative development, adapting to evolving business requirements.
- High Data Volume Processing: Handled weekly datasets for 50,000 products, optimized for performance and scalability.
- Customizable Reports: Produced tailored reports for management, supporting strategic pricing decisions across diverse retail stores.
- Broad Data Coverage: Enriched Co-op’s data warehouse with competitor pricing, alongside other data like weather forecasts, for holistic business intelligence.
- Reliable Data Pipeline: Ensured consistent and accurate data flow from third-party providers to the data warehouse, minimizing errors.
- Scalable Architecture: Designed services to scale with increasing data volumes and provider integrations, supporting future growth.
- Collaborative Development: Leveraged Trello for team collaboration, maintaining quality and transparency.
- Business Intelligence Enhancement: Strengthened Co-op’s BI capabilities, enabling better logistics, pricing, and workforce management decisions.
- Robust Error Handling: Implemented error handling in API services to ensure data integrity and operational continuity.
- User-Centric Reporting: Delivered reports optimized for the pricing team’s needs, improving usability and decision-making efficiency.
Co-op Assosia Java Teradata Strategy Software Agile Trello JUnit 5 SQL