Unix shell script sql jobber

I'm seeking a freelancer who can aid in creating a 1-2 minute corporate promotional video. Key Requirements: * Time Frame: A draft is required within a short span of 12 hours. * Budget: I have set aside a budget of 100 USD, with flexibility for increment based on your professional fee. * Style: The promotional material should ideally exude a formal and modren, professional tone. - I have script - 1-2minute video

...transitions, text overlays, and motion graphics to keep the audience engaged and highlight the membership program's benefits. Ensure branding is consistent with our website () in terms of colors, fonts, and overall aesthetic. Duration: The videos should be 15-40 seconds long to effectively convey the message while keeping the audience engaged. after the first two lines of the script are used, then the Call to action should sit on screen for the duration of the rest of the video (Click for an info pack) Budget and Quantity: We need you to create 5 variations with different footage in each For each video created, we require both a portrait and a horizontal version. We will be picking 2-3 of the best winners Brand and Style Guide: For brand consistency, refer to our websi...

As a professional hypnotist putting o...a professional hypnotist putting on a show, I'm in need of someone with a flair for the dramatic and an understanding of hypnosis to help write material for an hour-long hypnosis show. This show needs to engage various audiences such as the general public, corporate events, and teenagers. Key Tasks: - Craft an engaging, entertainment-focused hypnosis script - Ensure audience inclusivity, suitable for all aforementioned groups - Keep script runtime to a solid 1 hour Ideal Candidate: - Excellent creative writing skills - Knowledge or willing to gain research-based insights in hypnosis - Experience writing for entertainment or shows Remember, this is not therapeutic or educational hypnosis, it's all about entertainment. Let&#...

I'm in need of a distinguished SQL developer with an adept background in ETL Testing within Snowflake. The successful candidate will be responsible for: - Carrying out efficient ETL Testing in Snowflake. This will involve knowledge in specific areas such as data extraction, data transformation, and data loading. - Execution and validation of SQL Test Cases. This specifically includes conducting data integrity tests and data retrieval tests. The ideal candidate should have proven experience in SQL development, ETL testing and knowledge in the Snowflake environment. An understanding of database design, query optimization, and database administration will be highly beneficial. The candidate should be detail-oriented and should have a keen eye for identifying and a...

Greetings potential freelance tutors! I'm on the lookout for an individual with real time Power BI development experience to help me level up from a beginner to an adept user, preparing me for an upcoming job interview. Please note ** I have above average skills in SQL and need to learn power BI to work as data analyst*** To get a clearer picture of what I require, here are some specifics: - I am a beginner in Power BI, hence I am open to starting with the basics and gradually developing a robust knowledge of it. - While I am open to all aspects of Power BI, I do not have any specific areas to focus on currently. So, your suggestion on structuring the learning plan would be highly appreciated. - To make the learning more pragmatic, I would love to apply what I learn on some ...

...that involves the use of SQL servers, where I'm looking to develop a system to track the delta i.e. the incremental changes occurring within the server. This procedure will help me manage regular uploads, specifically on a weekly basis. Here's a rundown of what I'm envisioning for this task: 1. Base Functionality: Create a mechanism to identify, track and summarize the delta changes in the SQL server. These changes will be prepared for weekly uploads. 2. Database Source: The delta will be detected directly from my SQL Database, thus expertise in database systems and management is required. 3. Regular Updates: As mentioned, this procedure will take place weekly. The ability to automate this process would be heavily favored. Skills and Experience: ...

...pre-inspection status, project number/location) are effectively implemented on the HTML form. The signature box must be functional and the user's input should be captured properly. 2. Data Storage: Upon submission of the form, all data needs to be stored into a SQL database. 3. PDF Generation: Lastly, after the form has been submitted and the data saved, a PDF form should be generated dynamically with all the data captured from the user, including their digital signature. The successful freelancer should have proven experience with HTML, SQL, PDF form generation and handling digital signatures. Familiarity with JavaScript may also be beneficial to manage form data effectively. An eye for detail is crucial for this task, ensuring all fields capture and display data...

