Sql data matchcông việc

We're seeking a Shopify whiz to launch our next big product! Do you: Find hot-selling products for Shopify? Source top-notch suppliers? Craft ROI-crushing marketing plans? If so, you're our perfect match! I am planning to establish a new Shopify store that will principally sell physical products. The goal is to capture a specific geographic and demographic market segment. Tasks include: - Building an intuitive and captivating Shopify store from scratch. - Sourcing high-quality physical products. - Conducting market research to discover winning products fitting our demographic and geographic target. - Implementing effective sales-driving strategies and ROI-driven marketing tactics to elevate the store's profitability. Ideal skills for the job: - Proven experience...

I need a professional who can skillfully manipulate a PDF document for me. The project involves deleting an unspecified chunk of text and replacing it with text sourced from a different PDF document. Some particulars: - You may not need to match the original format and style. Infusing a different style is acceptable. - Showcasing past work involving similar tasks in your application will place you at an advantage. - I appreciate accuracy, attention to detail, and promptness in delivery. Ideal Skills: - Proficiency in Acrobat Adobe or other PDF editing tools. - Exceptional attention to detail. - Demonstrable past experience in similar tasks. - Strong command of languages, especially the language used in the PDF. - Effective communication skills to clarify any ambiguous aspects of...

I need a skilled graphic designer to create two minimalistic and modern logos for our transport company. These logos will be used to rebrand our fleet of trucks and should harmoniously match our existing branding colors. Additional to the logos, a modern banner design is also required. This banner should feature our logo, as well as a basic map of Europe outlining the countries our company services. Prospective freelancers should be able to demonstrate a strong portfolio of minimalistic and modern design. Expertise in branding and vector graphics will be highly regarded.

...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill task tests. Please send your details for the below-mentioned questions. 1. What typ...

Wealth recovery website with contact form. This website will contain the following details: ** Please see design idea in attached file. Please use for ideas but I would like the site to be better. ** Site should match the green in the logo provided. ** All details and content within attached files ** All images should be over happy people with money, money, and a picture of money on a table with a person walking away. - Index Page - Faqs Page - Terms and Conditions Page - Contact Form ** Responsive design for PC, Tablet, and mobile phone I'd greatly appreciate a design that leans more towards a clean and professional theme. The interface must be user-friendly and easy to navigate. Freelancers vying for this project should have experience in web design and graphics. Proficie...

...dynamic and colorful application for both iOS and Android platforms. This project will require you to incorporate features such as: 1. Creating Teams: Users should have the ability to assemble and manage their own teams. 2. Making Contests: Users should be able to create and participate in contests. 3. Financial Transactions: The app should facilitate the addition and withdrawal of money. 4. Live Match Updates: Keeping users updated with live feeds and scoring is crucial. 5. Social Media Integration: I'd love for the app to have seamless social media networking functions so users can share their successes and experiences. To ensure a smooth flow of the entire application, the design needs to be uncluttered yet visually appealing, and entirely bug-free. The application must...

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

I'm seeking a highly experienced consultant specializing in Canadian nutrition facts label...other relevant files/attachments - Identify ingredient databases/and other pertinent files for usage in our SQL Database by our in-house software engineers Ideal Candidate Skills: - Strong grasp on Canadian food labeling regulations - Proven record in nutrient analysis - Packaging design expertise. - Prior experience in building similar Ingredient analysis software/tools, have an understanding of data structures, especially in Chinese nutritional content, and would be exceptional at updated nutrition regulations, allergens, and Nutrition Facts label specifications as stipulated by Canadian Food Regulatory Authority - A very detailed SOW available, if you're the per...

...comprehensive library of ingredients and their nutritional values is crucial for effective operation. Previous experience building or consulting, specifically Chinese Nutrition Facts label and ingredient databases, is a must. - Ingredient Databases: Must provide Chinese Ingredient Databases and other relevant files/attachments - Identify ingredient databases/and other pertinent files for usage in our SQL Database by our in-house software engineers - Recipe Analysis: The ability to break down Chinese nutritional content into their constituent parts and analyze and present information in an easily digestible way. A background in developing similar functionalities is preferred. - Customizable Labels: A key feature of this project is the ability to generate fully customizable nu...

