Sammy Deprez

BI Consultant

Converting data into information since 2009

Visit my blog

Personal Profile

About me

Born in 1988 and since then always been fascinated by technology. Studied Electronics in high school. But finished school with 3 years computer science.

As a small kid I always enjoyed travelling, and until now this is still on my todo list every year.

European, Asian or African, all kinds of food have been prepared in my kitchen.

Always having a good eye for well designed products.

Personal Interests

When not at work:

  • I love to travel
  • I spend time with my family
  • I watch a movie
  • I love to cook
  • I like to do some graphical design

Contact

Mobile Phone: +32 494 86 09 30
Skype: sammydeprez
Website: www.sammydeprez.be
Email: Contact Page
Social Networks:

Technical Skills

Operating Systems

80%

Microsoft

60%

OSX

Programming Languages

60%

VB.net

70%

C#

Development/Design Tools

80%

Microsoft Visual Studio
(2005 and higher)

60%

Microsoft Visio

70%

Visual Paradigm

Database Management Systems

85%

Microsoft SQL Server
(2005 and higher)
SSIS, SSAS, SSRS

50%

Oracle

Other

85%

Apache

85%

HTML

70%

CSS

60%

PHP

75%

ASP.NET

Functional Skills

Social

  • Always ready to give someone a hand when necessary
  • A good communicator

Administrative

  • Order in documents and correctness is a must, not only digital but also in real life

Technical

  • 1 year experience in FS data model and client tools.
  • 5 years of experience in developing & designing ETL loads & reports
  • Developing user friendly systems with some eye candy as extra

Language Skills

100%

Dutch

85%

English

50%

French

Work Experience

BI Developer

HealthcareReportingCompliance

Responsibilities

  • Development & Design
  • SSIS ETL Packages
  • Cube Modifications with DAX
  • Query performance tuning
  • Release management
  • Scopings aanmaken + opvolging

Projects

  • Hospital Intelligence
    • Development & Design of ETL (SSIS)
    • Development & Design of Cube (SSAS, DAX)
  • MZG (Minimum Healthcare Data)
    • Development & Design of ETL (SSIS)
    • Development & Design of Cube (SSAS, DAX)
Period: June 2014 - Present

Technical Consultant

FinanceReportingCompliance

Responsibilities

  • Development & Design
  • SSIS ETL Packages
  • Reports with SSRS
  • Query performance tuning
  • Release management

Projects

  • DnB Bank (Vilnius, Lithuania)
    • Technical support for functional consultants
    • Dependency of IFRS processes
    • Migration of WKFS software
    • On-site Support
  • Dnb Bank (Riga, Latvia)
    • EURO Conversion
  • Internal Project (Vienna, Austria)
    • Testing of Compliance Software
  • Bank of China (Brussels, Belgium)
    • Software Migration
  • BKCP Bank (Brussels, Belgium)
    • Updating set of reports
Period: November 2012 - May 2014

BI Consultant

DatawarehousingReportingETL

Responsibilities

  • Development & Design
  • SSIS ETL Packages
  • Reports with LogiXML
  • Query performance tuning
  • ETL performance tuning

Projects

  • Hospital Intelligence (Internal Project)
    • Development & Design of ETL (SSIS)
    • Development & Design of Cube (SSAS)
    • Development of Reports (LogiXML)
  • Recupel vzw
    • Analysis, Design & Development of Master Database for CRM application
    • Design of data model with Visual Paradigm
    • Programming of web services on DB with C#
  • Mega Group Trading
    • Analysis of ETL Performance problem with a specific fact table load
    • Adjustments to SSAS Cube & ETL Load to fix performance problem and adding measures
Period: September 2009 - November 2012

Internship

Ministry of Education IT DepartmentNairobiKenya
Internship as a final project to get my degree in Applied Computer Science.
During this 4-month internship, I developed a webportal for the Ministry of Education
This experience enhanced my analysis and communication skills.
Period: Feb 2009 - May 2009

Education & Certificates

Mastering DAX

SQLBI
Training

Graduated: 2015

Lean Six Sigma White Belt

Wolters Kluwer
1 hour training

Graduated: 2014

PRINCE2 Foundation

Wolters Kluwer
1 week training and certification

Graduated: 2014

Dynamic CRM 2011

Eduvision
Installation, Configuration & Customization

Graduated: 2011

Business Intelligence

Computer Solutions NV (iDeeds), Harelbeke, Belgium
An inhouse training given by my employer at that time, my first steps into the BI world, a new world that opened. Data warehousing, Cognos, SSIS, SSAS, SSRS

Graduated: 2009

Bachelor Of Applied Computer Science

Howest, University College West Flanders, Belgium
My first step to become an IT specialist. Learning how to analyse, configure and manage both computers and networks. Designing IT structures, create and manage databases, program computers, set up web applications, ...

Graduated: 2009

Recommendations

"Sammy is a very talented developer, who has quickly acquired a lot of experience in developing complex BI solutions. He is very creative in finding working technical solutions for the most diverse functional requirements. (February 3, 2013)"
Ivan Vanhaverbeke (Functional Analyst - Project Manager at Computer Solutions)
"Sammy is a well-versed BI consultant with whom it was a pleasure to work. He is quick on the uptake, both from the aspect of the business case as from the aspect of finding a suitable technical approach to deliver new solutions."
Steve Decroubele (Project Leader & Analyst at Computer Solutions)
"Sammy was very diligent and detail oriented in his work and always followed through in all projects he was involved with. He was always sharp, cheerful and eager to assist in any project."

Let's get in touch