Sander Laasik, Developer in Tallinn, Estonia
Sander is available for hire
Hire Sander

Sander Laasik

Verified Expert  in Engineering

Software Developer

Tallinn, Estonia

Toptal member since June 18, 2020

Bio

Sander has a master's degree in computer science and a seven-year career in Swedbank as a data warehouse developer and system analyst. He has been described as a top professional with a mindset for transforming data into business value. He's an expert in writing complex SQL in major RDBMS' and their PL extensions. Database modeling is also his passion. Recently, Sander has added MSSQL Server and Power BI to his skill set.

Portfolio

Softwerk OÜ
Microsoft Power BI, SQL Server Reporting Services (SSRS)...
Registat Solutions OÜ
Angular, Spring Boot, Java, PostgreSQL
Swedbank Estonia AS
Informatica PowerCenter, Teradata, Oracle RDBMS, Oracle Data Integrator (ODI)

Experience

  • Oracle Data Integrator (ODI) - 7 years
  • SQL - 7 years
  • Teradata Databases - 7 years
  • ETL Implementation & Design - 7 years
  • XML - 5 years
  • Database Modeling - 5 years
  • PostgreSQL 10 - 4 years
  • Informatica PowerCenter - 3 years

Availability

Part-time

Preferred Environment

Oracle SQL Developer, Git, Windows

The most amazing...

...project I've completed was the implementation of a business-critical service in a leading bank in the Nordics.

Work Experience

Business Intelligence Developer

2019 - 2020
Softwerk OÜ
  • Oversaw the data analysis.
  • Spearheaded the database modeling and implementation (Microsoft SQL Server).
  • Designed and implemented ETL processes (SQL Server Integration Services).
  • Implementing OLAP cubes (SQL Server Analysis Services).
  • Created BI visual reports and dashboards (Power BI).
Technologies: Microsoft Power BI, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Microsoft SQL Server

Full-stack Developer

2018 - 2019
Registat Solutions OÜ
  • Designed and implemented the database model and created the needed procedures (PostgreSQL, PL/pgSQL) for manipulating the data.
  • Took over a back end that was running on Java (SpringBoot) and successfully delivered the assigned tasks.
  • Programming frontend using Angular framework.
Technologies: Angular, Spring Boot, Java, PostgreSQL

Software Developer

2013 - 2018
Swedbank Estonia AS
  • Performed business requirements analysis for a wide range of data warehouse projects.
  • Designed the data models for the projects.
  • Planned and proposed the architecture for the projects.
  • Developed the database objects needed for the projects.
  • Built the ETL components for the projects.
  • Supported the maintenance team in the production environment.
Technologies: Informatica PowerCenter, Teradata, Oracle RDBMS, Oracle Data Integrator (ODI)

Software Quality Engineer

2011 - 2013
Swedbank Estonia AS
  • Tested different software components in the pre-production test environment and provided a report about the quality.
  • Validated data quality in Oracle and Teradata databases.
  • Ensured data integrity in Oracle and Teradata databases.
  • Tested ETL processes using Oracle Data Integrator.
  • Enhanced testing tools to support automation of testing.
Technologies: Oracle RDBMS, Oracle Data Integrator (ODI), Teradata

Experience

AML ETL Implementation

I had to really push myself in this project in order to learn all the tools, processes, and ways of working and coping with database objects and data written in a foreign (non-English) language.

Also, I had to take a step forward by coming up with the architecture and data model without any help from the architects. This boosted my self-confidence to a new level and showed that with great commitment and readiness to learn new things I can move mountains.

Baltic Banking Data Warehouse Top Performer Award

I won the Swedbank's BBDW Top Performer Award twice for outstanding commitment, work, and results.

Banking FTP project

I worked on developing a complex Funds Transfer Pricing project which needed some expert level SQL in order to fulfill all the business requirements and implement the calculations.

Wide Range of Source Loading (ETL) Projects

In order to feed the data warehouse with detailed and good quality data, I contributed to a wide range of loading projects from different operational systems of a bank.

Data-out Views and Macros for Applications

I was involved in multiple projects where I needed to design and implement interfaces for a bank's internal applications to provide the needed data from the data warehouse. In addition to the technical tasks, it also included a deep understanding of the business needs, finding all the crucial data from the warehouse, and putting it into the expected format for the applications.

Implementation of Temporal Data Storage Ideas in PostgreSQL (Master's Thesis)

https://github.com/SanderLaasik/temporal
For my master's thesis, I developed a set of PostgreSQL functions and tables to implement temporal support in a PostgreSQL database as described in the book "Temporal Data and The Relational Model" by C.J. Date, Hugh Darwen, and Nikos A. Lorentzos.

(http://www.dcs.warwick.ac.uk/~hugh/CS319/CS319-Temporal-Data.pdf)

Education

2013 - 2015

Master's Degree (Cum Laude) in Computer Science

Tallinn University of Technology - Tallinn, Estonia

2009 - 2013

Bachelor's Degree in Computer Science

Tallinn University of Technology - Tallinn, Estonia

Certifications

SEPTEMBER 2019 - PRESENT

MCSA: SQL 2016 Business Intelligence Development

Microsoft

Skills

Tools

Informatica PowerCenter, Microsoft Power BI, Git

Languages

SQL, XML, Java, Visual Basic, PHP, CSS, HTML

Paradigms

ETL Implementation & Design

Platforms

Oracle Data Integrator (ODI), Oracle Data Integrator 11g, Windows

Storage

Teradata Databases, Database Modeling, SQL Server Integration Services (SSIS), PostgreSQL 10, Oracle 11g, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Oracle SQL Developer, Teradata, Oracle RDBMS, PostgreSQL, Microsoft SQL Server, Database Administration (DBA), SQL Server 2012

Frameworks

Spring Boot, Angular

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring