PROJECTS

We provide IT Solutions and Trainings in all aspects of IT. We provide services in the area of Software Testing and Quality Assuarance to leading organisations around the world. See below some of our previous and current assignments.

Projects Baseline FDW and Baseline FNN

 

Roles: Senior Technical Test Analyst (Primary Role),

Business Analyst, Agile Champion/SCRUM Master  (Secondary Role)

 

Summary: 

Our Principal Consultant work in a team of  Business Analysts, Test Analysts, Developers, Project Managers, Release Manager and  Product Owners in a fast paced Agile environment, delivering highly technical solutions, new functionalities and enhancements in a bi-weekly iterative life-cycle. The technical solutions were deployed and tested in batch oriented environment using investment and other banking data from multiple source systems and regions. These systems are linked together in a highly complex architecture covering three main project areas such as Baseline FNN (for financial and non financial changes, patches and permanent fixes around the PeopleSoft General Ledger ), Baseline FDW (for financial and non financial changes, patches and permanent fixes around the Informatica Datawarehouse) and FIRE (for financial changes, patches and permanent fixes around the Financial Reporting out of the Data warehouse). The Baseline FDW stream requires the use of ETL processing (Extract, Transformation and Loading). 

 

Tools/Systems/Techniques/Products:

SQL, Oracle PL/SQL Developer, Aptitude, Orsyp, ETL, Informatica, Microsoft TFS, PeopleSoft, UNIX, PUTTY, MARDEN, Datawarehouse, Autosys, Data Modelling, UML, Use Cases, Class Diagrams, Business Process Modelling, AGILE, Daily Stand-ups, Retrospectives, Product Risk Analysis, Project Risk Analysis, Poker Planning Sessions, PeopleSoft Navision reports, Test Automation, APEX. Settlements, Trades, Cashflows, Deposits, Derivatives, FX trades, Journals, NOSTRO, Fees, FXOPTIONS, Penalty, Bond, Loan, Pledge, PeopleSoft  General Ledger, FX rate, Revaluation, Accruals, Amortisation, Hedging, Account Certification, Intraday Batch Processing, End of day Batch Processing, SWAPS, SPOT Trades, FORWARD Trades, Business Units Set-up, Holiday Processing, Cross-Currency Processing.

Projects :

  • ARIA (ABN AMRO Returns to India Project) Jul 2012 – April 2013

  • ConnECT/Exit GA T24 ModelBank Project Apr 2012 - Jul 2012

  • Credits UAT on ModelBank 2.0 Project ( upgrade from R8 to R11) Nov 2011 - Apr 2012

  • Agile (SCRUM) CBI Credits (Term & Revolving Loans) & Markets for T24 Europe Sep  2011 - Nov 2011

  • FMIS7/BAU Projects May 2011 - Sep 2011

 

Roles:

  • Business Analyst / UAT Coordinator on ARIA (ABN AMRO Returns to India Project) Jul 2012 – April 2013

  • Test Manager International Domain on ConnECT/Exit GA T24 ModelBank Project Apr 2012 - Jul 2012

  • Test Lead Model Bank on Credits UAT on ModelBank 2.0 Project ( upgrade from R8 to R11) Nov 2011 - Apr 2012

  • Test Lead on Agile (SCRUM) CBI Credits (Term & Revolving Loans) & Markets for T24 Europe Sep  2011 - Nov 2011

  • Senior T24 Test Specialist  on FMIS7/BAU Projects May 2011 - Sep 2011

 

Tools/Techniques/Technologies:

SharePoint, SCRUM (Sprint, Product Backlog, Sprint Backlog, Retrospectives), T24 banking System R08 and R11, HP Quality Centre 10.0 Enterprise Edition, XML, WinXP, Win2000,Lotus Notes 8.5, Sametime, Microsoft Office 2003 (Outlook, Excel, PowerPoint, Project, Visio, Word), UltraEdit32 Professional Editor, UltraEdit32 FTP/SFTP Browser, Snipping Tool (Screen Capture), Citrix, IBM Mainframe, IBM SIPS Tool, FBN SWIFT Alliance, MQ connections, GIMT, Websphere Message Broker (WMB), Anti Money Laundering (AML), Payment systems/Functions/Interfaces/Clearing Systems (Target2, SWIFT, CEC, EMZ, BACS, SEPA, AOL, BICs, Direct Debit, Standing Orders),  T24 Command Line, Enquiries, Routines, Repair Queues, Search, MT 101, MT103, MT202COV, MT940, IPSY, TIGA, WebShare, WebEx, Risk Systems such as FCA/FAIR, Smartstream, Investment Banking  (Fixed Income Trading, Treasury Bills, Switch, Funds, Equities, Bonds, Stocks, Futures, FX, Clearing and Settlement), Treasury (Bloomberg, Adaptive, Intellimatch), Trade Life Cycle, Electronic Trading

Project: ACI ETL/Business Intelligence Project       

 

Roles: Senior Technical Test Consultant 

 

Summary: 

Our Principal Consultant managed:

  • Test Planning, Preparation and Execution and Defect Management in the following areas (using SQL where appropriate for data reconciliation)

  • ETL Testing (Extract, Transform and Load)

  • SQL Verification tests on Extract tables (created with correct data and system columns, check record counts, sums, compare rows column by column)

  • Verify Process runs on Sili/Fili to extract tables without error

  •  Verify Process runs on Extract tables to Transform tables

  • Verify Transform tables is created with correct data columns and system columns, check record counts, sums, compare rows column by column

  • Validation and error messages on fact tables

  •  SQL Verification tests on Derived data – default values and mapped values

  • SQL Verification tests on Fact tables – any specific logic

  • SQL Verification tests on Withheld logic on fact tables

  • SQL Verification tests on Exclude utility and logic

  • SQL Verification tests on Correct utility

  • SQL Verification tests on Load tables – created with correct data columns and system columns

  • SQL Verification tests on Load tables – check record counts, sums, compare few rows column by column.

  • SQL Verification tests on Load table validation

  • SQL Verification tests on Load reference tables – current records and effective dates

  • Negative Tests – e.g.  Empty Extract

  • Requirements Gathering

  • Data Profiling

  • Data Mapping

  • Prioritisation of tasks

 

 

Tools/Systems/Techniques/Products:

Citrix, SQL, SQL Server Management Studio (Microsoft SQL Server 2005 and 2008), Microsoft Visual SourceSafe 2005 and 2008, Microsoft Visual Studio 2005 and 2008, HP Quality Centre 10.0 Enterprise Edition, MicroStrategy 8, Sybase 12.0, Informatica, Ab-initio.

Project: Unified Handheld, Data Reconciliation and Web Upgrade Delivery Project       

 

Roles: Senior Technical Test Consultant 

 

Summary: 

Our Principal Consultant managed:

  • Reconciliation testing of data from Cognito with that meant for HITS and Softlocker databases using SQL

  • Requirements Gathering

  • Data Profiling

  • Data Mapping

  • Prioritisation of tasks

  • End to End testing of new web upgrade front end with backend legacy systems/databases

  • Managed and coordinated the testing activities

  • Planned, designed, and executed tests

  • Developed Test Estimate

  • Developed the Test Summary Report

 

Tools/Systems/Techniques/Products:

Citrix, SQL, HITS, Softlocker, Testlocker, IIS, Microsoft SQL Server 2005, Mailbase server, Websphere, Telephony Testing, Ab-initio.

Project : Customer First/EPM Deployment 

 

Role: Senior Technical Test Consultant

 

Summary: 

Customer First/EPM Desktop Deployment is part of a suite of BCC/Service Birmingham partnership Business Transformation Programmes to redesign the delivery of BCC services. This involved the deployment and roll-out of hundreds of legacy and/or new applications with new software upgrades to Windows 2000, Windows XP and Citrix Neighbourhood platforms to over sixteen thousand users in a complex infrastructure environment.

 

