Jim Cameron



Jim Cameron

PERSONAL DETAILS Updated: 1st December 2019

Contact mail@jimcameron.co.uk

Mobile: 07760 455819

Seeking Test Lead/ Test Manager Contracts in Edinburgh.

Key Skills Strong on strategy, experienced on many platforms (Offhost, Mainframe, Web). Extensive Technical knowledge, gained mainly in Banking & Insurance. Good NFT and ETL experience (Informatica and Datastage). Agile and Waterfall.

Tech skills: Jmeter, Gatling, Loadrunner, Performance Center, Fitnesse, Rest API and Jenkins, SQL Linux/Bash Shell script, ALM (Quality Center), MQ, Java (Junit3, Eclipse) , VBA(excel), Awk, IBM Mainframe (Clist, ISPF, JCL, Focus BI, Rexx ,Fortran, Cobol). Clouds: Amazon AWS, Hadoop.

ISTQB (ISEB Practitioner). Fluent German & French. Degree BSC Physics.

WORK EXPERIENCE Latest first. References available on request

NFT experience; 2 years at RBS, 1 year at NRS (Census) and 1 year at IBM.

Automation & Agile: 3 years at RBS, Maersk and BskybB.

Technical Analyst National Registry of Scotland (Census) Edinburgh Jan 2019 to Nov2019

Built test plans and specified tooling, execution for the 2021 Scottish Census and a Rehearsal in October 2019. Jmeter and Gatling.

• Co-ordinates with multiple suppliers (CACI, APS,CFH, PPS)

• Specified Master NFT plans and system NFT plans

• Arranged 1.6 million items of test data in AWS (Amazon Cloud)

• Wrote and executed NFT test cases in Jira

• SQL (SQL/Developer) written to generate data.

• Technology: AWS, Jmeter, Gatling

Test Lead RBS Personal and Business Banking Edinburgh ` Mar 2016 to Sep 2018

Led the testing of new Credit Cards functionality to Customers (Paperless statements, Instalment Lending) delivered via Internet Banking and the RBS Mobile app. Initially a hands-off role which became more technical as issues were resolved. Agile methodology (BDD)

• REST services testing via SOAP/UI

• NFT of IBM's TeaLeaf package using Performance center/Loadrunner + metrics.

• Co-ordinated with multiple departments within RBS (CCI, eBanking, Data & Analytics, Accounting AI, Datapower, Signing Service, Mobile).

• Co-ordinated with external partners: TSYS, Infracast.

• Designed, built and executed Test cases within P3M/Agile

• Built a metrics reporting suite using Excel VBA and SQL(Against QC)

• Built test Data collections, synchronised across many platforms.

• Managed dependency lists, Defect triage, traceability, Test design and case building.

Technology: Cloud(Hadoop), Performance Center / Loadrunner, Jira/Zephyr, Quality center, excel VBA, Mainframe Z/OS, Excel VBA, Citrix

Test Lead RBS Data & Analytics Edinburgh ` Feb 2015 to Feb 2016

Test lead in RBS's Data & Analytics department, responsible for Data Quality (DQ). Data from a sample of 50 source systems we assessed using 1000 Rules running under Informatica's IDQ. Results, and Reference data captured by an Oracle/Apex front end, were transformed and loaded to a DataMart, and analysed by Qlikview reports. ETL and Housekeeping were performed by Informatica's Powercenter.

Key Responsibilities:

• Led a team of 4 test Analysts to specify and perform System Testing and SIT (Integreated Testing) and Non Funtional testing (Performance Center, batch)

• Defect Management

• Built an Excel comparison tool using VBA

• Used SQL (Oracle) to automatically compare results of ETL (Powercenter) againsdt source using Union and 'casting out pairs'

• Build a mainframe file parser using VBA

• Security cleared to work with production data.

• Automated comparison check on 1020 ETL transformations by SQL(union + pair suppression) driven by spreadsheet.

Technology: Informatica Powercenter, IDQ, Powerexchange, Linux Bash/ Awk, Vi, HP/SA, Scp, sftp, Connect/Direct, Mainframe Z/OS, Excel VBA, Citrix