I'm in need of a skilled graphic designer to modernize my brand's logo by changing its color to white. The main reason for this change is to better match my website's theme and increase its visibility. There is no strict deadline for this project, offering flexibility for the right creative expert. The ideal person for the job would possess: - Profound understanding of color psychology in branding - Mastery of graphic design software - Exceptional attention to details - Experience in brand modernization

...primarily for individual customers who are utilizing our skincare products. The app needs to have the following features: - A communication channel where users can reach out to us about their skincare queries and feedback. - An image upload function for users to share their skin conditions/treatment progress. - An algorithm or system to make product recommendations and skincare tips that match the users' data and input. Freelancers bidding on this project ideally should have: - Experience in image processing or familiarity working with similar apps. - Strong background in e-commerce app development. - An understanding or interest in skincare, though not mandatory, would be a plus. - Excellent communication skills. - Detail-oriented mindset and able to manage ...

want an eccommerce banner with matching logo. The logo is for an eccomerce store which sales all sorts of items such as amazon and ebay. The logo and banner must match the colors in this template image attachemnt included here. Logo and banner should have the name . -Pease no Amazon logo -No shopping cart -No shopping bag

...Tool Relocation" - Our custom search tool currently resides somewhere else on the site. The task requires it to be relocated to the search page. - The preferred position is as a separate search bar at the top of the page. 2. "Add to Cart Icon Redisplay" - I would like the "Add to Cart" icon to maintain its current display style from the previous Venture theme. However, it should also match the aesthetics of the new Ride theme. - The location for the "Add to Cart" icon needs to be below the product description in the product blocks. Ideal Candidate Skill Set: - Extensive Shopify development experience, particularly with Venture and Ride themes, is essential. - Ability to seamlessly relocate and redesign features within a Shopify s...

I'm seeking a freelancer with expertise in job portal integration. S...should have proven past experience in job portal integration. In your application, provide details of similar projects you have worked on, this will enhance your chances of winning the bid. For this integration, proficiency in Node is required as it's the primary language preference for this project. A strong understanding of how various job portals operate and their APIs needed. Intellegent match of job to resumes, resume harvesting needed Required Skills: - Job Portal Integration - Node - Familiarity with Dice, Monster, and Hotjobs APIs - Resume retrieval techniques - Excellent problem-solving skills - Attention to detail Looking forward to receiving your entries and excited to start working with ...

I am in need of a seasoned expert in web and database development focusing on creating an efficient database structure and developing both backend and frontend functionality. and i want know just what to use for this project and only consultant Key Responsibilities: - Design and structure a NoSQL and sql database - Develop back and front end functionality using JavaScript with Node.js Ideal Skills: - Extensive experience in NoSQL and sql database structuring - Proficiency in JavaScript and Node.js - Ability to make informed suggestions on database and language use - Hands-on experience in Website design would be an added advantage Your goal will be to provide robust, secure and efficient database support to my website's functionality. Suggestions on improvement ar...

More details: Is this project for business or personal use? For starting a new enterprise What information should successful freelancers include in their application? Experience How soon do you need your project completed? Within a month I need a dating App developed for Android at least. This is for two separate groups with characteristics that may match but I want to control the when they can meet without giving there contact information at first. They can interact but i can only approve the meeting. It will not be stereotypical dating app. It isn't for dates, it is more for social interactions. I would like a spot to post pictures, too and a chat feature.

...descriptions from screen shot - use any design layout you like as long as they match up to the specific sizes above Color Scheme: - Apply a color scheme that ties in with the flag colours — black, white, and grey, yellow, red, green, royal blue and light blue. In terms of skills, experience in designing for large scale prints and understanding of branding are desired. Should have an eye for detail ensuring all our design requirements are met. Note: I'll provide the branding elements, but ensure you bring your creativity to the project. screenshot - please use text from screenshot example and include flags adobe stock image - please use this image or similar. - must be wine related. Company logo - please include logo and match writing to the font used on th...

...looking for a skilled graphic designer to inject new life into my existing book cover design. The areas that need attention are: - Colors: The current color scheme needs a complete makeover. I want to transition to warm colors such as red, yellow, and orange that can instantly catch attention and evoke a strong emotional response. - Images: I also want the images on the cover to be enhanced to match the new vibrant color palette. -- I have a picture I would like to use. Replace the original design but keep Michelangelos hands in there -- The title and other book description as is -- wrap around cover and I would need it back in JPG and PDF for paperback (Amazon dimensions) Ideal Skills & Experience: - A strong background in graphic design, particularly in cre...

