Christopher J. Donalds

• Created and published daily multi-channel marketing content across 4 social media platforms, systematically tracking core KPIs to optimize distribution strategies and drive audience growth by 300% on Instagram, the company's primary client acquisition channel.
• Analyzed cross-platform performance metrics covering over 15,000 impressions to identify audience trends, translating raw content data into actionable insights that enhanced overall marketing effectiveness.

• Architected 6 interactive Power BI dashboards during an agency-wide database modernization and legacy migration, translating complex data structures into clean business intelligence for non-technical leadership across 5 regional divisions.
• Validated schema mapping and verified data integrity for over 50,000 historical records, eliminating pipeline transition errors and ensuring accurate baseline data for enterprise reporting.
• Collaborated with senior data analysts and agency stakeholders across high-impact analytical workflows to maintain operational transparency and accelerate the digital transformation of DPIE services.

• Architected a relational database schema using Microsoft Access, engineering schema updates and database patches to streamline internal data progression and facilitate regulatory approval for economic development projects across Prince George's County.
• Audited over 10,000 departmental inspection logs to identify and resolve over 200 critical data errors, eliminating processing inefficiencies and ensuring operational tracking accuracy for high-volume county inspections.
• Synthesized IT troubleshooting with data analysis, performing performance tuning and routine quality assurance to preserve database integrity across cross-functional agency workflows.

Architected a centralized data warehouse and analytics portal as a cost-effective alternative to enterprise CRM platforms for resource constrained non-profit organizations. Modeled granular donation and shift logs using SQL fact and dimension structures (dim_donors, dim_hubs, fact_donations, fact_volunteer_activity) to track multi-regional aid throughput, volunteer labor valuation, and campaign ROI.

Built an interactive analytics web portal with dynamic multi-dimensional filtering, converting raw humanitarian logistics datasets into real-time executive insights with client-side persistence and zero-downtime offline fallback capability.

Preview: Dynamic Executive KPI Scorecard Real-time metrics recalculating financial donations, active profiles, aid throughput, and volunteer labor valuations from staged CSV logs.

Preview: Ingestion & Schema Staging Engine Batch CSV processing interface with automated validation into fact_donations and fact_volunteer_activity warehouse entities.

Detailed System Visualizations & Architectural Report:

Figure 1: Multi-Tenant Access & Sandbox Gateway Enterprise authentication screen supporting isolated tenant logins and instant guest access, allowing prospective stakeholders to explore full analytics pipelines without prior onboarding.

Figure 2: Batch Ingestion & Schema Staging Engine Client-side CSV file upload interface with dynamic target entity selection (fact_donations vs. fact_volunteer_activity), automated schema type validation, and fallback handling.

Figure 3: Live Executive Analytics Scorecard Operational summary recalculating $55.5K in contributions, active donor profiles, 4,000 aid units, and $1.1K in volunteer labor value dynamically from active dataset staging.

Figure 4: Payment Channel Capital Distribution Aggregated bar visualization highlighting revenue channels, illustrating major liquidity inflows driven via Wire Transfers ($25.0K) and Direct Deposits ($25.0K).

Figure 5: Donor Retention & Regional Efficiency Radar Comparative line trends tracking recurring donors through Q4 2026 paired with a multi-axis radar score assessing fulfillment speed, inventory turnover, and volunteer capacity.

Figure 6: Multi-Hub Inventory Aid Distribution Horizontal stacked analysis categorizing medical supplies and food rations across physical facilities, led by East Region (1,500 medical, 800 food).

Figure 7: Campaign Revenue vs. Marketing Expenditure Direct ROI comparison benchmarking gross returns against allocated marketing budgets across initiatives (e.g., Spring Relief netting $28,000 against a $3,500 budget).

Figure 8: Fact Donations Granular Financial Ledger Itemized record viewer querying underlying transactional rows directly from fact_donations, featuring live client-side text filtering and multi-column searches.

Figure 9: Volunteer Activity Log & Labor Valuation Engine Granular activity logs calculating volunteer hours and economic capital contributions using the Independent Sector $31.80/hr benchmark for grant auditing and board reporting.

Figure 10: Automated Executive Findings & Decision Support Algorithmic reporting engine converting dynamic filter states and calculated totals into plain-English liquidity findings and human capital operational summaries.

