Sam Wallace Email & Phone Number

Centennial, Colorado, Us

Founded Mile High Data Solutions in July 2020.Mile High Data Solutions (MHDS) provides services that leverage my 20+ years of experience with data analytics; reporting and visualization; database development; customer targeting and segmentation; strategic solution design; and just doing whatever it takes to turn complex data into actionable insights that are easy to understand for all levels of the business.In addition to these services, MHDS leverages the unique and diverse skillset of its leadership team. Lisa Tisdale, a long-time market research expert has held leadership roles at HBO and Time Warner Cable, and Ryan Hoffman our lead software developer both have 20+ years experience. This leadership team and our partners help provide our clients with a unique 360-degree view of their customers. Whether it is staff augmentation, a standalone analysis project, or a longer-term program, MHDS transforms your data into something that effectively drives intelligent business decisions. We do it by integrating market research, data analytics, and database solutions to fully leverage all your existing data and hidden customer insights.

New York, Ny, Us

• Successfully established the Insights & Analytics Department that was responsible for how all of KORE’s customers analyzed and visualized their data within the products they purchased. Grew this remote team from three to 13 individuals working in different locations within the US and Canada. Other responsibilities included:o Creation, deployment, and maintenance of standard and custom Tableau content for all of KORE’s customers across all products. o Data science and modeling engagements.o SQL scripting (SQL Server, Amazon Redshift, and MySQL), custom view creation, and stored procedure design to help facilitate more complex analytic and master data management requests.o Product-related duties to facilitate better end-user experiences, customer implementation, and continued customer success of KORE’s Data Warehouse & Analytics (DWA) product.o Multi-node Tableau Server management for all clients.• Lead architect and strategist for KORE’s Aggregated Data Environment (KADE) that facilitated customer benchmarking, segmentation, and modeling. This led to the development of a new line of business within the company.• Successfully served and helped grow revenue as the project reporting and analytics lead for the company’s two largest customers, including the data migration associated with the merger of Learfield and IMG College. • Led internal SQL and ticketing system training courses to ensure the team didn’t need to rely upon software development resources to build and maintain reporting. This helped free up our developers while decreasing our implementation times.• Developed a ticketing system standardization process and supporting database table structure that allowed the Insights team to create standard ticket reporting for its Ticketmaster customers. Previously, reporting was inefficiently customized for each client and implementation of this new process greatly increased efficiencies and proved to be a major competitive advantage.

Phoenix, Az, Us

• Acted in a hybrid role as both a strategic business analyst and database developer based on the needs of each project.• Designed, implemented, and maintained a financial planning and marketing analytics database solution: a centralized SQL Server relational database which houses information from several data sources such as Archtics™ (Ticketmaster’s ticket sales platform), the general ledger (MS Dynamics Great Plains), and various other internal and external sources.• Directed a strategic effort on variable ticket pricing to create decision tree models to accurately price each section in the stadium. • Created a ticket broker identification and analysis solution that allowed the Club to see which ticket holders were frequently re-selling their seats. Designed a system to programmatically collect and append secondary market information on a recurring basis from multiple third-party sites to our data warehouse. This led to a new strategy surrounding how to better manage ticket brokers in the stadium.• Created financial forecast models, performed geo demo analysis, designed materials in PowerPoint, and presented plans and results to the team’s executives.• Developed a technical solution (SQL Server, VBA, and Access as an interface) to manage all aspects of luxury box sales: multi-year contract management, inventory assignment, invoice production, and financial reporting. The result was a streamlined process that once took several days each month to reconcile figures between sales, marketing, finance, and the box office, to a process capable of providing instant reports.• Replaced the existing expense budgeting process that was being handled in a series of Excel spreadsheets by identifying the best fit in terms of a third-party solution, Adaptive Insights™. Reduced the budget cycle time by over 60% while providing more reporting and visibility for budget managers and leadership.

Denver, Co, Us

• Acted as the lead consultant in a variety of ongoing and project-based relationships. • Architected ETL and table structure on robust MySQL relational databases that were used for segmentation, benchmarking, and a wide range of business analytic efforts.• Created a means to reach and retain higher contributing customers. This mechanism is still in use at Eagle and has been adopted by the majority of its clients in subscription-based industries.• Provided recommendations and produced user-specific reporting that clearly communicated findings, at both the executive summary and more detailed levels.• Created VBA macro-based reporting in applications such as MS Excel that allowed for flexibility without the time constraints and costs of creating an intensive software development dashboard.• Designed and implemented a process for a revenue share payout team for Time Warner Cable that greatly increased accuracy and reduced the overall payout process from ~600 labor hours a quarter to ~ 20 hours. The company was then able to reallocate resources to concentrate on new business acquisition rather than maintenance.

Stamford, Ct, Us

• Responsible for analysis that examined customer trends, campaign response & ROI, and customer base migration.• Helped Time Warner understand its performance against other fiber optics providers. This created awareness that competitors were successfully acquiring Time Warner’s most affluent customers, and it resulted in more aggressive retention offers to targeted households in fiber overbuild areas.• Analyzed the success of divisional initiatives in order to provide a proof-of-concept prior to these programs being rolled out on a company-wide basis.• Facilitated the use of longitudinal customer analysis by managing the creation of data feeds where historical trends could be ascertained. • Created new operational procedures including an interactive MS Excel campaign matrix for the corporate managed mail program that allowed all campaign-related deadlines to be met for the first time in over a year.• Was a key member of the company’s acquisition team for Adelphia and Comcast markets. Was quickly promoted to Senior Manager following this success.

Denver, Co, Us

• Managed consumer and prospect databases.• Created segmentation schemes and performed cost-saving waste elimination on direct mail and telemarketing campaigns to increase the clients’ return on investment.• Managed the data implementation process for direct mail campaigns and performed campaign success analysis.

• Managed the content associated with the launch of cable still-frame advertising channels.

Bozeman, Mt, Us

Covered high school and college athletics.

Bachelor Of Science, Journalism

Education record