Aleksandr Zmeev

Senior Software Engineer

Libra Hospitality•  April 2019 - Present

Main reports - Created and fixed main reports - over 100 - Implemented machine learning algorithms to predict hotel occupancy. - Client-server app with more than 1000 users. - Used tools: Stimulsoft, Power BI, SSRS, Crystal Reports, MS Excel (pivot tables, getting data from different sources, filling by script), Tensorflow, Flask, Jira, Git and SVN Automated SQL-query testing - Implemented automated SQL-query testing - Used tools: python, pytest, pandas, sqlalchemy Database performance - Improved database performance and loading speed - Optimized queries - by writing T - SQL statements, complex stored procedures, dynamic SQL queries, scripts, functions, triggers, views, cursors and query optimization - Improved Indexes (+ Removing duplicate Indexes) - Defragment Data Data Engineering - Acquire datasets that align with business needs - Developed algorithms to transform data into useful, actionable information - Build, test, and maintain database pipeline architectures - Collaborate with management to understand company objectives - Createed new data validation methods and data analysis tools - Ensure compliance with data governance and security policies - Created a platform for processing and analyzing data.

Software Engineer

OTC Tender•  September 2015 - March 2019

Main reports - Wrote more 500 reports - Developed, optimized and maintained SQL stored procedures and views as sources for SSRS reports. - Designed and maintained corporate reports using MS Reporting Services, SQL stored procedures, advanced Excel (VB, Pivot tables and charts) - Used tools: PostgreSQL and MS SQL databases, SSRS, Power BI, Crystal Reports, MS Excel, Jira, Git - Created website - assistant to online bidding (tenders) Recommendation system - Loaded data from different platforms - Worked on different data formats such as JSON, XML and performed machine learning algorithms in Python. - Used PostgreSQL, Pandas, NumPy, Seaborn, SciPy, Matplotlib, Scikit-learn, and NLTK in Python for test various machine learning algorithms. - Jira, Git, Flask - Implemented vendor recommendation system - the number of unallocated tenders decreased by 60% ETL - Worked with business users and business analyst for requirements gathering and business analysis. - Converted business requirement into high level and low-level design. - Designing and customizing data models for Data warehouse supporting data from multiple sources on real time. - Supported daily loads and work with business users to handle rejected data. - Used: PostgreSQL + Python + Pentaho DI (info about tenders from different sources) - Wrote scripts to process text files using Python and JScript, visualized data using Python Big data part - Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data. - Created Hive queries for market analysts. - Reviewed Hadoop log files - Loaded data from 5 main tender-oriented sites.

Software Engineer

Rosneft •  October 2007 - September 2015

- CAL, C/SIDE Development, Confidential native database, SQL Server 2005, 2008 - Perform business requirement analysis and design - Perform gap analysis between standard Dynamics NAV functionality and business requirements - Configure Dynamics NAV - Identify and recommend product customizations, enhancements or work-arounds to meet business requirements - Author all standard documentation as well as specifications for both functional and technical requirements - Train users on new business processes and using Dynamics NAV 3.7 and 4.0 - Develop data conversion and testing strategies - Cold calls in sales department - SSRS, Jira, SVN, RedMine

Don State Technical University

Mathematics, MS•  September 2002 - December 2007

Specialization - Cybersecurity