Figure 11: Multi-Tenant Architecture & Configuration Administrative control panel verifying organization tenant isolation, warehouse schema assignments, database connectivity drivers, and profile credential management.

Engineered and modeled an enterprise graph database using Neo4j and Cypher Query Language based on a multi-dimensional Spotify music catalog. Scaled the relational architecture to 190,551 total nodes and 471,780 directional relationships, establishing high-performance indexing for multi-hop graph traversals.

Designed analytical queries to model artist collaboration clusters, isolate cross-genre versatility metrics, evaluate track explicit vs. clean popularity distributions, and audit database integrity to detect catalog compilation anomalies.

Preview: Multi-Hop Artist Subgraph Traversal Graph query traversal evaluating Taylor Swift node dependencies across 19 individual tracks and 8 interconnected genres.

Preview: Artist Co-Performance Network Mesh Relational traversal resolving bidirectional collaboration structures across 437 artists and 563 co-performed tracks.

Graph Database Execution & Cypher Validation Audit:

Figure 1: Global Relationship Volume Verification Cypher query execution (MATCH ()-[r]->() RETURN count(r) AS NumRelationships) validating 471,780 indexed directional relationships streamed in 93 ms.

Figure 2: Catalog Node Infrastructure Volume Cypher query execution (MATCH (x) RETURN count(x) as NumNodes) confirming 190,551 total nodes (spanning Track, Album, Artist, and Genre entities) streamed in 130 ms.

Figure 3: Artist Multi-Hop Network Traversal (Taylor Swift) Traversal path isolating 28 total nodes (1 Artist, 19 Tracks, 8 Genres) connected across 38 relationships (19 PERFORMED, 19 BELONGS_TO) revealing cross-genre versatility into folk, punk, country, and dance.

Figure 4: Cross-Genre Versatility Query (Genre Count > 3) Subgraph isolating 35 versatile artists spanning 55 distinct genres and 910 tracks, reaching the initial 1,000 node visualization limit across 1,850 relationships.

Figure 5: Bidirectional Artist Collaboration Network Multi-edge graph traversal isolating two-way musical collaborations across 437 artists sharing 563 co-performed tracks across 1,212 directional edges (featuring Alan Walker, A$AP Rocky, Alok, and Avicii).

Figure 6: Data Validation & Compilation Artifact Detection Tabular aggregation exposing metadata anomalies where multiple artists were assigned identical compilation album listings ("Alternative Christmas 2022") with 195 track counts and 0.0 average popularity scores.

Figure 7: Explicit vs. Clean Audio Track Popularity Matrix Comparative evaluation by genre showing acoustic tracks with clean lyrics holding higher popularity (43.15 vs. 30.35), while alt-rock and ambient tracks demonstrated higher average popularity when tagged explicit.

Developed a multi-tier database desktop application engineered with a decoupled 3-tier architecture (Presentation Layer, Data Layer, and Object/Domain Layer) using Java Swing and a local MySQL backend. The system centralizes academic partnerships and bridges communication gaps by securely connecting faculty, students, and research collaborators.

Architected robust relational schemas with foreign-key constraints enforcing referential integrity, programmed parameterized JDBC statements to defend against SQL injection, and integrated SHA-256 cryptographic password hashing with user authentication. Designed flexible search routines enabling case-insensitive, keyword-based research matching across academic abstracts and research interests.

Preview: Role-Based Student Portal Interface Interactive dashboard providing authenticated students access to query faculty research abstracts, modify personal research interests, and run matching algorithms.

Preview: Dynamic Abstract & Publication Browser Scrollable multi-record viewing pane executing normalized relational joins across publication entities to display faculty titles, co-authors, and research summaries.

Java Swing Client Workflow & Database Transactions:

Figure 1: Secure JDBC Database Handshake Dialog Initial system gateway capturing localized database host credentials, utilizing dynamic runtime connection pooling through the MySQL Connector/J driver.

Figure 2: Primary Application Navigation Router Centralized routing menu offering radio-button state selection between user authentication, new user registration, and clean database connection termination.

