Philippe - Architecte SQL SERVER

PresentCompany:
NRB, Network Research BelgiumClient: FSMA (Brussels).Client Domain: Financial Services and Market AuthorityMission: System Engineer.The FSMA implementsnetworksand applicationssecurity as the firstpriority. In order to do so, I am involved in all Web Firewall (F5 ASM / LTM), Microsoft ThreatGateway(TMG), Unified Access Gateway (UAG),Network access control (NAC). They also authenticates external users using certificate authentication (X509) using the Microsoft UAG linked to AD LDS.My role is to understand the needs and propose, implement, documentsolutions in collaboration with theexternal services provider NRB. Technologies:F5 (ASM/LTM), TMG/UAG, X509, IIS (with encryption), Active Directory (AD DS/AD LDS), Kerberos, ArchiMate

2013/2018(5 Years)Company: BEEP.Client: BNP PARIBAS Fortis(Brussels).Client Domain: Capital MarketApplication DeliveryMission: SolutionsArchitect.
-Objective was to moveBelgian infrastructure and applications from Brussels data centreto Paris data centre,minimize service disruptionand verify (adapt) application compliancy with Security best practises and BNPP environment rules.-CreateMiFIDII (European regulation)multi-tiersolution based on Microsoft product. The main objective was to collectfinancial productsknowledge and experiencefrom client representativesand generate suitability assessment prior dealing with client.-Create interfaces with external Web Site provider in order toautomaticallypublish regulation document to BNPP client (worked with Cloud provider on Sitefinity Solution interface).
-Manage GDPR regulation application transformation
-Make sure security aspects of expected solutions (access, authentication mechanism, rights management, encryption...)
-Migration Middleware solution based on IBM WebSphere Message Broker 7 and Oracle 11 toIBM Integration Bus 9 and Oracle 12.Technologies:Web(Apache, Tomcat, IIS), Infrastructure and Application Virtualisation(Citrix + VMWare vSphere). Microsoft BI suite (SQL Server 2014, SharePoint2013, SSIS, SSAS, SSRS)IBM WebSphere, Oracle, Windows Server 2012R2, RHEL branch 7,Microsoft Entity Data Framework, MVC, IIS ARRDomain:Capital Market.

2011/2013(3 Years)Company: BEEP.Client: BNP PARIBASFortis(Brussels).Client Domain: IT Capital Market SupportMission: ApplicationEngineer.
-E-Commerceproject support, Solution improvement, Deployment automation using WebSphere Jython API.Manage up to 20 RedHat Enterprise Linux servers including WebSphere, Tibco rollout and management.F5 load balancing and IBM WAFwere used to expose application on the internet public network.Oracle 11g development (including privileges administration).
-Microsoft BI for Retail and Private Banking activity deep analysisforprojectbased on SSIS, SSAS and SharePoint 2010 Microsoft Technologies.
-Clarityv12(Company Financials assets management) from Computer Associate.Technologies:WebSphereApplication Server7, Microsoft BI (SQL Server2008 R2, SSRS, SSIS, SSAS,Microsoft SharePoint 2010), CA Clarity (BO XI, Oracle 11g,WebLogic),Windows Server2008 R2, Linux RedHat(branch 6)Domain:Capital Market, DWH BI.

2010/2011(8 months)Company: BEEP.Client: BICS(Belgacom International Carrier Services).Client Domain: TelecomServices provider
Mission: DWH DevelopmentEngineer.
-Versioning and release management automation.
-Data warehousingusing Teradataas backendwith BTEQ client(Huge Billing CDR inflow). -Informaticaworkflowdevelopment-Manage Business Object reports
-Implement Operational reporting. Technologies:Linux RedHat(branch 5), Windows 2003, SharePoint2007, BOXI, Teradata BTEQ scripting, Informatica ETL.Domain:DWH BI Operational.

