OTC: Inventory & Sales Reporting System

Description

  • Responsibilities

  • API Design
  • Backend Development
  • Testing and QA
  • DevOps

Technology

  • Python
  • Django
  • Django REST Framework
  • PostgreSQL
  • Celery
  • Docker
Project Brief
The project consisted in re-building a legacy enterprise system to improve the reliability and the user experience.
Key Features
  • Synching Data from the Legacy System
  • Allow the user to filter data using custom tree-like rules, adding conditions and special operators
  • Generate Reports in Excel (xlsx) including multiple sheets, formulas and a custom styling
  • Exporting Reports to PDF for printing
My Role

I joined the team to help to speed up and complete backend development and worked in the following tasks:

  • Bugfixes and optimization in the data sync module
  • REST API Design for Invoices and Reports generation
  • DB Schema Design for the Reports module
  • Backend Services Implementation for Excel Reports Generation.
  • Unit tests & Integration tests
  • Code Reviews