Dylan White

• Developed dashboards and reports in Excel and Power BI to support project decision-making and enhance stakeholder communication.
• Analyzed project performance metrics, identifying trends to inform future strategic decisions and initiatives.
• Assisted in budget management by monitoring expenses and forecasting resource needs for ongoing projects.
• Supported risk assessment activities by evaluating potential impacts of data-related issues on project timelines and outcomes.
• Established robust quality assurance processes to maintain data integrity and accuracy across all analytics deliverables.

• Lead analyst reporting to CFO on product pricing, margin analysis and sales forecasting for a beverage manufacturer.
• Analyzed financial data from finance and accounting systems to support budget forecasting and variance analysis.
• Prepared monthly management reports to communicate insights on financial performance.
• Utilized advanced Excel functions to streamline data reporting processes and improve accuracy.

• Analyzed complex data sets to identify trends and provide actionable insights for decision-making.
• Developed and maintained dashboards using visualization tools to monitor key performance indicators.
• Conducted regular audits of data integrity, ensuring consistency across databases and reporting systems.
• Streamlined reporting processes by automating routine tasks, significantly reducing manual workload.

Performed ad-hoc short-term financial analysis and accounting functions for a diverse set of companies.

Projects included:

• Extracted data from ERP system and identified thousands of discrepancies between purchase orders and invoices.
• Analyzed $100k+ of overspent purchase orders to line-item level and collaborated to reconcile data for reporting.
• Pulled data using SQL for 2000+ employees and built custom census reports in Excel for upload.

• Utilized CRM, Excel, Business Intelligence and other enterprise software to build data dashboards (10,000+ monthly users).
• Collaborated with cross-functional teams to gather requirements and define project scopes.
• Forecasted SaaS sales by product line, analyzing real-time gaps between forecast and actuals in a monthly report for CEO.
• Documented business requirements, ensuring alignment with organizational objectives and compliance standards.