Web Development & Data Engineering
Droguería Opunsa
A modern website and custom sales and inventory data platform for a pharmaceutical distributor in Panama.
- Web Development
- SEO
- Data Warehouse
- SAGE 50
- SSIS
- SSRS
Project overview
Droguería Opunsa needed a clear digital presence that reflected the reliability expected from a pharmaceutical distributor. JotasLabs created a responsive website with focused service information, cleaner navigation, SEO foundations, and room for future content growth.
The company also needed sales and inventory reports that were not available directly in SAGE 50. JotasLabs designed and developed a data warehouse connected to the SAGE 50 database, with dimensional tables for clients, laboratories, products, and other business entities, plus fact tables for sales and inventory.
ETL workflows were built with Microsoft SQL Server Integration Services (SSIS), while personalized operational reports were created in Microsoft SQL Server Reporting Services (SSRS) and made available for export to Excel.
JotasLabs continues to support the website, data warehouse, integrations, and reporting workflows as the company's needs evolve.
Selected screens
JotasLabs
Have a similar challenge?
Tell us what you need and we will shape the right digital or technical solution.