Data Engineer Stockholm, Sweden

Podría estar disponible

(Actualizado 2024-03-27.)

Data Engineer

Stockholm, Sweden

Nativo Svenska, English, Spanish, Intermedio French

  • T-SQL
  • Azure
  • Python
Contacto

Habilidades (59)

VISUALIZATION

API

BUSINESS REQUIREMENTS

BI

Python

MATLAB

POWERPOINT

pytest

Bash

MICROSOFT EXCEL

Excel

VBA

PIPELINE

Business Intelligence

MICROSOFT POWERPOINT

Git

Serverless Architecture

SYSTEM DEVELOPMENT

Docker

QUEUE MANAGEMENT

Queue

SHELL SCRIPTING

JavaScript

DATA SCIENCE

Kubernetes

PySpark

MICROSOFT DYNAMICS

Amazon Web Services

ASTERADATA

REACTJS

React

DYNAMICS

Cassandra

MICROSOFT DYNAMICS AX

AWS

CALYPSO

MAPPING

RECONCILIATIONS

TECHNICAL REQUIREMENTS

STATISTICAL MODELING

TEST CASES

RESOURCE UTILIZATION

Project Management

LOGISTICS

TEACHING

CUSTOMER RELATIONSHIP MANAGEMENT

BUSINESS OPERATIONS

Data Analysis

REQUIREMENTS GATHERING

SELF-DIRECTED

BUSINESS PROCESS MANAGEMENT

DATA SERVICES

Pressure Vessel

MARKETING ANALYSIS

OPERATIONS

TRADING

WORKFLOW

MONTE CARLO

CRM

Resumen

Johnny is a seasoned IT professional with over eight years of experience,
excelling in business intelligence, data science, data engineering, applied
mathematics, coding, and cloud development. Proficient in extracting business
insights through data analysis and visualization, Johnny stands out for his
exceptional communication skills, effortlessly conveying complex concepts to
non-technical stakeholders.

CGI experience

Oldest Bank in Sweden, Azure Data Engineer (Dates 06/23 to 03/34)

As an Azure Data Engineer, Johnny develops of a hybrid cloud data platform,
focusing on the creation of a unified data source for the entire Swedish central
bank. In this role, he is responsible for Python development, constructing data
pipelines efficiently using Dagster, Docker and azure pipeline yaml files.

His expertise encompasses various tools and technologies, including SQL,
Dagster, Copier, Cookiecutter, and Azure DevOps. He has experience with
static analysis tools such as ruff and pytest, ensuring code quality and
security. He excels in building artifacts in Azure Pipelines, and he follow a
continuous integration and continuous development approach within an agile
strategy. His daily work involves saving code in Azure Repos with git,
contributing to efficient and collaborative development practices.

LF-BANK, Data Engineer (Dates 12/22 to 06/23)

In his role as a Data Engineer, Johnny oversees the ETL process and Data
pipelines for the bank's data warehouse, leveraging an on-premises Microsoft
stack consisting of SSIS, SSMS, and C#. The assignment's primary objective
is to expand the current data warehouse and transition the data models to
KAFKA. Furthermore, Johnny actively contributes to developing new data
models, employing methodologies such as Kimball and Data Vault to ensure a
precise representation of the bank's operations.

NCC, Azure Data Engineer (Dates 06/22 to 12/22)

As a data engineer, Johnny led the comprehensive ETL workflow in Azure,
with the mission of constructing a cloud-based data warehouse for the entire
company. This involved crafting precise data models that faithfully represented
business operations.

In his role as a data engineer in Azure, Johnny achieved seamless integration
of data flows from APIs (data sources) to PowerBI, utilizing the capabilities of
Azure Databricks. His expertise and efforts were pivotal in establishing a
robust infrastructure, facilitating efficient data processing and analysis across
the organization.

Industry expertise
Banking and Finance, Retail,
Construction, Transportation, Energy

Experiencia profesional

Data Analyst
Nobina

2017-09 - 2018-08

As a Data Analyst at Nobina, Sweden's largest public transportation company, Johnny undertook a multifaceted role encompassing operations research, optimization of crew and vehicle schedules, and identification of events in daily traffic operations through insightful data visualization. His daily efforts involved gathering and analyzing information to proactively design preventive measures, thereby avoiding unnecessary costs. Johnny also played a key role in fostering cross-sectional communication within the company by contributing to the creation of Business Intelligence (BI) reports in Power BI. His proficiency extended to various tools such as HASTUS, Microsoft Excel, VBA Excel, Power BI, R, Data Visualization, Requirement gathering, and Project Management.
Business Analyst
Brummers and Partners

2017-01 - 2017-06

