Nick Leonard Email & Phone Number

Jacksonville, Florida, Us

Principle financial model architect for large scale projects within Web.com. Each model is highly automated and optimized to account for immediate scenario sizing, multiple full year revenue impacts, and perfectly reconciles to the General Ledger. Listed below are a few examples of my work in FP&A:Yodel Financial Model (one of Web.com’s largest acquisitions): I redefined how bookings are categorized and recognized by designing an OLAP cube that allowed for actuals to be updated at a moment’s notice. I built a daily net revenue tracker that gave executives the ability to make swift decisions as the month progressed. This structured allowed me to forecast an organization with 500 sales reps and $150 million dollars of annual revenue with a 1% margin of error. The first iteration of the cube and financial model were built and ready to use in one month.Web for Enterprise Financial Model: I built this revenue model using a bottoms up approach that allowed for detailed variance reporting at the client level for this $75 million dollar line of business. The model is flexible enough to analyze full year revenue impacts for hundreds of multi-location enterprises. All of this was accomplished in one month. Built a detailed P&L that forecasts EBITDA by natural account and service accurately.Commissions Expense Model: I built this expense model from the ground up by using an algorithm that accurately forecasted millions of monthly commissions expenses by accounting for sales velocity, headcount, number of days in the month, incentives, and product changes.

Jacksonville, Florida, Us

Lead all analytic efforts for the eCommerce, DIY, Field Sales, and LBW divisions.Advised senior management on strategic marketing decisions regarding churn reduction and revenue growth. Built business cases for all new pricing and promotion scenarios. Developed innovative cohort churn model that calculates the Life Time Value of customers by lead channel.Create custom reports that illustrate the product performance trends that drive strategic marketing decisions.

Create scalable measurements that maximize the efficiency, visibility, and performance of RailAmerica's Commercial Group.Facilitate the Forecasting and Budgeting of company carloads and revenue. Interpret RailAmerica's performance projections through custom dynamic reporting.Developed the commercial revenue forecasting model through the use of SAP Business Objects. This model was used to forecast all sales related revenue items for the entire company (outside of industrial development). Project Manager: Use linear programming to plan the Annual Budget, Monthly Forecast, SAP BPC Implementation, Microsoft CRM Implementation and Erosion Management Analysis. Facilitate 5 Year Commodity Forecast and all Commercial analytics for the 10k.

Project Manager for the implementation of a suite of e-Business tools that streamline the process efficiency for our customers.Built CRM system through Microsoft Sharepoint that individually tracked the implementation status of each customer. Developed KPI's that calculated the levels of implementation, customer automation, and projected automation levels. These reports were used on earnings calls with Wall Street Analysts. Initial expectations were 75% automation within 12 months. I achieved 93% automation within 12 months.

Bba, Marketing

Green Belt / Lean, Six Sigma