Database sql scriptεργασίες

I am seeking an experienced Python developer to improve the functionality of a current script by adding new features, specifically automated tasks. The upgrades will involve: - Analysing and understanding the existing Python script. - Enhancing the script by adding automated task features to streamline operations. - Testing the script to ensure it performs as required with the new features. Ideal applicants will have: - Proficiency in Python, with a focus on script optimization. - Experience integrating automation functionalities into Python scripts. - A keen eye for detail and error detection. - A proven track record improving and maintaining Python script performance. I am looking forward to working with someone who can improve our script&#...

...into my project in full. I have integrated demo vesrion only. The primary goal is to improve the user experience by allowing for drag and drop functionality for file uploads. Key Requirements: - Implementation of drag and drop functionality using DropzoneJS - Ensuring DropzoneJS supports multiple file uploads at once - Do not need integration within the existing project structure. PHP Upload script working just fine. - Adherence to best practices for user interface design and user experience Ideal Skills and Experience: - Proficiency in JavaScript and relevant libraries, particularly DropzoneJS - Proven experience with front-end development and UI/UX design - Ability to integrate new functionalities to existing codebase Validation: - Start your quote with "Validation St...

...AFL that I need converted into TradingView Pine Script. The primary function of the current code is to execute trading decisions based on the conditions of the market. **** 1 MORE CONDITION TO BE ADDED MENTIONED IN TXT FILE ATTACHED******* ***** FIXED PRICE RS. 3000/- ONLY ******* Key requirements: - Conversion: The Amibroker AFL strategy needs to be converted to TradingView Pine Script. The converted script should retain the functionality and logic of the original. - Optimization: The Pine Script should be optimized for performance on the TradingView platform, ensuring efficient execution and minimal latency. - Strategy understanding: It's crucial that the freelancer understands the trading logic and conditions embedded in the Amibroker AFL script...

I have a 15-minute script in progress and I'm seeking a professional Turkish male voice-over artist to bring it to life. The project involves recording the script in a professional tone. Key requirements: - Male Turkish voice-over artist - Previous experience in long-form voice-over - Ability to deliver a professional tone - Strong communication skills I'd appreciate someone who can collaborate with me on this project, offering input on pacing and intonation where necessary. I'm looking for a voice that is clear, engaging, and professional. Please provide samples of previous work in your bid.

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking

Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).

I am in need of expert skills in 2D animation to create a short, engaging video that encompasses a unique process. Requirements: - The animation should be 2D. - Experience with creating short, impactful animations is essential. - The completed video s...create a short, engaging video that encompasses a unique process. Requirements: - The animation should be 2D. - Experience with creating short, impactful animations is essential. - The completed video should be less than 1 minute in duration. - I will provide the script for the animation. - Grasp on translating text to visual imagery is invaluable. Ideal freelancers will possess exceptional 2D animation skills, strong communication, and an ability to work efficiently to create a punchy, less than a minute video from the provid...

Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto

There are 89 simple phrases and the recording would take about 15 mins. the speakers need to be: - Native Italian speakers from Italy. - Age from 18-55. - Both professional voiceover or amateur Budget: $8 per speaker. We reserve the right to reject any recordings that do not meet our quality standards. (the pronunciation) Feel free to contact me if you are interested in this project. Best Regards Libby

I require a skilled 3D visual effects animator to create engaging rear projections ...particularly visual effects. - Ability to animate flying effects and magic effects. - Knowledge and experience in theater productions or similar events are a plus. - Strong understanding of timing and how visuals can enhance a live performance. Your task will be: - To design and animate distinctive 3D flying and magic effects. - To work with the director to ensure the visuals align with the script and the vision of the performance. - Be able to revise and refine animations upon review and feedback. Your goal is to create visual effects that will captivate the audience and enhance the overall experience of the theater production. I look forward to seeing your portfolio and discussing the projec...

Preciso de uma pessoa que faça a instalação e configuração de uma instância do Izing (Preferência pelo PRO com SaaS) ou Whaticket em uma VPS. O profissional deve possuir a expertise necessária para assegurar que não exista nenhum backdoor ou script malicioso no pacote usado para instalação. O pacote de instalação é de responsabilidade do profissional. Preciso das seguintes funcionalidades: • Suporte a API Wpp não oficial; • Chat multiusuário; • Transcrição de áudio • Configuração de chatbot com diversos fluxos; • API para disparo; Recursos que acho interessantes: • Suporte a API Wpp oficial; • Suporte a ...

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions ac...

