Alvaro Parra

I collaborated with the marketing team in a pharmaceutical company to extract information and build a dashboard to visualize, analyze, and increase sales.

PROBLEM
Employees were trying to process and analyze millions of sales on Excel spreadsheets, which was time-consuming and error-prone. The marketing manager requested a solution that could optimize and improve the process.

SOLUTION
We started by designing a data warehouse to extract information from the company's selling system. To store that information, we bought a server and installed a Microsoft SQL Server database. Next, we installed Pentaho Kitchen on another server and developed ETL pipelines to process information.

Once the design was stable, we began work on the visualization tool. We had QlikView at that time, so that's how we started developing the visualization portion. The new dashboard had a significant impact, as processes that had taken hours were done in a matter of minutes. It allowed us to measure each agency's sales and provide information to improve overall company sales.

I assisted in building financial reports for customer consumption. The reports were simple, but most had heavy queries behind them. I solved many issues related to the query logic and built financial reports based on that logic.

I built complex reports, including one that would be exported from SSRS into Excel to generate multiple Excel spreadsheets. I developed the report structure, created the queries that would extract the data, and collaborated with the customer to follow up and add last-minute updates.