Lion Analyst Programmer
Magnet Ltd
Keywords
Skills
Unisys Mainframe, A-Series, SEQUENT, NX, LINC 16.3, LDA 3R2 & EAE, Oracle SQL Server Management Studio 2005 / 2008, UNIX, DMSII, Exec 8 WFL, Unisys JCL / WorkFloW, VB Script, UFSS, UNISURE, URBIS LINCLITE, Crystal Reports, PL/SQL, Oracle SQL, RT Query, NET Framework 3.0 LION6.net, SQL Server 2008 Business Objects 6.5, Microsoft Visual Studio 2010 / TFS, Team Foundation Server, COBOL 74, SAP, EDI, Windows NT servers, databases, SQL, VB Scripts, ISIS, Test Scripts, Excel, PL/SQL Developer, Oracle database, User Interface, Java foundation architecture, SQL Server Management Studio 2008, database, TRAC, Micorsoft TFS ( Team Foundation Server, Visual Studio 2010, C#, frontend, Eclipse, Jira, Java, Hybris, backend, UAT, Q+E Database Editor, LION 5.3, LINC 16.2, xml, xsd, dtd, IBM Rational Clearquest, excel spreadsheets, Functional verification, IBM Websphere, Document management, PVCS, Rational RequisitePro, Rational Clearquest, C#.NET, Microsoft .NET Framework, Visual Studio, ASP.NET, SQL Server 2005, SQL Query Analyzer, SCORM, Oracle 6g, Oracle 10g, TestDirector, Rational ClearCase, coding, unit testing, system testing, Unisys LINC, WFL, NT LION, mainframe, ERGO, LINCLITE, LION 5.1, Microsoft SQL 2000 Query Analyzer, pages, Biztalk, LDQ, Test Director, ACCESS, Acclaim, Version Control, spreadsheets, functional specifications, SQLplus, Release Management, RSA, IMS, System design, software tools, COBOL, TEXAS INSTRUMENTS, JCL
Project history
12/2014
-
08/2020
support and decommissioning & migration function. Major deliverables included designing and
developing a WEB based portal for an external client as well as an EDI orders load feed for the
increasing business channel of Independent vendors. The environment constituted LION6.net running on
Windows NT servers, databases were interrogated using SQL & RT Query and jobs scheduled via VB
Scripts.
developing a WEB based portal for an external client as well as an EDI orders load feed for the
increasing business channel of Independent vendors. The environment constituted LION6.net running on
Windows NT servers, databases were interrogated using SQL & RT Query and jobs scheduled via VB
Scripts.
06/2014
-
11/2014
QA Test Analyst
HP Enterprise Services
QA Test Analyst - Project scope was governed by the requirements of Interconnector UK (IUK) who own
the gas pipeline which links the UK with Europe. The Interconnector Shippers Information System
(ISIS) manages and audits the transfer of gas. Test Scripts were derived from Functional
Specifications as well as SME briefings and anomalies logged manually within Excel. PL/SQL Developer
was used for Oracle database manipulation.
the gas pipeline which links the UK with Europe. The Interconnector Shippers Information System
(ISIS) manages and audits the transfer of gas. Test Scripts were derived from Functional
Specifications as well as SME briefings and anomalies logged manually within Excel. PL/SQL Developer
was used for Oracle database manipulation.
10/2013
-
04/2014
Test Analyst
DNV GL ( Noble Denton )
Test Analyst - This project scoped requirements from South Hook Gas ( SHG ) to provide an Energy &
Capacity Management System ( ECMS ) based upon DNV GLs' core Product Access Manager ( AM2 ). Test
Scripts were derived from Functional Detailed Specifications ( FDS ) which were 'fine tuned' during
subsequent exploratory tests and liaison with developers. User Interface screens were developed
using Adobe Flex overlaying a Java foundation architecture. SQL Server Management Studio 2008 was
used for database queries and defects logged via TRAC.
Capacity Management System ( ECMS ) based upon DNV GLs' core Product Access Manager ( AM2 ). Test
Scripts were derived from Functional Detailed Specifications ( FDS ) which were 'fine tuned' during
subsequent exploratory tests and liaison with developers. User Interface screens were developed
using Adobe Flex overlaying a Java foundation architecture. SQL Server Management Studio 2008 was
used for database queries and defects logged via TRAC.
07/2012
-
07/2013
QA Test Analyst
Univar / NMQA
QA Test Analyst - This project scoped Univars 'Q' Pricing solution which was subject to a software
upgrade in tandem with a global migration, a migration of regional pricing solutions onto 'Q'.
Development followed an Agile methodology with daily Scrums, Sprints were governed by Stories,
Issues and Acceptance Scripts maintained within Micorsoft TFS ( Team Foundation Server ). Using a
Microsoft Visual Studio 2010 C# .net frontend, SQL Server Management Studio 2008 was used for
database queries and functional requirements were collated in HP Quality Centre for regression
purposes.
upgrade in tandem with a global migration, a migration of regional pricing solutions onto 'Q'.
Development followed an Agile methodology with daily Scrums, Sprints were governed by Stories,
Issues and Acceptance Scripts maintained within Micorsoft TFS ( Team Foundation Server ). Using a
Microsoft Visual Studio 2010 C# .net frontend, SQL Server Management Studio 2008 was used for
database queries and functional requirements were collated in HP Quality Centre for regression
purposes.
05/2012
-
06/2012
Test Analyst
Eclipse Group Solutions Ltd.
Test Analyst - Project scope encompassed a complete rewrite of Waterstones' online WEB application.
Key deliverables included Order Processing with EBM's ( Event Based e_Mails ), Product and Web Page
maintenance. Driven by an Agile methodology, test scenarios followed stories maintained in Jira and
Issues raised using the same. The environment was Java frontend with a Hybris (HMC, WCMS & CS)
backend used for Web Page & database manipulation.
Key deliverables included Order Processing with EBM's ( Event Based e_Mails ), Product and Web Page
maintenance. Driven by an Agile methodology, test scenarios followed stories maintained in Jira and
Issues raised using the same. The environment was Java frontend with a Hybris (HMC, WCMS & CS)
backend used for Web Page & database manipulation.
12/2011
-
04/2012
Admin Re® UK
Windsor Life
Test Analyst - This project governed the migration of ALICO ( American Life Insurance Company ) Life
& Pensions policies onto Windsor Lifes' Life & Pension Administration solution (ALPHA). Test
scenarios encompassed UAT Use Cases ( 'workplans' ) inherent to ALPHA functionality to prove
migrated policies conformed to existing pre-defined tasks, Policy letters were produced using
Dialogue and verified against functional templates. PL/SQL Developer and Q+E Database Editor were
used for Oracle database manipulation. Test execution and defect were managed with the aid of HP
Quality Centre.
& Pensions policies onto Windsor Lifes' Life & Pension Administration solution (ALPHA). Test
scenarios encompassed UAT Use Cases ( 'workplans' ) inherent to ALPHA functionality to prove
migrated policies conformed to existing pre-defined tasks, Policy letters were produced using
Dialogue and verified against functional templates. PL/SQL Developer and Q+E Database Editor were
used for Oracle database manipulation. Test execution and defect were managed with the aid of HP
Quality Centre.
10/2010
-
11/2011
Linc / Lion Analyst Programmer
Magnet Ltd
this role covered a maintenance, support and migration function, including logistics exercises with
third parties such as DHL and Homebase. A full development lifecycle including design, test and unit
test was covered. The environment constituted LION 5.3, LINC 16.2 with Windows NT servers supporting
runtimes, databases were interrogated using SQL & RT Query and jobs scheduled via VB Scripts.
third parties such as DHL and Homebase. A full development lifecycle including design, test and unit
test was covered. The environment constituted LION 5.3, LINC 16.2 with Windows NT servers supporting
runtimes, databases were interrogated using SQL & RT Query and jobs scheduled via VB Scripts.
07/2010
-
09/2010
Test Analyst
TNT Express ICS
Test Analyst - TNT's communication channel between suppliers such as Nokia & Cisco is undergoing a
rewrite, the emphasis on this project is to ensure the replacement is identical and the flow of
messaging between all parties via RosettaNet remains intact. The primary focus of this stage of
testing is to validate conversions to and from .xml formatted data in terms of content and also
against .xsd / .dtd schema definitions. Liquid XML Studio was used for .xml file interrogation,
Oracle SQL developer and DbVisualizer were used for database manipulation and Defects were managed
using IBM Rational Clearquest.
rewrite, the emphasis on this project is to ensure the replacement is identical and the flow of
messaging between all parties via RosettaNet remains intact. The primary focus of this stage of
testing is to validate conversions to and from .xml formatted data in terms of content and also
against .xsd / .dtd schema definitions. Liquid XML Studio was used for .xml file interrogation,
Oracle SQL developer and DbVisualizer were used for database manipulation and Defects were managed
using IBM Rational Clearquest.
04/2009
-
06/2010
Admin Re® UK
Windsor Life
Test Analyst - This project governed the migration of legacy Aviva Life & Pensions policies onto
Windsor Lifes' Life & Pension Administration solution (ALPHA). Data was verified from a content
perspective using a variety of source documents such as .csv files, excel spreadsheets and legacy
system screen prints, from a functional perspective ALPHA product documentation, namely UAT / BAT
Use Cases, was referenced. PL/SQL Developer and Q+E Database Editor were used for Oracle database
manipulation. Test execution was managed with the aid of HP Quality Centre and Defects managed using
T-Plan Incident Manager.
Windsor Lifes' Life & Pension Administration solution (ALPHA). Data was verified from a content
perspective using a variety of source documents such as .csv files, excel spreadsheets and legacy
system screen prints, from a functional perspective ALPHA product documentation, namely UAT / BAT
Use Cases, was referenced. PL/SQL Developer and Q+E Database Editor were used for Oracle database
manipulation. Test execution was managed with the aid of HP Quality Centre and Defects managed using
T-Plan Incident Manager.
07/2008
-
03/2009
Test Analyst
TNT Express ICS
Test Analyst - This project encompassed the migration of legacy data to their core logistics
Customer Database (CDB) on a country by country basis. Adopting the role of lead migration analyst
work detail included the strategic analysis of requirements, high level meetings and discussions
with various development areas. The scope of testing also covered the Functional verification of
portals written in IBM Websphere using business derived Use Cases. Document management utilized PVCS
and Rational RequisitePro. Oracle SQL developer and DbVisualizer were used for database
manipulation. Defects were managed using Rational Clearquest.
Customer Database (CDB) on a country by country basis. Adopting the role of lead migration analyst
work detail included the strategic analysis of requirements, high level meetings and discussions
with various development areas. The scope of testing also covered the Functional verification of
portals written in IBM Websphere using business derived Use Cases. Document management utilized PVCS
and Rational RequisitePro. Oracle SQL developer and DbVisualizer were used for database
manipulation. Defects were managed using Rational Clearquest.
01/2007
-
06/2008
Linc / Lion Analyst Programmer
HBOS - Financial Services - Clerical Medical Investment Group
Pensions system (P142). A full development lifecycle was covered with close liaison to User
Acceptance and Operational teams.The later stages of this assignment included a project aimed at
porting LION source code into a C#.NET environment. The environment constituted LION 5.1, LINC 16.3,
Microsoft .NET Framework utilizing Visual Studio & ASP.NET and SQL Server 2005 databases which were
interrogated using SQL Query Analyzer.
Acceptance and Operational teams.The later stages of this assignment included a project aimed at
porting LION source code into a C#.NET environment. The environment constituted LION 5.1, LINC 16.3,
Microsoft .NET Framework utilizing Visual Studio & ASP.NET and SQL Server 2005 databases which were
interrogated using SQL Query Analyzer.
09/2006
-
12/2006
Test Analyst
Vizuri Ltd
Test Analyst - This project was sponsored by BECTA (British Educational Communications & Technology
Agency - a Government approved supplier controlling strategic development and e-strategy delivery
into schools and other learning sectors). Project scope was to validate, using predefined UAT Use
Cases, 17 Web based educational packages from a platform and framework perspective. Role included
defect management, supplier liaison and the manual execution & recording of BECTA produced test
scripts. An appreciation of SCORM & DDA compliance was acquired.
Agency - a Government approved supplier controlling strategic development and e-strategy delivery
into schools and other learning sectors). Project scope was to validate, using predefined UAT Use
Cases, 17 Web based educational packages from a platform and framework perspective. Role included
defect management, supplier liaison and the manual execution & recording of BECTA produced test
scripts. An appreciation of SCORM & DDA compliance was acquired.
02/2006
-
07/2006
Test Analyst
EDS
Test Analyst - Working for the Department of Constitutional Affairs (DCA) on their Service Upgrade
Project Study (SUPS) programme, this project involved the migration of their 9 Courts systems from
Oracle 6g to Oracle 10g which also included an Application re-write, all applications were
front-ended via Web forms.
Work detail involved the analysis of migration documents into detailed test scenarios and the
execution of UAT Use Cases. Test scripts were logged into TestDirector and executed manually, all
execution results and defects were also recorded within TestDirector. Rational ClearCase was used as
a document repository and PL/SQL Developer used to interrogate data.
Project Study (SUPS) programme, this project involved the migration of their 9 Courts systems from
Oracle 6g to Oracle 10g which also included an Application re-write, all applications were
front-ended via Web forms.
Work detail involved the analysis of migration documents into detailed test scenarios and the
execution of UAT Use Cases. Test scripts were logged into TestDirector and executed manually, all
execution results and defects were also recorded within TestDirector. Rational ClearCase was used as
a document repository and PL/SQL Developer used to interrogate data.
12/2004
-
01/2006
Linc / Lion Analyst Programmer
HBOS Financial Services
Pensions
system (P142) to incorporate Sandler Stakeholder & the Pensions simplification legislative changes.
Development covered coding (in LINC & LION) and unit testing before handover to system testing
environments. An interim project looked at Document Controls and in particular their reflection of
the pending new infrastructure at CMIG. The main task was to upgrade Systems Documentation to
reflect the transition from Unisys LINC & WFL to NT LION & VB Script. During this contract CMIG
migrated all mainframe systems from a Unisys to NT environment. They initially operated upon a
UNISYS CLEARPATH using DMSII. Software and utilities used included LINC 16.3 , ERGO , LINCLITE , WFL
& OVER'C'. Post migration systems operated within a NT environment running LION 5.1 , utilities used
included RT Query & Microsoft SQL 2000 Query Analyzer.
system (P142) to incorporate Sandler Stakeholder & the Pensions simplification legislative changes.
Development covered coding (in LINC & LION) and unit testing before handover to system testing
environments. An interim project looked at Document Controls and in particular their reflection of
the pending new infrastructure at CMIG. The main task was to upgrade Systems Documentation to
reflect the transition from Unisys LINC & WFL to NT LION & VB Script. During this contract CMIG
migrated all mainframe systems from a Unisys to NT environment. They initially operated upon a
UNISYS CLEARPATH using DMSII. Software and utilities used included LINC 16.3 , ERGO , LINCLITE , WFL
& OVER'C'. Post migration systems operated within a NT environment running LION 5.1 , utilities used
included RT Query & Microsoft SQL 2000 Query Analyzer.
06/2002
-
11/2004
Linc Analyst Programmer
Principality Building Society
used to administer their Retail & Commercial mortgages as well as other Investment products. A full
lifecycle scope was covered on topics such as Money Laundering, Credit Scoring & Commercial Lending.
FSA ( CP186 ) Regulation generated an E-Commerce project aimed at front-ending the UFSS with WEB
pages. This phase utilized Unisys' utilities Component Enabler , Biztalk & Hubbing to communicate
between our front and back office systems. Developement utilized UNISYS EAE, LDA 3R2 and supported a
Clearpath NX4600 machine running LINC 16.3 on a DMSIII database. Other utilities included ERGO ,
LINCLITE , WFL , LDQ , Test Director, ACCESS & Acclaim. Also covered was the inclusion, into a
steering group, to oversee a move to LINC17 / EAD / LDA 3R3 incl. Direct Generate from server to
HOST CS7200 mainframe. Release management using LDA Version Control was an integral part of all
processes.
lifecycle scope was covered on topics such as Money Laundering, Credit Scoring & Commercial Lending.
FSA ( CP186 ) Regulation generated an E-Commerce project aimed at front-ending the UFSS with WEB
pages. This phase utilized Unisys' utilities Component Enabler , Biztalk & Hubbing to communicate
between our front and back office systems. Developement utilized UNISYS EAE, LDA 3R2 and supported a
Clearpath NX4600 machine running LINC 16.3 on a DMSIII database. Other utilities included ERGO ,
LINCLITE , WFL , LDQ , Test Director, ACCESS & Acclaim. Also covered was the inclusion, into a
steering group, to oversee a move to LINC17 / EAD / LDA 3R3 incl. Direct Generate from server to
HOST CS7200 mainframe. Release management using LDA Version Control was an integral part of all
processes.
07/2000
-
01/2002
Linc Analyst Programmer
Unisys Limited
and development.The Norwich Union phase of the project included writing technical designs, test
scripts and test execution. TestDirector was used to create test plans and to log execution results
and system faults. The testing phase of the Scottish Equitable Unisure project utilized Excel
spreadsheets to create test scripts from functional specifications. Test execution results and
defects were logged in Excel too. SQLplus provided a means of database interrogation and UNIX
commands were used extensively.
scripts and test execution. TestDirector was used to create test plans and to log execution results
and system faults. The testing phase of the Scottish Equitable Unisure project utilized Excel
spreadsheets to create test scripts from functional specifications. Test execution results and
defects were logged in Excel too. SQLplus provided a means of database interrogation and UNIX
commands were used extensively.
10/1999
-
06/2000
Linc Analyst Programmer - Release Management
Unisys Limited
their Life & Pensions solution ' UNISURE ', primarily on Proposal Entry modules. Unit test plans and
test scripts were written in Word documents guided by functional design content. Unit test plans
were executed with the aid of LDA III on NT and using RT Query for database interrogation.
System testing utilized SQLplus for database interrogation , faults were logged into CMAS ( a
Unisys tool ). Unix
commands were used extensively. Later stages of this contract moulded into a support function,
delivered on-site,
by aiding UAT and acting as a focal point between Unisys and the end user to coordinate production
faults.
test scripts were written in Word documents guided by functional design content. Unit test plans
were executed with the aid of LDA III on NT and using RT Query for database interrogation.
System testing utilized SQLplus for database interrogation , faults were logged into CMAS ( a
Unisys tool ). Unix
commands were used extensively. Later stages of this contract moulded into a support function,
delivered on-site,
by aiding UAT and acting as a focal point between Unisys and the end user to coordinate production
faults.
06/1998
-
08/1999
Linc Analyst Programmer
Royal & Sun Alliance
finance team the work entailed re-engineering an existing IMS Loans module into UNISURE. This
involved a full life cycle development from initial business design and build thru to unit and
system testing. Test execution was aided with the use of LDA III and RT Query for database
interrogation. Mainframe system testing utilized SQLplus for database interrogation.
involved a full life cycle development from initial business design and build thru to unit and
system testing. Test execution was aided with the use of LDA III and RT Query for database
interrogation. Mainframe system testing utilized SQLplus for database interrogation.
09/1997
-
05/1998
Linc Analyst Programmer
Unisys Limited
for the Union Bank of Switzerland (UBS). Their Loan Administration System included Syndicated Loans
and Settlements.
and Settlements.
03/1996
-
08/1997
Linc Analyst Programmer
NatWest Life
system (P174). The latter stages involved the enhancement of their Proposal Viewing System to enable
the handling of two new products due for launch. This was a first for NWL in that a third party was
to administer these products and send daily update files. This in turn meant working closely with
CAT teams to produce Test Plans and with Release teams to finalize WFL flows, request database loads
/ unloads / rollbacks and code compilations. Mainframe system testing utilized ERGO for database
interrogation.
the handling of two new products due for launch. This was a first for NWL in that a third party was
to administer these products and send daily update files. This in turn meant working closely with
CAT teams to produce Test Plans and with Release teams to finalize WFL flows, request database loads
/ unloads / rollbacks and code compilations. Mainframe system testing utilized ERGO for database
interrogation.
01/1996
-
03/1996
Linc Analyst Programmer
AAR
The work detail at AAR was to enhance their existing Inventory Maintenance system (IMOPS) to include
a new consignment of stock. Closing phases involved the release to system test teams and their
support during test cycles.
a new consignment of stock. Closing phases involved the release to system test teams and their
support during test cycles.
08/1995
-
12/1995
Linc Analyst Programmer
Unisys Corporation
management systems into one universal system (SRMS) for worldwide implementation. The role involved
analysis, coding and unit testing. Concluding system test phase involved manual test scripts
creation from Functional designs.
analysis, coding and unit testing. Concluding system test phase involved manual test scripts
creation from Functional designs.
11/1993
-
05/1995
Linc Analyst Programmer
NatWest Life
first was within an Application Support area for their Life & Pensions System. This arena dealt with
service queries raised by users which were predominantly rectified using ERGO in batch form. The
second phase was to perform a leading role within a development phase for their L&P System. This
role fulfilled functions from System design through to implementation and post-implementation
support. Finally I was delegated to create a new role within NatWest Life referred to as a Systems
Coordinator to ensure correct version controls and database usage using OVERSEE.
service queries raised by users which were predominantly rectified using ERGO in batch form. The
second phase was to perform a leading role within a development phase for their L&P System. This
role fulfilled functions from System design through to implementation and post-implementation
support. Finally I was delegated to create a new role within NatWest Life referred to as a Systems
Coordinator to ensure correct version controls and database usage using OVERSEE.
Local Availability
Only available in these countries:
United Kingdom