I am experiencing slow query processing and management issues with large ...experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall d...

I am in need of a talented script writer who can create engaging, Hindi language horror scripts for YouTube. The scripts are for short films, with each video being less than 10 minutes. The focus of the horror should be more psychological thriller than supernatural or slasher. Key requirements for this project include: - Fluency in Hindi - Proven experience in scriptwriting, particularly for the horror genre - A deep understanding of the psychological thriller subgenre - An understanding of the dynamics of YouTube content and how to captivate an audience in a short span of time. The ideal candidate will be able to weave a compelling narrative that keeps viewers on the edge of their seats, all while maintaining a distinctly Hindi language and cultural context.

...working: VSL ad video that is working: Script for the ad: Script for the ad We want to use viral images to attract more people’s attention. Format: Beginning of the ad is a viral meme + cut to my recording + cut to body of the edited ad (old body that works) Beginning of the ad is a viral meme GC | Viral Memes + Middle of the ad is ME acting out something - “this might sound crazy but…” GC | Kim's Ad Footage + End of the ad is the original body of the video: - start from “this might sound crazy but..” GC | Adset 2 for Nick [Sprint 2] Video (raw) : Video (edited): Script for the ad: Script for the ad - for the subtitles The order of Reels I shot: Script: Reel:

i have Indicator tradingview code i need to fix the jason message to send alert in telegram group fit with cornix

...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush or...

...currently in need of a professional who can assist in completing a database for over +14000 companies. The goal of this project is to generate high-quality sales leads. Key Project Details: - You will be required to include accurate and up-to-date contact information including phone numbers and email addresses. - In addition to the contact details, each company's key contact person's name must also be included in the database. The ideal freelancer for this project will have: - Prior experience with database generation and management. - Proficiency in data mining and web scraping techniques. - Exceptional attention to detail to ensure accuracy of information. - Proven track record in generating sales leads through database creation. This project i...

I'm looking for a skilled developer to create a custom script for Jira Cloud. The script should modify the behavior of a select field within the platform. Key Features: - Dynamic Select Field: The select field should dynamically change based on the values chosen by other issues in the project. This means that as the field is selected, it should update to exclude values already in use by other issues. - Hide Values Already In Use: The script should ensure that the select field does not present options that have already been selected by other issues in the project. - Customize Form Behavior: The script should also allow for custom form behavior in Jira Cloud. This project requires a developer with experience in Jira Cloud and strong skills in Groovy, the r...

I'm looking for a talented native English speaker to paraphrase a script for a video. The script is intended for a general audience, so I need the content to engage and connect with viewers. The tone should be energetic. Key Requirements: - Native English speaker - Experience in script paraphrasing - Able to adapt content for a general audience - Capable of infusing an energetic tone - Understanding of video script writing nuances I'm looking for someone who can take my existing script and elevate it so it resonates with a wider audience. If you've got a great understanding of language, are creative, and can bring energy to your writing, this could be a perfect fit for you.

I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...