...freelancer who can generate an animated video featuring a human-like AI spokesperson. The video script is quite expansive, with around 3200-3500 words in total. The key elements to consider in this project entail: 1. Video Format - The video should be purely animated. Using already available resources or creating original animations is completely up to the chosen freelancer. 2. Color Scheme - The animation should incorporate a gentle blend of pastel colors. It should create a visually pleasing aesthetic without detracting attention from the AI spokesperson. 3. AI Character - The AI spokesperson should take the form of a human-like character. It should express emotions and gestures that align with the script. Proficiency in animation tools, a keen eye for color and detail...

...disponibles para que yo pueda examinar y entender a fondo el desempeño de mis empleados. Se requiere experiencia en desarrollo de software y se valorará especialmente la experiencia en desarrollo de sistemas de evaluación de personal. Busco un profesional que pueda aportar soluciones innovadoras y funcionalidad excelente a este proyecto, en particular devs con conocimiento en Angular, NestJS y SQL Server....

I need an automated script that can import multiple source files and fill in relevant sections of multiple tabs of an template file for analysis. In addition to import, I need automated generation of formulas and sections to be dynamically expanding or collapsing based on the depth of source data. More details on chat.

I'm in need of an experienced LISP script creator who can help me develop a custom script for Autocad/BricsCAD. My main aim is to automate certain aspects of the drawing process, saving both time and effort in my tasks. Specifically, this script will need to automate: - Dimensioning Here are some characteristics the ideal freelancer for this project will have: - Experience with Autocad/BricsCAD - Knowledge in creating LISP scripts - Understanding of the drawing automation process

...for a birthday occasion. The audience will be composed of a mix of friends; I need someone who can creatively incorporate a multiplicity of humor styles to engage all listeners. Key requirements: - Experience in writing comedic scripts or roasts. A portfolio showcasing previously written roasts or comedy scripts will be highly appreciated. - Ability to deliver a sharp, witty, and hilarious script that will keep the audience entertained and engaged for ten minutes. - Familiarity with writing roasts for diverse audiences, including colleagues, friends, and family members. - An understanding on how to balance humor and respect, ensuring no lines are crossed during the roast. In summary, the ideal candidate will craft a memorable, entertaining, and humorous speech that ackn...

I'm currently in search of a highly skilled Content Writer who can generate a persuasive and informative landing page that promotes our Managed services offering tailored for Enterprises using High end technology environments eg. Oracle, MySql, Ms-SQL hosted on Cloud, on-premises. The main objective is to capture the attention and interest of the CIO, IT Directors, CTO's, showcasing how our proven services will augment their team and operations, in a compelling way that encourages them to explore what we offer further. To have a more comprehensive basis for selection, please provide me with past work samples that are similar to this project brief. Key to success of the landing page is the encapsulate keywords to ensure SEO aspect is taken care. Ideal skills necessary fo...

I am looking for a content creator to help me with my course. The ideal candidate will have experience creating video lectures for adult learners. Content Requirements: - I have a detailed script for the content, so the freelancer will need to follow it closely. - The course will consist of video lectures, so the freelancer must be skilled in creating engaging and informative videos. Ideal Skills and Experience: - Experience creating video lectures for adult learners. - Strong scriptwriting skills to ensure the content is clear and concise. - Proficiency in video editing software to create professional-looking videos. - Ability to create visually appealing slides or graphics to enhance the video content. If you are a content creator with experience in creating video lectures for...

Hi, I was referred to this website from my search engine. My name is Tom Benson and I'm a filmmaker (Writer Director). I live in New York City (Manhattan) I'm in the process of finalizing a pitch deck for a film project I've written and...with the intended tone, and then integrating the final image into my pitch deck along with a tagline. I'm seeking a talented individual, possibly a recent graduate, who specializes in this type of design work. I am prepared to compensate at market rates for a few hours of work. Time is of the essence as this is just a preliminary step in the investment process, with the main focus being on the script, budget, and shooting schedule. If you can assist or recommend someone, please contact me [removed by freelancer.com admin] ...

We have a mobile app called Acade...getting the 404 on the production only Browsers enforce a security feature called CORS, which restricts web pages from making requests to domains outside of their domain. so that is why we were getting the 404 issues because the browser was blocking our request this happens when we try to use this kind of setup on a firebase hosted project so the solution for this is I write a server-side "proxy" script to make the request from code running on our server and change the code in our home page to call the proxy instead of the remote resource so I will be using firebase cloud functions to achieve this so now I wrote a cloud function to handle this and get the response and show the tweet in our home page " Experience writing custom Flu...

