Colin White Email and Phone Number

Microsoft contract to provide XIP program management, data visualization, and analysis for marketing activities.

Data analysis, reporting, and visualization for the Americas CMO field marketing team, with a focus on marketing events analysis, monthly business management scorecard, and Federal Marketing. Deliverables in Power BI, PowerPoint, and Excel from multiple sources including ADF, SQL, PBI, Excel, and Adobe Analytics. Analysis done with PBI, SQL, and Excel to answer business questions and provide insights with exec-level visibility.

Provided reporting, analysis, and data management for the central corporate BI team in a global consumer audio business. Single owner of effort to formalize Master Data Management principles across a business made up of multiple brands, categories, and systems, to ensure the highest quality data for analysis and reporting. Collaborated with IT teammates in Data Engineering and Enterprise Resource Planning, to make MDM-driven adjustments to data pipelines and source systems. Collaborated across multiple groups to improve data quality and deliver insights, including Finance, Sales, Marketing, Supply Chain, and Leadership.

Supported Bing Planning Team in regular and ad-hoc business reporting and analysis, including sourcing data, automating pipelines, visualizing and providing contextual commentary for the rhythm of the business, with a bias toward forecast intelligence. Deliverables included written analysis, slides, spreadsheets, and dashboards.

Develop automated reporting and perform business analysis for Microsoft LSP Partners doing incentive programs to drive sales and consumption of cloud-based products, Azure and O365. Build an ETL process to pull data from multiple sources and normalize it to serve the set of automated monthly reports in Excel and PowerPoint for the PDMs and leadership team.

B2B Marketing to drive cloud adoption, end-to-end PM of activities for a portion of the business, including Windows on AWS and strategic launching products. Helped create a new program allowing marketing managers to self-serve digital campaigns with their content. Managed the budget and partner relationship for a multi-million-dollar Co-op Marketing budget shared between Microsoft and Amazon. Drove all aspects of execution for marketing activities, coordinating with product managers, channel owners, creative, business intelligence, and operational teams. Performed regular and ad-hoc data analysis and reporting as needed.

Oversee complete data management and reporting for the MS PC Hardware business. Present analytical findings to a non-technical audience, giving context and highlighting any implications to the business. Manage and provide main inputs to market forecasts. Collaborate with Product Managers to evaluate product value proposition, set performance metrics and forecast product volumes, then with Marketing Managers to track performance of products and campaigns. Work with Finance and the Hardware Planner to create a long term revenue forecast.

Manage SQL databases for regular and ad-hoc reporting of market data. Develop SQL DTS/SSIS packages, Stored Procedures and ad-hoc queries to streamline data collection and scrubbing processes. Create Excel and Sharepoint front-end for reporting and process tracking.