Figure 3: Secure Role-Based User Authentication Input validation module passing credential hashes through a SHA-256 cryptographic pipeline to verify credentials against stored records in the Account table.

Figure 4: Multi-Field Student Profile Onboarding Data entry dialog enforcing validation on usernames, hashed passwords, contact emails, and phone numbers prior to executing transactional SQL `INSERT` statements.

Figure 5: Authenticated Student Services Menu Personalized session view greeting the active user and providing direct access to view publications, update individual interest matrices, and perform faculty matching.

Figure 6: Relational Faculty Abstract Retrieval Java Swing multi-line text viewport displaying parsed relational query results, linking authors, publication types, and project descriptions.

Figure 7: Master Academic Interest Directory Information dialog querying 20 standardized technology disciplines (AI, Blockchain, Robotics, Quantum Computing) to guide student-faculty research matching.

Co-developed Terroir, an end-to-end wine logging, cellar inventory, and consumer analytics platform combining a responsive web portal (HTML/PHP/CSS) with an administrative Java Swing desktop client connected to a shared MySQL transactional database. The system bridges daily personal tasting records with commercial cellar analytics, tracking varietals, regions, producers, and consumption frequencies.

Designed the normalized relational database schema (Project_Database) enforcing primary/foreign key relationships across Users, Beverages, Tasting Entries, Flavors, Liquor Stores, and Inventory entities. Implemented bcrypt/hashed password security, transaction auditing, and custom administrative CRUD interfaces allowing database administrators to inspect tabbed tables, insert structured records, and manage account lifecycles.

Preview: Terroir Consumer Web Portal Authentication Modern client authentication interface allowing registered cellar members to securely log in and access custom tasting journals and inventory trackers.

Preview: Multi-Table Administrative GUI Explorer Java Swing administrative desktop dashboard querying live relational tables across Users, Beverages, Tasting Entries, Store Inventory, and Follow Relationships.

Full-Stack Web & Java Swing Database Management Architecture:

Figure 1: Relational DDL Schema Architecture (Project_Database.sql) Structured MySQL schema definition defining core entities including Users (with UUIDs, unique email/username constraints, and timestamps) and Beverages (tracking ABV decimals, regions, and vintages).

Figure 2: DB Explorer Administrative Dashboard Centralized Java desktop control panel providing database administrators quick access to connect to data sources, inspect live tables, execute inserts, and perform record deletions.

Figure 3: Multi-Entity Tabbed Database Record Viewer Interactive multi-tab data browser querying normalized relational records across 14 tables including Users, Advertisements, UserMembership, StoreInventory, and Consumption Trackers.

Figure 4: Dynamic Administrative Insert Module Entity selector routing administrators to custom input dialogs, enforcing field validation and membership status bit flags prior to executing SQL INSERT operations into the Users table.

Figure 5: Entity Deletion & Referential Integrity Safeguard Controlled record removal interface allowing administrators to purge records by unique primary keys (such as userID) while preserving relational referential integrity.

Figure 6: Terroir Personal Wine Journal Web Authentication Clean, responsive web frontend developed in HTML and CSS, providing cellar members entry to their digital tasting notes with backend authentication routed through PHP.

Figure 7: Member Registration & Address Validation Portal Comprehensive consumer onboarding form capturing contact details and geographic cellar coordinates (Rochester, NY) for localized wine availability and inventory recommendations.

Analyzed sales, item production, and localized survey data across regional retail networks using PowerBI and Excel to diagnose revenue plateaus and optimize employee commission thresholds.

Constructed a corporate performance measurement framework establishing key sales per labor metrics and item mix optimization rules to target a >63% sell-through rate across Store 402 and regional store footprints.

Preview: Employee Commission Benchmark Audit Two-week rolling sales audit of 20 producers at Store 402, evaluating commission achievement under current ($7K) and proposed ($8K) pay period thresholds.

Preview: Optimal Item Mix & Pricing Strategy Correlation analysis mapping item categories against gross revenue and quantity sold, establishing high-yield production targets.

Retail Intelligence Dashboard & Diagnostic Findings:

Figure 1: Bi-Weekly Employee Sales Performance & Bonus Threshold Audit Itemized two-week sales audit for 20 active producers at Store 402. Data proved that only 6 of 20 workers hit the existing $7,000 commission threshold, demonstrating that the planned $8,000 increase would penalize frontline staff unless paired with category coaching.

