Optimize sql prestashop työt
Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.
Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...
PrestaShop verkkokauppa-alustalla olevan verkkokaupan kehittäminen, parantaminen, alkuunsaattaminen sekä mahdollisesti ylläpito.
Prestashop kaupan korjaaminen ja päivittäminen. Prestashopissa on ilmennyt http 500 erroria aiheuttajana ilmeisesti smarty cache ja kauppa on todella epävakaa. Tuotteiden kopioinnissa osassa kuvissa kuvan tilalla kysymysmerkki. Olisi tärkeää saada kauppa takaisin vakaaksi ylläpitää ja käyttää. Ehdota tarjousta.
Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
our customers, our company is looking for website optimization skilled people. We want to hear your views on how you could implement for our customers tehokaita and affordable SEO solutions. What kind of tools you can use? Reporting tools, monitoring tools etc etc. In addition, we would like to hear your views on whether järkeävää our clients to set up a landing page for different domain and optimize the separate sites for different search words. Sell yourself to us! What to give and you have the know-how for our company, and how and where you work consists of Reward
...a skilled professional to manage and optimize my Instagram and Google ads campaigns. The primary goal of this project is to drive sales and conversions on both platforms. Key Responsibilities: - Crafting and implementing high-converting ads that reflect my brand. - Monitoring ad performance regularly and making data-driven adjustments to improve ROI. - Ongoing optimization for both Instagram and Google ad platforms to maximize reach and engagement. - Identifying and targeting the ideal audience for both platforms. Ideal Skills: - Proven experience with managing Instagram and Google ads. - Demonstrable success in driving sales and conversions through social media advertising. - Strong analytical skills, with the ability to interpret data and optimize campaigns accordingl...
...implement strategies to attract new clients for our web development services. Identify potential leads and convert them into clients. Build and maintain relationships with clients to ensure long-term partnerships. Conduct market research to identify new business opportunities. Create and deliver compelling presentations and proposals to prospective clients. Collaborate with our marketing team to optimize lead generation campaigns. Track and report on sales performance metrics. Requirements: Proven experience in business development, sales, or lead generation for web development or similar services. Strong understanding of web development services and the ability to communicate their benefits to potential clients. Excellent communication, negotiation, and interpersonal skills. Ab...
...viewers. Your expertise in creating visually stunning experiences is crucial. - Venue Suitability: The mapping is for a medium-sized space. Your ability to optimize the projection for this venue is vital. - Content: The projection will feature pre-recorded video. Experience in syncing video content with projections will be beneficial. Your responsibilities will include: - Translating a vectorworks CAD drawing into a dynamic and engaging visual experience. - Recommending the ideal projector and lens types for the venue to ensure optimal projection quality. - Using your creative expertise to enhance the pre-recorded video content and optimize it for projection mapping. Ideal Skills: - Proficiency in projection mapping software and vectorworks CAD. - Experience with medium-...
...long ago was the last reader job done/developed? How many users using it? What antenna was used? Any ideas to improve your solution? 6. We are in RFID business deeply for several years. Please let us know if you need us to provide some sample RFID tags for your testing, else we assume you will get them. Though they are available at very inexpensive price everywhere. 7. Suggest ways to improve/optimize the RFID passive tag's relative location x,y,z co-ordinates results. 8. Any questions you have that we may have failed to address here. 9. What all editors will be used? 10. Confirm All the IP rights, editable form of designs, drawings, supporting docs, source codes, professional user, installation manuals and any other related materials will be submitted to us, before any paym...
...Backend: C# coding. - Database: MySQL. - Currently hosted on a Windows server with IIS. - **New Hosting Environment:** - Hostinger VPS with Linux OS. - SQL Server installed via command line (no GUI). - No Windows server or IIS available. **Issues Encountered:** - Umbraco runs well locally on the VPS but not accessible externally. - Unable to attach the website domain. - Issues uploading the website from a local machine to the VPS. **Requirements:** - Expertise in Umbraco CMS. - Strong knowledge of C# and MySQL. - Experience with migrating websites from Windows/IIS to Linux environments. - Familiarity with configuring SQL Server on Linux. - Ability to troubleshoot and resolve issues with domain attachment and site deployment on a VPS without a GUI. **Responsib...
A website used to be a WP site. It is now remade with and the new version is hosted on a new server. I need to retrieve the old information from the DB drop. When I try to add the database entries to a freshly installed WP installation and access it (either localhost or server) it immediately throws 301 error and redirects to the new kobe-oukoku website. Please add this text in the beginning of your application so I know you've read the description: kobe animal kingdom.
We are in the process of developing an innovative electrolyte drink with added benefits for skin, hair, and nail health. We are seeking an experienced food formulation specialist to review our current formulation and provide expert suggestions for any necessary adjustments to optimize efficacy, safety, taste, and marketability. Responsibilities: * Review the current formulation of our electrolyte drink. * Assess ingredient interactions, safety, and compliance with relevant regulations in USA. * Evaluate the efficacy of the formulation in delivering the intended health benefits. * Provide suggestions for improving taste and palatability, especially in relation to the inclusion of iron. * Recommend any additional ingredients or changes to dosages for enhanced effectiveness. * Offer i...
...publish engaging content, including posts, videos, and graphics, that are tailored to each platform and our target audience. - Monitor and respond to comments and messages in a timely and professional manner. - Use analytics tools to track and measure the success of our social media marketing efforts, particularly focusing on number of followers, engagement rate, and conversion rate. Adjust and optimize strategies as needed based on performance data. Skills and Experience: - Proven experience in social media marketing, with a track record of successful campaigns and results. - Previous experience in marketing of a streetwear clothing brand is a must. - Strong understanding of the unique requirements of each platform, particularly Facebook and Instagram. - Proficiency in social...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I'm seeking an SEO expert to optimize my website, focusing on Google, Bing, and Yahoo search engines. Looking at around 15 keywords. I currently have some working on the SEO, however they are not getting the results I want. I will handle any Blog, and you can suggest ones if you would like to. - The primary goal is to significantly improve my website's visibility and ranking. - Target audience for my website is B2C (Business to Consumer). Your responsibilities will include: - Keyword research and placement - On-page and off-page SEO optimization - Monitoring and reporting on SEO performance - Implementing strategies to drive leads and sales Ideal freelancers should have: - Proven experience in SEO and a track record of successful projects - A deep underst...
I am currently in need of a professional who can take my partially developed Amazon store to completion. The store is dedicated to the sale of home and kitchen products. The main tasks I need assistance with are: - Storefront Design: I am looking for a professional who can design a visually appealing storefront that will optimize sales and make the store easy to navigate. - Product Image Upload: I need someone who can upload product images in a consistent and appealing way. - General Store Setup: This includes everything needed to make the store fully functional. Ideal Skills and Experience: - Proven experience in designing Amazon storefronts. - Familiarity with the sale of home and kitchen products on Amazon. - Strong attention to detail. - Excellent communication skills to ensur...
As a business owner, I am seeking a skilled freelancer with proven expertise in Microsoft Dynamics GP 2016 for the development of an integration or web service that can optimize our purchasing process. Key Requirements: - **ERP Purchase Invoice Creation**: The primary goal of this project is to create a direct integration or web service that can extract suppliers, products, and purchase orders from various data formats (CSV, XML, JSON) and seamlessly import them into Microsoft Dynamics GP 2016. This will greatly enhance the efficiency of our purchasing workflow and eliminate the need for manual data entry. Ideal Skills and Experience: - **Microsoft Dynamics GP 2016 Proficiency**: A thorough understanding of Microsoft Dynamics GP 2016 is essential for this project. Previous experie...
...offers varying challenges. - Introduce scaling difficulty that dynamically adjusts to the player's skill level, providing a continuously engaging experience. - Include endless mode-specific features such as leaderboards, milestones, or rewards that motivate players to push their limits and strive for higher scores. - Design gameplay loops that encourage players to strategize, adapt, and optimize their tactics to survive as long as possible against the relentless zombie waves. 3. Character Development and Customization: - Create a progression system that allows players to unlock new abilities, upgrades, and customization options as they survive longer in the endless mode. - Implement strategic choices for players to tailor their pet characters and loadouts to ...
...responsive across all devices. Integrate compelling content, including text, images, and multimedia elements, to effectively communicate our products/services, features, and unique selling points. Implement clear and prominent calls-to-action (CTAs) strategically placed throughout the landing page to guide visitors towards desired actions, such as signing up, making a purchase, or contacting us. Optimize the landing page for conversions by employing best practices in user experience (UX) design, layout, and copywriting. A/B testing may be required to identify and implement elements that maximize conversion rates. Deliverables: Initial mockup/design concepts for approval. Fully functional landing page developed according to the approved design. Testing and debugging to ensure...
...from you. Key requirements and responsibilities for this project include: - Developing and implementing a robust digital marketing strategy tailored to a B2C audience - Conducting in-depth market research to identify and engage potential customers - Creating engaging and persuasive email campaigns to drive product purchases - Monitoring campaign performance and making data-driven adjustments to optimize results - Demonstrating a proven track record of successfully boosting product sales through digital and email marketing Ideal candidates will have: - Extensive experience in B2C digital marketing - Proven expertise in creating effective email marketing campaigns - A strong background in data analysis and campaign optimization - Excellent communication skills to convey the produ...
...design is outdated and no longer resonates with the brand image I am aiming for. - Enhance user experience: I need you to help improve user experience on the website. This includes simplifying navigation, making the website more intuitive and improving visual consistency. - Improve loading speed: Although this is a secondary concern, I would appreciate any suggestions or implementations to help optimize the loading speed of the website. Your Skills: Ideal candidates should have a solid background in web design and development. Specifically, I am looking for someone with: - Proficient in HTML, CSS, and JavaScript. - Previous experience in website redesign and enhancement. - A strong eye for design and detail. - Excellent understanding of user experience principles. - A portfolio ...
...I would like the freelancer to assess and advise on the best approach for ensuring the website displays properly on mobile devices. Skills and Experience: - Proficiency in HTML and CSS to develop a visually appealing and functional portfolio website. - Experience in implementing custom designs and ensuring pixel-perfect accuracy. - Knowledge of responsive design principles and the ability to optimize the website for mobile devices, if necessary. Timeline and Budget: - The project should be completed within a reasonable timeframe, preferably in [insert desired timeline]. - Please provide a quote for the project based on the provided information. If you are confident in your web development skills and can bring my specific design to life, please submit your proposal with relevan...
...core platform functionalities using Laravel, including product management, order processing, user management, and reporting. Integration: Integrate major payment gateways and ensure transaction security. Security: Implement high security standards to safeguard data. and Optimization: Conduct comprehensive testing to ensure the platform operates efficiently and optimize based on feedback. Dashboard: Include all features and capabilities for managing and displaying all details, adding packages, themes, and applications through it. Required Skills: •Advanced experience with Laravel framework and PHP. •Strong frontend development skills using HTML, CSS, and JavaScript. •Experience in integrating APIs and payment gateways. •Deep understanding of
I'm in need of an architectural expert who can design a modern medium-sized EV station with surrounding shops. Key Points: - Size: The station and shops will be medium-sized, so your design should effectively optimize the space available. - Style: The preferred architectural style for this project is modern. It should be sleek, functional, and in line with contemporary design trends. - Amenities: The EV station should not just be a stop for charging, but a complete experience. The shops surrounding it should include charging stations, restaurants, and retail shops. This design should seamlessly integrate these elements into a cohesive and practical layout. Your role as an architect will involve: - Conceptualizing and designing the overall layout of the medium-sized EV stati...
...will be integrated with our reader system eventually. 10. Please provide a test software app that emulates our reader commands/responses to prove the results gained by your antenna POC. Please let us know if you need us to provide some sample RFID tags for your testing, else we assume you will get them. Though they are available at very inexpensive price everywhere. 11. Suggest ways to improve/optimize the RFID passive tag's relative location x,y,z co-ordinates results. 12. Submit Testing procedures to verify & confirm for your satisfaction 13. Submit Testing procedures to verify & confirm for our satisfaction 14. Submit Solution's Guarantee details 15. Confirmation that you shall routinely submit complete IP, documented source code and supporting docs and user...
...that I need. The data columns listed above will be need to be automatically pulled into tables and columns and stored in Microsoft Excel. I need to be able to use SQL or a UI and ultimately easily import/embed into Microsoft Excel - the data finally must be pulled into Microsoft Excel. The freelancer must be Proficient in working with Amazon Seller Central and pulling back the relevant info for comprehensive, robust reporting purposes. Understanding of reporting data from Seller Central data and experience in data reporting and data analytics. Also ultimately this data is to be stored into a database and to where I can use SQL to create queries and tables for dashboard reporting purposes. Your work will be crucial in creating and enhancing reporting for accessing a...
...primary focus will be on leveraging social media marketing to drive traffic and conversions. This includes creating and executing effective social media campaigns, and possibly managing the social media accounts. Ideal Skills and Experience: - Proficient in Shopify: The candidate should have a strong understanding of Shopify's backend, be able to set up product listings, manage payments, and optimize the store for conversions. - Social Media Marketing Experience: Proven experience in creating and managing successful social media campaigns, with a track record of driving sales and engagement. - Design Skills: A good eye for design is essential, you should be able to create a modern and visually appealing Shopify store that resonates with my brand and products. Please apply...
I'm searching for a freelancer with intermediate Matlab skills to help optimize the energy efficiency of a battery system for renewable energy applications. Key Project Requirements: - Optimize battery system for energy efficiency: The primary focus of this project is to ensure that our battery system operates with maximum energy efficiency. This involves assessing current battery performance and implementing improvements in its energy consumption. Ideal Candidate: - Intermediate Matlab Proficiency: The perfect candidate for this project should be proficient with Matlab, having experience in battery system optimization. Previous work in the field of renewable energy systems would be a bonus. The goal of this project is to enhance the energy efficiency of our battery s...
In this project, I am seeking a professional to inspect and review the current state of a townhome community gutters and downspouts. This inspection is primarily to: - Determine any needs for repairs or replacements. - Evaluate and propose improvements to increase water flow efficiency. Despite the gutters and downspouts appearing in excellent condition, I believe there is room for improvement to make the water drainage system work more efficiently. Here, the aim is not to maintain aesthetics, but more importantly, to ensure the overall efficiency of water flow. Currently, more than a gentle rain causes water to over-run the gutters, making front doors unusable. Ideal Experience and Skills: - Expertise in gutter and downspout inspection and maintenance. - Proficiency in suggesting pra...
I require a meticulous professional, experienced in the workings of Microsoft A...Solve data type mismatch errors, ensuring seamless data integration - Add some of the small functionalities to the application. - Need the full application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back to its most optimal version in the earliest possible timeframe. If you're that hands-on problem solver with a keen eye for detail, you could be just what this project needs. *Some of the sub-application the software has t...
Se requiere un sistema diseñado en Python que trabaje en sistema operativo Wndows, el cual a través del uso del WebCam pueda hacer reconocimiento de rostros comparando el rostro en la cámara vs el rostro almacenado en formato digital en una base de datos en SQL Server 2016+. El resultados debe ser un True o False. El sistema debe trabajar localmente (No en la nube).
I'm looking for a skilled professional to design and develop an innovative multi-vendor e-commerce platform, where multiple sellers can sell products directly from their respective warehouses. While PrestaShop has been a consideration, I'm keeping an open mind to different platforms that would best serve this concept. We will also need features to accommodate seasonal products available during specific times of the year. Key skills and experiences for the task include: - Proficiency in various e-commerce platforms. PrestaShop expertise is a bonus but not a requirement. - Experience in developing multi-vendor e-commerce platforms. - Understanding inventory management systems, particularly with multiple sellers each managing their own stocks. - Ability to implemen...
Mevcutta hibrit bir uygulamamız var. Sql üzerinden veri çeken bir servis mevcut Bu projeye rapor eklenecek
I'm seeking a proficient SEO specialist, ideally with comprehensive expe...products targeted at middle-aged adults within the South African market. - Your main objective will be to update and improve on the current SEO (settings, keywords, links, and metadata) in order to increase key events from organic search. Secondly, reviewing and updating the 2 current Google ad campaigns to optimize traffic from paid searches. - Experience with Wordpress/Woocommerce is vital due to our platform usage. - Essentially, your role will be to go over the current SEO setup and optimize it. - Proven experience or familiarity targeting South African consumers is desirable bit should not make a big difference. Your expertise will play a pivotal role in maximizing our online visibility, ...
I'm in need of a landing page for my ...must be designed to effectively capture visitor information, particularly: - Names and contact details - Location and service requirements - Specific plumbing issues In responding, please send examples of prior experience with plumbing ot related businesses. Ideal Skills: - Graphic design - Web development - Social media integration - User experience (UX) design - SEO knowledge (to optimize for lead generation) Experience in designing landing pages for service-oriented businesses is a plus. Excellent communication skills and a clear understanding of lead generation strategies are highly valued. Your understanding of plumbing businesses and their unique challenges will be a significant advantage. I look forward to receiving ...
...my current Prestashop platform from version 1.7.7.2 to the latest version 1.7.8.11. As I have custom themes installed, it's crucial to ensure that all of them are compatible and functioning correctly post-update. Additionally, I need all existing bugs that may arise from the update to be identified and fixed to ensure a seamless user experience. Key Tasks: - Update Prestashop from 1.7.7.2 to 1.7.8.11 - Ensure compatibility of existing custom themes with the new version - Identify and fix any bugs or issues that arise post-update Expectations: - The updated platform should be fully functional and all existing custom themes should work as intended - Any bugs or issues should be resolved promptly to maintain the site's usability Ideal Skills: - Strong experience...
...targeting young adults. The primary goal of this campaign is to generate leads for my cellphone sales. The ad copy should have a professional tone to appeal to the target audience. Key Responsibilities: - Design and execute an ad campaign on Instagram and Facebook - Craft ad copies that are professional and engaging - Strategize on how to effectively target young adults - Continuously monitor and optimize the campaign for better results The ideal candidate should have: - Proven experience in creating successful Instagram and Facebook ad campaigns - A good understanding of the young adult demographic - Excellent copywriting skills and the ability to adapt tone to suit the audience - Strong analytical skills to interpret campaign data and make informed decisions If you'...
This project needs a skilled professional who is highly efficient with dbt, Databricks, Snowflake, Google Cloud Platform (GCP), Python programming, and SQL database management. Responsibilities: - Execute data transformation tasks using dbt - Process and analyze data using Databricks - Handle data storage and querying on Snowflake - Manage cloud platform setup and tasks on GCP - Implement Python programming for data manipulation - Write and manage SQL queries and database Ideal Skills and Experience: - Prior experience in the same field - Intermediate level expertise in dbt data transformation - Knowledge of Python and SQL - Understanding of cloud architectures, particularly Google Cloud Platform - Familiarity with Snowflake and Databricks Applicants with su...
Having problems with Docker and need configurations 1 - 3 current running containers need proper ports assigned to them. The containers connect be lost as they are for production. 2 - set up and configure three additional separate Docker groups, each for a different entity which would contain sql, Apache, and file storage. Key Requirements: - Configure 3 isolated Docker groups for Entity A, Entity B, and Entity C isolated from each other. - The setup should be designed for scalability, load balancing, and security although specific requirements for each are not yet defined Ideal Freelancer: - Proven experience in Docker containerization - Familiarity with setting up and managing production environments - Strong understanding of port assignment and management - Capability f...
I need a simple C# Windows Forms management project. It has three classes: Service, Tourist and Tranzactions. It's for college and supposed to be for a tourism agency wanting to keep track of its services, tourists and tranzactions. Nothing complicated, a CRUD app connected to a SQL database, simple UI and the project has to meet the requirements from the screenshot attached below.
I'm in need of a professional who can optimize my Shopify website for speed, with a specific focus on the collection pages. Key Requirements: - The site needs to pass the Core Web Vitals assessment, ensuring a good user experience. - The selected freelancer should be able to identify and resolve issues that are slowing down the site. Prior Experience: - Experience in optimizing Shopify websites for speed. - Familiarity with Google PageSpeed Insights and its recommendations. Please provide details of your experience with similar projects when bidding.
I am looking for an experienced freelancer who can support my B2B business in crafting and managing LinkedIn pos...posts. - Creation and dissemination of custom offers via MailChimp E-Shots. - Providing graphic design for both LinkedIn posts and E-Shots. Ideal Skills and Experience: - Proficiency in LinkedIn and MailChimp platforms. - Experience in B2B Social Media Marketing. - Knowledge in creating custom offers suitable for B2B businesses. - Expertise in graphic design. - Proven ability to manage and optimize LinkedIn posts and MailChimp E-Shots. I'm ideally searching for a freelancer who appreciates the importance of custom offers and can manifest this in both LinkedIn posts and E-Shots. If you have a knack for both social media marketing and graphic design, I'd lo...
