Andy Read Email & Phone Number

Sheffield, Gb

Sheffield, England, United Kingdom

Specialties: IBM iSeries (AS400) support and development (RPG,RPGLE, ILE SQL). System21 Aurora 2.2 and Aurora 3.0, Indigo (Warehousing / RDT), Cobwebb (document transformation via email,fax & print), EDI support and development (Reims & TrustedLink), Bespoke RPG applications, Infor workspace 2009 & 2013, Infor workflow, Pacsol (document archieving), IB9 Message Broker triggers, Aurora and Indigo PTF installation. RouteOne and PCiRoute application developer.

iSeries support and development. I have supported the following applications:-• System21 3.5.2, Aurora 2.2 and Aurora 3.0• Indigo (Warehousing / RDT)• Cobwebb (document transformation via email,fax and print)• Reims (EDI and BACS applications)• Bespoke RPG applications• Infor workspace 2009 and 2013• Infor workflow• Pacsol (document archiving)• Message Broker (IB9) data transformation• iSeries database triggers• Aurora & Indigo PTF installationI have written and amended programs in all variations of RPG for the applications:- • Voice Picking interface• Marco Weight Scales interface• Hyperion interface• Sales orders interface (from excel)• Sales orders interface between ERP's• Sales Invoice -> Purchase Invoice conversion for intercompany trading• Bespoke System21 reports• Financial Accounts• Management Accounts• Manufacturing• MRP• Inventory• Warehousing• SOP• EDI• Aurora 3.0 Master data maintenance• Aurora 3.0 Master data publication• System monitoring tools• User profile creation tools• User profile audit reports• Data retention routines• Database performance routinesAs well as developing on the iSeries I have also developed applications for the following PC applications:-• Cobwebb document transformation• Excel Macro applicationsI have been responsible for ETL (extract, transform, load) of external data before converting and loading into Aurora. Responsible for uploading master data at all of the Aurora implementations across the UK and US for both existing and newly acquired companies. This has also included training master data staff at each site. Cutover and go-live support for new implementations of Aurora.

Worked as an AP on iSeries... responsible for EDI using REIMS.