Cooperativa Agrícola de Vila do Conde, CRLData Analyst & IT Manager - Data & Business Systems
Sep. 2021Vila do Conde, Porto, Portugal• Developed and deployed 5+ interactive Power BI dashboards that automated reporting for sales and operations, reducing manual report generation time by 15 hours per month. • Engineered ETL processes using Power Query to source, clean, and model large datasets from multiple systems, improving data integrity by 25% for reporting and analysis. • Automated data aggregation from multiple sources using Python (Pandas, NumPy), reducing data preparation time by 5 hours weekly and minimizing manual errors. • Wrote and optimized complex SQL queries (joins, subqueries) to extract and transform data from Primavera ERP, decreasing ad-hoc report turnaround time by 30%. • Created Excel VBA automation scripts that streamlined repetitive data entry and reporting tasks, saving up to 10 hours per week in employee productivity. • Managed technical projects focused on improving operational efficiency through data analysis and process automation.