Igor Starostenko Email & Phone Number

San Francisco, CA, US

San Francisco, CA, US

Irvine, CA, US

Irvine, CA, US

Irvine, CA, US

• Designed and implemented a data warehouse model, ETL and reporting from the group up on Google Cloud Platform for the multi-platform car subscription product
• Developed cost efficient data pipelines in Python and Go that load data into Cloud Storage and BigQuery from multiple 3rd party services as well as internal cloud managed sources and databases using Dataproc, Cloud.
• Worked closely with marketing team to collect attribution data from different platforms, marketing spend from different sources, investigated issues and provided analytics on user conversion, marketing attribution and.
• Helped to define multilevel product KPI and built visualizations for each metric using Google Data Studio and BigQuery that are based on Segment events and Business data
• Built reports for each platform (web, iOS and Android) with insights on user events, conversion, devices and sources using data collected from Mixpanel API
• Performed devops to configure VPC access and set up CI/CD for data pipelines with Cloud Build

Irvine, CA, US

• Managed ETL data pipelines, Redshift data warehouse using AWS, Apache Airflow as well in-house built services for data analytics
• Rebuilt daily load data pipelines for main data sources (Segment and Mixpanel) to optimize costs of operation by avoiding the usage of expensive 3rd party ETL tools
• Built a data lake of user events in AWS that are stored in parquet format in S3 and queryable with Redshift or Athena using Glue data catalog
• Developed custom data load workflows from both external and internal data sources to support analytics efforts using Apache Airflow
• Worked with marketing team to provide them with insights on campaign performance, attribution and costs; Designed a workflow that takes a daily snapshot of prices for each UTM source and calculates marketing spend.
• Optimized Airflow DAGs for local development and testing; started incorporating data validation tasks for each data load pipeline that automatically tests loaded data and sends notification in case of failure to ensure.

Irvine, CA, US

• Built an internal analytics engine based on Next JS web application and Express server with REST API that connects to external data sources and uses Elastic Search, MongoDB, MySQL and Amazon Redshift to generate.
• Responsible for the quality of AutoGravity web application, web widget, web API and a private label web application. Ensured having frequent and stable releases
• Developed an open source service with REST API and GraphQL that collects data on test runs from different projects, aggregates metrics and provides a React Redux UI dashboard with reports, analytics and management.
• Designed and built a data driven, scalable automation framework for React based web application and web widget using RSpec, Capybara and SitePrism in Page Object model
• Developed browser native E2E build acceptance tests with visual diff using Cypress and Applitools Eyes and integrated them into Jenkins deployment pipeline with AWS ECR

Santa Monica, CA, US

Test Automation development for Print on Demand service

Santa Monica, CA, US

• Ink and Main Team.
• Developing and maintaining automated test scenarios for Ruby on Rails application using Cucumber/Capybara framework in Page Object model, running Poltergeist and Selenium drivers
• Writing application specs for new features as well as extending test coverage of the existing functionality in Gherkin in cooperation with project managers, QA engineers and developers, applying BDD practices
• Mentoring and coaching other QA Engineers in the company in development of test automation framework based on the needs of each division’s project
• Performing load testing of the application and new features using JMeter
• Developed a sku testing tool based on Selenium WebDriver and performed automated tests for each template in every environment to ensure that each unique sku conforms to requirements

• Testing client-server Mobile applications (Android and iOS) for multiple sports teams and events based on unique requirements from project to project
• Close cooperation with developers in debugging issues and covering various use cases
• Gathering app specific requirements and Test Planning for multiple mobile applications. Writing full regression test documentation.
• Development of Test Automation scripts to perform regression testing that cover platform’s basic functionality using Selenium Web Driver and Appium framework
• API testing of numerous requests for different events and sports stats (hockey, basketball, etc.) including live game scenarios. Verifying if server responses in the expected JSON format
• Testing Geo Location services to verify that users in particular areas receive geo based content and ads