Experience

• 

  Victorian Trading Co.

  • Lenexa KS

  • Sr. Business Analyst

    • Jun 2018 - Aug 2019
    • Lenexa KS

    Core member of the management team, where a key responsibility was to develop the channel revenue demands that supported monthly, mid-year and annual forecast for seven marketing channels (catalog, email, wholesale, branded search, ebay, Amazon and retail).Developed multiple revenue predicting channel models in Excel using hourly sales data to forecast daily revenue goals and if they were going to be achieved. This analysis was used for future promotional campaign planning by the ecommerce team. Using Excel, built, maintained and published daily financial dashboards using several database platforms (Google Analytics, Cognos and Ecometry) to extract financial KPIs to monitor the success of daily financial and monthly goals, marketing campaigns and revenue performance of each marketing channel.Liaison between FP&A and marketing teams in providing monthly revenue performance, areas of revenue channel risk, margin analysis and cost.Partnered with each marketing director to set their annual channel revenue budgets. Analyzed historical revenue trends and channel margins that had potential growth between 5 and 10% over current year topline goals. Built extensive customer segmentation profiles for the catalog and e-commerce teams using Cognos to identify growth opportunities. This analysis was estimated to generate $1.5M of future revenue.Key contributor with the IT department in the implementation of Cognos reporting database platform; developed on-boarding procedures and data dictionary requirements.Using Cognos Query Studio, created a variety of queries to conduct monthly customer opt-in and opt-out audits to evaluate the health of the email file and examine purchasing behaviors that would impacted future email campaigns.Using Google Analytics, built in depth data trending revenue models evaluating response, open, click through and abandon rates for the ecommerce marketing team.

• 

  Sprint

  • United States
  • Telecommunications
  • 700 & Above Employee

  • Group Manager – Budget Forecasting, Data Analytics and Product Management

    • Mar 2013 - May 2018

    Responsible for the development of the annual budget, quarterly forecast, and monthly variance analysis for 40+ consumer products generating $525M in annual revenue. Establish and evolve profitability analytics, metrics and KPIs by product and customer segments. My roles and responsibilities include: Develop solid justifiable financial product revenue objectives utilizing various forecasting techniques, revenue assurance investigation, revenue risk analysis and the measurement of monthly results (budget to forecast) to identify variances to budget. Reduced operating expenses by 20% over the past five years while growing revenues by 10% year over year.• Provide monthly financial presentations for various senior level meetings regarding the financial health of the consumer products division. • Establish and expand strong cross-functional relationships across Finance, IT, Legal, and Operations, to manage product requirements, costs, and implementation of project timelines for new and existing initiatives ~$50M over three years. • Serve as the department liaison collaborating with Sprint’s internal data science team to evaluate consumer profiling and purchasing behaviors to improve product revenue growth.• Collaborate with IT to establish data analytical requirements for KPI reporting integrating MicroStrategy dashboards across Teradata and Oracle databases. • Work closely with outside vendors and consulting firms on new and existing product requirements to increase the product portfolio and future revenues for the department. • Manage a team of three product development managers for the consumer product organization.

  • Product Development Manager – Data Analytics, Product KPIs, Product Development

    • Mar 2010 - Feb 2013

    I worked on the New Ventures team that was created to drive new product innovation and incremental revenues across multiple Sprint organizations. My roles and responsibilities included•Worked closely with IT to create a subscriber database repository to track and evaluate customer buying behaviors and create sensitivity and propensity purchasing models to evaluate revenue opportunities.•Collaborated with data analytics modelers to build predictive purchasing models intended to stimulate product purchases using various messaging campaigns.•Served as the department data expert evaluating product KPI trends to analyze purchasing behaviors.•Investigated new product opportunities and developed financial business cases that predicted revenue growth ~$25M, product life-time churn reduction and increased customer lifetime value for big-box retail partners.

  • Wholesale, Strategy and Market Planning Positions (2003 – 2008) Additional Positions

    • Mar 2003 - Feb 2010

    Major Responsibilities included: •Managed outsourced research and analytical consulting firms for larger cross department projects. In addition, performed a number of on-going ad-hoc research studies and monitored the financial performance of partners and industry competitors.•Provided extensive broadband competitive intelligence utilizing secondary research to evaluate and provide executive de-briefings regarding Time Warner, COX Communications, and Comcast.•Performed extensive market, company, and industry research. Participated on a small tactical merger and acquisition team evaluating the operating performance of competitors Sprint was considering as potential acquisitions.

• 

  Insightful Analytics

  • Insightful Analytics, LLC- Managing Partner – Analytical & Data Insights

    • Feb 2003 - Dec 2016

    Managing Partner – Analytical, Financial & Data Insights I co-founded Insightful Analytics, LLC a consulting firm that performed data modeling, financial analysis and market research as well as other managerial consulting work across a variety of industries. Our services at the time included but not limited to:● Predictive analytical modeling ● Increased insight & actionable intelligence about customers ● Category research studies ● Customized financial forecasting & modeling ● Survey analysis and presentations ● Applied statistical software included SAS, SPSS, Excel, AccessBy leveraging data to maximize it's value, we worked with all levels of data when translating raw information into critical business decisions that helped develop and lead initiatives that transformed business decisions.

• 

  Aquila

  • Overland Park, KS

  • AQUILA ENERGY (1999 – 2003)

    • Jul 1999 - Mar 2003
    • Overland Park, KS

    Sr. Manager Product / Market Development Manager (2000 – 2003)Everest, a subsidiary of Aquila was a $300 million funded startup broadband / CLEC telecommunication company in Kansas City that provides dedicated internet access, fixed wireless, local, long distance, E-mail, DNS hosting and cable services within the greater Kansas City metro calling area.• Developed financial business models for consumer data, content and voice products sold in the market place. Product Development Manager Durable Consumer Products (1999 – 2000)Managed the company’s non-utility product lines (HVAC, Water Heaters and Air Filters) in eight mid-west states. New products exceeded first and second year revenue projection by $1.7 million dollars.

• 

  Sprint, H&R Block, Others

  • Pittsburgh, Ohio and Kansas City

  • Multiple Positions

    • Sep 1985 - Feb 1999
    • Pittsburgh, Ohio and Kansas City