Solutions Engineer with 6+ years’ experience driving global ad tech revenue and innovation. Expert in architecting and deploying data solutions (SQL, Python, AWS), impacting $200M+ portfolios and fueling 25% revenue growth. Developed tools cutting processing time by 40%. Proven leader translating data insights into high-impact business outcomes and client satisfaction.

Skills

Ad Technology & Revenue Optimization

  • Ad Serving (Google Ad Manager 360, FreeWheel)
  • Programmatic Advertising
  • Header Bidding/Prebid.js
  • First-Party Data Strategy
  • Audience Targeting
  • Cookieless Solutions
  • Revenue Attribution
  • Yield Optimization
  • Programmatic Strategy

Data, Analytics & Visualization

  • Advanced SQL
  • BigQuery
  • AWS (S3, Athena, Glue)
  • dbt
  • ETL/ELT Pipelines
  • Data Modeling
  • A/B Testing
  • Looker
  • Power BI
  • Python
  • Tableau
  • Data Storytelling
  • Technical Problem Solving

AI, Automation & Development

  • Python
  • Docker
  • LangChain
  • LLM Integration
  • Prompt Engineering
  • CI/CD Pipelines
  • REST APIs
  • Semantic Modeling
  • RAG Applications
  • Embeddings
  • GraphQL
  • Vector Databases

Business, Leadership & Project Management

  • Agile Methodologies
  • Client Solutions
  • Cross-Functional Leadership
  • Data-Driven Decision Making
  • Stakeholder Management
  • Strategic Partnerships
  • Salesforce
  • JIRA/Confluence
  • Project Management

Work Experience (7)

Dec 2023 - Current
Founder, Generative AI Developer & Consulting
.contexts LLC
 New York, NY https://www.linkedin.com/company/patrickcarmichael-io-llc/
Founded .contexts LLC to formalize generative AI and workflow automation development. Built custom tools across media, ad tech, and analytics projects. Focused on semantic data pipelines, Python + Docker deployments, and custom AI interfaces to streamline operations for clients and internal R&D. Passionate about leveraging advanced AI to solve real-world operational challenges.
  • Developed custom Python automation scripts that reduced data processing time by 30% in personal analytics projects
  • Built an AI interface prototype integrating GPT with structured data, resulting in a 25% increase in client satisfaction scores and expediting project delivery by 20%
  • Implemented modular code architecture that improved project maintainability and reduced development time for subsequent projects by 25%, leading to accelerated client implementations
  • Designed and executed an end-to-end data workflow solution used daily by clients, automating tasks from data extraction to visualization and increasing efficiency by 40%
May 2024 - Nov 2024
Solutions Engineer
Burt Intelligence
 New York, NY https://www.burt.ai/
Provided comprehensive solutions engineering support for ad tech clients, optimizing data workflows and integrations.
  • Resolved 95% of client platform integration and reporting issues within 24 hours—examples include troubleshooting missing revenue data in Confluence configs, debugging JSON API endpoints, and writing Athena SQL queries to quickly surface client analytics discrepancies
  • Optimized data workflows in AWS S3, achieving a 30% reduction in manual intervention and ensuring seamless exports to BigQuery for real-time analytics
  • Built customized API integrations and robust data scraping solutions, which cut external data onboarding times by more than 40% and enhanced dashboard delivery for clients
  • Led production pushes and coordinated with engineering teams via Jira, ensuring zero downtime for nightly data migrations and seamless feature deployments
  • Implemented standardized documentation protocols and knowledge base articles, reducing onboarding time for new team members by 40% and improving cross-team collaboration
May 2023 - Nov 2023
Global Pricing & Inventory Analyst
Bloomberg
 New York, NY https://www.bloomberg.com/
Managed ad inventory, rate cards, and pricing strategies across Bloomberg's digital platforms, optimizing revenue and client solutions.
  • Managed premium inventory allocations across Bloomberg Terminal, Web, TV, and Radio properties, representing $30M in quarterly advertising revenue
  • Increased deal closure rates by 22% by refining pricing strategies and collaborating with sales & BI teams
  • Optimized pricing models for financial services vertical during 2023 market volatility, protecting 15% higher CPMs compared to industry benchmarks
  • Developed automated dashboards in SQL, Datorama, and Tableau, improving efficiency by 30%
  • Worked with senior leadership to develop and implement AI-driven generative tools that automated lead qualification and email outreach, reducing sales cycle times by 18% and boosting funnel conversions
