EXPERIENCE
Senior Database Analyst, Lockheed Martin (SC Cleared) September 2012 – Present
Operating Environment: Microsoft Windows XP/NT/7, AIX 6.1, Oracle 11g, Developer/Designer 2000, PL/SQL, SQL, Oracle Apex, Toad, SQLDeveloper
Responsible for PL/SQL development and maintenance of ad-hoc reporting functions to support major UK client. Investigation and analysis of database related issues that may result in failure to meet customer SLAs. Point of contact between customer, service desk and technical areas of the organisation.
Senior Database Developer, DSTL (SC Cleared) May 2008 – September 2012
Operating Environment: Microsoft Windows XP, Oracle 11g, Developer/Designer 2000, PL/SQL, SQL, Oracle Forms 9i, Oracle Reports 9i, Oracle Apex, Toad
Responsible for providing specialist development and support functions for bespoke software utilised in Radiation dosimetry records, radioactive isotope record keeping & Nucleonic instrument services.
Technical achievements included the design and development of a new database system for seamless integration of a new radiation badge type in to the radiation dosimetry record management system and design and development of a new database system to enable planning and monitoring of scientist visits to various establishments holding radioactive sources. Research work involved feasibility studies for migration of current oracle forms based systems to web based systems utilizing Oracle Apex and integration of documents into current database systems (via C/BLOBS).
Technical Business Manager, Ordnance Survey Sept 2001 – May 2008
Operating Environment: UNIX, Microsoft Windows 2000/XP, Oracle 8i, Developer/Designer 2000, Mapinfo/Mapbasic 6.5, PL/SQL, SQL, SCCS, Microsoft Access, Microsoft Visual Basic 6
Managed a team of 4 responsible for maintaining IT systems concerned with ensuring quality and supply of geospatial data. Provided technical input into decision making processes including requirement gathering, attending project meetings and end-user liaison.
Technical duties included development and maintenance of applications primarily using Oracle Forms, embedded Oracle package/procedures (SQL), UNIX scripts and MapBasic. Achievements included development of an error management and reporting system within an Oracle Forms based application resulting in a considerable reduction in the number of user support calls due to increased robustness of the system, and the replacement of a ‘flat file’ based geospatial data system, with an Oracle database driven system which resulted in greater processing efficiency and improved reporting facilities.
Team leading duties required planning and co-ordination of team effort and reporting to higher level management on a regular basis. This required the allocation and monitoring of tasks, planning projects and end-user liaison. I was also responsible for staff development and performance management within the framework of the organisations staff performance and review procedures. Achievements included successful end of year staff reviews using a new performance management system introduced to the organisation and the management of staff performance/disciplinary issues.
Senior Analyst / Programmer, Fortek Computers Ltd May 1997 – Sept 2001
Operating Environment: Oracle ( v7.1 – 8i ), PL/SQL, SQL, Ingres v6.4, Micro Focus Cobol, UNIX (AIX, UNIXWARE, DRS/NX SVR4, DGUX,), VMS, Microsoft Windows (3.11, 95/98 and NT), MS-DOS, VMS Cobol, SCCS, Microsoft Access, Microsoft Visual Basic 6
Involved in development, maintenance and documentation (to ISO 9001 standard) of operational information systems for the emergency services, developed using Micro Focus Cobol, Oracle and Ingress across a wide range of hardware platforms all operating under a UNIX environment.
Other duties included, temporary support desk manager and responsible for client liaison and management of junior members of staff and DBA tasks.
Main achievements included implementation of an incident review system for police services enabling users to perform detailed searches using a wide range of selection criteria and to view comprehensive details and played a major role in the conversion of database systems to millennium compliance, requiring conversion of data and code, as well as full system testing.
Involved in the development of a number of utilities for the transferral of data between UNIX based systems and Microsoft Access databases using Visual Basic 6, and the development of a web based Incident viewing system including WAP technology.
M.I.C.S Analyst/Programmer, University of Southampton Dec 1995 – May 1997
Operating Environment: Hewlett Packard, Sequent, PC, UNIX (LINUX), MS-DOS, Novell, Microsoft Windows (3.11 & 95), Ingres v6.4, 4GL, Report-Writer, COBOL, SQL, Raisers Edge, SCCS
Responsible for maintenance of legacy student records system running on HP hardware, and development of related applications. Also responsible for development and post implementation support of new student records system running in a UNIX environment. Also responsible for planning, developing and implementing a fund-raising database system for the University alumni office.
Major achievements included development of a student registration and library card distribution system, whereby student registration details were entered and various course details would be provided by the system – in particular, timetables could be calculated and any clashes reported, and unique registration / library cards could be issued.
I was also responsible for the 1996 exam grade / HESA reporting system whereby student’s exam results were calculated and a number of statistical reports produced. The system also produced exam result notification letters.
The post was for an initial period of 1 year, and was extended by a further 9 months.
IT Centre Analyst/Programmer, NM / Friends Provident / Hoskyns Aug 1990 – Dec 1995
Operating Environment: VAX, PC, VMS, Microsoft Windows (3.11, 95), OS/2 Warp, MS-DOS, VMS COBOL,
DELTA, R-Base RDBMS, SQL, Commander EIS, One-up
Analysis and development of financial systems for the life assurance industry and development of database systems. Other duties involved use and knowledge of a number of PC software applications, and provision of development and maintenance for end-user PC workstations, which included both hardware and software support.
Major projects involved development of financial reporting systems, developing and implementing several major database applications and development, implementation and support of a major EIS system. I was responsible for assessment and specification of software and hardware requirements, development and maintenance of the system including network functionality and, once implemented, providing end user support which included installation, upgrading and repair of both PC hardware and software and to provide assistance to users.
Programmer, Ordnance Survey Jan 1989 – Aug 1990
Operating Environment: ICL 3960, VME, COBOL, Gospil, IDMS, IDMSX, MS-Basic
Developed a number of interface programs between an existing sales ledger database and a new software package (MERA). This included writing specifications, developing and amending programs and end user liaison.
Also made enhancements to an existing TP security system to provide increased security and to log access violations, and dealt with a number of aspects of the day-to-day running of the system. Also developed a number of PC applications.
Clerical Officer, WJEC Aug 1988 – Dec 1988
Semi-Skilled Operator, Marconi Electronic Devices Aug 1981 – Aug 1982
Trainee Storekeeper, Marconi Defence Systems Aug 1980 – Aug 1981
EDUCATION:
1994 – 1995: University of Portsmouth Post Graduate Certificate in Information Systems.
1986 – 1988: Polytechnic of Wales Higher National Diploma in Business and Finance
1982 – 1986: Highbury College of Technology Ordinary National Diploma in Business and Finance
ADDITIONAL QUALIFICATIONS: NVQ Management Level 3
IT TRAINING:
Basic SCL 1 week January 1989
ICL VME COBOL 1 month February 1989
Batch processing using application master 1 week June 1989
DEC COBOL 2 weeks August 1990
Introduction to VMS 1 week August 1990
Intro to WordPerfect, Wordperfect Office, Planperfect 3 days January 1991
Introduction to One-Up 1 week March 1992
W/Information Gateway PC/Mainframe Comms 1 week March 1992
Commander EIS 1 week April 1992
DELTA foundation course 1 week June 1993
DBMS 2 weeks June 1993
Introduction to APEX 1 week December 2011
ITIL Foundation in IT Service Management 1 week November 2013
OTHER EXPERIENCE
Extensive practical knowledge and experience of PC’s and peripherals (including software)
PCSA Networking
R:Base (32 bit DBMS) SQL
Microsoft QuickBasic
Microsoft DOS, Windows V3.11,Windows 95, Windows NT, Office
PMSC Series III Analysis & Design Methodology
NMDM (Development methodology based on DMR P+)
Lifespan (Project management)
IDMS, DDS, GOSPIL, QUERYMASTER and SCL
