Arvo Paukkunen

IT PROFESSIONAL, PROGRAMMER, ENTERPRISE ARCHITECT & DESIGNER

Hire Me

Personal Profile

My true passion has always been to create something meaningful for the clients.

profile

One of the benefits in having a long career in developing IT solutions with consulting and software companies, is the unique view to the dawn of the internet till today. It includes many development paths, set of tools and technology for developers and designers. I feel that the decisive and most productive solutions lie somewhere between overhyped new tech gadgets & good old releases. I have learned a lot from companies and the people I have been working with. Specially in Microsoft, Software AG and Computer Associates - to mention a few... New technology innovations always motivate and inspire me to seek more challenges.

I would love to get my hands on new projects again and again. In delivery consultant point of view I want to make sure that projects are successful from the very beginning. Meeting customer expectations is the key and must never be forgotten. It deserves be cherished during the delivery.

Skills

Some of my skills evaluated by myself with alittle help of customers and co-workers.

AZURE Integrations

AZURE PaaS

AZURE SaaS

Azure API management

AZURE IoT hub

SQL Server (T-SQL, SSIS, SSAS, SSRS, MDS)

Visual Studio & VSTS DevOps extensions

ORACLE

JSON, NodeJS, XML etc.

CSS

jQuery

PHP

C#

Bootstrap

ASP.NET MVC & MVVM

Xamarin

Mobile apps for Win10, iOS, Android

Razor

REST

Education

I'm self-educated. I still belive learning by doing

Databases & BI

With Oracle, SQL server, DB2, Tamino XML db, Jasmine Object db, Informix, RedBrick and MySQL

Several DW/DM systems since 90's to today. Retailers and whole sales companies like Kesko Oyj (Ltd), Tradeka Oyj (Ltd), Teboil Oyj (Ltd) and several companies in a field of banking and insurance in Finland, in metadata and reporting systems in Ireland, Netherlands and Iceland. Some where on the way, I find my self in education services giving a Informatica and SQL server trainings. When with Affecto Oy, I gave a lot of Informatica training courses and before that time - I gave SQL Server trainings as a freelancer consultant with Microsoft Finland. That was already before I was hired by Microsoft Oy.

Programming

Wide range of languages like Visual Basic (back in 90's), C#, PHP, Java & Java script. Shell scripts on Unix earlier on my career. ADABAS & NATURAL with Software AG. Lots of XML based SOA integrations and so called modernizations.

Early years of my career, mostly VB with Basware Oy. One product what I started was in some early stage, called e flow. Later the programming was going more online and one solution was MS Exchange 4.0 base quotation system for Wärtsilä Oyj. Very soon after that I get involved more and more with budgeting and DW database systems (in late 90's). One of the most interesting project was Redbrick warehouse for Teboil oil company. That was one of the first starchema DW systems in nordics. Redbrick was a database designed by mr. Ralf Kimball and later bought by IBM. Today I'm working mostly ETL systems Like SSIS for data integration and automations. Database designing mostly on MS SQL Server and Analysis services + Master data services. Latest re-discovery (from 2010 - and today) is finding my self doing actual programming more and more- just because it's always been there in my skill set, but maybe a little bit in the background.

Experience

Examples of different types of jobs and projects I have been involved with.

Teboil DW

DB design regional lead and delivery / Helsinki, Finland / 1990

With ID Application Oy and Thomas Friesendahl we did big data warehouse - at that time - for oil industry loyalty card system and all card payment analysis system. ETL was handled with Visual Basic program what generates batch files for scheduled maintenance and loads. I was following that particularly DW for years, and the customer was very happy and after 10 years of continuous usage - nothing was ever needed to move out of the db. Performance was still good.

OP Bank

Lead ETL & Db designer / Helsinki, Finland / 2010 - 2011

Multivendor BI project with whole Microsoft stack involved. My responsibility areas were designing staging area, scheduled daily loads, data transformations (ETL). Analysis services cubes design and it's performance tunings. This was truly 'lighthouse' project for all the vendors.

Finance system Data integration R&D

Product Lead Architect / Helsinki, Finland / 2014 - 2015

A reporting system integrations with a clever and dynamic ETL. We were designing extraction API from source system and make that expandable for any other systems like SAP etc. All the work was done SQL server tools like T-SQL & SSIS (Integration services) and Analysis services as one reporting option. Relational side of staging and DW database is designed to integrate for Microsoft, Qlickview, Cognos etc. Qlickview specific interfaced was created on sql server relational database views and stored procedures.

Contact

Why not contact right away?

Contact Info

Pajalahdentie 17 c 46, 00200 Helsinki Finland

+358 458854888

arvosoft@hotmail.com

Download my CV here

Get in Touch

Information captured may be used for analysis. No personal info are collected.