Switch to English version?

Yes

Переключитись на українську версію?

Так

Переключиться на русскую версию?

Да

Przełączyć się na polską wersję?

Tak

Login
Registration
- Welcome to Freelancehunt
  
  Work risk-free, saving time and money
  
  Login Registration

Yana Pucheva

Offer Yana work on your next project.

Kyiv, Ukraine

3 hours 40 minutes back

available for hire

6 Safes completed

9 months 19 days back

2 clients

age 40 years

on the service 1 year

Client profile

Rating

Successful projects

Average rating

Rating

Desktop Apps

31 place out of 471

Databases & SQL

20 place out of 1205

Databases & SQL

Accounting Services

Consulting

Information Gathering

Skills and abilities

Programming

Services

Data Processing

Outsourcing & consulting

Portfolio

Mobile application for accounting work at a service station

Hybrid Mobile Apps

PWA

Frontend:
- HTML5 — page structure
… - CSS3 — appearance and styles
- JavaScript (vanilla) — application logic, without frameworks

Backend (server logic):
- Google Apps Script — server-side JavaScript within Google, processes requests and works with the spreadsheet

Database:
- Google Sheets — stores all data (records, directories, users)

Hosting:
- GitHub Pages

Vanilla HTML/CSS/JS + Google Apps Script + Google Sheets, hosted on GitHub Pages

More screenshots of this application can be found at the link https://drive.google.com/file/d/19pYQOppkDcRLjDtqx_88XJLTwnCRWFoS/view
Mobile application for tracking Household Finances

Hybrid Mobile Apps

Mobile application for tracking Household Finances on App Sheet
MANY EXAMPLES of implemented solutions with Interfaces and descriptions

Desktop Apps

BUSINESS CARD: https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=1846804128

EXAMPLES OF IMPLEMENTED SOLUTIONS

… 1. ORDER ACCOUNTING https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=1857944885
2. FINANCIAL ACCOUNTING https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=1994446930
3. SALES ACCOUNTING and WAREHOUSE ACCOUNTING https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=1449753288
4. ANALYTICS https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=350880282
5. COST CALCULATORS https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=156195454
6. FINANCIAL MODELS https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=1155610840
https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=1846804128
Dashboards in Looker Studio based on Google Sheets

Desktop Apps

Financial model in Looker Studio
Internet Service/ CRM/ browser-based Accounting System

Client Management & CRM

I will develop an internet Service/ CRM/ browser-based Accounting System for you.

Tools used:

… Frontend
- Vue: For creating the user interface
- Vue Router: Routing
- Pinia: For managing the application state
- PrimeVue - a universal and high-performance library of Vue user interface components
- Vuestic: a set of styled components - demo: (Vuestic-Demo-Site)
- Chart.js: For visualizing data in the form of charts.

Backend (Firebase - a set of microservices)
- Cloud Functions: (Serverless Architecture, Node.js and Express.js)
- Firestore: A database for storing all user data and data from tables, directories, final calculations
- JWT (JSON Web Tokens): For user authentication and authorization (security).

I have experience as a PM/BI (Project Manager/ Business Analyst) in implementing business process automation systems.

I have a strong analytical background in the following areas:

1. Construction (project management, general contracting, cost estimation, business center management)
2. Investments and development (investment attractiveness analysis, budgeting, construction project management)
3. Insurance (all types of risk insurance, reinsurance, loss adjustment)
4. Business Center management, leasing service.
5. Dentistry and beauty salons.
6. Food preparation and delivery services.
7. Taxi fleet
8. Moving company (Transportation organization services)
9. International freight transportation
10. Food courts and catering

I have extensive experience in direct development:
1. Complex accounting systems;
2. Management, Financial, Warehouse accounting systems for enterprises, sales accounting;
3. Financial models of investment projects, Franchises;
4. Budgeting and financial planning systems;
5. Analytical reports with dashboards, charts, diagrams
6. Database creation (input forms, queries, and reports from the database)
7. Description of business processes in BPMN 2.0 notation.
Financial model for opening a Training Center

Desktop Apps

Hello.

I will develop a Financial Model for your Investment Project based on your initial data in several execution options (pessimistic, realistic, optimistic).

… Based on the financial model, it will be possible to assess the profitability/recovery of projects, as well as the feasibility of entering the project.

The Financial Models I develop are dynamic tools for analyzing financial condition and modeling the financial efficiency of investments using a variety of user-defined dynamic settings for applying certain criteria and indicators, franchise packages, as well as the possibility of consideration in three modes: pessimistic, realistic, optimistic.

