Home
Key Skills
Skills Breakdown
Key Experience
Work Experience
Contact
 



I have been a team leader for nearly seven years now.  I have managed teams ranging in size from just myself to seven people.  The teams have comprised of both contract and permenant staff.  I have had line management responsibility for all members of the teams I have been team leader for.


I have been performing the role of business analyst within the project teams I have managed.  I have been responsible for all the requirements gathering and documenting for the projects I have been involved in.  These activities inlcuded analysis of legacy systems, client interviews and functional and non-funtional requirement documentation.  In conjunction with these requirements analysis functions I have performed customer support at all levels from 1st line customer facing to 2nd and 3rd line bug fixing.  These tasks have led to a large amount of project management skills being utilised.  The final business analyst function I have performed is pre-sales.  This has required me to perform product demonstrations and requriements analysis from potential customers both within the UK and abroad.


I have used SSADM within formal Ministry of Defence project for requirements analysis for over two years.  This involved the generation of Data Flow Diagrams, Logical Data Models and Entity Life Histories for a number of departments within the Ministry of Defence (Navy) Procurement Executive.

I have been using various RAD methods to develop various applications using VB and SQL.  I have always fallen back on using Logical Data Models and Data Flow Diagrams to document and provide starting points for design where contractual requirements have specified the need.

I have started to use UML to document the requirements of a new product being developed to meet the new European Union Emissions Monitoring Scheme.


I have been developing databases for over ten years now.  I have been using Microsoft SQL Server (versions 7 and 2000) over the last 4 years to develop the back end of robust and scalable client server/server applications for the Power Generation sector. 

Use of my extensive Data Modelling skills allowed me to create detailed Logical and Physical data models that reduced the size and complexity of the legacy system data model but still upheld and extended the functiionality required to meet the business needs.

To achieve consistent data verification and formatting, Stored Procedures have been used to control all data transfer from Client application to data tables.  These Stored Procedures made extensive use of Transact SQL, including complex multitable joins, cursors, etc.

To provide an audit trail that would meet Environment Agency requirements Triggers where used to record all changes to each field in the database so that each change could be linked to a user at a specific time.

Data migration from an exisiting Oracle database was achieved using a bespoke translation tool that pulled the data out of Oracle, verified it, and transformed it to the new data structures required before  pushing into the SQL 2000 database.


To support data extraction form recently developed client/server applications extensive use of web technologies has been made.  This involved using Apache Tomcat and Cocoon to host user definable reports using a package called xReporter.

Reports have to be defined in XML to a standard definition and transformed using custom written XLST stylesheets to transform the data returned into HTML pages or PDF documents.


I have been using VB6 for 5 years and VBA for nearly 10 years now to develop a number of applications ranging from small Access single user applications to multiuser enterprise client server applictions using VB6, COM, ADO and Microsoft SQL Server.

I have lead teams of VB6 developers for all of those five years providing expert knowledge and coaching to new team members as required.


I am a competant Microsoft Office user.  I have used Word, Excel and Access to provide workflow applications, making extensive use of VBA to link all these together.


I have had brief exposure to a number of technologies which provides mean with an understanding of thier capabilities and possibilities.  These involve Oracle, Java, J2EE and Apache.  I feel I can pick up and run with any of these at short notice and have proved this in the past on a number of occasions.