Pesach Horodnyy Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

Project: Digital Modernization program: Public Secure authentication solution.• Conducted meetings with BAs, Solution Architect, Technical Lead, System Analysts to review BRD, Mock-ups, flowcharts, Solution Design documents from QA perspective.• Created and executed Use Cases, Test Scenarios, Test cases for testing Public Secure Microsoft Azure Cloud SaaS on different browsers, mobile devises (iOS,Android) and integration with other government clusters and services.• Managed Defect logs in Azure DevOps. Participated in Defect Triage meetings to resolve the issues efficiently.• Created and managed test artifacts under Test Plans in Azure DevOps.• Tested data migration script from OneKey users database to Public Secure cloud.• Provided Test progress update to the managers and team.

Concord, Ontario, Canada

• Performed Testing Maturity Assessment against the target level from TMMI model for company’s test process improvement.• Led testing activities on Product Security project.• Created detailed Test Plan, Test scenarios, test coverage Traceability Matrix.• Created and executed manual test cases and automation scripts for continuous integration. • Verified security requirements are met on the Cloud and on-Premises integrated software environment.• Validated data integration through API services.• Validated data against Data Base Library in Analytics.• Created and supervised Stories, Technical Tasks and Defects in JIRA.• Used Confluence and JIRA to collaborate, assign tasks and share information about the project status efficiently.• Facilitated meetings with developers, business analysts, stakeholders.

Toronto, Ontario, Canada

• Helped the multi-million project to meet the aggressive release deadlines and assure the data quality by streamlining the testing approach and implementing a unique model of managing mixed (offshore and onsite) QA Team.• Developed QA practices and processes applicable to the project’s specific needs to increase testing effectiveness and efficiency.• Revised and updated quality standards, ensuring policies and procedures are enforced within the project.• Assigned work to team members and optimized resource allocation.• Created Test Strategy and detailed Test Plan.• Managed Test Scenarios/Test Cases/Test Scripts creation and execution.• Created semi-automated complex SQL scripts for data validation and regression testing.• Validated data loaded via near real time SAP HANA SLT interface and ETL jobs from different sources to EDW Data Foundation Layer (Landing).• Validated data correctness in the AO (SAP BI Analysis for Office) Reports and COGNOS Reports using complex SQL queries against the source database. • Validated data in Tableau reports for Data Analytics with QuerySurge Test Automation tool.• Created scripts for an automation test suite for Master Data health checks and regression testing.• Participated in Sprint planning and provided QA estimations.• Created Test Execution Status report after each sprint to share the testing progress with stakeholders.• Led Defect Triage meetings to ensure all defects are assigned to the appropriate team members and the defects are fixed/retested/closed in a timely manner according to the Priority/Severity.• Set up and supervised Microsoft Visual Studio Team Foundation Server (TFS) as sprint planning, development/test case creation progress trucking and test execution/defect management tool.• Used HP ALM as a global defect management tool.• Facilitated meetings with business and developers to find a root cause and resolve issues discovered during testing.

Toronto, Canada Area

• Created Test Strategy, Test Plan, Test Schedule, Traceability Matrix, Risk Assessment documents.• Coordinated testing activities for all testing phases – System, Integration, End to End, Automation, Performance and User Acceptance. Responsible for test resource coordination and test estimation.• Worked with team members to ensure testing deliverables are in compliance with the quality standards and deadlines. • Managed small (2-3) and large (up to 10) test teams for different CTC projects.• Created and executed Test Cases for System, Integration, E2E, Regression, UAT testing for various projects within Canadian Tire.• Created and executed SQL Queries and scripts for data validation in DB2, Oracle, IBM Netezza, Hadoop HBase/Hive Data Warehouses. • Executed ETL jobs using IBM WebSphere DataStage as the ETL tool from UNIX SHELL scripts, ESP Scheduler or directly from JCL Library in TSO environment.• Validated data loaded correctly into different layers of the Data Warehouse (Landing, Staging, Data Mart) based on the ETL transformation rules and error handling rules defined in STM using SQL queries and scripts. • Executed IA jobs for integration between disparate applications across multiple hardware and software platforms and validated data loaded through IBM ESB/MQ/ WebSphere Message Broker. • Created semi-automated scripts for data validation.• Validated import and extract files in different file format: CSV, delimited, fixed length, XML.• Validated data correctness in the COGNOS Packages and COGNOS Reports using SQL queries against the source database. • Worked closely with Automation team to develop Automation Test suite using HP QTP v10.0.• Worked with Business to improve process flows based on the test results.• Set up and administered HP QC / HP ALM as test execution and defect management tool.• Facilitated meetings with business and developers to resolve issues found during execution.