• weekly & monthly sales calculation, control and modeling dynamics to achieve indicative values, automation processes, report on certain product group balances;
• participation in daily sales calculation, detection and analysis of abnormal trend deviations, forecasting;
• responding ad hoc requests from team or clients to calculate, analyze and visualize data;
• creating complex data models, interconnected tables and directories;
• calculating specific indicators of market activity.

Organization and control of cross-linked Google Sheets architecture for media advertising agency management accounting, including:

• media campaign realization database, control of data entry, period-end closings, automated calculations for project teams profitability, specific KPI's for key clients, forecast vs. actual analysis;
• project teams KPI tracking files, individual employee performance metrics;
• organizational structure & financial modeling, headcount data, employment types, tax liabilities, integration with financial forecasts to model agency profitability and unit economics;
• monthly payroll processing, base salaries, performance bonuses, % workload, business trips, benefits;
• monthly Profit & Loss reporting, automation;
• Power BI dashboards, other presentations;
• ad hoc analytical support.

Improved the management accounting system. Carried reporting system to a quality new level.

• database design and advanced SQL programming (github.com/vsevolod-zelenkov/MySQL);
• back-end: data integration, Python (github.com/vsevolod-zelenkov/Python);
• introduction to Big Data, machine learning, and predictive analytics;
• front-end: reporting tools and concepts, Tableau (public.tableau.com/app/profile/vsevolod4198);
• Power Pivot and Power BI (github.com/vsevolod-zelenkov/PowerBI).

(dan-it.com.ua/certificates/business-intelligence/zelenkov-vsevolod/)

• calculating current balances with key suppliers, modeling forecast values;
• control on consistency between SAP / BAS databases;
• gross profit report, plan-fact, factor analysis;
• calculation for provided discounts, dynamics in terms of regions, sales channels;
• data consolidation, report on key performance indicators (KPI's);
• report on profitability of business units, factual cost budget execution;
• building reports and dashboards in Power BI.

Implemented Power BI data visualization in department, set up automation of basic reports.

• daily report on sales, direct costs and direct expenses, monthly gross profit report;
• preparation, agreement and control for payment plans;
• sales analysis, combined ABC / XYZ analysis;
• data consolidation for employee salaries;
• organization and control of motivation payments to customers;
• working on financial development models;
• Google Sheets management reports.

• cash flow report, budget planning;
• actual VAT tracking (cash method);
• payment register, coordination and control of execution;
• consumer indebtedness, indicators for legal department, control on payments under restructuring agreements;
• monthly, quarterly and annual reporting forms;
• calculation of payments for electricity distribution system operators;
• control over turnover of bank accounts.

• P&L, BS, CF, financial reports;
• business activity analysis (profitability of sales, combined ABC / XYZ analysis, fixed and indirect costs);
• management accounting of business processes using double-entry method;
• profitability analysis on import deliveries;
• budget planning, plan-fact analysis, optimization;
• control of payroll and partner funds payments;
• organization of financial processes for advertising campaigns.

Carried reporting system to a quality new level. Improved the management accounting system.