Data Categorization Solution

Project Info -

Designed and implemented a comprehensive solution to process and categorize data from a source table with over 52 columns into six new tables based on the client’s specific requirements. Built using Flask and PostgreSQL, the system is optimized to handle millions of records efficiently. Two CLI tools were developed: one for processing the entire dataset and another for handling data based on date range. These scripts were deployed as services on a Linux server, ensuring automated and reliable execution. The solution provided seamless data management, categorization, and integration into the client’s operations, enhancing their ability to manage and analyze large datasets effectively.