I'm looking for a skilled web developer to create a lighter version of OLX, predominantly for advertising services. Essential features should include user registrati...services. Essential features should include user registration, ad posting, and a robust search system. Although primarily for service advertisement, the ability to integrate the buying and selling of products at a later stage should be considered during design. Key skills needed for this job: - Proficiency in HTML, CSS, JavaScript, and preferably Java for backend programming - Familiarity with SQL databases - Experience with digital advertising platforms would be a bonus The timeline for this project is urgent. It is expected that the developer will be able to dedicate sufficient time to ensure completion as so...

...our project involves working with key cloud platforms - AWS (Amazon Web Services) and Google Cloud Platform. The ideal candidate for this job should have: - In-depth knowledge and experience servicing both AWS and Google Cloud Platform - Good understanding of Kubernetes and containerization approach to software deployment - A strong background in working with PHP, JavaScript, React, and Cloud SQL - Proven experience in implementing and managing CI/CD pipelines, infrastructure, and log analysis. By joining us and performing the required tasks to the highest standards, you'll shape up the efficiency of our operations, leading to a significant advancement in our project. Applicants are encouraged to share their previous projects and experience in similar roles. For those...

I have a construction project in mind that I need an estimator for. Specifically, it's a commercial building project that needs to be accurately costed. It is a 2-story 80,000 SF medical office building core & shell. our scope of work includes CFM framing, sheathing, rough carpentry, insulation, fireproofing, shaft walls, LGS framing, drywall and acoustical ceilings. I'm not just looking for a ballpark figure, but rather a detailed itemized estimate that covers all potential costs. A comprehensive understanding of construction costs and the ability to delve into specific areas of cost is required. Ideal candidate will have experience with OST & QuickBid, as well as Proest. A candidate with their own software is preferred. Ideal Skills & Experience: - St...

...currently in the process of completely re-writing our product from vb .NET webforms to C# in the MVC framework. You will assist with this project and help us develop new features. You will work with our team of inhouse front end developers and another freelance C# developer. Budget is £25 per hour The following skills and knowledge of technologies will be essential: - VB - .NET - C# - SQL - MVC framework - VUE .js framework - Windows Server The following would be advantageous: - HTML/CSS - Bootstrap - Azure - An interest in Football - Previous experience of the GoCardless API Our relationships with freelancers have always been long term, we are not looking for a quick fix. Candidates MUST be available for communication and be responsive durin...

We seek a seasoned Web Analytics expert to lead technical Google Analytics 4 (GA4) implementation projects across various sectors. The role involves transitioning clients to GA4, crafting measurement strategies, and integrating Google Tag Manager (GTM) for data transmission. Key responsibilities include tagging sites, conducting tag rep...and interpersonal skills (in English). - Hands-on experience in tag implementation & maintenance. - Ability to troubleshoot technical issues in GA4 and GTM. - Confidence in client-facing communication. - Understanding of data Layer implementation best practices. ** Desired Skills & Experience: = = = = - Google Analytics 4 Certification. - Backend GCP/Big Query, Data Lake, and/or Python skills. - SQL skills. - Advanced data analysis and...

I'm looking to have a SQL view query written in Redshift. With no specific tables indicated, the freelancer should be adept enough to identify the relevant tables during the development process. Requirement: - Expertise in SQL and Amazon Redshift. What To Include In Your Proposal: - Please include any past work related to SQL queries, especially if you've previously worked with Redshift. Deliverable: - The use of this SQL view query is for reporting purposes, so it needs to be efficient and reliable.

I am seeking a developer experienced in AWS and ASP.Net for a personal project. The main focus of this task will be to implement a CICD pipeline. Main Requirement: I am working on the Asp.Net Website Web Form with database MS SQL Server. I want to implement CICD pipeline for my project. Main Aim is that, if I made any change in My Visual Studio 2022 in code then it should reflect on the AWS Server. The objective: - Immediate implementation of a CICD pipeline for my project. Your qualifications: - Proficient knowledge in AWS and ASP.Net. - Prior experience in implementing CICD pipelines. - Capability to deliver the project ASAP. Your role involves: - Developing and implementing CICD pipeline for the project. - Ensuring the pipeline's seamless performance. Take note that ...

