Ryan Kelly Email & Phone Number

Chicago, Illinois, United States

Chicago

Chicago, Illinois, United States

Chicago

Led sales lift projects for fifteen to twenty campaigns at a time – from setup to execution to final delivery – requiring deep knowledge of internal IRI processes, digital media buying, and sales trends across multiple verticalsCustomized standard IRI deliverable with new visualizations and slide formats to most effectively represent insights and tell a compelling story for each reportServed as the projects’ main point of contact, working together with media agencies, client-side marketing teams, data providers, and internal IRI departments to deliver results

Chicago

Developed measurement frameworks for BP Corporate, BP Fuels, Castrol, Buffalo Wild Wings, and BBVA Compass accounts, ranging from small, regional sponsorships to national awareness campaignsDesigned and managed delivery of weekly, monthly, and end-of-campaign reports to clients, utilizing SQL, PowerBI, and Microsoft OfficeOrganized and led knowledge-sharing sessions to introduce media concepts, measurement tools, and presentation skills to new hires

Chicago

Coded custom MySQL databases to efficiently deliver weekly, bi-weekly and monthly reports for BP Corporate, Fuels and Castrol business unitsLed coworkers in setting up MySQL for their accounts, developing a lesson plan for creating custom databasesManaged the implementation of brand lift and foot traffic studies for BP, leading the setup via tagging and coordination between teams. Additionally, responsible for compiling the data into custom dashboards for monthly updates to the clientBuilt automated reporting for BBVA Compass via MySQL and PowerBI, reducing time spent building weekly reports by 15%-Team earned Mindshare North America’s Growth in Client Partnership award for significant improvement in client relationship

Chicago

Redesigned weekly reporting processes for BBVA Compass to more effectively collaborate with investment, social and planning teamsDeveloped a thorough measurement framework for new campaigns, ranging from national sponsorships to regional DR campaignsAssisted in planning and managing brand lift studies through both Nielsen Vizu and Millward Brown

Batavia, Il

Continued work assisting the National Projects department in completing assignments while working on projects specifically assigned to myselfProjects ranged from redesigning employee handouts to analyzing waste disposal data from around the countryUtilized both company-specific software and Microsoft OfficeSat in with the Advertising department for one week, working with employees on their day-to-day assignmentsAdditionally sat in with the Advertising Department for one week, working with employees on their day-to-day assignments.

Batavia, Il

Served as an internal consultant working on special projects for the Office of the PresidentsCompleted a number of smaller projects throughout the summer while also working on one large final projectFinal project consisted of information compiled from many different company resources and a forty-minute presentation delivered to the Vice President and Directors

Bachelor Of Arts (B.A.), Communication, General

Activities and Societies: Student Athetic BoardMinors in Marketing and Spanish. Completed Spanish minor in two years.

Education record

Activities and Societies: Student Newspaper, Youth & Government, Key Club, Soccer

Bachelor Of Arts (B.A.), 3.5

Overseas Study program through Indiana University. Attended classes focusing on international business, journalism and cyberculture.