FRANCK LUGAND

– Program Lead - Counterparty Data Management & KYC Transformation – Led the Counterparty Data Management transformation program, covering KYC, Credit Risk and Master Data Management. – Managed the replatforming of the KYC solution, ensuring regulatory compliance and scalability. – Drove the replatforming of the credit request and credit approval workflow, improving efficiency and governance. – Designed and implemented a Master Data Management (MDM) solution to centralize counterparty data and enforce data uniqueness, consistency and data quality. – Defined and implemented an event-driven architecture leveraging a message bus to distribute counterparty data across enterprise systems in near real-time. – Led end-to-end project delivery using Agile methodology, including backlog management, sprint planning, delivery tracking and reporting via Azure DevOps. – Coordinated cross-functional stakeholders (Credit, Compliance, IT, Business teams) through regular governance and follow-up meetings to ensure alignment with business and regulatory requirements.

– IT Project Manager – E-commerce & ERP Integration (Microsoft Business Central) – Led an E-commerce platform redesign project, including the implementation of an Enterprise Service Bus (ESB) to support scalable system integration. – Designed and delivered data integration flows between Microsoft Dynamics 365 Business Central and the E-commerce platform using API-based and event-driven integrations. – Managed end-to-end project delivery, including project planning, budget definition, milestones tracking and risk management. – Conducted business requirements analysis and produced functional and technical specifications. – Led and coordinated a development team of 4 developers, ensuring delivery quality, timelines and alignment with technical standards. – Acted as the main point of contact for all stakeholders: executive management, business sponsors, business units, infrastructure teams, developers and external vendors. – Ensured governance, reporting and communication throughout the project lifecycle. – Technical environment: Microsoft Azure (Logic Apps, Data Factory), REST APIs, SQL Server, Power BI, DevOps, Microsoft Dynamics 365 Business Central

– Data Specialist - Core Banking & Risk Reporting Migration – Contributed to the core banking system migration for Société Générale, transitioning from Olympic to S2i. – Led the inventory and analysis of existing Risk and Credit Administration reporting, supporting migration to the S2i Data Warehouse (DWH). – Conducted business requirements analysis with key users from Risk and Credit departments. – Produced functional and technical specifications in collaboration with business teams and S2i functional experts. – Developed SQL Server data models and data sources on the DWH Data Hub. – Designed and delivered reports and dashboards using the Suadeo data visualization and data integration platform. – Performed non-regression testing on legacy reporting and led User Acceptance Testing (UAT) with business stakeholders to validate migrated reports. – Technical environment: Core Banking System S2i, Data Warehouse (Data Hub), SQL Server, Suadeo

– Senior Data Analyst & Project Manager – BI Platform Migration (CIB & Wealth Management) – Served as Project Manager for the migration of the bank's Business Intelligence reporting platform from SAP BusinessObjects BOXI 3.1 to BI 4.2. – Acted as Functional Lead and Lead Developer for the CIB (Corporate & Investment Banking) domain within the Data Solutions department. – Defined target architecture, migration activities, project planning, resource allocation and budget tracking; produced project governance and documentation. – Led business requirements analysis and reporting inventory with key users across CIB and Wealth Management departments. – Managed User Acceptance Testing (UAT) and ensured alignment between business requirements and delivered BI solutions. – Designed and developed dashboards and analytical reports using SAP BusinessObjects, Tableau and Power BI. – Modeled and implemented data warehouse enhancements, integrating new data sources and supporting evolving analytical use cases. – Collaborated with multiple banking business units to deliver data-driven insights supporting decision-making. – Technical environment: SAP BusinessObjects (BOXI 3.1, BI 4.2), Tableau, Power BI, Oracle, SQL Server

– Treasury & Trading Operating Officer – Middle Office – Provided functional support to Trading Floor and Treasury activities within the Middle Office, acting as a key interface between Front Office and control functions. – Delivered data analysis and reporting for multiple trading desks (FX, Equities, Fixed Income, Structured Products) and senior management. – Designed and developed Tableau dashboards to monitor trading activity, P&L drivers and operational metrics. – Ensured data reconciliation between trade booking systems, order execution platforms and the core banking system. – Led cross-departmental projects involving Front Office, Operations, Risk, Compliance, Legal, Finance, Asset Management and Client Management. – Acted as primary contact for regulatory audits, including FINMA and Swiss National Bank (SNB). – Managed market data subscriptions and access rights for traders (Bloomberg, Reuters) and controlled access to markets and financial instruments. – Technical environment: Tableau, Oracle, Sybase, Talend, Core Banking System ATLAS, Kondor+, Sungard GL Trade, Bloomberg, Reuters