As someone who's looking for a proficient Python scripter, I require a particular script that can efficiently extract data from the Avaitor game on the website ODDS96.IN. Excellent skills in web scraping and data processing are a must for this project. Key elements of interest include: - The successful extraction of dynamic data from the Avaitor game - The ability to navigate and extract information accurately from betting sites - Expertise in automation, ensuring the script runs without my interaction once it's set up - Previous experience in working with gaming/betting sites is a plus but not necessary The goal here is to be able to understand the game behaviour better for strategic purposes. I look forward to receiving your proposals and appreciate your inter...

I need a skilled Caribbean voice artist from St Kitts ( or region) to provide a 90 second script recording in a conversational / professional style and utilizing a regional accent. This recording will be used for a viewpoint commentary. - The script will be provided; you will simply need to record in WAV file format. - Local colloquialisms may form part of the script. Script not yet supplied. - Experience with voice overs for tourism sector or in radio broadcasting will be nice to have. - Ability to record high-quality audio is a must. I'm looking forward to your proposals. Please provide a sample of your past voice work if possible.

...We're not outsourcing any projects. This is not a task based project. If you're an individual developer with 3-6 years of Perl + XML + SQL experience, please submit your bid with exact monthly payment requirement. The budget range specifies our monthly budget per developer for full time ( 8 hours per day) commitment, Monday to Friday. Monthly budget is 80K to 120K per month depending on the experience. This job is open to developers from INDIA only. Bangalore based candidates who can work in hybrid mode will be given priority. The ideal candidate should have a minimum of 3 years of experience in Perl development and scripting, with expertise in XML and SQL (Preferred) Below is the Job Description for an in-depth understanding of the requirements. JOB DES...

I require a Power BI expert to support me with data visualization and report creation task...me with data visualization and report creation tasks. My project will primarily focus on sources drawn from Excel spreadsheets, SQL databases and CRM systems. Key responsibilities will involve: - Developing a strong visualization of collected data - Assisting in the creation of comprehensive reports The ultimate objectives are to analyze data trends and improve existing visualization formats for better decision making. Ideal candidates should have significant experience in handling a variety of data sources and creating effective reports. Strong Power BI skills, particularly in data visualization, are essential for this task. Expert-level knowledge of Excel, SQL and CRM systems i...

Hey there, I’m looking for someone to work on this brief. Let me know if it looks like something you can help with. Social Media Analytics Script Development API Documentation: For detailed API endpoints and specifications, refer to Task Overview: Develop a Python script to collect social media data based on user inputs for USERNAME, HASHTAG, and LOCATION. The script will interact with the HikerAPI to fetch, analyze, and store data efficiently. Script Actions: USERNAME Selection: Fetch user posts. List followers and following. Retrieve user's stories and reels. Collect commenters and likers' IDs. Get tagged posts. Identify interactors on posts and stories. HASHTAG Selection: Retrieve hashtagged posts. Identify post creators. Collect co...

We are seeking a candidate with robust proficiency in AWS and automation technologies, specifically utilizing Ansible, Terraform, Git, and Github. The ideal candidate should possess hands-on experience with these tools and demonstrate a strong understanding of CI/CD principles. Familiarity with UNIX/Linux commands and code repository platforms such as Git and Github is essential, along with the ability to define and implement CI/CD practices. The role requires developing automation strategies using Ansible and Terraform, as well as estimating project efforts accurately. Candidates should showcase both independent work capabilities and effective teamwork skills, with knowledge of user story estimation and Agile-Scrum methodologies. Cloud certifications are preferred. Additionally, th...

...are working on another infrastructure revamp opportunity , for which existing SQL servers to be migrated and upgraded, to the new servers (we are providing virtual servers solution). Kindly find below details, we can arrange for an online discussion with customer, please let’s know your feedback, Key Duties: - Migration from old Microsoft SQL Server platform to new one - Ensuring integrity of all data is preserved during the migration - Debugging and solving any issues that may arise during the process - Implementing a strategy for smooth transition and minimal downtime Ideal Candidate Will Have: - Significant SQL development experience - Proven track record with database migrations, specifically Microsoft SQL Server - Understanding of maintaining d...

