Problem
The challenge with unstructured data at scale.
The analyst team faced a massive bottleneck: it was necessary to consult health fund transfer details for hundreds of municipalities on the FNS portal manually. This required navigating through multiple layers, hidden buttons, and slow modals, significantly delaying strategic analysis.
Solution
An intelligent, automated extraction pipeline.
I developed a Python-based automation script that simulates a user navigating through the entire FNS portal. Using Playwright, the script finds target municipalities, interacts with the complex UI to fetch financial data, and extracts it automatically into a structured format.
- Automated navigation with Playwright
- Municipal-based input automation
- Data cleaning and CSV consolidation with Pandas
Tech Stack
Results
The project completely eliminated manual consultation. What used to take days for an entire team now runs in minutes, ensuring 100% accurate data for the company's financial monitoring.