Sql jobs

Job Title: Business Analyst (SQL + BI Tools) Duration: 2 Hours Time: Evening IST Budget: ₹22,000 Tech Stack Required: SQL SQL Server Management Studio (SSMS) Snowflake Tableau Power BI ThoughtSpot Requirements: Strong hands-on experience in the above-mentioned tools. Prior experience working in medicated/healthcare domain is mandatory. Ability to provide insights, perform data analysis, and communicate findings clearly. Note: This is a short-term requirement for a specific task/session, not a full-time engagement.

I'm looking for a ...can generate a comprehensive report for an embedded scenario within an existing application. The primary database is Microsoft SQL Server. The application has already been modified to host the embedded report and a data source and initial Power BI report have been created to prove out the concept. Primary need is extensive report/visual development expertise and advice on additional options and capabilities that Power BI may offer. Key Requirements: - Embedded report/visual development - Analyze a variety of sales performance metrics - Examine warranty claim problems Ideal Skills & Experience: - Proficiency in PowerBI - Extensive experience with Microsoft SQL Server - Strong analytical skills with sales data - Previous experience wi...

Hello , we have a website on A2 Hosting is a managed VPS server with 250 GB disk and 8 giga Ram , we have proboem , My sql use to much server resourch . We are looking fior a developer to optmize our prestashop and our My sql

...computer reports, printouts, and performance indicators to locate and correct code problems. **Requirements:** - Proven working experience as a Data Analyst or Business Data Analyst. - Technical expertise regarding data models, database design development, data mining, and segmentation techniques. - Strong knowledge of and experience with reporting packages (Business Objects, etc.), databases (SQL, etc.), programming (XML, Javascript, or ETL frameworks), and statistical packages for analyzing datasets (Excel, SPSS, SAS, etc.). - Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. - Adept at queries, report writing, and presenting findings. **Preferred Qualifications:*...

I'm seeking a skilled PHP and SQL developer to create an 'Institute Management System' for a computer institute. Key Requirements: User Roles: - Admin: Manage students and teachers, manage fees and payments, generate reports. - Student: View attendance records, access exam results, download certificates. Core Functionalities: - Student Enrollment: Add new students into the system. - Fee Management: Track and manage student payments. - Attendance Management: Record and display student attendance. - Exam Management: Handle exam records and allow students to access results. - Certificate Generation: Enable students to download their certificates. Ideal Skills and Experience: - Proficiency in PHP and SQL. - Experience developing management systems or similar a...

I'm looking for a skilled developer to improve an old Excel 2003 model. The current system uses VBA to read and collect live data via DDE links, but is slow and needs an upgrade. Requirements: - Collect live data into an SQL database or other similar database - Generate new files after 18,016 data points (approx. every 4 hours) - Each 500 points equals one period (4 minutes) - Display data as per the attached Excel format Ideal Skills: - Proficiency in C++ or Microsoft Visual Basic - Experience with SQL databases - Strong understanding of data collection and real-time monitoring systems Open to ideas and suggestions from coders on how to enhance this setup.

...application in building data pipelines and analytical models. • Proven ability to design and implement dimensional and relational data models optimized for reporting and analysis (gold layer). • Solid understanding of data integration patterns and ETL/ELT processes for building integrated data layers (silver layer). • Experience implementing data quality checks and data governance frameworks. • Strong SQL skills and experience with data manipulation and querying. • Familiarity with Power BI and its integration with Fabric datasets. • Excellent communication, presentation, and client management skills. You can explain complex technical concepts to both technical and non-technical audiences. • A knack for problem-solving and a proactive approach t...

