VIKTORIYA LUKYANOVA

Vaughan, ON cell: 647-***-****

adhyn6@r.postjobfree.com http://ca.linkedin.com/pub/viktoriya-lukyanova/25/621/311/

Senior SOFTWARE QUALITY ASSURANCE ANALYST / LEAD with strong analytical, planning and organizational skills that balance work, team support and ad-hoc responsibilities in a timely and professional manner

SUMMARY OF QUALIFICATIONS

●Diplomas in Computer Programming and Accounting, Certificates in Software Quality Assurance and Testing Methodology

●17+ years of experience as a Software Quality Assurance Analyst in Banking, Brokerage and Telecom industries in all phases of testing for client / server, Web and mobile, 12 years in BANKING in addition

●QA experience in all phases of life cycle, including requirements gathering, risk analysis, project planning, scheduling, testing, data identification/preparation, defect tracking, management, and reporting

●Extensive experience with different levels of testing, including GUI, Development Integration Test (DIT), Functional, System Integration (SIT), Regression, and User Acceptance Testing (UAT), End-to-End(E2E), PAT, positive and negative, functionality, object-oriented testing manually and using Automated Testing Tools

●Data Testing - Integrated Development Testing, Field-to-Field, Bill-to-Bill, Online Compare and Usage testing

●Expertise in all types of Test Documentation: Test Plans, Test Strategies, Test Summary, Test Scenarios, Test Cases, Functional Specifications, User Interface documents, Root Cause Analysis, Gap Analysis

●Knowledge of the Software Development Life Cycle: from customer requirements and functional specification to the final product, Quality Assurance concepts, metrics analysis (schedule, size/complexity, cost, quality), QA Methodologies, Standards, best practices within Waterfall, DevOps, and Agile Environments

●Solid understanding of industry methodology standards (e.g.Capability Maturity Model Integration [CMMI] and International Organization for Standardization [ISO])

●Proven working experience of testing n-tier web-based and client-server applications with J2EE, Java, .NET, XML, Oracle, DB2, WebLogic and WebSphere.

●10+ years of experience of databases: Oracle, DB2, MS Access, Mainframe and writing, understanding, executing SQL statements

●7+ years of experience with ETL, Data Warehouse – Informatica and back end Data Validation

●5+ years of Team Lead/Test Coordinator experience

●5+ years Wealth Management

●5+ years RESTful API Test Experience (Soap UI, Parasoft, SOA test), Web services using XML files

●Defect prevention through early involvement of project, Gap analysis.

●Technical assistance to junior team members and providing professional services for end-users

●Excellent team-working, analytical, logic definition, negotiation and problem-solving skills, able to interact with technical and non-technical resources

●Ability to work on multiple tasks concurrently, quick learner, able to grasp new ideas, methods and procedures with minimum effort

●Detail oriented. Excellent organizational and time management skills

●Programming experience and formal training in QA methodologies and practice

Computer Skills

●Programming languages: Java, C++, Visual Basic 3.0/6.0, HTML, JavaScript, Jquery, DHTML, SQL, PL/SQL, XML, CSS, AJAX, SVG – 2D, VRML-X3D, ASP.NET.

●Databases tools: Oracle, MS Access, ODBC, SQL Navigator, SQL Plus, Query Analyzer, Enterprise Manager, Toad for Oracle, SQL Developer

●Web/Mobile testing tools: Browsers, Browser Stack, Litmus

●Web Servers: IIS, WebSphere, WebLogic, Apache Tomcat

●Automating testing tools: Mercury WinRunner, Load Runner, Quality Centre, Test Director, Quick Test Professional, Rational Test Manager, Robot, ClearQuest, E-Test Suite, Jira, Bugzilla, Parasoft

●OS: Windows 95/98/2000/XP, Win NT 3.5/4.0 Server / Workstation, MS-DOS, UNIX.

●Microsoft office: Word, Excel, Access, MS Visio, Lotus Notes, MS Project, Visual SourceSafe Explorer 6.0, SharePoint, Skype.

●Super System, V21, SGI, CICSS, QManager, Soap UI, BTB AFP Browser, FasTest Print Stream Compare, pgAdmin, Web Services Informatica Cloud, WebEXWeblink, SimCorp Dimension (SCD) tool, Beyond Compare

