MY CASES
Due to my work in consulting my experience in various business areas grows with each new project. My interest in automation and continuous studying of technologies allow me to build technological and efficient solutions
Fast food restaurant
Help with business model assessment and optimization: my job was to build an analytics model of the financial statements
The model helped to find economic errors and visualize the difference between profit and revenue to stop the systematic withdrawal of money from the business
I also gave recommendations how to build a system of expenses financial planning
The model helped to find economic errors and visualize the difference between profit and revenue to stop the systematic withdrawal of money from the business
I also gave recommendations how to build a system of expenses financial planning
Cosmetology
I helped to organize finances - built a google spreadsheet-based accounting system that allowed to calculate financial indicators, including revenues and expenses, as well as profit and loss
I consulted on the creation of a business model - an investment plan to attract the necessary investment and protect the client's business interests
I consulted on the creation of a business model - an investment plan to attract the necessary investment and protect the client's business interests
Accounting company
Building and automating service sales and operational processes
Building CRM system and system of internal distribution of clients and projects by clients in Asana, AirTable
Building reporting and visualization in Power BI using Power Query
Building a service calculator and creating a commercial offer for the services provided to the company's clients
Building CRM system and system of internal distribution of clients and projects by clients in Asana, AirTable
Building reporting and visualization in Power BI using Power Query
Building a service calculator and creating a commercial offer for the services provided to the company's clients
Cleaning agency
Optimization of business processes and financial performance
There was developed an efficient accounting system of expenses and income based on google tables for financial analysis
Price list development, analysis and margin calculation for each service
Process automation and creation of management analytics
Automatic calculator for calculating orders with selected services and additional options for them
Dynamic calendar for order planning and multi-user tables for process scenarios
Building a system of automatic wage analytics
There was created a summary analytics of monthly margins, new clients and other important management metrics
There was developed an efficient accounting system of expenses and income based on google tables for financial analysis
Price list development, analysis and margin calculation for each service
Process automation and creation of management analytics
Automatic calculator for calculating orders with selected services and additional options for them
Dynamic calendar for order planning and multi-user tables for process scenarios
Building a system of automatic wage analytics
There was created a summary analytics of monthly margins, new clients and other important management metrics
Party organization
Process logic building for management accounting
Income and expense source classifiers for calculating unit economics for P&L report of business financial model
Digitalization of financial performance of processes
Automation of operational processes
Income and expense source classifiers for calculating unit economics for P&L report of business financial model
Digitalization of financial performance of processes
Automation of operational processes
Design agency
What has been done in the project:
Product costing calculator and forecasting the impact of cost changes on profits and margins
Product line formation depending on the qualification of designers
Building an accruals and calculation service system including motivation and bonuses for the involved designers
Product costing calculator and forecasting the impact of cost changes on profits and margins
Product line formation depending on the qualification of designers
Building an accruals and calculation service system including motivation and bonuses for the involved designers
Online store
Financial stability assessment of business
Fixing accounting errors
Building financial statements
Identification of the main sales channels and their shares in the total revenue
Calculation of marginal profit for each channel
Identification of the most and least profitable channels
Allocation of fixed costs by channel
Calculation of the break-even point for each channel
Creation of visual dashboards with interactive diagrams that display the main financial and operational indicators of the company for quick and easy evaluation of the business health
Fixing accounting errors
Building financial statements
Identification of the main sales channels and their shares in the total revenue
Calculation of marginal profit for each channel
Identification of the most and least profitable channels
Allocation of fixed costs by channel
Calculation of the break-even point for each channel
Creation of visual dashboards with interactive diagrams that display the main financial and operational indicators of the company for quick and easy evaluation of the business health
Fashion sales
Setting prices and building an incentive system for business partners
Analyzing the company's work, eliminating errors in documents and preparing financial reports
Consulting on business processes
Creation of payment calendar, cashflow summary report
Building an analytics system for targeted advertising
Organization of the request payment system and their approval
Automation of the inventory balance report
Analyzing the company's work, eliminating errors in documents and preparing financial reports
Consulting on business processes
Creation of payment calendar, cashflow summary report
Building an analytics system for targeted advertising
Organization of the request payment system and their approval
Automation of the inventory balance report
Food sales
Building a marketing strategy
Creating and calculating metrics to analyze business model
Automation of warehouse accounting
Automatic generation of financial statements
Investors share allocation calculator
Creating and calculating metrics to analyze business model
Automation of warehouse accounting
Automatic generation of financial statements
Investors share allocation calculator
Online Piano School
I helped the client to build a google spreadsheet structure for lessons accounting, payments and schedules, teachers' salary calculations, which reduced the load on operational processes, allowing the client to focus on quality education of her students and marketing promotion of the school
Developed a financial reporting system that allowed for more accurate and efficient control over the school's income and expenses and to see the dynamics of profit growth in a selected period at any time
Developed a financial reporting system that allowed for more accurate and efficient control over the school's income and expenses and to see the dynamics of profit growth in a selected period at any time
Dance school
Helping to simplify financial processes and increase the profitability of the business - using Google tables, I built a financial model that helped to find and correct economic errors and optimize pricing for subscriptions
I developed a calendar to track classes and a motivation system for instructors, which reduced the load on the school's operational processes.
After analyzing all the data, we calculated the break-even point and set up accounting and analytics for the subscription system
The head of the dance school received valuable recommendations and tools that helped her to improve business performance and increase the business profitability
I developed a calendar to track classes and a motivation system for instructors, which reduced the load on the school's operational processes.
After analyzing all the data, we calculated the break-even point and set up accounting and analytics for the subscription system
The head of the dance school received valuable recommendations and tools that helped her to improve business performance and increase the business profitability
School of English
Helped the founder of the school to build a financial model that allowed him to assess the profitability of different areas of the business and identify which of them needed to be improved and developed further
Helped to create financial statements that gave a complete view of the business's performance
Provided recommendations on how to improve asset management to bring more money to the school
Helped to create financial statements that gave a complete view of the business's performance
Provided recommendations on how to improve asset management to bring more money to the school
Fintech startup
Work within the service Startup mentorship [Financial System]:
Building a financial model
To optimize cash flow and control financial liabilities, a payment calendar was created
Calculation of a financial cushion for fund formation
Calculation of investment fund to determine money available for additional investments
Calculation of research and development (R&D) expense fund
Building a financial model
To optimize cash flow and control financial liabilities, a payment calendar was created
Calculation of a financial cushion for fund formation
Calculation of investment fund to determine money available for additional investments
Calculation of research and development (R&D) expense fund
Cryptofarm
Calculation of optimal hardware configuration from the viewpoint of economics of mining machines
Mathematical model of selection of coins for mining
Financial model with project payback calculation
Economic calculation of cryptofarm operation scenarios
Mathematical model of selection of coins for mining
Financial model with project payback calculation
Economic calculation of cryptofarm operation scenarios
Backpack manufacturing startup
Searching for errors and analyzing the business model
Consulting on sales and logistics processes
Crisis management, recommendations for improvement, building processes and accounting for investor presentation
Profit sharing model for investors-partners
Consulting on sales and logistics processes
Crisis management, recommendations for improvement, building processes and accounting for investor presentation
Profit sharing model for investors-partners
Startup producing accessories for game consoles
Building a financial model
Building a payment calendar
Production planning and component inventory turnover calculation
Consulting on teamwork processes
Reporting and calculation of project development scenarios for investors
Building a payment calendar
Production planning and component inventory turnover calculation
Consulting on teamwork processes
Reporting and calculation of project development scenarios for investors
Cloud team building startup
Startup mentorship:
Idea formalization, vision & mission statement, product value creation, process description, team building process criteria, building the order generation process, business model description
Idea formalization, vision & mission statement, product value creation, process description, team building process criteria, building the order generation process, business model description
Startup and investor community
Financial support for the community:
Building financial statements
Financial flow management
Project management and projects funding
Building financial statements
Financial flow management
Project management and projects funding
Floor tiles manufacturing
Creation of a financial plan for a business project of a floor tiles manufacturing
Calculation of the production cost adjusted for the depreciation shift to the manufacturing costs
Calculation of capital required for the project and creation of an investment offer to the investor
Investor entry scenario modeling
Planning of operating, investment and financial cash flows
Calculation of investment return and interest payment terms, project profitability
Business evaluation after 5 years using the following methods: Profit Multiples, Revenue Multiples and Discounted Cash Flow.
Creation of a dynamic dashboard with the main financial indicators of the project for presentation to the investor
Calculation of the production cost adjusted for the depreciation shift to the manufacturing costs
Calculation of capital required for the project and creation of an investment offer to the investor
Investor entry scenario modeling
Planning of operating, investment and financial cash flows
Calculation of investment return and interest payment terms, project profitability
Business evaluation after 5 years using the following methods: Profit Multiples, Revenue Multiples and Discounted Cash Flow.
Creation of a dynamic dashboard with the main financial indicators of the project for presentation to the investor
Construction
Building an operational process system and calculating timelines for each stage of the project
Creating a business model
Calculating the investment attraction amount
Analyzing and evaluating investment offers
Building financial statements on the basis of QuickBooks accounting program
Creating a business model
Calculating the investment attraction amount
Analyzing and evaluating investment offers
Building financial statements on the basis of QuickBooks accounting program
