Ben Johnson
Business Intelligence Data Warehouse Consultant at Teleion- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Matthew Eccles
There can be few people, if any, who have as good an understanding of music royalties and licensing from an end-to-end perspective than Ben Johnson. At Rhapsody / Napster he was the key contact between the licensing / legal teams and the royalty reporting teams, responsible for designing, building and maintaining a royalty system that was proven to accurately calculate royalties from complex license agreements in over 30 territories and with hundreds of different licensors. Ben has the almost unique skill-set of understanding the terms of the license agreements (including the key issues in negotiating those licenses) and also understanding how to program a system to calculate those royalties. With his great understanding of the systems as well as the business, Ben was always extremely quick, efficient and effective at responding to requests for specific data. Watching him do his thing is a little bit like magic.
Daniel Parker
Ben built the Rhapsody royalty calculation software system from scratch which was a huge accomplishment. He quickly became the technical expert on all royalty calculations and reporting requirements. He built a scalable system the allowed Rhapsody to expand from 2-3 countries into 40. He support countless upgrades and fulfilled many audit requests. Beyond on that, he was a pleasure to work with. I would highly recommend Ben to any employer.
Matthew Eccles
There can be few people, if any, who have as good an understanding of music royalties and licensing from an end-to-end perspective than Ben Johnson. At Rhapsody / Napster he was the key contact between the licensing / legal teams and the royalty reporting teams, responsible for designing, building and maintaining a royalty system that was proven to accurately calculate royalties from complex license agreements in over 30 territories and with hundreds of different licensors. Ben has the almost unique skill-set of understanding the terms of the license agreements (including the key issues in negotiating those licenses) and also understanding how to program a system to calculate those royalties. With his great understanding of the systems as well as the business, Ben was always extremely quick, efficient and effective at responding to requests for specific data. Watching him do his thing is a little bit like magic.
Daniel Parker
Ben built the Rhapsody royalty calculation software system from scratch which was a huge accomplishment. He quickly became the technical expert on all royalty calculations and reporting requirements. He built a scalable system the allowed Rhapsody to expand from 2-3 countries into 40. He support countless upgrades and fulfilled many audit requests. Beyond on that, he was a pleasure to work with. I would highly recommend Ben to any employer.
Matthew Eccles
There can be few people, if any, who have as good an understanding of music royalties and licensing from an end-to-end perspective than Ben Johnson. At Rhapsody / Napster he was the key contact between the licensing / legal teams and the royalty reporting teams, responsible for designing, building and maintaining a royalty system that was proven to accurately calculate royalties from complex license agreements in over 30 territories and with hundreds of different licensors. Ben has the almost unique skill-set of understanding the terms of the license agreements (including the key issues in negotiating those licenses) and also understanding how to program a system to calculate those royalties. With his great understanding of the systems as well as the business, Ben was always extremely quick, efficient and effective at responding to requests for specific data. Watching him do his thing is a little bit like magic.
Daniel Parker
Ben built the Rhapsody royalty calculation software system from scratch which was a huge accomplishment. He quickly became the technical expert on all royalty calculations and reporting requirements. He built a scalable system the allowed Rhapsody to expand from 2-3 countries into 40. He support countless upgrades and fulfilled many audit requests. Beyond on that, he was a pleasure to work with. I would highly recommend Ben to any employer.
Matthew Eccles
There can be few people, if any, who have as good an understanding of music royalties and licensing from an end-to-end perspective than Ben Johnson. At Rhapsody / Napster he was the key contact between the licensing / legal teams and the royalty reporting teams, responsible for designing, building and maintaining a royalty system that was proven to accurately calculate royalties from complex license agreements in over 30 territories and with hundreds of different licensors. Ben has the almost unique skill-set of understanding the terms of the license agreements (including the key issues in negotiating those licenses) and also understanding how to program a system to calculate those royalties. With his great understanding of the systems as well as the business, Ben was always extremely quick, efficient and effective at responding to requests for specific data. Watching him do his thing is a little bit like magic.
Daniel Parker
Ben built the Rhapsody royalty calculation software system from scratch which was a huge accomplishment. He quickly became the technical expert on all royalty calculations and reporting requirements. He built a scalable system the allowed Rhapsody to expand from 2-3 countries into 40. He support countless upgrades and fulfilled many audit requests. Beyond on that, he was a pleasure to work with. I would highly recommend Ben to any employer.
Experience
-
Teleion
-
United States
-
IT Services and IT Consulting
-
100 - 200 Employee
-
Business Intelligence Data Warehouse Consultant
-
Jul 2022 - Present
Working full time as a consultant for Amazon, assisting with their Global Real Estate and Facilities team to help better understand help desk tickets related to maintenance and facilities requests / incidents through reporting, data visualizations and ad hoc analysis. This work involves a large portion of customer and expectation management, requirements gathering, prototyping and developing reporting with Tableau. Working full time as a consultant for Amazon, assisting with their Global Real Estate and Facilities team to help better understand help desk tickets related to maintenance and facilities requests / incidents through reporting, data visualizations and ad hoc analysis. This work involves a large portion of customer and expectation management, requirements gathering, prototyping and developing reporting with Tableau.
-
-
-
Coinme
-
United States
-
Financial Services
-
1 - 100 Employee
-
Data Engineer
-
Oct 2020 - Jul 2022
As a contractor, came in to advise and consult on a data warehousing engineering project for this company who previously has been using an elasticsearch / Kibana solution. I kicked off a POC using a Snowflake database, then converted to a FTE as a Data Engineer. Responsibilities now include setting-up real time data flows, designing and implementing Snowflake configurations (roles, databases, schemas, warehouses), architecting ETL monitoring capability, building data pipelines via an AWS S3 data lake, helping set up AWS Kinesis Firehoses to funnel events to our S3 bucket from event sources, and build out useful datamarts. Show less
-
-
-
Napster
-
United States
-
Musicians
-
1 - 100 Employee
-
BI - Technical Program Manager / Data Engineer
-
May 2012 - Jul 2020
• Technical product owner for streaming music royalties calculations and technical deliverables surrounding those calculations. Includes both publishing (performance, mechanical), and label calculations. • Model cost optimizations for contract negotiation, product / license / industry innovations. Help generate revenue via Royalties PAAS, & deliver faster data processes. Includes modeling solutions to identifying industry wide bot and 'stream buying' royalty fraud. • Operationally run monthly Napster, iHeart Media, and Sony label royalty calculations as well as U.S. performance and mechanical royalties processes. Royalty costs run over $90,000,000 annually and typically account for 80% of a Digital Service Providers’ revenues. Supporting accuracy and reporting for over 300 licencors – each with custom licensing contracts on multiple products. • Lead all “source system” to “BI integration” projects related to new business partners / licencors / new data sources. Data warehouse imports data from multiple source systems (content metadata in one system, ecommerce revenue in another, subscriber metadata in another). • Technical vendor manager for label royalties as well as royalties PAAS partners, fielding licencor questions about royalty results, report data and formats, and new reporting requirements. Focus on 3 major labels with largest sets of requirements and 85% of the world’s market share. • Wrote and developed processes to insource customized royalty calculations and eliminate the 3rd party. Enabled global expansion into over 40 countries (from 3), reduced payment calculation time from 2 days to hours, and reduced licencor reporting times from 3 days to a half day. • Build release scripts, deploy & maintain code and code repositories. Major releases include deployment of an entire royalty software application. Objects deployed are data warehouse tables/data/procedures, as well as TPT or fastload scripts (Teradata tools & utilities). Show less
-
-
-
Starbucks
-
United States
-
Retail
-
700 & Above Employee
-
Sr Business Systems Analyst - BI
-
2008 - May 2012
Deep data analysis of retail consumer and partner / employee behavior including labor scheduling analysis retail store marketing and staffing strategies, cash handling analysis. Targeted certain store types for specific program/product testing (new food and beverages) and to improve sales, reduce waste.Led requirements gathering efforts to renovate and enhance retail store reporting tools.
-
-
Business Systems Analyst
-
2004 - 2008
Performed coaching and training on the use of retail staffing software tools as a way to optimize retail staffing schedules. Gathered requirements and designed store reporting tools used to manage operations.Wrote Systems and Best Practices documentation. These included retail scheduling software manuals, promotional reporting tools
-
-
Education
-
1995 - 2000
University of Washington
Bachelors, Sociology -
2013 - 2013
Modeling Agency
Machine Learning
Community
