Director, Business Intelligence and Analytics @ From March 2014 to Present (1 year 10 months) Senior Manager, Business Intelligence and Analytics @ From September 2013 to March 2014 (7 months) Greater New York City AreaManager, Business Intelligence & Analytics @ • Manage and develop of team analysts
• Provide daily/weekly/quarterly dashboard to provide visibility to the business
Director, Business Intelligence and Analytics @ From March 2014 to Present (1 year 10 months) Senior Manager, Business Intelligence and Analytics @ From September 2013 to March 2014 (7 months) Greater New York City AreaManager, Business Intelligence & Analytics @ • Manage and develop of team analysts
• Provide daily/weekly/quarterly dashboard to provide visibility to the business to performance against quarterly targets and key KPIs
• Build and maintain MySQL data tables to drive company wide reporting
• Operationalize and automated many of manual reports through Spotfire to increase team productivity From March 2013 to September 2013 (7 months) Senior Analyst, Business Operations @ • First hire in the Finance and Business Analtyics team
• Built and maintained the first pro-forma revenue model
• Instituted the first quarterly revenue and impression forecasting process for the sales team
• Rolled out monthly account tracking and weekly flash reporting to the organization From December 2011 to March 2013 (1 year 4 months) Senior Network Analyst @ • Provide price/volume recommendations to the media team when on boarding new publishers, and evaluate deal structure of existing publishers to maximize margin.
• Responsible for yield optimization reporting and analysis, and provide recommendations to the Adops team to ensure optimal campaign assignment.
• Margins improved 10% month over month (Dec. 2010 – Jan. 2011) due to recommendations
• Drive strategy by providing key insights for the top accounts across the country.
• Grew a top financial client into one of the top advertisers for all of 2010.
• Awarded the International Delivery Manager of the Quarter Award for Q1 2010 for having the highest client retention rate at over 98%.
• Built dashboards in Tableau to analyze the network dynamics and highlight opportunities for growth and improvement
• Act as a mentor for the new five hires and lead their training program. From February 2010 to December 2011 (1 year 11 months) Business Analyst @ • Work closely with the sales and trafficking teams to launch campaigns in a timely manner and ensure they are set up for success.
• Increased spend on top finance, telecommunications, and pharmaceutical accounts by over 400% (2008-2009).
• Won the Innovator of the Quarter Award for the Operations team in Q4 of 2007 for developing a new tool that improved efficiency in the delivery group.
• Be the liaison between operations and technology in the developing an automated process for client stats. From May 2007 to December 2009 (2 years 8 months) Revenue Operations Associate @ • Responsible for revenue based reporting; designing and creating both regular reports and ad hoc reporting for the entire marketing department.
• Performed modeling and sizing analysis of potential markets for sales initiatives.
• Manage data quality projects to ensure consistent data for analytical purposes. From March 2006 to May 2007 (1 year 3 months)
BA, Economics, Political Science @ University of Maryland College Park Bernard Guillermo is skilled in: Business Analysis, Business Intelligence Tools, Reporting & Analysis, Microsoft Excel, Tableau, Online Advertising, Python, SQL, Digital Media, Financial Analysis, Spotfire, MySQL, NumPy, Vertica, Git, Behavioral Targeting
Looking for a different
Bernard Guillermo?
Get an email address for anyone on LinkedIn with the ContactOut Chrome extension