Test Lead Maersk Line IT Copengahen & Glasgow ` May 2012 to Aug 2014

Master Data Management project Informatica-based, both ETL and Real time. Led a team of 4, Built and ran tests, Created an Automated test envirionent and pioneered use of a tool (Fitnesse) . MI/BI using Teradata and SQL. Reporting to Stakeholders + Metrics.

• Automated ETL testing using Fitnesse + Firlibraryweb (DBFit)

• Automated REST testing via SOAPUI and Fitnesse.

• SQL written to encode source and target transformations/ filters / sampling so that Fitnesse could automatically execute and compare.

Technology: Informatica Powercenter, Hub, Realtime, IDD. Java Jboss JMS MQ Oracle DB, Oracle BPM. Agile BDD VersionOne. SAP Vendor, Financials. Quality center, GIT. Subversion .PERL SQL Developer. Fitnesse FitLibraryWeb Teradata Dbfit. Soap-UI web services. QTP. XSLT Xpath XML. QC, Jira

Automation Test Analyst Agile BskyB Livingston Contract Oct11 to Feb12

Reworking of CRM Chordiant & Arbor billing. Pair Programming Agile TDD. Junit4 framework via Webdriver, Selenium RC (Java and Python). Continuous Integration testing (Jenkins). Java and Python

Key Responsibilities:

• Design, build & run automated Web scripts Selenium & Fitnesse (Spider).

• Server side testing with Fitnesse (FIT) using a REST API.

Technology: Fitnesse Fit, FitLibraryWeb Dbfit Selenium Chordiant CRM Arbor Billing . Jenkins, Javascript, Atlassian Jira and confluence. Quality Center GIT Subversion Java Ruby Apache Oracle Toad SQL Developer Java Beans Eclipse Maven Ant. QC, Jira

Senior Test Analyst UAT + Migration Tesco bank Edinburgh Contract Sep09 to Aug11

Very large scale v-model ETL/Data Migration of Credit cards and Insurance from RBS to TSYS, and Mainframe/Vsam to Oracle 10i, Integration with multiple third parties. Claims & policy data transformation for Home, Motor, Pet.

Key Responsibilities:

• Script design and execution, Financial reconciliation.

• Data Transformation and refresh (claims) using IBM Datastage.

• Defect management – Defect analysis - using Quality center

• Built Data Obfuscation tools using IBM Datastage and Unix awk.

• Built testing tools to parse and compare files across systems.

Technology: Mainframe IBM, Cobol. DB2 SQL. Data Warehouse SAS IBM Datastage, Oracle, Toad, Excel, MI (SQL), XML, Oxygen, Xsd, Schematron, PGP , Javascript, MS Access 2010, Redhat Linux, VBA, Awk, Python.

Test Manager SHL Surrey Contract Dec 08 to Jun 09

SHL deliver web based cost effective e-procurement, and other psychometric testing to blue chip clients worldwide.

Key Responsibilities:

• Delivered Data Migration Testing and UAT on 4 projects simultaneously.

• NFT (Loadrunner) on SHL's profiling web site

• Performance testing of Web applications

• Managed Automated regression testing on 4 environments.

• Brower/OS compatibility testing on 15 environments.

• Project Management: Defect Management and supplier management (x4)

• Matrix Managed a 22-strong offshore team (Hexaware, Chennai).

NFT Consultant Welsh Govt, Cardiff Nov 08

Prepared a feasibility study into load testing a documentation database for the Welsh Government.. A challenging architecture (SOA, CORBA/IIOP)

Key Responsibilities:

• Assessed the feasibility of tools including Loadrunner, Borland Silkrunner, IBM Facilita, Compuware, and others.

• Assessed Vuser types including Java, Web, Sockets, Web services & Orb.

Test manager IBM Edinburgh Permanent Oct 06 to Sep 08

Initially Telelogic but IBM took over. An Agile (BDD) software house, the market leader in Requirements Management (RM) producing Doors, Web Access, and Focal Point. Agile development similar to Openup. Successfully delivered nine projects in 18 months, typically two in parallel, maximum six.

Key Responsibilities:

Responsibility for cost estimation & delivery of Testing on Web services and SOA systems.

• Introduced Structured test design methodology (ANSI/IEE based) and risk assessment.

• Managed Performance testing (Loadrunner) and Environment setup. Forecasting live user behaviour from Web Logs.

• Line Management of all testing staff including other TMs. Total 32.

Test Lead SYS&UAT RBS Edinburgh Contract June 05 –Sep 06

Ran testing on two large Connex v-model projects to integrate Ulster Bank systems into RBS Group. Data Migration of accounting and ATM warehouses.

Key Responsibilities:

• Credit Card testing with third parties: TSYS, Mastercard and Visa

• Detailed ISO8583 messaging tests with third parties.

• Delivered test phases: Online Connex Testing, System Test, UAT.

• Tested with International Payments, Back Office/Core Banking / Ledger / MI / BI (Focus)

• Led a small expert team (3)

• Compliance testing with external organisations: TSYS, Mastercard and Visa.

Technology: Connex TCP/IP IBM mainframe Z/OS and OS/390 SQL SPUFI JCL COBOL. Tandem/Base24 Test Director PVCS-Tracker CICS DB2.

Previously : Test manager at Abbey (Santander) 1year, at Test Consultant at Tesco Bank 18 months, Test Lead RBS where I built the e-Banking NFT platform using Loadrunner, Test Manager at RBS ATMs (9 years), Lloyds (Scottish Widows), NHS, Reuters, Willis Faber. British Telecom, Jaguar Cars, Hill Samuel.

INTERESTS

Cycling in clubs & with friends. Hill walking with friends.

Language studies + socials with informal groups.

END OF CV

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download