Hi, We are looking at launching a coinflip website like the CSGO coinflip sites back some 10 years ago but we want some updates. What we have done: We have uploaded the files (script), created a db and imported the sql file as well as updated the config with the cb files. The site loads but the STEAM API does not connect. So we need to update the script to operate in a way that supports in 2025. We need: Tasks for this stage: 1) Remove the usage of steam with the script and replace the user account system with an email / password registration / login with user profile onsite . ( we will require users to confirm their email account to withdraw). 2. We need a coinflip system to be update to support place holder items which each have a value (we will supply a list of items and t...

I require a data expert to gather and preprocess 5 minute timeframe price data for 30 ...should be comprehensive, including not only OHLC and volume, but also market cap. The data needs to be accurate and delivered as a Big Query SQL Data Frame, ready for analysis. Key Requirements: - Accurate data collection from any suitable platform or API (CoinGecko, CoinMarketCap, CryptoCompare, etc.) - Comprehensive data set including OHLC, total volume, volume from top 5 exchanges and market cap - Preprocessing of data to ensure it is ready for analysis - Delivery of data as a Big Query SQL Data Frame Ideal Skills and Experience: - Proficiency in data collection and analysis - Experience with crypto market data - Familiarity with Big Query and SQL - Attention to detail and com...

...and participate in weekly async code reviews & architecture huddles. Help set engineering best practices—CI/CD on Vercel & GitHub Actions, IaC for AWS where needed—and shape our culture of fast, friendly feedback. Must‑Have Qualifications 3+ years professional JavaScript/TypeScript engineering with production React / apps. Comfortable jumping between front‑end and back‑end tasks; solid SQL and data‑modeling chops. Hands‑on experience with Supabase, Postgres, or similar relational DBs. Real‑world integrations with REST/GraphQL and at least one major payments, auth, or media API. Familiarity with modern DevOps for serverless (Vercel, AWS Lambda, CloudFront, S3). Self‑directed, clear communicator, thrives in the ambiguity of 0→1 product work. Extr...

...client’s data stack faster, cleaner, and more valuable. What You’ll Do: Work from a technical consultant handoff to identify bottlenecks and inefficiencies Execute fixes across Snowflake, BigQuery, Redshift, dbt, Looker, Tableau, etc. Write performant SQL, optimize queries, and clean up pipelines Deliver tangible results within a defined 30-day sprint window Provide output documentation and implementation notes at the close of sprint Requirements: Strong proficiency with modern data stacks (Snowflake, BigQuery, Redshift, dbt, etc.) Fluent in SQL and hands-on experience optimizing data pipelines Able to work fast, communicate clearly, and deliver without micromanagement Familiarity with BI tools like Looker, Tableau, Power BI Experience with mid-mark...

I'm looking for an experienced Python developer to create a web application using the Flask framework. The project will involve implementing user authentication, integrating a database, and setting up a REST API. Key Features: - User ...databases is crucial. The application will need to store and retrieve user data, application state, and other necessary information. - REST API: The developer will need to create a robust REST API for the application, ensuring it is well-structured and easy to use. Ideal Skills: - Python & Flask: Extensive experience in Python and the Flask framework is a must. - Database Management: Skills in SQL or NoSQL databases will be highly beneficial. - API Development: Previous experience in creating and managing REST APIs will be crucial for the...

Our company is developing a web portal for our employees to use. We are looking for somebody experienced that can help our IT project manager with development. Required - Blazor - SQL Server - HTML CSS & Javascript - Github Good to know - Azure

I'm seeking a Computer Science Graduate with expertise in Microsoft Access and SQL. The tasks include designing a simple database (up to 5 tables), writing SQL queries, and performing data analysis and reporting. Ideal Skills and Experience: - Proficiency in Microsoft Access - Strong SQL skills - Experience in database design - Data analysis and reporting skills - Computer Science graduate or equivalent experience - Ms Access

I'm looking for an experienced SQL Server professional who can help me with the retention and archiving of my MSSQL Backup logs. Key Requirements: - Extend the retention period for backup logs to 1 year. - Ensure that the logs are stored in msdb. The ideal freelancer for this project would be someone who has a deep understanding of SQL Server maintenance plans and log management. Experience in configuring log retention and archiving is a must. Please note that there is no need for a specific format or structure for the compressed logs.

I am looking for a skilled SQL and Java Spring Boot developer to create a robust web application. The project will involve user authentication, CRUD operations, and integrating with external APIs. Key Project Requirements: - User Authentication and Authorization: Implement a secure login system that includes role-based access control. - CRUD Operations: Develop the necessary Create, Read, Update, and Delete functionalities for the application. - Integration with External APIs: Connect the system with different external services through APIs. Other Project Details: - Database Management System: The project will be using Oracle as the primary DBMS. - Data Security: While the exact level of security measures wasn't specified, I want to ensure the project is built with security i...

I'm looking for a seasoned Full-Stack Software Developer with expertise in Laravel...interface for seamless shopping experiences. - Admin Control Panel: For managing users, editing profiles, viewing logs, and banning users if necessary. Payment Process: - Implement Coinpayments API for checkout processing, facilitating smooth and secure cryptocurrency transactions. Ideal Skills and Experience: - Proficiency in Laravel framework. - Extensive experience in full-stack development - PHP, SQL, Javascript, HTML & CSS. - Previous work designing and implementing E-Commerce platforms. - Demonstrated ability to integrate APIs, particularly Crypto-Currency ones. - Strong understanding of user interface design for both front-end and admin control panel. - Experience in implementing u...

As an advanced cybersecurity student, I am seeking a seasoned cybersecurity expert to help me successfully navigate my OSCP course labs. The primary activities I need assistance with include SQL injection, OS injection, and using msfconsole. Key requirements: - Deep understanding of cybersecurity concepts - Extensive experience with OSCP course labs - Proficiency in SQL injection, OS injection, and msfconsole, msfvenum, exploitdb - Able to provide clear and concise lab guidance My goal is not just to complete these labs and get ready for the exam, but to do so with a high level of proficiency. A successful freelancer will be able to guide me through the labs and help me troubleshoot specific issues as they arise. This project is perfect for someone with a rich backgroun...

...existing accounting software application. The work will involve a variety of tasks, including: • Adding and customizing reports • Modifying existing user interface screens • Implementing new features • Improving application performance • Identifying and fixing bugs Required Skills and Experience: • Strong experience with Delphi and the VCL (Visual Component Library) • Solid understanding of SQL • Proven experience working with the database technology used in the project (details will be provided) • Ability to read, understand, and modify existing code • Excellent problem-solving skills and a strong commitment to meeting deadlines If you have a strong track record and experience—particularly with the specified dat...

...healthcare data pipelines. This position will support, maintain, and develop software using a variety of different tools including Snowflake, Python, Pandas, Pyspark, SQL, and the AWS stack. What You’ll be Doing: Writing production level Python and Snowflake SQL for ETL pipelines Writing and integrating data unit tests as part of the data pipelines' development and deployment Using AWS services and technologies for application deployments to data APIs Who You Are and What You Bring: 4+ years of professional experience working with data Experience creating an automated ETL process using Python, Snowflake, and SQL Experience with data processing, validation, cleaning, and debugging data sets Experience with building production grade ...

I'm looking for a skilled developer to enhance my existing ...upgraded to .NET 8.0 and ensure it only utilizes the columns in the measures and visuals for generating optimized versions of the m and SQL queries. It should support all Power BI visuals. Key Requirements: - Identify all open Power BI projects and queries - Generate optimized m and SQL queries using only the columns in the measures and all visuals - Upgrade to .NET 8.0 - Improve the performance of the queries I will share the current version of the app as a zipped file through Freelancer. Ideal candidates should have extensive experience with C#, .NET, and Power BI, along with a proven track record in query optimization. Knowledge of Power BI visuals, measures, and SQL queries is crucial for successf...

I'm looking to build an e-commerce platform using .ASP.NET MVC and SQL Server. The platform will have various user roles, primarily focusing on Admin functionality. Key Requirements: - .ASP.NET MVC and SQL Server expertise - E-commerce platform development experience - Understanding of user management systems The main focus will be on creating an Admin interface with key functionalities such as user management. If you have previous work experience in developing e-commerce platforms and have a good grasp of .ASP.NET MVC and SQL Server, please get in touch. I look forward to your proposals.

...trying to access locked content 5. ADMIN PANEL (Web-based): I need a backend system where I can: Create & manage conversation scenarios or prompts Edit AI content templates or response types See user activity logs (optional) Manage subscriptions or access (optional) Preferred stack: Frontend: React or Vue (responsive) Backend: Firebase / Node.js / Laravel Database: Firestore / MongoDB / SQL 6. TECH STACK: Mobile App: React Native (preferred for cross-platform) Backend & Auth: Firebase / Node.js Push Notifications: Firebase Cloud Messaging Analytics: Firebase Analytics AI: OpenAI API / Google NLP / DeepL or similar DELIVERY EXPECTATIONS: This is a turnkey project, and I expect: Full source code (iOS + Android) Submission to App Store + Play Store App icon...

I need a one-page website for facilitating payments for services. The site will primarily serve as a platform for users to pay for a service. Key Requirements: - The site will be simple and clean, showcasing a single, clear purpose. - It must support Credit/Debi...specific details for the payment gateway integration at a later time. Ideal Skills: - Proficiency in web development. - Experience with payment gateway integration. - Ability to create user-friendly, intuitive designs. Please ensure your proposal includes relevant examples of previous work, particularly any one-page sites or payment service sites you've developed. I need it to connect to MS SQL data base to retrieve and save information. Also prepare an invoice using crystal reports, send sms and emails upon suc...

I am seeking a skilled SQL expert who specializes in MySQL. The project involves two main tasks: optimizing queries for improved performance and overseeing the migration of data to MySQL from various sources. Key Responsibilities: - Analyze and optimize MySQL queries for better efficiency - Manage and execute data migration tasks Ideal candidates should have: - Proficiency in MySQL and SQL language - Experience in query optimization and data migration - Ability to deliver quality work within the given timeline

... Automated & Manual Vulnerability Identification: Conduct thorough automated scans and manual testing against the live application from an unauthenticated perspective, and also with provided test accounts representing different user roles (if applicable). Focus areas include: OWASP Top 10 Vulnerabilities: Attempt to identify and exploit common web vulnerabilities such as Injection (e.g., trying SQL or other injection patterns to see application reactions), Broken Authentication & Session Management, Broken Access Control (testing for privilege escalation and horizontal access based on observed user IDs or roles), Cross-Site Scripting (XSS - Reflected, Stored, DOM-based), Cross-Site Request Forgery (CSRF), Security Misconfigurations (e.g., verbose error messages, exposed i...

As discussed over the chatbox, we need to migrate 4 Azure VMs to our on-premises server. We have a physical machine available and plan to create 2 separate VMs on it—one dedicated to SQL and the other for data and user access. We will be using Hyper-V on a physical machine running Windows Server 2022.

...experienced Full Stack QA Tester based in India to support the development of a cutting-edge Natural Language to SQL dashboarding application. This role will involve testing across the frontend (ReactJS), backend integrations (Gemini prompt engineering), and BigQuery-based data validations. This is a full-time freelance role (40 hours/week). While the majority of work can be done during IST working hours, availability for key meetings in EST time (e.g., evening IST) is required. Key Responsibilities: Develop and execute manual and automated test cases for a ReactJS-based dashboard application. Validate natural language processing (NLP) outputs generated via Gemini to ensure accurate SQL query formation. Conduct data validation testing in Google BigQuery to ensure inte...

...Coimbatore. I'm looking for SQL and Power BI experts in Coimbatore who can assist with data analysis and report creation. The project primarily involves working with an SQL database. Key Responsibilities: - Data Analysis: I need the data to be meticulously analyzed to provide insights that will aid in decision making. - Report Creation: The analyst will be responsible for creating comprehensive reports based on their analysis. Key SQL Operations: - Data Extraction: You will need to extract relevant data from the SQL database. - Data Transformation: The extracted data will need to be transformed for analysis. - Data Loading: Finally, the transformed data will need to be loaded back into the SQL database. The ideal candidate for this project: -...

I'm looking for a professional who can Make awareness session to create a reports and dashboard from MS SQL using power BI with hands on training for create a report from my MS SQL database using MS Power BI. The report will focus on employee performance data, specifically productivity levels. Key Requirements: - Extract and analyze data from the MS SQL database focusing on employee productivity levels - Create a comprehensive Power BI report visualizing productivity levels with line graphs Ideal Skills and Experience: - Proficiency in MS SQL and MS Power BI - Prior experience in creating performance reports - Strong analytical skills to interpret employee performance data - Excellent visualization skills to present data in an understandable and engagin...

**adbaadPOS Mobile Version Technical Specification (English)** --- # 1. Project Objective Develop a mobile version (APK or iOS) based on the existing **ComfortPOS Desktop** program under the new brand name **adbaadPOS**. The application will connect to a Microsoft SQL Server database and manage sales operations. # 2. Main Requirements - SQL Server connectivity: via online and local Wi-Fi. - Ability to change server connection settings. - Offline mode: work without internet and sync later. - Barcode scanning: Using the phone's camera. - Simple, fast, and intuitive interface. # 3. Screens and Functions | # | Screen | Description | |---|-------|----------| | 1 | Server Connection Settings | Server IP, Port, Database Name, Username, Password | | 2 | Login Screen | Enter...

...analytical tools for manufacturing efficiency, downtime patterns, and operational insights. Technical Environment: -Framework: ASP.NET (.NET Framework 4.8) -IDE: Visual Studio 2019 -Database: SQL Server 2016 hosted on Microsoft Azure -ORM: Entity Framework 6.0.0.0 -BI & UI Tools: DevExpress V21.2.11 (heavy use of BI dashboards and reporting) We currently support three user roles: Master-Admin, Admin, and User, each with specific access privileges. The application uses Entity Framework for all database activity. Ideal Candidate Profile: -Strong experience with ASP.NET (Web Forms or MVC) and Azure SQL -Familiar with authentication protocols like Twilio, OAuth, JWT, etc. -Skilled in data visualization and interactive dashboards (DevExpress preferred) -Capable of implem...

...analytical tools for manufacturing efficiency, downtime patterns, and operational insights. Technical Environment: -Framework: ASP.NET (.NET Framework 4.8) -IDE: Visual Studio 2019 -Database: SQL Server 2016 hosted on Microsoft Azure -ORM: Entity Framework 6.0.0.0 -BI & UI Tools: DevExpress V21.2.11 (heavy use of BI dashboards and reporting) We currently support three user roles: Master-Admin, Admin, and User, each with specific access privileges. The application uses Entity Framework for all database activity. Ideal Candidate Profile: -Strong experience with ASP.NET (Web Forms or MVC) and Azure SQL -Familiar with authentication protocols like Twilio, OAuth, JWT, etc. -Skilled in data visualization and interactive dashboards (DevExpress preferred) -Capable of implem...

We are seeking someone who has strong experience of migrating SQL Server databases to Postgres. We are in the process of migrating our application, and with that will come a change in database. Objective is to have the database fully migrated so that we can run our app up against it, to verify it. I need you to maintain full documentation for this. As well as the migration, I need a full handover document detailing what you did and how please, as this work will need to be repeated again in the future several times, and I want our team to be able to do it. If this goes well, we will probably use you for other things in the future, so please do your best work on this.

...functionalities including login authentication, creating new accounts, launching the game and syncing credits. - Understand and adapt to my unique website backend structure: master > sub agent > member. - Each sub agent has a distinct code and is responsible for creating player IDs. Ideal Candidate: - Proficient in Vue.js, as that's the current technology used for the frontend of my site. - Familiarity with SQL databases, specifically myPHP or PostgreSQL. - Ability to comprehend and work with a different backend structure. - Previous experience with Game API 2 is a plus. Ultimately, I need an expert who can seamlessly integrate the game API, while optimizing and understanding both the backend and frontend of my website. Currently my website project has not been upl...

I'm seeking a skilled professional to assist with setting up a SQL database on Microsoft Azure. The database will primarily be used for data storage and retrieval, and it will need to accommodate multiple users accessing it simultaneously. Key Requirements: - Setup of SQL database on Microsoft Azure - Configuration for multi-user access - Implementation of daily backup solutions The ideal freelancer for this project should have extensive experience with Microsoft Azure, particularly in setting up and configuring SQL databases. Knowledge of database security for multi-user access is a plus. I'm also interested in any recommendations for specific data backup and recovery solutions that could further enhance the reliability and durability of the database.

I'm seeking a proficient WordPress developer to address urgent security vulnerabilities and implement changes as per our VAPT report. The highlighted issue is an SQL Injection threat. Key Tasks: - Fix SQL Injection vulnerabilities located on the Login page, Search functionality, and Contact form. - Update plugins as per the recommendations in the VAPT report. - Modify site layout or content in accordance with VAPT suggestions. Ideal candidates would have extensive experience in WordPress security, a deep understanding of VAPT reports, and a proven track record of implementing successful security fixes and site modifications.

...that enhances language learning through adaptive storytelling. The platform should leverage React.js for the frontend, Django for the backend, and SQL Lite for database management. It must integrate Natural Language Processing (NLP) to create personalized, dynamic story-based learning experiences and include real-time feedback mechanisms. The goal is to develop a fully functional, scalable, and user-friendly web application with interactive storytelling, AI-powered assistance, and multilingual support. Technology Stack: Frontend: React.js (with TailwindCSS or Bootstrap for UI) Backend: Django (Python) with Django REST Framework Database: SQL Lite(for structured data storage) Authentication: Firebase or Django AllAuth (SQLlite) NLP & AI: SpaCy, Hugging Face, (for AI-...

Our current website is incomplete and not functional. We are seeking a freelancer to develop a fully operational e-commerce website with Python and SQL. Key requirements: - Build a robust e-commerce platform. - Incorporate essential features such as: - A seamless shopping cart experience. - A system for user reviews. - Secure and efficient payment gateway integration. - Implement a user authentication system with email/password login. Ideal candidates should have proven experience in web development, particularly in building e-commerce sites. Proficiency in Python and SQL is mandatory. Understanding of shopping cart mechanics, user review systems, and payment gateway integrations will be highly advantageous. Candidates with experience in developing secure user aut...

I'm seeking a skilled data analyst to delve into our operational data and help predict future production output. Key Responsibilities: - Analyze our operational data with the goal of predicting future performance, specifically production output. - Provide insights and recommendations based on the analysis. Ideal Skills and Experience: - Proficiency in data analysis tools (e.g., Python, R, SQL, Excel). - Experience in analyzing operational data. - Strong understanding of production metrics and KPIs. - Excellent predictive modeling skills.

I'm looking for a seasoned Power BI Developer to create a comprehensive dashboard focusing on customer behavior. The project involves using website analytics data and presenting it through various visualizations. Key Requirements: - Proficient in Power BI for dashboard creation and data visualization. - Experienced in using DBeaver for database management. - Strong SQL skills for querying and fetching data from multiple tables. - Ability to analyze data and present insights clearly. The ideal freelancer will be able to utilize charts, graphs, and KPIs to create a visualization that tracks customer behavior effectively.

I'm looking for a skilled VB.NET and Crystal Report developer. The task is to retrieve customer details from my SQL Server database, specifically filtering by recent purchases, and sending these details as PDF files via WhatsApp. Key Requirements: - Proficiency in VB.NET and Crystal Report - Experience working with SQL Server - Knowledge of generating and sending PDF files - Familiarity with WhatsApp API for VB.NET - Ability to filter data based on recent purchases The ideal freelancer will have a strong background in software development, particularly in VB.NET, and will have previously worked with Crystal Reports and SQL Server. You will need to generate PDF files from the customer data and send these via WhatsApp. The ability to filter customer data by recen...

I'm looking for an ETL expert based in India to help me with data import in a database or anETL tool and analysis. Key Responsibilities: - input data to both SQL and NoSQL databases. - importing from CSV files. - Conducting data analysis. Ideal Skills: - Proficiency in ETL tools and processes. - Extensive experience with both SQL and NoSQL databases. - Strong analytical skills. - Expertise in working with CSV files. This project requires someone who can handle diverse data sources and is skilled in data extraction and analysis.

I'm in need of a proficient SQL scripter with extensive experience in PostgreSQL. The primary task involves creating a script for data extraction specifically targeting customer data. Ideal Skills: - Proficient in SQL scripting - Extensive experience with PostgreSQL - Knowledgeable in data extraction techniques - Prior experience handling customer data preferred Please provide your relevant experience and examples of similar projects you've successfully completed.

We are seeking a skilled Full Stack developer (Python, React, SQL, Docker) to build an application that interacts with a locally installed Large Language Model (LLM). We are looking for an Application that essentially: - Loops through a directory of XML/json files - Forms prompts using the contents of these files - Systematically submits these prompts to a locally installed LLM - Potentially use Redis for queueing prompts - Saves the results of the prompts to a local PostgreSQL instance - Also allows for the option to save to CSV (both options configurable as on/off) - Build a basic React front-end to view and interact with the output (original data passed to LLM and the resulting information) - The UI will eventually grown in complexity so should be open for extending/scalable A...

...expert with substantial experience in Ms Access, Python, and SQL for this project. The tasks will revolve around database design, data analysis, and leveraging SQL, Python and Ms Access to enhance our database system. Key Responsibilities: - Design and implement efficient database structures - Analyze data to derive meaningful insights - Use Python and Ms Access for various tasks - Optimize SQL queries for better performance The expert should primarily focus on: - Enhancing the performance of our database - Scripting in Python to automate and streamline processes - Managing and manipulating our Ms Access database The main objective of this project is to improve database performance. Ideal candidates will have a deep understanding of SQL queries and optimiz...

...customer satisfaction, and operational efficiency. Scope of Work: • Connect Power BI to data sources including Excel files and SQL databases • Clean, model, and transform data for accurate reporting • Design user-friendly, visually appealing dashboards • Highlight KPIs relevant to various departments (sales, operations, customer experience) • Ensure data is presented in a clear, actionable manner for stakeholders • Prepare dashboards suitable for regular review and presentations Ideal Freelancer Should Have: • Strong expertise in Power BI (dashboard creation, DAX, data modeling) • Experience in data analysis, cleaning, and transformation • Proficiency in Excel and SQL • Prior experience in creating executive-lev...

...• Web-based, simple interface. • Hosted on my server (e.g., Ubuntu VPS), full source code provided. Reliability: • Prevent flagging by Klarna/Revolut credit card issuers long-term. • Neutral checkout/rotation avoids detection as crypto-related. • Add new on-ramps via API if one is flagged. • Documentation for adding on-ramps. Security: • Encrypt data (HTTPS, AES-256). • Protect against SQL injection, XSS. • Log login attempts in dashboard. Delivery: • Complete system (frontend, backend, dashboard). • Test all on-ramps with Klarna/Revolut credit cards. • Includes: • System installed on my server. • Full source code. • Documentation: dashboard use, add on-ramps, troubleshoot. • 1-mont...

...Hours will be dependent upon scope of work to be performed, but we anticipate between 60 and 100 hours a month. - 10+ years’ experience in web development - Strong programming abilities in modern responsive HTML, CSS, Javascript, .Net (C#, WebForms, MVC, Core), React, and marketing emails - Demonstrated knowledge and experience working with Microsoft Azure VMs, Azure Blob storage, Microsoft SQL Server, Kentico Xperience CMS development, Adobe Experience Manager (frontend template development), Git/SVN, Algolia and web service integrations. - Good comprehension and adherence to current standards in SEO, privacy, and WCAG/ADA compliance. - Experience with Google’s GA, GA4, Tag Manager, Data Studio, and Search Console desired. - Self-disciplined, responsive, and...

Description: I need an experienced Python developer familiar with financial data APIs (like Yahoo Finance) to debug an issue in a Django-based project. Problem: The script is supposed to fetch historical stock data including the Adjusted Close price. However, for some tickers (e.g., AEE), I'm getting the following error: sql Copy Edit 1 Failed download: - AEE: No data found for this date range, symbol may be delisted Empty DataFrame Columns: [Open, High, Low, Close, Adj Close, Volume] Index: [] This issue appears only locally — the code is now deployed on a VPS and the web interface works fine. What I Need: Review and debug the Python script that retrieves financial data. Ensure robust error handling for cases like delisted or invalid tickers. Possibly review date r...