Greg Powell Email & Phone Number

Austin, Tx, Us

Austin, Texas, Us

In my role as a consultant I am certainly never bored! On a week to week basis I work with around 5-6 clients on a multitude of different projects across every part of the data-value chain (ETL, to data modelling to data visualization). I enjoy solving problems for my clients.From a visualization perspective I mostly leverage Tableau's capabilities to craft compelling and actionable data visualizations for my clients. I have a wide experience in constructing comprehensive and accurate data models (SQL, Python) that are easily ingested into Tableau (or any output) for visualization. I have an eye for detail and am very thorough when it comes to data validation when customers have the goal of establishing a single source of truth in their data.I have built and nurtured strong client relationships, guided clients from initial data exploration, through transformation, to final visualization and ensured data integrity in our projects.I am also a team player, and have worked successfully in Zuar teams such that we can meet our business and client goals.Role Summary:- Building interactive custom dashboards using visualization best practices for multiple clients/industries/locations. - Designing data staging and data modelling solutions for consumption in Tableau - Working with Zuar’s largest customer, integrating Tableau Dashboards with Zuar’s custom portal and data staging platform for a multi-site manufacturing efficiency project (OEE) - Experience working with Salesforce, Netsuite and Shopify based datasets (API/SQL). - Experience automating Tableau processes using the Tableau REST API. - Experience with datasets across multiple industries (consumer ecommerce, healthcare, manufacturing, B2B sales, Finance

Ch

Extracting data from various sources (SQL/Excel/stored procedures/Python scripts) and developing interactive dashboards in Tableau. - Engaging with major stakeholders (CFO, CEO, GM, IT, Marketing, Social Media, Graphic Design) on matters of performance, data and reporting quality and accuracy in a timely fashion. - Established reporting procedures, standardized dashboard formats and writing documentation of all reports and data structures

Responsiblities- Evaluating BI/Reporting Tools for implementation into the business as a new reporting platform (1-2 months) - sisense.com- Establishing the source of truth for the many data streams in our business- Providing adhoc and reporting on product, sales, launch and web-traffic in a timely fashion.- Establishing performance metrics- Engaging with major stakeholders (CFO, CEO, GM, IT, Marketing, Social Media, Graphic Design) on matters of data and reporting quality and accuracy in a timely fashion.- Maintain existing reports- Compile monthly royalty reports- Provide sales forecasts - Generating visualisations to communicate company performance in easy to understand terms.- Developing an analytics strategy for the business- Greenfield - developing prototype forecasting and analytical projects to reduce costs/improve profit- Recurring Customer Analysis- Implementing analytical tools- Data Governance - Inventory- Google Analytics, Google AdwordsAchievements- Established new automated procedures that streamlined reporting, and saved several days of the General Manager's time per month.- Providing metrics to give the business visibility on daily, monthly and pre-post launch performance. - Automated the generation of royalty reports and sales reports resulting in a efficiency gains- Reducing the time of report generation from 2-3 days to several hours thanks to implementation of the SiSense reporting tool. Resulted in quicker insight to action.

Melbourne, Victoria, Au

Highlights:- Identified $1 Million dollar gap in sales by identifying bottlenecks in lead generation process.Created from scratch new frameworks for cost to serve, cross sell propensity, customer segmentation and sentiment analysis models for the business using statistical techniques. (ARIMA/Queuing Theory/K-Means/Multinomial Regression)- Prescribed ARIMA/seasonal decomposition forecasts of future sales of vehicles- Cleaned, extracted and formatted data from structured (SQL, API) and unstructured sources (web/other documents) for ease of analysis. Clear and understandable presentation of results to executive level staff.Responsibilities:Development of models for the forecasting of fleet salesDeveloping a Novated Car Lease Cross Sell Propensity Model FrameworkMarketing Campaign AnalysisDeveloping Analysis Framework for Fleet Sales and Services - involving Agent-by-agent analysis and lead/opportunity generation analysis Sentiment Analysis Project studying the link between Agent/Customer Sentiment and SalesCustomer Segmentation ProjectData Mining and ETLStakeholder managementManagement, skills training and coaching of 2 other junior staff membersAchievements:Pricing and Profitability - queuing theory models used to predict cost to servePresentated Marketing Campaign Analysis - delivered insights (such as ideal time of call) to the business.Propensity modelling - delivered an initial "Test and Learn" list of high and low propensity customers. Post-call analysis that customers in the higher propensity groups were better lead, opportunity and sales generators.Delivered a framework of Sales Agent measures, reports, insights and further analysis to the Fleet Sales and Services team resulting in better agent performance visibility to management.Sentiment AnalysisCustomer Segmentation - Developed a proof of concept segmentation model using mathematical and common sense principles that grouped MMSG customers into 7 distinct groups.

Responsibilities- Predictive Modelling/Analytics – develop, test and refine predictive pricing models for the Buzzsports Tennis, Cricket and Soccer trading platforms.- Data mining – identify betting trends from historical data to ensure markets are priced efficiently- Data Extraction - Extracting data from Excel, SQL and proprietary (Hawkeye) formatted files using off the shelf and bespoke tools (scripting tools)- Software design/project management – custom extraction tool design- Statistical consulting to ensure that existing pricing models produce efficient marketsAchievements- Developed a working cricket prediction model for Twenty20 Cricket and Tennis– Cricket - Multinomial Logistic Regression Model– Simulations proved that markets would be priced efficiently for a profit of 3-4% in 100% probability markets, with minimum bookmaker supervision. - Provided management reporting identifying pricing anomalies in various markets resulting in less risk to bookmakers- Successfully built several simulation models to assess model accuracy and limitations using Excel, VBA macros and other statistical tools. The simulations confirmed profitable/breakeven performance of the market over time.- Identified issues with existing predictive models and reporting problems to management that resulted in a new soccer model being estimated.- Tested model simulation results for significance to ensure model accuracy- Established an extraction tool for proprietary Hawkeye data files

(see other entry)

New York City, New York, Us

Web Developer involved in the relaunch of lonelyplanet.com

Responsibilities- Develop and maintaining the WAGERplayer platform (PHP/MySQL)- Writing software specifications and documentation (user and internal)- Managing client requirements- Scheduling and managing test/live client releases- Providing customer support both over the phone, onsite and on an on-call basisAchievements- Led a software development team that implemented and managed a sports betting system for Lasseters Sports. The system was delivered on time and on budget.- Designed, implemented and tested numerous credit card and online payment gateway services- Handled client support and feature requests in a professional and friendly manner

Melbourne, Victoria, Au

ASP, MSSQL, PHP, PostgreSQL, MySQL, CRM/Web development

Masters, Applied Econometrics

Bachelor Of Business Systems