PROFESSIONAL EXPERIENCE

Manulife - Investment Division Information Services, Toronto 07/2015 – 11/2019

Senior Quality Assurance Analyst/Lead - Functional/SIT/UAT(Contract)

Projects:

Global Optimization(GO) – Accounting Book of Records (GO-AABOR) project is a multi-year program to transform the operational platform that supports the investment management activities across front, middle and back office using SimCorp Dimension/SCD

RBC Fund Accounting in Agile environment - UAT Lead

Valuation System Transformation (VST) - Data validation in Agile environment

●Worked with business and project users to perform defect triaging, testing and resolution for key project implementation stages including Functional Testing, SIT, UAT, E2E

●Interact with the BA’s, QA’s, Developers and PMs to contribute to the delivery of the project schedule by preparing test estimates.

●Review and analyze business requirements and specifications to validate them for completeness, clarity, correctness, consistency, traceability to identify the testing scope.

●Developed Test Strategies with all related details about test strategy, test environments, test data, prepared Test Execution Summaries for projects and releases.

●Contribute to application/solution development lifecycle process improvements. Review test strategies and test cases to ensure testing coverage for all projects.

●Developed and reviewed the Test Cases to ensure traceability matrix according to detailed Business Test plan and upload to HP ALM and Jira

●Planned all required test cycles for System Integration Test (SIT), considering code drop schedule, change requests, Test Exit Summary

●Create testing templates, metrics and maintain QA process consistency across project, on- and off-shore.

●Hosted required meetings with technical and QA teams, defects triage meetings

●Understanding of Back and Middle Office functions as it relates in Wealth and Asset Management

●Validated that the SimCorp delivered system configuration performs as expected for in-Scope business functionality

●Validated accounting entries for transactions entered against instruments: buy, sell, modify & cancel, EOD and MTM related calculations for Valuation Adjustments & Risk

●Validated posting rules for security types, cash settlement amounts, positions, Portfolio calculations postings, Pricing updates through NAV agents, Cash Deposits and withdrawals posting rules

●Participated in successfully implementation of SimCorp Dimension platform for a portion of assets with integration to 12 other new or updated systems for Trading, Master Data, Collateral, Reporting, etc

●Validated business requirements and SimCorp configuration for derivative products: FX (Options, NDF, Swaps), Credit (CDS/CDX), Equity (TRS, Options), Rates (IRS/XCCY, Swaptions) and ABS (MBS, CMO, CLO)

●Validated derivative accounting entries, lifecycle event processing, and pricing calculations

●Leading subproject for transformation of all related to Transfer Agencies transactions: Subscriptions, Redemptions, Reinvestments

●Validated XML schemas and posted transactions into Informatica database

●Write, execute and update SQL scripts to verify ETL processes Data Warehouse – Informatica and back end Data Validation in ETL Cloud team for Mainframe, Oracle

●Writing, executing Unix commands through shell scripting

●Data Mapping validation between Source and Target systems with SQL and Beyond Compare tool

●Data conversion testing from Mainframe to Oracle

●Experience working on the remote desktop environments

●Created weekly test status reports

●Participated in daily scram and defects triage meetings

●Identified and raised key risks, issues, and dependencies

●Responsible for following established SDLC methodologies, best practices and standards

●Worked with business and technical personnel (i.e. Development, IT Operations) to troubleshoot and resolve defects and issues quickly and efficiently

●Provide updates on tasks via discussions and status reports in written, verbal or graphical form as required

●Coordinated End to End testing with different teams of the project, provided back-up to other testing projects as required

Software/Tools: Oracle, Mainframe, SQL Developer, ALM HP QC, Informatica Cloud, WebEXWeblink, Word, Excel, IE 8.0, Sharepoint, Beyond Compare, SimCorp Dimension tool (SCD),Unix Shell, XML, REST API, ServiceNow, MS Office Applications, Microsoft Project, Office 365

Acxsys Corporation – Interac Association, Toronto 07/2014 – 07/2015

Senior Quality Assurance Analyst - Functional/SIT/UAT (Contract)

