Bulsatcom LTD - Data Warehouse Phase 1
**Data Extraction/ETL**
The project focused on designing and implementing the initial phase of Bulsatcom’s enterprise Data Warehouse (DWH), emphasizing the staging layer and the development of efficient, scalable data models for customer/subscriber, payment, and ticketing areas. This was based on data retrieved from the company’s Billing and Ticketing BSS systems. This initiative was crucial in establishing a unified and centralized analytical platform to facilitate business insights, reporting, and operational decision-making.
**Project Roles:**
- Project Manager
- DWH Designer
- DWH/BI Developer
- System & Database Administrator
**Key Responsibilities:**
- **Project Management:** Overseeing project activities, which included planning, coordination, stakeholder communication, and resource allocation.
- **DWH Design:** Creating conceptual, logical, and physical data models for essential business areas like customer/subscriber profiles, payment transactions, and ticketing records.
- **ETL & BI Development:** Developing and executing ETL processes, data marts, stored procedures, and data visualization tools using Oracle Data Integrator and SAP Business Objects.
- **Staging Area Implementation:** Designing and building a robust staging area to enable efficient and secure data ingestion and preprocessing from various source systems.
- **System & Database Administration:** Setting up, configuring, and managing Oracle services on Linux, which included database instance management, performance tuning, and maintenance of Oracle 12c and PostgreSQL environments.
**Technologies & Environment:**
- **Databases:** Oracle 12c, PostgreSQL 9.x
- **ETL & DWH Tools:** Oracle Data Integrator 12, Oracle Data Modeler
- **BI & Reporting:** SAP Business Objects 4.2
- **Operating Systems:** Linux
- **Others:** PL/SQL, Bash scripting (for automation and service management)