CV/Mission de Consultant AUTOMATION ANYWHERE freelance

Exemple de missions de Stephen,
Consultant AUTOMATION ANYWHERE habitant ?

April 2021 – June 2021
Triad Consultancy

I completed an Ingres database housekeeping project for Areen Design of London via Triad.

December 2018 – October 2021
Office for National Statistics – Newport Wales

Recent projects

I have completed several ad-hoc project based pieces of work for ONS. I have just completed an upgrade project from OpenROAD 6.2 to 11.1.

March 2014 – present
Version 1 Dublin working on the Transport Systems team

Recent projects

Recent work for Version 1 has involved upgrading the OpenROAD version from 6.2 to 11.2. The 6.2 version is out of support. In recent years I have mostly completed ad-hoc project work.

Senior Ingres consultant

Work Completed so far

ABF – The Department has a database Performance Monitoring system pointing at the live Ingres databases. This was written in ABF many years ago, my remit was to enhance the system and provide new functionality, to allow the user to identify locks on the database and be able to remove them if needed.

OpenOffice – Openoffice is being integrated into the departmental systems as a replacement for Microsoft Word. My first assignment was to work out a way that the software could be used to replace current Standard Letters used by the department using mail merge. Development was completed in OpenRoad coding and macros written in the OpenOffice documents to achieve this, giving the client an open source reporting tool.

OpenRoad – The Vehicle application has had to be modified to move from a ‘fat’ client environment on Windows XP machines to Citrix servers. This required a major change in the way reports were printed and also the location to where the output files were stored. The local C drive was referenced and accessed in many areas, this would not work on the Citrix server as the C drive would not be inaccessible. Each user now has a Home drive to store information. Ingres Reporter reports now save the formatted information to a file on the H drive and a new DLL along with recoding existing OpenROAD code now sends the file to a named printer.

Database – All of the Ingres installations have either been upgraded from 9.2 to 9.3 with an additional installation of Patch 14624, or are in the process of being upgraded. It is part of my responsibility to help with these upgrades, installing the new software and testing known issues being addressed in the upgrade. A range of DBA tasks need to be completed or QA’d before each release, I take part in both of these tasks.

All of the installations have subsequently been upgraded to Ingres 10. It was my responsibility to phase in the many test and production servers over a period of 3 months.

Testing – I am responsible for test strategies and the delivery of test matrices for Unit, System and to a degree, User Acceptance Testing.

Release Management – The applications require deployment when fully tested, it is my responsibility to ensure that all release documentation is completed and relevant application files are furnished to the party responsible for the deployment to UAT and Production. This can include co-ordination with other parties, mainly the client I.T department and other external suppliers such as Fujitsu and Eir. A high degree of organisation and technical knowledge is required to deliver the end-to-end project.

Service Delivery – For the past 5 years I have been responsible for the service delivery of all OpenROAD and Ingres application products for the Department of Transport. There has been a lot of development work and upgrades during the period that I have delivered to a high standard and within software development standards and guidelines. Working for a software company means that I have been a generalist and take active control of a project life cycle.

July 2008 – March 2014
Revenue Commissioners, Dublin (Accenture)

Principal Ingres/OpenROAD consultant

Project Management
We use Microsoft Project to set project milestones and monitor progress on software to be delivered to the business. At the moment I am part way through a project to change the format of all of the customer numbers for taxpayers in Ireland. This has involved drawing out a project plan, deciding on skill resources and staff numbers required. Liaison with the business to analyse their needs and working closely with the Project Board to make sure we are on target with the project and to address any concerns they might have. This is a complex system environment using multiple skill sets that must communicate to create a working system. We used OpenRoad GUI, Ingres Database, Pearl Scripting, C, Unix Scripting and Java for this project.

