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 & 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 from 2008 to 2010.
I was a member of the board from 2003 to 2007.

I have been a member of the board of a housing cooperative since 2010.


Project references

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


Size classification of customers:

  Big enterprise      : Public limited company listed in a stock exchange
                        or non-public organization with more than 1000 employees.
  Medium enterprise   : Private limited company, more than 20 employees
  Small enterprise    : 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


2011        customer: Big labour union
            project: SMS interface for membership registry
            programming language: Java
            database: MySQL

2010        customer: Medium 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

2010        customer: Big political party
            project: Membership registry
            programming language: Java
            database: MySQL

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

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

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

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

2004 - 2010 customer: Government agency
            project: Survey system ( employee work satisfaction )
            programming language: Java
            database: MS SQLServer, MySQL

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

2009        customer: Association of organizations ( cultural heritage )
            project: WWW-interface for benefits management system
            programming language: Java
            database: MySQL

2002 - 2007 customer: Medium software company
and         project: Project management and invoicing system
2009 - 2010 programming language: Java
            database: MS SQLServer, 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

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

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

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

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

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

2005        customer: Big labour union
and         project: Management system for disagreements
2011        programming language: Java
            database: Oracle, 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

2004 - 2005 customer: Association of organizations ( cultural heritage )
and         project: WWW search engine
2011        programming language: Java
            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

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

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

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

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

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

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

Aapo Puhakka