- Royal Tunbridge Wells, GB
- £20 /hr
- Available now
Technically strong and always hands-on my key skills are in the fields of systems analysis, test data generation and testing. I am familiar with a variety of databases and operatingmore...Technically strong and always hands-on my key skills are in the fields of systems analysis, test data generation and testing. I am familiar with a variety of databases and operating systems and competent with SQL and other programming techniques to collate, analyse and manipulate data.
I have exceptional documentation skills. With a keen eye for detail and the ability to plan ahead my documentation is always of the highest quality, clear, concise and relevant and my abilities in this area encompass producing project plans, specifications and reports.
Working in a team I am confident in expressing my ideas as well being able to sit back and listen to the views of others. A motivated self-starter, I plan and carry out the work I need to complete my assignment and will naturally take the lead on tasks and support others where the need arises.
Of particular interest to me is data and test related work specifically involving systems integration, data warehouses, data migration and data reporting (BI) projects
Area Covered: UK
Job Title: Data/Test Analyst
Description: Countdown II Project ; a real time customer facing information system for London Buses based on GPS, web, mobile and SMS technologies. My roles were specifying design requirements and assisting in the development of BI reports and subsequently developing and implementing the testing strategy for them.
Data Analyst - Reviewed requirements and database schemas of multiple data sources to create the reporting design specifications used in the development of QlikView BI reports. Discussed design with customer with a view to obtaining sign-off.
Test Analyst - Produced the overall Project Test Plan and defined the Reports Testing Strategy. Reviewed the data models for the web, mobile and SMS data channels as well as Remedy and HP OpenView schemas and generated the test data for direct insertion into the databases. Carried out static testing with developers to validate the operation of program code.
Test Execution - Configured and maintained the test environments for QlikView, Oracle and PostgreSQL applications. Performed tests to verify the operation of the defined reports and demonstrated their operation in details to obtain acceptance. Worked with developers in determining the cause of unexpected outcomes.
Job Title: Test & Comissioning
Company: Aspen Clinics
Description: Short term project for the implementation of the IT services at the dental practice belonging to my wife.
Procured, installed, configured and maintained the practice computer system and applications.
Job Title: Data/Test Analyst
Company: Siemens Information Systems Ltd
Description: iBus Project; a major bus management system for London Buses. Using the ETL processes in Service Flow to display and calculate the system KPIs and Metrics my role was to coordinate the data from several internal sources and demonstrate the correct operation of the performance figures.
Business Analyst – Produced the KPI & PI design specifications. Interpreted the requirements and discussed the details with the client and development team to specify the data sources, calculation algorithms, presentation and exception conditions required to produce the report outputs.
Data Analyst – Reviewed the design specifications, determined the relevant test cases and calculated the expected results. Identified the data parameters for each reporting period in the test calendar
Test Analyst – Defined Test Strategy for testing the system KPIs and developed test scripts and produced test data for direct import into Digital Fuel's Service Flow product. Performed static testing with developers to validate the operation of program code.
Test Execution - Executed System Acceptance tests on the test data imported into Oracle, compared the results against the expected results and worked with the developers in determining the cause of any differences. Performed End-to-End testing and validation of the KPIs once the code had been migrated to live.
Job Title: Data/Test Analyst
Company: BT Global Services
Description: London LSP Project, with responsibilities for Data Migration, Reporting and System Testing.
Data Analyst – Performed comprehensive review of the design documentation to establish the strategy for testing the reporting requirements for the Statutory Reporting, Operational Reporting and Statutory Returns (CDS).
Data Migration – Modelled the data migration of users, patients and patient episode data. Executed the migration process, investigated data migration warnings and errors and determined the success of the migration. Defined the test strategy for checking the system operation with data that had been entered at the system front-end as well as migrated data.
Test Analyst – Produced the System and Integration Test Plans to confirm end-to-end sub-system data integrity and flows and to check the operation at the interfaces with third parties (via messaging). Produced System Functional Test Scripts based on Use Cases and Operational Work-Flows in Test Director.
Test Execution - Performed unit and system testing on Statutory Reporting, Operational Reporting and Statutory Returns (CDS) using imported and manually entered data.
Job Title: Test Analyst
Company: Clearswift Corporation
Description: MIMEsweeper for SMTP 5.0, a corporate email scanning and content filtering application.
Test Analyst – Reviewed Use cases to outline Test Scenarios and produce Test Plans and Test Scripts for XML Web Services and security infrastructure. Liased with Developers to identify and resolve testing issues.
Unit Testing – Organised, devised and executed component testing of infrastructure components using a test harness based on C++ and C# class extensions and Perl scripts. Designed the component test harness to validate the operation of the XSL Transform module used to migrate the XML configuration data.
Job Title: Data/Test Analyst
Company: Royal Bank of Scotland
Description: IBBA project, the large-scale replacement programme for the existing Coutts accounting system and full integration with the RBOS system.
Data Migration - Developed SQL scripts as part of the ETL process for generating the customer and account information for insertion into the target system DB2.
Test Analyst – Produced the Test Plans and Test Scripts for the new System Reports. Configured MS-Access integration with Oracle to ensure that the testing was accurate and completed on schedule. Maintained test scripts using PVCS Version Manager.
Test Execution – Defined and performed the post-migration Data Quality Assurance exercise that compared the migrated data in the DB2 database with the source data on the VAX server. Performed the system testing of reports and financial products such as Commercial Loans and Call Deposit as well as Funds Transfers and Foreign Exchange deals and the Online Banking system. Logged and managed defects.
Job Title: Senior Test Analyst
Description: Responsible for the verification of existing and new Liquidity Management Products including: Zero Balance Accounting, Cross Border Sweeping, Interest Reallocation and Money Market Investments
Test Analyst –Identified the Test and Data Requirements based on the User Requirements, Functional Specifications and UML design documents and used this to create the Test Plan, identify Test Cases and write the Test Scripts. Participated in technical reviews of the design documentation and code segments.
Test Execution - Executed unit, integration and system tests. Created strong relationships with the developers and enlisted their help in resolving technical issues. Prioritised the testing according to operational requirements for the End-of-Day processing and account sweeping activities. Performed volume testing of the account sweeping process to confirm completion within the required time frame and recovery testing of investment sweeps caused by missing hand-off files and process interruption.
Configuration Management – Created new builds using PVCS Version Manager. Identified the test hardware and installed the new software releases by upgrading the softbase and front-end applications and implemented schema changes by running stored procedures. Devised and executed regression tests that were executed immediately before and after upgrading the software.
Education Summary: The University of Salford
BSc (Hons) Biomedical Electronics
Manchester Metropolitan University
ACCA Certified Diploma in Finance and Accounting
The Open University
M261 - Mathematics in Computing
M246 - Elements of Statistics
Foundation Certificate in Software Testing
Intermediate Certificate in Software Testing
System Modelling Techniques (with UML)
System Development Essentials
Systems Design & Implementation Techniques
The Chartered Insurance Institute
CF1 UK Financial Services, Regulations & Ethics
CF2 Investment & Risk