It looks like you are in United States. Would you like to go to https://onsiter.com/us/ instead?
Might be available
(Updated 2020-04-07)Tekninen IT-konsultti (IBM AS400/i5)
Kauniainen, Finland
Native Finnish, Fluent Svenska, English
- +10 vuotta SQL
- +20 vuotta RPG/RPGLE/SQLRPGLE
- +20 vuotta IBM AS400/i5/system i
Skills (25)
Professional Experience
Contractor, System Designer
L-Fashion Group
2017-09 - Present
I have been mainly working on a project interfacing LFG's ERP to new all automatic
warehouse system (KiSoft from Knapp). This is done using SQLRPGLE
sending/receiving XML messages. This warehouse automatization project should be
finalized by August 2019.
warehouse system (KiSoft from Knapp). This is done using SQLRPGLE
sending/receiving XML messages. This warehouse automatization project should be
finalized by August 2019.
employee, System Designer
LeasePlan Finland
2013-12 - 2017-09
My main duties were to develop new features to LeasePlan Finland's leasing system
(RPGXML, SQLRPG) and giving 1 st line support to users on any issues within IBM
System i based leasing system. On support role also creating Excel reports using
VBA/Sql was part of the job.
Skills detail: IBM System i, SQLRPG, RPG Free, SQL, RPGXML
(RPGXML, SQLRPG) and giving 1 st line support to users on any issues within IBM
System i based leasing system. On support role also creating Excel reports using
VBA/Sql was part of the job.
Skills detail: IBM System i, SQLRPG, RPG Free, SQL, RPGXML
Contractor, technical systems/business consultant
1999-05 - 2013-11
Fiskars Brands Finland Oy maintaining their
2011-04 - 2013-11
I was working for Fiskars Brands Finland Oy maintaining their
PRMS system and developing interfaces between Fiskars' new SAP system and then
existing PRMS. I also maintained my own earlier developed labor reporting system at Fiskars and re-made its interface to a new salary system.
PRMS system and developing interfaces between Fiskars' new SAP system and then
existing PRMS. I also maintained my own earlier developed labor reporting system at Fiskars and re-made its interface to a new salary system.
Canon North-East Oy on their decommissioning
2008-12 - 2011-03
I was working for Canon North-East Oy on their decommissioning
project (decommissioning of Movex system and the company). In this role I created new
interfaces between Movex and iScala systems as part of Canon North-East Oy's business
was transferred to Canon Russia that was using iScala. I made enhancements to several
different parts of Canon North-East Oy's mission critical System i solutions and I was the sole person to give support on Canon North-East Oy's System i and their Movex system..
project (decommissioning of Movex system and the company). In this role I created new
interfaces between Movex and iScala systems as part of Canon North-East Oy's business
was transferred to Canon Russia that was using iScala. I made enhancements to several
different parts of Canon North-East Oy's mission critical System i solutions and I was the sole person to give support on Canon North-East Oy's System i and their Movex system..
Fiskars Brands Finland Oy
2006-01 - 2008-01
I was contracting for Fiskars Brands Finland Oy creating a browser based
labor reporting system (based on System i/PRMS) using RPGIV with embedded SQL as
stored procedures..
2002-2005 I worked as a sub-contractor for SSA Global in Finland. In this job I have
been working with SSA's BPCS (V6.0.04/V6.1/V8.0), PRMS and Masterpiece clients
giving end user support&training, making enhancement specifications, doing system
upgrades and keeping client system intact. I have also done programming with AS/SET
and RPG (e.g. Fano Fine Food, Netherlands- BPCS V6.1). I have been involved in SSA
labor reporting system (based on System i/PRMS) using RPGIV with embedded SQL as
stored procedures..
2002-2005 I worked as a sub-contractor for SSA Global in Finland. In this job I have
been working with SSA's BPCS (V6.0.04/V6.1/V8.0), PRMS and Masterpiece clients
giving end user support&training, making enhancement specifications, doing system
upgrades and keeping client system intact. I have also done programming with AS/SET
and RPG (e.g. Fano Fine Food, Netherlands- BPCS V6.1). I have been involved in SSA
support person
FinnCatering, YIT Power, Raisio Chemicals/Ciba, Canon, ME Group
1999-01 - 2002-01
I worked with Intentia in their Movex implementation projects (ie. FinnCatering, YIT Power, Raisio Chemicals/Ciba, Canon, ME Group, FinnSementti). In
this job I was all the time facing the end users and did everything from gathering
requirement definitions to programming. 1999-2004 I worked with Tradepaq's document
solutions (DTD&Confirm) at Intsru Optiikka and I was the only person doing their
enhancements and giving support.
You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com)
Skills detail: IBM iSeries/AS400/System i up to V6R1, PC's, Microsoft XP/Vista/7,
Novell Netware 6, MQSeries on AS400/System i, AS/SET, RPG400, RPGIV, RPG
stored procedures, CL, DB2/400, AS400 Query, Net.Data (CGI), HTML, EDI, SQL,
FTP, TradePaq's document solutions, Manufacturing, Logistics, Interfaces, XML
this job I was all the time facing the end users and did everything from gathering
requirement definitions to programming. 1999-2004 I worked with Tradepaq's document
solutions (DTD&Confirm) at Intsru Optiikka and I was the only person doing their
enhancements and giving support.
You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com)
Skills detail: IBM iSeries/AS400/System i up to V6R1, PC's, Microsoft XP/Vista/7,
Novell Netware 6, MQSeries on AS400/System i, AS/SET, RPG400, RPGIV, RPG
stored procedures, CL, DB2/400, AS400 Query, Net.Data (CGI), HTML, EDI, SQL,
FTP, TradePaq's document solutions, Manufacturing, Logistics, Interfaces, XML
project manager, systems/business analyst
WM-Data Consulting
1997-08 - 1999-04
I worked as a technical project manager and I was responsible for clients' BPCS
implementations from functional specifications to technical implementation and for
imported data integrity. My main client was Santen Oy (pharmaceuticals/ opthalmic drugs), BPCS V6.0.02 implementation project and with them I came to know what FDA
regulations mean for information systems. I took care of user training, made requirement
specifications, formed them to technical specifications and also made the programming. I
worked with BPCS versions from 4.0.02 to 6.1 both MM & CS. Clients were
manufacturing companies from pharmaceutical and chemical industry (ie. Schering, Santen, OMG Kokkola Chemicals, Outokumpu Poricopper). I was often put to solve
urgent client issues not faced before at WM-Data and I carried off well all the expectations.
Skills detail: IBM AS400, PC's, Microsoft NT, AS/SET, RPG400, CL, DB2/400, AS400
Query, EDI, SQL, FTP, Pharmaceuticals, Manufacturing, Logistics, Interfaces, FDA
implementations from functional specifications to technical implementation and for
imported data integrity. My main client was Santen Oy (pharmaceuticals/ opthalmic drugs), BPCS V6.0.02 implementation project and with them I came to know what FDA
regulations mean for information systems. I took care of user training, made requirement
specifications, formed them to technical specifications and also made the programming. I
worked with BPCS versions from 4.0.02 to 6.1 both MM & CS. Clients were
manufacturing companies from pharmaceutical and chemical industry (ie. Schering, Santen, OMG Kokkola Chemicals, Outokumpu Poricopper). I was often put to solve
urgent client issues not faced before at WM-Data and I carried off well all the expectations.
Skills detail: IBM AS400, PC's, Microsoft NT, AS/SET, RPG400, CL, DB2/400, AS400
Query, EDI, SQL, FTP, Pharmaceuticals, Manufacturing, Logistics, Interfaces, FDA
Contractor, systems/business consultant
Saab seats
1993-10 - 1997-07
I was working at Lear Seating Sweden's sites to analyze the changes needed to fit the systems implemented in Trollhattan site (Saab seats) for needs in Bengtsfors site (Volvo seats). I defined and created a big part of Lear's EDI solution against Volvo's systems. I
provided system support and training (AS400/MAPICS/BPCS) to users at Lear's both
Swedish plants. I also made analysis and enhancements to Nokia Consumer Electronics'
BPCS (V4) system in Turku/Finland and worked for IBM (MAPICS) in Stockholm,
Sweden. I did also some contracting for WM-Data in their BPCS (V4) projects.
Skills detail: IBM AS400, PC's, Microsoft 3.1, RPG400, CL, DB2/400, AS400 Query,
EDI, SQL, Manufacturing, Logistics, Interfaces
provided system support and training (AS400/MAPICS/BPCS) to users at Lear's both
Swedish plants. I also made analysis and enhancements to Nokia Consumer Electronics'
BPCS (V4) system in Turku/Finland and worked for IBM (MAPICS) in Stockholm,
Sweden. I did also some contracting for WM-Data in their BPCS (V4) projects.
Skills detail: IBM AS400, PC's, Microsoft 3.1, RPG400, CL, DB2/400, AS400 Query,
EDI, SQL, Manufacturing, Logistics, Interfaces
systems analyst
Lear Finland, Kalanti
1992-02 - 1993-09
I was responsible for Lear Finlands' ERP and finance systems implementation
(MAPICS/BPCS - RPG400). Lear Finlands' PC based EDI solution was developed under
my supervision. Part of the time I was working at Lear Seating's Swedish plants.
Skills: IBM AS/400, PC's, Microsoft network, RPG400, CL, DB2/400, AS400 Query,
EDI, Manufacturing, Logistics
(MAPICS/BPCS - RPG400). Lear Finlands' PC based EDI solution was developed under
my supervision. Part of the time I was working at Lear Seating's Swedish plants.
Skills: IBM AS/400, PC's, Microsoft network, RPG400, CL, DB2/400, AS400 Query,
EDI, Manufacturing, Logistics
different employers (3)- junior programmer/programmer
1987-05 - 1992-02
Programming on RPGII, RPG400 and Synon2. I worked with a sawmill system and two
different local ERP-systems.
Skills: IBM S/36 and AS400, RPGII, RPG400, Synon, CL, DB2/400, AS400 Query,
EDI, Manufacturing
You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com)
different local ERP-systems.
Skills: IBM S/36 and AS400, RPGII, RPG400, Synon, CL, DB2/400, AS400 Query,
EDI, Manufacturing
You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com)
Academic Background
Bachelor of Computing
Commercial College of Tampere
2020-04 - 1987-01
Bachelor of Commercial
Commercial College of Turku
2020-04 - 1986-01
Certifications
You created this PDF from an application that is not licensed to print to novaPDF printer