I have 10 years of experience as a Head of Investment Projects (Development Company).

There are many examples of financial models for Investment Projects/Franchises.

Example in the table:
https://docs.google.com/spreadsheets/d/1i3dkXYMjmCufwcmnWKU1Q-pC4u1nBnnBvX07uJlhlvo/edit#gid=1706957885

Below, as an example, I attach:

1. Financial Model Franchise - Bakery Chain
https://drive.google.com/file/d/12LgTdB7l3WzoSdEGpX-BU5moCPWFNiMU/view

2. Financial Model of the Training Center Franchise
https://drive.google.com/file/d/1EQjYvON2mysBQVPpXhEX5A6c5kclZLJ7/view

3. Financial Model for Investment in Real Estate
https://drive.google.com/file/d/16rI4YyRlp48rWxKnPrDvoD5LSQzA94SW/view

You can see more examples of developed financial models in my Business Card at the link
https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=1155610840

I will carefully listen to your needs and offer optimal solutions.
Franchise Financial Model

Desktop Apps

I will develop a Financial Model for your Investment Project based on your initial data in several execution options (pessimistic, realistic, optimistic).

Based on the financial model, it will be possible to assess the profitability/recovery of projects, as well as the feasibility of entering the project.

… The Financial Models I develop are dynamic tools for analyzing financial condition and modeling the financial efficiency of investments using a multitude of user-defined dynamic settings for applying various criteria and indicators, franchise packages, as well as the possibility of consideration in three modes: pessimistic, realistic, optimistic.

I have 10 years of experience as a Head of Investment Projects (Development Company).

There are many examples of financial models for Investment projects/Franchises.

Example in the table:
https://docs.google.com/spreadsheets/d/1i3dkXYMjmCufwcmnWKU1Q-pC4u1nBnnBvX07uJlhlvo/edit#gid=1706957885

Below, as an example, I attach:

1. Financial Model Franchise - Bakery Chain
https://drive.google.com/file/d/12LgTdB7l3WzoSdEGpX-BU5moCPWFNiMU/view

2. Financial Model of the Educational Center Franchise
https://drive.google.com/file/d/1EQjYvON2mysBQVPpXhEX5A6c5kclZLJ7/view

3. Financial Model for Investment in Real Estate
https://drive.google.com/file/d/16rI4YyRlp48rWxKnPrDvoD5LSQzA94SW/view

You can see more examples of developed financial models in my Business Card at the link
https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=1155610840

I will carefully listen to your needs and offer optimal solutions.
Investment Real Estate Financial Model

Desktop Apps

Hello.

I will develop a Financial Model for your Investment Project based on your initial data in several execution options (pessimistic, realistic, optimistic).

… Based on the financial model, it will be possible to assess the profitability/recovery of projects, as well as the feasibility of entering the project.

The Financial Models I develop are dynamic tools for analyzing financial condition and modeling the financial efficiency of investments using a variety of user-defined dynamic settings for applying certain criteria and indicators, franchise packages, as well as the possibility of consideration in three modes: pessimistic, realistic, optimistic.

I have 10 years of experience as a Head of Investment Projects (Development Company).

There are many examples of financial models for Investment Projects/Franchises.

Example in the table:
https://docs.google.com/spreadsheets/d/1i3dkXYMjmCufwcmnWKU1Q-pC4u1nBnnBvX07uJlhlvo/edit#gid=1706957885

Below, as an example, I attach:

1. Financial Model Franchise - Bakery Chain
https://drive.google.com/file/d/12LgTdB7l3WzoSdEGpX-BU5moCPWFNiMU/view

2. Financial Model of the Training Center Franchise
https://drive.google.com/file/d/1EQjYvON2mysBQVPpXhEX5A6c5kclZLJ7/view

3. Financial Model for Investment in Real Estate
https://drive.google.com/file/d/16rI4YyRlp48rWxKnPrDvoD5LSQzA94SW/view

You can see more examples of developed financial models in my Business Card at the link
https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=1155610840

I will carefully listen to your needs and offer optimal solutions.
FINANCIAL ACCOUNTING

Desktop Apps

Structure of the Financial Accounting System:

1. Payment Registration Forms
Interface examples:
… https://drive.google.com/file/d/14ET-mQfn3ZfzsHNmle5j3UjSspudU7uv/view
https://drive.google.com/file/d/1m-0KuhU1srktPueVmQluUokQRNkABWv-/view

