Database-design Jobs

I have three distinct text-file datasets—customer information, financial records, and survey responses—that all need to be brought into a clean, analysis-ready format. The job is twofold: first, accurately key or import every record into a structured spreadsheet or database layout; second, perform a full hygiene pass to remove duplicates, correct any formatting inconsistencies, and fill in the missing fields I will flag for you. You will receive a folder of raw .txt files plus a short field dictionary that shows the expected column names, data types, and any reference lists you can use for validation. Once the data is in shape, return it as Excel workbooks (or CSV if you prefer) that match the field order in the template I’ll provide so I can import straight into our CRM...

I’m ready to commission a full-stack solution that turns our current paper-heavy student office into a streamlined digital campus. The first release must focus on student enrolment and records management and be robust enough to let us expand later into timetabling or forum modules if we choose. What the initial build must do • Transcripts & grade tracking – students and authorised staff should see up-to-the-minute results, GPA calculations, and printable official transcripts. • ID card generation – on-demand cards with photos, barcodes/QR and expiry dates, exportable to standard badge printers. Access control Both students and staff will log in to view or update the records appropriate to their role. Please include role-based permissions, single sign...

I am ready to commission a complete, web-based management suite for a multi-store shopping mall. The project must cover two distinct areas: 1. A mall-level administration panel that tracks tenants, leases, foot-traffic analytics, promotions, and finance. 2. A store-level back office where each retailer can handle day-to-day tasks such as product catalogues, inventory, staff rosters, and sales reporting. Every screen has already been drafted; page 3 of the attachment contains the reference mock-ups that must be followed pixel-for-pixel while remaining fully responsive for desktop and large-tablet browsers. Key scope elements • Build a single-page web application that communicates with a secure REST (or GraphQL) API. • Design and implement the database schema, access l...

Saya mencari seorang freelancer yang dapat menangani administrasi dan pengolahan data secara end-to-end. Fokus utama saya adalah pengelolaan dokumen dan penyusunan database yang rapi, mudah dilacak, serta selalu up-to-date. Ruang lingkup pekerjaan: • Input dan validasi data di Microsoft Excel maupun Google Sheets—keduanya akan dipakai bergantian sesuai kebutuhan. • Penerapan rumus VLOOKUP, IF, COUNTIF, hingga pembuatan Pivot Table untuk rekap otomatis. • Penyusunan laporan administrasi dan laporan bulanan yang mudah dibaca oleh manajemen. • Penataan arsip digital/fisik berikut sistem penamaan file agar dokumen cepat ditemukan. • Pembuatan sheet HR: absensi, database karyawan, rekap lembur, sampai ringkasan payroll. Anda bebas menentukan format atau ...

Printflow V2.3 — Simplified Specification Version 2.3 · Purpose: Telegram-based production tracking, material control and reporting for one printing / paper-bag manufacturer. 1. Principles • PostgreSQL is the system of record. The LLM only extracts and answers; it never writes SQL or changes data directly. • Every extraction and every operator entry is confirmed by a human with Edit / Approve / Reject before it is saved. • Never invent missing data. Anything the PO does not state stays blank/UNKNOWN until a person fills it in. Colours stay free text. • History is append-only: corrections are new events, never silent overwrites. • No features beyond this document. Simple, deterministic, auditable. 2. Architecture Telegram (long polling) → ONE ...

I'm seeking a skilled Access database developer to create a system for tracking employee training requirements. Essential Features: - Employee Record Management: Maintain comprehensive records including personal information, job role, department, and training history. - Reporting and Analytics: Generate insightful reports to analyze training data and employee compliance. Training Completion Tracking: Updates will be manually handled by HR. Ideal Skills & Experience: - Proficiency in Microsoft Access - Experience in database design and management - Strong analytical and reporting skills - Attention to detail and accuracy Looking forward to your expertise!

## Project Overview & Objectives We are seeking a developer to build a custom, multi-tenant Learning Management System (LMS) tailored for commercial fleet compliance and driver training. The system will replace standard video files with an interactive, slide-based presentation player utilizing synchronized background audio narration. The application should be built using a modern, scalable tech stack (freelancers are encouraged to propose their preferred backend and frontend frameworks), designed for optimal deployment on a standard Linux VPS environment. ## Core User Roles * **Super Admin:** Full platform control, interactive module creation, system-wide analytics, and company/tenant onboarding. * **Company Manager (Tenant):** Dashboard access to enroll their specific fleet drivers...

Project Overview We are looking for an experienced AI/ML developer to help us build a private, locally hosted Large Language Model (LLM) for our project. The goal is a secure, on-premise AI solution that runs entirely on our own server, with no reliance on external cloud AI services, so our data stays fully within our control. You will work closely with our internal IT team from the planning stage through deployment. Scope of Work Phase 1: Discovery & Brainstorming Collaborate with our IT team to understand our current infrastructure, data sources, and business needs. Recommend the best architecture, model choice (e.g., Llama, Mistral, Qwen), and approach (RAG, fine-tuning, or a combination). Phase 2: SQL Data Room Development Design and build a structured SQL data room that pulls...

Freelance PHP + AI Developer Required We are looking for an experienced PHP Developer with 5+ years of experience who also has strong practical experience working with AI APIs, AI Agents, and AI-powered web applications. PHP Development Skills 5+ years of professional PHP Development experience Strong knowledge of Core PHP & OOP MySQL / Database Design HTML, CSS & JavaScript AJAX & REST APIs MVC architecture Git / GitHub Clean, secure and maintainable coding practices Ability to understand, maintain and extend existing PHP applications Experience building custom admin panels and web applications AI Skills & Experience Hands-on experience with: OpenAI / ChatGPT API Google Gemini API Claude API DeepSeek API AI Agent Development & Integration AI Chatbots & Conversa...

need a complete, professional bureau-de-change and money-transfer platform consisting of a responsive website plus iOS and Android apps. The goal is one unified fintech experience where customers can view live FX rates, calculate exchanges, buy/sell or send money, complete KYC, make payments, receive notifications, and track transactions in real time. The platform must be suitable for a Canadian/Québec regulated money-services business, with strong KYC/AML, transaction monitoring, audit trails, security and reporting. It must also be designed for future physical bureau-de-change locations, cash transactions and multiple branches. 1. Website & Mobile Apps Responsive web application iOS app ready for App Store submission Android app ready for Google Play Shared secure backend/A...

I have a MySQL database that holds a mix of text and numerical fields, and it needs a quick yet thorough clean-up. The goals are simple: • Identify every record containing NULL values and either replace those NULLs with the appropriate defaults or remove the rows when a sensible default is impossible. • Detect and eliminate duplicate rows without breaking referential integrity. I will give you direct access to a staging copy of the database along with its schema. Please supply: 1. The SQL scripts you use (well-commented) so I can rerun them later. 2. A brief before-and-after row count plus any caveats you found during the process. Successful delivery is a database free of NULLs in mandatory fields, no duplicate records, and a clear script trail so the work is fully repr...

We have approximately **8 million products already uploaded to our website/database**, and all products currently do not have images. We are looking for an experienced developer/automation engineer to build a **scalable automated product image sourcing, generation, matching and upload system**. The preferred image hierarchy is: 1. Find and use an accurate manufacturer/official product image where available. 2. If a suitable real image cannot be found, use AI-generated product-only images where appropriate. 3. Products with uncertain image matches should be flagged for review rather than automatically uploading an incorrect image. The system should use available product information such as product name, part number/SKU, manufacturer, brand, category and description to identify the corre...