Alexander Somer

Alexander Somer

Manager of Data · Gain Theory

North Miami Beach, FL

In My Own Words

Work Experience

Manager of Data

Gain Theory

2022 – 2024

Ensure maintenance of database for CPG clients. Build out ETL processes for data collection. Design processes to aggregate and model large data sets across numerous channels both digital and linear. * Oversee the development of processes to create full-stack systems for the security and usability of our clients' data. Used Snowflake and Datorama (SalesForce Marketing Intelligence program) to organize data for business cases and dashboard creation. Engineered queries and backend processes to ensure consistent data and efficiency. * Manage data modeling projects (called Sensor) that involved deep-diving into developer portals, API troubleshooting, enhanced ETL building, and Snowflake processes for easy handoff of data to modeling team. Work with analysts to complete project and prepare for the client presentations - discussing business implications, strategy, and implementation. * Nurture and grow analyst level team members by teaching, being open, and imparting knowledge. Get into the data with them and provide guidance to complete client projects. Learn quickly myself to gain mastery of the Gain Theory suite of products.

Manager of Measurement and Analytics

Havas Media Group

2021 – 2022

Oversee team of data analysts and measurement specialists for insurance industry client. Develop and manage AWS Redshift database. Model client data for different business use-cases. Provide business and marketing recommendations based of measurement results. Deliver model output to executive level client audiences * Manage a team of three analysts and specialists to deliver all levels of reporting for client's six lines of business. Use data modeling techniques (regression, chi-square, lift analysis) to provide meaningful insights to client for purpose of growing business and developing new marketing mix strategy. Give daily support on creation of client facing reports. Deliver findings to executives within client organization in weekly and monthly readouts * Develop back-end queries for data feeds into AWS Redshift database. Troubleshoot all issues related to the data quality and database structure. Optimize ETL structure and relationship tables for efficient joining and appending of data. Connect database to dashboard platforms - including Tableau, Qlik, and Google Data Studio. * Provide support on enterprise business strategy based off results of models across all of client's lines of business - bundling opportunities, call center optimization, telephony and CRM implementation, and demographic targeting enhancement

Senior Media Manager

OMNI DIRECT

2019 – 2019

Analysis on all client media spend sales and demographic data. Recommend media spend allocation on Spanish language TV. Manage weekly budgets between $15K and $600K for a dozen clients. Build out usage on media platform. * Managed a team of four media buyers and client liaisons. Instructed team in media buying efficiency and strategy implementation. Lead weekly scrums to collaborate on current projections * including creative concepts, new outlets to test, and updated reporting techniques. * Analyzed millions of rows of consumer trend, sales, media spend, and demographic data on many levels - CPC, CPA, sales predictive modeling, trendlines, demographic performance, industry analysis, DMA analysis. Created weighted scoring to identify top performers for all clients. * Updated reporting using Tableau for data visualization. Created dashboards for clean reporting and ease of use for client liaisons. Streamlined reporting process by connecting media platform (InfoTech MMS) to backend of Tableau using a custom API.

Senior Manager Performance Marketing

HOLADOCTOR

2018 – 2018

Manage, oversee, and strategize all facets of lead acquisition for a nationally present health and life insurance brokerage, and internationally present health and wellness website in Spanish. Manager and query 10MM record database of website traffic (HolaDoctor.com and subpages) and Book of Business. Consult on implementation of SalesForce * Managed a team of six marketing specialists across various social media, paid search, and terrestrial marketing platforms. Designed the contact strategy and sales funnels for each medium to ensure optimum benefit from each marketing tool. Team members are to report on daily KPI so quick changes can be made. Through this strategy, CPA for insurance policies went down 20% and website traffic increased 16%. * Implemented new database structure for more efficient querying and reporting. Designed the schema of relational tables with keys to join every website user to the content being read, policies being purchased, and marketing platforms engaged with. Allowed for transparency of consumer journey from first interaction to cross-sell purchases. Data aggregation time decreased 41%. * Collaborated with the IT Department to create inbound and outbound call distribution with a call center of 30+ agents. Missed call percentage went from 45% down to 3% through the implementation of a new distribution and call prioritization configuration. Both management and agent pool were benefited by the changes

Marketing Manager

PROGRESSIVE MEDICAL CENTER

2017 – 2018

Manage and build Marketing Department for family of Integrative Medicine Clinics. Allocate budget to increase efficiency of marketing mix regarding patient acquisition. Analyze data sets across multiple channels to make real-time marketing decisions * Managed a team of five to perform all tasks related to Marketing for Progressive Medical Center across the entire marketing funnel (impressions to new patients). Tasks included: managing an annual budget of over $1MM by analyzing data across all marketing channels; running tests on new media platforms, creative, audiences, and messaging; implementing and overseeing CRM, Marketing Automation, Relational Database, Reputation Management, and Digital Telephony systems. * Created CPM-centered models to allow for apples-to-apples comparisons of efficiency for marketing channel budget allocation. Used granular buckets of audiences' sizes by platform (SEM, social media paid content, programmatic trade, TV stations, radio stations, OOH, print) to calculate demographically and effectively adjusted CPMs based on age, gender, and household income figures plus a ratio of reach vs cume. * Designed and executed tests across all platforms. Tests included messaging, call-to-actions, design schemes, themes, comparably priced flights, cross-media performance, and promotions. Used results of tests to optimize marketing mix - KPI that holds the most weight is conversions of leads into new patients

Education

MBA

UNIVERSITY OF MIAMI SCHOOL OF BUSINESS

bachelors

QUEENS COLLEGE CITY UNIVERSITY OF NEW YORK

Interests

SportsBass guitarBeer tastingCreative writing

Skills

Information TechnologyDatabaseBig DataQA and QCCloud ComputingBusiness IntelligenceMiddleware and IntegrationData MiningProgrammingTelephonyERP and CRMMessagingProtocols and StandardsArchitectureMachine LearningOperations, Monitoring and Software ManagementNetworkEnterprise StorageReportingMarketingGeneralMarketing CommunicationsDigitalProductAudienceAdvertisingPublic RelationsMarket ResearchData & Analytics