My main activities were to develop datasets and visualisations using Power BI (M and DAX included). Additional tasks include to perform Business and Data Analysis to find the correct data sources, scripting queries using T-SQL, Hive and Impala to feed the datasets, facing internal customers to gather their requirements and data needs, also, helping my team with the creation of internal processes. Recently, as part of the Big Data project, I’ve been learning Python to manage and maintain the data migration from SQL Server on-premises sources to Hive and Kudu tables in Cloudera.
Part of my activities also include maintaining and creating SSIS ETL packages/jobs and maintain legacy Data Stage ETL jobs.
Visualisations with Power BI, Project estimations, Business and Data Analysis, Business Processes design and diagramming.
Impala SQL, SharePoint, SQL Server, DAX, SSIS, Confluence, MS Teams, Cognos, Data Stage, Python.