2. Automated Distribution Form for Bank Statement/Payment Registration (if needed)
https://drive.google.com/file/d/13WNPG0NHe9idoCrBWXF6MNt9VONAZsr1/view

2. Database (Payment Registry):
https://drive.google.com/file/d/1i55mkrczDu8UFd4cCr6e2-4_hb_UHs-S/view

3. Payroll Accrual and Payment Form
Payroll payments are registered in the Payment Registry.
https://drive.google.com/file/d/1qH1ec3AFTk5CH-hDiUYUQ0ZemxqH9WN0/view
https://drive.google.com/file/d/1DoUWTyL2taDVMpFNPUtZdxDEUvjZ1aq0/view

4. ANALYTICS, providing a variety of reports, dashboards, graphs, and charts
4.1. Profit and Loss Report (P&L)
https://drive.google.com/file/d/1Pt1Xs8s90JBoG7Wlo9gClq_r-CsJXajn/view
4.2. Cash Flow Statement
https://drive.google.com/file/d/1IA5nuvZVNxhePsOLuTX97ybU-CGfsvqA/view
https://drive.google.com/file/d/1l_9k50buqVJg0ZY7FqNStPgpOSJSX-rW/view

4.3. Current Balances in Accounts
https://drive.google.com/file/d/1CfDMuV-jtomiP3tJvAsVXOeNKofXk2sT/view
https://drive.google.com/file/d/1EqZavUG7aZ1mv-FKp7ZSD6ExEfiH0ZpZ/view

4.4. Comprehensive Dashboard (Financial Model)
https://drive.google.com/file/d/1EQjYvON2mysBQVPpXhEX5A6c5kclZLJ7/view

More Examples https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=1994446930
ORDER ACCOUNTING

Desktop Apps

I will develop an Order Accounting System with Analytics for you in accordance with your business processes, functional needs, and access control.

Structure of the Accounting System:
1. Order Registration Form (for each employee/branch)
… Interface examples:
https://drive.google.com/file/d/13PRZeE_tEyv2rMJqsmeoCrmhcVSNByDh/view
https://drive.google.com/file/d/1ggGFefnKj6Szsq5HzGCU_aJAURhnWV8h/view
https://drive.google.com/file/d/10gcURSRJrgVZ__tDRo6FU9wf0JG7hyec/view

2. Client/Employee Data Registration and Editing Form
https://drive.google.com/file/d/1xMhYIYj4AgeSprb-pJMhp14p1CofkhI0/view

3. Unified Order Registry
https://drive.google.com/file/d/1CqLJtNv4jOGx-NKpQDuD4Ny-HkzxHxP_/view

4. Report on Current Orders
https://i.imgur.com/Ofbqno9.png
https://drive.google.com/file/d/1ktmkOxP9kDTWyvPWVb7zt30F2SMav5BT/view
5. Other Analytics.
https://drive.google.com/file/d/1TMq13d8p3zsuDEfIuGQ_zNy9v51ijPVW/view

6. Salary Calculation
https://drive.google.com/file/d/1qH1ec3AFTk5CH-hDiUYUQ0ZemxqH9WN0/view
https://drive.google.com/file/d/1DoUWTyL2taDVMpFNPUtZdxDEUvjZ1aq0/view

7. Payment Registration,
https://drive.google.com/file/d/14ET-mQfn3ZfzsHNmle5j3UjSspudU7uv/view
including bank statements
https://drive.google.com/file/d/13WNPG0NHe9idoCrBWXF6MNt9VONAZsr1/view

I will carefully listen to your needs and offer optimal solutions (the proposed solutions are usually demonstrated with examples of my developments)

More Examples https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=1994446930
Business Analyst. Development of Business Processes

Enterprise Resource Planning (ERP)

I can offer my services as a Business Analyst for your project.

I have experience as a PM/BI (Project Manager/Business Analyst) in implementing business process automation systems for enterprises. I can break down tasks for the project from both the Business needs (business processes) and the developer's perspective.

… I have extensive experience in interviewing and creating detailed Technical Specifications, including descriptions of business processes (BPMN 2.0 notation).

I have a financial and economic education and over 20 years of experience working in various business sectors, with hands-on experience in organizing business processes for companies, allowing me to participate in projects, including as a business analyst, and quickly understand the specifics of the Client's business processes and propose optimal solutions to their needs in the development of accounting and management systems.

I have a strong analytical background in the following areas:

1. Construction (project management, general contracting, cost estimation, business center management)
2. Investments and development (investment attractiveness analysis, budgeting, construction project management)
3. Insurance (all types of risk insurance, reinsurance, loss adjustment)
4. Business Center management, leasing service.
5. Dentistry and beauty salons.
6. Food preparation and delivery services.
7. Taxi fleet.
8. Moving company (transportation organization services)
9. International freight transportation
10. Food courts and catering.
Writing Regulations, Job Descriptions, Business Processes

Enterprise Resource Planning (ERP)

I will describe and develop Business Processes.
I will write Regulations and Job Descriptions for Business Processes.

I have experience as a PM/BI (Project Manager/Business Analyst) in implementing a business process automation system for enterprises, including forming/proposing optimal solutions according to the Client's needs.
… I can fragment tasks for the project from both the Business's perspective and the developer's viewpoint.

I have extensive experience in interviewing and creating detailed Technical Specifications, including describing business processes (BPMN 2.0 notation).

I have a financial and economic education and over 20 years of experience in various business sectors, with direct experience in organizing business processes for companies, allowing me to quickly understand the specifics of the Client's business processes and propose optimal solutions for their needs in accounting and management system development projects.

I have a strong analytical background in the following areas:

1. Construction (project management, general contracting, cost estimation)
2. Investments and development (investment attractiveness analysis, budgeting, construction project management)
3. Insurance (all types of risk insurance, reinsurance, loss adjustment)
4. Business Center Management, leasing service.
5. Dentistry and beauty salons.
6. Food preparation and delivery services.
7. Taxi fleet
8. Moving company
9. International freight transportation
10. Food courts and catering
https://drive.google.com/file/d/1QP8T54k-cuWykw1QgQumYRsZE8tMNtu8/view
ANALYTICS on FINANCE

Desktop Apps

I will develop for you a system of Analytical Dashboards (reports, Dashboards, graphs, and charts) for effective and convenient monitoring and analysis of your company's performance indicators across various factors, categories, reporting periods, and stores.

Below are some examples:
1. Comprehensive Dashboard (Financial Model)
… https://drive.google.com/file/d/1EQjYvON2mysBQVPpXhEX5A6c5kclZLJ7/view

2. Profit and Loss Report (P&L)
https://drive.google.com/file/d/1Pt1Xs8s90JBoG7Wlo9gClq_r-CsJXajn/view

3. Cash Flow Statement
https://drive.google.com/file/d/1IA5nuvZVNxhePsOLuTX97ybU-CGfsvqA/view
https://drive.google.com/file/d/1l_9k50buqVJg0ZY7FqNStPgpOSJSX-rW/view

4. Current Balances in Accounts
https://drive.google.com/file/d/1CfDMuV-jtomiP3tJvAsVXOeNKofXk2sT/view
https://drive.google.com/file/d/1EqZavUG7aZ1mv-FKp7ZSD6ExEfiH0ZpZ/view

ANALYTICS on SALES

1. Summary Sales Report by Stores
https://drive.google.com/file/d/1iZY1N775-QyQklPESJyttTOTe_yr-bZX/view

2. Monthly Sales Report by Points
https://drive.google.com/file/d/1UGWP-qzDEzd3fGfqCdroro-rlUHMdMDd/view

3. Summary Report on Sales Profitability by Brands
https://drive.google.com/file/d/1TMq13d8p3zsuDEfIuGQ_zNy9v51ijPVW/view

4. Top Sales
https://drive.google.com/file/d/1CLJfQFxOK2pEqixqLBwqMnFfgoIh9NcF/view

5. Sales Report Builder
https://drive.google.com/file/d/1EmzJpz9ubrSC4BfYD2n_lXHs5sdqnjJk/view

6. Summary Sales Report by Product Groups
https://drive.google.com/file/d/1_QhQqxQ-tYU_IuMqmwchAfJyHb_JrPdi/view

7. Order Performance Indicators
https://drive.google.com/file/d/1cdizWxZsV7ukPCPTPe9LKquG4iq9Fksn/view

8. Order Reports
https://drive.google.com/file/d/1lj_A72VNmZRfHnlMdqR490Dy39vmJhe2/view

More examples of implemented solutions with interfaces and descriptions of the functional structure of Accounting and Analytics Systems can be viewed in my Business Card at the link
https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=350880282

I will carefully listen to your needs and offer optimal solutions.
SALES ANALYTICS

