$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
1
jobs
DHW/BI Developer
Justinas Mockus
,
Vilnius, Lithuania
Experience
Other titles
Skills
I'm offering
• Around 8 years' experience in Database Design, Development and maintenance of database applications on SQL 2008 R2 - 2016 in OLTP/OLAP/BI environment.
• As part of the team, extensively involved through the Software Development Life Cycle from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Expertise in developing complex stored procedures.
• Experience in designing ETL data flows using SSIS; creating packages to extract data from various databases, flat files, XMLs.
• Experience in creating SQL Server jobs, SQL Mail Agent, schedule DTS/SSIS Packages.
• Experience in creating Ad hoc reports and reports for BI analysis.
• Experience in developing Drill-down, Drill-through And Cascading reports SSRS reports using MDX on cubes or OLTP databases.
• Experience working in an Agile Scrum teams.
• Completed 7 out of 10 Johns Hopkins University "Data Science" R language base courses on Coursera platform http://*****.***)
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• As part of the team, extensively involved through the Software Development Life Cycle from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Expertise in developing complex stored procedures.
• Experience in designing ETL data flows using SSIS; creating packages to extract data from various databases, flat files, XMLs.
• Experience in creating SQL Server jobs, SQL Mail Agent, schedule DTS/SSIS Packages.
• Experience in creating Ad hoc reports and reports for BI analysis.
• Experience in developing Drill-down, Drill-through And Cascading reports SSRS reports using MDX on cubes or OLTP databases.
• Experience working in an Agile Scrum teams.
• Completed 7 out of 10 Johns Hopkins University "Data Science" R language base courses on Coursera platform http://*****.***)
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
Markets
United Kingdom
(Remote
only)
France
(Remote
only)
Germany
(Remote
only)
Lithuania
Denmark
(Remote
only)
Norway
(Remote
only)
Sweden
(Remote
only)
Finland
(Remote
only)
Links for more
Once you have created a company account and a job, you can access the profiles links.
Industries
Language
English
Fluently
Lithuanian
Fluently
Ready for
Available
My experience
2019 - 2020
freelance
Business Intelligence Consultant
Luminor.
Business Intelligence developer for ECB Comprehensive Assessment (Asset Quality Review and Stress Testing) directive at Luminor Bank.
• Consolidating historical data from a various Oracle and MS SQL Server data warehouses to one
common MS SQL Server data warehouse for ECB launched Asset Quality Review programme.
• Analyzing business logic, fixing data quality issues, committing created code to SVN
• Consolidating historical data from a various Oracle and MS SQL Server data warehouses to one
common MS SQL Server data warehouse for ECB launched Asset Quality Review programme.
• Analyzing business logic, fixing data quality issues, committing created code to SVN
Pl/sql, T-SQL, Stored procedures, MS SQL Server, ETL, Business Intelligence, Data Warehouse, Data Analysis
2018 - 2019
job
BI DEVELOPER
AB "Danske Bank".
Danske Bank is a Northern Europe region bank, which operates in 16 countries where it provides services
for 3,4 million private, business and institutional clients.
My functions:
• ETL development using SSIS 2012/2016 from various sources (SQL Server, DB2, flat files etc.)
• Source control via TFS and RedGate tools.
• Continuous Integration and Continuous Deployment via TFS.
• Data analysis.
• Dashboard and report development.
• Report creation using SSRS 2012/2016 and Tableu.
• Cube development and MDX.
• Main responsibility is delivery of tasks related to extracting, transforming and loading the data to the central data warehouse, and further make it available for various business applications.
• Using Agile/Scrum software development methodology and working as an Agile team member.
Tools and skills used:
• MS SQL Server 2016, T-SQL, SSRS, SSIS, SSAS, Tableu, RedGate tools, Visio, TFS.
for 3,4 million private, business and institutional clients.
My functions:
• ETL development using SSIS 2012/2016 from various sources (SQL Server, DB2, flat files etc.)
• Source control via TFS and RedGate tools.
• Continuous Integration and Continuous Deployment via TFS.
• Data analysis.
• Dashboard and report development.
• Report creation using SSRS 2012/2016 and Tableu.
• Cube development and MDX.
• Main responsibility is delivery of tasks related to extracting, transforming and loading the data to the central data warehouse, and further make it available for various business applications.
• Using Agile/Scrum software development methodology and working as an Agile team member.
Tools and skills used:
• MS SQL Server 2016, T-SQL, SSRS, SSIS, SSAS, Tableu, RedGate tools, Visio, TFS.
Ssis, MDX, Continuous deployment, Sql server 2016, Continuous integration, Server, BEE, Software, Development, SSAS, TFS, Developer, It, SSRS, Sql, T-SQL, Visio, Integration, DB2, ETL, Data Warehouse, Deployment, Agile, Software development, SQL Server, Scrum, Data Analysis
2016 - 2017
job
ETL DEVELOPER
SKANDINAVISKA ENSKILDA BANKEN.
SEB is a Swedish financial group for corporate customers, institutions and private individuals with headquarters in Stockholm. Its activities comprise mainly banking services, but SEB also carries out significant life
insurance operations.
My functions:
• Develop and support the BI ETL solutions utilizing Informatica tool.
• Main responsibility is delivery of tasks related to extracting, transforming and loading the data to the central data warehouse, and further make it available for various business applications.
• Using Agile/Scrum software development methodology and working as an Agile team member.
Tools and skills used:
• Informatica, Oracle PL/SQL, Erwin, Data Vault 2.0 concept knowledge.
insurance operations.
My functions:
• Develop and support the BI ETL solutions utilizing Informatica tool.
• Main responsibility is delivery of tasks related to extracting, transforming and loading the data to the central data warehouse, and further make it available for various business applications.
• Using Agile/Scrum software development methodology and working as an Agile team member.
Tools and skills used:
• Informatica, Oracle PL/SQL, Erwin, Data Vault 2.0 concept knowledge.
Banking, Oracle PL/SQL, BEE, Insurance, Software, Development, Support, Developer, It, Sql, Pl/sql, ETL, Data Warehouse, Agile, Software development, Operations, Oracle, Scrum
2011 - 2016
job
DATABASE ENGINEER / SCRUM MASTER
UAB "MARKMONITOR".
LT
UAB "MarkMonitor"- leading international anti-piracy company, providing piracy tracking and prevention services, working with biggest copyright holders.
My functions:
• Extract, transform, and load (ETL) data from various source systems to the data warehouse covering
a variety of technical scenarios encountered in the construction of complex data warehousing
solutions, including T-SQL, SSIS, and other data manipulation tools within the Microsoft Suite of Products.
• Designing and developing BI / Reporting solutions using SSRS.
• Implement changes to reporting, warehouse, MDX Queries, and other components of the BI path.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC)
from initial planning through implementation of the projects. Capable of handling responsibilities
independently as well as a proactive team member.
Tools and skills used:
• MS SQL Server 2008 R2/2014/2016, T-SQL, SSRS, SSIS, SSAS, SQL Server R Services.
Scrum master responsibilities:
• Facilitating the daily standup.
• Helping the team maintain their burndown chart.
• Setting up retrospectives, sprint reviews or sprint planning sessions.
• Shielding the team from interruptions during the sprint.
UAB "MarkMonitor"- leading international anti-piracy company, providing piracy tracking and prevention services, working with biggest copyright holders.
My functions:
• Extract, transform, and load (ETL) data from various source systems to the data warehouse covering
a variety of technical scenarios encountered in the construction of complex data warehousing
solutions, including T-SQL, SSIS, and other data manipulation tools within the Microsoft Suite of Products.
• Designing and developing BI / Reporting solutions using SSRS.
• Implement changes to reporting, warehouse, MDX Queries, and other components of the BI path.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC)
from initial planning through implementation of the projects. Capable of handling responsibilities
independently as well as a proactive team member.
Tools and skills used:
• MS SQL Server 2008 R2/2014/2016, T-SQL, SSRS, SSIS, SSAS, SQL Server R Services.
Scrum master responsibilities:
• Facilitating the daily standup.
• Helping the team maintain their burndown chart.
• Setting up retrospectives, sprint reviews or sprint planning sessions.
• Shielding the team from interruptions during the sprint.
SSRS, UP, Sql server 2008, MDX, Planning, International, Server, BEE, Software, Development, SSAS, Implementation, Sql, Ssis, T-SQL, ETL, Data Warehouse, Database, R, Software development, Scrum master, SQL Server, Scrum
My education
2014
-
2016
VILNIUS GEDIMINAS TECHNICS UNIVERSITY
Masters, Data mining technologies
Masters, Data mining technologies
describes how data mining model was created, which is solving a task of P2P data classification. A goal of the
model is to filter out data, which is not useful for further processing. Model creation was based on CRISP-DM
data mining methodology. In the project were used data and text mining technologies. For model training and
testing were used data collected from P2P networks. It was developed using SSIS data mining tools, T-SQL stored
procedures, SQL Server R Services.
2007
-
2011
VILNIUS GEDIMINAS TECHNICS UNIVERSITY
Bachelors, Engineering informatics
Bachelors, Engineering informatics
• Pure mathematics.
• Basics of databases.
• Computer aided graphics
Justinas' reviews
Justinas has not received any reviews on Worksome.
Contact Justinas Mockus
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Justinas directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark