Railway Time Table Type Setting various dates throughout 2007 - 2008
At KADFIREData Cleanse Administrator Sept 2006 - March 2007
Collating, analysing and
loading vehicle data for a Vehicle, Van and
Truck hire company, who rent and lease over 7,500 'white vans' and
HGVs.
After purchasing a new 'ERP' type application to replace legacy
applications, they identified many data errors, some very critical to
the legal status of their vehicles.
The project included:-
- Responsibility for creating the process and procedures to successfully implement a data cleanse project.
- Analysing data to identify mistakes and problem areas and raising priority issues to be addressed within the relevant departments.
- Processing and arranging the data for final load into the new application. The prime aim during the project was to prevent any vehicles being on the road illegally, and to change data on the live system without preventing its availability for business use.
PGCE Maths Key Stage 2 - 3 Sept 2005 - July 2006
- IT business analysts.
- Their main driver being to replace expensive ‘inherited’ applications with ‘modern’ package type solutions.
- Support them in discussion with the end user functions, about the business case for their preferred application.
- IT Infrastructure
- Its main driver being to reduce operational costs and efficiently support the new applications.
- Maintain the existing infrastructure as suited to the current skill sets.
- Support the managers of IT Operations to justifying their required investments
- Move all Data communications off private circuits onto VPNs.
- Provision for the hosting of the public web site to the Longbridge Data Centre.
- Provide secure Internet access to all Web based applications.
- Architect suitable infrastructure for the new Vehicle Ordering and Warranty Claims Systems.
- Architect a secure SOHO service for people working from home, and all global roaming workers.
- All user management migrated to a single data source, with authentication via native Windows 2k ADS or LDAP.
- Dual ISP Internet connections via BGP.
- Dual layer of firewalls, each of different technologies Netscreenand Nokia Checkpoint.
- Expansion of the use of the Reverse
Proxies to:
- Terminate all SSL sessions,
- Authenticate the users via central ADS,
- Allow only legitimate URLs through to the Server Farm.
- Client VPNs using Nortel Contivity
- Site to Site VPNs using Cisco.
- Remote user authentication using Active Card and RSA
- Ensuring the configurations of all user authentication was possible via Windows ADS or LDAP.
- Guided web developers to develop their site to work with the Reverse Proxy Technology
- Assisted in problem resolutions to deploy applications securely onto the Internet.
- Obtaining an AS number for the company and getting agreement between two ISPs over the BGP configuration.
- To satisfy the demanding Service Level, the application was installed on 2 four processor Intel servers which ran Oracle 9i RAC. This could be expanded with additional cheap Intel machines should performance require.
- The File system was provided by two EMC CLARiiON SANs, each SAN mirroring the file system of the other. Backup was achieved using Legato and a Silo of DLT and LTO Tape loaders. All of which were connected via 5 fully meshed Brocade Fibre Channel Switches.
- The Web Application was split into 2 layers, the first was 2 servers running Apache which load balanced to the second layer, the second layer having the business logic and Vehicle Catalogue on up to 10 servers, with the Java application for each European Country running on Tomcats, and an ORB to direct the application to which servers were running their language site.
- Several of the services within the Java application were unstable. Extensive testing and analysing enabled the programmers to identify the causes and remove the instability.
- Full 'Gremlin' testing across the whole new Infrastructure to prove the monitoring and problem resolution procedures.
- This application would only run on IBM AS 400s. The Web access was provided by Seagull using their J Walk software. This is a screen scraper off the standard 'Green Screen' application.
- J Walk would not work through the reverse proxies. It relies on its own Java application which required correct configuration to work in our environment.
- Ensured the remote support and Internet connectivity did not compromise the security of the rest of the business applications.
- Implemented Outlook Web Access for Internet view of Email by remote workers.
- Citrix implementation to deliver office applications on UNIX workstations.
- Architected server platforms for Stellent document management system.
- Assisted in the evaluation of contract renewals for Hardware and Operations.