(615) 555-0142 ◇ Nashville, TN
vikram.chandran@example.com ◇ linkedin.com/in/vikram-chandran ◇ vikramchandran.com
Data modeling professional with 8 years designing conceptual, logical, and physical data models for a healthcare analytics company with a 40TB warehouse serving 60 hospital clients. Owns the enterprise data model of 320 entities, cut average query time on the 20 most-used reports 65% through a dimensional redesign, and delivered a canonical patient model that ended 4 years of conflicting patient counts across 6 systems. Designs models around the questions the business asks, and documents them so the next engineer can extend them without asking.
Coursework in Data Modeling, Database Design, Data Warehousing, and Enterprise Architecture.
Certified Data Management Professional since 2021; Snowflake SnowPro Advanced Data Engineer since 2023.
- Own the enterprise data model of 320 entities and 4,100 attributes for a 40TB healthcare warehouse serving 60 hospital clients and 900 analysts.
- Cut average query time on the 20 most-used reports 65% through a dimensional redesign of 12 fact tables and 40 conformed dimensions.
- Delivered a canonical patient model that reconciled 6 source systems and ended 4 years of conflicting patient counts, with 0 reconciliation disputes in 2 years since.
- Designed logical and physical models for 9 warehouse subject areas covering claims, policy, and billing across 180 tables.
- Modeled the migration of a 15-year legacy warehouse to a cloud platform, with 100% of 220 reports reconciling to the legacy output at cutover.
- Built the naming and documentation standard adopted across a data team of 25, cutting model review cycles from 3 weeks to 1.
- Reverse-engineered 60 undocumented tables into a logical model during a 12-week internship.
- Wrote data quality checks that found 14,000 orphaned claim records ahead of a system upgrade.
- Received a full-time offer at the end of the 12-week internship based on the reverse-engineered model.
Canonical Patient Model. Ran 20 workshops with clinical, billing, and analytics teams to define a single patient entity with 45 attributes and survivorship rules across 6 source systems, then modeled and validated it against 12M patient records, which ended 4 years of conflicting counts and became the foundation for 30 downstream reports.
Dimensional Redesign. Redesigned 12 fact tables and 40 conformed dimensions with clustering keys and slowly changing dimension types matched to how each attribute is queried, validated against 6 months of query logs, which cut average query time on the 20 most-used reports 65% and warehouse compute cost 28%.
Legacy Warehouse Migration Model. Mapped 180 legacy tables to a redesigned cloud model at a previous employer, with a lineage document for every column and a reconciliation test for every report, which delivered 100% of 220 reports matching legacy output at cutover and retired 40 redundant tables.
- Member of a data management association chapter of about 200, presenting about once a year on healthcare modeling.
- Volunteer data architect for a nonprofit clinic network, designing its reporting database.
- Guest lecturer for a university information systems course twice a year.
- Lead data modeling standards for a data team of 30 and chair the weekly model review of about 8 changes.
- Mentor 3 data modelers and 4 data engineers on dimensional design and documentation.
- Represent data modeling on the enterprise architecture board of 10.

.webp)



.webp)


%20Which%20Should%20You%20Use.webp)