Jun 2022 - Jan 2023
Revenue Lead, Large Partner Solutions
Google
 New York, NY https://www.google.com/
Led publisher relationships to optimize ad revenue and yield management for Google's large partners.
  • Led 15+ publishers, optimizing yield and achieving 25% revenue growth on a $200M+ portfolio
  • Designed automated revenue analytics pipelines, saving 2+ hours per week and impacting $5M+ in quarterly revenue
  • Mentored a Digital Marketing Apprentice, teaching advanced programmatic yield analytics, dashboard design, and client-facing communication strategies, directly contributing to their full-time hiring in Google's Marketing Group
  • Led 4+ DEI & LGBTQ+ initiatives, resulting in increased employee resource group participation by 30% and launching the company's first virtual Pride panel series
  • Delivered programmatic expertise cross-functionally across Google on implementation & strategy
  • Leveraged data-driven insights to optimize sales for Google ad products internally, saving colleagues 2+ hours weekly and improving campaign ROI
Jul 2018 - Jun 2022
Sr. Digital Platforms & Pricing Analyst
Paramount
 New York, NY https://www.paramount.com/
Managed programmatic partnerships, yield optimization, and analytics for Paramount's digital properties.
  • Increased programmatic ad revenue by 50% YoY, generating $25M+ in profits through yield optimization
  • Managed 50+ programmatic partners, boosting fill rates by 28% across Viacom, CBS, and PlutoTV
  • Led cross-platform analytics integration during Viacom-CBS merger, creating unified reporting dashboards that drove $8M in previously unidentified revenue opportunities
  • Pioneered Connected TV monetization strategies during streaming growth acceleration (2020-2021), such as launching audience-based CTV packages that increased CTV revenue 40% YoY and set a new record for impressions sold during the 2021 Olympics
  • Designed an audience segment taxonomy system connecting first-party data across Paramount's digital ecosystem, improving targeting precision by 35% and increasing CPMs by $1.75 on affected inventory
  • Developed live SQL-powered dashboards, resulting in 65% greater data visibility and enabling revenue managers to identify and act on optimization opportunities within 48 hours
Jan 2013 - May 2016
Honors Peer Advising Coordinator
University of Massachusetts Amherst
 Amherst, MA https://www.umass.edu/honors/
Co-led the Peer Advising Program within the Bloom Honors Advising Center, managing team operations and advising curriculum development.
  • Directed weekly meetings and office operations for a team of thirteen student leaders, overseeing programs that served more than 600 students per semester
  • Implemented standardized student advisor training program that increased advisor retention rates by 40% and improved student satisfaction scores from 3.2/5 to 4.6/5
  • Managed scheduling and operations for 300+ weekly student advising appointments, maintaining 98% on-time meeting rate while coordinating across 5 academic departments
Jun 2007 - Apr 2016
Customer Service Department Head & Cash Office Lead
Stop & Shop Supermarket
 Marstons Mills, MA & Northampton, MA https://stopandshop.com/
Progressed from entry-level cashier to department management, overseeing both front-end operations and cash office accounting functions while maintaining full-time academic studies. Managed one of the store's highest-responsibility areas at a young age.
  • Supervised and scheduled 20+ front-end associates, optimizing staffing during $250K+ daily sales periods
  • Managed cash office operations, balancing and accounting for $30K-50K in daily transactions with zero discrepancies
  • Maintained 98% customer satisfaction rating while handling 100+ customer service interactions daily
  • Reduced checkout wait times by 25% through implementing real-time lane management, predictive scheduling, and rapid response protocols for bottlenecks
  • Trained and mentored 40+ new employees on POS systems, company policies, and customer service standards
  • Implemented cash handling procedures that reduced register variances by 30%
  • Balanced this high-responsibility role while maintaining Dean's List academic performance

Projects (3)

Custom AI Interface & Pipeline Development
Dec 2023 - Current
  • Generative AI
  • Python
  • Docker
  • LangChain
  • Automation
  • Semantic Modeling
  • Ad Tech
  • Workflow Automation
Developed custom AI interfaces and semantic data pipelines using Python, Docker, and advanced generative AI (including LangChain and semantic modeling) to automate ad tech workflows and enhance analytics for clients and internal R&D.
  • Reduced end-to-end data processing time by 40% via optimized pipelines using semantic knowledge structures and RAG applications
  • Created intuitive AI interfaces that increased client adoption by 25%, with several clients integrating the system into their core analytics stack
  • Integrated new solutions with existing ad tech systems with minimal disruption, resulting in fast time-to-value for enterprise pilot projects
