Diana Matar

• Jointly worked with team of three members to migrate UNOPS' SQL Server data warehouse to Google BigQuery cloud while implementing best practices in coding standards and data modelling.
• Collaborating closely with data analysts and stewards to ensure timely insights and optimal data use, while fostering and promoting culture of data stewardship and accountability for new reports and dashboards.

Key Accomplishments

Managed collaboration with PMO and infrastructure teams to develop GCP cost and BQ slot utilization dashboards, optimizing cloud costs and achieving significant savings through identifying inefficiencies.

• In collaboration with product manager, leveraged multi-dimensional digital marketing data to track and analyze traffic of 27 million monthly users across 15 countries who use Omio platform and its multi-mode travel search engine.
• Jointly developed with four member team cloud-based big data architecture with self-service dashboards using Data Studio visualization tool.
• Optimized Google BigQuery data structure by modelling denormalized data using nested and repeated records.

Key Accomplishments

Developed large-scale analytical data warehouse with over 100TB of data with streaming ETL pipeline that integrated AWS (Redshift, S3) and GCP (BigQuery, Dataproc, Data Studio) services.

• Implemented scalable data warehouse for multi-billion European e-commerce company, Zalando in collaboration with Technical Architect.
• "Product lifecycle management" data warehouse tracks over 100 million online orders, monitors merchandise product availability, and provides time-series analysis for stock availability and price tracking on AWS cloud infrastructure and Redshift.

Key Accomplishments
Developed real-time streaming data pipelines that enable instant product insights for 900+ million online visitors per quarter.

• Redesigned Smava's data warehouse architecture and built new data marts that support historical representation of loan offers provided to 300 million customers in collaboration with business analysts.
• Implemented Python and Pentaho integration solution for tracking Google Analytics AdWords campaigns and incorporating geospatial data into Marketing team's bidding strategy.

Key Accomplishments

The new data marts led to improve data coverage, completeness, and enhanced the accuracy of the credit scoring machine learning algorithm.

• Jointly developed with Product Owner and two developers Amazon Kinesis streaming application that integrated online sports betting platform with IBM digital marketing cloud using AWS, Spring Boot, and Java

Key Accomplishments
The real-time module for instant bonus credit to new users resulted in zero wait time for crediting the bonus rewards.

• Managed geospatial events management system correlating security incidents with UN peacekeeping patrols, providing decision aiding reports to UN Senior Leadership.
• Collaborated with stakeholders (Child Protection, Human Rights, Civil Affairs, and Police) to integrate data sources, improve report quality, and maintain data confidentiality.
• Created an offline version of the system for troops in conflict zones without internet connectivity.

Key Accomplishments

Executed mission-wide training program to improve data literacy skills of UN troops and received recognition from UN military coordinators.

• Collaborated with broad range of stakeholders in Logistics, Finance, Client Services, and HR to understand business needs, gather requirements and create operational reports and executive dashboards tracking performance against KPIs.
• Managed team of four IT contractors to ensure continuous development of BI solution using SQL Server data warehouse, SAP Business Objects, and Web Intelligence.
• Designed training program aimed at influencing stakeholders about scalability using SAP HANA's in-memory columnar data stores.

Key Accomplishments

Delivered self-service reports for UN RSC service lines, enabling them to present results-based budgeting framework to the UN steering committee.

• Designed & developed web-based process management system for 1,500 UN Volunteers, managing their administrative lifecycle from recruitment to repatriation.
• Managed & led team of two IT developers in expanding system deployment into two additional UN African missions and UNDP office and facilitated knowledge transfer and capacity building in the team.

Key Accomplishments

Improved UNV Support Project KPIs by 30% through system deployment and expansion, streamlining administrative processes and saving staff time.

• Developed web-based systems within budget and quality standards using PHP, ASP.NET, and MySQL databases.