As an ambitious entrepreneur, I need a competent marketer to inc...strategies for my new company www.mystiquevibe.com. The main tasks include: - Devising a robust SEO strategy to improve my website's search engine rankings. - Exploiting Facebook, Twitter, and Instagram to enhance the visibility of my brand. - Collaborating with micro-influencers to extend our reach to millennials, parents, and business professionals who form our target audience. The perfect match for this job will have a solid background in SEO and social media marketing, influencer collaboration, and targeting varied demographic profiles. I eagerly welcome proposals that showcase these skills and experience. I need some one who can help me scale from 0-10,000 visitors per month and has experience in US mark...

I need a proficient Microsoft Access developer to assist in upgrading my database from Access 95 to Access 2010. Key Tasks: - Database upgrade - Query optimization; to ensure optimal performance of the updated database. - Design forms and reports; to match our specific business needs. Ideal Skills: - Previous experience in upgrading old versions of Microsoft Access databases. - Proficient in database management and query optimization. - Understanding in designing Access forms and reports. Hands-on experience and a proven record in handling similar tasks would be a major asset.

I require a skilled graphic designer to revamp my current roll-up design. My project is strongly rooted in the automotive sector, with active influences from the YouTube community, ...images of cars, my logo, and my social media icons - Display of my Car YouTuber name prominently Ideal skills and experience: - Exceptional graphic design capability - Prior experience in the automotive sector - Understanding of YouTube culture and iconography - Excellent grasping of color schemes and branding - Experience in working with social media branding, inclusive of logos and icons. Has to match the template includet, you delivery in photoshop PSD and PDF! Files here: :u:/g/personal/thomas_flybycompany_dk/EYgmkjKfxnNOpQHI2DBL-XsBZAVZj59KF_qVbyGSYGnADA?e=JqdW8x

I need a talented designer to create an informational website that is targeted towards the general public. The site should have a professional and corporate visual style. The project also involves designing a logo, which should match the overall aesthetics of the website. The Website needs to incorporate all Marketing tools and plug ins to reach maximum lead generation and reach. The Website is for an Office / Shop Fitout Company based in New South Wales, Australia. Ideal skills and experience: - Proven experience in both website and logo design - Familiarity with corporate and professional design aesthetics - Experience in creating informational websites - Understanding of effective design for the general public. Your portfolio showing similar projects would be highly appreciate...

I'm in need of a logo for my business Daily Green, which operates within the food and beverage industry. Our primary need is a design that can effectively communicate a feeling of healthiness and freshness. Ideal candidates for this job would have: * Previous work with branding in the food and beverag...which operates within the food and beverage industry. Our primary need is a design that can effectively communicate a feeling of healthiness and freshness. Ideal candidates for this job would have: * Previous work with branding in the food and beverage industry * An understanding of design principles that convey freshness and health * A portfolio demonstrating their ability to create logos that match the desired feeling. Please include relevant examples of your past work in...

...and implementation of a dark theme option for enhanced user experience. **Features:** 1. **Live Scores and Match Updates:** - Users can access live scores and match updates in real-time, including detailed scorecards, match statistics, and player performances. - The website will fetch live score data from reputable sources like and , ensuring accuracy and reliability. 2. **News Section:** - A dedicated news section will provide the latest articles covering cricket events, player insights, team updates, and match analysis. - Content will be categorized for easy navigation and exploration, enhancing user engagement and satisfaction. 3. **Match Schedule:** - Users can view a comprehensive schedule of upcoming matches, including ...

...be provided upon hiring. 2- User Authentication System Improvement: A key aspect of your role will be to upgrade our current user authentication system. This includes implementing more secure signup/login processes, utilizing the latest best practices for data security, encryption, and ensuring a seamless user experience. 3- Database Integration and Optimization: Your duties also entail the integration and optimization of the back-end database. Proficiency in database architecture and SQL is crucial, with an emphasis on enhancing data retrieval and storage processes to support the new features and authentication improvements. 4- Ideal candidates will possess a strong background in developing e-commerce systems, with a keen eye for creating intuitive user interfac...

