IT Consultant

4/2001 – 5/2018

Mana Solutions managed an HP NonStop (Tandem) mainframe for RSA - this housed a Business Intelligence system comprising an ETL (Extract, Transform and Load) suite of programs, together with the Data warehouse.
Project Management
Business and Technical Analysis
Applications Support and Development for Premium and Claims ETL (Analysis and Programming - COBOL, TACL, SQL, Enscribe, Inspect).
Systems Management (S-Series, Safeguard, Netbatch, SCF, ODBC, DSM/SCM, Tape Utilities).
DBA
Hardware Support (TSM, Guided Replacement Tools)
Projects include: Development of TACL framework to support parallel processing during ETL runs; Creation of data pipeline to an MS SQL Server 2008 database using Attunity Connect drivers; Application expert and data modelling for project to replace the BI solution; Conversion of IBM Tape transfers to FTP; Exporting Health Insurance Database to third party; Decommissioning of the Tandem server.
As Director of Mana Solutions, proposed and negotiated outsourcing deal with RSA to manage entire Tandem server operation.

Hausratsversicherung, Business Intelligence (BI), ETL, Microsoft SQL-Server (MS SQL), NonStop SQL & SQL/MX (TANDEM), Cobol

6/1998 – 4/2001

Tandem Specialist on a project team developing and supporting a BI Database.
Analysis and Programming for project development phases (TACL, COBOL, SQL, Inspect).
Application Support for the Live system.

NonStop SQL & SQL/MX (TANDEM), Cobol

4/1994 – 6/1998

Team Leader on consecutive projects:
BT Chargecard. Team leader of Application support team on call billing system. Tandem
BT CHIS. Team leader of a Syntegra VV&T (verification, validation and testing) team working on a BT managed client server project. HP Unix.
CCS UK. Leader of a millennium compliance task, and team member of a development and support team on an air cargo EDI switch project. Tandem.

UNIX, Cobol