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.

Special expertice:

Domain specific expertice:

Some history of main programming language used:

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

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

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 'Ylioppilas' certificate with four Laudatur's in 1994.


Military Service

Accomplished in 1995 at TiedPsto/TykPr and TjPtri/RUK. 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 have participated in the Skunk Rocket Project since 2006.
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.


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

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

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

2016        customer: Small association 
            project: Course management 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

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

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

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

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

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

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

2013 - 2015 customer: 15 transport companies 
            project: Maintenance of truck control system
            programming languages: Java, C#, Sybase Powerbuilder
            database: Sybase

2011 - 2015 customer: Three medium associations 
            project: 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

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

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: 7 big labour unions 
            project: Congress management system
            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 23.12.2016