Lioudmila Malko

E-mail: ac8l3m@r.postjobfree.com Phone: 647-***-****

Senior Quality Assurance Analyst

SUMMARY OF QUALIFICATIONS

** *****’ experience in SW Testing and Quality Assurance Analysis

Experience in Banking, Retail, Insurance and Manufacturing sectors with emphasis on Quality Assurance

Proficiency with QA testing in ETL/Master Data Management /Reference Data environment/Oracle SQL

Excellent skills in Manual and hands-on experience in Automated testing with knowledge in QAS/RSA/Eclipse, VisualStudio2008, SOAP UI, XML Tester, IBM Data Studio, UFT 12.3, SQL Developer

Apache Hadoop ecosystem, Big Data, HDFS, Map Reduce, Hue Workbench, TOAD application tool

Competent in creating Test Plans, Test Scenarios, Test Cases, Test Coverage, Knowledge Transfer, Data Flow Documentation and in preparing Test Data

Expertise in White Box, Grey Box and Black Testing using variety of techniques

Knowledgeable in Smoke, System (Functional/non-Functional), System Integration, UAT and Regression Testing

Hands-on experience in testing Web applications using website/web application tools

Robustly experienced with RDBMS and SQL query usage

Proven ability in QA training, Application Support and Software installation

Compliance with ISO 9001, TL9000, UL and IEEE 829.98 Quality standards

Dedicated team player with excellent interpersonal skills, willingness to learn and analytical, creative thinking

TECHNICAL SKILLS

Operating Systems: MS Windows 200x/NT/XP/7, UNIX (Sun Solaris), IBM WebSphere, Linux, Hadoop

Languages: SQL, HTML, XML, JavaScript, UNIX Shell

Databases: DB2, IDP, Netezza, Oracle 8i/10g, My SQL, Access 200x

ETL tools: IBM InfoSphere DataStage, Informatica-Trillium

Test Automation Tools: IBM RSA, Eclipse, SOAP UI, NUnit, QTP, UFT14.03, JMeter, VisualStudio2008, W3C/WDG, CSE Validator v.10, Inspyder, JSON Formatter, SpellChecker

Test Management Tools: ClearQuest, Test Director, Bugzilla 2.18, QATraq, JIRA, HP QC, HP ALM, Confluence

BI tools: Teradata, Microsoft Power Pivot, IBM Cognos

Network Technologies: TCP/IP, HTTP, FTP, Ethernet, Intranet

Office Applications: MS Office (Word, Excel, PowerPoint), Lotus Notes, MS Share Point

Applications: IBM MDM, FabView, Lab View, Citrix, Matrix, Putty, WinSCP, VDI, Toad, Hue

SDLC Methodology: Waterfall, V-model, Agile (Scrum, XP), RUP

RELATED WORK EXPERIENCE

CGI Inc., Toronto Senior QA Analyst 08.2017 – 12.2018

Client: Scotia Bank, Toronto

Project: Anti-Money Laundering (AML) Transformation program

SDLC: Agile Scrum

Develop test artifacts for AML project for Individual, Organization and Trust parties based on mapping documents, business rules, HLSD and HFRD and Compliance documents

Prepared Test Case Matrix, Test Cases and Traceability Matrix and review those documents on BA, Developers and QA team meetings

Created AML Test Scenarios for PEP, VSD, STR, Sanctioned countries customer with AHR rates

Actively participated in daily Stand-Ups, Sprint Planning, Retrospective, Review, and Triage meetings

Prepared input data for multiple (10xn) cases with Risk factors combinations, ACI EDL project

Created and executed SQL scripts for test data validation

Analyzed ETL rejects and data process results using Log files

Executed test cases and verified test results E2E for Smoke, Functional and Regression tests for Individual, Organization and Trust parties

Deeply analyzed CRR test results for Customers with variety of Addresses, Industry Codes, Product Types and Account Status according to Risk Rating and Business Priority

Tracked data for CRR Case_ID on EDDU Reports and Daily Notifications

Performed End-to-End data verification for QS Standardization in multi-tier application as BD2/MDM/Files – Hadoop (BaselineStaging-QS-Baseline-QS-CSA) – Oracle_SQL

Widely used HP QC for saving test case data and results, open and track defects

Involved in QA test environment configuration including Hive and Oracle RDBMS and QA tools to analyze data in Hadoop and FSDM environment

Trained QA team to use documentation, create test scenarios and analyze DB data

