Diana Matar

• Implementation of BigQuery Data Hub for all UNOPS personnel across 80+ countries, improving scalability, data quality, and AI readiness.
• Support DataForm-based ETL/ELT and metadata automation to ensure consistent, reliable transformations.
• Collaborate with service line analysts and data stewards to strengthen reporting accuracy and governed data flows.
• Build BigQuery cost and slot-usage dashboards to improve cloud transparency and capacity decisions.

Key Achievements

• Achieved ~50% reduction in BigQuery warehouse cost ($150K/year) through disciplined capacity and slot-usage optimization.
• Improved data consistency and lead time across 500+ Data Hub dimensions and facts.
• Enabled foundations for the semantic layer and AI-ready modelling, supporting UNOPS’ future analytics capabilities.

• Collaborated with product and marketing teams to analyze multi-country user behavior across 27M+ monthly users.
• Worked with a four-member engineering team to build and maintain a cloud-based big data architecture with self-service analytics.
• Optimized BigQuery models using nested and repeated fields to improve performance and storage efficiency.

Key Achievements

• Developed a 100TB+ analytical data warehouse spanning AWS (Redshift, S3) and GCP (BigQuery, Dataproc).
• Improved query performance and storage efficiency through BigQuery model redesign.
• Delivered high-visibility dashboards supporting product, marketing, and operations decision-making.

• Built a scalable AWS Redshift warehouse for Zalando Product Lifecycle Management (PLM) data, tracking 100M+ orders and product availability.
• Developed real-time pipelines delivering product insights for 900M+ visitors per quarter.

Key Achievements

• Improved pricing and inventory visibility with time-series analytics.
• Optimized PLM data models for faster, more reliable reporting.

Redesigned the data warehouse and built data marts for 300M+ customer loan-offer history, including Python/Pentaho pipelines for Google Ads and geolocation analytics.

Key Achievement

Improved data completeness for credit-scoring models and enhanced marketing attribution through automated AdWords and geo-data integration.

Co-developed an AWS Kinesis streaming app connecting the sports-betting platform with IBM Marketing Cloud (Spring Boot, Java).

Key Achievement

Built a real-time bonus-credit module enabling instant rewards with zero wait time.

• Developed BI reports and dashboards for peacekeeping, logistics, finance, and HR, integrating mission data into accessible reporting for operational teams.
• Supported BI training and created offline reporting tools for field staff working in low-connectivity environments.

Key Achievements

• Delivered self-service reporting used by UN RSC service lines to support results-based budgeting presentations to the UN steering committee.
• Helped deliver training sessions that improved data literacy for mission personnel and strengthened day-to-day reporting practices.

• Built a lifecycle management system for 1,500+ UN Volunteers.
• Led two developers to deploy the system across additional UN missions.

Key Achievement: Improved UNV administrative processing efficiency by ~30% through streamlined workflows.

Delivered PHP/ASP.NET/MySQL web systems for small businesses.