Trevor Frey

Works with clients and internal teams to define requirements and troubleshoot issues across CRM and ERP systems. Built training videos and end-user documentation for a new CRM rollout and led adoption efforts. Builds custom reports in Crystal Reports and SQL, and designed dashboards that give consultants one place for KPIs and documents. Leads system testing and user training, and reviews configurations for optimization opportunities.

Ran financial analysis on prospective investments using horizontal and vertical analysis, plus ratio analysis for liquidity, profitability, and solvency. Mapped the food system by products and daily calorie consumption to find investment opportunities.

Analyzed current business performance and projected future conditions, then brought recommendations to supervisors. Worked through regional merchandise reports to pull out insights for strategic decisions.

Built Excel spreadsheets to calculate retroactive pay for city employees after union contract changes. Set up a database to compare competing bids for city services. Processed property tax over and underpayments and issued refunds or notices.