Environment: Enterprise Data Lake (EDL) - Apache Hadoop/HDFS/Hive, Hue, Toad; MS Enterprise SQL Server, Oracle SQL Developer, Putty,, WinSCP, NotePad ++, VPN, MS Office, Windows 7, HP-ALM, JIRA, Confluence, Bit bucket, Github, Lync

TD Bank, Toronto Senior QA Analyst (contract) 05.2015 - 02.2017

Projects: TD Wealth Data Migration (TDW), Credit LOB Data Migration, Data Reconciliation, Production defects

SDLC: Agile Scrum, V-model

Created Test Scenarios for Initial and Delta Data Load, including Suspect Duplicate Processing (SDP), Survivorship Rules (CR), Customer Status Derivation (CSD), Decoupling, Data Segregation and Data Propagation based on HLSD and HLFR

Prepared Test Plans and Traceability Matrix and review documents on BA, SA, Developers and QA team meeting

Wrote and executed test cases and analyzed test data using SQL scripts in ST, E2E SIT, Smoke, Functional and Regression tests based on reference and mapping documents, business rules, SDS and

Created Business Use Cases with Complicated Test Scenarios including multiple Collapse/Split, Inactivate/Add transactions and Derivation and Reconciliation process

Complete QA Resources and Time-line estimations for Accelerated Golden Profile and Data Reconciliation projects

Worked with data analysis and verification using IBM Cognos Reports and Daily and Monthly Warehouse Notifications

Ran ETL and MDM batch jobs, analyzed mapping, coding, aggregation, cleansing processes and rejects

Performed data validation on Back-End (MDM DB) and Front-End (GUI - DSUI) testing

Widely used HP ALM to run test cases, open and track defects and replicated defect for developers

Performed Pre- and Post-data migration validations for code and data tables in v.9 and v.11 data bases.

Ran SOAP UI and XML tester jobs to create single party/accounts records using WSDL files

Trained and monitor offshore QA team of 4

Provided deep support for UAT team in test data preparation and test results understanding and analyzing

Executed jobs in Hadoop framework: Scoop-in for data ingestion, Pig Latin script writing, Hive queries for data analysis

Environment: DB2, MDM v9.5, MDM v11.2, InfoSphere DS/QS/Application/DB servers, IBM WebSphere MQ, IBM Cognos, DSUI, SOAP UI, XML Tester, HP ALM, Citrix, VDI, Putty, WinSCP, AutoSys, Windows 11, NotePad ++/NotePad/TestPad, SQL-Landuage, WebEx, Jira, Apache Hadoop/HDFS/Hive/Pig/Scoop, Hadoop Podium

TCS, North America Senior QA Analyst 11.2012 – 05.2015

Client: Bank of Montreal, Toronto

Projects: Suspect Duplicate Processing (SDP), Customer Data Matching (CDM), High Risk Unit (HRU), Anti-Money Laundering (AML), Foreign Account Tax Compliance Act (FATCA)

SDLC: Agile Scrum, V-model

Develop test cases based on mapping documents, business rules, HLSD and HFRD documents

Create and execute test scripts to validate various source systems such as Operational CIF(OCIF), Capital Market (CMCIF), Anti-Money Laundering (AML), Know Your Customers (KYC), Foreign-Account-Tax-Compliance-Act (FATCA)

Run server jobs for ETL and MDM data process jobs for Initial and Delta Batch Loads

Control ETL and MDM batch process using Test Director and Test Design tool

Extensively query MDM database using Advanced Querying tool (AQT)

Perform IDP, ETL and MDM data process and validation for Individual, Organization and Trust parties

Analyze ETL rejects, MDM Error Logs and PMP data validation

Responsible for Standardization (QS), Suspect Duplicate Processing (SDP) and Match/Merge (M&M) data process and analysis for different sources in scope – ECM and US_AML project

Run SOAP UI jobs to create single party records using WSDL files – HRU project

Lead QA team of 3 for ECM Probabilistic Matching Engine project

Environment: MDM v9.5, MDM v10.0, MDM v10.1, Netezza, InfoSphere DS/QS/Application/DB servers, SOAP UI, HP QC 10.0, AQT, Microsoft Power Pilot, Windows 7, NotePad/TestPad/UltraEdit, SQL-Landuage

InfoTrellis Inc., Toronto QA Analyst 12.2010 -11. 2012

Client: JCPenney Company Inc., Dallas, USA

Projects: MDM Data Migration

SDLC: Agile Scrum

Wrote, executed and customized XML test cases according to the requirements