...on below terms as it is same for all of us, all team members. Use our projects to monetise your extra 4 hours a day, which were otherwise not making you anything. Work includes : 1. rebranding projects 2. upgrading dependecies to latest (which will again be useful in future projects done on same script) 3. smoothen flow and bug fixes to ensure all functions work perfectly (usually required in first project done on a particular script, which will again be used in future projects done on same script. We usually assign work on few particular scripts to each dev, so that this needs to be done minimum number of times). 4. Recurring projects based on expertise, and project flow (usually 1-5 projects per month per lancer depending on work quality, ethics, expertise and b...

I have a fairly complex Autohotkey script that customizes the behavior of an application. This script involves some advanced functions like Windows API calls and file manipulations, and I need it to be converted to C# code. The C# application doesn't need to have a GUI, it only needs to replicate the functionality of the Autohotkey script. API used - GetMenuItemCount EnableMenuItem GetMenuString Ahk method used MouseGetPos CoordMode WinExist WinGetClass LButton::return SendMessage WinGetTitle WinGet WinActivate ControlGetFocus Key requirements: - Convert an advanced Autohotkey script that customizes application behavior to C# code - Ensure the C# code replicates the original Autohotkey script's functionality - No GUI is required in the C# applic...

Data Specialist: The Data Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black peo...

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Pr...

Write the script for mi insta reels based on the raw video provided to you. Script should sound genuine and engaging taking context from the provided video

I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-ba...

I need software to automate the login process of a Windows Desktop Application (fill Username & PW). For that, i'm looking for either a consultant that can recommend/evaluate existing soft- and hardware, or a skilled developer to create a software/script for the task. The desired operation is as follows: User scans a finger. Based on the result, the username/PW fields are auto-filled and submitted. A UI to add/edit/delete users is obviously needed. Ideal Skills and Experience: - Proficiency in Windows application development and/or Windows scripting. - Experience with biometric fingerprint devices. - Experience in software automation. A proof of concept for the auto-fill part has already been tested and can be provided. A fingerprint scanner is already existing, if a so...

ALL PHP script of the configurations and parameters of the site /////CONFIG AND INSTALL SCRIPT //// I want a complete configuration of all parameters URL DEMO SCRIPT. 7437.Cj0KCQiA5rGuBhCnARIsAN11vgR0IAOeV3fZLehJ28mJeOVeC35qXrrXFJfbYhlUK8e9nraqPybSIxUaAic2EALw_wcB .................................................. ................ ......... I want a complete script setup with all systems working. CREATION OF ACCOUNTS AND EMAIL ADDRESSES TO MAKE THE WHOLE SCRIPT WORK example add: :add languages EUROPE AND ENGLISH : account creation, facebock, instagram, twitter X, (create an email address on the domain)

We're looking for someone to qualify leads and set appointments with interested parties for our web based 3D virtual floorplan software. We'll initia...afterwards we'll look at paying you for a set number of hours as milestones. We currently have hundreds of contact details which need to be worked. Competitive rates will be prioritised. Skills needed: Good conversational English Preferably neutral accent Ability to evangelise a product Competent with telephone sales Duties include: Cold calling from a spreadsheet of prospects Work using a script as guidelines Pitching our product to prospects over the phone Conversationally move a prospect to a booked meeting with our Sales Director There is also commission available which will be discussed after the trial per...

... The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or coaching Azure Analytics would be advantageous - Strong Communication: The ability to clear...

...Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowl...

...expert mobile developer to build an event app for both iOS and Android platforms. The application will primarily function as an event hub and needs to incorporate a number of advanced features. The app must support: - Event registration - Agenda scheduling - Push notifications - Selling different priced tickets per seat/location - country of the event and more - API integration with website (php script built with laravel) A similar app will be provided for reference. The ideal candidate should have solid experience in implementing these features and a strong understanding of both platforms. Being able to create a user friendly and smooth interface is essential. Knowledge of ticket sale systems and push notifications will put you at an advantage in the application process. Pl...

I'm in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: -...considered a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creation and maintenance for tracking and managing products. The purpose of this project would be Bug fixing and improvement of the software tool already existing. Required: Experience with ER Models architecture Experience with MS SQL server 2017 express as DBMS Experience with Python 3.8.3 and Tkinter GUI toolkit Experience with Powe...

I am in need...Access specialist to create a straightforward database. The main aim of this project is the production of a simple database with a focus on data reporting. Key Points: - The database is intended for data reporting purposes. - There will be 1-5 different types of data entries (tables) in this database. - The final database should be equipped for generating various types of reports from the data it contains. - I am looking for a freelancer who can also document the database effectively. Ideal Skills and Experience: - Experience in designing and building Microsoft Access databases, specifically with a focus on reporting. - Strong knowledge of structuring databases for efficient reporting. - Ability to provide clear and concise docume...

We are building an AI Calling Application using Streaming + STT + LLM + TTS. We are looking for someone having expertise with LLMs (especially Open LLMs and SLMs) to guide and deploy the best Language Model for following our script in real time, and providing very quick responses. We plan to scale this to 100 concurrent users/live calls, so want someone with experience in LLMs (specially Open Source) and their benchmarking/requirements. Please do not blindly fire without proper knowledge, that leads us to waste time and resources. More AI tasks in planning, if this is completed satisfactorily.

I need assistance with extracting specific data from a voter list that comes in PDF format from the election commission. Here’s what I need: - Extract Name, FathersName, Age, Gender, VoterID, and SerialNumber from the PDF voter list. - Placement in a standard Excel format is acceptable, no need for any specific formatting. - Not just a one-time service, I also need a software or script that can perform this PDF-to-Excel conversion automatically in the future. Ideal candidates for this project have advanced skills in data extraction, familiarity with handling election data and proficiency in developing an automated system for convenient PDF to Excel conversion.

You will need to visit and search for the following categories. Drainage Glazing repair Appliance repair Plumber Electrician Roofer Use the postcode W2 4DP After you have the search results You will need to open a google sheet and have the following categories Name of Business Website (you will need to find this either from checkatrade or google if you use google do not put LTD on the end) Companies house link for each business use this link The task is to complete 500 companies - please bid knowing this and only bid if you read the brief and understand it

I need a 30-second video explainer in Hindi, targeted at adult viewers, that explains the features of a product. The script is ready. However, I need an AI-generated realistic avatar to be the primary character in the video. Key Project Details: - Video length: 30 seconds - Language: Hindi - Target Audience: Adults - Avatar Style: Realistic Requirements: - Proficient in creating animated video explainers - Experience with AI-generated avatars - Skilled in producing content in Hindi Please include relevant samples of your previous work in your proposal.

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...

Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This pro...will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be discussed d...

I'm currently experiencing database connection errors on my Wordpress website. Key Requirements: - Fix database connection errors causing website load problems - Ensure the website is running smoothly and all features are fully functional - Full access to the website's hosting account and database for troubleshooting - Clear and timely communication using instant messaging for updates and feedback Ideal Skills and Experience: - Proven experience in resolving database connection errors on Wordpress websites - Strong understanding of database management and troubleshooting in Wordpress - Excellent problem-solving skills and ability to work efficiently - Previous experience in instant messaging for client communication is a plus Had issues lik...

** Urgent Need ** I need 1 Script Description Content every day each one will be short 100-200 Words. Video Will be provided. Content Topic/Type Example: The Content should be like this type of topic and 100% unique and related to the subject. All the content should be well-researched and have accurate information. The budget is $10 Per Content. Newbies are highly welcomed.

...overshadowing the message. - Making sure the script is engaging, thought-provoking, and highlights the importance of reproductive rights effectively. Skills & Experience Needed: - Experience in scriptwriting, particularly radio scripts. - Familiarity with, or willingness to research, modern day issues surrounding reproductive rights. - Ability to combine personal experiences with factual information seamlessly to create a compelling narrative. - Possess sensitivity and understanding for the topic at hand. Be clear in your presentation with the following: What issue you are addressing Why the issue is timely, topical, and relevant to our time and place The ideal freelancer for this project would be someone who can bring empathy and understanding to the script, shed...

I'm looking for a professional Flask and Python developer to help me implement a user management system for my website. The user management system should have Social Media login integration. Additionally, I would like the selected developer to set up a payment gateway and a MySQL database. Ideal Skills: - Proficient in Flask and Python - Experience in implementing user management systems with social media login integration - Proficient in setting up payment gateways - Proficient in working with MySQL databases

I'm urgently looking for a programmer with experience developing play-to-win games, specifically with an existing script. Main requirements and preferences: - Preference for a Ludo style game, but open to alternative suggestions in this format. - The game must have a “play to win” mechanism that needs to be engaging and well thought out. - The platform is flexible, it can be a web-based game or an app, so previous experience in both or either of them is an advantage. - The project has an urgent deadline and must be completed as quickly as possible. Ideal Skills and Experience: - Experience in developing play-to-win games, preferably with a mechanism similar to Ludo. - Proven track record in web or app-based game development. - Ability to deliver high quality proje...

I require a skilled developer to create a Pine Script indicator for I want to create a dashboard Indicator to show Moving Averages and market structure of all time frames I'll send details from chat Like this -

I'm seeking a developer to create a Roblox executor compatible on Windows. This program must feature: 1. Script Execution: - It should have the capacity to successfully execute scripts in Roblox games without interruption or failure. 2. Game Exploits: - The program should be able to identify and exploit weaknesses in the game for a better user experience. 3. User Interface: - Creation of a detailed, intuitive, and user-friendly interface is crucial. I prefer a UI design that is simple to navigate, even for new users. The ideal freelancer for this project will have robust experience in Roblox, an understanding of game exploiting methods, and the proficiency in creating user interfaces in different platforms, particularly Windows. A portfolio showcasing similar completed pro...