Application and Database Analyst Farmapatria
Administered and maintained a nationwide network of 120 SQL Server databases, performing periodic reviews, data cleanup, inconsistency correction, backups, and restoration activities.
Audited inventory figures, identified and reported discrepancies, and produced Excel business reports covering profits, losses, upcoming expirations, and products without movement using SQL queries against national consolidated and central-distribution databases.
Built complex SQL queries using joins and subqueries to extract and cross-reference information across multiple databases. Documented standard procedures for SQL Server cleanup, storage release, restoration, and database recovery.
Provided nationwide functional and technical support for the SAINT system, including user permissions, data discrepancy resolution, and incident management for pharmacy state coordinators.