Duties and Responsibilities of our Principal Consultant:

  • Managed and coordinated the testing activities on the SB/BCC Desktop Deployment Project

  • Wrote the Desktop Deployment Strategy for Customer First and EPM programmes

  • Planned, designed, and executed tests on the BCC Application Data Encryption Project stream

  • Developed Test Estimate for the BCC Application Data Encryption Project stream

  • Developed Test Estimate for the SB/BCC Desktop Deployment Project

  • Wrote the Test Summary Report for the SB/BCC Desktop Deployment Project

  • Planned, designed, and executed tests on the Customer First/EPM Application Deployment Project stream (Complex Infrastructure Testing Exercise)

  • Planned, designed, and executed tests on the Customer First/EPM Service Desk Testing Project stream

  • Developed Test Specifications to cover the major test objectives as per the Detailed Test Plan for Service Birmingham/BCC Operational Acceptance Testing

  •  Coordinated Deployment Testing with Service Birmingham/BCC Application Support Staff and Super Users

  • Reported and Tracked defects to resolution with Application Packaging/Deployment Team

  • Developed and implemented workflow systems to facilitate testing

  • Provided training to BCC Super users and colleagues

  • Produced Test Progress Reports to Head of Testing on weekly basis

  • Developed Test Execution Plan and Approach for Deployment Testing

  • Scheduled and coordinated meetings and test sessions with Application Support Staff, Super Users and other colleagues on regular basis

  • Maintained high visibility of test progress to all stakeholders making sure issues that can impede project delivery are escalated in time to appropriate authorities

 

Tools: Credant, Quality Centre, Excel, Java, IE 6.0, Active X, Lotus Notes, IE Spell, WebEditPro, WinXP, Win2000, Citrix, VMware, Telephony Testing.

Projects: 

Project 21, Skycard Migration, Sky Waves, Skycard Business As Usual, Data Migration, Sky Q2 NoV, Additional Promo Rates, CCA3, August Cheques, Full File Nov Q3, Direct Debit Files, TSYS Support, UAT New Deals, CCRP Project, Credit Limit Increase Opt Out, Sky Card Loyalty Fulfilment , Online Account Servicing, Monthly Regression Pack, October Cheques and Balance Transfers, Sky Card Cut-off Review, Reissue policy rules (1+ cycle delinquent decline), Interest Charging on Repayment Plans and Credit Limit Increase Opt Out.      

 

Roles: Senior Technical Test Consultant 

 

Duties and Responsibilities of our Consultant:

  • Led a team of twelve UAT Test Consultants dispersed over three locations to implement testing solution on the highly successful Skycard Migration and part of Skycard Business As Usual programmes

  • Developed test plans for multiple projects (Skycard Migration, Sky Waves and Skycard Business As Usual)

  • Coordinated and developed Test Plan/Test Specifications for Disaster and Recovery Testing

  • Developed workflow and progress tracking systems to enable effective RAG reporting of test progress by my test manager

  • Monitored and reported test progress using workflow systems on daily basis

  • Designed and delivered trainings and workshops to colleagues within the test team

  • Liaised with Business users, Developers and other test team members to understand business requirements and attending project and test meetings

  • Reviewed available baseline documentation of various components of new solutions, legacy and third party applications to extract Test Conditions and Test Cases to facilitate writing and execution of Test Scripts

  • Translated Business Process specifications into test specifications (Test Cases, Test Scripts and Test Data)

  • Reviewed and updated existing Test Artefacts including Test Cases, Test Scripts and Test Data

  • Functional and User Acceptance Testing of various subsystems

  • Worked closely with Business users to identify test scenarios for subsequent test execution

  • Created and defined Test data based on Test Scenarios using simple to complex SQL queries

  • Data reconciliation tests of ASCII files with data in Data Warehouse using Macros and SQL

  • Worked closely with Project Manager to develop Test Project Plan

  • Developed Test Estimates for various work streams for the purpose of planning, scripting and test execution

  • Developed Test Plans and for multiple projects

  • Responsible for producing Impact Analysis for Change Requests and subsequent test planning, preparation, execution and reporting of approved Change Request functionalities

  • Responsible for bringing Potential Issues that may/may not result in Change Requests to the awareness of Developers and Business users

  • Responsible for backend server side testing using SQL to define, create and edit Test Data, to investigate potential defects and to carry out file or data comparison

  • Making progress reports to the test manager by providing daily status report of assigned activities and planning with him to review estimates and all known risks

  • Liaising with the development team and third party suppliers to resolve and track all outstanding defects/faults detected during testing

 

