About Me
a space very few people occupy."
My career started in 1999 on a $340M construction project, but I quickly realized that the real challenge was never the documents themselves — it was the data trapped inside them. That insight became the engine of everything that followed: 24 years of building the intelligence layer that turns project complexity into executive clarity.
Today I design and operate SQL Server data warehouses, build Power BI dashboards that give leadership real-time visibility across 7 projects and 4 offices, and develop Python & automation tools that eliminate manual bottlenecks entirely. My databases handle 500,000+ records with CTEs, optimized stored procedures, and ETL pipelines pulling from multiple enterprise sources — so the right number reaches the right person at the right moment.
Most people in this field manage files. I build the data infrastructure on top — governance frameworks, quality controls, MDM, and BI models — so that a project manager in Cairo can make a strategic call based on live data, not a week-old spreadsheet.
Across mega-projects in Egypt, Saudi Arabia, and Libya — power plants, oil & gas facilities, airports, and high-rise complexes — I have consistently been the person who bridges the gap between field operations and boardroom decisions. Today I am pushing further into AI-powered analytics, predictive reporting, and intelligent document processing — helping construction organizations move from reactive reporting to proactive, data-driven decision making.
Career Progression
Head of Document-Data Control Technical Support
Consolidated Contractors Intl. Co. (CCIC)
Acting as Area Coordinator – Document-Data Management · 7 Projects & 4 Offices
- Transformed complex data into actionable insights via interactive Power BI dashboards and data models.
- Enabled data-driven decision-making through accurate, timely BI solutions and self-service tools.
- Established and managed Document Control Departments across all Egypt area projects and offices.
- Developed and maintained SQL Server databases including data validation, optimization, and troubleshooting.
- Designed, developed, and maintained data pipelines and ETL processes integrating multiple enterprise sources.
- Implemented and supported Primavera P6 Enterprise administration for all projects and offices.
- Defined enterprise data quality frameworks covering accuracy, completeness, consistency, timeliness, and integrity.
- Drove data lineage, MDM, and automation initiatives across the full data lifecycle.
- Developed and tracked KPIs supporting operational and strategic decisions.
- Led continuous improvement initiatives to automate workflows and optimize document control processes.
Head of Document Control Dept.
Consolidated Contractors Intl. Co. (CCIC) – Build Office CS/QM
Client: Qatari Diar · 10 Projects
- Responsible for delivery of all formal engineering documentation across 10 projects.
- Managed MS SQL Server administration including installation, upgrades, backup & recovery, performance tuning.
- Created database components: Tables, Views, Procedures, Functions, Triggers, and Packages.
- Implemented Primavera P6 Enterprise for all area projects and offices.
Document Control Head
TAV – Tepe Akfen Investment Construction & CCC JV
Project: Sebha International Airport · Client: Libyan Civil Aviation Authority
- Coordinated all Document Control activities including technical documents, drawings, and commercial correspondence.
- Managed SQL Server database administration and maintained document registers and distribution records.
Document Control & System Analysis Manager
PARACON International (Egypt)
- Provided consultancy for document management system roll-outs in organizations of 500+ employees.
- Defined metadata, workflow mappings, and retrieval strategies for DMS implementations.
- Led document taxonomy studies and trained staff on document management policies.
Sr. Document Controller (Acting Head of Department)
Consolidated Contractors Intl. Co. (CCIC)
Project: Al Khafji Field Development Plant (KFDP) – Phase I · Client: ARAMCo & KGOC
- Managed comprehensive filing system and computer database for all document control center operations.
- Ensured all users had the latest revision of approved documentation in a timely manner.
Sr. Document Controller
Consolidated Contractors Intl. Co. (CCIC)
Project: Khursaniyah Producing Facilities (KPF) · Client: Saudi ARAMCO · Main Contractor: SNAMPROGETTI
- Led team in collecting, issuing, submitting, and distributing all technical documents.
- Managed filing system and workflow control to ensure timely access to latest document revisions.
Head of Document Control Group
Consolidated Contractors Intl. Co. (CCIC) & HAS JV
Project: Cairo North 750 MW Combined Cycle Power Plant (Civil Package) · PM: PGESCo
- Developed and maintained a comprehensive filing system and SQL database for document control.
- Created required applications and database program units (Tables, Views, Procedures, Functions, Triggers).
- Participated in server administration, backup & recovery, and performance tuning.
Document Controller & Network Administrator
United Stone Egypt
- Handled all company electronic and physical transmittals and managed network of 20 computers.
Document Controller
Orascom Construction Industries
Project: City Stars · Owner: Golden Pyramids Plaza · PM: BECHTEL
- Managed latest-revision document distribution and maintained computer database for fast retrieval.
Accountant
Seif Pharma Group
- Responsible for supplier accounts, financial reporting, and tax compliance.
Training & Certifications
Artificial Intelligence & Digital Transformation 📄 View
Corporate Governance Management ISO 37000 📄 View
Governance & Digital Transformation Ambassadors Program 📄 View
Google Data Analytics Professional Certificate 📄 View
Introduction to Containers w/ Docker, Kubernetes & OpenShift 📄 View
Docker for beginners 📄 View
Automate Doc. Review Process with SharePoint & Power Automate 📄 View
Monitoring & Telemetry for Production Systems 📄 View
Aconex Learning Explorer Badge (Associate, Professional & Specialist) 📄 View
Digital Transformation for Executives 📄 View
Python 101 – Develop Your First Python Program 📄 View
Introduction to IoT and Digital Transformation 📄 View
Front End Web Development Professional (Nanodegree) 📄 View
Analyzing and Visualizing Data with Power BI (DAT207x) 📄 View
Excel for Data Analysis and Visualization (DAT206x) 📄 View
Querying with Transact-SQL (DAT201x) 📄 View
Innovation and IT Management (IS110x) 📄 View
Microsoft Certified Database Administrator (MCDBA) 📄 View
Microsoft Visual FoxPro 📄 View
Visual Byblos Cyberspace (VBC) Documents Management System / Business Process Managemet
Primavera Enterprise P6 – Implementation & Administration
SharePoint as Documents Management System
Aconex Documents Management System
Primavera Expedition Professional (Presenter/Trainer)
Crystal Reports
Microsoft VBA in Access, Visual Basic 6.0 & VB.NET
In-House Training
IT/Project Control Systems Trainer – Controls Managers Program📄 View
AI Applications in Construction Management (I & II)📄 View
Forensic Investigation of Delays in Large Construction Projects (I, II & III)📄 View
Motivation Skills for Managers 📄 View
BIM Applications & Best Practices Webinar📄 View
Creating a High-Performing Team📄 View
Modern Public Speaking & Presentation Skills📄 View
Advanced Emotional Intelligence📄 View
Critical Problem Solving📄 View
Professional Practice – SOP 📄 View
Construction Planning & Scheduling 📄 View
Project Management – SOP 📄 View
Time Management – SOP 📄 View
Leadership in Action Seminar/Workshop 📄 View
Education
Bachelor's Degree in Accounting
Faculty of Commerce · Benha University, Egypt
Volunteering & Social Responsibilities
Power BI Live Dashboard
Construction Analytics Dashboard
Power BI Embedded · Live Data · Multi-Project KPIs
Interactive executive dashboard consolidating drawing production, submittal tracking, working hours, and document control KPIs across 7 Egypt-area projects and 4 offices. Built on SQL Server data warehouse DWH_DB_TC_BLD_NEW with optimized CTEs and real-time Power BI refresh.
SD/AB Projects — Document Control Data Portal
Shop Drawings · Tech. Docs · RFIs · Production KPIs · Approval Summary · 8 interactive reports
XXX Project — Document Control Data Portal
DWGs Submission · Tech. Docs · Technical Documents Chart · RFIs · Project Summary · 6 interactive reports
Case Studies & Projects
Data Warehouse & SQL Optimization
Data EngineeringDesigned and optimized the construction data warehouse DWH_DB_TC_BLD_NEW handling 500,000+ records. Rewrote legacy queries using CTEs, replaced FORMAT() with CONVERT() for index efficiency, and reduced report generation time significantly.
- Unified drawing production + working hours reports
- Multi-currency grouping (LE & USD) by Project & REV
- Optimized
[SDSubmittalSumm]stored procedure - ETL pipelines from multiple enterprise sources
Power BI Executive Dashboards
Business IntelligenceDeveloped interactive executive dashboards for senior management across all Egypt-area construction projects, transforming raw SQL Server data into actionable visual insights for non-technical decision-makers.
- Drawing production tracking by discipline & revision
- Submittal status heatmaps across 7 projects
- Working hours analytics with drill-through
- Self-service BI for non-technical users
Document Control Automation
Process AutomationBuilt a suite of automation tools to eliminate manual document control tasks — from intelligent PDF renaming to browser-based spell-checking with SQL UPDATE generation and VBA/ADO Excel-to-database integration.
- Python EXE: auto-rename PDFs by latest revision date
- Browser spell-checker for SQL column values (domain-aware)
- Auto-generates UPDATE statements from corrections
- Excel ADO connector to VBC_DB_BLD via fn_GetPropertyVersionValue
Ask My AI Assistant
Have a question about my experience, skills, or background? Ask the AI assistant — powered by Claude.