Philippe Camus

Delivering high‑quality results on competitive fixed‑price engagements. - Data, BI and SQL expert - Full‑stack Drupal development - IT troubleshooting and support Current external engagement: Integrated Reporting Solutions Engineer for UNHCR - Designed and delivered self‑service semantic models that empowered end‑users to access operational data instantly, eliminating reliance on slow, resource‑heavy reports

Results Data Portal (RDP). PowerBI solution designed to deliver reports and analytics based on UNHCR's Results Management application (COMPASS) and ERP data. • Directed migration of RDP to a dedicated Azure subscription, ensuring compliance and zero downtime. Azure Data Factory, Azure SQL database, Analysis services, DevOps, CI/CD • Redesigned data models and reports to accommodate COMPASS indicator rebuild, mitigating impact on 10+ reports. • Developed QA dashboards for mid-year and year-end review exercises, enhancing reporting accuracy and collaboration across regional bureaus. • Managed service providers and filled critical technical gaps, ensuring uninterrupted delivery of BI solutions.

Global Focus website, UNHCR’s main operational reporting portal for donors and other key partners. https://reporting.unhcr.org/ • Delivered the full redesign of UNHCR’s donor reporting portal, and launched on time for the Global Appeal and pledging conference. • Ensured uninterrupted donor access to financial, operational, population, and results data. • Integrated upstream systems via API connections (RBM, ERP, population datasets, maps). • Migrated the platform from Drupal 7 to Drupal 9, modernized architecture • Developed custom D3.js visualizations and dashboards. • Implemented Active Directory authentication and strengthened security, • Ensured platform reliability by monitoring APIs, databases, and servers, and coordinating with IT, business divisions, and external providers.

Oversight of Global Focus website, the main UNHCR's operational information portal for donors (http://reporting.unhcr.org). Liaison role between business and technical teams. Business analysis, technical feasibility studies

May 2007 - April 2015: UNHCR Result Based Management software for planning, budgeting & monitoring UNHCR operations - Release Management & QA (dealing with offshore teams) - Technical leader & architect of the BI portal & synchronization solution - Business & Technical analysis - Data Modeling, - Troubleshooting, 3rd level support Technical env: IBM Cognos (Framework Manager, Report Studio, ..), Microsoft BI, Oracle, Sybase ASA, Java, Hibernate, Swing May - Dec 2006 : JPMorgan Design of a generic workflow engine Technical environment: .Net, C#, Sybase Jan-Apr 2007: www.naadge.com Design & development of an online agenda solution (appointments, resource planning, ...) - Application architecture (Datamodel, Authentication, ...) - Design of Persistence framework - User & Custom Web Controls development Jan 2004 - Dec 2005: JPMorgan Design & Implementation of various applications and underlying framework (Due dilligence, CRM, Trading modules). Visual Basic 6, ActiveX, COM, Sybase 12, Transact SQL, Java, .Net, Active Reports

Audit du système d’information du service des amarrages. Stabilisation de l’application et optimisation de procédures. Mise en conformité avec le framework J2EE du CTI (Struts & EJB). Environment Technique : Java, JSP/Servlet, J2EE framework, XML, XSL, Oracle 8i, Tomcat, Jbuilder, Junit

Integration of W4 workflow tool to Generali’s information system. - Development of the interface between W4 and business applications - Process analysis Development of automated procedures for unit & functional testing Technical Environment : Java, Oracle 8i, W4, Jbuilder, Tomcat Apache, JUnit, Rational Rose, Dreamweaver, UNIX

Analysis, design and implementation of Unit Trust Processor (UTP) application: Unit trust distributions setup, client position calculation and trade processing to Olympic system. Stored procedures optimization Client Reporting Technical Environment : Visual Basic 5 & 6, Sybase 11, Transact-SQL, UNIX

Unpaid management application •Analysis and development of the application •Development of technical and business components Technical Environment : Delphi, Interbase, UNIX, Powerhouse (Cognos), VIPP (Xerox)

Abel Enterprise software accounting • Application maintenance (correction & evolution) • Maintenance of development framework (Centura) and depreciation calculation module (dll written in C) Technical Environment : Centura, Visual C++, C, SQL Base, Oracle, SQL Server

Cantonal Agronomy Laboratory (LCA). • Analysis and development of ground analysis and meteorological applications Fishing permits application • Analysis and development of the application • BVR edition • Statistical reports Technical Environment : Visual Basic 5, Crystal Report, Oracle 7, PL/SQL

Abel Enterprise (accounting software) Technical Environment : Centura, Visual C++, C, SQL Base, Oracle, SQL Server