I will develop an Analytical Dashboard system (reports, dashboards, charts, and diagrams) for effective and convenient monitoring and analysis of your company's performance indicators across various factors, categories, reporting periods, and stores.

Below are some examples:
Comprehensive Dashboard (Financial Model)
… https://drive.google.com/file/d/1EQjYvON2mysBQVPpXhEX5A6c5kclZLJ7/view

SALES ANALYTICS

1. Summary Sales Report by Stores
https://drive.google.com/file/d/1iZY1N775-QyQklPESJyttTOTe_yr-bZX/view

2. Monthly Sales Report by Points
https://drive.google.com/file/d/1UGWP-qzDEzd3fGfqCdroro-rlUHMdMDd/view

3. Summary Profitability Report by Brands
https://drive.google.com/file/d/1TMq13d8p3zsuDEfIuGQ_zNy9v51ijPVW/view

4. Top Sales
https://drive.google.com/file/d/1CLJfQFxOK2pEqixqLBwqMnFfgoIh9NcF/view

5. Sales Report Builder
https://drive.google.com/file/d/1EmzJpz9ubrSC4BfYD2n_lXHs5sdqnjJk/view

6. Summary Sales Report by Product Groups
https://drive.google.com/file/d/1_QhQqxQ-tYU_IuMqmwchAfJyHb_JrPdi/view

7. Order Efficiency Indicators
https://drive.google.com/file/d/1cdizWxZsV7ukPCPTPe9LKquG4iq9Fksn/view

8. Order Reports
https://drive.google.com/file/d/1lj_A72VNmZRfHnlMdqR490Dy39vmJhe2/view

More examples of implemented solutions with interfaces and descriptions of the functional structure of Accounting and Analytics Systems can be found in my Business Card at the link
https://docs.google.com/spreadsheets/d/1Lqv3RIPMlBSCmN1pBflv3M2XOgyXcsal_f2XYy158QI/edit#gid=350880282

I will carefully listen to your needs and offer optimal solutions.
Management Accounting System - Concrete Supply

Desktop Apps

#Management accounting #Sales accounting #Accounting #Report #Statement #Bank statement

The following functionality has been implemented:

… 1. Accounting for construction objects/customers/suppliers
2. Accounting for shipments and deliveries.
3. Financial accounting of expenses and income with itemization, including processing of client bank data if necessary.
4. Accounting for cash flow.
5. Report on current account balances.
6. Accounting for accruals and salary payments to managers.
7. Reports on the results of Financial activities (income/expense/profit) for the period broken down by:
- construction objects;
- clients;
- suppliers;
- overall for the enterprise.
8. Reports on the effectiveness of transactions broken down by Customers, Suppliers/Managers.
Financial model for opening a laundry chain

Desktop Apps

#Google sheets #API #Google Sheets
#Financial model #Financial modeling #Financial model #Accounting #Warehouse #Warehouse accounting #Estimate #Estimates #Calculator #Analytics
Dynamic summary Tables with Custom settings

Desktop Apps

Pivot tables with dynamic report generation based on established User settings for the structure of pivot tables:

1. The necessary arrays of source data (more than 100 columns) are automatically exported to the pivot table.
2. In User settings, the following are set/selected:
… - Report structure (necessary columns from the source table),
- criteria, dimensions for forming pivot tables, reports.
3. The necessary Reports are automatically generated in the developed forms. At the same time, the report forms automatically acquire the appearance and structure chosen in the user settings.
4. A Constructor for dynamic charts has been implemented (the user selects the necessary indicators).
IN ADDITION - a system for checking errors/unmet conditions/unfilled cells in the source table according to specified error-checking criteria is provided by:
1. Generating a report listing errors for each group of conditions.
2. Automatic generation of color highlighting for errors/unmet conditions.

#Google sheets #API #Google Tables
#Financial model #Financial modeling #Accounting #Warehouse #Warehouse accounting #Estimate #Estimates #Calculator #Analytics
#Pivot #Pivot #Tables
Sales and Inventory Accounting System

Desktop Apps

I will develop for you an Order Accounting and Inventory Management System with Analytics according to your needs.

Below is an example of the System Structure:
1. Order Registration Form
… Interface examples:
https://drive.google.com/file/d/13PRZeE_tEyv2rMJqsmeoCrmhcVSNByDh/view
https://drive.google.com/file/d/1ggGFefnKj6Szsq5HzGCU_aJAURhnWV8h/view
https://drive.google.com/file/d/10gcURSRJrgVZ__tDRo6FU9wf0JG7hyec/view

