Sebastien Boyer
Technical consultant / SQL Dev at Capital Banking Solutions- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
-
Français -
Topline Score
Bio
Credentials
-
Advanced SQL for Query Tuning and Performance Optimization
LinkedInAug, 2020- Sep, 2024 -
SQL Server Integration Services
LinkedInAug, 2020- Sep, 2024 -
SQL Tips, Tricks, & Techniques
LinkedInAug, 2020- Sep, 2024 -
Installing SQL Server 2012
LinkedInJul, 2020- Sep, 2024 -
Querying Microsoft SQL Server 2012
LinkedInJul, 2020- Sep, 2024 -
SAS Base Certified Programer
SASJul, 2015- Sep, 2024 -
MOOC ABC de la gestion de projet - Ecole Centrale de Lille
Ecole Centrale de LilleFeb, 2014- Sep, 2024
Experience
-
Capital Banking Solutions
-
France
-
Technology, Information and Internet
-
200 - 300 Employee
-
Technical consultant / SQL Dev
-
Sep 2020 - Present
▪Assume technical implementation of our solutions locally and/or at our customers' sites:o Installation / technical setupo Functional setupo Customization of the solution for the customer▪ Reporting / dashboards▪ Calculation / accounting methods▪ In/Out interfacing with external applicationso Assistance / support on site or remotelyo Documentation / testingo Technical follow-up of projects under the responsibility of a project manager. ▪Assume technical implementation of our solutions locally and/or at our customers' sites:o Installation / technical setupo Functional setupo Customization of the solution for the customer▪ Reporting / dashboards▪ Calculation / accounting methods▪ In/Out interfacing with external applicationso Assistance / support on site or remotelyo Documentation / testingo Technical follow-up of projects under the responsibility of a project manager.
-
-
-
UBS
-
Switzerland
-
Financial Services
-
700 & Above Employee
-
BI Analyst Developer
-
Mar 2018 - Mar 2020
Development : - Lead Developer on several regulatory projects (GDPR Data Portability & DSAR) data projects (Smartview). - Data selection and extraction in Oracle databases (SQL queries & views). - Development in Informatica Power Center (Mappings, transformations and workflows). - Creation and maintenance of Business Object report. - Experience in development in an agile environmentStrategy : - Member of the core team in the data management project (Reorganization of the Staging area and Datawarehouse, Data quality, Data Lineage). - Analysis of the data impact linked to a major update of the CRM. - Structural updates of the data dictionary to include business meta data and data lineage.
-
-
-
EURIMPEX M.D.D.
-
Monaco
-
Wholesale Import and Export
-
1 - 100 Employee
-
IT Manager / BI Analyst Developer
-
Jun 2015 - Nov 2017
Shape tomorrow : Define the strategic orientation of our information system- IT lead and member of the steering committee in the replacement of the enterprise resource planning (ERP) software (drafting of the Internal specification, review and analysis of tender answers)- Creation of a corporate intranet using MS SharePoint. Development of web-based applications hosted on the intranet.- Transformation of the existing reporting system into a modern business intelligence using SAS Visual Analytics- Focus on network and security improvement (External Audit, implementation of a recovery plan) .Manage today : Be accountable of the all IT Activities- Member of the Eurimpex MDD Board of management- Plan and give priorities for IT projects- Development and maintenance of our internal applications- Network and security management- Day-to-day assistance to end user. Definition and implementation of a helpdesk tickets system (using GLPI – OCS inventory) to improve customer satisfaction.- IT purchases and budget management- Relationship with our IT suppliers (contract management and contract negotiation, technical follow-up). Development:- SAS - SAS enterprise guide - SAS Visual Analytics (SAS certification)- SQL server – SQL queries- SharePoint (intranet portal + internal application) – C# Webservice- Visual Basic 6 and VBA Network and security:- Network management of 27 virtual servers including domain controller, DNS, Exchange server, print server, Wsus server …- Active directory management , backup (VEEAM) , firewall (Watchguard), antispam server (Pineapp)- Telecom system management (autocom siemens hipath 3000)
-
-
Analyst Programmer
-
Jun 2015 - Nov 2015
- SQL - SAS Programming - Visual Basic- Developpement & automatisation, followup and maintenance of process & software- Network administration ( Active directory , Virtual server, backup, firewall, antispam server)-
-
-
-
SBM Offshore
-
Netherlands
-
Oil and Gas
-
700 & Above Employee
-
Planning Engineer
-
Feb 2012 - May 2015
SingleBuoy Mooring – From 01/12 - Planning Engineer- Management & Follow up swivel stack construction planning (Planning level III of 800-1000 activities).- Management & Follow up construction planning of Mechanical parts: Bogies et Chain stopper (Planning level III of 400-700 activities).- Creation & follow up of the workload capacity forecast of the department directly link to our planning- Creation & follow up of the workload capacity of specific equipment of our main suppliers.
-
-
Vendor Document Controler
-
Aug 2008 - Feb 2012
2008 to 2012 - Vendor Document Controller - SBM Offshore (Oil & Gas):- Vendor documentation management following specific requirements of both our quality system and specific needs of the client. - Follow up and management of internal software (eCDR – eDMS).- Development of IT tools to improve productivity by automatizing specific tasks- Update of HSSE supplier data (« Health, Safety, Security, and Environmental »).- Creation & follow up of the workload capacity of specific equipment of our main suppliers
-
-
Hotline / Helpdesk
-
Aug 2003 - Aug 2008
2003 to 2008 - Hotline / Helpdesk - SBM Offshore (Oil & Gas):- Understand & diagnose user needs- Hotline et direct support (250 users per technician).- Preparation & installation of new computer with Norton Ghost- Installation & maintenance of specific software- IT purchases management- Information System Maintenance (Databases FoxPro & SQL)- Specification of a customer satisfaction survey sent randomly during work orders creation- Specification of an application allowing user to record directly tickets on the corporate intranet system
-
-
IT Coordinator
-
Aug 2002 - Aug 2003
2002 to 2003 - IT Coordinator - SBM Offshore (Oil & Gas):- IT coordination on projects (Creation of new project in Information System, User Access rights on corporateintranet system)- Technical Specification and follow up for internal IT software (Ex: document management system)- Information System Maintenance (Databases FoxPro & SQL)
-
-
-
A.C.T.U
-
United States
-
Non-profit Organizations
-
1 - 100 Employee
-
IT Coordinator
-
Feb 2002 - Aug 2002
2002 to 2002 - IT Coordinator - A.C.T.U (French Administration):- Management of the request coming from user of the software Civitas (Town hall administration)- Coordination of future update with the editor- Web site update 2002 to 2002 - IT Coordinator - A.C.T.U (French Administration):- Management of the request coming from user of the software Civitas (Town hall administration)- Coordination of future update with the editor- Web site update
-
-
-
Groupe Fournier
-
IT Services and IT Consulting
-
IT Support Technician
-
Jun 2001 - Jan 2002
2001 to 2002 - IT Technician - Groupe Fournier (4th French pharmaceutical company):- Direct IT Support to user- Creation of standard workstation for each department and deployment by cloning the master- Installation & maintenance of specific software- Installation et configuration of network printer 2001 to 2002 - IT Technician - Groupe Fournier (4th French pharmaceutical company):- Direct IT Support to user- Creation of standard workstation for each department and deployment by cloning the master- Installation & maintenance of specific software- Installation et configuration of network printer
-
-
Education
-
1999 - 2001
Saint begnigne
BTS Informatique et Gestion, Option Développement -
1995 - 1998
Désiré Nisart
BAC Scientifique
Community
