Clients: Zillow, Metro-Goldwyn-Mayer (MGM), STARZ, United Artists Releasing (UAR), Claire's, Let's Get Checked, Genesis, KIA, and Heineken USA. Focus: multi-platform digital advertising.

Canvas Worldwide Analytics TeamCanvas Worldwide is a full-service media agency. Canvas is Campaign US's 2021 Most Innovative Agency. Canvas was Adweek’s 2020 Breakthrough Media Agency of the Year.Clients: Heineken USA, Thrivent, Hyundai, Genesis, Let's Get Checked and United Artists Releasing (UAR)Heineken USA client:- Developing new Sisense data model for reporting optimization and performance KPIs.Thrivent client (formerly known as Thrivent Financial):- Developing and maintaning Sisense online dashboards and reports for client and internal teams. Contributing content and analyses to campaign wrap reports. Processing and analyzing the data of more than 20 advertising partners. Regularly developing and editing SQL to deliver automation, new dimensions and metrics that add value.- Moved Thrivent data model and KPI and metric reports to Sisense data and analytics platform. Transformed Microsoft Power Query M queries to SQL queries.- 2020-2021 omni-channel campaigns: Importing, tidying, and transforming data automatically from MySQL, TMM, and PostgreSQL sources using Power Query M and R. Data modeling using Sisense and Power BI Desktop. Developing client KPI and metric reports, dashboards, and visualizations using Power BI, Power BI Service, DAX and R. Data sources include Adobe Analytics, DoubleVerify, and Google Marketing Platform (Campaign Manager 360, Display & Video 360 and Search Ads 360).Hyundai and Genesis (automotive) clients:- Developed R and VBA scripts to automate the process of reporting marketing and sales KPIs, trends, and data.- Developed and modified Power BI and Excel data models and dashboards.- Maintain Sisense dashboards using Python, SQL, and TMM Data data warehouseCanvas:- Completed a voice-over used to launch the all-new Canvas Worldwide website in February 2020.

Client: Executive Director's Office, Bureau of Consular Affairs, U.S. Department of State• Solid understanding of advanced Tableau for analysis, dashboards, and stories.• Extracted data and transformed it using Tableau Desktop, Excel, and SQL queries.• Provided data and insight to the client’s C-suite and senior management worldwide.• Collaborated with client teams on key decisions, risk management, and KPIs/metrics.• Developed valued dashboards and decision tools using Tableau and Excel.• Created and distributed ad-hoc reports and popular KPI/metric reports regularly.• Analyzed metrics, trends, anomalies, and relationships using Excel and Tableau.• Forecasted the demand for business services worldwide regularly.• Developed and refined the scope of data projects, including deliverables and deadlines.• Promoted for outstanding performance in a knowledge and insight creation role.Selected achievements:• Provided the first self-service reporting on 225 business locations using Tableau dashboards.• Significantly increased insight into business operations at 120 locations worldwide using Tableau dashboards and data from multiple sources including Salesforce.• Reduced the risk of building poorly sized business locations by providing data stories for 100s of locations worldwide in series of Tableau visualizations.• Alerted managers earlier about customer service scheduling anomalies using control charts developed and made available in Tableau.• Produced a popular weekly report that updated the Bureau and White House on the President’s customer service KPI for visa services.• Developed and distributed a valued, monthly staff productivity KPI report that improved management at all 30 high-revenue business locations.• Increased knowledge of what drives the demand for services by using correlation and regression to examine and model the relationships of suggested variables.• Delivered 100+ ad-hoc analyses on time for the Bureau’s Global Support Strategy.

Client: Executive Director's Office, Bureau of Consular Affairs, U.S. Department of StateSelected achievements (continued):• Awarded Certificate of Appreciation by the U.S. Department of State in 2014.• Developed and distributed the first regular reporting of business performance data, cutting data requests by 70%.• Provided insights about the measurement of customer service wait times that were used to improve the accuracy of wait times presented to 12 million customers.• Increased the percentage of fresh wait times in the Bureau’s website from 75% to 95% using insights from a wait time age analysis.• Modernized the analytics stack from Excel to Tableau, SQL, and SAP HANA Studio.• Forecasts used to make prompt, effective decisions about the Bureau’s budget, proposed business locations, and distribution of staff.• Improved forecast quality by using benchmarks to reveal the inputs to the forecasting process that did not add value.

Worked with managers and website staff on digital communication projects to improve 5 customer-facing websites. Completed essential business operation tasks such as the collection of customer biometrics.Selected achievements: • Resolved serious omissions and poor guidance in a key business process outsourcing (BPO) contractor's website.• Delivered a report on website use that lead senior managers to call for growth and efficiencies. • Significantly improved user experience and content in 4 government websites.• Launched and managed a project to merge the 4 websites.• Earned Extra Mile Award and group Meritorious Honor Award by helping to cut visa appointment wait times from 130 days to 3 days in 8 weeks and boost legitimate travel to the U.S.

Planned and managed the initial and intermediate phases of a pilot catchment-sensitive farming project.Selected achievements: • Created a farming grant the Department of Environment, Food and Rural Affairs’ (DEFRA) incorporated into their $40 million, nationwide Catchment Sensitive Farming Program.• Increased project funding by $120,000.• Established the first three best-practices demonstration farms.• Gave a presentation at the U.K.'s first local-government soils conference.• Expanded the project steering group to include key stakeholders such as DEFRA, the National Farmers' Union (NFU), and the Country Land and Business Association (CLA).

Wrote and implemented a conservation strategy for the River Teifi as part of Life in UK Rivers, a project to develop methods for conserving the wildlife and habitats of rivers within the Natura 2000 network of protected European sites.