User's Cover Picture
User's avatar

Mikhail Shapiro

Senior QA Professional - lead, SQL, automation, management

Message
Intro
Richmond Hill, Canada
Joined April 8, 2021

Skills

About
I am from Canada where I finished high school, university (degree in Comp. Science) and worked for 20+ years in IT QA consulting in Canada, US and Europe. I am also fully fluent in Russian and worked for American company Parsons Global Services in Russia from 2003 to 2006. I have lots of experience in complex technical environments with a lot of technical expertise (like SQL, Oracle, ETL and automation) as well as about 10 years of lead experience. I can be reached by email at mikhail.shapiro1@gmail.com, by phone at +972-52-209-7009 or on WhatsApp at 1-647-654-5006.
Loading...
Experience
User avatar
Ontario Ministry of Education: Student Lending Project
Nov 2022 – Jul 2023
Toronto, Ontario, Canada
Senior QA Specialist
• Writing complex multi-table Oracle SQL scripts to automate generation of formatted flat file test data files including header, detail and trailer records as well as post batch processing expected results verification with exception reporting • Functional and accessibility (AXE, NVDA, CCA) testing of Student Lending system • Mentoring junior team members in SQL • Creating manual test cases from business flow Visio diagrams • Using ALM for defect recording Tech Environment: Windows10, Jira, ALM, Oracle SQL, Sharepoint
User avatar
Finastra
Feb 2022 – Oct 2022
Toronto, Ontario, Canada
Senior QA Engineer
• Functional and accessibility (CCA, NVDA, AXE) testing of IBM Power BI Reports • Using Jira to manage user stories and defect resolution flows, and Microsoft VSTS for test artifacts • Using Informatica to manage ETL workflows, SQL/DbVisualizer for back-end verification Tech Environment: Agile, Jira, Azure, Databricks, Azure Data Factory, SQL, Power BI, Windows 10
User avatar
Ontario Ministry of Health: Sales Force COVID-19 Vaccine & Immunization Management
Oct 2019 – Nov 2020
Toronto, Ontario, Canada
Senior QA Specialist / Lead
• Functional and accessibility (AXE, NVDA) testing of Sales Force CCM system • Coordinating testing and production validation • Using Jira and TestRail to manage user stories, test cases and defect flow • Using IBM Cognos BI, SalesForce Workbench and Oracle for back-end verification • Creating custom Cognos BI and SalesForce reports • Participating in daily stand up meetings and deployment testing Tech Environment: Agile,Jira,HL7,TestRail, IBM Cognos BI,SalesForce Workbench Oracle DB, Windows10
User avatar
Ontario Ministry of Health: Health Claims Processing Project
Oct 2019 – Nov 2020
Kingston, Ontario, Canada
QA Automation Analyst
Created user guides for QA team for: • Use of IBM RQM integration with IBM RFT automated tool • Use of IBM Rational Clearcase Team Explorer use for source control and RFT project import • Setting up Virtual Oracle Box (VM) • Converting manual RQM test scripts into automated intelligent RFT scripts and integrating it into test cases in RQM • RFT Java scripts including DB2 and Oracle DB access for backend verification • Using RQM to maintain all testing artifacts Tech Environment: RFT with Java, RQM, Eclipse, DB2 and Oracle DB, Oracle VM, Windows 7/10, TSO/SPF
User avatar
Toronto Transit Commission: VISION CAD/AVL Project – Interface / Systems field testing
Apr 2017 – Aug 2019
Toronto, Ontario, Canada
Sr. QA Analyst
• Conducted complex multi-phase interface testing in multi-tier environment between TTC and Clever Devices CAD/AVL (automatic vehicle location) systems. • Conducted API testing using Widzler and Restlet tools • Conducted extensive Clever devices CAD/AVL mobile testing on Android tablet. • Used BizTalk Middleware, CSV, HTTP, XML, JSON, and flat files during interface and API testing. • Created and maintained testing artifacts (Test Strategy, Test Plan, Test Cases, Defects as well as administered defects resolution process using TFS. • Organized and managed defects triage meetings. • Used SQL Server Management Studio for data query, manipulation and validation. • Created unit and end-to-end automated functional scripts using Selenium with Java. Tech Environment: Java, Windows 7, Unix, Microsoft TFS, Oracle Developer, SharePoint, Selenium, Eclipse Junit, TestNG, Cucumber
User avatar
Carillion Canada: HR/Payroll Enterprise system implementation of Ceridian Dayforce Work Force Management (WFM) System
Jun 2016 – Apr 2017
Toronto, Ontario, Canada
QA Lead
• Using MS Project created test plan with test cycles, testing effort estimation and resource requirements • Developing test strategy/test cases for system and UAT testing focusing on employee benefit plans and time keeping/payroll as per complex union collective bargain agreements • Organized and lead defect/issues triage meetings • Formulated detailed ETL data migration and data mapping plan • Used defined business processes and interviewing business users to design business process diagrams. • Used QA Complete test CASE management software to set up full testing environment. • Demonstrated unit and end-to-end automated functional scripts using Selenium with Java Tech Environment: Agile, Windows 8, Java, .NET, Selenium, Junit, TestNG, Cucumber
© 2025 RemoteHub, Inc.
GeneralHome PageFind WorkVolunteeringBuy ServicesBrowse PortfoliosTest Ideas
Job CategoriesMedical & HealthcareWeb, Mobile & ITMarketing & SalesBusiness & ConsultingDesign & CreativeEngineeringCustomer SupportWriting & TranslationLegal & Finance
Help & SupportHelp CenterCommunityBlogTerms and ConditionsPrivacy Policy