Cairo, Egypt
I specialize in building business-driven data architectures that align data strategy with enterprise capabilities. At MCDR, I am responsible for analyzing current business operations (As-Is), identifying data dependencies, and preparing a solid foundation for the Solution Data Architecture (To-Be) stage. My role bridges the gap between business strategy and data implementation, ensuring that every data model, integration, and reporting layer directly supports organizational goals and real business workflows. I am passionate about transforming complex operational requirements into structured, efficient, and scalable data architectures that enable better decision-making across the enterprise. Key Focus Areas: • Business & Solution Data Architecture • Data Modeling & Data Governance • Business Process Mapping & Optimization • BI Reporting & Data-Driven Decision Support • Power BI, SQL, and Oracle Data Environments
- Partnered with executives and business owners to analyze business processes and uncover hidden data dependencies, driving more informed and strategic decision-making. - Acted as a bridge between business owners and technical teams by translating requirements into actionable BI/Analytics specifications, ensuring alignment and reducing delivery gaps. - Identifying the official sources for the data, in collaboration with the various Data Owners (Golden Source of Data). - Defined and maintained a business glossary and data dictionary to standardize terminology across stakeholders, ensuring consistent KPI and metric definitions. - Conducted Reverse Engineering and System Analysis on legacy BI systems to extract undocumented business logic, redesign process flows, and enable accurate migration and modernization. - Utilized ARIS to model and analyze business processes, improving workflow visibility and aligning systems with organizational objectives. - Reconstructed complex data flows across Oracle systems and Power BI dashboards using SQL, PL/SQL, and lineage analysis tools. - Mapped data relationships, dependencies, and key entities across source systems to support KPI definition and dashboard design. - Built foundational documentation for analytics and BI systems, reducing onboarding time for new developers and enabling scalable future development.
- Contributed to the design and development of the Enterprise Data Warehouse (EDW), integrating data from multiple business systems to support enterprise reporting and analytics. - Collaborated directly with C-Level executives and business stakeholders to translate requirements into robust BI and data-driven solutions. - Extracted, transformed, and integrated data from Oracle databases, building unified data models that supported business analysis. - Designed and maintained consolidated master data entities for brokers, custodians, customers, and issuers by integrating data from multiple source systems, improving consistency, reporting accuracy, and enterprise-wide data accessibility. - Built and optimized PL/SQL stored procedures and SQL queries to automate transformations, improve performance, and ensure data quality. - Designed and implemented data modeling layers including Staging Layer, Lookup Tables, and Semantic Layer to ensure structured, consistent, and business-ready data delivery. - Developed and maintained Data Lineage documentation to trace data flow across systems, ensuring transparency, governance, and impact analysis for business and technical stakeholders. - Implemented Change Data Capture (CDC) and automated data pipelines using Oracle Data Integrator (ODI) and GoldenGate for reliable and timely updates. - Scheduled, monitored, and optimized ETL jobs to ensure accurate and consistent data delivery. - Designed and deployed interactive Power BI dashboards to visualize KPIs and provide actionable insights for leadership. - Strengthened collaboration with cross-functional teams by bridging technical implementation with business needs, setting the foundation for advanced analytics and system documentation in later roles.