Jim Cameron
PERSONAL DETAILS Updated: 5th September 2018
Contact
Mobile: 07760 455819
Phone+fax: 07092 122636
Seeking Test Lead Automation Contracts in Edinburgh.
Key SkillsTechnically able, strong on strategy, experienced on many platforms (Offhost, Mainframe, Web). Extensive Technical experience, mainly in Banking & Insurance. Many-at-Once or Single projects, Waterfall and Agile.
Testing teams benefit from understanding of architecture and technical know-how.
Qualified ISEB Practitioner. Fluent German & French. Degree BSC Physics.
Business Experience
/ Years /Methodologies
/ YearsBanking / 10 / Insurance / 4 / Know the Ropes RBS / 3 / Prism / 3
Environments / 3 / Telecomms / 5 / CMMi / 2 / Know the Ropes RBS / 5
Government / 5 / EFT / 8 / V and W-Model / 6 / BCS Critical Testing / 3
Data Migration / 5 / Agile TDD/BDD / 3 / Ansi/IEEE 829 / 3 / MI/BI / 8
WORK EXPERIENCELatest first. References available on request
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 NFT (Loadrunner, batch)
- Security cleared to work with production data.
- Designed, built and executed Test cases within Agile TDD
- Built Automation tools including a database comparison (SQL) and Spreadsheet comparison (Excel VBA).
Technology: Informatica Powercenter, IDQ, Powerexchange, Linux Awk, Vi, HP/SA, Scp, sftp, Connect/Direct, Mainframe Z/OS, Excel VBA, Citrix
Test Lead Maersk Line IT Glasgow & Copengahen `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.
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 BskyB Livingston ContractOct11 to Feb12
Reworking of CRM Chordiant & Arbor billing. Pair Programming Agile TDD. Junit4 framework via Webdriver, Selenium RC. Continuous Integration testing (Jenkins).
Key Responsibilities:
- Design, build & run automated Web scripts Selenium & Fitnesse (Spider).
- Server side testing with Fitnesse (FIT) using a RESTful API.
Technology: Fitnesse Fit, FitLibraryWeb Dbfit Selenium Chordiant CRM Arbor Billing . 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 TPF Edinburgh ContractSep09 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.
- Server side testing of transformations including Premiums.
- 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.
UAT Test Manager SHL Surrey ContractDec 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.
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).
Quality Center v9.0 for tracking execution and managing defects.
Technology: C#, Apache, HP Loadrunner, SQL/Server, IIS, Windows XP+2003+Vista, Windows 7, QuickTestPro, Quality Centre, VirtualPC (similar to Vmware).
Performance Test 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.
Built basic Socket-level scripts using TCP-IP knowledge..
Test manager IBM Edinburgh PermanentOct 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.
Line Management of all testing staff including other TMs. Total 32.
Used Quality Center v9.5 for building and executing test cases, tracking to requirements, and managing defects.
Technology: ISO9001, Java, C#, Weblogic, Oracle, Toad, VIA/Webspher/MQ, XML Spy, Windows XP+2003+Vista+2000+NT, , Solaris, Redhat Linux 4/5, Synergy, Oracle, Citrix, Loadrunner, Winrunner, QuickTestPro QTP, Quality Centre, Vmware. Integration partners: Quality Centre, Rational Clearcase, Clearquest, Rose. Installshield.
Test Lead SYS&UAT RBS Edinburgh ContractJune 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 ISO8383 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.
Test ManagerAbbey (Santander) Glasgow Contract Nov 04 – May 05
Three Back Office projects in Glasgow: Child Trust Fund, Guaranteed Investment Bond, and Depolarisation (Life/Pensions).
Key Responsibilities:
Delivered 3 projects’ multiple test phases: 5xSystem Test 2x Performance Test, 1xUAT 3xUsability, Regulatory reporting (with Inland Revenue).
Prepared Strategies, plans & delivered scripts. Performance Testing.
Defined test requirements and environments; Managed defects; Matrix Managed test teams up to 6 strong including an offshore team.
Defined and captured metrics and presented to stakeholders.
Technology: Quality Center, Java J2ee; Co-Stars (Third Party accounting), Performance Center and Loadrunner, Prism VC++, Websphere, Siebel One-on-One + Tuxedo off host talking to IBM/OS 390/Cobol/Adaba/Natural/DB2 .Net Windows 2003. Loadrunner TSL Winrunner. Java I-Shell. Business Objects.
Test Consultant TPF (Tesco Bank) Edin. 18 months ContractMar 03 – Oct 04
Responsible for the quality of testing across TPF Technology, both Internal and External (Credit Cards, Banking, Life, Pensions, Loans,). V-model methodology. Mentored the Development team to plan and execute the testing.
Key Responsibilities:
QA and signoff test plans, deliverables and results for TPF, 3rd Party projects. Payments via Swift. Tested through to Core banking /MI.
Browser compatibility testing.
Performance Testing and Automation. Loadrunner, Web vusers, ‘C’ scripts.
Technology: Use Cases, Offhost (Websphere, .NET Windows 2003, Object Oriented,Oracle Chordiant CRM Apache Sun Solaris Java J2EE) with CTG to connect to Mainframe host, and Business Object & focus for BI/ Data Warehousing. TCP-IP all levels. Mercury Loadrunner, Quick Test Pro QTP, Test Director .PVCS Microsoft IIS SQL Server. Batch ETL, Migration.
Mi/BI Support Analyst Newell & Budge Edin. Contract Sep 02 – Feb 03
Not a Testing role – a B.I. support job owing to interesting market conditions. 3rd level support for FOCUS and DB2, JCL, COBOL, SPUFI, VSAM.
Technical Test Lead RBS Internet Banking Contract Aug 02
Managed Performance Testing & other technical testing in RBS Internet banking, all-phases test of mobile WAP Banking system and its integration with NatWest. Performance Testing of and its connection to the mainframe host in a Model Office environment.
Key Achievements:
Mobile Banking Service (WAP) V-model: Test Strategy, Data set up, Test case Specification, Managed System test and Performance test. MI using Focus. Payments via Swift, testing with Core Banking and Back Office.
Performance testing of Internet Banking HP/Loadrunner
Technology: Web, Loadrunner, Winrunner/QTP, Test Director, Mobile Internet, WAP, Offhost (Microsoft Web Servers IIS, App server C++ Objects, SQL/Server; OS/2 connection to OS/390 mainframe host. Test Director PVCS Tracker. Batch ETL, Migration. JCL COBOL SPUFI VSAM DB2.
Previously : 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
CVJim Cameron1/4