Summary
Overview
Work History
Education
Skills
Websites
Projects
Timeline
Generic

SERGEY SHCHERBAKOV

San Francisco,USA

Summary

Senior QA Engineer with 13 years of experience, including 8 years in leadership roles. Expertise in validating Business Intelligence systems and complex data pipelines in enterprise environments. Proficient in ETL testing and data integrity validation using SQL, with experience in backend API testing and performance benchmarking. Strong ability to design test strategies and collaborate with cross-functional teams to ensure release readiness and enhance system reliability.

Overview

18
18
years of professional experience

Work History

Senior Quality Analyst (Contract)

Apple Inc
Cupertino, CA
04.2023 - Current
  • Developed and executed comprehensive test strategies for BI applications and data pipelines, ensuring data integrity and quality across financial reporting systems
  • Designed, maintained, and executed integration, functional, end-to-end, performance, and load tests; investigated identified issues through root cause analysis and effective troubleshooting
  • Created comprehensive test plans and detailed functional test cases based on business and technical requirements, ensuring thorough validation of system functionality, data accuracy, and edge case handling
  • Collaborated with engineers and product managers to establish quality metrics and implement validation checkpoints, ensuring alignment with business requirements and maintaining high data and system integrity
  • Performed comprehensive ETL testing across all stages of the data pipeline, where Apache Airflow orchestrated data extraction from Snowflake, loaded it into web-facing services, and made it consumable by DataKit; validated data integrity, transformation accuracy, and end-to-end flow consistency
  • Created and executed SQL queries to manually validate and compare source data against BI reports, ensuring data accuracy and supporting reliable regression testing
  • Partnered with DevOps to implement performance benchmarking using tools like Autocannon and Grafana ensuring scalability under peak loads
  • Performed API testing using tools like Postman, Swagger, CLI, and RapidAPI to validate request/response structures, status codes, and data accuracy; verified integration points and ensured robust backend functionality across multiple services.
  • Used Splunk and Sentry to troubleshoot system-level and application issues by analyzing logs, identifying error patterns, and supporting root cause analysis
  • Experienced in testing hierarchical data structures, ensuring data integrity and consistency across different levels of the hierarchy
  • Built Jira and Tableau dashboards to track test execution metrics, defect trends, and data anomalies, improving transparency and facilitating data-driven quality improvements
  • Regularly reviewed test documentation, defect notes, and incident reports to enhance QA workflows and drive higher product reliability
  • Served as the primary gatekeeper for live production issues, leading incident management from severity classification and root cause analysis to resolution, significantly reducing business impact
  • Managed QA efforts that contributed to a low volume of LiveOps issues by ensuring high-quality testing, proactive defect detection, and thorough pre-release validation

Senior Quality Lead Engineer

Wine.com
San Francisco, CA
06.2018 - 08.2022
  • Leading QA wine.com Functional and Automation team to cover Ecomm Frontend, Backend and Mobile (IOS and Android) related testing
  • Creating, maintaining, and running integration, functional, end to end, performance testing, whether locally or through a build system. Troubleshoot and diagnose any errors and failures
  • Managing new API Layer testing for the following systems: Shopping Cart, Order Placement and Discounting by executing API Scripts in Postman, Swagger, Jenkins and JMeter.
  • Creating Test Plans from scratch during transitioning of Wine.com’ s infrastructure to Amazon Web Services (AWS) that included test coverage for AWS’s Lambda, Simple Queue Service (SQS), and Simple Notification Service (SNS) that created a scalable, robust, and fault tolerant system to tie our back-end CRM and Warehouse applications to our Ecommerce website.
  • Contributing to end-to-end testing for new internal Order Maintenance web services Platform used by Customer Service Agents
  • Managing Functional Test Suites creation via Zephyr and automation suites by utilizing test scripts in Selenium
  • Developed tests in SOAPUI using XML scripts
  • Validating data accuracy by running API calls via Postman/Swagger and utilizing complex SQL queries via Microsoft SQL Server Management Studio
  • Conducting Performance Testing of the site by running JMeter scripts
  • Creating test plans for Dev Marketing Projects to cover testing of Tealium Pixels and Product Content Blocks using Braze, Contentfull, Optimizely and Launch Darkly Platforms
  • Providing QA support for upcoming multiple projects for Regression and Functional Feature testing for eComm, OMS, D365 and HighJump Platforms
  • Contributing into Confluence Documentation Library with detailed step by step testing instructions and Test Planning documents
  • Troubleshoot complex Production Support Issues
  • Hands on testing different Payment processing systems such as Vanviv, AMEX auto checkout, Apple and Google Pay, Apple Pay Express and Gift Cards

QA Lead Engineer

