CARD System-DWH

DWH - Datawarehouse

On DWH CARD Project was responsible for the design, development, and maintenance of an internal Data Warehouse (DWH) supporting the company's card management system. The DWH served as the central database layer for applications and reporting solutions built in Oracle APEX, enabling the processing, integration, and delivery of large volumes of operational and business data. Key responsibilities included: Designing and enhancing the DWH data model. Developing, maintaining, and optimizing ETL processes and batch data processing jobs. Creating and managing database objects, including tables, views, procedures, and indexes. Improving SQL query performance through indexing strategies, statistics management, and query optimization techniques. Monitoring daily data loads and integration processes, troubleshooting issues, and ensuring reliable operation. Ensuring data quality, consistency, and availability across the platform. Supporting the development of reports, dashboards, and analytical solutions in Oracle APEX. The project delivered a scalable and high-performance data platform that served as the backend for the card management system, providing reliable data for operational reporting, analytics, and business decision-making.

Benefit for the company

I helped optimize database statistics, developed new features, and automated manual processes using Python.