John Cockerham Email & Phone Number

Dallas/Fort Worth Area

• Worked with AdOps team to optimize campaign performance based on several KPIs such as clickthrough rate (CTR), cost per action (CPA), video completion rate (VCR), etc. • Mitigating delivery issues for campaigns struggling to spend in full• Working with various data sets from multiple sources. For example, comparing Simpli.fi reporting to Google's DoubleClick Campaign Manager (DCM) and Google Analytics reporting utilizing various SQL queries to our database and Excel functions to help explain data discrepancies• Extensive work in Excel for data analysis and reporting for clients including various formulas, pivot tables, and occasionally VBA scripts • Identifying and communicating strategic initiatives to client services team such as incremental budget opportunities, fine-tuning target audiences, improving cost basis and ROAS (return on ad spend) for clients• Running and helping create Python scripts to help automate several optimization strategies• Documentation of processes and writing knowledge base articles in Confluence • Fielding service desk tickets in JIRA and Zendesk• De-bugging technical issues with site pixel placement and ad tags

Denton, Tx

• Worked with a variety of clients to determine system needs, marketing solutions, content needs, and the creation of processes for management and implementations of their websites• Participation in requirements gathering, web design, marketing, branding, and media meetings• Writing requirements documents and user stories for client project requests• Collaboration with BA / QA teams and development teams to complete user stories and fix bugs on client sites• Extensive usage of both Drupal and DNN CMS platforms• Database / SQL familiarity; using databases and Excel for data extraction and analysis; generating custom reports for clients based on specific requests

Denton, Texas

• Working with service delivery team to ensure top quality in project management, as well as delivering projects in a timely manner. • Content administration: adding content into websites via Drupal's content management system, including product edits on e-commerce sites. • Web testing for both Drupal and DNN sites using Atlassian's JIRA platform to monitor bugs and track issues. • Social media for the company's pages as well as writing social media marketing strategies for clients.

Denton, Texas

• Learning about and working with cross-functional teams across the organization.• Introduction to content and e-commerce product management on client websites.• Assisting Accounting & HR teams with document review, invoicing, printing.• Social Media management and development of strategies.

Denton, Texas

• Made coffee drinks, served customers, cashiering duties, customer service responsibilities, cleaning, and closing duties.

Fairview, Texas

• Served gelato to customers, maintained clean restaurant and workspace, cashiering duties, as well as closing duties.

Mckinney, Texas

• Worked in a kennel taking care of dogs and cats.• Fed, medicated, walked, and took out dogs.• Helped vet with procedures for the animals.• Developed strong Customer Service and interpersonal skills with pet owners and fellow team members.

Bachelor Of Business Administration - Bba, Marketing, Cumulative Gpa Of 3.9 (Magna Cum Laude)

Activities and Societies: Honors College, Intensive English Language Institute: volunteer helping international students learn.

Bachelor'S Degree, Spanish Language And Literature, Cumulative Gpa Of 3.9 (Magna Cum Laude)

Activities and Societies: Honors College, Intensive English Language Institute: volunteer helping international students learn.