Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak
  • 113 USD

    Sales Analysis with Excel

    Databases & SQL
    To see what and how you are selling will help with the MS Excel database management system.
    Send your files and I will do what you will be used to, comfortable and pleasant to work!
    #Electronic
    Business analyticsExcel
    Enterpriseresourseplanning


  • 226 USD

    Local construction-montage work

    Databases & SQL
    Business analytics of the enterprise. Cheap ERP in usual MS Excel format.
    the composition of the object;
    The network schedule;
    - schedule of use of machines and equipment;
    Graphics of employment resources.
    It is adapted on the basis of the existing base of the enterprise.


  • Export of Ukr

    Databases & SQL
    C++ Builder, #Firebird, #xml, #ftp

    The program forms a xml file with information about the residues of goods in the specified groups and loads it to ftp.


  • GreenLancer Helper

    Databases & SQL
    C++ Builder, MySQL and Parsing

    The program allowed to keep the key points of the project in the base by producing a parsing web page, which accelerated the verification of the project performed. It describes the projects that were in operation and the rest of the time spent on them.


  • Mercedes-Benz Vehicles, Techniques and Parts MySQL Database

    Databases & SQL
    A database of cars, techniques and original Mercedes-Benz spare parts in MySQL.
    It contains brands: Mercedes-Benz, MAYBACH, Smart, Unimog.
    The following types of vehicles are presented: Car, Van, Truck, Bus, MB Trac, Powersystems.
    The product contains: BD, drawings, BD scheme, web interface with sql requests, search for VIN (DataCard)


  • Development of an Excel file for inventory accounting

    Databases & SQL
    Project Meta
    It is necessary to develop a user-friendly Excel file for managing the inventory of solar equipment.
    Currently, one manager will be working with the file, entering purchases, reservations, and sales of goods.
    The file should automatically calculate the remaining stock of goods, their cost price, the value of inventory, and the profit from sales.


  • Transfer of the website to WordPress CMS

    Databases & SQL
    Landing page layout according to the design using HTML, CSS, JavaScript, transferring the site to the WordPress CMS, connecting the database management system.


  • Keno game

    Databases & SQL
    The Keno game I am currently maintaining is, as everyone knows, a game where you bet on how many of the 20 numbers randomly selected out of 80 are correct.


  • E-Mail Campaign Performance Analysis

    Databases & SQL
    Analyzed engagement metrics (open/click rates, unsubscribe rates, audience analyses), provided actionable recommendations to monetize the campaigns in the future.
    #Excel
    #analysis


  • Analysis of gaming metrics in Google Sheets

    Databases & SQL
    Calculated key metrics for games: Total Revenue, Paid Users Count, CR to Paid, ARPPU, average/median/minimum/maximum age of paying users.
    Built a summary row with Total metrics.
    Written analytical conclusions and hypotheses regarding the reasons for differences in user behavior.
    Identified possible reasons for low conversion to payers and differences in ARPPU between games.
    Formulated recommendations for improving game monetization.
    Tools and approaches: #GoogleSheets, formulas SUMIF, COUNTIF, AVERAGEIF, logical functions, table formatting.


  • 124 USD

    Accounting program for a private logistics company

    Databases & SQL
    Private logistics company accounting program
    Execution environment C# + SQL Server + Integration with MS Office


  • 45 USD

    ETL pipeline

    Databases & SQL
    My task was to create an ETL process that loads data from a .CSV file, transforms and cleans it, loads it into a PostgreSQL database, and several SQL queries for analysis. Also, for convenience, the cleaned data is stored in a .CSV.