Microsoft Senior Database Administrator, Database developer, Business Intelligence Developper and Application Developer in a wide variety of business applications. Certified MCSA SQL Server 2012. Specialized in Multi-dimensional (OLAP) databases, Microsoft Integration Services specialist and ETL workflow builder. Microsoft SSIS, Reporting Services(SSRS) and Analysis Services (SSAS) designer. Microsoft Certified Solution Associate(MCSA), Microsoft Certified System Engineer (MCSE), Microsoft Technology Associate (MTA) (Database Fundamentals), I am preparing the MCSE Business Intelligence. Solid experiences in implementing and maintaining replication database processes (Microsoft SQL Servers). Strong experiences in building and designing Microsoft OLAP Cubes (Analysis Services), using MDX queries, KPIs and security layers by user groups among the cubes. Now familiar with the Microsoft BI Tool suite including Power BI and Power Query. Particularly interested in either relational or multidimensional database designs, business analysis and performances using Microsoft SQL server tools including PowerBI, SSDT and SQL2014. Misc: MCSA, MTA, MCP and MCSE (Microsoft Certified System Engineer) Expert SSIS, SSRS & SSAS Database modeling (Normal Forms, Merise, DataVolt), Database development, Database Administration, security and performances. T-SQL, MDX, .NET, C#, PowerShell, VBA

Senior Microsoft BI Consultant @ In the context of the implementation of SuccessFactors (an SAP Cloud solution to manage Human Resources), the centralization of the institution's delegations data (>80 countries) requires the design and the implementation of some ETL workflows. The Microsoft Integration Services (SSIS) is the key. My experience, skills and certifications are in used to handle this and to lead that mission to success. From November 2015 to Present (2 months) Geneva Area, SwitzerlandMCSA SQL Server 2012 Trainee @ Now certified MCSA SQL Server 2012 after passed successfully the following exams: - 70-461 Querying Microsoft SQL Server 2012 (SQL Development) - 70-462 Administering Microsoft SQL Server 2012 Databases ( DBA SQL Server 2012) - 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 (SSIS, SSAS, MDM & DQS) From September 2015 to November 2015 (3 months) Lausanne Area, SwitzerlandSpécialiste en informatique décisionnelle - Business Intelligence Specialist @ - Analyze and collaborate in framing needs in relation with IT entities and / or business - Identify and manage the impacts related to the establishment and evolution of the decision-making system - Write functional specifications on the various BI applications - Contribute, being engine of proposals, to changes in the decision-making system and the rise of skills entire team - Provide vision on clean tools and techniques to BI and contribute to the technology watch From May 2015 to July 2015 (3 months) Geneva Area, SwitzerlandSenior SQL Developer and Database Support @ As a senior associate and as a Microsoft SQL Server Database Specialist (Administration & Development), creating, maintaining and supporting the existing SQL code, the SSIS Packages and the Reporting Services reports. In charge of supporting, maintaining, enhancing and developing SQL Servers from the ETL tasks (SSIS) to the reporting tasks (SSRS). These activities cover from the database server maintenance and administration to the performances improvements. In addition to that, the key is upgrading the existing system to new technologies, developing new automated processes to increase the performance and offer a better level of usage to our users. Also in charge of building technical solution for any new automated data exchange with customers. From September 2010 to March 2015 (4 years 7 months) Lausanne Area, SwitzerlandBusiness Intelligence Senior Consultant @ As a SQL 2005/2008 Business Intelligence Developer, in charge of developing and implementing the POS Scanning project from the ETL part (MS SSIS) to the reporting part (MS SSAS), in charge of migrating Data Stage 7.5 Data Flows to MS SSIS on the production servers for several projects (VISTA, SMDL, iWRL, W2R). Using all environments (Dev, QA and PROD), in charge of improving the resource consumption, maintaining and optimizing data flows and data results within some PMSA Business Units. On a daily basis, I acted for several projects, to plan its development, tests and deployments. In the context of a specific project, I was in charge of the development and the implementation in production of its pilot version, from the ETL to the OLAP part, managing the relationship with a PMSA customer & data provider, designing the transactional and multi-dimensional database structures with its integration in the existing production environment. I was also in charged of the OLAP and cube designs and maintenance, with the cooperation of both the Sales Information department and the Trade Marketing department. As an Microsoft SSIS expert, I was in charge of the workflow and packages design/development in the IBM Ascential Datastage migration context. From January 2008 to August 2010 (2 years 8 months) Lausanne Area, SwitzerlandSQL2005 Senior Database Administrator @ Securing the 2005 SQL data using impersonalization. Migrating objects such as users or Stored Procedures, Table-Functions and views from SQL servers to others. From October 2007 to October 2007 (1 month) Geneva Area, SwitzerlandBusiness Intelligence Senior Consultant & DBA @ Business intelligence consultant working on the Swatch Group Head quarter projects for reporting such as Key Portal Indicators (KPI) and Investment and Controlling System (ICS). From June 2007 to September 2007 (4 months) Lausanne Area, SwitzerlandSystem Engineer & Ground Segment Integration Tester @ In charge of planning, organizing and performing the ground segment application software, reporting failures and bugs in the integration environment shared by dedicated flight applications. I worked as contracted employee From November 2006 to May 2007 (7 months) Toulouse Area, FranceSystem Engineer & Oracle Developper @ Remedy HelpDesk 4.0 designer, trainer and developer. Oracle 9i & 10g for Solaris developer. Alcatel Problem Management specialist. I worked as contracted employee From May 2005 to October 2006 (1 year 6 months) Toulouse Area, FranceSQL DBA - Analysis Services Consultant - SQL & VB6 Development Engineer @ Project « Cultural Efficient Business ”: www.gfk-ceb.com DBA SQL Server 2000 & Analysis Services 2000. Database Model Analysis & OLAP cube designer, VB6 developer and solution builder for the IT department. Handling marketing data and figures regarding the cultural products (Books, DVDs, CDs, Video Tapes…) From May 2002 to April 2005 (3 years) Paris Area, FranceSystem Engineer & BI consultant (Self-Employed) @ System Engineer, Application Developer & BI Consultant From January 2002 to April 2002 (4 months) Paris Area, FranceSupport Engineer @ Development Support Engineer and Team Manager From October 1998 to December 2001 (3 years 3 months) Paris Area, FranceTechnician Support @ FranceNet / MicroNet Technician support for email and web access (routeurs/modem). FranceNet, then Fluxus is integrated to British Telecom(BT) From February 1998 to October 1998 (9 months) Paris Area, FranceFreight Employee @ Sales assistant From 1994 to 1996 (2 years) Paris Area, France

Olivier T. is skilled in: Microsoft SQL Server, SQL Server, ETL, SQL, SSIS, Databases, SSRS, Integration, Database Administration, OLAP, SSAS, Business Analysis, Unix, SQL Server 2000-2008, Software Project Management