Dan L. Email & Phone Number

Southfield, Michigan, United States

• Cross-Team Consulting/Report Formulation: Worked with a variety of divisions including product lines, regions, finance, and upper-level management to create and edit reports relating to revenue growth, sales volume projections, profitability, internal data consistency, and current market trends.• Data Output Efficiency: Extensively redesigned multiple Microsoft Excel workbooks and implemented automated calculations, interconnected worksheets, macros, and general formatting changes to facilitate the efficient creation of recurring reports with the fewest possible errors.• MS Excel Expertise & Adaptability: Completed recurring assignments as well as various one-time reports and special requests as needed, often requiring creation of new Microsoft Excel workbooks that utilized any number of the following: V, H, and X lookups, PivotTables, nested functions, conditional formatting, charts/graphs, macros, and embedded formulas.

• Independent Operation: Independently developed and operated a division within the company dedicated to the invention and manufacture of batched carry-out cocktails for sale to customers during the COVID-19 pandemic.• Cost/Profit Analysis: Tracked and ordered inputs/ingredients for product manufacturing and used Microsoft Excel to: determine cost per unit of product inputs, determine profit margins for all products, and determine ideal pricing for products based on labor, cost of inputs, and profit margins.

Michigan, United States

• Client Relations: Worked with a client (an early-stage startup planning to provide alcohol/beverage service packages to wedding venues) to plan and develop specifications for packages to be offered to vendors.• Spreadsheet Creation: Developed a Microsoft Excel workbook involving interconnected worksheets and extensive embedded formulas to determine prices of specific and custom packages for vendors based on desired inclusions.• Report Automation: Used Microsoft Excel to automatically calculate specifications of packages including required staff, wage & tip rates for aforementioned staff, and required quantities of beverage inputs based on a single data point (number of wedding attendees).

Lansing, Mi

Partnered with the Michigan DNR to perform research on community interaction with elk-based viewing and recreation activities in Michigan. Developed Statement of Work outlining scope of project. Helped to develop and distribute survey through DNR to gather data for analysis.Used Tableau to provide visualization and analysis of data from survey results toshow useful trends/patterns. Regularly met with project group and client to ensure tasks were being completedon schedule.Compiled findings into a final report and one-page executive summary to presentat Michigan DNR office.