📂 Project Description

The Data Consolidation Console App is a backend tool designed to extract data from multiple databases and centralize it into a single repository. It automates data collection, ensures consistency across sources, and provides a reliable foundation for reporting and analysis, improving efficiency and data integrity across the organization.

❗ Problem & Solution

Problem: Organizations often have data scattered across multiple databases, making reporting and analysis difficult. Manual consolidation is time-consuming, prone to errors, and may lead to inconsistent or outdated information.

Solution: The Data Consolidation Console App automates the process of fetching and centralizing data from multiple sources. It ensures consistent, accurate, and up-to-date data, reduces manual effort, and provides a reliable foundation for reporting, analytics, and decision-making.

🚀 Features

• Connects to multiple source databases
• Automated data extraction and consolidation
• Configurable synchronization schedule
• Centralized repository for reporting and analysis
• Ensures data consistency across sources
• Reduces manual effort and potential errors

🛠️ Tech Stack

• Framework/Platform: .NET 9 / .NET Core Console App
• Language: C#
• Databases: Microsoft SQL Server
• Task Scheduling: Windows Task Scheduler or Cron jobs
• File Output / Reporting: CSV / Excel (EPPlus or ClosedXML)

📹 Project Demo

Watch the demo below