Andrew Buell Email & Phone Number

Victoria, Bc, Ca

Victoria, British Columbia, Canada

Victoria, B.C.

• Built an analytics visualization product for the marine workboat industry utilizing Microsoft Power BI.• Built a SAS model which generated ~$150K in annual reoccurring revenue and filled a major product gap where customers were reliant upon raw csv files to gather company insights.• Met with external stakeholders to gather feedback and drive the analytics product releases/updates.• Supported 70+ analytics product customers.• Cleaned and transformed datasets to create actionable KPIs for customers.• Created a predictive maintenance schedule using customer's tracked engine hours data. Reduced customer vessel downtime.• Tracked and provided insights into reoccurring vessel non-conformities. Improved customer vessel compliance.• Led a team of developers to building a new reporting warehouse in Postgres SQL.• Created views, tables and queries to build the dataset required for a new embedded visualization tool Sisense.• Worked with developers to embed Sisense dashboards directly within Helm's core software and created a seamless and white-labeled visualization product.• Met with internal stakeholders to create dashboard/reporting solutions on Salesforce metric's as well as well as measuring customer software usage.

Victoria, Canada

• Introduced the ability to report on Big Data in real time using Microsoft Power BI and Google BigQuery platforms. • Created interactive and automated dashboards cross-departmentally for both internal and external use.• Provided analytical insight around video player performance leading to improved user viewability and content relevancy.• Worked with Revenue Operations team to pinpoint bugs in player tech.• Provided queried revenue/performance data and assisted Accounting team with month-end billing.• Became the primary internal correspondence for all SQL data requests.• Worked closely with top tier publishers and provided relevant player performance metrics on both content and ads.• Met with Google BigQuery engineers to understand the full Google Ad Manger dataset available to SendtoNews.• Used Google SQL language to provide more in-depth dataset offerings to the Revenue Operations team than the traditional Google Ad Manger built-in reporting.