SFDA Validation Tool

SFDA Validation Automation Tool | Python, Pandas & OpenPyXL

Developed a Python-based automation tool to streamline the validation and correction of invalid medical service and medication codes using official Saudi Food and Drug Authority (SFDA) data.

The tool automatically processes Excel files containing invalid codes, cross-references them with official SFDA datasets, identifies the correct valid codes, and generates structured results, eliminating the need for time-consuming manual searches.

Key Features:

- Automated validation and correction of medical codes.

- Bulk processing of Excel files using Python, Pandas, and OpenPyXL.

- Cross-referencing with official SFDA data sources.

- Reduced manual effort and minimized human errors.

- Improved data accuracy and operational efficiency.

- Developed as a standalone tool adopted by the healthcare pricing team.

Impact:

Transformed a repetitive manual validation process into an efficient automated workflow, saving time, improving accuracy, and enhancing productivity in healthcare pricing operations.