You can open access to the talent’s contacts. Click and buy!
– Agroholding “Belaya Dacha Trading”
– Business analyst
Responsibilities:
– Participation in the creation of a system of indicators and reporting in the direction of the supply chain;
– Regular analytical work and reporting in the direction of the supply chain, in particular, analysis and identification of the reasons for over-stock and out-of-stock of raw materials;
– Participation in project work on automation and optimization of planning for the supply of raw materials, production, sales, etc.;
– Training the sales team in sales analysis tools developed by the BI department;
– Participation in projects of the department – finalization and maintenance of the report “Sell in / sell out”, etc.;
– Control of the correctness and completeness of data: reconciliation, elimination of errors, maintenance of the necessary directories in reporting tools;
– Support for the Company’s divisions on analytics, costs and reporting.
Achievements:
– Creation from scratch of a management reporting block for the agricultural direction “DSR Agro”;
– Creation and two-time daily release of the Report on customer orders;
– Automation of information processing on agricultural work for the presentation of AgroSOP;
– Development of the “Conveyor” model for forecasting the harvest;
– Interaction in a team at the department level to solve the problem of uploading data to predict the company’s sales.
Start of work : March 2023
Completion of work: to the current day
– LLC “Cotton Club”
– warehouse logistics analyst
Responsibilities:
– Preparing daily and monthly reports
— Plan / Actual cost analysis
— Analysis of residues and organization of the supply of raw materials to the production site
— Interaction with IT on reporting
— Analysis of residues by sites and distribution of the incoming flow of raw materials and finished products by storage sites
— Forecasting, budgeting costs
— Preparation of analytical reports for the head
Achievements:
— developed a report comparing the consumption of raw materials over the past two months with the production plan for the week, about 40 thousand SKUs. Detailing by the volume of raw materials and the excess of the weekly stock in the context of one and / or several warehouses.
Outcome:
Reduced the cost of surplus purchases of raw materials to eliminate losses on expired raw materials.
Savings on renting storage space amounted to 7.5%.
Start of work : November 2022
Completion date: January 2023
– LLC “DNS Retail”
– Business analyst
Responsibilities:
– Maintain warehouse records in Excel, Google Sheets.
— Collection and consolidation of data from various sources (1C UT, through SQL queries in 1C).
— Analytics of efficiency in various sections.
— Analysis of shipments of goods by region.
— Control and analysis of the write-off of consumables.
— Regular checking of reports for errors, optimization and improvement of the type of reports.
Achievements:
Based on data from SQL queries developed reports:
– monthly analysis of the movement of goods in a cross-docking warehouse;
— daily analysis of the volume of shipped goods on the basis of FIFO;
— analysis of the limit threshold of the total cost of goods in one vehicle;
— developed and implemented the Team Wages (BOT) system based on Google Sheets, which became the first stage of the project for the implementation of BOT in the 1C UT database.
Start of work : March 2018
Completion date: September 2022
– LLC “Balashikha Foundry and Mechanical Plant”
– Production planning economist
Responsibilities:
– Analysis and accounting of movement, control of the minimum balance of components for the assembly shop of finished products.
– Accounting and analysis of the movement of finished products.
— Monitoring the fulfillment of contractual obligations to the customer.
Achievements:
– based on Excel, developed and implemented an intershop system for accounting for the movement of components for the key mechanisms of aircraft.
Start of work : March 2017
Completion date: February 2018
Excel, Power Query, Power Pivot, DAX language functions, M language, 1C query language, Power BI, VBA, Google Sheets, Working with large amounts of information, Management reporting development, Data analysis.
Moscow State Industrial University
– Automobile and tractor construction
– Company car service
– 2011
I made my passion my work, I consider this an achievement both for myself and for my future employer.
It was my previous work experience and passion for programming that led me to the profession of a business analyst.
Development and implementation of reports, automation of the product accounting system gave me the necessary skills.
The ability to analyze, understand the operational processes of the organization, I can clearly express my thoughts.
I am moving with my family to Serbia.
