Eric Leroy's Email Addresses & Phone Numbers

Eric is a focused and motivated Business Intelligence Specialist with 13 years of experience in Online Gaming, Consulting, Telecom, Pharma and Manufacturing. His strong management and technical skills have provided him with the flexibility to operate as a Project Lead, Architect or Senior Developer in an Enterprise Data Warehousing environment. He has significant experience in working with...

Eric is a focused and motivated Business Intelligence Specialist with 13 years of experience in Online Gaming, Consulting, Telecom, Pharma and Manufacturing. His strong management and technical skills have provided him with the flexibility to operate as a Project Lead, Architect or Senior Developer in an Enterprise Data Warehousing environment. He has significant experience in working with stakeholders, capturing business requirements and following through with BI solutions providing deep insight into the customer's complex source systems. He has strong experience working alongside or leading onshore (UK, Ireland & Belgium) and offshore (Russia, India & Philippines) development teams. Eric has developed innovative datamarts, semantic layers, KPI reporting, dashboards and multidimensional analysis on various BI platforms in new and migration projects. He has good time management and organisational skills, works well as part of a team and integrates easily at any level. Education : - Master of Science in Industrial Engineering – Option Informatics – ECAM - SAP BI Certified Professional (BOCP) Enterprise - SAP BI UDT/IDT Accredited - SAP BI Desktop & Web Intelligence Accredited Tools : - Universe Design Tool (BO5 to SAP BI4.1) - Information Design Tool (SAP BI4.1) - Web Intelligence (BO5 to SAP BI4.1) - Crystal Reports (CR9 to SAP BI4.1) - Desktop Intelligence (BO5 to XIR2) - Xcelsius/SAP Dashboards (4.5 to SAP BI4.1) - SAP Design Studio 1.5 - SAP BI Server (From BO XI 3.1) : Planning, Implementation, Migration & Lifecycle Management - Development of SAP BI Auditing capabilities - SDK Scripting using .COM/.NET (VB/VBA) & Java (Eclipse) libraries - Tableau Desktop & Tableau Desktop 9.1BI Consultant @ As a member of the BI team Eric is responsible for the architecture of the SAP BI solution. He plans and performs all related activities from migrations & upgrades to security model creation & reviews. He interfaces with business stakeholders, mentors colleagues, provides knowledge transfer and trains business users while developing Enterprise Business Intelligence and reporting strategies. Main responsibilities : • Datawarehouse design using dimensional modelling (Kimball methods) • Requirements gathering, technical design and reporting solutions implementation • SAP BI Platform architecture : Security Model, Content Management, Lifecycle management (Version Management, Promotion Management & Disaster recovery strategy) • Creation of user friendly universes on Oracle relational database and cubes • Report & Dashboard creation using Web Intelligence, Crystal Reports, Xcelsius/SAP Dashboards covering data from all business departments : marketing, affiliates, customer support, web optimisation, fraud, eComm & products • Migrations : from SAP BI3.1 to SAP BI4.1, from IBM DB2 to Oracle warehouse • Internal team coaching on SAP BI product (universe design, reporting, server administration, server maintenance, etc.) • End user training on Web Intelligence for self-service reporting • Creation of SAP BI SDK scripts for repetitive tasks automation (distribution list updates, permissions updates, connection updates, SQL query extracts, etc.) • Creation of a highly customized BI Portal on SAP BI Launchpad • Development of proofs of concept based on real business scenarios : SAP Design Studio 1.5 prototype using fragments & SAP BI Mobile • SAP BI Server : Installation, Upgrades, SSO setup & Auditing capabilities • Advanced SQL : analytical functions & optimisation Technical environment : - SAP BI 4.1 (Universe Design Tool, Information Design Tool, Web Intelligence, CMC, Crystal Reports, SAP Dashboards, SAP Design Studio, Auditor) - Oracle 11g - Pentaho Data Integration 5.3 From January 2013 to Present (2 years 11 months) London, United KingdomBI Project Manager @ As a member of the Client Engagement team, Eric was responsible for the follow-up of diverse BI projects – being the interface between local business units and Global IT. Main responsibilities: - Planning - Requirements gathering - Technical design documents review - SIT/Pre-UAT/UAT facilitation - Deployment follow-up - BI / SAP BO Advisory role Main projects he was involved in : - EG Factbook : Creation of solution providing consolidated data from different sources using the Microstrategy software suite. - McDonalds Spain : Migration from Oracle Express platform to Microsoft SSAS + SAP BO 3.1 platform - Business Plan / Rolling Estimates : Sunset intermediary legacy systems by implementing a solution to extract, transform and load data from SAP to the corporate datawarehouse. From October 2011 to December 2012 (1 year 3 months) Brussels Area, BelgiumBI Lead @ Deloitte Consulting has a strong reputation and track record as Business Performance Consultants. The practice is a recognized leader in helping clients solve complex business problems, differentiated by their ability to execute on the advice they provide. From September 2011 to December 2012 (1 year 4 months) Brussels Area, BelgiumSAP BusinessObjects Specialist @ As a member of the CIMI team Eric’s main role was to provide business with solutions to improve the way the BI solution MICA was implemented - 3 axis : general datawarehouse design, universe design & reporting. Main responsibilities: - BI / SAP BO Advisory role - SAP BO Development MICA project - tasks he was involved in : - BO Universe audit / BO Webi good practices - Development of a Proof Of Concepts to migrate VBA application generating lists of contacts to Webi. - Development of a marketing campaign funnel report From September 2011 to February 2012 (6 months) Brussels Area, BelgiumSenior BI Engineer @ Tasks: Marketing Oriented Datawarehouse Design BO XI3.1 Universe Design & Audit BO XI3.1 Java & Rich Webi reports development BO XI3.1 Server Installation & Configuration BO XIR2 to XI3.1 Migration - Content plan design & implementation BO XI3.1 Server Maintenance, Support & Optimization BO XI3.1 End Users Training (Designer & Webi) BO XI3.1 Custom JSP development using the BOE Java SDK New BO products (labs) Evaluation SAP Licensing Management SQL Server 2005 Transact-SQL (T-SQL) stored procedures development Technical environment: BO XI3.1 Designer BO XI3.1 Webi Java & Rich Client BO XI3.1 CMC, CCM, Auditor, BIAR exp/imp Apache & Tomcat 5.5 SQL Server 2005 Multi Browser From November 2008 to July 2011 (2 years 9 months) BI Engineer @ From December 2006 to October 2008 (1 year 11 months) IrelandBI Engineer @ Tasks: BO Technical Lead BO XIR2 Dashboards Design, Development and Deployment Universe and Report automatic generation using SDK Universe Design Deski and Webi reports development Estimates for BO developments Technical writings (Requirements and specifications) BO XIR2 Server Installation (Linux RHEL4 & Solaris 10) BO Training and Support New technologies prototyping (Xcelsius, QAAWS, Live Office, ...) Technical environment: BO XIR2 (Designer, Webi, Deski, CMS) BO XIR2 Performance Management BO XIR2 Platforms : Microsoft, Linux RHEL4 & Solaris 10 BO XIR2 Auditor Business Objects 5 – 6.5 (Designer, Full Client, Supervisor) Visual Basic & BO SDK's Oracle PL/SQL Oracle Developer Large Telecom companies From December 2006 to October 2008 (1 year 11 months) IrelandBI Consultant @ Analyst-Developer on a datawarehouse project with Oracle PL/SQL and TIBCO (and/or BODI) as ETL ; Business Objects FC and Webi Reports for data presentation. Skills : Business Objects Designer 6.5, Business Objects 6.5 (Full-Client and Webi), PL/SQL, GxP environment From April 2006 to December 2006 (9 months) BI Consultant @ From March 2006 to December 2006 (10 months) IT Consultant @ From December 2004 to March 2006 (1 year 4 months) Lims Analyst @ Oracle tester/integrator, Crystal Reports developer and support/maintenance team member for validated LIMS (Laboratory Information Management Systems) applications. Skills : advanced SQL, PL/SQL and Crystal Reports ; total quality approach ; usage of Business Objects, SAP, Documentum and ARS Remedy. From December 2004 to March 2006 (1 year 4 months) Analyst-developer @ Oracle analyst-developer and industrial applications support team member for automatic handling and production monitoring systems. Skills : advanced SQL, PL/SQL, Forms 9i, Reports 9i, TOAD, DB design, SGML languages (like XML, SVG, etc.), javascript, Vax /Alpha DCL. From 2002 to 2004 (2 years) Master of Science in Industrial Engineering, Electronics and Informatics @ From 1998 to 2002 Latin-Mathématique @ Collège Saint-Pierre d'Uccle From 1991 to 1997 Eric Leroy is skilled in: Web Intelligence, Data Warehousing, Business Objects, PL/SQL, Crystal Reports, SQL Server, Business Intelligence, T-SQL, Data Modeling, ETL, Database Design, Oracle SQL, SQL, Databases, Visual Basic