Pivot tables combining data from multiple columns punët

akdfjkajdfpadjfkpadkfjapdkfjadkfjapdfkjapdighgpihepjgg

...performance by today's internet standards (loading within 3 seconds) The site will not have 3D animations or videos. Authentication We use JWT for user authentication and authorization. ❌WHAT YOU DON'T NEED TO DO NodeJs BackEnd Development • It is not necessary to develop the backend in NodeJs. We have our own developers Connection to the database • No need to develop database structure such as tables or MySQL connections Server • It is not necessary to develop or structure any cloud configuration for BackEnd, FrontEnd server UI/UX Design • There is no need to develop the design. We have the layout of each page in Figma, with the necessary structure for development. • Style Guide: Color palette, typography, spacing, and standard visual c...

I have a PDF...following: - Organization: Calls, texts, and data should be separated into distinct columns in the spreadsheet. - Data Layout: The information should be laid out in an ordered manner which we will discuss further. Additional requirements include: - Calculations: The Excel sheet should include specific calculations like total call duration and data used. - Data Fields: The "To/From", "City", and "Time" fields should be organized in distinct columns within the spreadsheet. Ideally, I'm looking for a freelancer with: - Proficiency in PDF to Excel conversion. - Strong organizational and data handling skills. - Experience with creating automated Excel solutions for call logs. Given the...

...with a clean, straightforward design. Key Requirements: - Experience in designing minimalist logos - Knowledge of color psychology, particularly in using 2-3 colors for optimization. - A portfolio of previous brand identity work - Strong communication and understanding of design briefs Project Specifics: - The logo will be used primarily for the web and print. - It should be delivered in multiple formats suitable for these mediums. - It should convey professionalism and credibility. - I'd like to see some initial drafts, receive feedback, and have room for revisions if necessary. - Please use a combination of these colors and no others: #B5C2C8, #3E515D, #5CBCC3, #C29117 - The company name is Membership Fix. - The logo should capture the concept of community without us...

I am looking for someone skilled in photo editing to eliminate certain individuals from my group photos. This task requires a careful and thoughtful touch to ensure that the final product looks authentic and unaffected. The People to be Removed: - Ex-partners - Ex-friends The Photos: - Group photos Ideal skills and experience include: - Advanced proficiency in photo editing software - Attention to detail - Experience with removing people from complex images - Demonstrated ability to maintain the integrity of photos after editing.

I am in need of a proficient data analyst who can handle multilingual data analysis in English, Spanish, and French. The project aims to provide insights into the logistics and business operations of several industries including Healthcare, Retail, Manufacturing, and Education. Key Tasks: - Data Cleaning and Preprocessing: Efficiently handle large datasets in multiple languages for optimal data quality. - Descriptive Analytics and Reporting: Create insightful reports on the logistics and business data in a clear, concise and actionable manner. - Predictive Modeling and Forecasting: Utilize predictive analytics to forecast future trends and make informed strategic decisions. Ideal Candidate: The ideal candidate should possess: - Proven experience ...

I need two outdoor cooking tables based on the document specs provided. I am looking for scaled, cad drawings that can be given to the custom carpenters

...professional who can help me tackle a variety of issues. I need several files repaired and converted to SVG format. The files in question span across icons, images, and phrases, and have issues such as pixelation, blurriness, and distortion. These files will primarily be used on my website. Key responsibilities include: - Identifying and rectifying pixelation, blurriness and distortion issues in multiple icons, images, and phrases - Converting these files to high-quality SVG format - Ensuring the repaired and converted files are suitable for website use Ideal candidates should have: - Proficiency in repairing and converting a variety of file types - Experience in dealing with pixelation, blurriness, and distortion issues - Knowledge of SVG format, and its specific requirements ...

