Liliia Omelchenko Email & Phone Number

Kuala Lumpur, My

Moskow, Russia

1. Analysed marketing activities effectiveness using Python (Pandas, NumPy, Matplotlib) and SQL (Vertica, ClickHouse, GoogleBigQuery, MySQL);2. Created of BI-visualizations in the field of marketing for TOP-management (PowerBI, Tableau);3. Created marketing cubes (Direct channel) and maintained cubes for all marketing channels: SEM, SEO, Brand, Mobile (searched and rectified code weaknesses; detected data flaws within OWOX and Google Analytics);4. Developed customer segmentation (RFM, interest segmentation, email and push segments);5. Conducted research on the potential effectiveness of issuing bonuses to specialists, the need to attract new clients/specialists;6. Evaluated AB tests in email marketing;7. Conducted daily ad-hoc tasks.

Krasnodar, Russia

1. Developed short-term and long-term forecasting of airport activity results (aviation commerce);2. Visualization of data in the BI system (Tableau),3. Carried out operational and deep analysis using various tools (Tableau, MySQL, 1C (ERP, DO, SCP, AMS), Excel (advanced level): Power Pivot (DAX), Power Query);4. Conducted an expert assessment for making managerial decisions on the introduction of new services and launch of new flight routes;5. Performed automation of the department activities: developed and implemented analytical reporting into Excel, SQL, created of Dashboards in BI (Tableau) with display of key indicator6. Provided full cycle of support in database development: collecting information about department needs, writing technical specifications (exporting data from 1C to MySQL), process control, testing the result, creating tables and showcases, optimizing SQL queries to ensure speedup;7. Developed business model for budgeting (working with tabular forms for multidimensional data arrays): calculated of airport activity results (aviation commerce) for the reporting year with details (considering changes in tariffs, exchange rates, inflation, etc.)8. Mentored 4 internal stakeholders in terms of the use BI systems.

Krasnodar, Russia

Duties:Developed analytical reports for top management and business units in order to monitor performance as well as identify and reduce procurement risks (Excel use on advanced level);Created tools based on SQL queries to automate the activities of the department (SQL Server Management Studio, SQL Developer, Teradata);Described business processes occurring in the department (Aris, BPMN);Constantly analysed opportunities to reduce logistics costs by optimization supply chains;Introduced and managed projects to optimize warehouse space and ensure accuracy of monthly stock takes;Identified malfunction within ADR (Automatic Delivery Rewards) system, elimination of them together with the IT department;Developed automated performance evaluation systems for business units;Managed a staff of 7 people acting as a head of the sector after staff reduction.Achieved results:Facilitated introduction performance evaluation systems for inter-warehouse movements, resulting the reduce of additional movements of goods between distribution centres;Rectified several errors resulting 4% reduce of losses connected with food expiration date;Reduced logistic costs by $260,000 within 4 months.

Bachelor Degree, Business-Informatics

Training, Data Scientist

Data Science: machine learning, neural networks, exploratory data analysis, python.

Training, Exploratory Data Analysis Using Python

Python: pandas, numpy, sci-py, matplotlib, seaborn, scikit-learn, statsmodels.