Software Development
Work to date has involved working as part of the AIM team in Revenue Commissioners. This team is responsible for Interventions that pursue taxpayers for money owed to the Revenue. These are large and complex systems and development is of a RAD nature with emphasis placed on swift coding, testing and delivery. The object model is complex and can be difficult to change or add to, so the role has been a challenging one. The position requires me to analyse, document , code, test and deliver a product to the Caseworkers and the Revenue Solicitors Office. The reporting tools are Word with delivered bookmarks and macros, an HTML reporting method and Crystal Reports 10 querying an SQL Server and an Ingres database. The use of external objects is extensive throughout the systems.

I have just completed a new Compliance system for Relevant Contracts Tax, Premium Tax and Value Added Tax to allow for the prosecution of Late and Non-Filers in the taxation system. A taxpayer will be sent a Warning Letter, then a Certificate and then the record is passed to Revenue
Solicitors Office to have the Summons printed and issued. This system will bring a considerable amount of revenue in tax penalties in the future.

Testing
Test strategies and test plans are required at unit test, integration test and system test stage of each project. There are many bug recording software sets out there and I have used a variety of these to both record the problem and correct the issue.

Release Management
The user receives new software via an automated system we have written in Visual Basic. This downloads all components needed for the end user to click on an icon on their desktop to access the newly delivered system. This requires co-ordination with the client I.T. Services department and full knowledge of their release processes and what they expect to receive. The onus is on me to deliver a one-click deployment process.

Database
Database changes are generally required for each release. It is my job to write the SQL scripts to make these changes and ensure that they are delivered to the live database when the system is released. I completed routine DBA tasks as standard and as required, database optimisation, configuration changes, data backup and recovery.

Mentoring
My work history has always included mentoring experienced and inexperienced staff alike and deciding on their training needs.

April 2008 – July 2008
Office for National Statistics in Newport, Wales

Senior Ingres/OpenROAD consultant

Conversion and Upgrade
ONS has been an Ingres/OpenRoad site for approximately 10 years and was running on Ingres 2.0 and OpenRoad 3.5. They had 10 separate survey systems in ten different code bases. It was my job to upgrade their OpenRoad 3.5 to OR2006 and plan the OR2006 deployment and movement to Ingres2006. I converted all ten separate systems to OR2006 and migrated them to a single code base to aid future development. During this period I also completed some OR2006 projects and trained the permanent staff to code in a more object orientated and efficient manner. This position involved full life-cycle development, from analysis to development, to database work, to delivery. The reporting tool is Crystal Reports 10, querying data in a SQL Server database and an Ingres database using ODBC drivers.

November 2006 – April 2008
IBM in Dublin

Senior Ingres/OpenROAD consultant

My role in IBM is that of a senior Ingres consultant. The primary project was to enhance the Motor Tax Office back office system to support Motor Tax Online transactions. From early 2008 garages will be able to change vehicle ownership online and Gardai. Local Authorities and Private individuals will be able de-register the car as End-Of-Life. This project touches the majority of the systems involved in Motor Tax Online.

Development
Initially my involvement was in the High Level Design, Component Modeling, Data Modeling and detailed
Design phase of the Ingres part of the project. I then managed the development phase, coding in OR, unix scripting, ABF and reportwriter. We had upgraded to Ingres 2006, so some time was spent testing this as well.

Delivery
This system was delivered nationwide in Ireland using IBM software delivery methods. My role here was to make sure that the many system components were packaged correctly and delivered to the team responsible for the rollout.

Database
Database changes were required for the enhancements as well as database modelling for new functionality. It was my job to write the SQL scripts and plans to make these change happen and ensure that they are delivered to the live database when the system was released. I completed routine DBA tasks as standard and as required. The systems that I worked on required the use of Replicator and the automation of batch job scripts to run during system down-time. Quality assurance was required on SQL before it was ran into the production database, it was my responsibility to complete this task.

Mentoring
I received 3 trainees lacking in any of the software skills required to complete their roles in the team successfully. I trained them in the software skills and gave them work as varying degrees of difficulty as the project progressed to make...