Management Consulting Projects

Especialista de Soporte y Dinamización de Comunidades

Especialista de Soporte y Dinamización de Comunidades — SaaS de Marketing (Remoto) Buscamos una persona que se convierta en la cara visible de Korex frente a nuestros clientes: resolutiva cuando hay un problema, y llena de energía cuando hay que activar a la comunidad. Qué harás Soporte y atención al cliente: · Ser el primer punto de contacto de nuestros clientes por WhatsApp y email. · Resolver consultas de primer nivel: accesos, uso del CRM, estado de campañas, saldos y dudas generales de la plataforma. · Gestionar a diario situaciones de alta tensión con clientes insatisfechos —quejas, reclamos y solicitudes de reembolso—, manteniendo la calma, escuchando con empatía y encaminando cada caso hacia una solución concreta que proteja la relación con el cliente. · Escalar incidencias técnicas al equipo de desarrollo con toda la información necesaria (capturas, pasos para reproducir el problema) y dar seguimiento hasta el cierre. · Comunicar de forma proactiva cuando haya incidencias que afecten a varios clientes. · Hacer seguimiento post-resolución para confirmar que todo quedó funcionando. · Documentar cada caso resuelto en nuestra base de conocimiento interna. · Reportar semanalmente el estado de satisfacción de la cartera de clientes. Dinamización de comunidades: · Entrar a los grupos y comunidades de nuestros clientes con energía y cercanía: saludar, presentarte, generar conversación y que la gente sienta que Korex está presente. · Incentivar la activación de los miembros: dar la bienvenida a los nuevos, celebrar avances y resultados, animar a quienes están inactivos a retomar. · Mantener un contacto directo y humano con los clientes y sus equipos, no solo cuando hay problemas. · Proponer dinámicas sencillas que mantengan viva la comunidad (retos, recordatorios de formaciones, momentos de reconocimiento). · Detectar en los grupos señales de desmotivación o insatisfacción y reportarlas al equipo antes de que escalen. ━━━━━━━━━━━━━━━━━━━━━━ Qué te damos en Korex · Entorno de profesionales: trabajarás codo a codo con un equipo con experiencia en marketing, desarrollo y operaciones, no en un call center masivo. · Formaciones de alto nivel para el área de soporte: capacitación continua en la plataforma, en comunicación con clientes y en gestión de incidencias y situaciones difíciles. · Acompañamiento directo del Director de Operaciones: durante tu incorporación y de forma permanente en tu día a día. No estarás solo frente a los casos complejos. · Bonos por alta tasa de satisfacción de clientes: tu buen trabajo se mide y se premia. · 100% remoto, con flexibilidad dentro de la franja horaria acordada. ━━━━━━━━━━━━━━━━━━━━━━ Requisitos · Don de gentes real: te energiza hablar con personas, generas cercanía rápido y sabes leer el ambiente de un grupo. Este rol es tanto de actitud como de habilidad técnica. · Inteligencia emocional y temple: capacidad demostrada para conversar con clientes molestos sin ponerte a la defensiva, bajar la tensión y convertir una queja en una solución. · Experiencia comprobable en atención al cliente, soporte digital o gestión de comunidades (SaaS, agencias de marketing, plataformas online, grupos de WhatsApp). · Español nativo con excelente redacción en castellano neutro. Escribirás con clientes de España y Latinoamérica a diario. · Tono cálido, profesional y resolutivo. Nada de respuestas robotizadas ni mensajes genéricos de "copiar y pegar". · Psicología en saber cómo atender al cliente de forma excelente, representando a la marca de forma cálida, cercana y profesional. · Proactividad: no esperas a que te escriban, tú inicias la conversación. · Criterio para distinguir qué puedes resolver directamente y qué debes escalar. · Organización y autonomía: trabajarás remoto y necesitamos alguien que documente y haga seguimiento sin que se lo pidan. · Disponibilidad en franja horaria compatible con España y Latinoamérica. Se valorará · Experiencia como community manager o dinamizando comunidades de emprendedores, equipos comerciales o programas de formación online. · Experiencia previa gestionando reclamos, reembolsos o retención de clientes. · Conocimiento de CRMs y de Meta Ads (Facebook/Instagram) a nivel usuario. · Manejo de herramientas de gestión de tickets o tableros tipo Kanban. Condiciones ·Dedicación part-time: aproximadamente 20 horas semanales, con posibilidad de crecer a jornada completa según el crecimiento de la cartera de clientes. · Contratación como freelancer + bonos por satisfacción de clientes. · Incorporación inmediata, con periodo de prueba de 30 días. · Formación inicial sobre nuestra plataforma a cargo del equipo · Se necesita conexión a internet y buen equipo para poder trabajar de forma autónoma.

