Back to Portfolio
SheetSync Analyzer
ISBAT Final Project — Django Tool for Health Report Automation
Context
This was my university final project at ISBAT University, designed to solve a critical problem faced by health teams: frequent Excel reporting errors caused by manual cross-sheet comparison. Health workers were spending hours manually comparing data across multiple spreadsheets, leading to inaccuracies and wasted time.
Problem
Manual cross-sheet comparison in Excel was causing:
- Time-consuming manual data verification processes
- Human errors leading to reporting inaccuracies
- Delayed reporting cycles affecting decision-making
- Lack of visual summaries for quick insights
My Role
Full-stack developer — responsible for:
- Backend data processing using Django and Python (Pandas)
- Front-end visualization with JavaScript and Chart.js
- Automated comparison algorithms
- Error detection and flagging system
Tech Stack
Django
Python
Pandas
JavaScript
Chart.js
HTML/CSS
Outcome
Key Achievements:
- Automated cross-sheet comparisons, eliminating manual work
- Built error detection system that flags discrepancies automatically
- Created visual summaries using Chart.js for quick insights
- Result: Increased reporting accuracy and significantly reduced processing time
Impact
The SheetSync Analyzer transformed how health teams handle reporting data. By automating the comparison process and providing visual summaries, teams can now focus on analysis rather than data entry, leading to faster and more accurate health reporting.
Back to Portfolio