Declan - Développeur AS400
Ref : 130821H001-
Domicile
2001 CORK (Irlande)
-
Profil
Développeur, Business Analyst (66 ans)
-
StatutFreelance
-
Tarif Journalier MoyenVoir le tarif
-
Smartply Europe,WaterfordJan 2013 - aujourd'hui
Employed as remote contract programmer/analyst using SQL and Crystal Reports. Activities include creating stored procedures, tables and views. Also writing reports using Crystal Reports.
-
Jan 2012 - aujourd'hui
Present Musgraves Retail Partners, Europe
Employed as contract programmer/analyst using JAVA, COBOL and RPG on IBM AS400. Main duties involve designing enhancements to Supply Chain system. Achievements: Frequent high quality JAVA and COBOL solutions deployed on time. Many reports also written using Jasper Reports. -
Smartply Europe,WaterfordJan 2011 - Jan 2012
Employed as contract programmer/analyst 3 days per week. Used SQL Server Management Studio to create and maintain views, triggers and procedures. Created extracts and reports using Crystal Reports and Syspro ERP system. Areas worked on were Sales, Purchasing, Complaints, Freight, and Inventory. Achieved timely and reliable SQL based solutions, involving high level of interaction and requirements gathering from users.
-
Pepsico (Little Island) in CorkJan 2005 - Jan 2011
Employed as contract programmer/analyst on IBM AS400 using RPG and COBOL (2/3 days per week).
Main duties involved supporting a Mapics ERP system and enhancing other bespoke systems on the AS400. Achieved superior level of support for business users. Also played major role in data extraction to new SAP system. This involved extracting and verification of data by data cleansing and business user teams. Achieved smooth and accurate data extraction involving extensive communication with SAP teams. -
Medite of Europe, ClonmelJan 2004 - Jan 2010
Employed as contract programmer on IBM AS400 using RPG and COBOL (2/3 days per week). Main duties involved enhancing and supporting bespoke systems on the AS400. Reliable and high quality enhancements achieved on AS400. Also used SQL Management Studio and Crystal Reports (with Syspro) and to deliver new SQL solutions. Achieved high quality and reliable SQL solutions.
-
Dairygold, MitchelstownJan 1986 - Jan 2004
Employed as contract programmer on IBM System38 and AS400 using RPG and COBOL. Worked on existing Invoicing and Sales systems. Also Accounts Receivables, Creditors, Milk Recording, Artificial
Insemination for cattle, Pig Payments, Payroll and Bank Reconciliation were other system maintained. Duties involved programming enhancements and trouble-shooting as well as helpdesk tasks. Achieved satisfactory levels of support for business users. -
Vector Software, DublinJan 1986 - Jan 1986
Contract programming of enhancements to Accounts Receivable package for a large software house, on System38 platform. Achievement: Delivered high-quality and reliable programs.
-
Medite of Europe, ClonmelJan 1985 - Jan 1986
Position involved programming IBM System38 on contract basis using RPG. Applications included full manufacturing spectrum. Raw Materials, Production, Quality Control, Stock, Order Entry, Shipping, Invoicing, AR, AP and General Ledger. Programming involved maintenance and trouble-shooting, enhancements to existing systems, and design and programming of new applications. Achievement: Delivered high-quality support for business users and robust and reliable programs.
-
Loctite (Ireland), DublinJan 1985 - Jan 1985
Programming involved enhancements to existing Order Entry system on System/38 using COBOL, on contract basis. Reporting to Systems Analyst. Achievement: Program enhancements completed on time and to high quality standard.
-
Mitchelstown Co-opJan 1984 - Jan 1984
Contract position as programmer on System38 . Application involved conversion of invoicing system from UNIVAC to System38 using COBOL. Also did some programming on milk recording system. Reporting to project leaders. Achievements: Programming tasks completed, resulting in reliable code.
Key IT Skills
SQL
Crystal Reports
Jasper Reports
JAVA
Syspro
AS400 / i5 RPG, RPG4,
AS400 / i5 COBOL
Mapics
Android
Over 25 years experience of analysis, design and coding
Plus excellent communication skills and international experience
Educational Details
1976 Leaving Certificate St Pauls College, Raheny, Dublin
1979 Certificate in Computer Programming Techniques Irish Computer Training School
Sept 1999 to November 2000 IBM, Dublin
Employed as part-time contract training instructor, delivering courses on AS400 programming, operations and administration. These courses for IT professional included Security Administration.
Sept 1997 to May 1999 University College Cork
Employed as part-time lecturer on programming in RPG. Modules taught were part of degree courses in IT(Computer Science) and Commerce.
Hobbies and Pastimes
Favourite activities include running, cycling, swimming, canoeing, surfing. I compete in Triathlons.
I also enjoy gardening, woodwork, playing guitar, playing keyboards, reading, DIY, and travelling.
SQL
Crystal Reports
Jasper Reports
JAVA
Syspro
AS400 / i5 RPG, RPG4,
AS400 / i5 COBOL
Mapics
Android
Over 25 years experience of analysis, design and coding
Plus excellent communication skills and international experience
Educational Details
1976 Leaving Certificate St Pauls College, Raheny, Dublin
1979 Certificate in Computer Programming Techniques Irish Computer Training School
Sept 1999 to November 2000 IBM, Dublin
Employed as part-time contract training instructor, delivering courses on AS400 programming, operations and administration. These courses for IT professional included Security Administration.
Sept 1997 to May 1999 University College Cork
Employed as part-time lecturer on programming in RPG. Modules taught were part of degree courses in IT(Computer Science) and Commerce.
Hobbies and Pastimes
Favourite activities include running, cycling, swimming, canoeing, surfing. I compete in Triathlons.
I also enjoy gardening, woodwork, playing guitar, playing keyboards, reading, DIY, and travelling.