2008/ 2010(2 years and 3 months)Company: BEEP.Client: BNP PARIBAS Fortis(Brussels).Client Domain: Bankingand tradingMission: Solution Engineer(Information Servicessupport)-Problem management. Audit, report and implement solutions to improve software and architecture. Manage post incident reports and tasks, actions to prevent incidentsaccording to ITIL process.-Design and implement businessmonitoring solutionto improve visibility on business activities, and increase IT service management pro-activity.The function required cross platforms and business capabilities.
-BNP Paribas Fortis integration project, objective was to join technologiesand applications.Technologies:ITIL,Windows Server environment, Desktop virtualisation (Citrix).Applications deployment using WebSphere, reporting using BOXI, Clarity (CA),databases Oracle10gand SQL Serverdevelopments, MQ Seriesfor applications messaging.UNIX and Windows scripting for products integration. Process flow scheduling using ControlMproduct.Nagiosmonitoring solution.Domain:Operational.

2003/2008(5 Years)Company: VOLT Europe.Client: Proximus(Belgian Telecom Leader)Brussels.Client Domain: TELECOM
Mission: Data Management ArchitectImprove developmentand deployment ofoperational and businesssupportsystem(OSS/BSS). Reporting solution on top of an in house product. Serviceoriented architecture for the development of distributed systems toCentralize semi-realtime datafrom network's components.
Drive systemsdesign and architecture
Managelifecyclesandensure the solution meets the business requirements.
Relationship withoffshore company(conference calls, documents and requirements).
Training sessionsfor end users and offshore support.
Manage all modificationsbring by equipment and software provider:
products roadmapand build change report
impact analysis
System migration
Environment management. Prepare all environment requirements, based on ITIL recommendationsand software evolution, mainly on Oracleand Sun Solaris products.The function requires capabilities to understand technical concepts and environment of Telecom, manage release calendar and scope definitions, plan deliverablesand provide clear achievement information.Technologies:ITIL, SAS, internal tools, Oracle SGBD 10g development, Perl and UNIX shell scripting
Domain: Data Warehouse(including CDR, Network configuration and performance data), Network mediation(EventLinkMediation device), ETLusing Perland OracleSGBD, KeyProcess Indicators and reports definition.

1998/2003(5 Years)Company: STERIA.Client: Proximus(Belgian Telecom Leader)Brussels.Client Domain: TELECOMMission: Telecom Software Engineer.
Telco Network Modelcreation (NGOSS) of 2Gnetwork.
Data migrationand integration.
Test environmentsmanagement and acceptance test / code review
Improve oracle scripts performance. Implementversioncontrol system (cvsbased) in order to produce a high quality in delivery.
Provide a Daily comparison (dump compare) of these data with the live data.
Performance metric collection application, as extensibleinformation and data model todescribe network management information, and network usage to optimize network components deployment.
Test scenariosin order to verify that all business requirementsare reached.
RFQ writing and Offer writing, Products roadmap, Software Company Partnership,
Product Change Request,Environment management, System analysis, test and integration.Technologies:UNIX Scripting, OracleDatabase (DDL, DML)Domain: Capacity management, performancemetricsand configuration management.

1998Company: ARIANE II.Client:Swiss Life (Insurance Company) Brussels.Client Domain:INSURANCE.Mission:Software Engineer.
Work on application to manage insurance contracts
Report about End user requirements and build development functional areaTechnologies:MS Office developer package.Domain:Insurance contracts management.

1998Company:ELVA.Client Domain:Automobile industry Welding HardwareMission:Test and ImplementationEngineer
Project study, demonstrations and setup.
Evaluate technical capabilities of welding equipment to optimize car light glasses manufacture. It wasactually made using central heating and the objective was to find an electro-magnetic solution in order to optimize the heating period (reduce it, and reduce preparation work)
Visit Renault automobile major client research site.

1997Company: SEFAR FYLTIS.Function Held:Conception and automation responsible.Client Domain:Technical Textile and Chemical research for industrial filtration.Mission:Conception Manager
Project study, product follow-up
Production system improvement.The objective was to migrate from manual cutting system to an informatics air laser cutting system.
Find a textile weld system.Actual solution was industrial sewing, the mission was to rebuild the conception in order to use thermal welding system.Hardware:PC, AS400, Lectra Technologies