Portfolio

Case Studies

Active contracts. Multi-year partnerships. Enterprise deployments. Much of our work lives behind NDAs and firewalls — these studies document real challenges, documented approaches, and measurable outcomes.

Atlanta Public Schools · City of Atlanta Parks & Recreation

Youth STEAM Education — 7+ Years of Active Contracted Programming
Our longest and most active engagement — delivering coding, robotics, dance, digital arts, and garment-making programs to 2,500+ students across Atlanta schools and recreation centers as a certified APS vendor.
2,500+
Students Served
7+
Years Active

Education

The Engagement
1st Evolution Arts holds active contracts with both Atlanta Public Schools and the City of Atlanta Parks & Recreation to deliver STEAM-based after-school programs, summer camps, and in-school programming. Over 7 years, we’ve built a curriculum that bridges technology and the arts to develop real skills in youth ages 4–18. Each program is facilitated by trained instructors with a max 1:12 teacher-student ratio to ensure genuine impact.
Programs Delivered
  • Coding: HTML, Scratch, WordPress (Word To Code)
  • Robotics: MakeyMakey circuit + programming (ages 8+)
  • Dance: Ballet, Jazz, African, Creative Movement
  • Garment Making & Fashion Design
  • Digital Citizenship (Techtastic™ Designers)
  • Tech & Arts Fusion — STEAM + yoga + ballet
  • Summer camps: coding, robotics, cultural immersions
Outcomes & Impact
  • 2,500+ students served worldwide across programs
  • Certified vendor status with APS maintained 7+ consecutive years
  • Active Parks & Rec programming across Atlanta recreation centers
  • Students producing websites, apps, choreography, and garments
  • Programs aligned to municipal curriculum requirements
  • Parallel nonprofit (Evolution Arts Inc.) supports BIPOC communities
Youth on MakeyMakey
Coding / HTML / Scratch
MakeyMakey Robotics
Dance Instruction
Garment Making
STEAM Curriculum

Pennsylvania DOT · Maryland DOT

Driver Licensing Technology Platform (DL Testing App 1.0 + CDL Testing App 2.0)
A mobile-first solution modernizing how Pennsylvania conducted and graded driving license examinations — then licensed and deployed by Maryland, proving the platform’s cross-agency scalability and compliance posture
1M+
Users Served
2
States Deployed
Government
The Challenge
Pennsylvania relied on paper-based processes for driving exams — inefficient, error-prone, and unscalable. The Commonwealth needed a secure, field-ready iPad solution deployable across distributed testing sites statewide, meeting state compliance and accessibility requirements.
Our Approach
  • Requirements gathered directly from PennDOT program stakeholders
  • iPad-native iOS app with offline capability for field examiners
  • DL Testing App 1.0 for standard licenses; CDL Testing App 2.0 for commercial
  • Grading logic, session persistence, and secure state backend data transmission
  • Architecture documented for cross-agency licensing portability
The Outcome
  • Statewide adoption by Pennsylvania for CDL and DL examinations
  • Architecture proven portable: Maryland DOT licensed and deployed
  • Examiner workflows digitized with real-time grading and record capture
  • Compliance-ready documentation enabled fast approval in second state
iOS / iPad
Swift / Obj-C
SQLite
RESTful API
Core Data

Pennsylvania DOT · Maryland DOT

Driver Licensing Technology Platform (DL Testing App 1.0 + CDL Testing App 2.0)
A mobile-first solution modernizing how Pennsylvania conducted and graded driving license examinations — then licensed and deployed by Maryland, proving the platform’s cross-agency scalability and compliance posture
1M+
Users Served
2
States Deployed
Government
The Challenge
Pennsylvania relied on paper-based processes for driving exams — inefficient, error-prone, and unscalable. The Commonwealth needed a secure, field-ready iPad solution deployable across distributed testing sites statewide, meeting state compliance and accessibility requirements.
Our Approach
  • Requirements gathered directly from PennDOT program stakeholders
  • iPad-native iOS app with offline capability for field examiners
  • DL Testing App 1.0 for standard licenses; CDL Testing App 2.0 for commercial
  • Grading logic, session persistence, and secure state backend data transmission
  • Architecture documented for cross-agency licensing portability