Interac Association and Acxsys Corporation operate an economical, world-class debit system including the Interac Network; Interac e-Transfer, Interac Online, Cross Border Debit; and International ABM services.

Projects: e-Transfers, Bulk Transfers, EUF (Request and Fulfill Transfers, Transfers Automatic Deposits), Scoring Engine using DevOps, Agile methodologies

● Defined scope and test scenarios for System Integration(SIT) and User Acceptance Testing(UAT)

●Performed testing of different mobile operating systems (iOS, Android, Blackberry)

●Defined testing approach including test phases, their deliverables and success criteria, test data management approach.

●Work with scrum team members for effective knowledge transfer to understand, create, and test product functionality and quality of data against devices

●Worked with scrum team on overall defect management to validate, prioritize, and resolve defects/bugs as soon as possible

●Designed and implemented test cases and scripts based on functional specifications and system analysis, analyzed user stories and use cases/requirements for validity and feasibility, generated reports.

●Suggested and successfully implemented changes to existing Test Cases, achieving extensibility and reusability by using modular design approach.

●Provided gap analysis for existing testing assets and requirements as part of Change Management Process.

●Followed up on changes to business requirements, ensuring complete coverage of upcoming CRs and their successful implementation into the existing work frame.

●Defined test data specifications and prepared data required for future UAT purposes

●Created and updated requirements traceability matrix ensuring comprehensive coverage of all requirements within testing timeline.

●Developed Data Driven test cases and scripts for testing system interfaces, using XML / Web Services, PL/SQL, Parasoft.

●Strong API testing using Parasoft SOA testing

●Organized and facilitated weekly status review meetings to report test status to stakeholders.

●Tracked and monitored action items, issues, and risks

●Managed defect reporting and resolution during the defect cycle, worked with the user acceptance test lead to report and resolve defects in a timely manner

●Worked closely with Product, Development, Architectural and Database Teams in order to facilitate testing efforts, achieving tight deadline schedules.

Tools/ Software: Oracle DB, Parasoft, SOA, Jama Testing Tool, Jira Defect Tool, SQL Developer, WinSCP, FI Emulator, OAS, GATEWAY - Java J2ee, REST API, JQUERY, CSS Word, Excel, IE 8.0, SOAP UI, Google Chrome, Mozilla, Browser Stack, Browsera, Litmus, Sharepoint

Symcor, Mississauga 07/2011 – 04/2014

Senior Quality Assurance Analyst/Lead - Functional/SIT/UAT (Contract)

Responsible of coordinating and testing of composition, printing, archiving of variety financial documentation including statements, letters, tax slips for Financial institutions including projects: BMO Diners, BMO Credit Card, TD Credit Cards, TD MBNA, RBC, Scotia, Broadbridge, Vancity, Mackenzie using Agile, DevOps and Waterfall methodologies

●Reviewed requirements, functional specification and technical specification, including Business Requirements Documents, XMC Messaging Configuration Guide, Test Plan and Strategy with respect to correctness, consistency, comprehensiveness and testability

●Created / contributed in the development of the project test strategy and project test plan

●Created test scenarios, test cases and supporting test data to ensure the data adequately tests all testable situations

●Established and evolved formal QA processes and standards, ensuring that the team is using industry-accepted best practices.

●Analyzed ASCII files for missing data and prepared specific requirements based on the RDF files layout and Sort Order/Copybooks documents.

●Worked in collaboration with the client, developers, business analysts onshore and offshore team to discuss issues and functional gaps. Chair/Participated in meetings and conference calls.

●Processed data using qManager processing tool, verified reports, outputs

●Validated Data integrity using SQL statements.

●Created/Executed Unix commands through shell scripting

●Validated statements loading and archiving using XML messages

●Experienced with REST API testing using SoapUI tool

●Tested web pages and PDF pages that can be read with assistive technologies such as JAWS and Voiceover

●Updated and maintained regression tests and designed new regression tests suites.

●Created Release Notes for code promotion to the environment.

●Prepared daily/weekly project reports and defects reports using Quality Centre and Jira

●Executed project and change requests CR test cases and test plans details

●Timely completed of assigned testing tasks incorporating all quality processes and reporting of test results