...be provided upon hiring. 2- User Authentication System Improvement: A key aspect of your role will be to upgrade our current user authentication system. This includes implementing more secure signup/login processes, utilizing the latest best practices for data security, encryption, and ensuring a seamless user experience. 3- Database Integration and Optimization: Your duties also entail the integration and optimization of the back-end database. Proficiency in database architecture and SQL is crucial, with an emphasis on enhancing data retrieval and storage processes to support the new features and authentication improvements. 4- Ideal candidates will possess a strong background in developing e-commerce systems, with a keen eye for creating intuitive user interfac...

...this so that address line 2 accurately displays the address information. Improved Search Logic: Enhance the search logic to better match user expectations. When a user searches for a business, they might include both business name/category and address information in their query. We need to search for the business name/category in their respective fields and the address information in both address line 1 and address line 2. One suggested approach is to split the search query at the occurrence of the word "in": Search the part before "in" in business name and category. Search the part after "in" in address lines 1 and 2. Only display results where both parts match accordingly. Firestore Notification Integration: We need to integrate Firestore...

...include: - Commercial Length: Less than 30 seconds. You'll receive all the necessary materials and context to perform your task effectively. - Language and Style: The voice-over must be in an Azerbaijani regional accent. You should carry a convincing Azerbaijani dialect to reflect authenticity. - Gender Preference: The voice-over artist needs to be female. Your pitch, tone, and expressiveness should match the original voice tone in the English version. Ideal Candidate: You should possess solid experience in voice-overs, ideally in the Azerbaijani language and must be competent in maintaining the flow, tone and nuances of the original English commercial. Send your voice samples along with your bid. Your cost should include the recording fee and any revisions as well. I loo...

I'm seeking a skilled app developer to create a streamlined iPad application that will intertwine with our current SQL database. The primary functionalities of the app will be customer and device check-ins. Main Features: -Customer Check-in: -Record new check-ins in our SQL database -Generate and print a ticket for every customer who checks in -Device Check-in: -Create new tickets in the database for device check-ins -Print both the ticket and a tag for the checked-in device The ideal freelancer for this project has demonstrable experience in mobile app development, specifically for iPad, with strong knowledge of SQL database integrations. A solid understanding of generating and printing tickets using software applications will be highly beneficial. ...

...description of the database. The specific responsibilities include: - Developing 3 types of queries: Data extraction, data modification, and data calculation (specific instructions will be provided after project commencement) - Creation of 2 forms: A Main and a Subform. The main form is to be designed for data entry. - Devising 2 reports based on set requirements (to be disclosed upon project initiation). - Crafting a detailed written description of the entire database system using a provided template. Ideal assistance would come from someone with proven experience in Microsoft Access, SQL, VBA, and database development. A deep understanding of query development, form creation, and ensuring data integrity within Access databases is crucial. ...

I am on the lookout for an experienced Selenium, Java, Cucumber, and Maven professional to help me solve issues wherever I am stuck, I am learning selenium for my company and want to work independently soon , so need someones help to learn it, 1. User Authentication 2. Data Validation 3. Error Handling Having a background in quality assurance and experience using behavior-driven development (BDD) framework will be the best match for this project. I am seeking assistance in ensuring all modules function as intended, and errors are adequately managed.

I'm in need of a talented individual who excels in Python and SQL, with specific experience in database administration and web scraping tasks. Tasks: - Oversee database administration, ensuring swift and accurate data storage operations - Conduct web scraping to collect crucial data Purpose: - The main focus is data storage, with a goal to develop an organized, high-performing storage system Data Type: - The database will primarily store user data Skills & Experience: - Proficient in Python & SQL - Extensive experience in database administration - Web scraping expertise - Knowledge of data storage principles - Experience handling user data.

I am searching for a seasoned Android Studio developer who is well-versed in debugging, code optimization, and SQL database manipulation. Key Tasks: - Debugging the existing codebase experiencing crashes and performance issues - Optimizing the code to improve performance - Correcting the code for accurate SQL data retrieval A perfect candidate will have following skills: - Strong experience in Android Studio - Proven track record in debugging and code optimization - Advanced SQL knowledge for efficient and correct data retrieval An example of the issues include frequent app crashes during specific user interactions and noticeable lags during database retrieval operations. Therefore, ability to replicate, understand, and fix these issues is critica...