...widgets for our current dashboard in Sisense. Requirements: - Creation of specific widgets: Charts, Tables - Charts: Line charts, Bar charts, Pie charts - Tables: Data tables, Summary tables, Pivot tables These widgets will a show the following: - Top ten Selling Items (# units sold and $) - Upsells (# units sold and % of overall sales) - Modifiers (# units sold and % of overall sales) - Daily specials ($ sold and % of overall sales) The ideal candidate should have: - Proven experience in developing widgets for Sisense - Proficiency in creating various types of charts - Strong understanding of data table structures - Ability to design and implement effective summary and pivot tables I'm looking for a com...

I am seeking a skilled freelancer to find popular influencers across multiple social media platforms including Instagram, YouTube, TikTok, Gettr, Truth, Facebook, and Rumble. Requirements: - Experience in social media marketing and influencer outreach. - Ability to categorize influencers by follower count and engagement rate. Main Tasks: - Identify influencers across stated platforms - Categorize them based on follower count and engagement rate Application: Please share examples of your past work related to influencer discovery or social media marketing. Highlight any specifically relevant experience for this project. By recognizing your ability to successfully deliver this project, through past work examples, I can feel confident that my project is in competent hands.

...collection reports, provides inventory management, and includes customer data analysis. The dashboard should be accessible via web browsers and mobile devices. Key Features 1. Sales Reports o Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data Source: Multiple MS SQL databases. 2. Collection Reports o Daily Receipt Report: Display daily receipt data with graphs. o Monthly Receipt Report: Display monthly receipt data with graphs. o Annual Receipt Report: Display annual receipt data with graphical representation. o Data Sour...

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attentio...

...expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and the other with full access for any required changes. **Requirements:** **Tab 1: Welcome & Data Collection** *Design and User Interface:* - Create an inviting and user-friendly interface that reflects our professional standards, incorporating the company logo colours (blue, white, grey). - Ensure intuitive navigation and seamless data entry for clie...

...o Line from bottom of ID text to midpoint on edge of triangle o Default alignment has the bottom line of text aligned to 5% above the bottom corner of the triangle  Orthogonal rotation • Text moves away from triangle. Minimum distance 1/64” between edge of block and edge of text • Grip allows for rotation from perpendicular  Stretch-able location of cable ID • Grip at insertion point of ID text • When the grip moves away from the default location o Line between symbol and text becomes visible o Line around text becomes visible  Automatic overlap protection • ID attributes shift if necessary to avoid overlap with other ID attributes. o 0 up o 180 down o 90 left / up (text looks like multiple lines) o 270 right / down (t...

...domain names, phone numbers, trademarks, and social media handles. Additionally, it should search for the mentions of the given words or phrases in Google organic search and various shopping sites. Note that some of these sites may not have APIs available to perform these checks. Ideal Skills and Experience: - Proficient in Web Development: The tool needs to be designed to perform these checks on multiple platforms in a seamless and efficient way. - Familiar with SEO and E-commerce: The ability to accurately identify mentions of the given words or phrases in Google organic search and shopping sites is crucial. - Experience with API Integration: Being able to integrate with various social media platforms like Facebook, Twitter, Instagram, Reddit, and Youtube for handle availabil...

I'm seeking an expert who can create multiple Quora accounts for the purpose of promoting a product or service. Key Requirements: - You will be responsible for creating multiple Quora accounts. - These accounts should be believable and not easily flagged as spam. - The content on these accounts should be related to the product/service that will be promoted. Ideal Skills and Experience: - Proficiency in creating and managing multiple social media accounts. - Understanding of Quora's policies and guidelines. - Experience with product promotion and marketing on social media platforms is a plus.

I'm experiencing multiple performance issues with my WordPress site hosted on a Virtual Private Server (VPS), which has plenty of resources (8 vCPU / 12GB of RAM, SSD). The problems include: - Consistently slow loading times on the front end - High server CPU usage, which I suspect is leading to the slow loading times - Database connection errors - Posts in the backend are taking a considerable amount of time to load I haven't made any recent changes to the site, such as installing new plugins or updating the theme, which could have caused these issues. I need a skilled professional who can dig into these issues and improve the overall performance of my site. Ideal skills and experience for this job include: - Extensive experience with WordPress - Proficiency in optimi...

I'm looking for a professional who can extract specific text content from a website and organize it into different categories.

I am looking for a Jinja2 frontend developer to convert our simple Figma design files into Jinja2 files. This wor...implement into our site. Key Responsibilities: - Translate Figma design files into Jinja2 web templates. - Ensure the templates are well-structured, clean and easy to implement. - Implement basic functionality like navigation bars, forms, and image sliders. Ideal Skills: - Proficient in Jinja2 templating language. - Strong experience in frontend development. - Familiarity with implementing designs from Figma. - Ability to work collaboratively with our in-house frontend developer. This project is straightforward as the design is simple with just a few pages. The successful freelancer will play a crucial role in setting the foundation for the implementation of our ne...

Create a Google Sheets system for managing alcohol inventory. Includes columns for Brand, Name, Number of bottles, Country, Rating. Dropdown for rating (1-10). Show stats: unique bottles, total bottles, countries. whit a front page where i can insert the above items, and get under a reading of stats.

I'm in need of a skilled Swift Engineer to work on a variety of projects with me on a long-term basis. Your primary tasks will be centred around mobile app development, particularly for iOS devices, and will...EST time for at least 3 - 5 hours The apps created will have a diverse range of functionalities, including user authentication, push notifications, and in-app purchases. They will cater to a broad audience, ranging from the general public to business professionals. The ideal candidate for this position will have: - Proven experience in Swift programming and iOS app development - Proficiency in using XCode and submitting apps to the App Store - A good understanding of user authentication and in-app purchases - Strong communication skills to collaborate effectively on ...

...program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that...

I'm seeking a Flutter developer to create a quiz app that's compatible with both iOS and Android. Key Features: - Register with Google and Facebook - Category list - Leaderboard - Quiz screens - Quiz results - Profile and settings pages The app will be centered around multiple choice questions quizzes. Skills Required: - Proficiency in Flutter - Experience with integrating social media registration (specifically Facebook) - API integration capabilities - Familiarity with quiz app development - Ability to implement a clean, user-friendly UI for the mentioned pages Interested freelancers should be able to work efficiently and provide a polished final product. Please share your relevant past work for consideration.

I have a 120MB JSON file with nested objects, and I am in need of a skilled professi...JSON file with nested objects, and I am in need of a skilled professional who can convert this data into a CSV format. Specifically, I require the following: - The nested JSON objects should be flattened into single columns in the CSV. - The column headers in the CSV should match the keys in the JSON file. The ideal candidate for this job should have: - Proficiency in handling JSON and CSV data structures. - Experience in working with nested JSON objects and flattening them. - Ability to accurately map JSON keys to CSV column headers. If you've successfully converted complex JSON files into CSVs before and you're confident in your ability to deliver clean, well-structure...

...o Line from bottom of ID text to midpoint on edge of triangle o Default alignment has the bottom line of text aligned to 5% above the bottom corner of the triangle  Orthogonal rotation • Text moves away from triangle. Minimum distance 1/64” between edge of block and edge of text • Grip allows for rotation from perpendicular  Stretch-able location of cable ID • Grip at insertion point of ID text • When the grip moves away from the default location o Line between symbol and text becomes visible o Line around text becomes visible  Automatic overlap protection • ID attributes shift if necessary to avoid overlap with other ID attributes. o 0 up o 180 down o 90 left / up (text looks like multiple lines) o 270 right / down (...

...are currently in need of a seasoned and results-oriented freelance Project Manager. In this role, you'll be the cornerstone of our client engagement process, responsible for leveraging your extensive experience in marketing projects to manage and assist in sales improvement. Key Responsibilities: - Attend Zoom calls with clients to meticulously understand their needs and requirements. - Act as a pivot in the client engagement process, effectively promoting our services to close deals. - Utilize your expert knowledge and experience in marketing projects to drive sales. Key Requirements: - Previous experience managing marketing projects is essential. - Exceptional communication skills, specifically through Zoom calling. - Proven track record in driving sales and revenue grow...

looking for an expert in video analytics to help with a live stream volume calculation project for inventory management. Key Requirements: - Utilizing video analytics to calculate and track volume - Developing a system to process live streaming video feeds - Find volume of a dirt pile using multiple fixed cameras and any other needed sensors in .NET core C#. Examples of apps already built - URC Ventures Stockpile Reports Lite iPhone app; ; Use openly available camera appliances so we shall be independent of any specialty vendors. Please provide testing procedures and testing tools in simulated conditions. If some 3rd party tools are used, our pre-approval, source codes and unlimited licenses be included, meeting

I'm looking for a skilled photo editor who can remove six palm trees from an image and fill in the space to make it appear as if they were never there. The aim is to blend the background seamlessly. Retaining high detail in the remaining parts of the picture is critical. Your expertise in photo manipulation and detail-enhancement will be a great fit for this job. High-level proficiency in using photo editing tools such as Adobe Photoshop or GIMP is essential. Strong attention to detail is also key to ensuring the picture maintains its natural look. If resolution can be increased, that is a plus. Keeping the cost down is important.

I'm looking for a professional who can convert my PDF document to an editable Word document, ensuring that the layout, font styles, tables, images, and page numbering are all maintained. Key Requirements: - Preserving font styles and formatting: It's important that the text in the Word document appears exactly as it does in the PDF. - Keeping tables and images intact: The tables and images should be accurately reproduced and remain in their original positions. - Maintaining page numbering and headers/footers: The Word document should mirror the PDF in terms of its pagination and any header or footer content. Evaluation: - Accuracy of text conversion: I will compare the text of the original PDF with the Word document to ensure that there are no errors or om...

I'm in need of someone to take the following designs and redraw them using photoshop or illustrator. It's a straightforward design. * Key Skills: 1. Graphic design 2. Logo design 3. Creative direction * Ideal Experience: 1. Have previously redesigned logos. 2. Experience in creating intricate logos. 3. Understanding of color psychology would be advantageous. Remember, I'm not necessarily out to recreate the wheel here, but I'm definitely looking for a more refined, sophisticated look.

...on my existing website. Currently, my site only supports PayPal and I want to add another layer of customer convenience by allowing bank transfers. I need to be able to sell theater tickets, so an interactive sitting map should be available. While I haven’t decided yet on a specific bank or service for processing these transactions, I am open to suggestions. If you have prior experience with multiple processors, that would be a significant advantage. Ideal skills and experience: - Proven background in E-commerce website development - Knowledge of various payment processors - Understanding of safe and secure payment gateways - Ability to integrate new payment methods without disruption of site performance Please base your bid on your desired compensation for setting u...

I'm looking to have a brand logo designed for my homemade sweets and savory store called Gostosuras. The ideal logo should be minimalist, combining both text and icon elements. I envision a clean, modern design with a neutral color scheme to represent my brand. Key Requirements: - Minimalist design - Combination of text and icon - Neutral color scheme Ideal Skills and Experience: - Proven experience in creating minimalist brand logos - Strong understanding of color theory and how to use a neutral color palette effectively - Ability to balance text and icon elements in a way that is visually appealing and memorable - A portfolio demonstrating work on similar projects would be a big plus. Please ensure your bid includes: - Estimated timeline for completion - Any additional s...

We have Andorid TV app built in OS 9 chipmunkband seem to have problem working in Andorid boxes 10 and 11 but work on phone no problem and So we think we may need to upgrade gradle and some depencies Also we need package changed so the upgrade is done it will installed and not conflict with exsisting apps that are same Build .so os will see as a different app Attached are two soure codes similar

I need a professional to set up an automated workflow system using Zapier for my WordPress site. The system should: - Allow me to easily upload PDF documents for conversion - Automatically create AI optimized SEO article based on the document text - Categorize the extracted content into predefined sections - Generate a structured post on my WordPress ...should: - Allow me to easily upload PDF documents for conversion - Automatically create AI optimized SEO article based on the document text - Categorize the extracted content into predefined sections - Generate a structured post on my WordPress site based on the categorized content. Ideal Skills: - Proficient in Zapier and WordPress - Experience in creating automated workflows - Knowledgeable in data extraction and categorization ...

Develop a chatbot with a web chat interface using the Llama 2 7bn LLM model to assist users in resetting their passwords. The chatbot will interact with users to collect...of cell number) through a structured conversation. The system will validate user inputs against an API and terminate the conversation after three invalid attempts. Upon successful verification, a text message with the new password will be sent via an external API. The project will include creating APIs for future speech input/output integration, ensure response times under 1.5 seconds, handle multiple simultaneous users with unique identifiers, and provide customizable response messages. The system will be deployed on google cloud in a Docker container, written in Python, and include comprehensive logging and docu...

I am looking for a skilled professional who can take the content of my PDF book and make automations it into multiple SEO articles that will get automated post on Wordpress. These articles should be approximately 1500 words each, and should be generated automatically. Key requirements: - Understand SEO principles: The generated articles should be optimized for search engines, with appropriate keyword usage and content structures. - Automation skills: You should have experience with tools like Make or similar AI-powered software to automate the article generation process. - Attention to detail: The content should maintain the integrity of the original material, ensuring a high standard of readability and coherence. I am looking to generate several articles, so please let me know ho...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of t...

...access of large files: The miniGFS should handle large data quantities seamlessly, allowing both read and write operations swiftly. - Data replication and fault tolerance: This project prioritizes data integrity and availability, necessitating a system designed for data replication and recovery in the occurrence of a fault. - Parallel processing: Optimum speed during file operations can be achieved through parallel processing functionality and the miniGFS should capitalize on this. - Data distribution across multiple nodes: To ensure efficient space use and increase speed, data distribution across various system nodes is crucial. - System redundancy: In case of any systemic failures, the system should have a fallback mechanism where ...

...be a combination of a Zigzag indicator and a Pivot indicator, which can be tailored based on my specific requirements and trading rules. Key Features: - Custom Zigzag Indicator: The indicator should be able to identify the various price swings in the forex market in a zigzag pattern. - Pivot Indicator: It should also be able to calculate and mark pivot points based on the price action. - Customizable: The indicator should be flexible and adjustable to my specific trading strategies and preferences. - User-Friendly: It should be easy to use and understand for a trader, with clear visual markers and alerts. Skills and Experience: - Proficient in TradingView's Pine Script language. - Strong understanding of forex market dynamics, including pivot points an...

I am in need of a professional and experienced developer to create an e-commerce website that enables online sales. Key Requirements: - Develop a user-friendly e-commerce platform on Wix - Implement product search/filtering functionality to help users navigate the site - Set up multiple payment options to facilitate seamless transactions - Integrate inventory management for efficient stock control The ideal candidate should have prior experience in e-commerce website development, particularly with Wix. Your understanding of e-commerce best practices and willingness to take my requirements into careful consideration will be highly valued.

We want to extract members from one Facebook group which contains about 24.000 members. We don´t know if this is possible or not. We want to create a group and invite all these members to them.

Logo Design Needed for Wholesale Company "KoopTop" Description: We are KoopTop, a wholesale company based in the Nether...Requirements: The logo should include the company name "KoopTop". The design should be modern, clean, and professional. It should be versatile and work well on different platforms (website, business cards, packaging, etc.). Preferably incorporate elements that convey trust, reliability, and the wholesale industry. Deliverables: A high-resolution logo in both color and black & white. Files in multiple formats (AI, EPS, PNG, JPG). A favicon version for the website. To Apply: Please provide a portfolio of your previous logo designs and a brief description of your design approach. If you have any questions, feel free to ask. We look forw...

I'm in need of a professional who can transform my existing plans into a detailed HMO layout. This task involves creating comprehensive floor plans, incorporating both provided specifications and your own recommendations. Key Responsibilities: - Translate the existing plans into an HMO layout - Suggest and incorporate furniture and fixtures - Ensure the layout is detailed and accurate - Combine provided specifications with your own recommendations Ideal Skills and Experience: - Proficient in floor plan creation - Experience in designing HMO layouts - Able to accurately interpret specifications - Good eye for detail, with a focus on accuracy - Strong communication skills, particularly in providing recommendations based on requirements

Hello, I have a webpage ready designed. And a wordpress template to create the site. I need someone to put it together. And some help with finishing it. Also I need Elementer installed and cms.

I need a skilled logo designer to create a unique, eye-catching logo for my music brand called 'Mazzter'. This brand represents multiple music genres, but quality is our top priority. - The logo should represent the diversity of the music genre yet maintaining a common thread of quality. - Please incorporate the color purple into the design, as it is closely associated with the brand image I want to create. The ideal freelancer for this project should have: - Proven experience in logo design and brand development - Excellent color theory knowledge, especially with the color purple - Ability to interpret and express music genre diversity through visual design.

I am seeking a land designer who can expertly translate my vision of a new city on 1.75 Million sqm (1,750,000) land into commercial, residential, logistic and industrial zones and development into a detailed plan. The key aspect of this design will be combining community such as retail spaces and should be based on a modern architectural style, renewable energy and sustainable energy. The land is square with one neighbor and three major 50 meters roads. Here's what I expect: - Innovative and modern architectural design for land spaces that stand out while aligning with industry standards and regulations. - Strategically layout of the spaces to maximize foot traffic, consumer convenience, and overall operational efficiency. - Show a clear understanding of commercial, industr...

...messages and monetary contributions. Adding a monetary contribution prioritizes and highlights their comments/messages. Brand Name: FamPe "Fam" is a keyword used by influencers to refer to their fans because it creates a sense of closeness and community. This platform enables fans to contribute (monetary contribution) to their influencers, especially in Live Streams. That's where the name FamPe comes from. Brand Values:- - Innovation - Reliability - Efficiency - User-Friendly Logo Style Preferences:- - Audience: YouTube streamers and viewers, ages 15-45, worldwide demographic - Type: Wordmark logo, modern and minimalist - Feel: Exclusive, Professional, trustworthy, cutting-edge - Color Palette: Primary: #EC6A5E, #5156D4, Accent: #EC6A5E (given color palette is p...

I'm seeking a professional interior designer to help me revamp my living room, kitchen, and bedroom into a traditional/modern style. Key Requirements: - Proven experience with residential interior design - Strong portfolio showcasing traditional design aesthetics - Knowledge of creating cohesive designs across multiple rooms You should be able to: - Understand my vision and translate it into a traditional style - Recommend and source appropriate furniture and decor - Create a design that is both aesthetically pleasing and functional.

I am in search of a talented designer who can navigate through a few uncertainties. Unfortunately, I skipped some essential questions, leaving some ambiguity in specific aspects of the project. Your job: - Adaptable enough to handle logo, brochure, or flyer design since the service needed wasn't defined - Skilled at multiple graphic design styles because a specific theme wasn't selected - Able to derive the best decisions for the goals of the project as the purpose wasn't specified Skills & Experience: - Proficient in modern, vintage, and minimalistic design styles - Experience with brand identity, marketing, and informational designs is a plus - Problem-solving ability and creativity to fill in the information gaps This project presents an exciting challeng...

...2. just don't want to do it. The option to take photos offsite is acceptable. This person should be able to capture the essence of a diverse range of products, including jewelry, handbags, accessories, and clothing. Key Requirements: - Prior experience in commercial product photography, particularly with accessories and clothing. - Ability to showcase intricate product details, and capture multiple angles. - Thinking outside the box - the knack for creating truly original and eye-catching photos - Understanding of the purpose of the images - they are intended to be displayed on my store website. The ideal freelancer will have a keen eye for detail and an awesome creative streak. This person will have a portfolio demonstrating their technical ability and aesthetic sense. ...