Most complex sql query jobs
...Investor Reporting – Provide financial reports for property owners. AI & Automation – Automate reminders, rent adjustments, and document processing. Mobile Access – A mobile app for tenants, landlords, and property managers. Integrations – Connect with third-party tools like QuickBooks, CRM, and banking APIs The software should include advanced accounting features such as detailed financial reports, complex transactions tracking, and reconciliation functionalities. The software should be primarily developed as a web-based application. The software does not need to support multiple languages. User roles and permissions should be advanced, allowing detailed customization of access levels. The software should allow intermediate customization of user role...
...include: - Regular communication via Microsoft Teams - Consistent turnaround times - A strong focus on quality and precision, with particular attention to the aesthetic appearance of the designs - Experience working with complex cases Please provide the following in your response: - Your experience with similar cases - Your standard turnaround times - Your communication process - Your pricing structure - Examples of your recent work We expect less than 50 cases per month, require the use of Exocad exclusively for our project, and prioritize Crown and bridge designs most often. The final designs should be delivered in STL files. We expect the final designs to have a standard level of industry detail. We may also need support for digital wax-ups. We prefer the completed ...
I'm seeking a seasoned SAP ABAP professional to conduct online live sessions. The target audience is beginners, so the training should start from the very basics. Ideal Skills: - Extensive experience in SAP ABAP - Proven track record of teaching - Ability to simplify complex concepts - Excellent communication skills - Proficient in conducting online live sessions Please submit your bid if you meet these qualifications and can help nurture the next generation of SAP ABAP professionals.
...Follow a predefined content framework to ensure consistency and alignment with project goals based on deadlines. ✅ Adapt writing style and tone to match different industries and audience personas. ✅ Proofread and edit content to maintain clarity, accuracy, and brand voice. Requirements: ✔ 3+ years of experience in content writing, journalism, or digital marketing. ✔ Ability to simplify complex topics and write engaging, well-researched content. ✔ Proven experience in long-form content, whitepapers, and case studies. ✔ Excellent time management and organizational skills to meet deadlines efficiently. ✔ A strong portfolio showcasing educational, informative, or research-based writing. Preferred Skills (Nice to Have): Experience with AI-assisted writing tools like Chat...
I'm looking for a professional web designer to give my website, , a contemporary yet elegant and classic look. The redesign should maintain a similar layout but with a few strategic changes for a more modern aesthetic. Key Areas for Redesign: - Homepage: This is the first point of contact for most visitors. It needs to be visually appealing and easy to navigate. - Contact Page: This page should reflect the new design style, making it user-friendly and inviting. - Product Pages: These pages need to showcase our products in an elegant and classic manner, while still being contemporary. The ideal freelancer for this project should have: - Extensive experience in web design and redesign - A strong understanding of contemporary, elegant and classic design styles - Proven ability
...Updating data must be straightforward to ensure that non-technical users can manage the updates efficiently. * Hosting: Hosted on our Squarespace site with the flexibility to move it to a standalone domain if needed. * Accessibility and Analytics: - Compliance with WCAG 2.1 or similar accessibility standards. - Analytics should capture key user interactions, such as the number of searches, most used filters, click-through rates to product detail pages, and useful visualizations, e.g. user interaction heat maps. Technical Requirements: * Frontend: Responsive framework (e.g., React.js, Vue.js). * Backend: Integration with Google Sheets or similar data source. * Hosting: Initially hosted on Squarespace, with flexibility for standalone deployment if needed. * Secu...
...adults), and the children are charged half the adult rate (treated as half an adult). But if 2 adults and 1 child in hotel C, it will applies either hotel A or B’s method. This requires understanding the different logic each hotel uses to calculate the number of occupants and their corresponding rates. ------------------- Purpose: We want customers to avoid the hassle of understanding each hotel’s complex pricing calculations. They simply need to input their travel dates, number of rooms, number of adults, children’s ages, and room type, and they will receive a clear breakdown of the total price per person and the overall total. The final price table should be visually appealing, with a detailed breakdown of the total price, including what the package covers, o...
...gradient & dewpoint plotting. - Data: I have some initial data and calculations prepared, but it's only partial. - Explanation: I require both steps and final results to be explained to me. Ideal Skills and Experience: - Proficient in Excel and familiar with 2023 National Building Code, Alberta Canada Edition. - Experience in dealing with thermal and structural calculations. - Ability to explain complex concepts in a simple, understandable way. - Hands-on experience with building projects. This is an urgent task, and I would appreciate swift responses. Thank you. The final deliverables should be provided in an Excel spreadsheet. Please provide written explanations of both the steps and final results in a supporting document. The supporting document should contain an...
Fix ABA (Australian Bankers’ Association) file generation issues in a React-based web app. Ensure ABA files pass bank validation checks. Identify formatting errors and correct header, transaction, and footer records. Current Tech Stack Frontend: React (TypeScript), Vite, Tailwind CSS, shadcn/ui. State Management: TanStack Query (React Query). File Processing: JavaScript/TypeScript logic for text-based ABA file creation. Key Objectives ✅ Analyze & Fix ABA File Structure – Ensure proper formatting, spacing, and field alignments. ✅ Implement Validation Checks – Prevent invalid ABA files from being generated. ✅ Test ABA Files – Validate against bank portal and other verification tools. ✅ Enhance User Experience (Optional) – UI feedback for errors...
I have a portrait photo with uneven lighting that needs to be corrected. The areas that need the most attention are behind the hair and around the head. I would like the lighting to be adjusted in a way that enhances the natural look of the photo, rather than creating dramatic effects. Ideal skills for this project include: - Proficiency in photo editing software like Adobe Photoshop or Lightroom - Experience in portrait photo editing - Ability to enhance natural lighting Freelancers with a keen eye for detail and a knack for subtle adjustments will excel in this project. Please provide samples of previous photo editing work, particularly portrait photos, in your bid. The final edited photo should be provided in JPEG format. The original photo is high resolution (300 dpi).
I'm looking for a Smartsheet expert who can help create a comprehensive resource allocation sheet that auto-calculates and generates an easy-to-read dashboard. As a clinical researc...Key Responsibilities: - Track budget allocations and expenditures. - Monitor and display resource utilization, project progress, and cost tracking on the dashboard. - Include metrics for 30-day, 60-day, and 90-day tasks, as well as the critical path and combined trajectory of the entire portfolio. Ideal Skills: - Deep understanding of Smartsheet features and capabilities. - Ability to visualize complex data in an accessible way. - Experience with long-term project tracking (one to three years). Please provide examples of similar projects (MUST BE USING SMARTSHEET) you've completed and how ...
I need a comprehensive user instruction manual for installing a third-party power app from Microsoft Power Platform. This manual... Key Requirements: - The manual should be detailed step-by-step, with each step accompanied by a screenshot for clarity. - The instructions should cover how to prepare the Microsoft environment, including all necessary programs and assets. - It should also include a breakdown of costs, per company and per user. Ideal Skills: - Excellent technical writing skills, with the ability to simplify complex processes for a mixed audience. - Proficiency in Microsoft Word. - Experience with creating detailed instructional manuals with screenshots. Your bid should reflect your understanding of the task and your ability to deliver a clear, concise, and comprehensi...
I'm looking for a professional web developer to create a user-friendly and informative website for my law firm. Key Features: - The website should primarily serve as a platform to inform potential clients about our legal services. - It should prominently feature our practice areas and spec...prominently feature our practice areas and specialties, as well as detailed profiles and credentials of our attorneys. - A contact form or clear contact information is essential for client interaction. Ideal Candidates: - Proven experience in developing law firm websites or similar professional service websites. - Strong understanding of SEO and user experience design. - Excellent ability to present complex information in a simple and engaging manner. The website should have a modern an...
I have a static website hosted in a AWS S3 bucket and CloudFront distribution point. It is incorrectly configured and producing errors. In some cases I get too many redirect errors. In others I get access denied errors. Most of the configuration I believe will be correct but I'm not strong enough in this area to fix proprely. Requirements: 1 - Ensure visits to the URL and all subsequent web pages serve correctly 2 - As above but for a URL of 3 - Fix so visting a URL like renders correctly. Right now I'd need to type Your experience: You will need EXPERT level AWS S3, Cloudfront, DNS related skills. QUESTIONS: 1 - Tell me a bit about your skills specific to hosting websites on S3 with CloudFront DO NOT
...particularly with high poly models - Strong understanding of anthropomorphized, furry characters - Experience with creating NSFW content - Ability to create a model that is both detailed and functional for potential use in animations or interactive media - Ensuring the model is optimized and functional for animations, including clean topology. - Experience with creating detailed skeletons and rigging for complex character models. - Include customizable features such as different clothing options or body parts. - Ability to create blendshapes or morph targets for facial expressions and other deformations. - Ensure anatomical correctness while maintaining the stylistic elements characteristic of anthro models. - Capability of producing high-quality renders of the model in various l...
I'm looking for a skilled research writer who specializes in technology. The focus of this project will be specifically on the field of robotics. Ideal Skills and Experience: - Proven experience in writing technology-focused research papers, particularly in the area of robotics. - Strong research skills to gather and analyze relevant data. - Ability to present complex information in a clear, concise manner.
Please Sign Up or Login to see details.
I'm in need of a simple yet engaging whiteboard animation video, lasting no longer than 3 minutes, to illustrate the issues encountered during the order picking process in our warehouse. Key Components: - Steps of the order picking process - Common problems encountered - Solutions to avoid these problems The target audience for this video is our warehouse staff. ...process - Common problems encountered - Solutions to avoid these problems The target audience for this video is our warehouse staff. Therefore, the animation should be straightforward, clear, and effective in conveying these messages. Ideal candidate should have: - Proven experience in creating whiteboard animation videos - Understanding of warehouse operations (preferred) - Ability to convey complex ideas simp...
I need a professional to help revise and update our 282-page Health, Safety, and Environment (HSE) manual. Key Tasks: - Making formatting and layout changes - Updating the text - Adding some color - Ensuring the document remains in Word format - Update existing charts, graphs, and diagrams with the most recent data. - Insert new sections as required to cover any gaps in HSE policies. - Review the manual to ensure it complies with current industry standards and regulations. Ideal Skills and Experience: - Proficiency in Microsoft Word - Attention to detail - Experience with document editing and formatting - Ability to understand and revise HSE-related content - Graphic design skills to add color in a professional manner. The primary goal for this update is to improve the usability ...
...will be essential. - Performance and UI/UX Improvements: I'm looking for a developer who can enhance the performance and speed of the new application, as well as modernize the UI/UX design. Previous experience with React and UI/UX design will be a significant advantage. Add more areas of focus Data Migration Strategy API Integration Authentication Logic The website will need to allow users to query our database tables for individual record counts, purchase records to download, and manage users and their data credits in an admin panel. Currently, we're migrating from InforbrightDB (MySQL compatible) to ClickhouseDB, so familiarity with this database transition would be beneficial. Please implement a modern design overhaul for the UI/UX. The expected timeline for the...
online quoting system that enables commercial customers to configure and price pumps, tanks Project Summary: The goal is to develop the most cost-effective online tool for generating quotations based on tank and pump system selections. The tool should allow users to input key parameters such as tank type, pump setup, control type, and other configurable options, and automatically generate a quote with the appropriate model selection. To minimize costs, the solution should leverage a simple web application. The tool should require minimal maintenance, with an option for user authentication and tiered pricing if needed. Key features include: • Simple UI for selecting system components • Automatic lookup and model selection • Quote generation with PDF export • Adm...
Wanting to have an AI Engine Chatbot or similar plugin that will call a MySQL database to provide the most suitable answers. OpenAI Chatbot Asks relevant questions Refers to backend MySQL database for answers based off conversation Allows for fine tuning - keywords can be pulled and used to make SQL queries. Ability for me to train or change keywords
I'm in urgent need of an Excel macros specialist who can help with data analysis and reporting on financial data. Key Requirements: - Expertise in Excel macros, specifically for data analysis and reporting. - Proficiency in handling and interpreting financial data. - Ability to create summary reports from complex datasets. Ideal candidates will have a strong background in finance and data analysis, with a track record of creating effective Excel macros. Please be prepared to showcase examples of your previous work in this area.
I'm looking for a skilled WordPress developer familiar with the Avada theme to help me modify two pages on my site. I need to add a few sections formatted in a specific way. I'll provide a screenshot as an example of the formatted area. Key Req...example of the formatted area. Key Requirements: - Add a few sections to two pages of my Avada WordPress site - Modify the pages according to a provided screenshot - Replicate the layout structure and text content from the screenshot - Ensure the visual style matches the existing site Ideal Skills: - Proficient in WordPress and Avada theme - Excellent attention to detail - Ability to replicate complex layouts and content Please note, the modifications are quite simple and straightforward. The modifications need to be comple...
I'm looking for a skilled MATLAB programmer who can translate my assembly code into efficient MATLAB code. The primary use of the code will be for algorithm development, specifically for digital audio signal processing. The MATLAB code should be able to: - Perform complex audio processing tasks, with a particular emphasis on reverberation - Implement optimization routines to improve performance Experience with both assembly and MATLAB is crucial, as is a strong background in audio signal processing. Familiarity with algorithm development in a MATLAB environment will be highly beneficial.
I'm looking for a smart Business Analyst who understands the B2B lead generation business and can assess my website, my application, and my product. Your tasks will include: - Writing compelling...Your tasks will include: - Writing compelling content about the features and functionalities of my application and product. - Creating blog posts that are educational and informative. Ideal candidates will have: - A deep understanding of B2B lead generation. - Exceptional business analysis skills. - Proven experience in creating engaging content. - Strong writing skills with a knack for making complex topics accessible and informative. -> Able to test product as user and provide feedback, it helps you to generate content and help us to improve it further. -> Work is on hourly...
...agent support (Users can chat with real assistants) Task & request management (Users can submit requests for various services) Subscription model (Basic & premium tiers) User profile management (Preferences, transaction history, saved preferences) Push notifications (Alerts & task updates) 2. Cloud Backend & API Serverless backend (Firebase Functions / AWS Lambda) User & agent management system AI query processing (Handle user queries, categorize tasks) Payment processing (Stripe API for subscriptions & transactions) Secure data storage (User profiles, chat logs, transaction history) 3. AI & Personalization AI chatbot (Handles task automation & recommendations) User profile learning (Basic personalization based on past interactions) Smart recomme...
... Your role will be to enhance the speech with humor that not only entertains but also educates the audience on the intricacies of HR and business. The ideal candidate will be able to interpret the speech and infuse it with a mix of subtly, witty and edgy comedy, keeping the audience engaged and amused throughout. If you have a knack for making complex topics accessible and enjoyable, and can deliver a speech that’s as informative as it is entertaining, I’d love to hear from you....
I'm looking for a seasoned marketing professional with a strong background in private equity real estate. The primary focus will be creating engaging email campaigns aimed at enhancing our brand awareness within the sector. Key Responsibilities: - Develop and design captivating email content centered on industry news, case studies, and infog...Responsibilities: - Develop and design captivating email content centered on industry news, case studies, and infographics. - Strategically distribute these emails to maximize reach and engagement. Ideal Skills and Experience: - Proven experience in marketing within the private equity real estate sector. - Exceptional skills in email marketing and content creation. - Ability to interpret and present complex industry information in an e...
...somewhat fearless. Can get pretty good interviewees. PLUS free, live consummate help to those who watch or listen to the Podcast AND a chance to be interviewed on camera, issues and all! Not only interviewed but ultimately put in the right direction for getting through it and even healing. Wow. Referrals to local professional therapists included of course. I’ll need remote interview capability bc most of my ‘show-clients’ are in NY for now. I’m licensed in NYS and still practicing. I have written several episodes already but prefer to wing-it in the moment things are revealed to create thrills and chills ? Key Responsibilities: - Content/Idea Creation: Help develop engaging, life-centered non-fiction stories and ideas for episodes. - Interviewing: Bring ...
I am seeking a professional with strong PowerPoint skills to create an engaging and persuasive presentation for a business proposal. This proposal will focus on operational improvements and is intended for internal stakeholders. Therefore, it is essential that the freelancer: - Understands the intricacies of operational processes - Can convey complex ideas in a clear and compelling manner - Has experience creating presentations for internal audiences The ultimate goal is to secure buy-in from key decision-makers on proposed operational enhancements. Your ability to translate operational data into a persuasive narrative will be crucial.
We’re looking for a fresh, modern logo for Wisely Consulting! ? Our company specializes in web development, e-commerce solutions, embedded systems, and digital consulting. You can check out our current logo at – but we’re ready for something new! What We Need: ✅...Need: ✅ A clean, professional, and minimalistic design ✅ A modern, tech-savvy feel ✅ A logo that looks great on websites, business cards, and social media ✅ A logo only in 1 color ✅ A logo containing a simple icon, that can be used alone. What We Like: ? Simple yet distinctive logos ? Strong typography with a digital/tech feel ? Creative use of the letter W (optional) What to Avoid: ❌ Overly complex or cluttered designs ❌ Generic logo templates ❌ AI generated logo ? Submit your best designs!
...kitesurfing adventures. Key Aspects: -The logo should be made of our name which: IKS - Along the IKS name, a good idea is to make an Icon which also deliver the message - The logo should convey a youthful, energetic, yet clean and fun vibe. - It should incorporate elements of surfboards, kites, and ocean waves in a seamless and innovative way. The integration doesn't need to be overly complex, but the core essence of our activities should be clear. - The color scheme should be bold and vibrant, to match the adventurous spirit of our business. - Consider creating an icon var iant of the logo that can be used as a compact representation of our brand. Ideal Skills and Experience: - Proven experience in logo design, particularly in the adventure sports or craftsma...
I'm seeking a creative and professional logo designer to reflect my multifaceted business. We specialize in surfboard craftsmanship and kitesurfing adventures. Key Aspects: - The logo should convey a youthful, energetic, yet clean and fun vibe. - It should incorporate elements of surfboards, kites, and ocean waves in a seamless and innovative way. The integration doesn't need to be overly complex, but the core essence of our activities should be clear. - The color scheme should be bold and vibrant, to match the adventurous spirit of our business. - Consider creating an icon variant of the logo that can be used as a compact representation of our brand. Ideal Skills and Experience: - Proven experience in logo design, particularly in the adventure sports or craftsmanship se...
...of a mechanical component into a .step file suitable for CNC machining. The project involves precise adherence to specific dimensions and tolerances which I will provide through annotated drawings. Ideal Skills: - CAD software proficiency - CNC machining knowledge - Detail-oriented - PDF to STEP conversion experience This project requires immediate attention. The mechanical component has a complex geometry that requires detailed conversion. The conversion should be done using SolidWorks software. The conversion should be completed within 1-2 days. The 3D model should have a highly detailed representation to capture all intricate features. Pay special attention to the critical tolerances noted in the drawings. The 3D model should have a high level of detail to capture all intr...
I'm seeking a professional to help me produce a series of lectures on YouTube catered to Adults. The teaching style will be either lecture-based, or discussion-based aimed at delivering clear and concise content in an engaging manner. I want to teach a book that I've written on personal finance. I need technical and creative support with this project Ideal Skills: - Ability to break down complex Non-Fiction concepts - Experience creating content for YouTube - Understanding of adult learning principles - Proficiency in video editing software is a must Your task will be to: - Help grow our YouTube channel through quality content. The project will involve creating 5-10 lectures. Each lecture should be between 20-30 minutes in length. "Incorporate various format...
I'm looking for an expert in digital marketing with a strong background in setting up and managing ad campaigns on social media platforms, specifically Instagram, Facebook, and LinkedIn. My primary goal is to boost sales of my physical products, which...and engagement metrics. The campaign aims to achieve a specific revenue target by the end of the duration. The campaign aims to achieve a revenue target of $1 million by the end of the duration. The primary metric for evaluating the success of the campaign will be the total sales revenue generated. I prefer a low level of involvement in the creative process and will trust the freelancer to make most decisions independently. The products being marketed are wall mounted decorated items. The campaign should primarily target a nat...
I'm launching a fast food brand, "UFO Fried Chicken", and in need of a talented graphic designer to create a modern, sophisticated, and unique logo that includes an icon and text. The logo should prominently feature a UFO, while also incorporating elements of fried chicken i...in fast food brand design is a plus The logo should utilize a color palette of red/blue or blue/orange and include a star. Your creativity is crucial to formulating unique designs that truly represent my brand. As for the style, I'm looking for a mix of minimalist, vintage, and cartoonish elements. Ultimately, I need a logo that reflects a strong and appealing brand identity, with a UFO as the most prominent element. The specific design of the UFO is open to your interpretation – I...
I'm in need of a skilled professional who can convert a picture into a medium-detail 3D model suitable for 3D printing. Key Requirements: - The final 3D print will be made using PLA, so the model needs to be optimized for this specific material. - The level of detail required for the model is medium. It should be adequately detailed for a good quality print, but not overly complex. Ideal Skills: - Proficiency in 3D modeling software. - Prior experience in creating 3D models for 3D printing. - Understanding of PLA properties and how to optimize models for this material. Please only apply if you have relevant experience and can provide examples of similar work.
I am seeking a ZBrush specialist who can create complex character models that are not only visually appealing but also functional for animation. Ideal Skills: - Extensive experience in ZBrush, particularly in character modeling - A strong portfolio of character models - Understanding of animation requirements and character rigging - Knowledge of industry standards for model quality Please note that the specific type of character to be modeled has not yet been determined. If you have a strong creative vision and can propose interesting character concepts, that would be a plus.
Please Sign Up or Login to see details.
I'm looking for a talented writer with ...talented writer with a solid background in trading and finance to help me create engaging content for a book focused on stock market investing. The primary target of this book is novice investors, but I also want it to be appealing to more seasoned traders. Key Requirements: - Draw inspiration from 'Stock Investing Mastermind' by ZebraLearn - Produce well-researched chapters that articulate complex concepts in an accessible manner - Include theoretical concepts and practical guides - Creativity and passion for trading is a plus - Provide writing samples of past financial content. If you have experience in writing and a keen interest in the trading world, I would love to hear from you! The desired length for the book is app...
...Zapier✔️ Ability to automate data imports and reports✔️ Strong understanding of demand forecasting & financial modeling✔️ Experience working with inventory tracking and supplier forecasting✔️ Proficiency in customer support data tracking and report generation✔️ Experience with social media analytics & performance tracking✔️ Familiarity with email marketing automation and reporting✔️ Bonus: Knowledge of SQL, Google Apps Script, or Python for automation ? Preferred Qualifications: ➤ Experience working with Shopify stores, e-commerce brands, or inventory-based businesses➤ Understanding of fulfillment strategies & ad targeting➤ Familiarity with geographic & demographic analytics➤ Previous experience assisting with customer service workflows & supplier coordi...
Please Sign Up or Login to see details.
I'm seeking an expert in DevOps to help me understand and implement best practices and workflows related to Continuous Integration/Continuous Deployment (CI/CD) and Containerization with Docker and Kubernetes. Key areas of focus: - Best practices and workflows for CI/CD: I'm particularly interested in learning about effective deployment strategies and pi... Deployment (CI/CD) and Containerization with Docker and Kubernetes. Key areas of focus: - Best practices and workflows for CI/CD: I'm particularly interested in learning about effective deployment strategies and pipeline automation. Ideal candidates should have: - Extensive experience with CI/CD and containerization - In-depth knowledge of best practices in these areas - Ability to explain complex topics in an e...
I need a program or spreadsheet that will make my data submissions during home inspections more efficient. Key Features: - Drop-down boxes: For standardized responses. - Fill-in text bo...for easy access and backup. - Ideally, it should be a user-friendly interface that's easy to navigate during inspections. Ideal Skills: - Proficient in creating interactive software or spreadsheets. - Understanding of intuitive interface design. - Ability to implement photo attachment capability within the tool. The platform for this tool can be flexible, but it should prioritize ease of use. Most data input will occur on a smartphone or computer/laptop during inspections. I have examples of the different info that is put into the reports that need to be combined along with a current comple...
Please Sign Up or Login to see details.