Simple Power Apps Canvas App using one SharePoint List

I need someone to help build a simple Power Apps Canvas App for a production works order tracking process. The app is for a small engineering company and will be used on shared Android tablets and mobile phones. This is for a **simple, but modern look first version** that I can expand later. ## What the app needs to do Operators need to: 1. Select a workstation / production area. 2. Scan or type a works order number. 3. Add multiple works orders into a batch. 4. Review the batch. 5. Submit the batch. 6. Save the submitted records into one SharePoint List. 7. View recent submitted records. ## Data source The app should use **one SharePoint List only** for the first version. Example list name: WOTracking No Dataverse, SQL, Power Pages, model-driven app or premium connectors unless agreed first. Suggested SharePoint columns The single SharePoint List can contain: * `Title` — works order number * `TrackArea` — workstation / production area * `TrackDateTime` — date and time submitted * `TrackDate` — date only * `TrackTime` — time only, text format such as `HH:mm` * `TabletID` — tablet/device name if available * `InputMethod` — typed / scanner / batch * `BatchID` — ID to group one batch submission * `SubmittedBy` — user who submitted * `Comment` — optional notes ## Required screens First version only needs: * Home page * Works Order Tracking * Batch Review * Submit Result * Latest Updates ## Main screen The Works Order Tracking screen should include: * workstation selector; * works order input box; * Add to Batch button; * batch list/gallery; * remove item from batch; * clear batch button; * review/submit button. The important part is that the operator can select the workstation once, then scan/type several works orders before submitting. ## Submit logic When the batch is submitted: * add one row per works order into the single SharePoint List; * include the same `BatchID` on each row in that submission; * include the selected workstation/area; * include date/time submitted; * show a success/failure result. ## App style The app should be: * simple; * tablet-first; * mobile-compatible; * large-button; * easy for factory operators; * easy for an internal IT manager to maintain. Basic responsive layout is enough. It does not need to be overdesigned. ## Deliverables Please provide: 1. Working Power Apps Canvas App. 2. One SharePoint List connected. 3. Batch add/review/submit working. 4. Latest submitted records screen. ## Important This is for a first working version only. I want something simple that I can expand later. Future features may include current status, full history, error logging, Datafile ERP export, assembly instructions, stock locations, incident reporting and IT tickets, but they are not required now. Please confirm: * your experience with Power Apps Canvas Apps; * your experience with SharePoint Lists; * estimated cost; * estimated timescale; * whether you can keep this simple and use only one SharePoint List for the first version.

Create automated planning application spreadsheet

