Andrey Gladkikh - Резюме BI developer, BI analyst, Power BI developer, Power BI analyst

Experience: 1) Full time job: 1. JTI Russia (Japan Tobacco International) (https://www.jti.com/ru/europe/russia); Post: specialist in financial accounting and analysis. Term: 14.08.2022 – 15.11.2023 (1 year and 3 months), (termination of work at JTI due to the end of the company's operations in Russia) Duties: 1) Analysis of sales of cigarette products in the context of various time intervals: working with the sales database using MySQL, visualizing the results obtained using the libraries Pandas, Seaborn, Matplotlib in Python. 2) Periodic analysis of the production of cigarette products using MySQL and visualization of the results obtained using the libraries Pandas, Seaborn, Matplotlib in Python. 3) Analysis of the work and workload of each team member during various time periods, analysis of KPI of team members: development of relevant dashboards using Power BI. 4) Participation in the process of budgeting the company's administrative expenses, control and analysis of the implementation of the company's administrative expenses budget plan using the development of relevant dashboards in Power BI. 5) Develop and maintain dashboards in Power BI to analyze the company's working capital based on information from databases. 6) Periodic optimization of reports built using Power BI, as well as Pandas, Seaborn, Matplotlib in Python, updating the methodology for calculating various metrics in Power BI. 7) Development of various new dashboards in Power BI for the purpose of analyzing the company's operations. 8) Periodic leadership of a team of 10 people during team-leader leave/illness. 9) Sensitivity analysis of the company's operating results (cost, sales, EBITDA) 10) Preparation of monthly, quarterly operational reports within the framework of management accounting, periodic initiation of postings in SAP. Achievements: Improved, as well as developed new reports in Power BI, improved the practical skill of using MySQL, as well as the libraries Pandas, Seaborn, Matplotlib in Python. Soft skills have been improved: the periodic leadership of the analyst team has allowed developing leadership qualities, as well as developing the ability to find a common language with each team member. Communication with foreign colleagues on a regular basis made it possible to increase knowledge of the English language. 2. Ilim Timber Industry (https://ilimtimber.com/) Post: financial analyst Term: 06.08.2021 – 09.08.2022 (1 year) Duties: 1) Assessment of the economic efficiency of various investment projects aimed at improving the company's performance; 2) Sensitivity analysis of various economic indicators (cost, sales, EBITDA). 3) "Plan-Fact" analysis of the company's working capital; 4) Formation of operational reporting, sensitivity analysis of the company's operating results using Power BI; 5) Calculation of the cost of the unit of the company's production; 6) Participation in the budgeting of the company's administrative expenses, analysis of the company's administrative expenses using Power BI; 7) Participation in forecasting the company's production program; 8) Participation in forecasting the company's sales; 9) Assessment of the economic efficiency of various projects of the company, proposal of alternatives for cost-effective implementation of projects, control and evaluation of project implementation: • reorganization of sales (change of geographical area for sales, setting of new final prices for products - analysis of how economically profitable it is to make certain changes in activities; proposals for organizing these changes in activities in the most cost-effective way); • bringing a new product of the organization to the domestic market and the international market - assessing the economic effectiveness of the processes of bringing a new product to the markets (from planning what exactly this product will be to the sale of this product to end consumers); • introduction of a new production line - assessment of the economic effect of the introduction of a new production line at the plant; • reorganize production workers time in the plant to minimize downtime and shortfalls. 10) Generation of weekly, monthly, quarterly operational reports within the framework of management accounting, visualization of the results obtained using Power BI. 2) Part time job (practice at the university): 1. AGR Softwer (https://agr4.ru/ru/) (University project in terms of education) Post: Junior Consultant Term: 02.2016-06.2016 Duties: • Preparation of primary and element-by-element SWOT analysis. • Preparation of PEST analysis. • Development of primary strategic alternatives to the company's development based on the analysis performed. Result: Strategic alternatives received support from the company's economists (these alternatives were economically justified, the calculations were carried out correctly). 2. EDUCA (https://educa.ru/) (University project in terms of education) Post: Junior Consultant Term: 03.2017-05.2017 Duties: • Comprehensive analysis of the online English language learning market in Russia. • Analysis of the company's business model. • Development of a strategy to retain the company's current customers. • Development of a primary strategy for scaling up the company's operations in other countries. 3. KARAT (https://karatspb.ru). Post: Junior analyst (University project in terms of education) Term: 06.2018-07.2018 Duties: • Participation in the calculation of the cost of production. • Participation in the development of a system for optimizing the production process and reducing the cost of production. • 4. Faurecia (http://www.faurecia.ru/) Post: Junior Consultant (University project in terms of education) Term: 09.2018-11.2018 Duties: • Development of the optimal route of delivery of the company's products from the USA to Russia. Results: A detailed scheme for transporting containers through the United States and Europe has been built, all time and money costs accompanying the entire supply chain have been calculated. 5. AB InBev (https://abinbevefes.ru/) Post: Junior Consultant (University project in terms of education) Term: 11.2018-12.2018 Duties: • Preparation of ABC, XYZ and FMR analysis. • Development of a warehouse project for a plant in St. Petersburg, taking into account the peculiarities of storing alcoholic beverages.

2021: St. Petersburg State University - Faculty: "Economy" specialty: "Management of Organization Development" (Master) 2019: Higher School of Management of St. Petersburg State University - Faculty: "Management," specialty: "Logistics" (Bachelor)

• MS Excel – Advanced level • SQL (MySQL) – Medium level • Power BI – Medium level • Python – Beginner (libraries: Pandas, Seaborn, Matplotlib) • PowerPoint – Medium level • SAP – Beginner • Version control system (git) (GitHub) – Medium level • Soft skills: periodic leadership and management of a team of 10 people.

Английский Итальянский

I am interested in analytics