• Created client dashboards in Tableau, saving FTE payroll hours• Established best practices for campaign data capture for reporting, optimization and predictive analysis• Managed junior staff, delegating responsibilities and providing support• Revamped reporting processes for improved efficiency, shortening turnaround time and decreasing costs• Drafted company documentation on industry topics such as a cookie-less web, and the impact on the business• Leveraged Python, Tableau, SQL for streamlining processes• Deployed cloud-based data warehouse for storage, retrieval of historical and current client data

• Built automated client dashboards in Tableau, resulting in $50K incremental for one client• Designed, executed custom queries against datasets to derive actionable recommendations and insights to sales, account management, and supplier teams from Hive and Vertica• Defined company standard for A/B testing, wrote documentation and provided internal training• Managed junior staff analysts on workflow and provided feedback and best practices• Presented analytical findings directly to clients including high level marketing executives

Served as primary analytics resource to buyer team, including sales leads, account managers, and executive leadership on demand-side initiatives and investigations: • Provided daily and weekly updates on shifts in spend among strategic partners to key stakeholders, business owners• Identified wastes in ad serving costs and elevated findings to executives for action• Provided weekly updates to account managers on how their accounts were pacing based on forecasts and actuals spend figures, using Snowflake and a shared document • Developed collateral materials for company-wide buyer presentations on performance with top partners, publishers, and advertisers • Collaborated across teams to monitor inventory quality control, impacts to the company’s bottom line• Built dashboards in MicroStrategy (desktop and web) for account managers to monitor the health of their books of business • Administrator of Anodot anomaly detection tool, creating alerts, dashboards, and closely monitoring for real-time actionable recommendations• Created actionable insights to key members of buyer and executive teams, leading to savings

Was the primary and often sole analytics resource for organization, mostly assisting the sales team in using data to inform client campaigns and marketing initiatives• Utilized large search and campaign data sets to gain audience insights to inform media, search and creative strategies for advertising clients• Presented customer behavioral findings to clients, along with actionable recommendations • Worked on development of periodical client reports and analytic findings with engineering, product development teams• Developed analytics POV for the company• Created marketing materials from distilling terabytes of proprietary search data using Hive, Impala, Python

Provided insights on campaign performance, site-side activity, creative and media optimization recommendations, landing page optimizations at the HTML level, and multivariate dynamic creative analysis on a range of clients servicing B2B and B2C marketing efforts• Created campaign success measurement proposals for in-market optimizations and post-campaign analysis• Estimated required delivery for test plans in order to achieve actionable results• Designed, specified requirements for database schema for automated reporting process, saving 800~1,200 man hours/year• Delivered, presented key findings of numerous media and content initiatives, making recommendations to achieve goals • Quantified opportunity for increased tourism through a poaching strategy targeting qualified prospects, accounting for competitor reaction • Demonstrated the effectiveness of a de-positioning campaign of competitor using social media discussions• Developed methodology of defining and determining key prospect clients for potential pitches across industries• Optimized online advertising campaigns to maximize responses at lower costs• Mentored and delegated work to junior staff, managing their time and expectations• Led development of content optimization for marketing campaign utilizing social media content

• Designed test plans to measure differences in responses for direct mailings to loyalty rewards program and presented plan to client • Designed, wrote code to extract loyalty membership renewal behavior and presented findings to client • Constructed client presentations in PowerPoint using charts manipulated in Excel and SAS• Designed and presented marketing test plans to clients• Used data from DoubleClick/DART, Google Analytics, Omniture, and other vendors for the use of campaign reporting and analysis.• Aided in campaign pitch for new business by mapping out strategy for specific channels of media campaign (i.e., social, search, etc) and forecasted sales based upon media plan• Designed plans to test differences in response behavior by communication channel, executed test plans and presented findings.• Assisted colleagues in writing code in SAS, formulas in Excel, queries in SQL

• Using SQL, SAS, Excel and PowerPoint, analyzed membership data and trends for clientpresentations and in the support of sales and new client acquisition • Addressed ad-hoc inquiries from clients on specific marketing opportunities • Performed statistical analysis of web site traffic to address internal and external requests • Survey design and survey-results analysis • Secondary market research in the health care and pharmaceuticals sector to aide and add insight to client deliverables.

Created a database of all online higher education programs that offered degrees (i.e., associates, bachelor's, master's, doctorate), by institution and program area.

• Analyzed and forecast market trends in the mobile communications industry, communicating these findings to internal and external stakeholders • Collaborated with team members to address ad hoc requests from clients on specific inquiries • Extracted and manipulated survey response data sets, performing tests of statistical significance and communicating these findings to clients and the news media• Worked on development of a Sigmoidal-curve modeling tool that forecast market penetration of various mobile telecommunications technologies and devices

• Supported efforts to develop a company intranet, including aggregating cross-functional information,collaborating on design, and maintaining up-to-date information • Data review and analysis of internal survey results for training needs and requirements. • Apex language programming for developing triggers in Salesforce CRM application.

• Resolved network, hardware and software problems• Supported and assisted users with new applications and training on new tools• Designed and ran queries on optical character recognized subpoenaed documents upon attorneys' request