Anthony Phipps Email & Phone Number

London Area, United Kingdom

* Provide Business Intelligence data analysis and visualisations for workforce, project management and financial reporting.* Provide data consolidation, transformation and automation tools and methods* Using Power BI, Power Query, Power Automate, Tableau, Excel & Access with VBA* SharePoint site administration

specialising in:PC Windows VB6 / SQL / Excel VBA / Tableau / VB.Net / AccessIBM Mainframe Cobol, DB2, DL1 and CICSThis position encompassess services provided to my clients detailed separately over the equivalent timeframe.

Contract | Reading, United Kingdom

Visual Basic 6 (VB6), VB.Net, SQL Server, VBA in Excel / Access, SourceSafe, Crystal Reports, Micro Focus Cobol* Maintenance and development of pension administration software to comply with FSA / FCA statutory changes including Gender Neutral and Index Linked projections and illustrations* Analysis and development of systems comprising VB6, complex user developed applications written using Excel / VBA, Access, Crystal Reports and other 3rd party processing applications* Full software development life cycle from Business Analyst requirements: Analysis, design, coding, testing, documentation and implementation* Support of upgrade from Windows XP/Server 2003 to Windows 7. Significantly, rewriting and documenting a VB3 application in VB6 (containing TrueGrid and Crystal Reports)* Support, development and creation of a technical manual for a legacy Micro Focus COBOL application

Contract | London, United Kingdom

Visual Basic 6 (VB6 VB5 VB4 VB3), VB.Net, Oracle, SQL Server, VBA in Excel / Access, Argent, ClearCase, Connect Direct* 3rd Line support of Streamline back-end software. This supports merchants, card issuers and internal WorldPay users after credit card transactions have been authorised and processed* Developed logging and monitoring facility to allow quick investigation of failures of scheduled jobs by creating a repository of log files and pre-defined diagnostic SQL results* Responsible for identifying and implementing ‘quick wins’. These high impact tactical solutions ease the most immediate problems quickly at great benefit to the business

Contract | Bracknell

Windows: Visual Basic 6 (VB6), VB.Net, Oracle, SQL Server, VBA in Excel / Access, Micro Focus Cobolz/OS:- COBOL, TSO/ISPF, Rexx, MQ Series• Design, development and support of a VB6 / VB.Net / Oracle / SQL Server based source control and development environment written with OO/COM controls and classes. It includes extensive utilities for QA checking, controlling, moving and analysing code between the PC and the mainframe using FTP and XML, greatly increasing productivity• Act as focal point to co-ordinate with other teams including Operations, DBA, 3rd Party Suppliers, Network, Windows Desktop and Mainframe teams in the UK and Germany.• Provide technical / infrastructure support & training. E.g. research and implement a COBOL / CICS Web Service address lookup application. A prototype was developed with VB.Net with XML / SOAP• Peer review, troubleshoot and provide expertise to other developers for quality and performance. Provide automated VB6 code quality checker to assist visual code checking• Development of centralised and utility programs (like date-routines, common MQ Series interface and programs for external communications e.g. DVLA and Post Office addresses)• Provide interactive Excel VBA spreadsheets for re-organising and analysing raw data. Support and enhance Access databases controlling workflow management

Contract | Bracknell

Development of the International Vehicle Sales system, a location independent system on IBM Mainframe, coding and testing following BMW's strict in-house quality procedures

Worthing. 2nd Contract with L and E.Support and development of Payment Protection / Extended Warranty systemsAdd reporting and statistics gathering to Warranty, integrating DB2 & DLI in Mantis and batchConverted Roscoe/RPF/Librarian based change control system to Endevor

London. 2nd Contract with Nomura.Enhancement of the Securities settlement and Banking Administration systems for Nomura Bank of Switzerland.Design, specification, coding and implementation of Change Control System. Written using CLIST and ISPF Dialog.

Worthing. Contract.Development of new Extended Warranty system.Convert single segment DLI programs to multi-level DB2/DLI.

London. Contract.Developing a system to administer loans, deposits (including fiduciary) and forex deals.Installing and testing in Switzerland to satisfaction of end user.

Camberley. Contract.Design, development, and testing of CLOAS (Life and Pensions admin system) from client's requirements. (e.g. Annuity and Tax Exempt Savings Bond

Farnborough. Contract.Convert CICS / DLI / VSAM system to MANTIS / DLI and provide ongoing support.

Redhill. Permanent.Development and technical / sales support of CLOAS (Life and Pensions admin system) product.

Gillingham. Permanent.Production system support and development for Payrolls, Stock control and financial database.