Tools/Techniques/Technologies:

PRINCE2, Citrix, Teradata, AS400, TSYS Mainframe (TS2) Green Screen Application, SpeedScans, RDC, DB2, TSQL, NIKU, Oracle 10g, Excel, Test Director 8.0,Microsoft Query, SQL, Windows 2003 Professional, J2EE, Java TM 2 Platform, UNIX, Browser-based Java EE, WebSphere Application Server v6.1, AIX, XML, Image files, Javascript libraries, Stylesheets.

Project : Hugo - redevelopment of First Choice Holiday website

 

Role: Senior Technical Test Consultant

 

Tools/Techniques Used:

QTP, Oracle 10g, Excel, Test Director 8.0, Empirix E-Test Suite, Elementool, Microsoft Query, SQL, PLSQL Developer, XML, XSD, CSV, Altova XML Spy 2006 & 2007, Windows 2003 Professional, J2EE, Java TM 2 Platform, UNIX, Websphere.

Project :Self Investment Pension Administration 

 

Role: Senior Technical Test Consultant

 

Tools/Techniques Used:

Oracle 10g, Excel, Test Director 8.0, Microsoft Query, SQL, SQL Tools, XML, XSD, CSV, WinSCP Version 3.7.4, Assyst Enterprise Version 6.5, Altova XML Spy 2006 & 2007, Windows 2003 Professional, J2EE, Java TM 2 Platform, UNIX, Websphere, Elixir, CSIP New World trading Portal, and Trading Portals for Joint Ventures like Scottish Equitable, Scottish Life, MetLife, Zurich and Zurich Vanilla 

Projects : ``Lion'' and ``BI”   

 

Summary: 

Business Intelligence project, which involves replacing Mitsui's existing underwriting system (Charisma) with a new, bespoke system known as MSIP and building a data warehouse to integrate with MSIP Client and MSIP database to provide a variety of reporting capabilities.                                          

 

Role: Senior Technical Test Consultant

 

Tools/Techniques Used:

Transact-SQL, SQL Server Integration Services (SSIS), Microsoft SQL Server 2005 Version 9.0 (SQL Server Management Studio), TOAD for ORACLE 8.6, Oracle 10g, SQL Server 2005 Microsoft Report Manager, Microsoft Report Builder, ProClarity Analytic Server Version 6.1, Excel, Empirix e-Manager Enterprise Version 3.0, Microsoft Query, SQL, XP and UML, Telephony Testing

Project :MSN News Service Website Development 

 

Role: Senior Technical Test Consultant

 

Tools/Techniques Used:

Agile (Scrum), Bedrock 3.0, Microsoft Product Studio Client UI 2.1, Excel, Orcas, Microsoft QuickPseudoLoc Text, Microsoft XMLForm (EX) 1.0, Websphere.

Projects : First Contact SAP CRM implementation  

 

Role: Senior Technical Test Consultant

 

Tools/Techniques Used:

QTP, GroupWise, CRM ABAP solution, CISCO IP Phones, Citrix Metaframe Program Neighbourhood, SAP CRM 4.0, SAP Interaction Centre WINCLIENT, SAP Library, CISCO IPCC Enterprise version 7.0 {Cisco System CTI Toolkit (IPCC Supervisor and Agent Desktops), SAP Telephony Connector, Cisco Email Manager} Witness Call Recording Viewer, Excel, Microsoft Query and SQL, Telephony Testing.

© LSIT Consulting

This site was designed with the
.com
website builder. Create your website today.
Start Now