Ryan Huffman Email & Phone Number

Apex, Nc, Us

Raleigh, North Carolina, United States

• Created Duo’s first ever historical reporting database to track bookings insights by Customers, Tier, Industries, Geos, Partners, Product Type and Sales Organization.• Rebuilt the file used to prepare for forecast calls to enhance analytics, improve forecast accuracy and automated the file refresh process to create additional capacity for analysis during each forecast cycle.• Responsible for Duo’s Month-End and Quarter-End reporting process and setting annual targets.•… Show more • Created Duo’s first ever historical reporting database to track bookings insights by Customers, Tier, Industries, Geos, Partners, Product Type and Sales Organization.• Rebuilt the file used to prepare for forecast calls to enhance analytics, improve forecast accuracy and automated the file refresh process to create additional capacity for analysis during each forecast cycle.• Responsible for Duo’s Month-End and Quarter-End reporting process and setting annual targets.• Presented Duo’s results and forecast to the Senior Director of Security Finance and provided additional business context behind the results as well as guidance on future risk / opportunities within the business.• Developed a model to be able to look back at historical subscription renewal rates to more accurately forecast outcomes within Duo’s renewal business and explain causes of any forecast deltas.• Pioneered development granular reporting of ARR metrics to be able to understand the health of different aspects of Duo’s business from a recurring revenue perspective.• Created ad-hoc financial models to assess potential profitability of new offers or product promotions.• Lead Duo’s annual long-range forecasting process to provide a granular forecast of Duo’s Bookings, Revenue and Margin for the upcoming 4 years.• Developed Power BI dashboards with more than 14,000,000 data points for bookings and recurring revenue to create previously unavailable insights and enhance the speed and availability of getting data.• Primary resource for reporting insights for leaders in Sales, Product Management, and Marketing.• Created an annualized bookings dashboard to assist stakeholders in their preparation for reporting calls.• Responsible for reviewing / approving deal proposals with nuanced discount requests from Sales.• Lead training series to help team-members uplevel their skills. Topics included Power Query, Power Pivot, Advanced Pivots, Dynamic Arrays and Power BI. Show less

Raleigh, North Carolina, United States

• Led weekly forecast meetings with sales managers for our department's US Public Sector and Americas Service Provider Theaters and advised Directors on setting their forecast while taking into account the managers' outlook, pipeline metrics, historical compares and VP expectations.• Automated the Forecast File creation process for all five departments in our organization saving our Finance team 3+ hours weekly.• Created a 1-click solution to running our legacy Sales Pipeline… Show more • Led weekly forecast meetings with sales managers for our department's US Public Sector and Americas Service Provider Theaters and advised Directors on setting their forecast while taking into account the managers' outlook, pipeline metrics, historical compares and VP expectations.• Automated the Forecast File creation process for all five departments in our organization saving our Finance team 3+ hours weekly.• Created a 1-click solution to running our legacy Sales Pipeline Report using Power Query and SFDC while reducing file size of the report by 90%.• Quickly and efficiently consolidated 2,000,000+ rows of historical data to create previously unseen views of pipeline trends. This exercise was initially intended to be a project central to an internship to be done over the course of the summer but I ended up completing it in one day using data analysis tools.• Leveraged Power Automate, Power Query and VBA to create a Bot that calculates and summarizes prior week attainment. This process is required to be performed on Sunday to distribute the results to all sellers across the Americas. Using the Bot reduced the amount of time to complete the process by 85% and eliminated the possibility of having manual errors.• Rebuilt our team's monthly and quarterly reporting packages by creating 100+ pivot tables and charts summarizing our business results and creating new strategic insights for leaders. By rebuilding each of these reports I was able to greatly simplify the process while allowing greater data capacity for growth compares that look father back.• Investigated compensation inquires and partnered with leadership to provide fair and consistent resolutions.• Facilitated monthly forum for Financial Analysts globally to share ideas and best-practices.• Reviewed expenses to determine the correct monthly accruals amounts to submit to leadership. Show less

Raleigh-Durham, North Carolina Area

Raleigh-Durham, North Carolina Area

Raleigh-Durham, North Carolina Area