Tamer Abdel Hamid
Mahmoud El Sayed

Designed and optimized the construction data warehouse DWH 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

Developed 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

Built 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 SQL database

Automated self-check email alerts sent instantly to users upon any incorrect or incomplete data entry in the DMS — covering template mismatches, missing discipline/date fields, and metadata errors. Ensures immediate corrective action before records are finalised, eliminating downstream data quality issues.

Example: Drawing discipline registered as Mech. instead of Elec. — error detected and corrected instantly via automated notification.

• Instant alerts on incorrect Template, Discipline, or Date fields
• Auto-generated email with full document metadata table
• Sent directly to responsible user with CC to DCG team
• Drives zero-tolerance data entry accuracy across all projects

Incorrect Template

Missing Issue Date

Incorrect Discipline