Manual QA Testing for Web Application
About RolePerform structured manual testing of a web application before release. The goal is to identify functional, usability, responsive-layout, and regression issues across important user journeys. We need detailed, reproducible bug reports that help developers fix issues efficiently. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.RequirementsReview requirements and create a practical test checklist.Test registration, login, forms, search, payments, and key workflows.Check common desktop, tablet, and mobile screen sizes.Record severity, steps, expected result, actual result, and evidence.Retest fixes and maintain a clear status summary.Highlight risks that should block release versus minor improvements.
CI/CD Pipeline for GitHub Project
About RoleSet up a practical continuous integration and deployment workflow for an application hosted in GitHub. The pipeline should automatically run quality checks, tests, and a controlled deployment process. We need useful failure messages and documentation so the development team can maintain the workflow after delivery. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.RequirementsReview the repository structure and existing release process.Configure automated linting, tests, and build validation.Add protected deployment steps for the selected environment.Manage secrets safely and avoid exposing them in logs.Create clear status checks and failure notifications.Document branch, release, rollback, and troubleshooting procedures.
MySQL Database Optimization and Backup
About RoleReview and improve the performance and reliability of a MySQL database used by a web application. The project includes identifying slow queries, reviewing indexes, checking backup practices, and documenting a safe maintenance routine. Changes must be tested carefully to avoid disrupting production data. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.RequirementsReview database schema, query performance, and growth patterns.Identify slow queries and recommend or implement safe optimizations.Check indexes, constraints, and data consistency.Design or improve scheduled backup and restore verification.Document monitoring indicators and maintenance procedures.Explain every production change and its expected effect.
PostgreSQL Database Migration
About RoleMigrate an application database to PostgreSQL with minimal risk and a clear rollback plan. The project requires careful mapping of data types, indexes, relationships, and application queries. We expect a test migration, validation report, production runbook, and support during the final cutover. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.RequirementsAudit the source schema and identify compatibility issues.Prepare migration scripts and a repeatable test process.Validate row counts, relationships, key business values, and application behavior.Plan downtime or low-downtime cutover based on the application.Provide rollback steps and post-migration checks.Document credentials and environment setup without exposing secrets.
AWS Deployment for Web Application
About RoleDeploy an existing web application to AWS using a secure and maintainable setup. The environment should support reliable application hosting, database connectivity, logging, backups, and basic scaling. We want clear infrastructure documentation so another developer can operate the deployment confidently. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.RequirementsReview the application requirements and current deployment process.Configure suitable AWS services for hosting and data storage.Set up environment variables, access controls, logs, and backups.Use secure networking practices and least-privilege permissions.Create a repeatable deployment process for future releases.Provide a handover document with monitoring and troubleshooting steps.
Dockerize Existing Web Application
About RoleContainerize an existing web application so that development, testing, and deployment environments are more consistent. The Docker setup should be easy for a new developer to run, should not expose secrets, and should include practical troubleshooting notes for common environment problems. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.RequirementsReview the application stack and runtime dependencies.Create suitable Dockerfiles and a local orchestration configuration.Separate development configuration from production secrets.Document database, storage, and migration initialization steps.Test a clean setup on a fresh environment.Explain how to build, run, update, and troubleshoot the containers.
Google Cloud Server and Storage Setup
About RoleConfigure a Google Cloud environment for a small application and its file storage. The work should balance cost, security, and ease of management. We need a clean setup with appropriate permissions, backups, monitoring, and a documented method for deploying updates. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.RequirementsCreate or review the project structure and billing safeguards.Configure compute, storage, database, and network components as required.Set up service accounts with limited permissions.Enable logging, alerts, and basic backup policies.Test application access and file upload/download behavior.Provide a cost overview and operational handover guide.
Python Automation for Monthly Reports
About RoleAutomate a repetitive monthly reporting process that currently requires manual spreadsheet work. The script should collect data from supplied files or APIs, validate inputs, calculate agreed metrics, generate a formatted report, and clearly identify missing or unusual values before final output. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.RequirementsUnderstand the current manual workflow and reporting format.Create reusable scripts with configuration for future months.Validate source files and show clear error messages.Generate Excel or PDF reports using the approved layout.Include a small test dataset and expected result.Document installation, execution, and troubleshooting steps.
Sales Forecasting Machine Learning Model
About RoleBuild a forecasting model that estimates future sales from historical transaction data and agreed business factors. The goal is not only to produce predictions but also to communicate model limitations, error ranges, and the variables that influence results so the output can support practical planning decisions. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.RequirementsReview data quality, seasonality, missing values, and business definitions.Prepare a reproducible data-preparation and training pipeline.Compare suitable baseline and machine-learning approaches.Evaluate accuracy using time-aware validation.Provide visual forecast outputs and an explanation of assumptions.Deliver code, documentation, and a handover session.
Image Classification Model for Product Defects
About RoleDevelop a proof-of-concept computer-vision model that classifies product images into approved and defect categories. The project includes data review, labeling guidance, model training, evaluation, and a simple demonstration interface or API. We need honest performance reporting and a clear plan for improving the model with more data. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.RequirementsReview the image dataset and identify labeling or imbalance issues.Suggest a practical annotation and data-splitting strategy.Train and compare suitable classification approaches.Report precision, recall, confusion matrix, and important failure cases.Create a simple inference script or API demonstration.Document how new images can be added for future training.
Payment Gateway API Integration
About RoleIntegrate a payment gateway into our existing web application. The implementation must support secure payment initiation, success and failure handling, verification callbacks, transaction records, and clear user messaging. We need a production-minded integration with proper testing and documentation rather than a basic demo. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.RequirementsReview the existing application and payment provider documentation.Implement payment creation, callback, verification, and status handling.Prevent duplicate transactions and handle retries safely.Store only appropriate transaction details and protect sensitive information.Test success, failure, cancellation, and delayed callback scenarios.Provide deployment variables, test evidence, and integration notes.
CRM and Website Lead Integration
About RoleConnect our website lead forms with a CRM so new inquiries are created, assigned, tagged, and tracked automatically. The integration should be reliable, avoid duplicate leads, and give the sales team enough information to follow up quickly. We also need a clear way to identify failed submissions. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.RequirementsMap existing form fields to CRM fields.Implement secure API or webhook-based lead creation.Add source, campaign, and consent information where available.Prevent duplicates using suitable identifiers and validation.Log failed requests and provide a retry or alert process.Test multiple form types and document the final configuration.