1001 Freelance Projects
Latest Projects from
Freelance Marketplaces
View Project
View this project in detail
(Note: you will be redirected to external marketplace)
Project title:
[sharp]15: Backend KPI & Time-Series APIs
Posted by:
External project from PeoplePerHour
Started:
21-Feb-2026 11:26 GMT
Description:
Summary
We need an experienced AWS/backend developer to deliver pre-aggregated user KPIs, time-series endpoints for charting, and upcoming payment endpoints. The goal: provide small, fast endpoints the frontend can call (single request per dashboard load) and ensure data correctness, caching and tests.

Scope of work
Build (or finalize) the following endpoints (or confirm/extend existing):

1. GET /user/{user_id}/kpis
Returns: portfolio_value, total_appreciation, monthly_earning, monthly_payout, last_updated
Pre-aggregated for fast reads

2. GET /user/{user_id}/upcoming-payments?days=30
Returns scheduled installments due in the next X days (property, amount, due_date)

3. GET /market/history/{area_key}?days={n}
Returns time-series: [{date, price_per_sqm, valuation}] for charting

(Optional) GET /user/{id}/portfolio-snapshot/latest — aggregated per-property snapshot

Data sources & responsibilities:
- Use DynamoDB table (PropertyValuations) for historical price/sqm series.
- Use Monthly Snapshot Engine (Lambda) for latest snapshot/purchase_price/current_value.
- Map OCR outputs (SPA) to PaymentSchedule table to compute upcoming payments.

Ensure:
-Composite key time-series queries on DynamoDB are efficient and paginated
-Caching layer or TTL to prevent too many DLD API calls (redis or in-Lambda cache)
-Proper authentication and secure handling of API keys
-Unit tests and integration tests
-Swagger/OpenAPI doc for endpoints and example responses
-Provide a brief data model summary and documentation for frontend mapping.

Deliverables
- Implemented endpoints deployed to the existing AWS account (or provided as serverless Lambda + API Gateway definitions)
- Postman collection / OpenAPI spec
- Tests and instructions to run them
- Short runbook describing cron/timing of snapshot ingestion and where the KPIs derive from

Acceptance criteria
- /user/{user_id}/kpis returns accurate numbers for sample user (manual cross-check)
- /market/history/{area_key} returns at least the last 90 days or the available historical records (non-empty)
- /user/{id}/upcoming-payments lists the correct installments for sample user
- All endpoints respond within acceptable latency (
Project ID:
3470910
Project category:
Project budget:
View this project in detail
(Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
Flutter MVP: Daily Activity App
Category: App Development, Backend Development, Figma, Flutter, Google Firebase, Mobile App Development, React Native
Budget: ₹37500 - ₹75000 INR
21 Mar 2026 17:03 GMT
Reflective Scholarship Essay Writer Needed
Category: Academic Writing, Article Writing, Content Writing, Creative Writing, Editing, Essay Writing, Grant Writing, Personal Development, Proofreading, Research Writing
Budget: $30 - $250 USD
21 Mar 2026 17:03 GMT
UK Thesis Harvard Referencing Help -- 2
Category: Academic Writing, Article Writing, Report Writing, Research Writing
Budget: £250 - £750 GBP
21 Mar 2026 17:00 GMT
Enhance WhatsApp Chatbot via Twilio Integration -- 2
Category: AI Chatbot, AI Chatbot Development, API Integration, Automation, Chatbot, Debugging, Make.com, Mobile App Development, PHP, Twilio
Budget: $14 - $30 NZD
21 Mar 2026 17:00 GMT
Clean And Boost My Audio
Category: Adobe Audition, Audio Editing, Audio Engineering, Audio Processing, Audio Production, Audio Services, Sound Design, Voice Talent
Budget: $30 - $250 USD
21 Mar 2026 16:58 GMT
Web QR Membership Management System
Category: API Development, Bootstrap, CMS, Database Management, Full Stack Development, HTML, PHP, Software Architecture, Web Development, Web Design
Budget: $30 - $250 USD
21 Mar 2026 16:58 GMT
Minimalist Nature-Inspired Logo Icon
Category: Branding, Icon Design, Logo Design, Photoshop, Vector Design
Budget: ₹600 - ₹1500 INR
21 Mar 2026 16:58 GMT
Personal Lifestyle Secretary Needed in bangalore
Category: Customer Service, Entrepreneurship, Event Planning, Public Relations, Social Media Management, Time Management
Budget: ₹55000 - ₹95000 INR
21 Mar 2026 16:57 GMT
Bilingual Online Training Platform Development
Category: Graphic Design, HTML, Laravel, Node.js, Payment Gateway Integration, PHP, Web Development, Web Design, WooCommerce, WordPress
Budget: $30 - $250 USD
21 Mar 2026 16:56 GMT
Build Scalable Data Pipelines
Category: Azure, Data Architecture, Data Integration, Data Processing, Database Programming, Java, Python, SQL
Budget: $15 - $25 USD
21 Mar 2026 16:54 GMT
Website Content & SEO Maintenance
Category: Content Management System (CMS), Content Writing, Google Analytics, Internet Marketing, Keyword Research, Link Building, SEO, Website Management, Website Optimization, WordPress
Budget: $30 - $250 USD
21 Mar 2026 16:53 GMT
Booking & Payment MVP Application
Category: Full Stack Development, HTML, IOS Development, JavaScript, Mobile App Development, Payment Processing, Python, React Native, UI / User Interface, Web Development
Budget: $30 - $250 USD
21 Mar 2026 16:53 GMT
Amazon Account Setup & Growth
Category: Account Management, Amazon, Amazon FBA, Customer Service, Data Analysis, Inventory Management, Keyword Research, SEO
Budget: ₹1500 - ₹12500 INR
21 Mar 2026 16:53 GMT
Profile-Based Investment Wallet Website
Category: ECommerce, HTML, Laravel, Node.js, PHP, Python, Web Development, Web Design
Budget: $30 - $250 USD
21 Mar 2026 16:53 GMT
Techno DJ Reel Edit
Category: Adobe Premiere Pro, After Effects, CapCut, DaVinci Resolve, Final Cut Pro, Video Editing, Video Post Editing, Video Services
Budget: ₹600 - ₹1500 INR
21 Mar 2026 16:53 GMT
Browse All Projects
Projects by Skills ...
android
ajax
asp
aspnet
cms
cpp
csharp
css
delphi
design
drupal
excel
facebook
flash
html
java
javascript
joomla
iphone
mysql
photoshop
php
python
ruby
seo
sql
sysadm
translate
typing
twitter
vbnet
xml
wordpress
writing
New!
Проекты на русском
(Projects in Russian)

Copyright © 2005-2025
1001 Freelance Projects