Rob Hood Email and Phone Number

Solely owned LLC that I incorporated in May 2024 for my freelance and independent contractor work. My consulting work includes: market research, audience research, data analysis, web analytics, Excel VBA coding and building custom Excel programs for companies and individuals.

Supported portfolio strategy, content acquisitions, brand health, competitive tracking, and corporate communications for HBO MAX, TNT, and TBS.* Collaborated with Executives, Marketing, Branding, Advertising Sales, and Network Strategy groups.* Created high level analyses for the launch of the HBO Max streaming service by identifying content strategy, potential content acquisitions (including Sesame Street and Adult Animation), and highlighting industry trends.* Provided data and fact checking for corporate communications (public relations, investor relations, executive speaking engagements).* Direct oversight of original series reporting process and distribution throughout the company. Improved report efficiency with a master template in Excel that automated repetitive process flows by using large Excel VBA / Macros, ultimately reducing report creation times by 10+ hours per week and potential for human error by 80%.* Compiled genre and viewing performance trends among competitive streaming services (Netflix, Amazon Prime, Hulu).* Maximized sales revenue by delivering accurate audience forecasts to strategic planning teams that create the sales rate card. * Reviewed existing software applications to breakdown processes and information flow in order to develop best practices and usefulness to the company.* Trained new and existing employees in business acumen and numerous software applications to maximize their productivity in creating valuable presentations and ad-hoc analyses.

Provided marketing support, audience forecasting, and schedule optimization for TBS network.* Collaborated on the rebranding of TBS network (2015) by creating targeted strategies to reposition the network’s brand and expand programming development. Identified niche comedy genres within original live-action comedies, original animated series, and late-night talk shows as potential for bringing new audiences to the network.* Worked with external vendors to coordinate the collection of quantitative and qualitative research, promotional ad testing, landscape analyses, and pilot testing.* Utilized focus groups and national surveys to identify potential strengths and weaknesses within promotional media messaging, as well as providing network management with actionable creative insights and optimal media placement opportunities.* Analyzed scheduling and acquisition scenarios and made recommendations that optimized viewership ratings.

Provided research support for TNT’s priority programming by collaborating with the Marketing, On-Air, Branding and Digital teams to identify target audiences, measure message effectiveness and track program performance.* Created comprehensive audience profiles and post-analysis reports that are distributed to high-level executives and employees within the company. Used findings to create targeted strategy recommendations by educating clients on consumer behavior, attitudes and trends.* Monitored activities of competitive network cable landscape and use preliminary ratings analysis to inform network executives about competitive program premieres and series behavior patterns.* Co-authored a research software manual to implement best practices, strategies, and procedures across several Nielsen software applications. * Searched for ways to improve and streamline routine reports in order to ensure reports and presentations are serving the key interests of clients.

* Developed and implemented an excel macro that simplified the daily metered market competition report that is sent out to network executives and company employees, reducing report creation time by 4 hours per week.* Analized media usage, demographics, psychographics and consumer behavior. Used findings to set forth consumer attitudes, trends and appropriate marketing recommendations and conclusions.

Managed all aspects of inventory operations for 34 Latin America television networks. Supported the operations of 5 sales administration offices and 8 international sales teams by providing analytical and statistical research.* Played an integral role in the TBSLA migration to the Aleph traffic system. Successfully brought the department’s information systems back to previous operational levels by identifying alternative intelligence resources for data retrieval and extensive testing of applications for errors.* Designed and implemented an interactive Inventory Allocation Management System to align the inventory optimization resources with the overall strategy of the Latin America operation. Used to effectively predict and resolve inventory disputes between regional offices by providing alternative solutions and schedules in order to adhere to financial agreements and deadlines- Successful implementation contributed to a 46% increase in operational volume over first two years, saving $3.1 million in revenue in 2008, and $4.2 million in 2009 that would have otherwise been lost due to conflicts.* Created and maintained an Operational Performance Rating report for analyzing trends within various stages of the operation cycle, and the effect of human errors contributing to outcomes. Collected measurement data from 3 different databases to create interpretive charts, models, and written summaries that supply management with metrics linking successful performance progress towards target achievements. * Developed and distributed a weekly Network Performance report summarizing variances in network performance. Used statistical models to analyze contracted projections versus actual volume booked that were essential in providing teams the ability to forecast expected network volume and revenues for assistance in workload planning.* Authored a 90 page Training Manual that documents proper inventory implementation strategies across several applications.

Brought on board to fill a newly created position to solve problems the department was having with inventory. Gathered and assimilated a wide range of data and looked for patterns, relationships and linkages to create a clear path for the future. Assessed new business initiatives and the impact they would have on corporate culture.* Created and maintained database management systems used for tracking available inventory, backlog of orders, potential new orders, financial data, and accommodation factors for various contract types.* Managed how oversold time slots should be handled by reviewing contracts to facilitate alternative solutions and schedules with sales teams in order to adhere to financial agreements and deadlines.* Introduced system of procedures for pre-clearing sales orders to prevent conflicts from arising. Contributed to a 14% increase in operating efficiency within the first three months.* Drafted and implemented a Re-Evolution plan that outlined the strategic direction of inventory management and related new roles within the department.* Instrumental in discovering errors within the structure of existing applications and directed efforts in fixing discrepancies.* Embraced the challenge to take on additional projects. Initiated and prepared monthly reports for management teams to quickly show operational statistics that expressed the value of the department’s role in enhancing the position of the networks.* Educated co-workers on technical subjects related to inventory. Created a participative training style with hands on approach to clearly present complex data in simplified terms.

Coordinated the logistical support for successfully transferring passenger baggage within designated airport facilities.* Managed a team of 50 team members responsible for over 40,000 bags on a typical eight hour shift.* Received a Letter of Commendation for Performance and Commitment (2006).* Assisted in the implementation of a more efficient baggage transfer system by auditing domestic cities and their arriving flights into Atlanta. Resulted in an overall 55% improvement in mishandled baggage within the first 3 months.* Analyzed arriving flights using data collection software to determine the volume of luggage and assigned the deployment of human resources to meet operational needs.* Trained new employees in procedures and responsibilities of a safety conscious work environment. Served as a mentor who inspired and developed people for promotion.* Fostered and promoted a cooperative working environment by instilling a can-do attitude in employees to maximize productivity and improve employee morale.

* Coordinated loading and unloading of aircraft using heavy equipment. * Planned the weight and balance of aircraft to ensure best possible in-flight performance.* Directed the ground movement of aircraft in terminal ramp area.