I am looking for someone to create an automated spreadsheet/report that pulls the previous week’s UK planning applications from the UK PlanIt data/API. The purpose of the report is to help identify potential trade opportunities for builders, loft conversion companies, kitchen/renovation firms, roofers and other home improvement trades. I need the spreadsheet to be refreshable each week, so I can update it with the latest planning applications and then export or share the data with ChatGPT for analysis. What I need is a spreadsheet system, ideally in Google Sheets or Excel, that can: 1. Pull planning application data from UK PlanIt. 2. Refresh the report weekly to show the previous 7 days of applications. 3. Cover all UK counties / planning areas, not just one local authority. 4. Handle multiple planning authorities within each county where needed. 5. Pull clean, structured data into a spreadsheet. 6. Allow me to filter by county, planning authority, date, application type and likely trade opportunity. 7. Create summary tabs that make the data easy to review. 8. Be simple enough for a non-technical user to refresh each week. **Important functionality required:** The spreadsheet should include: * A refresh button or clear refresh process. * A date range selector, ideally defaulting to the last 7 days. * County / area filtering. * Planning authority filtering. * Keyword filtering for relevant trade opportunities. * Automatic categorisation where possible, for example: * Extensions * Loft conversions * Garage conversions * Renovations/refurbishments * Kitchens * Roofing * Outbuildings * Commercial fit-outs * Other building works * A clean export tab that can be copied into ChatGPT for analysis. * Basic error handling if the API limit is reached or if a request fails. * A simple instruction tab explaining how I refresh and use the report. **Suggested spreadsheet tabs:** 1. **Instructions** Simple user guide explaining how to refresh the data and use the spreadsheet. 2. **Settings / Control Panel** Date range, counties/areas to include, keywords, refresh controls and any API settings. 3. **Raw Planning Applications** The unedited data pulled from PlanIt. 4. **Cleaned Applications** Clean version of the data with standardised columns. 5. **Trade Categorisation** Applications categorised by likely trade relevance. 6. **County Summary** Number of opportunities by county and trade type. 7. **Planning Authority Summary** Number of opportunities by local authority. 8. **ChatGPT Export** A clean tab designed specifically so I can copy/export the data and ask ChatGPT to analyse it. **Required data fields:** Where available from PlanIt, I would like the spreadsheet to include: * Application name/reference * Planning authority * County / area * Application start date * Address * Description * Application type * Development type * Status * Decision, if available * Applicant / agent details, if available * Link to planning application * Latitude / longitude, if available * Last scraped / last changed date * Suggested trade category * Opportunity score, if possible **Trade opportunity scoring:** Ideally, I would like a simple scoring system to highlight the best opportunities. For example: * High relevance: extension, loft conversion, conversion, major renovation * Medium relevance: alterations, outbuildings, roof works, garage conversion * Low relevance: tree works, signage, minor admin applications, discharge of conditions I am happy for the freelancer to suggest the best scoring approach. **Technical requirements:** The freelancer should be comfortable working with: * APIs * Google Sheets Apps Script and/or Excel Power Query * CSV/JSON data imports * Pagination * Rate limits * Data cleaning * Building refreshable dashboards/reports The PlanIt API has paging and request limits, so the system must be built responsibly and should not rely on one huge request. **End goal:** Each week I want to be able to refresh the spreadsheet, see the latest planning applications across all counties, identify the best trade opportunities, and then ask ChatGPT to analyse the data by county, trade type and opportunity quality. **Deliverables:** 1. A working Google Sheet or Excel workbook. 2. Automated or semi-automated weekly refresh process. 3. All required tabs and filters. 4. Clean data structure ready for ChatGPT analysis. 5. Simple instructions for use. 6. A short handover call or written walkthrough. 7. Notes on any limitations of the PlanIt API or recommended future improvements. **Please include in your response:** * Whether you recommend Google Sheets or Excel for this. * Examples of similar API/spreadsheet automation work. * How you would handle all counties and multiple planning authorities. * How you would manage API limits and pagination. * Estimated delivery time. * Fixed price quote.

opportunity

Mobile App Developer Needed for Premium AI Coaching App

