Andrew Ivanov Email & Phone Number

Moscow, Russia

- Weekly and monthly detailed financial analysis of sales, UNIT-economics (see sample tables in the portfolio).- Monthly ABC analysis for 300 SKU. I conduct it using my own improved methodology (see sample tables in the portfolio).- Calculation of the feasibility of participation in promotions and recommendations on pricing.- Setting up management accounting, incl. in the "Plan-Fact" and "My Warehouse" programs.- Planning (sales plan, procurement plan, payment calendar).

Moscow, Russia

Financial consultations in the course of IT projects implementation

Russia

- Basic Python (including loops, visualization, pandas, numpy libraries)- Statistical analysis (descriptive statistics, probability theory, hypothesis testing)- Methods of data preprocessing (omissions, duplicates, categorization, changing data types)- SQL (data slices, data grouping and sorting, joining tables, aggregation functions, subqueries and temporary tables)- Analysis of business indicators (metrics, cohort analysis, unit economics)- Hypothesis testing, A/B testing- Visualization and presentations (seaborn, matplotlib, plotly libraries, dashboards in tableau)- ScriptsSuccessfully completed 14 projects, including 2 SQL projects:- "Analysis of business indicators of a mobile application" (A/A and A/B testing, Matplotlib, Pandas, Plotly, Python, NumPy, SciPy, Seaborn, statistical hypothesis testing, product metrics, event analytics, conversion, funnel)- "Prioritization and testing of hypotheses to increase the revenue of an online store" (Matplotlib, Pandas, Python, NumPy, SciPy, product metrics, statistical hypothesis testing, ICE and RICE ranking of hypotheses, analysis of cumulative data, A/B testing)- "The study of patterns success of computer games" (Matplotlib, NumPy, Pandas, Seaborn, exploratory data analysis, descriptive statistics, data preprocessing, hypothesis testing)- "Identifying the causes of mobile app losses" (Matplotlib, Pandas, Seaborn, NumPy, customer base cohort analysis, product metrics, unit economics, conversion and retention, LTV, САС, ROI)- "Analysis of the Moscow catering market" (Pandas, Plotly, Matplotlib, Python, Seaborn, Folium, categorization, geoclusters, choroplet, creating presentations)

Moscow, Russia

Constant analysis of business processes, search for growth points (in accordance with the Pareto principle), debottlenecking and optimization made it possible to ensure every year profitability above the bank deposit rate (owner's requirement).- Control and analysis of the work of the e-commerce division: marketplaces and our own online store (pricing policy, promotions, analysis of marketing effectiveness, analysis of profitability and turnover). Weekly and monthly analysis.- Control and analysis of the profitability of customers (plan-fact analysis, generating business recommendations to increase profitability).- Capital turnover management. ABC-analysis. A 1.5-fold increase in sales of the leading brand over the year with a 10% increase in profitability and a 27% reduction in the matrix.- Accounts receivable management.- Determination of the pricing policy (approval of the price list, discounts and bonuses for customers, one-time compensations and promotions).- Weekly analysis of all key performance indicators of the group of companies (profitability, shipments, returns, discounts, bonuses, costs, actual markup ratio, DZ, PDZ, turnover).In the last three years (2019 - 2022) combined the functions of a financial and commercial director (management of purchases and inventory, pricing policy).Main achievements: 2-x increase in business profitability with a 1.6-x increase in revenue and a 12% profitability during pandemic (in trade).

Moscow, Russia

- Investment project implementation (more 10 billion rubles): development and adjustment of the financial model, control of project costs and credit covenants, preparation of reports for the bank.- Budgeting, foreign economic activity, control and reporting.- Working with large amounts of information in Excel (formulas, pivot tables, macros).- Preparation of financial statements, reports and presentations in Power Point.- Organization of the process of obtaining subsidies "from scratch". Full and timely receipt of all due subsidies from the state budget.Main achievements:- The provision of the holding's current activities during the year in the absence of bank financing and without attracting funds from shareholders.- Received subsidies in the amount of 1.5 billion rubles from the federal and regional budgets.

Moscow, Russia

- Budgeting, treasury, analysis, control, optimization of financial and economic activities, reporting.

Kazan, Tatarstan, Russia

Budgeting, treasury, analysis, reporting, cost control and optimization of financial and economic activities. Participation in negotiations with investors and creditors, preparation of investment prospectuses, business plans and financial models.Main achievements: the transformation of a loss-making enterprise into a successful, highly profitable business with an annual turnover of 2 billion rubles.

Data Analyst

14 projects, including 2 SQL-projects

Marketplace Analyst

1C: Trade Management

Plan Designer

Master'S Degree, Economy, 5

red diploma