2. Client/Employee Data Registration and Editing Form
https://drive.google.com/file/d/1xMhYIYj4AgeSprb-pJMhp14p1CofkhI0/view

3. Unified Order Registry
https://drive.google.com/file/d/1CqLJtNv4jOGx-NKpQDuD4Ny-HkzxHxP_/view

4. Report on Current Orders
https://drive.google.com/file/d/1ktmkOxP9kDTWyvPWVb7zt30F2SMav5BT/view
5. Other Analytics.
https://drive.google.com/file/d/1TMq13d8p3zsuDEfIuGQ_zNy9v51ijPVW/view

7. Goods Receipt Registration Form
https://drive.google.com/file/d/1G7afp_e0VPEGsz4ZZSO085AOeCUt92K-/view
Product nomenclature https://drive.google.com/file/d/1sJYbxV7px55OcbxXYZQGd9FPUnrJ6OGP/view

8. WAREHOUSE BALANCES
8.1. Warehouse balances with automatic photo display (the photos themselves are stored on Google Drive, and the image is displayed in the Table via a link)
https://drive.google.com/file/d/1rbdrjmo976y2S5BatP_gYDe1CXPZdwnm/view
8.1. Report on balances by Product Groups
https://drive.google.com/file/d/1TMq13d8p3zsuDEfIuGQ_zNy9v51ijPVW/view
8.3. Automatic warehouse balances
https://drive.google.com/file/d/1f9qxgHUB9zFPy7lvmwFQMG3mnzRUq_vb/view

Examples of implemented solutions with interfaces and descriptions of the functional structure of the Accounting and Analytics Systems can be viewed at the link
https://docs.google.com/spreadsheets/d/1GBteLwTH5pc6-teoVsqctLRVDRf5D7PBgsrarOEL_4M/edit#gid=1857944885

I will carefully listen to your needs and offer optimal solutions.
Online Order Registration Form

Desktop Apps

Functionality implemented for Order Form Managers for online registration of orders in the Unified Database for subsequent processing and servicing of orders.
Program for working with quotes on the exchange www.binance.com

Desktop Apps

#Crypto #Currency

A tool has been implemented for working with quotes on the exchange www.binance.com/en/

… The program includes the following functionality:
1. Regular automatic updates of trading pair quotes from the exchange
2. Monitoring the appearance of new pairs on the exchange and adding new pairs to the database (button click)
3. Distribution of pairs into separate tabs based on specified criteria (btc, bnb, others)
4. Daily archiving of quotes with convenient visualization of quote dynamics for the past week.
5. Selection of interesting pairs for tracking in trades
6. Formation of a list of selected pairs for subsequent processing. A link is generated in each row to navigate to the exchange for that specific pair.
7. Processing (setting personal preferences/exit criteria/readiness to sell), monitoring price dynamics.
8. Establishing an acceptable range of quotes and generating a report on selected pairs indicating whether the dynamics of changes fits
9. Automatic generation of a report on pairs for which it is profitable to sell quotes

#Google sheets #API #Google Sheets
#Financial model #Financial modeling #Accounting #Warehouse #Warehouse accounting #Estimate #Estimates #Calculator #Analytics
#Summary #Summary #Tables
Management Accounting System for TAXI PARK

Desktop Apps

1. Dispatcher Block (DISPATCHER)
1.1. Calendar work schedule for drivers across the entire Taxi Fleet:
- assignment of drivers to vehicles
- operational planning/ modification of drivers' work schedule considering drivers' work mode (shift schedule, shifts)
… 1.2. Dispatcher Monitor:
- ensuring personalized data entry into the Database, including blocking input when mandatory fields are not filled
- accounting for departures/ arrivals
- online monitoring of vehicles in the fleet/ on the route, amount of time spent on shift
- accounting for the sale of additional services for drivers
- accounting for revenue by various items and criteria (when closing the cash register)
- accounting for expenses incurred during the shift linked to the vehicle and driver (when closing the cash register)
- registration of accidents
1.3. Registration of drivers' and Vehicles' statuses:
- absenteeism, sick/ recovered
- putting the Vehicle in for repair, out of repair, maintenance

2. Accounting Block:
- accounting for vehicles on the balance sheet/ removal from the balance sheet/ accounting for ownership form (purchase/ lease/ leasing)
- calculation and accounting of salary payments considering the bonus system