●Managed defects by ensuring accurate tracking and summary reporting ensuring project awareness of all unresolved defects.

●Participated in User/Business Acceptance Testing and Client Acceptance Testing activities and defect resolution in conjunction with the Project Manager/Business Analyst

●Perform various project administration tasks, including coordinating meetings, taking meeting minutes, forwarding communication releases, and performing maintenance of project tracking logs in order to satisfy project management processes

●Investigate project systems/process-related problems/inquiries and recommend solutions

●Provided leadership to employees, which includes assigning tasks or work, holding regular meetings, mentoring in order to create and maintain a high-performing team

●Assisted in the planning, preparation, and maintenance of project team schedules, documented work plan updates, maintained project issues logs, estimated activity duration and risks

●Mentored junior team members

Tools/ Software: PostgreSQL, HP Quality Centre, Jira Defect Tool, xMC Online, xMC Messaging tool, qManager, AFP Browser, Soap UI, REST API, FasTest Print Stream Compare, pgAdmin, XML, Word, Excel, IE 8.0, SharePoint, MS Project, Microsoft SQL Server, Unix

ROGERS, Brampton 01/2009 –05/2011

Senior Quality Assurance / Data Analyst (Contract)

Tested functions in support of Data Quality tasks for Business Transformation Customer Migration – Maestro Migration including Integrated Development Testing, SIT, UAT, E2E, Field-to-Field, Bill-to-Bill and Usage testing for OOB and Cable Custom. Project involved the replacement of the legacy mainframe billing applications with a single Amdocs CRM Billing platform.

●Field-to-field, Bill-to Bill, Online Compare testing using automated and manual routines to validate mappings, translations, reference table definitions and transformation logic for set values, direct moves, translation and transformation scenarios.

●Data analysis, which includes studying the source of data thoroughly to understand its content, structure, quality and integrity and data mapping.

●Worked with UF (Uniform Format) spreadsheets for each field defined by Amdocs to understand the Maestro target data fields.

●Write, execute and update SQL scripts to verify ETL processes Data Warehouse – Informatica and back end Data Validation.

●Definition and development of processes in support of testing functions.

●Analysed test results navigating through multiple systems to define the source of the problem.

●Identification of translation table, reference table, transformation logic and product definition problems that cause discrepancies.

●Change control, defect management and retesting activities.

●Prepared status reports, collection of Statistics related to testing activities.

●Identified data cleansing scenarios to the DaTA Team Lead

●Provided back-up support to the Test Lead.

●Participated in defining mapping rules for Filter, Deferral and Push of accounts and addresses and responsible of rules testing

●Trained and supervised testers assigned to testing activities.

●Maintained Risk Analysis documents.

●Responsible for SharePoint maintenance, ensuring that documents are accessible and searchable.

●Uploaded documents to SharePoint, check-in/out, archiving, clean-up, and version control.

●Monitored SharePoint disk space usage through the build-in SharePoint reports for each site collections

●Provided training to users of the SharePoint application, designed and created workflow

Environment/ Database: Win XP, Super System, V21, SGI, CICSS, Oracle 9i, Mainframe

Tools: IBM Rational ClearQuest, TOAD, Query Express Tool (QET)

Software: Microsoft Access, Word, Excel, IE 8.0, SharePoint, WebDrive

CIBC, Toronto 04/2007 – 12/2008

Senior QA Analyst - Functional Test Analyst/SIT/UAT (Contract)

Tested web-based application for Retail Branch Technologies – SM@RT Project

●Reviewed requirements, functional specification and technical specification, including GUI Channel Documents, Use Cases, Master Test Plan and Strategy with respect to correctness, consistency, comprehensiveness and testability

●Identified, analyzed, reported and track defects using Mercury Quality Centre tool

●Performed System Integration Test (SIT), User Acceptance Test (UAT), End to End(E2E)

●Performed ETL extracts testing, Batch processing using SQL

Tools/Software: Windows XP, Java, REST IPI, SOAP UI, Mercury Quality Centre-QC ALM, Microsoft Word, Excel, IE 6.0, Microsoft Visual SourceSafe 6.0, SharePoint

IBM Canada Securities Industry Services, Toronto 08/2006 – 03/2007

