Stephanie Hertl

• Developed 100+ PostgreSQL queries across 50+ AWS tables supporting data for 4.1M users. • Architected 30+ Tableau dashboards with over 400 visualizations, reducing ad hoc work 40%. • Established BigQuery for GA4 and optimized metrics, improving reporting accuracy 25%. • Resolved Airflow DAG failures, schema and refresh issues, improving ETL reliability 99%. • Configured 20+ Salesforce workflows and HubSpot integrations, improving media attribution.

• Produced 98%-clear, compliant image datasets that boosted recognition accuracy 12 - 22%. • Executed imaging at 3 - 5X throughput, delivering 500+ multi-ratio crops for rapid scaling. • Exceeded quality target by 46.5%, sustaining above average scores across 30+ evaluations. • Achieved 90% audited QA outcomes that met or exceeded expectations with low error rate. • Delivered 100% metadata accuracy, accelerating dataset growth, ingestion, and retraining.

• Scaled analytics infrastructure (dbt/GitHub) for 70+ new clients annually, netting +25% growth. • Drove data and analytics best practices during 6X company growth from 25 - 150+ employees. • Shifted data warehouse configuration to pre-sale, speeding client delivery 86% (14 to 2 days). • Oversaw 60+ client migrations, documenting DPAs, InfoSec, and Master Service Agreements. • Engineered SQL-based CRM record URLs for secure record access without PII exposure.

• Oversaw marketing data pipeline transformation for over 45 media and account managers. • Built executive report integrating $3M in spend and setting KPI benchmarks for 50+ accounts. • Leveraged SQL, regex, and case logic in BigQuery/BI tools to tailor high data volume clients. • Unified syntax, casing, and spacing logic to ensure 99% data integrity across environments. • Modeled multi-year data to forecast KPI trends with 90% accuracy on monthly goal targets.

• Managed analytics across 40+ clients, implementing reporting and attribution frameworks. • Automated multi-channel BI dashboards, accelerating stakeholder analysis time by 20% • Engineered data flows for campaigns and audiences, delivering precise marketing insights. • Implemented API authentication software automating reports, saving analysts 5 hrs. per week. • Partnered with IT and operations to automate data ingestion, improving refresh rates 30%.

• Designed workflows routing CSVs into live sheets, cutting 25 hrs/month of manual work. • Conducted query analyses revealing retention drivers, driving 2-3X conversion rate gains. • Configured CRM workflows to refresh spreadsheets, ensuring updated client metrics. • Utilized Excel formulas to transform client datasets, improving reporting accuracy and access. • Delivered monthly data briefings guiding budget realignment, improving allocation by 15%.

• Developed 25 promo, 12 service, 8 category pages, and 4 case studies to rebrand website. • Created 10 short keyword videos, deploying content through the Vzzar hosting platform. • Contributed to the content strategy and optimization plan for a major client in Maryland. • Translated, revised, and rewrote 200+ Spanish link building comments for company keywords.

• Installed 50+ header images with responsive code, call-to-actions, and design software. • Assisted in the development and execution of digital marketing campaigns. • Analyzed campaign performance and provided insights for optimization. • Created and managed content for social media and digital marketing initiatives.

• Concentration: Humanities • Achievements: Ralph Harper Fellowship Recipient, Thesis

• Concentrations: Advertising, Strategic PR, English Language & Literature, Creative Writing • Achievements: Honors College Scholarship Recipient & Graduate