3. Management Accounting
- monthly Analytics of the efficiency of the taxi fleet as a whole, as well as for each individual driver
- monthly Analytics of vehicle usage efficiency indicators
- formation of the TOP-10 best drivers for online broadcasting

4. Human Resources Department Block:
- surveying drivers
- hiring/ termination, etc.
- selection of work mode and shifts
Financial Model of the Shoe Dry Cleaning Franchise

Desktop Apps

Financial Model of the Shoe Dry Cleaning Franchise
SURVEY. Questionnaire registration and Analysis

Desktop Apps

Survey and Questionnaire Analysis System

The system includes the following functionality:
1. A data registration form for the survey, which also uses dynamic drop-down lists.
… By clicking the button, the data is registered in the Registry (database).

2. Questionnaire Registry

3. Analytics with the ability to apply various criteria for sample selection and obtain analytical data across different segments.
Management Accounting System for Construction Company

Desktop Apps

1. Accounting of construction objects/clients/suppliers
2. Accounting of Contracts and related documents (additional agreements, Invoices, Acts of completed work)
3. Financial accounting of expenses and income with itemization, including automated processing of bank statements.
4. Accounting of cash flow.
… 5. Report on current balances in accounts.
6. Accounting of accruals and salary payments to managers and other staff.
7. Report designer:
7.1. Financial indicators by Objects
7.2. Balance of mutual settlements by:
- Construction objects;
- Counterparties;
- Contracts, additional agreements, Invoices, Acts of completed work
8. Reports on the results of Financial activities for the reporting period with diagrams (Structure of income, expenses, profit/loss)
9. Report on current cash balances in accounts
ANALYTICAL PROCESSORS

Desktop Apps

ANALYTICAL PROCESSORS of various functional purposes and complexities
ANALYTICAL PROCESSORS

Desktop Apps

ANALYTICAL PROCESSORS
Commercial Proposal Constructor

Desktop Apps

#Proposal Builder #Constructor #Calculator

The following functionality has been implemented:
1. An interface for generating a Commercial Proposal from a set of company services has been implemented, as well as a Menu for navigating between program windows.
… 2. A selection of services necessary for the client is made from a multi-level set of company Services.
3. The cost of the selected services in the proposal is automatically calculated taking into account many criteria: selected services, service package, amount and term of prepayment, and provided discounts.
4. A Commercial Proposal for the client is automatically generated in both Summary and detailed forms for each category of services.
5. An Efficiency Monitor for the commercial proposal has been developed, which provides summary analytics for analyzing financial efficiency broken down by each type of service:
- cost price;
- basic markup considering discounts;
- commissions for managers, marketing department;
- agency fees;
- total markup;
- selling price

#Google sheets #API #Google Sheets
#Financial model #Financial model #Accounting #Warehouse #Warehouse accounting #Wildberries #Estimate #Estimates #Calculator #Analytics
#Summary #Summary #Tables
https://docs.google.com/spreadsheets/d/1qS05KWGovZOaK4Ondffrw5Z6djfiZJrzfFfQucsYrCc/edit#gid=1411192660
Search form for the Special Equipment Database

Desktop Apps

A search monitor has been developed with the following functionality:
1. By phone number, it searches in more than 20 different tabs of a large database of special equipment and provides results in the form of a complete list of all types of special equipment registered in the database under the entered phone number (with all necessary characteristics).
2. The search result also generates a link to the CELL of equipment models, which allows direct access to the cell of the interested equipment models for subsequent record editing and input of updated information.
General Report Generator - Wildberries

Desktop Apps

All the shortcomings of Wildberries reports are eliminated by creating a Unified General Report from 10 Wildberries reports.

How it works:
From the Wildberries marketplace, you download 10 reports for the period you need.
…
Next, all management is carried out from the General Report system interface - just press the necessary button:

1. Uploading 10 Wildberries reports to Google Drive
2. Uploading original reports to the System
The system issues a warning in case of uploading an incorrect format or the absence of any original report on Google Drive
3. Generating the General Report
There is an option to enter necessary user metrics in Settings before starting the report generation.
4. Creating a Supply Order in the Wildberries format
5. Clearing the drive of original reports before the next upload

Functionality can be adapted to your needs.
Internet Service/ CRM/ browser-based Accounting System

Client Management & CRM

I will develop an internet Service/ CRM/ browser-based Accounting System for you.

Tools used:

… Frontend
- Vue: For creating the user interface
- Vue Router: Routing
- Pinia: For managing the application state
- PrimeVue - a universal and high-performance library of Vue user interface components
- Vuestic: a set of styled components - demo: (Vuestic-Demo-Site)
- Chart.js: For visualizing data in the form of charts.

Backend (Firebase - a set of microservices)
- Cloud Functions: (Serverless Architecture, Node.js and Express.js)
- Firestore: A database for storing all user data and data from tables, directories, final calculations
- JWT (JSON Web Tokens): For user authentication and authorization (security).

I have experience as a PM/BI (Project Manager/ Business Analyst) in implementing business process automation systems for enterprises.

I have a good analytical background in the following areas:

1. Construction (project management, general contracting, cost estimation, business center management)
2. Investments and development (investment attractiveness analysis, budgeting, construction project management)
3. Insurance (all types of risk insurance, reinsurance, loss adjustment)
4. Business Center management, leasing service.
5. Dentistry and beauty salons.
6. Food preparation and delivery services.
7. Taxi fleet
8. Moving company (Transportation organization services)
9. International freight transportation
10. Food courts and catering

I have extensive experience in direct development:
1. Comprehensive accounting systems;
2. Management, Financial, Warehouse accounting systems for enterprises, sales accounting;
3. Financial models of investment projects, Franchises;
4. Budgeting and financial planning systems;
5. Analytical reports with dashboards, charts, diagrams
6. Database creation (input forms, queries, and reports from the database)
7. Description of business processes in BPMN 2.0 notation.

Show more 15 jobs

Reviews and compliments on completed projects 6

Real expert
Craft master
Quick answers
First-class quality
Nice communication
High responsibility
Great price
Lightning fast

More than 6 months ago 6

13 August 2025 200 USD
Automatic export from email

Quality

Professionalism

Cost

Contactability

Deadlines

Wonderful. As always, everything is quick.

Juris O. | Safe

| Response review

13 January 2025 393 USD
Development of the Dashboard Formation System. Stage 3

Quality

Professionalism

Cost

Contactability

Deadlines

This is already the 3rd stage of the project and everything is going according to plan.

Juris O. | Personal | Response review

11 January 2025 349 USD
Development of the Dashboard Formation System. Stage 2

Quality

Professionalism

Cost

Contactability

Deadlines

Thank you, everything is done on time.

Juris O. | Personal | Response review

2 December 2024 489 USD
*Development of Dashboard Formation System. Stage 1

Quality

Professionalism

Cost

Contactability

Deadlines

The work was completed quickly and within the agreed timeframe.

Juris O. | Personal | Response review

25 November 2024 58 USD
Dashboard setup

Quality

Professionalism

Cost

Contactability

Deadlines

Quality and on time. Thank you.

Juris O. | Safe

| Response review

19 November 2024 41 USD
1 hour consultation on the project

Quality

Professionalism

Cost

Contactability

Deadlines

Everything is good and clear. They explained to me clearly what can be done with my request.

Romans V. | Personal | Response review

Activity

Latest proposals 10	Budget	Added	Proposal
Freelance project		1 Jun	concealed
Freelance project 90 USD	90 USD	31 May	concealed
Freelance project		12 May	concealed
Freelance project 400 USD	400 USD	12 May	concealed
Freelance project 135 USD	135 USD	8 May	concealed
Freelance project 23 USD	23 USD	7 May	concealed
Freelance project		6 May	concealed
Freelance project 55 USD	55 USD	27 Apr	concealed
Freelance project 800 USD	800 USD	22 Apr	concealed
Freelance project		22 Apr	concealed

Yana Pucheva

Rating

Skills and abilities

Programming

Services

Outsourcing & consulting

Portfolio

Reviews and compliments on completed projects 6

13 August 2025 200 USD Automatic export from email

13 January 2025 393 USD Development of the Dashboard Formation System. Stage 3

11 January 2025 349 USD Development of the Dashboard Formation System. Stage 2

2 December 2024 489 USD *Development of Dashboard Formation System. Stage 1

25 November 2024 58 USD Dashboard setup

19 November 2024 41 USD 1 hour consultation on the project

Activity

13 August 2025 200 USD
Automatic export from email

13 January 2025 393 USD
Development of the Dashboard Formation System. Stage 3

11 January 2025 349 USD
Development of the Dashboard Formation System. Stage 2

2 December 2024 489 USD
*Development of Dashboard Formation System. Stage 1

25 November 2024 58 USD
Dashboard setup

19 November 2024 41 USD
1 hour consultation on the project