Katya Notkin Email and Phone Number

Project/Product Management=========================- Collaborated with product managers and eng teams on cross-team projects - Collaborated with business clients to understand their needs and agree on priorities for UA, CRM, Shipping & Payments, User Experience Research, and CX domains.- Planned quarterly objectives and key results based on company business needs and technology enhancement goals, primarily:---- Deliver data generated via ELT data pipelines to business users and 3d-parties---- Semi-automate manual tasks---- Deliver data engineering components for critical cross-team initiatives---- Proactively make software solutions more efficient and secure, upgrade software ----------------------------- Technical leadership=================- Integration with 3d-party data sources (Python, REST APIs, proprietary SDK, SFTP)- Effective data management, including data concistency, latency, retention policies, accessibility, privacy; solutions scalability, robustness, and cost-effectiveness; data modeling- Technical architecture for data pipelines: GCP -- CI/CD, BQ, GCS, Composer based on Apache Airflow etc.- Oversaw implementing data warehousing solutions - Innovative Solutions:---- End-to-end testing environment for Airflow/Docker-based architecture.---- Oversaw PoC for AI-powered solution using ChatGPT and LangChain to automate the collection of item inventory data----------------------------Team management================- Hired, facilitated onboarding, mentored full-time data engineers and co-ops, conducted performance reviews- Planned and ran Sprints to achieve business and technical objectives (Agile, Jira).

SQL consultingBig dataset cleansing, data points mapping (Spark/scala) projectWorking with data for stock fluctuation anomaly detection (Python / pandas, numpy libraries)QuizZella.com (2017)Software development for educational and gaming startup:- implementing microservices using AWS Lambda (Python3, MongoDB, jsonschema)- load testing against self-hosted MongoDB, Mongo Atlas

Engineering Lead, Data Warehousing - June 2016 - April 2017Sr. Data Warehousing Engineer, April 2013 - June 2016 Project planning, identifying and documenting functional and technical requirements, implementation for big data ETL and model trainingProposed and implemented innovative solutions and new functionality.PROJECTSResponsible for data warehousing, bid data processing, ETL project architecture and implementation for online advertising (Hadoop, Hive, Python, MySql, Spark/Scala, NoSql, Linux scripting, git, JIRA, Confluence, Agile) Roadmap projects serving the needs / in collaboration with Data Science and RTB teams:- Automated feature scores evaluation for real-time bidding predictive models. Reduced processing time. Fully responsible for product enhancements and adjustments to data growth- Proposed and implemented data generator for model training, utilizing transformed warehouse datasets, which allowed to save on RTB logging resources - Trained classifier models experimentiung with feature combinations, new advertising channelsImplemented ETL to attribute user conversions to ads served, aggregated data for further utilizationProcess re-architecture resulting in improved s/w performance, scalability, stability, data availability. Data acquisition project based on integration with 3d party API (Python, MySQL, Google DFP API)Outlined test environment setup (software, test data acquisition), led software hardening effort

Arista SolutionsDeployment of web/mobile app in Amazon Cloud 2012-2013- migration to AWS EC2 (Linux) / RDS (MySQL) – creating shell scripts for one-step deployment on AWS (bash, gawk, sed), git scripts for revision control- MySQL database consulting: data modeling, database and data manipulation, performance optimization - creating mobile app use cases to implement S3 integration for iOS appArista Solutions 2005-2006Cell phone towers location web site - Design / data ETL from FCC database/ implementation Marketing IMS for Ando Media via Arista Solutions LLC - Technical design/ development (C# / MS SQL Server)Cellular Towers IM / accounting web application (Java / JSP / MySQL) - Business transaction logging and other functional enhancements, Data Dictionary - Data migration / ETL project – populating production DB w/ data from proprietary client databases - configuring security / access policies for AWS resources (IAM / S3 bucket policies and TVM)

Software development to augment Quota Management System (stored procedures - T-SQL, C#)

- Managed software solutions RFP process, negotiated / awarded supplier contracts (industry: advertising)- Managed offshore projects (Russia, Ukraine) , coordinated requirements with technical architects - Served as a liaison between company and the client, managed client expectations.

Project management @ Professional Services, Custom Software group

Customer software system development - team leadership and client expectations management. - Functional and Technical Design - Implementation, including client checkpoints, change order requests management, system functional integration, testing, designing user test case scenarios and conducting user acceptancePlanning and tracking project implementationManaging project team (12 people)Client management (contract negotiation, scope management, conducting client checkpoints)Principal Consultant 1995 – 1999 i-Cube, Cambridge, MA- Assured internal delivery and UA of delegated business module (C/ Oracle / Unix)- Planned and led cross-module functional system integration- Developed UNIX scripts for automated system integration.

Maintained and extended software system used to support core product releases (Oracle PL/SQL, C, UNIX)

Responsible for clinical trials database (SQL, SAS, UNIX):- Responsible for data quality control - Responsible for data extraction and processing for MDs and medical statisticians- Database redesign for improving data availability initiative