Revenue Analytics Pipeline (Google)
Jun 2022 - Jan 2023
  • Analytics
  • Automation
  • Revenue Optimization
  • BigQuery
  • SQL
  • Google Cloud Platform
Designed and deployed automated revenue analytics pipelines with Google Cloud tools, saving 2+ hours per week in manual reporting and providing real-time alerts for revenue anomalies, directly enabling $5M+ in quarterly optimization actions.
  • Automated recurring reporting processes, improving efficiency by 30% and eliminating over 8 labor hours per month
  • Developed real-time anomaly detection alerts, which identified data discrepancies and campaign underperformance within minutes—allowing rapid intervention and minimizing lost revenue opportunities
  • Trained team members on pipeline maintenance and best practices, ensuring pipeline continuity and flexibility
SQL-Powered Dashboard Suite (Paramount)
Jul 2018 - Jun 2022
  • SQL
  • Dashboards
  • Data Visualization
  • Tableau
  • Ad Tech
Developed analytics dashboards using SQL and Tableau, increasing data visibility by 65% for 5M+ daily ad impressions and empowering revenue managers to identify new opportunities and optimize campaigns within 48 hours.
  • Created a centralized reporting suite that replaced siloed systems, streamlining data access for 30+ stakeholders
  • Implemented dynamic filtering and executive insights, which led to the identification of $8M in new revenue streams post-merger
  • Designed automated KPI/alerting system, directly supporting revenue decision-making in weekly strategy sessions

Volunteer

7/1/2018 - 1/31/2023
Leader
LGBTQ+ Initiatives
Led DEI & LGBTQ+ initiatives across multiple companies to foster workplace inclusion and advance equality.
  • Launched Google's first virtual Pride panel series, raising awareness for LGBTQ+ employees across three offices and influencing new inclusive benefits policies
  • Served as LGBT Education Chair on EMERGE Executive Board at Viacom, producing campaigns that reached over 500 employees and sparking a permanent cross-brand partnership with GLAAD
  • Executed 12+ corporate partnerships with organizations like GLAAD & ACLU, supporting community education and legal advocacy
9/1/2016 - 5/31/2018
Volunteer
Center for Economic Research and Social Change
 https://cersc.org/
Organized finances for fundraising events and supported initiatives for underrepresented communities.
  • Organized finances for fundraising events that generated $5000 for the 501(c)3
  • Worked to amplify voices of minority groups within local and national communities

Education (1)

- Current
BBA
 Operations & Information Management, Information Technology
UMass Amherst, Isenberg School of Management, Commonwealth Honors College
  • Advanced Business Intelligence & Analytics (foundation for all major analytics and dashboard projects in career)
  • Information & Project Management (applied in large-scale cross-functional project delivery at Google and Paramount)
  • Business Processes & Enterprise Systems
  • Database Design & Implementation (directly relevant to data modeling/SQL pipeline work at Paramount and Burt)
  • Business Policy and Strategy

Awards

2018
Best Deliverables - Data Visualization, Tableau
OIM Department, UMass Amherst
Awarded for top-ranking data visualization project analyzing key film success factors using the TMDB dataset, recognized among 40+ student projects
2018
SAP Student Recognition Award
UMass Amherst
Recognition for demonstrated depth and breadth of SAP ERP system knowledge; top 5% in ERP simulation competition
2018
Dean's List
UMass Amherst
Awarded continuously throughout enrollment (All Semesters); maintained 3.66 GPA while balancing leadership and employment

Certificates

2023-05
Python Code in Place Scholar
Stanford University
 https://codeinplace.stanford.edu/

Languages

English

Native Speaker

Interests

Ad Technology & Digital Media Innovation

  • Connected TV Ecosystems
  • Retail Media Networks
  • First-Party Data Strategies
  • Header Bidding Optimization
  • Social Commerce Integration

Data Science & Machine Learning

  • Custom Interactive Dashboards
  • Predictive Analytics in Ad Performance
  • Semantic Search & Vector Databases
  • NLP for Content Analysis

Cloud Computing & Infrastructure

  • Data Lakes & Warehouses
  • Real-time Data Processing
  • Serverless Architectures

AI Ethics & Responsible Tech

  • Algorithmic Bias in Ad Targeting
  • Ethical Data Collection and Usage

Personal Pursuits

  • Canine Companionship
  • Quantified Self
  • Scuba Diving
  • Urban Exploration