Planning and accounting of production in Microsoft Excel.
Professional proficiency in MS Excel tools is required, including VBA macro programming, Power Query, Power Pivot, Data Validation, Power BI. It may also be necessary to have knowledge of MS Access. The technical task of the project is provided in the attached file.
Applications 1
Client's review of cooperation with Viktor Biruk
Planning and accounting of production in Microsoft Excel.The work is done qualitatively. Professional proficiency in MS Excel. Attention to detail and understanding of the production planning process.
Freelancer's review of cooperation with Ihor Visovsky
Planning and accounting of production in Microsoft Excel.Very good cooperation. Clear technical specifications. The client is in touch, provides detailed explanations regarding the production process. Only positive from the collaboration.
Current freelance projects in the category Databases & SQL
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (PenetrProject Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 11 hours 24 minutes back ∙ 4 proposals |
Database synchronizationSynchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 17 hours 15 minutes back ∙ 9 proposals |
Setting up a backup system and optimizing server infrastructureObjective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 1 day 15 hours back ∙ 23 proposals |
PIM system
225 USD
A PIM system needs to be created. The number of products is several million. There are several suppliers providing data in different formats: csv, xml, API. The data is limited, and often it is necessary to find product characteristics from other sources and supplement them. A… Databases & SQL, Web Programming ∙ 1 day 17 hours back ∙ 43 proposals |
Integration of BAS Shveyka 8
225 USD
Good day, it is necessary to integrate BAS Shveyka 8, connect the website and CRM Sales Drive, set up reports and other data. Databases & SQL ∙ 1 day 18 hours back ∙ 10 proposals |