Business Intelligence Consultant

I'm part of a TME Enterprise Architecture (EA) team called Business Intelligence
Competence Center (BICC). Our mission is to set and maintain BI standards, best
practices, governance, ... at the enterprise level. We must be able to understand the
needs of project teams as well as end-users and support them on creating effective
solutions.

My activities at BICC:
* Define Data & BI standards and guidelines for TME and NMSCs (pan-
European affiliates companies);
* Understand the business requirements and strategy;

* Create and maintain BI documentation on collaboration platforms within
TME (SharePoint, Microsoft Teams, Confluence);

* Coordinate BI activities between business and IT teams, including NMSCs;
* Help create architectural BI product roadmaps;
* Collaborate with other IT teams (O365, DBA, Cloud) to establish governance,
data reliance and infrastructure standards;
* Maintain communication with BI project teams (incl. external vendors);
* Lead the Power BI community within TME; supporting people on developing
their BI reports, share tips and tricks or monthly PBI updates, and organise trainings of
external parties.


My main responsibilities are:
* Help teams gather requirements on data projects, share standards and good
practices, and publish documentation;
* Develop enterprise reference architecture and roadmaps;
* Coach and guide solution developers and key users;
* Reach consensus on the proposed solutions within EA and IT development
teams;
* Explain the technology direction to a technical audience;
* Help a non-technical audience (e.g. executives) understand complex issues.


Next to my role at the BICC, I'm part of a development team for a PAN-E project. In this
project there are several smaller projects. My main role is to support, develop, and
follow up. (Data analysis, ETL, SQL, SSAS, data modelling (Kimball)).


Technologies: SQL Server, SSAS, Azure Data Factory, Digazu, Power BI, Azure platform,
Bamboo

Euroclear is a Belgium-based financial services company that specializes in the
settlement of securities transactions as well as the safekeeping and asset servicing of
these securities. It was founded in 1968 as part of J.P. Morgan & Co. to settle trades on
the then developing Eurobond market.


Within Euroclear I completed 2 projects.




On his first project where I was onboarded to develop a Power BI dashboard that
would convince higher management to work with Power BI. The dashboard was
created with call center data. I've imported the data from different SQL Server
databases, transformed the data in Power BI using Power Query and DAX, created the
data model, and set up the default lay-out for future reports.


As I was the only person on this project, all required steps (feedback, requirements
gathering, implementation, ...) was all done by myself.


In second assignment I was part of an internal project team, with the goal to create a
Datawarehouse of operational metrics. These metrics contained data from the
mainframes, current workstations (are all devices updated to a support version?),
reviewing the access management (does this user have the correct accesses to access
this source?, ...), and tickets from ServiceNow.

My main goal was to develop reports with Power BI (DAX - Power Query -
Visualizations), analyse the data, discuss automatic feeding with data owners/ ETL
team, assist in the Power BI Server setup, developing in SQL Server (creation of tables,
views, ..), UML Data modelling (Kimball), PowerShell scripting, and researching new
ways to automate the data.


Technologies: Power BI, Powershell, SQL Server