Hi- I hope you are well! For our brand guidelines I need to add in some extra colours for new products - we have our blue, white and grey but I need a bright eye catching colour to sit along with this Please could you help me to match a colour that you feel would work? ideally not red :) other than that please let me know what you think can work for an eye catching colour to sit alongside - can you send me some options to select from please? thanks

I'm looking for a detail-oriented freelancer with excellent typing skills and a keen eye for accuracy. You will: - Convert PDF documents into another PDF format through copy-typing. - Ensure that the final document is a perfect match to the original, down to the last period and comma. Desired skills and experience: - Proven experience in copy typing, particularly with PDF formats. - Excellent English language skills to ensure accuracy in copy typing. - Strong attention to detail and ability to maintain accuracy while working. Please note that the documents you'll be working with do not contain any special characters or languages other than English. It is a straightforward, but meticulous task requiring precision and time. Your typing speed and accuracy will be key to y...

I am looking for a skilled ReactJs developer to help me finish a project that is almost finished. The project requires the implementation of UI enhancements to match the current design. Skills and experience required for the job: - Proficiency in ReactJs - Strong understanding of UI development - Experience in implementing UI enhancements to match existing designs the system was built based on a template. It is necessary to make improvements, eliminate popups, insert dashboards, graphs

I am looking for a skilled ReactJs developer to help me finish a project that is almost finished. The project requires the implementation of UI enhancements to match the current design. Skills and experience required for the job: - Proficiency in ReactJs - Strong understanding of UI development - Experience in implementing UI enhancements to match existing designs the system was built based on a template. It is necessary to make improvements, eliminate popups, insert dashboards, graphs

I'm seeking an experienced Database Developer to build a Relational Database Management System (RDBMS) with a focus on product data. The system would rely on Structured Query Language (SQL), designed to execute simple queries. Key Responsibilities: - Developing a RDBMS using SQL - Ensuring the system can manage and interpret product data effectively - Crafting and implementing simple queries within the system Ideal Experience: - SQL development - RDBMS creation and management - Experience working with product data.

Looking for a skilled video editor who can bring my 1-2 minute YouTube shorts to life. Key requirements include: - Trimming and cutting footage to keep videos crisp and engaging. - Adding relevant music and sound effects that match the vibe of these shorts. - Introducing impactful text and graphics to increase viewer retention. Ideally, the final product will be simple and clean, focusing on clear, concise messaging rather than flashy effects. Efficiency and a keen eye for detail will be appreciated. Prior experience in similar projects is a plus.

Looking for an experienced MSBI and powerbi developer. You would be working with me to troubleshoot and optimize an existing MSBI solution and powerbi report. Your tasks include but are not limited to: - Data Modeling - ETL Development - Report Development For this project, your primary tools would be: - SQL Server Integration Services (SSIS) - SQL Server Analysis Services (SSAS) - power bi Your experience and skills in these areas will be critical to the success of our project. Only serious and high-quality professionals need apply. This is a challenging role and previous experience in the given areas is a must. Let's enhance our MSBI solution together and make it the best it can be.

I need a skilled web developer to give my AI Solutions company website a fresh, professional, and corporate look. Your task involves: - Updating the site's color scheme to match our corporate colors. - Enhancing the user interface to promote easy navigation. - Incorporating new sections, specifically, 'Services' and 'Blog.' Ideal candidates should have ample Wordpress experience and exhibit an impressive knack for creating an intuitive, professional, and corporate-themed user interface. A keen eye for color schemes that complement and promote our company's brand image will be highly favored. Additionally, familiarity with PHP, HTML, CSS, and JavaScript is essential to smoothly execute this project.

I'm looking for a skilled graphic designer who can handle a variety of tasks related to my brand's visual identity. - You need a deep understanding and thriving passion for logo design, branding, and packaging design. - The intended audience is both adults and children, sugg...resonate with audiences and elevate our brand visibility. Ideal skills: 1. Proficient in Adobe Illustrator and Photoshop. 2. Previous experience in logo, branding, and packaging design. 3. Strong portfolio showcasing a diverse range of design styles. 4. Exceptional aesthetic and creative skills. 5. Keen understanding of consumer psychology, particularly for a broad demographics range. If you match these criteria, I'd love to hear from you with an example from your portfolio that you fe...

