It looks like you are in United States. Would you like to go to https://onsiter.com/us/ instead?
Saattaa olla saatavilla
(Päivitetty 2020-04-07)Tekninen IT-konsultti (IBM AS400/i5)
Kauniainen, Finland
Äidinkieli Finnish, Sujuva Svenska, English
- +10 vuotta SQL
- +20 vuotta IBM AS400/i5/system i
- +20 vuotta RPG/RPGLE/SQLRPGLE
Taidot (25)
ERP
IBMi
LEASING
DB2
TECHNICAL SPECIFICATIONS
SQL
STORED PROCEDURES
SSA
DECOMMISSIONING
Batch Management
SEATING
FUNCTIONAL SPECIFICATIONS
DATA INTEGRITY
LOGISTICS
Excel
WRITING FUNCTIONAL
CLIENTS
Data Management
FDA
SYNON
FINANCE
ACROBAT
BUSINESS CONSULTANT
EMPLOYEE RESOURCE GROUP
Työkokemus
Contractor, System Designer
L-Fashion Group
2017-09 - Nykyhetki
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)
Koulutus
Bachelor of Computing
Commercial College of Tampere
2020-04 - 1987-01
Bachelor of Commercial
Commercial College of Turku
2020-04 - 1986-01
Sertifikaatit
You created this PDF from an application that is not licensed to print to novaPDF printer