– BI & Data Warehouse Analyst / Developer – Analyst and Developer within the Data Solutions team, supporting Wealth Management and Asset Management activities. – Contributed to the design, development and support of BI and Data Warehouse solutions for business users. – Implemented and administered SAP BusinessObjects BI and Talend ETL platforms. – Defined development standards and best practices for BI and ETL developers. – Developed BusinessObjects Universes and reports to support analytical and reporting needs across departments. – Led the migration of the SAP BusinessObjects BOXI R2 platform to BOXI 3.1. – Analyzed data integration requirements and participated in the selection and rollout of ETL tools. – Technical environment: SAP BusinessObjects, Talend, SSIS, Oracle, Sybase, SQL Server

– BI Consultant – QlikView & Reporting Solutions (Multiple Clients) – Delivered Business Intelligence and data visualization solutions for multiple clients across Insurance, Pharmaceuticals, Energy, Public Sector and Retail industries. – Designed and developed QlikView dashboards for Finance, Sales, Management, Marketing, Purchasing and Accounting departments. – Built BI solutions on top of heterogeneous data sources, including Oracle E-Business Suite, SQL Server and DB2. – Managed data extraction, transformation and loading (ETL) and scheduled data refresh using QlikView Publisher. – Designed and implemented advanced reports using SAP BusinessObjects. – Led a QlikView Proof of Concept (PoC) for a client within a 5-day delivery timeframe, demonstrating rapid value creation. – Acted as Project Manager on selected assignments, including workload estimation, budget tracking and delivery monitoring. – Installed and configured QlikView Server, including user access management and data reload scheduling. – Key client engagements: ECA (Insurance – Lausanne): BI dashboards using Oracle E-Business Suite; QlikView Publisher scheduling; SAP BO advanced reporting. Solvay (Pharmaceuticals – Basel): Sales performance dashboards in QlikView. WTO (International Organization – Geneva): Financial dashboards based on Oracle E-Business Suite. Tamoil (Oil & Energy - Geneva): QlikView dashboards and project management (workload vs budget). Néopost (Industrial Systems – Zurich): Rapid QlikView PoC on SQL Server data. Urech (Retail / Jewelry - Neuchâtel): Management and marketing dashboards; QlikView Server 8.5 installation and scheduling. – Technical environment: QlikView, SAP BusinessObjects, Windows Server 2008, SQL Server 2008, Oracle 11g, DB2, Oracle Applications

– BI Consultant – KPI & Dashboard Delivery (Multi-sector Clients) – Delivered Business Intelligence projects for clients across multiple industries, covering project management, business requirements analysis and analytics delivery. – Led needs analysis with key business users to define KPIs and reporting requirements. – Designed and implemented Data Warehouses and Data Marts, supporting structured and scalable analytics. – Developed interactive dashboards and KPI reporting using Qlik data visualization solutions. – Ensured data consistency and reliability across Oracle and SQL Server data sources. – Collaborated closely with business stakeholders to deliver actionable insights and decision-support tools. – Technical environment: Qlik, SAP BusinessObjects, Oracle, SQL Server

– IT Manager - ERP Implementation & IT Infrastructure (SME / PMI) – Served as IT Manager, responsible for the overall IT landscape, including applications, ERP implementation and infrastructure management. – Conducted IT and application audits covering Purchasing, Production, Sales and CRM processes. – Led business requirements gathering with key users and produced functional specifications. – Managed the implementation of the SilverCS ERP, including data migration from legacy systems. – Designed and delivered operational and management reports for all business departments. – Implemented EDI integrations with major retail partners, improving operational efficiency and data exchange reliability. – Acted as the primary interface between business teams, vendors and IT service providers. – Technical environment: SilverCS ERP, COBOL, Crystal Reports

– IT Manager - Digital Solutions & Event Operations (SME / Events Industry) – Served as IT Manager for an events-focused SME, responsible for the design, development and operation of digital solutions supporting sports events. – Designed and developed a sports event management application, including participant registration and RFID-based timing, using Visual Basic. – Developed the company website, integrating event presentation, online registration and online payment capabilities. – Delivered on-site IT operations during events, ensuring system availability, data reliability and real-time performance. – Produced operational reports to support event monitoring and post-event analysis. – Acted as the primary IT contact for event organizers and operational teams. – Technical environment: Visual Basic, SQL Server, Crystal Reports, PHP, Javascript