Revel Systems
San Francisco, CA
07.2014 - 06.2018
  • Leading QA efforts for development of Revel/Intuit QuickBooks Integration by creating test strategy and mentoring team members
  • Managing pre-release integration and regression testing including Web, Desktop and Mobile (IOS and Android) Applications
  • Designing and Executing Automation Tests in Selenium/Web Driver and Jenkins and API Test Coverage
  • Web Services API testing using Postman by utilizing GET, POST and PATCH requests
  • Develop end-to-end Web UI and REST API testing from test plans, test cases to test execution
  • Creating and editing scripts written in JavaScript coding language using Jasmine framework
  • Using Headless Chrome in node.js within “chrome-interface-remote-interface” package
  • Reviewing Logs and validating JSON to identify the root cause of the problem
  • Accessing MySQL Workbench DB using SQL queries to change XML files for test purposes
  • Hands on testing Hardware Technology such as Verifone, Ignecio, WorldPay and RP10 Pin Pads, EMV/Credit/ Debit/WIC/ EBT/ EFT/ Gift Card, Apple Pay and Google Pay Contactless technologies, digital scales , Honeywell, Zebra and Motorola scanners

Software Quality Assurance Engineer

Hightail.Inc
Campbell, CA
07.2011 - 06.2014
  • Conducted functional and regression testing on multiple platforms and different browsers for the SaaS Web and Desktop Applications
  • Reviewed requirements, specifications and technical design documents for new features to create detailed test plans and test cases
  • Utilized Firebug and XPath finder to develop API test
  • Worked close in connection with customer support team
  • Troubleshooted web application performance using Chrome inspector

Premier Banker

Wells Fargo
San Francisco, USA
09.2007 - 04.2011
  • Developed highest volumes of investment referrals in the district
  • Created a high ratio of Equity and Personal Loans
  • Utilized Firebug and XPath finder to develop API test
  • Built an exceptional relationship with clients

Education

Coding Bootcamp - HTML, CSS, JavaScript, jQuery, Bootstrap, Firebase, Node.js, MySQL, MongoDB, Express, React JS, Python, Django, Ruby, Java

University of California, Berkeley Extension
San Francisco, CA
09-2017

Data Administration and Management -

University of California
Berkeley
01.2015

Test Automation Course - Selenium WebDriver and Java

Computer Educational Center
San Francisco, CA
01.2015

BS - Finance

University of San Francisco
San Francisco, CA
12-2006

Skills

  • Operating systems: Mac, Windows, Linux
  • Database management: MongoDB, MySQL
  • Data interchange: JSON, APIs
  • Automation tools: Selenium IDE, WebDriver
  • Web development: HTML, CSS, Bootstrap
  • Programming languages: Python, Django
  • Scripting languages: JavaScript, jQuery
  • Server-side frameworks: Nodejs, Express
  • Database tools: Oracle SQL Developer
  • Project management: Jira, Bugzilla
  • Mobile development: React Native, Firebase
  • Web services: REST, SOAP, AJAX
  • Frontend frameworks: Angular, React
  • Development methodologies: Agile
  • Version control: GitHub
  • Testing frameworks: Jasmine
  • API testing tools: Postman, RapiAPI
  • Performance testing tools: JMeter
  • Cloud services: AWS
  • Analytics tools: Adobe Analytics
  • Data visualization tools: Tableau
  • Test management tools: Zephyr, TestRail
  • CI CD: Jenkins

Projects

CoffeeBreak — San Francisco, CA
A web application that allows users to personalize and summarize news articles from the New York Times and other sources.
Tools & Technologies: NYT API, Smmry API, React, JavaScript, jQuery, Material UI, Axios, MongoDB/Mongoose, Passport (Google OAuth)

Car Survey — San Francisco, CA
A personality-based car matching web app that enables users to find cars that align with their preferences and swap vehicles with other users.
Tools & Technologies: JavaScript, jQuery, HTML, CSS, Bootstrap, Sequelize, Handlebars, Passport

Timeline

Senior Quality Analyst (Contract)

Apple Inc
04.2023 - Current

Senior Quality Lead Engineer

Wine.com
06.2018 - 08.2022

QA Lead Engineer

Revel Systems
07.2014 - 06.2018

Software Quality Assurance Engineer

Hightail.Inc
07.2011 - 06.2014

Premier Banker

Wells Fargo
09.2007 - 04.2011

Coding Bootcamp - HTML, CSS, JavaScript, jQuery, Bootstrap, Firebase, Node.js, MySQL, MongoDB, Express, React JS, Python, Django, Ruby, Java

University of California, Berkeley Extension

Data Administration and Management -

University of California

Test Automation Course - Selenium WebDriver and Java

Computer Educational Center

BS - Finance

University of San Francisco

Similar Profiles

CREATE PROFILE
SERGEY SHCHERBAKOV