IT Technician
Keywords
Skills
Swedbank, Scania, SQL, SSIS, BIML, BI, DW, ETL, Data Vault, Net, C#, Angular, SSAS, metadata, visual studio, PROGRAMMING, JavaScript, HTML, CSS, XML, JSON, Azure ML, GitHub, Git, SSRS, SSMS, Power BI, Visual Studio Code, IIS, JIRA, Confluence, TFS, Nuget, MSSQL, PostgreSQL, FRAMEWORKS, NodeJS, Entity Framework, jQuery, Razor, Core, Xamarin, Speaker Recognition, Google, Text, Fullcalendar, X3Dom, Bootstrap, Vault, Data Warehouse, Scrum, KanBan, CI, CD, RESTful, MVC, GDPR, MEAN Stack, Windows, Linux, iOS, Android, script, Tabular, web application, access rights, web api, UI design, web hosting, Angular material, C# and SQL script-tasks, database, XSD, bug fixes, PowerShell, PowerBI, Net Core, Angularjs, SSL Certifikat, SSIS packages, SQL code, debugging, bug fixing, data modeling, auto generate, speech to text, API, speech-to-text, HTML pages
Project history
09/2022
-
09/2022
help of the Microsoft.AnalysisServices.Tabular library in .Net.
RESULT: I created a C# script that automatically scans for changes between the
source table and the SSAS tabular model and then updates and redeploys the model
on the server. I inserted the script into an SSIS package which was deployed and
scheduled to be run automatically on the server.
This solution saved a lot of time which otherwise would have been spent in
manually updating the models.
TOOLS & TECHNIQUES: .NET, C#, SQL, SSIS, Tabular
RESULT: I created a C# script that automatically scans for changes between the
source table and the SSAS tabular model and then updates and redeploys the model
on the server. I inserted the script into an SSIS package which was deployed and
scheduled to be run automatically on the server.
This solution saved a lot of time which otherwise would have been spent in
manually updating the models.
TOOLS & TECHNIQUES: .NET, C#, SQL, SSIS, Tabular
02/2022
-
02/2022
BI Developer
ATOM
GOAL: The team was using SSAS tabular models fortheir reports and they had a
problem with the metadata of the source table being changed, for example when some
columns of the source table were removed, the tabular models could not be processed
and they had to manually rebuild the model in visual studio and redeploy it on the
server, which took a long time. They needed a solution to automaze the rebuilding and
redeployment of the tabular models .
RESOLVEMENT: In order to solve the problem, I started searching for an existing
tool that could do this task, but there were none to be found. After that I did some
searching and found some examples how this could be done using C# code, with the
problem with the metadata of the source table being changed, for example when some
columns of the source table were removed, the tabular models could not be processed
and they had to manually rebuild the model in visual studio and redeploy it on the
server, which took a long time. They needed a solution to automaze the rebuilding and
redeployment of the tabular models .
RESOLVEMENT: In order to solve the problem, I started searching for an existing
tool that could do this task, but there were none to be found. After that I did some
searching and found some examples how this could be done using C# code, with the
01/2019
-
12/2020
Maintenance
RESOLVEMENT
Project: Maintenance of the SODA system
Jan 2019- Dec 2020
Role: Maintenance
RESOLVEMENT: During my time as a part of the Maintenance team of the system, i
have been working with support cases and maintaining and doing optimisations of
functions in the system and also i worked with ETL flows to import data.
I have been fixing malfunctions of the system that have caused delay of sending out
important daily reports to customers, which sometimes required working at a high
pace and being able to find fast solutions which I have been able to accomplish. I
have been doing felsearching in SQL procedures and data to be able to find the
cause of discrepancies in customers' reports that they have complained about.
Another task that I had while working with maintenance was to do weekly releases
and deploy new code to the production environment.
I have also been a mentor to new colleagues and taught them how the system was
built.
TOOLS & TECHNIQUES: BI, ETL, Data Vault, Data Warehouse, C#, .Net, SSMS,
SQL, BIML, XML, SSIS, PowerShell, Scrum, GIT, JIRA, PowerBI, NodeJS, .Net Core,
Angularjs, CSS, HTML, IIS, SSL Certifikat
Jan 2019- Dec 2020
Role: Maintenance
RESOLVEMENT: During my time as a part of the Maintenance team of the system, i
have been working with support cases and maintaining and doing optimisations of
functions in the system and also i worked with ETL flows to import data.
I have been fixing malfunctions of the system that have caused delay of sending out
important daily reports to customers, which sometimes required working at a high
pace and being able to find fast solutions which I have been able to accomplish. I
have been doing felsearching in SQL procedures and data to be able to find the
cause of discrepancies in customers' reports that they have complained about.
Another task that I had while working with maintenance was to do weekly releases
and deploy new code to the production environment.
I have also been a mentor to new colleagues and taught them how the system was
built.
TOOLS & TECHNIQUES: BI, ETL, Data Vault, Data Warehouse, C#, .Net, SSMS,
SQL, BIML, XML, SSIS, PowerShell, Scrum, GIT, JIRA, PowerBI, NodeJS, .Net Core,
Angularjs, CSS, HTML, IIS, SSL Certifikat
08/2017
-
12/2020
BI Developer
Nordicstation
Nordicstation is a consultancy company that delivers IT solutions with a
main focus on banking and finance.
Aug 2017 - Dec 2020 (3.5 years)
main focus on banking and finance.
Aug 2017 - Dec 2020 (3.5 years)
04/2018
-
10/2018
Developer
Projekt
GOAL: To create a .csv file in EMT format, that contains costs of financial
instruments, for an internal use inside the organization.
RESOLVEMENT: The first step was to import the data and store it into the data
warehouse. To be able to do that I created SSIS packages that imported the data
from the files on the disk to the warehouse. After importing the data, I wrote a logic
and multiple rules with SQL code, to mapp all of the columns into an EMT format,
and load the data into the tables. The last step was to create a file on the disk with
EMT data from the tables, by using an SSIS package.
RESULT: The system was developed and deployed to the production environment
and the files were sent out daily to be consumed internally in the organization.
TOOLS & TECHNIQUES: BI, ETL, Data Vault, Data Warehouse, C#, SSIS, SSMS,
SQL, Biml, Git, JIRA
instruments, for an internal use inside the organization.
RESOLVEMENT: The first step was to import the data and store it into the data
warehouse. To be able to do that I created SSIS packages that imported the data
from the files on the disk to the warehouse. After importing the data, I wrote a logic
and multiple rules with SQL code, to mapp all of the columns into an EMT format,
and load the data into the tables. The last step was to create a file on the disk with
EMT data from the tables, by using an SSIS package.
RESULT: The system was developed and deployed to the production environment
and the files were sent out daily to be consumed internally in the organization.
TOOLS & TECHNIQUES: BI, ETL, Data Vault, Data Warehouse, C#, SSIS, SSMS,
SQL, Biml, Git, JIRA
02/2018
-
04/2018
Developer
Projekt: MIFID II 10% drop rule report
Feb 2018 - Apr 2018
Role: Developer
GOAL: To create a report that notifies the customer on a daily basis, if the value of
an instrument drops by 10% or more according to MIFID II directive.
RESOLVEMENT: After the requirements were specified, the developers started to
create tables in order to be able to import the data needed for the report, and wrote
code that does calculations to check if the market value of a certain instrument has
dropped by 10% or more. I have done debugging and bug fixing in the logic when
errores have occurred.
RESULT: The project was completed according to the deadline and the reports were
sent to the aƦected customers.
TOOLS & TECHNIQUES: BI, ETL, Data Vault, Data Warehouse, C#, SSIS, SSMS,
SQL, Biml, Git, JIRA
Feb 2018 - Apr 2018
Role: Developer
GOAL: To create a report that notifies the customer on a daily basis, if the value of
an instrument drops by 10% or more according to MIFID II directive.
RESOLVEMENT: After the requirements were specified, the developers started to
create tables in order to be able to import the data needed for the report, and wrote
code that does calculations to check if the market value of a certain instrument has
dropped by 10% or more. I have done debugging and bug fixing in the logic when
errores have occurred.
RESULT: The project was completed according to the deadline and the reports were
sent to the aƦected customers.
TOOLS & TECHNIQUES: BI, ETL, Data Vault, Data Warehouse, C#, SSIS, SSMS,
SQL, Biml, Git, JIRA
08/2017
-
02/2018
Developer
Projekt: MIFID II Costs & Charges Report
GOAL: To create Costs & Charges Report according to MIFID II directive, that
contains the costs and charges that the customer has paid under the reporting
period for investing in securities.
RESOLVEMENT: This was the first and most important project for the team, which
had a very short deadline. To be able to accomplish the job, it was required to work
at a fast pace and extra hours. The business analysts wrote a clear requirement
documentation and then the developers started to write the code. My tasks as a
developer were to create ETL flows by generating database objects and writing
procedures that loads data into diƦerent tables and does calculations and then
groups the data on a customer level, to be able to select all of the costs and charges
for a specific customer and then create an XML file and a PDF report.
RESULT: Disregarding the short deadline, we were able to deliver the reports in
time and received positive feedback.
TOOLS & TECHNIQUES: BI, ETL, Data Vault, Data Warehouse, C#, SSIS, SSMS,
SQL, Biml, Git, JIRA
contains the costs and charges that the customer has paid under the reporting
period for investing in securities.
RESOLVEMENT: This was the first and most important project for the team, which
had a very short deadline. To be able to accomplish the job, it was required to work
at a fast pace and extra hours. The business analysts wrote a clear requirement
documentation and then the developers started to write the code. My tasks as a
developer were to create ETL flows by generating database objects and writing
procedures that loads data into diƦerent tables and does calculations and then
groups the data on a customer level, to be able to select all of the costs and charges
for a specific customer and then create an XML file and a PDF report.
RESULT: Disregarding the short deadline, we were able to deliver the reports in
time and received positive feedback.
TOOLS & TECHNIQUES: BI, ETL, Data Vault, Data Warehouse, C#, SSIS, SSMS,
SQL, Biml, Git, JIRA
08/2017
-
12/2017
Developer
Project: Building a Data Warehouse
Aug 2017 - Dec 2017
Role: Developer
GOAL: To build a Data Warehouse by using the DataVault method and import and
save data from multiple systems.
RESOLVEMENT: In the beginning of the creation of the system, we needed to
import data from multiple systems in order to do calculations and create reports.
My tasks as a developer were to work with ETL flows by doing data modeling and
creating metadata specifications for data models which contained "Hub", "Link"
and "Satellite" tables with diƦerent relationships between them. We created
database objects and SSIS packages by using the tool BIML that can auto generate
with a single click, a script that creates multiple database objects simultaneously. I
wrote C# code in BIML files that creates database objects from metadata .csv files.
RESULT : The Data Warehouse is the main part of the system and saves new data on
a daily basis. The system is stable and built in a smart way with multiple
constraints, in order to be able to detect problems in the data such as duplicates, as
soon as possible.
TOOLS & TECHNIQUES: BI, ETL, Data Vault, Data Warehouse, C#, SSIS, SSMS,
SQL, Biml
Aug 2017 - Dec 2017
Role: Developer
GOAL: To build a Data Warehouse by using the DataVault method and import and
save data from multiple systems.
RESOLVEMENT: In the beginning of the creation of the system, we needed to
import data from multiple systems in order to do calculations and create reports.
My tasks as a developer were to work with ETL flows by doing data modeling and
creating metadata specifications for data models which contained "Hub", "Link"
and "Satellite" tables with diƦerent relationships between them. We created
database objects and SSIS packages by using the tool BIML that can auto generate
with a single click, a script that creates multiple database objects simultaneously. I
wrote C# code in BIML files that creates database objects from metadata .csv files.
RESULT : The Data Warehouse is the main part of the system and saves new data on
a daily basis. The system is stable and built in a smart way with multiple
constraints, in order to be able to detect problems in the data such as duplicates, as
soon as possible.
TOOLS & TECHNIQUES: BI, ETL, Data Vault, Data Warehouse, C#, SSIS, SSMS,
SQL, Biml
01/2017
-
06/2017
Full Stack developer
Seavus
Seavus offers advanced consultancy services with expertise in
Management & IT.
Jan 2017 - Jun 2017 (6 months)
Management & IT.
Jan 2017 - Jun 2017 (6 months)
01/2017
-
06/2017
Developer (Intern)
PowWow
GOAL: To build a POC for an online conference system that can automatically create
documentation, by converting speech to text and auto generate a brief conclusion.
RESOLVEMENT: For this POC, I developed an API using .Net, and I used Google's
speech-to-text API to be able to convert speech to text and save the conversation
during the meeting into a text document on the disc. I have also been using
Microsoft's Speaker Recognition API for recognising the voice of the speaker and
printing out their name before every sentence in the text that was being saved in
the document. As a client I have developed an Android app with Xamarin.
RESULT : The project for creating a POC was developed successfully, but there was
much work left to be done in order to be able to create an app for daily use.
TOOLS & TECHNIQUES: .Net, MVC, C#, API, JavaScript, HTML, CSS, Speaker
Recognition, Google Speech-to-Text
documentation, by converting speech to text and auto generate a brief conclusion.
RESOLVEMENT: For this POC, I developed an API using .Net, and I used Google's
speech-to-text API to be able to convert speech to text and save the conversation
during the meeting into a text document on the disc. I have also been using
Microsoft's Speaker Recognition API for recognising the voice of the speaker and
printing out their name before every sentence in the text that was being saved in
the document. As a client I have developed an Android app with Xamarin.
RESULT : The project for creating a POC was developed successfully, but there was
much work left to be done in order to be able to create an app for daily use.
TOOLS & TECHNIQUES: .Net, MVC, C#, API, JavaScript, HTML, CSS, Speaker
Recognition, Google Speech-to-Text
03/2016
-
05/2016
Full Stack developer
Itancan
Itancan is a consultancy company for IT-Systems, development and devops.
Mar 2016 - May 2016 (2 months)
Mar 2016 - May 2016 (2 months)
03/2016
-
05/2016
Developer (Intern)
Roll
RESOLVEMENT: During my time as an Intern at Itancan, i have had tasks such as:
to write JavaScript code for implementation of Scheduler plugin to a FullCalendar
project. I have also been working on creating a support for 3D objects to be shown
in HTML pages, by using x3Dom.
to write JavaScript code for implementation of Scheduler plugin to a FullCalendar
project. I have also been working on creating a support for 3D objects to be shown
in HTML pages, by using x3Dom.
Local Availability
Open to travel worldwide