Created test artifacts: plans, scenarios and scripts for address, name and identifiers standardization and cleansing

Performed integration testing using Interactive Service Tester, IBM RSA for WebSphere and JCP test tools

Extracted and transformed data from DB2 using SQL query for writing test cases

Analyzed Response test results and solved Request issues

Environment: Windows XP, JRE, IBM RSA, JCP, DB2, Liquid XML Studio, Trillium, Bug Tracker, Notepad++, Agile SDLC

B&B Insurance Inc., Toronto QA Analyst (contract) 09.2009 – 10.2010

Analyzed functionality of the application; developed test plan and test cases for company website

Conducted HTML/CSS validation, links/syntax/spelling/JavaScript checking using testing tools

Created, executed test cases using Visual Studio 2008 and WatiN Framework and customized the scripts Performed GUI testing using on-line and off-line methods with Surfoffline

Run Compatibility testing using – Mozilla Firefox, IE 6/7/8 and Google Chrome with Inspyder testing tool

Identified, reported and tracked test defects utilizing QATraq test management tool

Environment: Windows XP, Visual Studio 2008, WatiN Framework, HP QTP 9.2, W3C/WDG Validators, LinkChecker, CSE Validator, Inspyder, SpellChecker, JSON Formatter, JavaScriptEditor Pro, Microsoft IE 7.0/8.0, Firefox 2.0, MS Office, MySQL

KWizCom Inc., Toronto Software Tester (contract) 04.2009– 09.2009

Generated and executed test cases based on Functional Specifications and Business Requirements

Performed Functional, Security, Compatibility, Front-end and End-to-End testing using variety of testing tools such as JMeter and Validator(s)

Environment: MS IIS, MS SQL 2005, HTML, XML, HTTP, PHP, GUI, CLI, JMeter, W3C/WDG Validator(s)

Celestica International Inc., Toronto QA Analyst/Software Tester 04.2006 – 02.2009

Used HP QC 9.2 to create and execute tests, verify output vs. expected results and manage defects

Worked closely with team members to review requirements testability and participated in status meetings, peer reviews and other QA improvement activities

Developed and documented test deliverables such as Test Plan, Test Case, Test Procedure, Test Report and Test Log based on System Requirements Specification for product testing

Environment: Windows Server 2003, Oracle 8i, HP QTP 9.2, HTML, HTTP, TCP/IP, HP Quality Center 9.2, Citrix, ICT Teradata

Celestica International Inc., Toronto Test Engineering Support 09.2002 - 04.2006

Worked and trained with in Product transfer from Celestica, Oklahoma to Celestica, Toronto

Configure and set up test environment according to test scenarios and test data for 5ESS OS for 1st Article Test

Performed System Integration and Configuration testing, modifier automated test scripts (C-shell_ according to product hardware configuration and requirements (EUU and ANSI standards)

Ensured data integrity in Oracle DB with writing and running SQL queries

Participated in Customer, BA and Developer meetings, provided hardware and software time and budget estimations for testing cycles.

Environment: UNIX Sun Solaris 8, Oracle 8i, Clear DDTS, 5ESS Chorus, Shell scripting, LAN/WAN, Citrix, Matrix, FabView

Celestica International Inc., Toronto Failure Analysis Technician 10.1998 – 09.2002

Analyzed and debugged In-Circuit Test and Functional Test failures for Memory card - IBM, CISCO, Lucent Andrew products

Set up test process, provided test support according to standard methods and procedures, repaired test hardware

Tested, debugged and conducted Root Cause Analyses for Product prototypes

Trained test operators and junior technicians to the proper test failure diagnostics

Used advanced troubleshooting tools - oscilloscope, DMM, logic analyzer

Performed hand repair and soldering

Environment: Windows Server 2003, SAP, Citrix, ICT Teradata

EDUCATION

B.Sc. in Electrical/Electronic Engineering Kharkov Polytechnic Institute, Ukraine

ISTQB Certified Tester

Certificate of Web Applications in C#

Software QA and testing

UNIX Shell Script writing

C - Language Programming Humber College, Toronto

Celestica, 0n-site courses:

Web Applications in C#

Lean Manufacturing

Six Sigma – Green Belt Project preparation

MS Project

SW Quality Management Seminar

Unix Shells Script writing

Celestica, 0ut-site courses:

Navigate Operations and Programming Teradyne, Boston

FabView, Introduction National Instruments, Toronto

LabView &Computer-based Measurements National Instruments, Toronto

References: Available upon request

Contact this candidate