Celal E.
Civil Engineer | Quantity Takeoff, BOQ, Cost Estimating & Project Controls | Python/PHP
Global rank:
35,404
/
152,673
Skill pts: 5
Want help from a designer like celale?
About
CIVIL ENGINEERING + SOFTWARE DEVELOPMENT
I combine international construction experience with Python/PHP development, database-backed applications, cloud technologies and workflow automation. I can support both engineering assignments and standalone software projects involving operational tools, reporting, data validation and process automation.
GitHub portfolio and source code: ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
SELECTED INDEPENDENT SOFTWARE PROJECTS
• CrewMetric — Python/Flask/SQLite application for workforce attendance, man-hours, production quantities, labor efficiency and capacity planning.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• SiteLedger — Python/Flask/SQLite material inventory with receipts, issues, transfers, stock counts, atomic posting and linked reversals.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• WorkWeave — Project delivery and capacity planning with task dependencies, team availability, effort, historical rates and expenses.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• SentryScope — Python static analysis with AST rules, conservative data-flow tracking, finding history and JSON/HTML/SARIF reporting.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• CertiFlow — BOQ quantity certification and progress-payment calculations with retention and previous-payment reconciliation.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• TraceLedger — Traceable BOQ measurements, reconciliation and ERP cost-code staging using SQLite.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• ProcureGate — PHP/SQLite purchasing workflow with budget checks, approval controls, role boundaries and transactional audit events.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• SiteQueue — Durable Python job queue with leases, bounded retries, idempotency keys and stale-worker fencing.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
These are independently developed personal portfolio projects with source code and documentation. They are distinct from my engineering employment and paid client engagements.
ENGINEERING SERVICES AND BACKGROUND
I help contractors, consultants and project teams turn construction drawings and project data into clear quantities, practical cost estimates and reliable project controls.
I am a civil engineer with nearly 20 years of international construction experience across Türkiye, Libya, Algeria and Iraq. My background covers residential developments, school buildings, industrial facilities and infrastructure, with responsibilities in site management, technical office management, planning, procurement and cost control.
Services I can support remotely:
• Quantity takeoffs, material takeoffs and bills of quantities (BOQ)
• Construction estimating, tender preparation and bid comparisons
• Progress payment review, quantity verification and cost tracking
• Project scheduling, resource planning and progress reporting
• Construction cash-flow forecasts and procurement planning
• Excel reporting, data checking and workflow automation
My tools include PlanSwift, Bluebeam, Microsoft Excel, Primavera P6, Microsoft Project and Tekla Steel. Alongside engineering, I have freelance software development experience with Python, PHP, cloud technologies and databases. This combination helps me automate repetitive reporting, reconcile project data and build practical tools for construction workflows.
I hold a BSc in Civil Engineering from Atılım University. I work in Turkish and English and am based in Türkiye, seeking international remote freelance and project-based assignments.
For each assignment, I focus on clear scope, traceable quantities, documented assumptions and deliverables that your team can review and use.
... more »
« less
I combine international construction experience with Python/PHP development, database-backed applications, cloud technologies and workflow automation. I can support both engineering assignments and standalone software projects involving operational tools, reporting, data validation and process automation.
GitHub portfolio and source code: ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
SELECTED INDEPENDENT SOFTWARE PROJECTS
• CrewMetric — Python/Flask/SQLite application for workforce attendance, man-hours, production quantities, labor efficiency and capacity planning.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• SiteLedger — Python/Flask/SQLite material inventory with receipts, issues, transfers, stock counts, atomic posting and linked reversals.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• WorkWeave — Project delivery and capacity planning with task dependencies, team availability, effort, historical rates and expenses.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• SentryScope — Python static analysis with AST rules, conservative data-flow tracking, finding history and JSON/HTML/SARIF reporting.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• CertiFlow — BOQ quantity certification and progress-payment calculations with retention and previous-payment reconciliation.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• TraceLedger — Traceable BOQ measurements, reconciliation and ERP cost-code staging using SQLite.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• ProcureGate — PHP/SQLite purchasing workflow with budget checks, approval controls, role boundaries and transactional audit events.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
• SiteQueue — Durable Python job queue with leases, bounded retries, idempotency keys and stale-worker fencing.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
These are independently developed personal portfolio projects with source code and documentation. They are distinct from my engineering employment and paid client engagements.
ENGINEERING SERVICES AND BACKGROUND
I help contractors, consultants and project teams turn construction drawings and project data into clear quantities, practical cost estimates and reliable project controls.
I am a civil engineer with nearly 20 years of international construction experience across Türkiye, Libya, Algeria and Iraq. My background covers residential developments, school buildings, industrial facilities and infrastructure, with responsibilities in site management, technical office management, planning, procurement and cost control.
Services I can support remotely:
• Quantity takeoffs, material takeoffs and bills of quantities (BOQ)
• Construction estimating, tender preparation and bid comparisons
• Progress payment review, quantity verification and cost tracking
• Project scheduling, resource planning and progress reporting
• Construction cash-flow forecasts and procurement planning
• Excel reporting, data checking and workflow automation
My tools include PlanSwift, Bluebeam, Microsoft Excel, Primavera P6, Microsoft Project and Tekla Steel. Alongside engineering, I have freelance software development experience with Python, PHP, cloud technologies and databases. This combination helps me automate repetitive reporting, reconcile project data and build practical tools for construction workflows.
I hold a BSc in Civil Engineering from Atılım University. I work in Turkish and English and am based in Türkiye, seeking international remote freelance and project-based assignments.
For each assignment, I focus on clear scope, traceable quantities, documented assumptions and deliverables that your team can review and use.
Experience
-
Freelance Software Developer | Python & PHP
Independent / Self-employed · Freelance
Jun 2022 –
Present
4 yrs 4 mos
Turkey
Independent PHP and Python development for practical business and operational workflows, including data validation, database-backed tools, procurement approvals, cost tracking, resource planning and reporting. My civil engineering background helps me translate construction requirements into useful software and data checks.
Personal projects published on GitHub include CrewMetric (man-hours and production performance), SiteLedger (material movements and stock reconciliation), WorkWeave (project delivery and capacity planning) and SentryScope (Python static analysis and finding history). These are independent personal projects, not claims of commissioned client engagements.
Technologies: Python, PHP, cloud technologies and databases. Examples: https://github.com/celalerakman - Owner & Construction Manager erakmn ltd. şti. · Self-employed Mar 2016 – Feb 2020 3 yrs 11 mos Turkey Owned and managed a residential construction business delivering more than 100 villa, prefabricated-house and wooden-house projects. Coordinated teams of approximately 25–50 people, suppliers, subcontractors, material procurement, schedules and site execution from initial planning through ready-to-live completion. This business has closed; this is historical experience.
Education
- Atılım University Bachelor of Science (BSc), Civil Engineering 2001 – 2006
Other experience
-
Software Portfolio — GitHub Project Catalogue
Independent software portfolio: https://github.com/celalerakman
The following are personal software projects. Source code and repository documentation are available for review; they are not presented as commissioned client work or evidence of commercial deployments.
certiflow — Cumulative quantity certification and payment calculations.
https://github.com/celalerakman/certiflow
traceledger — Traceable BOQ measurements and ERP cost-code staging.
https://github.com/celalerakman/traceledger
procuregate — Transactional purchasing workflow with budget and approval controls.
https://github.com/celalerakman/procuregate
sitequeue — Durable job processing with leases, retries and stale-worker fencing.
https://github.com/celalerakman/sitequeue
landed-cost — Compare supplier quotations including freight and minimum orders.
https://github.com/celalerakman/landed-cost
inventory-reorder — Lead-time inventory thresholds with safety stock.
https://github.com/celalerakman/inventory-reorder
dependency-schedule — Earliest finish calculation for task dependency networks.
https://github.com/celalerakman/dependency-schedule
invoice-deduplication — Find duplicate invoice references within supplier boundaries.
https://github.com/celalerakman/invoice-deduplication
unit-converter — Decimal quantity conversion with dimensional checks.
https://github.com/celalerakman/unit-converter
uat-coverage — Requirement coverage and acceptance-test readiness checks.
https://github.com/celalerakman/uat-coverage
retry-jitter — Bounded exponential backoff with injectable full jitter.
https://github.com/celalerakman/retry-jitter
content-addressing — Canonical JSON fingerprints for repeatable content identity.
https://github.com/celalerakman/content-addressing
log-redaction — Recursive sensitive-key masking for structured logs.
https://github.com/celalerakman/log-redaction
atomic-artifacts — Atomic local artifact replacement using same-filesystem temporary files.
https://github.com/celalerakman/atomic-artifacts
token-bucket — A local rate limiter driven by explicit monotonic timestamps.
https://github.com/celalerakman/token-bucket
storage-forecast — Storage capacity estimates from retention, replicas and daily growth.
https://github.com/celalerakman/storage-forecast
currency-parser — Parse decimal currency strings into integer cents.
https://github.com/celalerakman/currency-parser
invoice-matcher — Reconcile purchase orders, receipts and invoice quantities.
https://github.com/celalerakman/invoice-matcher
approval-routing — Route purchasing approvals by explicit value thresholds.
https://github.com/celalerakman/approval-routing
csv-export — Export text rows with spreadsheet formula neutralization.
https://github.com/celalerakman/csv-export
delivery-reconciliation — Track outstanding quantities across partial delivery notes.
https://github.com/celalerakman/delivery-reconciliation
vendor-validation — Validate vendor master rows before data migration.
https://github.com/celalerakman/vendor-validation
boq-overruns — Find measured quantities exceeding contracted BOQ quantities.
https://github.com/celalerakman/boq-overruns
unmeasured-boq — Identify contracted BOQ items without site measurement evidence.
https://github.com/celalerakman/unmeasured-boq
contract-valuation — Aggregate BOQ contract value by project and currency.
https://github.com/celalerakman/contract-valuation
measurement-history — Inspect running quantities across source measurement records.
https://github.com/celalerakman/measurement-history
referential-audit — Inspect SQLite foreign-key consistency.
https://github.com/celalerakman/referential-audit
query-plan-inspector — Inspect composite-index use for measurement lookups.
https://github.com/celalerakman/query-plan-inspector
sentryscope — Local Python static analysis with data-flow traces and auditable finding history.
https://github.com/celalerakman/sentryscope
workweave — Company operations, project delivery and weekly capacity planning.
https://github.com/celalerakman/workweave
siteledger — Construction material inventory with atomic warehouse movements and auditable stock reconciliation.
https://github.com/celalerakman/siteledger
crewmetric — Construction workforce management, approved man-hours and measured production performance.
https://github.com/celalerakman/crewmetric
Workstream Register — Project coordination, workstreams and delivery tracking.
https://github.com/celalerakman/workstream-register -
International Construction & Project Controls
Selected experience from my construction career:
School construction — Site Chief, Özlem Duru İnşaat: coordinated machinery and labor, prepared quantity takeoffs, BOQ, bid reports, construction cost estimates and Excel cash-flow forecasts. Used PlanSwift and Bluebeam and coordinated material and labor schedules. This engagement has ended.
Gürbağ A.Ş. — Senior Planning Engineer, January 2013–February 2016: head-office project planning, procurement and materials coordination, site visits and progress-payment review for Avrocity housing and Zaho university campus projects in Northern Iraq.
Polikon & Karamaden Partnership — Technical Office Manager, July 2010–December 2012: technical office responsibilities on a 1,400-residence OPGI housing development in Algeria.
Kolin A.Ş. — Technical Office Manager, March 2009–April 2010: pipelines and pools for the Great Man-Made River project in Benghazi, Libya.
ATK-YOL — Site Chief, March 2008–February 2009: infrastructure works on Ilısu Dam security access roads and outposts in Mardin, Türkiye.
VHP Yapı — Site Chief, October 2006–February 2008: reinforced-concrete structures and excavation works at industrial facilities in Kırıkkale, Türkiye.
Stats
0 followers, 0 following
Joined: October 23, 2026
Last seen: October 23, 2026
Area of Expertise
Languages
English Full professional proficiency
Turkish Native or bilingual proficiency
Location
Bursa, Turkey