Inventory Management Data Pipeline and Risk Analysis
Services Covered:

Information Technology
11 months
Confidential
1 March 2024
1-5
Nearshore
Project Capability Score (PCS)
Project Capability Score (PCS) estimates how capable Pynest is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS
Client
Confidential
Project Summary
Key Challenges
- Track and forecast products at risk of write-offs to reduce waste and enable faster donation to shelters and charities
- Improve inventory management to better identify stock and overstock situations
- Combine disparate data sources and migrate data reliably for timely access and analysis
Project Deliverables
- Integration and migration of primary data sources from Azure and setup of data pipelines
- ETL implementation using Python, SQL, and PySpark
- Stock and over-stock analysis algorithms with intermediate storage in ClickHouse
- Risk analysis algorithms to forecast inventory risks
- Visualization dashboard presenting stock-at-risk and write-offs
Project Solution
Project Outcome
- Improved data integration and migration processes for more reliable and timely data access
- Improved ability to detect and manage stock and overstock situations, reducing potential waste
- Effective risk analysis capabilities enabling proactive inventory management
- Clear and informative visualizations that facilitate better decision-making regarding stock management
Platforms
Web
Tech Stack
Python
PySpark
SQLClickHouse
Apache Hadoop
Client Endorsement
Overall Review Rating
Timeliness
Cost Rating
Willing to Refer
Quality of Deliverables
The solution Pynest built is scalable and efficient. It made our data integration and migration work better and strengthened our risk analysis. They delivered on time, understood what we needed, communicated clearly, and worked with us smoothly. We were impressed by how thorough their approach was.
Note: This endorsement is based on publicly available client feedback from external review sources.

