Open to Opportunities
Milad
Gerami
Senior BI Developer & Data Analytics Solutions Architect
↗ LinkedIn ↗ GitHub 📍 Irvine, CA — Open to Pacific Northwest & Southern CA

Turning raw data into executive decisions. My foundation is built on a real engineering background across construction, telecom, and project management, now moved to Power BI, SQL, and SSIS. I build scalable dashboards, optimized data models, and end-to-end ETL pipelines that give leadership the clarity they need to act. I use every tool available to solve problems faster and keep delivery focused.

Power BI SQL DAX SSIS PostgreSQL Star Schema Node.js Docker VS Code GitHub

About Me

Data professional turning raw numbers into business clarity.

B.Sc. Civil Engineering background, with a career spanning Engineering, Construction, Telecom, and Project Management before transitioning fully into Data & BI.

Currently a Power BI Developer at Colaberry Inc., delivering live consulting projects and building production-grade dashboards used by executive teams. Specializing in Power BI, SQL, and SSIS, building scalable data models and end-to-end ETL pipelines that turn complex data into clear, actionable insights.

Known for eliminating inefficiencies, automating reporting, and improving performance, while increasing visibility across teams and leadership.

If a project calls for AI, I know how to use it effectively to speed analysis and keep results practical.

"Data is my new beginning. I don't stop until I fully understand something, fast learner, eager to bring real value from day one."
2025 — Present
Power BI Developer
Colaberry Inc.
Built Executive Risk Command Center. Currently on live consulting projects.
2023 — 2024
Data Analytics Student
Colaberry Inc.
Intensive training in Power BI, SQL Server, SSIS & data warehousing.
2020 — 2023
Telecommunications Specialist
All States Engineering & Surveying
Led cross-functional projects. Introduced data-driven reporting workflows.
2018 — 2022
Project Manager
Telecommunications
Managed cross-functional teams. Introduced structured reporting workflows.
2000s — 2019
Civil Engineer & Project Design Consultant
Engineering & Construction
Led multi-phase projects including 5M+ sq ft commercial developments.

Skills & Tools

The stack I use to turn messy data into crisp, decision-ready insights.

BI & Visualization
Power BI DesktopAdvanced
DAXAdvanced
Data ModelingAdvanced
KPI DesignAdvanced
Report BuilderIntermediate
Database & SQL
SQL Server / T-SQLAdvanced
Stored ProceduresAdvanced
CTEs & Temp TablesAdvanced
Views & TriggersIntermediate
PostgreSQLIntermediate
ETL & Data Engineering
SSISAdvanced
Star Schema DesignAdvanced
Data ConversionAdvanced
SCD Type 1 & 2Intermediate
Conditional SplitIntermediate
B.Sc. Civil Engineering
Tehran Azad University — IAU
Intro to Data Analytics
Certified
Data Analytics
Certified
Power BI
Certified

Featured Projects

Real problems. Real data. Real results.

💎
Complete
Power BI · SQL Server · SSIS
Automotive Market Intelligence Dashboard

End-to-end BI project analyzing the US and global automotive market across Gas, Hybrid, and Electric vehicles, built on real EPA and IEA government datasets. SSIS pipelines load 49,846 EPA vehicle records and 16,436 IEA trend rows into SQL Server. Power BI dashboard with DAX measures, KPI cards, and dark theme. Key finding: EVs cost 75% less to fuel annually and hold 22% global sales share as of 2024.

Power BI SSIS SQL Server EPA + IEA Data
📊
Live
Power BI · Data Analytics
Executive Risk Command Center

Power BI dashboard analyzing 1,000+ construction projects across 83 risk variables, achieving 96.5% prediction accuracy. Star-schema model with optimized DAX measures for KPI tracking, cost overrun analysis, and executive-level risk visibility.

Power BI DAX SQL Server Star Schema
🚀
Full Stack
Node.js · React · PostgreSQL · Anthropic SDK
LaunchForge AI

Full-stack AI-powered startup launch platform. Generates structured launch plans saved as real projects and tasks in PostgreSQL. Campaigns module with Draft → Active → Complete lifecycle, GitHub deployment readiness reports, feedback system, in-app notifications, and 3-role RBAC. React + TypeScript frontend, JWT auth, Redis, Docker, and CI/CD with 79 passing tests.

Node.js React PostgreSQL Anthropic SDK Redis Docker

Experience

A career built on solving complex problems across industries.

Power BI Developer
Colaberry Inc. — Remote
2025 — Present
  • Built Power BI dashboards analyzing 1,000+ projects across 83 risk variables, achieving 96.5% prediction accuracy and enabling proactive decision-making.
  • Designed star-schema models and optimized DAX measures to support KPI tracking and cost overrun analysis.
  • Engineered SSIS ETL pipelines that unified fragmented data sources into a single source of truth, ensuring leadership had consistent, decision-ready data at all times.
  • Refined and optimized SQL queries and data models to eliminate performance bottlenecks, delivering faster and more reliable reporting.
Data Analyst (Intern)
Colaberry Inc. — Remote
2023 — 2024
  • Delivered Power BI dashboards that translated complex datasets into clear, executive-ready insights driving informed business decisions.
  • Built SSIS ETL pipelines to transform and standardize complex data into reliable, business-ready datasets.
  • Strengthened data accuracy by applying data warehousing best practices, validation techniques, and structured modeling approaches.
Telecommunications Specialist
All States Engineering & Surveying
2020 — 2023
  • Led cross-functional telecom projects and introduced structured reporting workflows that improved data visibility and operational decision-making.
  • Coordinated design and survey operations ensuring accurate project documentation and on-time delivery.
Project Design Consultant
Engineering & Construction
2000s — 2019
  • Managed large-scale construction and infrastructure projects including 5M+ sq ft commercial developments and multi-structure bridge programs.
  • Directed planning, quality control, and execution across engineering workflows improving operational efficiency and ensuring consistent project outcomes.

Get In Touch

Open to opportunities, collaborations, and conversations.

Let's Work Together

Whether you need a BI solution built from scratch, an existing dashboard modernized, a SQL data model optimized, or just want to talk data, I'd love to connect. Always open to the right opportunity in SQL development, Power BI, or business analysis.

What I Bring to a Team

I thrive in environments that push boundaries. I love exploring new technologies, picking up unfamiliar tools fast, and actively bringing AI into the workflow wherever it creates real value. Whether it's a new BI stack or an unsolved problem, I lean in and deliver.

SQL Developer
Power BI Developer
Business Analyst
Download Resume