I am looking for a talented photo editor who can transform one image from a normal picture into a wintery, frosty atmosphere. This project involves changing the background, adding realistic snow effects, and enhancing colors to match a reference picture I will provide. - Ideal Skills and Experience: • Expertise in photo editing and manipulation techniques • Ability to manipulate colors accurately according to provided reference • Experience with creating snow or winter effects in images. A keen eye for detail and creative flair are a must for this project. Please include any relevant work samples in your bid.

I'm searching for a freelancer with an active Google Local Guide account to optimize my business listing. Your tasks will focus specifically on enhancing the "Services Offered" section. Key Skills & Experience: - Proficient in Google My Business - Knowledge in SEO optimization is a plus - Experience in updating and optimizing listings - Great attention to detail The best match for this project would be someone who knows their way around Google My Business and understands how to effectively utilize it to reach an audience. Your skills will directly impact the visibility of my business on Google's platforms and aid in attracting potential clients.

I'm in need of a seasoned WordPress expert to modify my existing te...transformations for better visual appeal - Color scheme modifications complementing my brand - Font alterations to enhance readability Functionality Enhancements: - Unfortunately, the specific functionality changes were unclear but I'm open to discussing them in further detail Content Updates: - Keeping in line with these design and functional changes, content updates will also be needed to match the new design. An ideal candidate would have a deep understanding of WordPress templates, a keen eye for design and detail, along with the ability to effectively communicate. They would have handled similar projects before, especially with integrating custom template changes. Please share your relevant expe...

I'm in need of an Illustrator fluent in Procreate and skilled in tracing, specifically tracing buildings. The task at hand is a simple yet important one. Key Details: - Style: I'm not looking for a new style, instead, you'd need to match my current style in the illustration. - Specifics: The key focus will be buildings, so experience rendering architecturally accurate illustrations is necessary. - Timeline: I am working on a deadline, so punctuality is of utmost importance. The completed project will need to be delivered by March 27th. Ideal skills and experiences: - Proactive and able to follow my style accurately - Proficient in Procreate software - Previous experience with architectural illustrations - Proven track record for punctual delivery This may just be t...

...their level of interaction. Ensure data security and privacy compliance in accordance with industry standards. Develop an engaging user interface that enhances user experience and encourages prolonged app usage. Conduct thorough testing and iteration to refine app functionality and address user feedback. Features: User Profiles: Users can create profiles using their Facebook accounts, simplifying the registration process. Progressive Photo Unveiling: Photos of potential matches are initially blurred, and users must engage in meaningful interactions to gradually unveil them. Swiping Mechanism: Users can swipe left or right to indicate their interest in potential matches, fostering a dynamic and intuitive user experience. Messaging: Once a mutual match is made, users c...

Hi We are looking to hire 10 Freelancers who can complete a task for us on priority. Ideally we are looking to work with an VA agency who have an in-house team and resources. Here are the ideal traits of the VA we are looking to have 1) We need to have VA's who are professionals, time commitment is something which we value a lot. 2) We need ...a task for us on priority. Ideally we are looking to work with an VA agency who have an in-house team and resources. Here are the ideal traits of the VA we are looking to have 1) We need to have VA's who are professionals, time commitment is something which we value a lot. 2) We need VA's who have good speed, if you are looking to take 5 hours to get one task done, Probably we are not a good match. Please write the word ...

I'm looking for a creative graphic...embodies a smart, knowledgeable, energetic, and enthusiastic persona. The mascot should be attractive, funny, and represent the fun side of coding. It doesn't necessarily have to be an animal, it could be any character as long as it fits the given personality traits. The coding academy's name is PY. For example, the mascot can have a "Pie" since it sounds similar to PY academy. I want the colors to match the color theme of the academy which is mainly blue and orange. I will attach the PY's logo below. Ideal skills and experience: - Experienced in character and mascot design - Able to create designs that are amusing, attractive, and engaging - Understands how to infuse personality traits into characters - Proven abi...