David - Assistant à maîtrise d'ouvrage MICROSOFT BI

Database and BI Architect at Optix
April 2014 - Present (2 years 1 month)
• Technical Manager of software development teams in Paris and Jerusalem.
• Integration between ERP - CRM - SharePoint with a Master Data central repository
• Extensive BI solutions design and implementation (SSIS, SSAS, Sharepoint,PerformancePoint, Power BI, Mobile Reporting).
• Definition of company standards and best practices.
• Comprehensive database management and migration from SQL old versions to SQL Server 2014/2016; monitoring with SQL Sentry.
• Developed synchronisation SSIS and C# jobs between ERP system (SAGE Adonis) and Microsoft CRM2013.
• Expertise in Microsoft CRM 2013, SharePoint 2013 and Performance Point 2013.

Technical Team Leader and Lead Developer at TO
2010 - July 2013 (3 years)
• Designed the data architecture of TraceOne’s e-Collaborative Solutions for Retailers and Manufacturers.
Technologies: Microsoft Visual Studio 2010 and 2012 and ERwin 9.2.
•Developed and administered Business Intelligence and Reporting Systems including complex replication mechanism and clustering environment. Technologies: SQL Server 2008 and 2012, Integration Service, Analysis Services, Reporting Services and integration with QlikView within Visual Studio C# .NET.

Senior Consultant at BNP Paribas
March 2007 - 2010 (3 years)
• QA Manager for top French Bank Teradata CRM system.
• Assisted top management in the business requirement definition for multi-channel banking, campaign management and mailing systems.
• Provided expertise to support the database functional and technical requirements definition and integration projects
between the Italian and French IT departments.

Self-employed at Freelance
January 2006 - March 2007 (1 year 3 months)
• Designed and developed integration software between DB2 host system and departmental Microsoft SQL
Server environment. Technologies: VB.NET, SQL Server 2005, Integration Services and Host Integration
Services
• Expert on large Business Intelligence and Reporting projects.
• Production support for cluster, disaster recovery and back up strategies and for monitoring, profiling and fine tuning mission critical system.
Technologies: NLB, Microsoft Clustering, EMC2 SAN environment.

Senior Consultant - Engagement Manager (Rome) at Microsoft
March 1999 - December 2005 (6 years 10 months)
• SQL Server Product Specialist (versions 6.5, 7.0, 2000 and 2005).
• Designed and developed SQL Server database centric solutions and Business Intelligence solutions for the Italian public administration and major financial institutions.
• Development projects for the Italian Police and Military Intelligence in C# and VB.NET.
• Frequent missions to Microsoft HQ (Redmond, Seattle).
• Pre-Sales activities.
• Technical trainer and Knowledge manager (Microsoft award).

Senior Scientist at NATO C3 Agency
March 1991 - February 1999 (8 years)
• Head of internal software development branch and Agency Data Administrator.
• Developed databasecentric systems for military operations: Joint Operations-INTEL Information System (JOIIS), Common Operational Picture (COP) and GIS systems and helped deploy these systems in Bosnia and Herzegovina
(NATO peacekeeping force missions).
• Defined the business and functional requirements of the NATO Military Response Options and NATO Precautionary Measures project within the Partnership for Peace (PfP) Programme.
• Developed an Ingres database system for military satellite (SATCOM) and Line-of-Sight NATO communication systems.
• Official Agency IT trainer.
• Won several awards.
• Technologies: SQL Server 4.2, Ingres, MS Access, Visual Basic 5.0 and MapInfo GIS system.

Software Engineer at SEMA Group
November 1989 - February 1991 (1 year 4 months)
• COBOL software developments, Data General and Wang minicomputer systems. Several missions for key
customers: European Commission, Solvay, C.B.R. (Cimenteries Belges Réunies). Frequent missions to Saint
Gobain - Paris (France).