Kevin Mohan Email & Phone Number

Bronx, New York, Us

• Created annual budgets and scenarios, collaborating with Finance and Merchandise Buyers.• Led team of analysts and consultants to manage critical business platforms, including PowerBI, Qualtrics (customer sentiment) and Google BigQuery.• Designed, in conjunction with a cross-functional team, implementation of a new Customer Data Platform (CDP). Provided for this platform data inputs and technical expertise to develop a customer churn model and customer life-time value.• Developed statistical model to predict order damage based on grocery bag contents, customer profile and order distance traveled.• Conducted analysis evaluating Social Media ROI and ROAS, including Facebook and Google.

Paris, Fr

• Finance lead for the Advanced Analytics, CRM and Data Activation teams• Reviewed financial inputs and Python code for Match-Market campaign ROI analysis• Provided financial guidance for ROI initiatives, including MMX, MTA and campaign ROAS studies; incorporated findings into financial models to guide Capex and Opex investing strategies• Analyzed DMP / Data Activation usage and recommended opportunities to realize savings• Assisted the Sourcing and CRM teams with financial scenario modeling for negotiations to procure vendor services• Recommended strategies to obtain research credits from digital publishers to fund 3rd party verification of ad placement performance

Philadelphia, Pa, Us

• Led the Product and Content Analytics Strategy group, advising executives on a diverse array of topics presenting challenges and opportunities to Comcast’s business. Analysis highlights include VOD and Linear Usage, HBO viewership, PPV Movie Sales through the Set-Top Box, Product Bundling, Customer Onboarding, and Google Fiber.• Conducted viewing intensity and customer analysis of network viewership to assist with securing lower retransmission fees and better deal terms. Worked in real-time to provide feedback to the Content Acquisition Team as negotiations occurred.• Assembled and led a project team to analyze keyword spend on new customer acquisition. Repaired and reconciled broken data sources, and appended customer lifetime value metrics. Identified approximately $25 million of annual marketing spend that could either be eliminated or re-purposed.• Drove transformational change in marketing best practices for national and local marketing campaigns by implementing analytical discipline—e.g. hypothesis definition, A:B testing and post-campaign analysis.• Led cross-functional data-ingestion efforts for the Comcast Xfinity WiFi-product, organizing volumes of disparate engineering data (billions of daily records) into a sleek, compact and highly usable format for analysts and data scientists.

El Segundo, Ca, Us

• Built a financial case to secure additional capital funding for the DIRECTV Everywhere streaming product for the fiscal year 2013.• Forecasted streams, customers and revenue for the streaming product and established engagement targets for the Marketing organization.• Estimated the streaming product's benefit to enterprise revenue by analyzing customer usage data to model incremental premium unit sales as well as a reduction in enterprise churn.• Identified key opportunities to improve the performance of the streaming product through data analysis and customer survey research.• Assisted product managers by providing analysis, data requirements and forecast guidance for their corresponding product features, including Voice Control, NFL Streaming and Individualized Member Sub-Profiles.• Prepared monthly summary and bi-monthly detailed slides reporting on and analyzing the streaming product’s performance for the CEO's office.

Washington, Dc, Us

• Responsible for budgeting and forecasting revenue for AARP’s sizable product and service offerings across multiple industries.• Identified key variables driving revenue risks and opportunities in the forecast and communicated their significance to the appropriate operational stakeholders and to senior executives.• Met with external providers of AARP products and services, often Fortune 500 companies, to discuss revenue risks and opportunities and recommended appropriate follow-up actions.• Led cross-functional teams composed of members from the Distribution, Finance, Marketing and Operations Departments to evaluate new product and service offerings and the corresponding P&L implications.• Assisted the Sales organization by leading the financial discussion of business development negotiations, with a focus on obtaining discounted product and service offerings for AARP members and the maximum royalty for AARP.• Prepared and presented special financial analysis research projects requested by the CFO and CEO.• Produced quarterly risk management analysis of major AARP partners which included detailed analysis of financial statements.

New York, Ny, Us

• Managed the activities of a team of marketing analysts. Designed A:B tests and logistical models, prioritized projects, audited work streams and results. • Provided ad-hoc analysis of AOL Member Campaigns purposed to increase member retention, engagement and monetization for business managers• Coordinated with AOL data-warehouse to create, expand and optimize data sources for future analysis projects• Analyzed partner deals of 3rd party subscription services targeted toward AOL Free and Paid members• Conducted high-level strategic, financial and empirical analysis of AOL's member base, software products and web content• Prepared a portion of AOL’s Quarterly Investor Relations Presentation, detailing AOL paid subscriber engagement metrics and member trends • Worked diligently to provide excellent customer service to internal clients, often senior leadership

New York, Ny, Us

• Conducted ROI analysis of AOL marketing operations (e.g. Direct Mail, Online and Retail channels)• Produced monthly and quarterly reports detailing member registration, retention and revenue performance vs. operating targets• Generated sensitivity analyses to measure financial impact of potential strategies, using the Long Term Plan as a baseline• Forecasted member life expectancies and NPV’s through application of historical churn and cost metrics and utilization of time-series and regression statistical techniques• Modeled economics of partner deals for international web portal development, working extensively with the Business Development team

Mba, Finance, Logistics

B.A., Mathematics, Economics