• Assisted in the development of sales and marketing metrics used to determine the go-to-market strategy for a globally competitive heat treating company. This process consisted of researching cutting edge marketing techniques to expand brand awareness, performing environmental and economic analyses to determine operational direction, as well as competitor research and benchmarking meant to bolster the company’s claim as a high quality metal heat treater.

• Architected a data mart to be used as the foundation for the company’s reporting and dashboarding needs. Began by developing automated processes to continuously extract data from our production databases into the data mart environment. This allowed for the manipulation of production data to produce a schema optimized for reporting and dashboarding. Here, data was cleansed using custom business logic and enriched with demographic and socioeconomic data.• Built out the company’s dashboard reporting platform used by the internal team in addition to our Fortune 100 clients and partners. This consisted of creating custom dashboards tailored to report on a multitude of KPIs around sales and other industry specific metrics. Additional reports centered around demographic and socioeconomic attributes of our client’s end users enabling us to garner deeper insights into audiences.• Conducted recurring product sample survey analyses for a Fortune 50 consumer packaged goods company. Email surveys were sent to appliance buyers asking if they received the included product sample, tried the product sample, and if they were convinced to buy the product based on the use of the sample. These results were matched with demographic and socioeconomic data to identify relevant correlations between responses and buyer attributes. The results were analyzed, summarized into a deck, and presented to client and internal stakeholders. The insights derived from these analyses were used to show the lift in sales created by the inclusion of product samples and track the operational efficiency of the program.

• Analyzed the effectiveness of marketing campaigns for a Fortune 100 telecommunication provider. Initial efforts required the use of algorithmic business name matching to tie disparate marketing and sales data sources. This allowed for the analysis of win rates by marketing channel and campaign, further bolstered by determining sales velocity and the optimal customer journey. The analysis was used to optimize marketing campaigns, increasing their effectiveness, and improving win rates.• Produced multiple dashboards and reporting models used to determine unit forecasting and sales representative allocation for a Fortune 100 telecommunications provider. The project improved operational efficiency and allowed for increased adaptability when encountering operational road-blocks.• Developed a sales enablement platform for Fortune 500 telecommunications provider. The project automated the collection, cleansing and structuring of disparate data sources. The cleansed and structured data was then used to create standardized sales metrics to be visualized in dashboards. This provided executives with greater insight into the effectiveness of sales teams, created the ability to follow opportunities through the sales funnel, and increased the effectiveness of sales representatives by geographically mapping opportunities and their relevant metrics.

• Conducted a pricing analysis for a Fortune 200 telecommunications provider, sizing markets and increasing effectiveness of base product price raises. Recommendations netted a significant lift in revenue.• Participated in the design and build of a standard costing platform for a real estate investment trust, maximizing company margins by determining most profitable tenants based on demographic and socioeconomic attributes. Project required reorganization of firm’s database and processes to enable calculation of net operating income of individual units and tenants. The costing model allowed for insight into which types of potential customers should be targeted to maximize profitability.• Contributed to the development and implementation of an approach to realign the sales force of a major telecommunications provider. Used statistical techniques to geographically form polygonal clusters of potential customers. Used GIS software to map and display sales territories for distribution. Boundaries were layered on top of mapping software and provided to sales representatives, reducing the amount of overlap between representatives, and creating more efficient sales strategies.