Jonathan Keller Email & Phone Number

New York City Metropolitan Area

* Developed schema in SQL for ENR top list data.* Built out ETL pipeline into SQL for ENR top list data.* Produce 13 main ranking lists and hundreds of sublists each year, along with accompanying analysis of those lists.

New York, United States

* Developed visualization of COVID-19 related construction outages in Tableau.

New York City Metropolitan Area

* Performed TV spot attribution analysis in Tableau.* Analyzed change in CPV between first and second campaigns for targeted TV plans.

Greater New York City Area

• Supervised a dispersed client service staff in a deadline-driven environment.
• Shepherded the Deluxe New York office through two major integrations - one with the Deluxe Moosic office and one with the Deluxe Northvale office.
• Managed relationships with Deluxe New York's largest clients including HBO, earning all of HBO’s optical media authoring work starting in 2018.
• Tracked and analyzed performance metrics for the NY region.

Greater New York City Area

Wrote, performed and produced sketch comedy shows on a monthly basis with veteran house sketch teams.

Greater New York City Area

Writer of original articles for satire website; runt-of-the-web.comhttp://runt-of-the-web.com/author/jon-keller/

Greater New York City Area

Contribute original comedy articles for the women's satire site, reductress.comhttps://reductress.com/author/jonathan-keller/

Greater New York City Area

• Edited over 1000 pages of website copy and wrote over 150 pages.
• Improved weekend marketing email open rate by 5% and clickthrough rate by 0.5%
• Spearheaded blogger outreach SEO strategy with the aim of improving the website’s performance on PageRank.
• Trained new copywriting interns on writing and editing description copy.
• Developed customer acquisition strategies including product promotions, site functionality upgrades, and expansion of social media presence.

• Managed day-to-day operations of a 40+ employee facility, serving as the node where client services, production and sales intersect.
• Completely overhauled the station database, expanding it from 1600 to over 6000 destinations with up-to-date spec, address and contact information.
• Captained order integration between USA Studios and digital partner Yangaroo, leading to a seamless initial rollout.
• Managed relationships with the company’s largest clients, including Disney, Land Rover and Overstock.
• Created and implemented a new procedure for long format order entry, allowing the company to bring in over $200,000 in new business.
• Led team that developed a new file delivery system, reducing costs from $50 per-spot-sent to less than $3. Company saw savings of nearly $5000 per day.

New York, NY

• Managed relationships with some of the company’s largest clients, including AT&T, Fedex and Mercedes Benz.
• Regularly assisted the sales department in pitches, client meetings and new client onboarding.
• Trained new client service personnel in the use of in house systems and order workflow.
• Trained both clients and the client services team in the use DG’s Spot Central application as an entry level employee.
• Tested efficacy of new high definition order entry procedures for the New York region.

Burbank, CA

Burbank, CA

Certificate, Data Science

Data Science student in an immersive 15-week program. Python, SQL, probability and statistics, statistical modeling, machine learning and.

Improvisational Comedy

Sketch Writing / Improvisational Comedy

Advertising

B.A., English

Activities and Societies: Amnesty International, Habitat for Humanity, Scribblings Literary Magazine