The Outcome
  • Statewide adoption by Pennsylvania for CDL and DL examinations
  • Architecture proven portable: Maryland DOT licensed and deployed
  • Examiner workflows digitized with real-time grading and record capture
  • Compliance-ready documentation enabled fast approval in second state
iOS / iPad
Swift / Obj-C
SQLite
RESTful API
Core Data

WarnerMedia · Content & Marketing Analytics

Digital Asset Automation & Content Intelligence Platform
Eight years of embedded engineering at one of the world’s largest media companies — building the automation infrastructure and analytics views that powered real-time content decisions across a $5M+ content revenue pipeline.
200K+
Assets/Year
60%
Time Reduction
Technical
The Challenge
At WarnerMedia’s scale, manual media workflows created bottlenecks across content processing, marketing analytics, and programming decisions. Leadership needed real-time visibility into a $5M+ content pipeline without waiting for manual reporting cycles.
Our Approach
  • SQL Server performance views enabling real-time content analytics
  • Automation systems processing 200K+ digital assets annually
  • T-SQL stored procedure refactoring to eliminate redundancy
  • Partnered with Programming & Marketing for rapid analysis delivery
  • Alerting and monitoring infrastructure supporting $1M+ in savings
The Outcome
  • 60% reduction in manual processing time for digital asset workflows
  • Real-time analytics enabling live programming and campaign changes
  • $5M+ in content contracts supported through reliable, audit-ready data
  • $1M+ in operational savings via automation, sustained over 8 years
ASP.NET MVC
C#
SQL Server
T-SQL
ETL

dentsu X · Analytics & Strategy

Enterprise Analytics Modernization & Database Migration
Led a full warehouse migration and simultaneous delivery of predictive campaign models — 35% query speed improvement and +9% sales QoQ without service disruption to any downstream team.
+9%
Sales QoQ
35%
Query Speed ↑
Analytics
The Challenge
dentsu X’s analytics infrastructure was scaling beyond PostgreSQL’s capacity. Simultaneously, campaigns lacked the predictive modeling and attribution rigor to demonstrate ROI. The team needed a new warehouse, new models, and governance — all without disrupting live reporting.
Our Approach
  • PostgreSQL → IBM Cloud DB2 migration with zero service interruption
  • Schema and query architecture redesigned for DB2 optimization
  • Python/SQL predictive models for campaign targeting and spend
  • Tableau Server governance deployed across 100+ users
  • Data intake/prioritization SLAs established for 5-person team
The Outcome
  • +9% sales QoQ and +7% coupon downloads through improved targeting
  • 35% improvement in query performance post-migration
  • Standardized metrics and governance across all client accounts
  • Predictive models still informing campaign strategy post-engagement
SQL Server
T-SQL
SSIS
Tableau
Power BI

dentsu X · Analytics & Strategy

Enterprise Analytics Modernization & Database Migration
Led a full warehouse migration and simultaneous delivery of predictive campaign models — 35% query speed improvement and +9% sales QoQ without service disruption to any downstream team.
+9%
Sales QoQ
35%
Query Speed ↑
Analytics
The Challenge
dentsu X’s analytics infrastructure was scaling beyond PostgreSQL’s capacity. Simultaneously, campaigns lacked the predictive modeling and attribution rigor to demonstrate ROI. The team needed a new warehouse, new models, and governance — all without disrupting live reporting.
Our Approach
  • PostgreSQL → IBM Cloud DB2 migration with zero service interruption
  • Schema and query architecture redesigned for DB2 optimization
  • Python/SQL predictive models for campaign targeting and spend
  • Tableau Server governance deployed across 100+ users
  • Data intake/prioritization SLAs established for 5-person team
The Outcome
  • +9% sales QoQ and +7% coupon downloads through improved targeting
  • 35% improvement in query performance post-migration
  • Standardized metrics and governance across all client accounts
  • Predictive models still informing campaign strategy post-engagement
SQL
Operations Analytics
Route Optimization
Reporting