Curriculum Vitae of Aapo Puhakka

Suomeksi

Contents

Working Experience

I am working at Vetokonsultit Oy. I have been working in the company part-time during 1991 - 1993 and 1996 - 1999 and full-time since 1999.

I have been the CEO of the company since 2012.

Special expertice:

Domain specific expertice:

Some history of main programming language used:

Other used programming languages: C, C++, MS .net / C#, HTML, CSS, Javascript

Database experience:

Project references are at the end of this CV.

I was an assistant at the Operating Systems course of HUT in 1999 & 2000.

I participated in the Lego Robot as a Museum Guide project in 1999 & 2000.

Educational Background

Software sales coaching program 2017-2018.

I completed Master of Science studies in computer science at Helsinki University of Technology in 2004.

Option studies: Telecommunications Software and Multimedia
Major subject: Interactive Digital Media
Minor subject: Information Science
Master's Thesis: Concentrating Common Functionality of Different User Interfaces into an Application Server.

I got my Finnish High School certificate with four laudatur's ( Finnish: laudatur, English: laudatur, Mathematics: laudatur, Arts and Sciences: laudatur, Swedish: cum laude approbatur ) in 1994.

Music school certificate of graduation with violincello in 1992.

Military Service

Accomplished in 1995 at Reconnaissance Battery of Artillery Brigade and Fire Control Battery of Reserve Officer School.
Military rank: second lieutenant.
Special military education: artillery fire control, artillery measurement reconnaissance, intelligence officer.

Confidential Posts

I was the president of POLLUX in 1997. I was a member of the board in 1994, 1996 - 1997 & 2002.
(POLLUX is students astronomy, space & rocketry club). I'm now a honorary member of the club.

I was the secretary of TRIP in 2002.
(TRIP is students sailing club).

I am official Rocket Master, nominated by Finnish Astronautical Society.
I participated in the Skunk Rocket Project during 2006 - 2012.
I was the president and treasurer of the society during 2008 - 2010. I was a member of the board during 2003 - 2010.

I have been a member of the board of a housing cooperative since 2010 and I was the president of the housing cooperative in 2011.

I have been performance auditor of Meditaatiokellarin ystävät ry since 2014.

I have been performance auditor of Tavallinen Mieli Zendo ry since 2019.

Hobbies

Hobbies: meditation, cello, ukulele, yoga, qigong, kettlebell, orienteering, camping, mountaineering, canoeing, sailing, model rocketry and astronomy.

Project references

Customer projects, in which I have worked for more than 20 hours a year. 


Size classification of customers:

  Big company         : Public limited company listed in a stock exchange
                        or non-public organization with more than 200 employees.
  Medium company      : Private limited company, more than 20 employees
  Small company       : Less than 20 employees

  Big association     : More than 20 000 personal members
  Medium association  : 1 000 - 20 000 personal members
  Small association   : Less than 1 000 personal members
  Association of organizations : Members of association are companies or associations
  
  Big municipality   : more than 50 000 habitants
  Small municipality : less than 50 000 habitants

2002-2005,  customer: Big association 
2009-2021   project: Membership registry
            programming language: Java
            database: MySQL

2004-2021   customer: Multiple government agencies 
            project: Survey system ( employee work satisfaction )
            programming language: Java
            database: MS SQLServer, MySQL

2016-2021   customer: Big metal industry company 
            project: Quality management system
            programming language: Java
            database: MS SQLServer

2019-2021   customer: Medium fuel sales company 
            project: ERP-system
            programming language: Java
            database: MySQL

1999 - 2003 customer: Big labour union 
and         project: Paper and image archive
2011, 2020  programming language: Java
            database: Oracle, MySQL

2004-2005,  customer: 7 big labour unions 
2017-2018,  project: Congress management system
2020        programming language: Java
            database: MySQL

2013-2015,  customer: 15 transport companies 
2017-2020   project: Truck transportation control system
            programming languages: Java, C#, Sybase Powerbuilder
            database: Sybase

2019        customer: Large transportation company 
            project: Truck management system
            programming language: Java
            database: MySQL

2002-2007,  customer: Medium software company 
2009-2016,  project: Project management and invoicing system
2018        programming language: Java
            database: MS SQLServer, MySQL

2010,       customer: Big political party 
2013-2018   project: Membership registry
            programming language: Java
            database: MySQL

2017-2018   customer: Engineering company 
            project: Project management system
            programming language: Java
            database: MySQL

2017        customer: Big association 
            project: Membership registry
            programming language: Java
            database: MySQL

2015        customer: Small association offering social services 
and         project: Customer management system
2017        programming language: Java
            database: MySQL

2016        customer: Big labour union 
            project: Reporting system
            programming language: Java
            database: MySQL

2016        customer: Small city 
            project: Warehouse management system
            programming language: Java
            database: MySQL

2014-2016   customer: University 
            project: Acquisitions and equipment management system
            programming language: Java
            database: MySQL

2015        customer: Small company offering social services 
            project: Customer management system
            programming language: Java
            database: MySQL

2011-2015   customer: Three medium associations 
            project: Care service request management system
            programming language: Java
            database: MySQL

2011        customer: Big labour union 
and         project: Membership registry
2015        programming language: Java
            database: MySQL