Senior QA Analyst - Functional Test Analyst (Contract)

Worked on different projects for Capital Market Customer - Wealth management : Security Master, Accounting Master. Trading and Stocks application: Trades, Stocks, Mutual Funds, Derivatives, Reconciliations, Foreign Exchange using Agile, Iterative methodologies

●Studied Consolidated Requirements Document, Master Test Plan and Strategy, for defining scope of testing, and execution detailed testing scenarios

●Developed Test Cases for all in-scope transactions based on Posting Rules matrix for Development Integration Test (DIT), System Integration Test (SIT), User Acceptance Test (UAT)

●Created XML statements for transactions and submitted to the system using XML Spy tool

●Write, execute and update SQL scripts to verify ETL processes Data Warehouse

●Identified, analyzed, reported and track defects using Rational ClearQuest tool

Tools/Software: Win XP, Unix, Oracle 9i, Mainframe, IBM Rational ClearQuest, SQL Developer, TOAD, XML Marker, XML Spy,Oracle Enterprise Manager, Files Comparison tools, SOAP UI, CSS, ISS, AJAX, ASP.NET, Microsoft Word, Excel, IE 6.0, Lotus Notes 7, MS Project

TD Bank Financial Group, Mississauga, Ontario 05/2005 – 07/2006

QA Analyst (Contract)

Worked on LASER Personal Lending project – web based application, which implements a multi-channel, multi-product credit origination system in the bank

●Reviewed System Requirements / Design Specification, Use Cases, UI Matrix for developing and execution detailed testing scenarios, Test Scripts, Test Matrix for GUI, Functional, System Integration Testing manually and using Automation Testing Tools

●Regression test using Quick Test Professional(QTP)

Tools/Software: Win 2000, DB2, SQL, IBM Rational ClearQuest, Mercury Quality Centre, Quick Test Professional(QTP), SOAP UI, Load Runner, Microsoft Word, Excel, IE 6.0,

Lotus Notes 6.5, MS Visio STD 2000, MS Project

Heritage Operating Group LTD, Toronto, Ontario 10/2003 – 04/2005

QA Analyst (Contract)

Tested client-server and web-based applications that provided accounting and inventory controls.

Tools/Software: Win XP, MS Access, SQL, Win Runner, Load Runner, Defect Tracking Tool (Access 2000). Microsoft Word, Excel, IE 6.0, MS Visio STD 2000

Sectro Inc. Thornhill, Canada 09/2002 – 12/2002

Computer Programmer

Programmed web-based CGI applications using Visual Basic for the purpose of dynamically rendering XML documents including Scalable Vector Graphics (SVG – 2D) and Virtual Reality Markup Language (VRML – X3D). Created/Executed Unix commands through shell scripting

Environments: Windows 95/97, Win NT 3.5 Server / Workstation, Tomcat MS-DOS, UNIX.

Programming languages: MS Visual Basic 3.0, SVG – 2D, VRML-X3D, Java 2 SDK

DB/Software: Access, MS SQL 6.5, Microsoft Word, Excel, MS Visio STD 2000

Bank of National Credit, Kiev, Ukraine 09/2001 - 09/2002

Quality Assurance Analyst

Involved in all aspects of the QA process and testing for On-line Banking projects.

Tools/Software: Win NT 3.5/4.0, Windows 95/98/2000, Java 1.2, HTML/XML, JavaScript, C++,

Oracle 7.3/8.1, MS Access, SQL Navigator Pro 3.2.

Bank of Industrial Investments, Kiev, Ukraine 07/1992 - 06/2000

Manager of Accounting Department

Bank of Industrial Investments, Kiev, Ukraine 06/1988 - 06/1992

Bank Teller

EDUCATION

Certificate CIBC Enterprise Testing Methodology (CETM) Training 2008

CIBC Retail Branch Technology, Toronto, Canada

Certificate Quality Assurance Analyst 2004

Canadian Technology College, Toronto, Canada

Diploma Computer Programmer for Business and Industry 2001

Maharishi University of Management, Kiev, Ukraine

Diploma Accounting and computers in a Bank 1988

Banking College, Kharkiv, Ukraine

Contact this candidate