Hi, We are looking for an experienced mobile app developer or small team to build a premium AI-powered coaching / mentor mobile app from a completed Figma design. This is NOT a basic chatbot app and not a template app. The product is a structured AI coaching experience with onboarding, AI memory, daily tasks, accountability, progress tracking, push notifications, subscriptions, and basic content/admin control. Core MVP features: - iOS + Android app - Figma implementation - registration / login - onboarding flow - weak-area / problem selection - coach intensity selection - AI first-session questionnaire - AI mentor chat - structured AI memory / user context - daily quote system - ONE main daily task per day - YES / NO accountability - internal commitment score / points - progress tracking - weekly reflections - push notifications - free access / trial logic - subscription paywall - Apple In-App Purchases - Google Play Billing - restore purchases - backend subscription validation - locked / unlocked access based on subscription status - basic admin / content control - App Store + Play Store ready builds - deployment support - source code handover - documentation - post-delivery bug-fix support AI requirements: The AI mentor should not feel like normal ChatGPT. It should use: - onboarding answers - user profile - goals / preferences - selected weak areas - coach intensity - conversation summaries - important user facts - task history - YES / NO completion history - progress history - weekly reflections We do NOT want to send unlimited raw chat history to the AI every time. The memory should be structured, scalable, and cost-efficient. The mentor tone should be: - direct - short - disciplined - honest - action-focused - accountability-driven - not generic - not therapy-style - not motivational fluff Daily task logic: The app should give the user ONE main daily task, not multiple random tasks. Flow: 1. User receives one daily task 2. User receives reminder notification 3. Evening check-in asks YES / NO 4. Result is stored 5. Progress / commitment score updates 6. AI mentor reacts based on behavior 7. Future tasks adapt based on history and user context For MVP, daily tasks should use templates/categories + AI personalization, not fully random AI-generated content. Guidance areas should include: - discipline - focus - work / money - fitness - dating / relationships - confidence - habits - appearance / grooming / style - books / films / music recommendations where relevant These should not be separate complex modules in MVP. They should be part of the AI mentor, task templates, content logic, and daily guidance system. Admin / content control: We need a basic content/admin layer to manage: - daily quotes - task templates / categories - basic recommendation content - AI prompt / config text - basic user / subscription visibility if possible This does not need to be a large enterprise admin panel, but important content should not be hardcoded only. Preferred stack: Mobile: - Flutter or React Native / Expo Backend: - Node.js / NestJS, Django, FastAPI, Supabase / PostgreSQL AI: - OpenAI API - Claude optional later - structured memory system - prompt/config layer Payments: - Apple IAP - Google Play Billing - RevenueCat acceptable if recommended Notifications: - Firebase Cloud Messaging or OneSignal We will provide: - completed Figma design - user flows - mood board / visual direction - AI mentor tone direction - feature explanation - content examples where needed Important: We need someone who understands AI memory, user context, subscriptions, backend logic, scalable architecture, and polished mobile UX. Payments must be milestone-based. Payment after each milestone should only be released after a working, testable demo/build is approved. Please answer clearly: 1. What tech stack would you use and why? 2. How would you handle AI memory / user context? 3. Have you built AI chat or AI assistant apps before? 4. Have you implemented Apple IAP and Google Play Billing before? 5. Would you use RevenueCat or direct Apple/Google billing, and why? 6. How would you structure the backend? 7. What would the basic admin/content control include? 8. Estimated timeline? 9. Best fixed price for the full MVP? 10. Milestone breakdown with payment per milestone? 11. 2–3 real mobile apps you personally built? 12. Confirm source code and handover documentation are included. 13. Confirm payment is released only after each working milestone is approved. Please do not send a generic proposal. We are comparing multiple developers and will shortlist based on relevant AI app experience, subscription experience, strong architecture, fair pricing, clear milestones, and ability to understand product logic. Thanks.

opportunity

Tidy the server from X-ransom attack

Hello, Our Wordpress website was attacked by x-ransom. We have a backup of the WP and the database dump. We have detected some corrupted files there but it seems that there are still some left that were not detected. It has to be tidy after the attack. It’s an internet shop with uploads files of around 100GB. It’s stored on a private hosting in LV. What is done do far: 1. Update WordPress Version 2. Use z’d updateSecure WP-Admin Login Credentials 3. Set Up Safelist and Blocklist for the Admin Page 4. Use Trusted WordPress Themes 5. Install SSL Certificate 6. Remove Unused WordPress Plugins and Themes 1. Enable Two-Factor Authentication for WP-Admin 2. Back Up WordPress 3. Limit Login Attempts 4. Change the WordPress Login Page URL 5. Log Idle Users Out Automatically 6. Monitor User Activity 7. Check for Malware - found several none-Wordpress specious files and plugins. Deleted them. 1. Disable PHP Error Reporting 3. Turn File Editing Off 4. Restrict Access Using the .htaccess File 5. Change the Default WordPress Database Prefix - not done 6. Disable XML-RPC 7. Hide the WordPress Version 8. Block Hotlinking - not done 9. Manage File Permissions not done After making the list, we received another x-ransome attack. I suspect he has a server level access not only wp level. If you apply, you need to be a server security and a Wordpress specialist. Please, quote for the job.