Roman Serebrak
Winning proposal- Projects 44
- Rating -
- Rating 1 816
Budget: 4000 UAH Deadline: 7 days
Good day !
I propose to work together!
“...””””
Proposals are currently absent
- Projects -
- Rating -
- Rating 334
Budget: 15000 UAH Deadline: 7 days
I have been developing websites for more than 5 years. I write sites on the self-writing engine of PHP, I recommend ordering sites with me to the addition to the development of sites I am still engaged in developing different applications on PHP. Parsers/Grabbers, bots, the connection of third-party services by API, for such tasks you don’t have to look for a new performer, as all of this I’m doing.
Ready to complete your project under key. Write to me to discuss more in detail!
Budget: 8000 UAH Deadline: 7 days
Good day, ready to complete your project, I will do everything in good quality. I propose to develop on Yii2 or Laravel to accelerate the development process. More detailed in personal communication.
Budget: 7000 UAH Deadline: 14 days
Good day ! After reading the description of the work, there remained a few questions. I am ready to discuss them and start work. The price, dates and everything else should be discussed.
I also attach my portfolio: https://github.com/Alexey-Buglak
Proposals concealed
Current freelance projects in the category Databases & SQL
It is necessary to compile a large and up-to-date database of contacts of Ukrainian scientists, educators, researchers, doctoral candidates, and graduate students using only open sources. The result should be in Excel or CSV format and contain at least full name, email, place of work (university or research institution), position, and a link to the source from which the contact was obtained. It is essential to minimize duplicates and, if possible, verify the validity of email addresses. For data collection, official websites of universities and research institutions, faculty profiles, department pages, institutional repositories, journals on the OJS platform, ORCID, OpenAlex, Google Scholar, ResearchGate, Crossref, PDFs of scientific articles, as well as other open academic resources can be used. The use of automation (parsing, API, Python, etc.) is encouraged if it does not violate the rules of the respective services. The main goal is to gather the most complete database of contacts from open sources.
A centralized server system for collecting and storing data from Planfix, 1C, Meta Ads, and Google Ads is needed, as well as a web dashboard for displaying and analyzing this data. All data, change history, calculations, and aggregated metrics must be stored exclusively in the server database. The dashboard should not store or duplicate business data. It must retrieve the necessary information from the server database via API according to user requests and display it in the form of KPIs, charts, tables, and detailed reports.
We are looking for support for a project based on Yii , we need to make edits and improvements to the database, there is partially a connection with the previous contractor .....................
It is necessary to migrate the database from CRM G-PLUS to MyChatBot Database volume - 26 thousand leads 2 funnels - Call center and Sales department with their own funnels Lead cards (besides name and number) have many different fields Leads also have voice recordings of calls. These also need to be transferred I expect an approximate amount and implementation timeline from the candidate
Create a dashboard for monitoring and analyzing the performance of the company's location network (branches) in Google Business Profile (GBP) through the official Google Business Profile API. Process via a script based on Google Apps Script (link to Google Sheets). Record data in Google Sheets (which serves as a database for Looker Studio). Update: Daily (with an indication of the last update date). Create a Google Cloud service account. The script runs once a day (trigger at 03:00 AM) and sends a request to the GBP API. It retrieves metrics for the previous day for each location (locationId). Records data in a flat format (row = unique combination of Date + Branch ID + Metrics). Key Performance Indicator CardsCard NameGBP MetricDynamic FormatProfile ViewsImpressions (Search + Maps)Percentage %, Sparkline (blue)CallsLocal Services Phone CallsPercentage %, Sparkline (green)Website ClicksWebsite ClicksPercentage %, Sparkline (purple)Direction RequestsDirection RequestsPercentage %, Sparkline (orange)Average RatingAverage Review RatingAbsolute change (e.g., +0.1), Sparkline (yellow)New ReviewsNew Reviews CountPercentage %, Sparkline (turquoise)