I'm currently developing a Natural Language Processing (NLP) project for college. Here are the specifics: - **Project Objective**: The main goal of this project is text to SQL generation. - **Functionality**: The system should be capable of converting natural language queries into SQL queries. Though the question about the type of database was skipped, it would be advantageous if you have broad knowledge of databases to handle any type of interactions. Ideal skills and experience would include: - Experience with Natural Language Processing - Strong understanding of SQL - Proficiency in handling diverse data types and databases. Looking forward to your innovative solutions for this College NLP project.

Seeking a talented scriptwriter to write a short English drama script for children. The script should fall under the drama genre and have a runtime of less than 30 minutes. The ideal candidate should have experience in writing engaging and age-appropriate content for children. Creativity and the ability to incorporate educational elements into the script are highly valued.

I'm in need of an expert who can assist me in replicating my entire SQL database. This task is primarily aimed at data distribution. The specifics of the project include: - The replication method to be used has not yet been decided, this is something I will need your expertise with. - The replication should cover the entire database. It's essential to ensure that all data is accurately copied and nothing is left out. Ideal Skills and Experience: - Strong experience with SQL databases - Proficient in various SQL replication methods - Previous experience with large scale data replication - Detail-oriented and capable of ensuring data accuracy - Sound knowledge of data distribution techniques Please bid if you meet these requirements and are confident you ca...

I want someone who can understand powershell script and edit functionality

I'm actively searching for a proficient T-SQL programmer who can aid in SQL Server development. Tasks would include: • Engage in coding script • Debugging code • Optimizing the SQL server Ideal freelancers should have: • Extensive knowledge in T-SQL programming • Proficiency in SQL Server • Proven experience in database development

I am in need of a capable Pine Script developer, specifically someone with a good understanding of creating custom indicators. Specifics of the Task: - The primary task involves creating custom indicators using Pine Script. - Find levels using previous day high low and close with pivot point traditional. - Extended support and Resistance. - Identify bullish pattern (hammer, Bullish harami, bullish engulfing) at today's lowest point and bearish pattern (inverted hammer, bearish harami, bearish engulfing) at today's top point with Alert notification - Identify bullish pattern time frame 3,5,10 and 15 min. - Also add a screener. I am looking forward to your interesting proposals. Thank you.

As an individual who already has a Telesign account, I require skilled assistance to aid in the creation of a simple VBA script for Microsoft Excel that interacts with this service. My major requirement is to be able to send single SMS via the Telesign service using VBA. Key Responsibilities: • Read and comprehend the documentation provided by Telesign on how to use their service with VBA. • Amend my existing 20 lines of VBA code or create a new one that helps me achieve the functionality I am aiming for. Additional Details: • I will be providing the exact content that needs to be sent out in the SMS. Skills and Experience: • Proven experience in VBA (Visual Basic for Applications) • Solid understanding of XML/HTTP requests • Previous work wi...

...multi-disciplinary range of services and not just occupational therapy. The X represents the intersection of the different disciplines such as occupational therapy, speech pathology, psychology, positive behaviour support, physiotherapy and exercise physiology Key Requirements: - Develop a captivating, under 1-minute 2D animation that beautifully illustrates our rebrand journey. - I don't have a ready script yet, so you'll have to assist me in drafting one that graphically narrates our transition. Ideal Skills & Experience: - Proficiency in 2D animation techniques and tools is paramount. - Excellent scriptwriting skills, being able to turn boring facts into an exciting story. - Previous experience crafting similar projects would be highly beneficial. ...

To run the formula reset the data

Come do some interesting GIS programing. *** Please no AI responses. *** Please respond by telling me what is a 3-4. **Requirements:** - Proficiency in spatial SQL -> MUST for complex data query and retrieval. The ability to perform spatial analyses and geometric operations is crucial. - Expertise in creating engaging, interactive maps that can visualize spatial data and analyze spatial patterns on a global scale. This would involve dealing effectively with diverse data sets and potentially large volumes of data. - Strong background in PostgreSQL and PostGIS, with proven experience in writing advanced spatial queries. - Experience in web map development, with a portfolio of previous projects involving visual data exploration and user interaction. - Fluency in Python programmin...

Voiceover of provided 238-word script 'Breed Buddies'

I have a tradingview pine script strategy. I need 1- I want to add something this strategy 2- I need convert to C# code.

