Data Engineer

Natalia Ermolova

*** ********* ***, ******* ****, CA 94062; cell (650) -576-8222; email: *********@*****.***

Objective: Database Development and Web Applications

Skills: Redshift, PostgreSQL, ETL, MySQL, AWS, Airflow

PL/SQL, SQL, Oracle, Oracle Web Application Server, SQL*Loader

HTML, CSS, JavaScript, Java, JSP, J2EE, XML, Tomcat, Python

UNIX/Linux-based systems, Github

Professional Summary:

15+ years of experience developing database applications, server and client side. Good in performance tuning of complex queries and implementation of indexing strategies. Experience in Data Modeling, Database design and well versed with best Redshift, Postgres and Oracle practices. Designed scaling strategies using table partitioning, database partitioning and data sharding strategies across multiple servers for Postgres and Oracle.

Comfortable with HTML, CSS and JavaScript. Have done limited coding in Java and Python. Git/Jira/RTC

Employment History:

Sr Database and ETL Developer 07/2017 – 12/2017 (operations suspended)

MeetOtto; San Mateo, California

Created AWS Data Pipelines to load data into Snowflake based data warehouse. Configured Kinesis firehose for streaming log data into S3 buckets. Implemented data validation and cloning strategies. Implemented data generating queries for use in Tableau. Developed lambda functions for data event processing.

Snowflake, Python, Github, AWS administration.

Sr Database Developer 10/2014 – 03/2017

Bigcommerce; San Francisco, California

Reconciling production log data with site transactional data. Populating decision support warehouse for use by data scientists and data analysts. Supporting and designing ETL processes within AWS to bring data from MySQL, Postgres and MS SQL into Redshift warehouse, supporting development and management teams with custom data extractions requests.

Airflow, Python, Github, Redshift administration.

Advisory Software engineer 04/2013 – 10/2014

IBM/Tealeaf; San Francisco, California

Working on converting IBM Tee Leaf software platform from MS SQL Server to Postgres

Redesigning stored procedures, sql statements and other database elements to take advantage of PG superior features

Implementing multitenancy and sharding support using PG schemas to insure product scalability across cluster of servers as well as allowing multiple clients share single product installation.

Database Developer 10/2011 – 04/2013

RPX Corporation; Rational Patent; San Francisco, California

Working with PostgreSQL/PG-PSQL/PL-SQL performing data transformation and load. Converted multiple years of un-structured/semi-structured xml patent data into postgres data warehouse. Implemented complicated ranking and data de-duplication logic along with procedures to support continues updates from incoming streams of data. Collaborated with app developers on schema layout.

Applications Engineer 04/2002– 09/2010

George P. Johnson, Privately Held; Marketing and Advertising industry; San Carlos, California

Education: BS in Power Engineering, Moscow University, Moscow, Russia

Contact this candidate