Figure 2: Optimal Mix Modeling via Benchmark Producer (ID: 4110000096) Granular product mix profiling of top-tier producer generating $29.17K in Sept and $32.52K in Oct. Identified that prioritizing high-ticket, high-velocity goods (Shoes generating $21.8K across 3.2K units) significantly boosts individual producer output.

Figure 3: Production vs. Sales Volume Distribution by Department Comparative department throughput breakdown across 161.31K produced items and 88K sold units. Shows operational concentration in Apparel (40.19% produced vs. 39.06% sold) and Wares (39.01% produced vs. 39.59% sold), identifying inventory bottlenecks in secondary departments.

Figure 4: Core Department Sell-Through Rate Scorecard Evaluated sell-through percentages across major departmental categories, uncovering strong volume in Wares (57.64% on 62.93K produced) and Apparel (51.47% on 64.83K produced), while Books lagged at 45.06% (8,035 sold of 17.83K produced).

Figure 5: Sell-Through Rate Tiering & Inventory Over-Production Diagnosis Multi-tier inventory classification (Low: 0-33%, Medium: 33-66%, High: 66-100%) revealing an overall store sell-through rate of 54.86%—nearly 10% below the executive target of 65%. Highlighted severe overproduction in women's swim/camis while shoes (76.59%) and men's jeans (79.18%) excelled.

Figure 6: Community Brand Awareness & Outreach Marketing Survey Analytical evaluation of customer awareness surveys revealing critical promotional gaps: 78.26% of respondents only discovered Goodwill through word of mouth, 60.87% were unaware of special 15% discount days, and 73.91% were unaware of the Rewards program.

Evaluated a multi-decade box office performance dataset comprising top-grossing PG-13 film releases from 1980 to 2024 using Python and Advanced Excel pivot aggregations. Analyzed historical release trends across distribution eras (Modern Era, Digital Age, Early 2000s, 80s-90s) to identify commercial partnership candidates and forecast merchandise demand.

Developed actionable brand partnership guidelines for consumer merchandise partnerships, identifying Walt Disney Studios as the dominant revenue driver with over $12.8B in Modern Era gross ($10.6B in Action Sci-Fi). Synthesized genre clusters and release window trends to maximize campaign ROI and mitigate IP licensing risks.

Preview: Lifetime Gross Performance by Cinematic Era Pivot evaluation identifying the Modern Era (2011–2024) as the highest-grossing period with $34.7B, led by Walt Disney Studios generating $12.8B.

Preview: Genre Revenue & Franchise Loyalty Distribution analysis establishing Action Adventure Sci-Fi/Fantasy franchises as premier targets for consumer apparel and brand deals.

Box Office Market Intelligence & Studio Benchmarking:

Figure 1: Lifetime Gross Generation by Cinematic Era & Studio Comparative historical breakdown revealing the Modern Era (2011–2024) generated the highest lifetime gross ($34.7B), outpacing the Digital Age ($16.4B). Walt Disney Studios dominated Modern Era distribution with $12.8B, followed by Warner Bros. ($6.65B) and Sony Pictures ($3.84B).

Figure 2: Executive Decision Model & Partnership Strategic Brief Strategic synthesis recommending prioritized brand licensing partnerships with Walt Disney Studios for Modern Era Action Sci-Fi titles ($10.63B gross). Outlines risk mitigation, omnichannel distribution channels (DTC vs. Target/Walmart), and audience retention factors.

Figure 3: Genre Yield Breakdown & Franchise Merchandise Viability Dual-metric visualization benchmarking Lifetime Gross against Average Yearly Revenue across genre sub-clusters. Identifies high franchise loyalty and recurring box office velocity in Action Adventure Fantasy Sci-Fi (e.g., Avatar, Spider-Man, Star Wars).

Figure 4: Comprehensive Studio Distributor Matrix (1980–2024) Multi-variable matrix aggregating Average Yearly Revenue and Lifetime Gross across major Hollywood studios. Confirms Walt Disney Studios leading overall performance with $15.10B in total lifetime gross ($3.07B average yearly revenue) across all analyzed eras.