I need an experienced VBA script professional who can provide an on-demand solution for my Excel spreadsheets. Excel VBA to be able to run on a file at will. See attached spreadsheet worksheet Start is a sample of the beginning file (there might be more columns than sample file), worksheet END shows a sample of what the final spreadsheet will look like. Sheet1 to End of File Insert 3 columns: I, J, and K I1 title = “Style” J1 title = “Is it Primary Variant” K1 title = “Variant ID” I2 – to EOF, should equal first 4 characters of data in column H Sort by column I J2 to EOF should be When characters in column I changes to new Style enter Yes in column J and enter column A in column K Until column I changes enter No in column J and ent...

Bonjour, Je suis à la recherche d'un rédacteur talentueux pour écrire un livre technique sur l'analyse de données et SQL. Ce livre vise à enseigner aux lecteurs les meilleures pratiques de l'optimisation de requêtes SQL. Voici ce que je recherche chez un rédacteur: - Expérience antérieure dans la rédaction de livres techniques, de préférence dans le domaine de l'informatique - Capacité à expliquer des concepts techniques de façon claire et concise - Bonnes compétences en français écrit Tâches: - Rédaction d'un livre de formation SQL axé sur l'optimisation de requêtes - Traduction de ...

...days : In milestone 1, you will identify the materials in the list which have semiconductive properties. You will also identify materials in the list which can dope the materials to make the materials semiconductors. You will identify them as P type or N type. You will suggest methods to cause the materials to be doped, e.g. laser doping, xenon flash doping, solution doping, core@shell, etc. Some dopants may make the chemicals simply conductive, while other chemicals alter the bandgap of the semiconductive chemicals. The lists contain about 100 green chemicals. Here are some of the chemicals in the lists.: Semiconductors : zinc oxide, zinc iron oxide, attapulgite, bentonite sodium, ferric oxide, graphite, kaolin, magnesium oxide, magnesium sulfate, mica, mo...

I created a simple, 500 line voice assistant that uses gpt 3.5. The user can say "Jarvis" as the wake word, and the script will listen for a command, whatever is spoken next is sent to the gpt 3.5 api, and the response is spoken out loud. The script works perfectly, except I'm having difficulty getting it to work asynchronously and allow interrupting the ai during the response. I tried splitting the AI's response into multiple sentences, and checking between each sentence if the wake word has been spoken, but if for example I say "Jarvis" and then "Jarvis" again a few seconds later, the AI will finish the entire response, and then will recognize that I said Jarvis, and will recognize it again a few seconds later. So the program is suc...

...urgent need of an experienced PHP developer to undertake a comprehensive update of our existing affiliate script. The primary focus will be on fixing bugs, adding new functionality, and significantly enhancing the script's security, with a particular emphasis on preventing unauthorized database access. The ideal candidate will have a deep understanding of PHP, MySQL, security best practices, and experience with affiliate systems. #### Core Responsibilities: - **Security Audit:** Conduct a thorough security audit of the existing script, with a special focus on closing loopholes that could allow unauthorized database access. - **Bug Fixes:** Identify and resolve existing bugs in the script to improve stability and performance. - **Feature Development:** C...

I need a script developed in Python that can efficiently pull specific resource information from Azure. The script must focus on the following resources: - Virtual Machines - Storage Account Information - Databases For each Virtual Machine, the script should be able to retrieve: - OS details - CPU and memory usage - Network configuration - All other available attributes Ideally, the successful freelancer will have robust experience in Python and Azure SDK, with the ability to write well-structured, efficient and clean code. Deep understanding of Azure resources is a must. Working knowledge of database structures and network configurations will be highly regarded.

i need a youtube editor with knowledge in the football/soccer space, you will need to script-write aswel as the whole video production I want my videos the using a similar edit style as the ones attached below (Please obviously implement your own tricks and edits but take inspiration and structure from these vids) %0AimM_812MTO %OAsi=WjNxVZHZ7EYc5zES

In th...effectively use C# to integrate APIs in the backend. This task demands intermediate to advanced skills in writing C# code and a deep understanding of API integration. Key requirements: - API integration, with specific focus on integrating with third-party services - Managing data storage using Microsoft SQL Server The successful candidate should ideally possess: - Profound understanding of .Net development framework - Experience in using C# for API integrations - Proven proficiency in using Microsoft SQL Server for managing database operations - Familiarity with good practice and modern backend frameworks Note: Knowledge of Xunit and microservices will be an added advantage. This outlines the basic task, but I'm open to discussing more functionalities that ma...