2007-2010   customer: Medium electric engineering company 
and         project: Project management and invoicing system
2014-2015   programming language: Java
            database: MySQL

2014        customer: Government agency 
            project: Survey system ( teams )
            programming language: Java
            database: MySQL

2007-2014   customer: Big charitable organization 
            project: Donation accounting system
            programming language: Java
            database: MySQL

2005, 2011  customer: Big labour union 
and         project: Management system for disagreements
2013-2014   programming language: Java
            database: Oracle, MySQL

2013        customer: Medium software company 
            project: Evaluation of maintenance situation of Linux-servers

2009-2013   customer: Big telecommunication company 
            project: Call center database
            programming language: Java, C#
            database: MySQL, MS SQLServer, Oracle

2012        customer: Small architecture company 
            project: Project management and invoicing system
            programming language: Java
            database: MySQL

2012        customer: Small company 
            project: Program for data transfer from medical measurement devices
            programming language: Java

2012        customer: Government agency 
            project: Survey system ( worktime )
            programming language: Java
            database: MySQL

2009        customer: Association of organizations ( cultural heritage ) 
and         project: Benefits applications management system
2011-2012   programming language: Java
            database: MySQL

2011        customer: Big insurance company 
            project: Archive management system
            programming language: Java
            database: MySQL

2010-2011   customer: Big labour union 
            project: Document management system
            programming language: Java
            database: MySQL

2004-2005   customer: Association of organizations ( cultural heritage ) 
and         project: WWW search engine
2011        programming language: Java
            database: MySQL

2004        customer: Big industrial company manufacturing electrical products 
and         project: Project management system
2011        programming language: Java
            database: MS SQLServer

2010        customer: Small artwork restoration company 
            project: Management system for works of art
            programming language: Java
            database: MySQL

2010        customer: Big charitable organization 
            project: Testament management system
            programming language: Java
            database: MySQL

2007-2008   customer: Medium research center 
            project: Project management system
            programming language: Java
            database: MySQL

2007        customer: Big media company 
            project: Database conversion of www-application
            programming language: Java
            database: MySQL, Oracle

2005-2007   customer: Medium research center 
            project: Project management system
            programming language: Java
            database: MySQL

2006        customer: 5 project organizations 
            project: Special program for entering time sheets
            programming language: Java
            database: MS SQLServer, MySQL, Oracle

2006        customer: Small paper industry engineering company 
            project: Project management and invoicing system
            programming language: Java
            database: MySQL

2002-2006   customer: Big industrial company ( software, electronics and military applications ) 
            project: Project management system
            programming language: Java
            database: MySQL

2005        customer: Small city 
            project: Registry for confidential posts and postal deliveries
            programming language: Java
            database: MySQL

2005        customer: Association of organizations ( employer association )
            project: Customer relationship management system with projects
            programming language: Java
            database: MySQL

2004-2005   customer: Medium metal industry company manufacturing conveyor belts 
            project: Html application for offer calculation and layout design
            programming language: Java, JavaScript
            database: MySQL

2001-2005   customer: Research center of a big paper industry company 
            project: Project management and invoicing system
            programming language: Java
            database: Oracle

2004        customer: Association of organizations ( forestry ) 
            project: Mobile forest information system
            programming language: Java
            database: MySQL, Oracle

2003-2004   customer: Small consulting company 
            project: Benchmarking survey system ( hotels )
            programming language: Java
            database: MySQL

2002-2003   customer: Big metal industry company 
            project: Key customer system
            programming language: Java
            database: Sybase

2001-2003   customer: Small consulting company 
            project: Benchmarking survey system ( human resources management )
            programming language: Java
            database: MySQL

2000-2003   customer: Association of organizations ( information technology ) 
            project: Maintenance of a system for examinations and requests for offers
            programming language: C, Perl
            database: text-based

2001        customer: Medium company of chemical industry 
            project: Archive of patents and reports
            programming language: Java
            database: MS SQLServer

2001        customer: Big metal industry company 
            project: Control system for scale
            programming language: Delphi
            database: Sybase

1991-2000   customer: Big labour union 
            project: Membership registry
            programming language: SQLWindows, Delphi
            database: Oracle

1998        customer: Big labour union
            project: Contact information registry
            programming language: Delphi
            database: Oracle

1998        customer: 6 big labour unions
            project: System for collecting excess paid benefits
            programming language: Delphi
            database: Oracle

1998        customer: Government agency
            project: Management system for licenses granted for companies
            programming language: Delphi
            database: MS SQLServer

1997-1998   customer: Big political party
            project: Membership registry
            programming language: Delphi
            database: Sybase

1997        customer: 3 big labour unions
            project: Congress management system
            programming language: Delphi
            database: Paradox

1996        customer: Big labour union
            project: Management system for disagreements in employment agreements
            programming language: Delphi
            database: Interbase

1996        customer: Big TV-broadcasting company
            project: Planning model used in a TV-program
            programming language & database: Quattro Pro

1994-1995   customer: Big retail company
            project: Order and warehouse management system
            programming language: Paradox/PAL
            database: Paradox

1993        customer: Big labour union
            project: Membership registry
            programming language: SQLWindows
            database: SQLBase

Updated 18.3.2022