Developing and maintenance of data loading pipelines from various datasources to the DWH as well as creating data marts for business purposes based on DWH-stored data. Stack: Python, Airflow, S3, Greenplum.
 As part of my work responsibilities I’ve successfully onboarded new engineer to our team. My responsibilities also involved maintaining legacy DWH, based on Python, Airflow and Amazon Redshift. I performed basic administrative tasks via AWS console. Developed a Python Class for templating raw data collection, which helped significantly reduce the amount of code and time needed for adding new datasource to the DWH.

ETL process development and maintenance using Python, Apache Airflow, pandas, psycopg2. Designing and implementing various API-queries, including Facebook, Appsflyer, Adjust etc. Building and optimising data processing pipelines. PostgreSQL database administration, developing complex queries. Marketing funnel analysis, selection of profitable and detrimental segments. Hypotheses designs and testing, results evaluation. Making recommendations for the User Acquisition team. Reporting automation using Google Spreadsheets, Redash, Slack, etc. Fully re-worked one of the data processing pipelines using object-oriented approach, which resulted in more then two-fold increase in execution speed. Developed a service which processed and uploaded csv/xlxs reports to the database from Slack channels as part of the automation process. After first year on this position, I actively participated in interviewing and onboarding and mentoring process of five newly hired Junior Data analysts.

Produced and repaired PCBs and robots using laser cutter, 3d-printers, soldering. Administered Linux-based PCs and Raspberry Pi's. Implemented Kanban methodology using Asana into Tech Support departments workflow. Google Spreadsheet was used before. Drew up instructions and process description. Held a seminar for colleagues explaining the new process. As a result, the amount of work previously requiring three engineers was performed by two.

Communications with partners concerning new e-book and audiobook releases, financial statements etc. Internal team coordination: rights manager, sound-engineer, editors, voice actors etc. Managed outsource audiobook production. Recording and editing audiobooks using Logic Pro X, Adobe Audition. Technical support of internal and external processes. Publishing House audiobooks and e-books Database administration. With my direct participation Helvetica Publishing was named Electronic Publishing House of The Year 2015.

Faculty of Infocommunication Technologies, Mobile and Network Technologies

Faculty of Infocommunication Technologies, Information Systems and Technologies

Central School of English, English