As a CALYPSO BUSINESS ANALYST AT BRUMMER & PARTNERS FUND SERVICES, Johnny streamlined operations in a hedge fund's back/middle office, covering the entire financial asset trade lifecycle. Working closely with developers, he gathered and mapped requirements, improving processes and acting as a vital link between Back- /Middle office and IT. Johnny focused on enhancing trade reconciliations, utilizing tools such as Calypso, Project Management, Business Process Management, and languages like Java, Python, SQL.
Data Analyst
IKEA Tasstrup

2016-05 - 2016-12

As an Operations Research Analyst at IKEA Taastrup, Johnny aimed to save costs by optimizing work shift schedules.
Using advanced optimization algorithms, he designed more efficient schedules, demonstrating potential staff resource redistribution. Presenting findings to IKEA Denmark's CFO, he sparked interest for future collaboration. Tools utilized included Matlab, Workshop, Excel, Queue Theory, Markov Chain, Statistical Mathematics, R, HASTUS, and Requirement gathering.
Data Analyst
Transdev Sverige AB

2016-01 - 2016-12

As data analyst Johnny led and facilitated courses on the Hastus planning system, encompassing fundamental and advanced topics. Created extensive training materials for new users, forming the basis for self-directed training sessions.
Data Analyst
Unibuss Denmark

2016-01 - 2016-02

As a data analyst, Johnny led and facilitated courses on the Hastus planning system, covering both fundamental and advanced topics. He also created extensive training materials for new users, serving as the foundation for self-directed training sessions. In a separate project, Johnny conducted a pre-study to assist the client in selecting a new traffic planning system. The client sought information on the costs and risks associated with implementing a new optimization system.
Johnny delivered a final presentation with data visualization focusing on the costs.
On an individual level, Johnny was responsible for linking the client's requirements to two different planning systems and visualizing cost data. Additionally, he conducted interviews with system users and compiled a presentation outlining the costs, advantages, and disadvantages of each system.
Key areas of expertise in this assignment included: Hastus, Optibus, Data Analysis, Data Visualization, Process Mapping, Workshops, Requirements Gathering, Microsoft Excel, Microsoft Excel Pivot, and PowerPoint.
Data Analyst
SOS Alarm

2015-08 - 2015-12

As an Operations Research Analyst on the SOS project, Johnny aimed to reduce emergency call response times by creating optimized work schedules. Using MATLAB, R, Excel, VBA, statistical modeling, and HASTUS, he developed Erlang algorithms to predict staffing needs. By employing advanced optimization algorithms, he crafted efficient shifts, saving company resources and minimizing lead times. His findings were presented in a concise summary, outlining strategies for improved staff planning and reduced call response times.
Data Analyst
Sporveien, BI

2015-02 - 2015-08

Johnny demonstrated his expertise by creating and delivering a specialized course on a Traffic Optimization system for Sporveien in Norway. Beyond education, he played a key role in assisting the customer in migrating to new optimization software. Johnny's involvement extended to evaluating the quality of the migration by meticulously crafting and implementing test cases. This multifaceted contribution showcases not only his teaching abilities but also his hands-on involvement in ensuring a successful transition to upgraded optimization software and validating its effectiveness through thorough testing.
Data Analyst
MTR

2015-01 - 2015-02

Johnny held a key role in crafting the working schedules utilizing the Hastus optimization system for the organization.
This responsibility involved leveraging the capabilities of the optimization system to develop schedules that aligned with operational needs and organizational goals. By employing the Hastus system, he ensured that the working schedules were not only efficiently structured but also optimized for enhanced productivity and resource utilization. This experience underscores my proficiency in utilizing advanced tools and technologies to contribute to the operational efficiency of the organization.
Internship in Nuclear Material Software developer
EDF France

2013-01 - 2013-06

Algorithm optimisation of Atomistic Kinetic Monte Carlo code for Simulations of radiation damage in PWR, reactor pressure vessel (RPV). Wrote my thesis in numerical simulation department.
Arol Energy

2012-08 - 2012-12

Conducted a comprehensive preliminary study for an energy startup in France, analyzing market trends, competitive landscape, and identifying potential opportunities. The insights gathered were instrumental in guiding strategic decision-making and formulating a robust business plan for the startup.
Technical specializations Data Engineering Python development SQL development Java development Azure Cloud AWS INFORMATICA MDM Developer

Formación académica

Grenoble Ecole de Manegement
Grenoble Ecole de Manegement

2024-12 - 2024-12

Université Stendhal
Université Stendhal

2024-12 - 2024-12

Turing College
Turing College

2024-03 - 2024-01

Udacity
Udacity

2024-03 - 2024-01

Udacity
Udacity

2024-03 - 2024-01

Datacamp
Datacamp

2024-03 - 2024-01

certification

2024-03 - 2022-01

M.Sc.
INPG - Institut national

2024-03 - 2014-01

Polytechnique de Grenoble
Polytechnique de Grenoble

2024-03 - 2013-01

Certificaciones

Developer, Specialist Certification

Contacta con el consultor

/