Trevor Crow Email & Phone Number

New Bremen, Ohio, United States

• Created, tested, and maintained reports and ad-hoc queries, delivering actionable information to support business and customer requirements.• Designed and developed analytic and reporting solutions tailored to the Business Intelligence platform, ensuring optimal performance.• Fine-tuned reports and dashboards, utilizing advanced BI tools and techniques to improve efficiency, speed, and aesthetic design.• Collaborated with business stakeholders to analyze data, understand business needs, and translate them into detailed technical specifications.• Built, enhanced, and supported data models and extraction processes from multiple databases, ensuring seamless data integration and optimal performance.

New Bremen, Ohio, United States

• Utilized Microsoft Power BI and SSRS to design, automate, and distribute comprehensive weekly and monthly reports. Reports encompassed key performance indicators (KPIs), trends analysis, and actionable insights for both internal teams and external stakeholders.• Implemented and maintained robust tracking mechanisms for lift truck activity using proprietary company software. Worked closely with customers to ensure accurate and timely data capture, facilitating informed decision-making and operational efficiency improvements.• Proactively monitored and addressed daily truck alarms, swiftly resolving issues to uphold seamless business operations and minimize downtime. This proactive approach ensured uninterrupted workflow and adherence to operational benchmarks.• Played a pivotal role in collaboration with cross-functional teams, including Business Intelligence Developers, Application Developers, and Data Scientists. Contributed to the development, refinement, and optimization of over 10 SQL queries, enhancing data extraction, transformation, and loading processes critical to business analytics and reporting initiatives.

New Bremen, Ohio, United States

• Utilized Microsoft Power BI and SSRS to develop and distribute 30 detailed reports to both internal stakeholders and external partners, providing comprehensive insights into operational metrics and performance indicators.• Collaborated closely with Business Intelligence Developers, Application Developers, and Data Scientists to collectively develop and refine more than 15 SQL queries. These queries were pivotal in enhancing data extraction, transformation, and loading processes critical to business intelligence initiatives.• Spearheaded the review and consolidation of 30 additional SQL queries, contributing to the creation of a comprehensive master guide detailing data sources utilized across the Data Services department. This initiative streamlined data management and improved accessibility for analytical purposes.• Engineered a robust Business Review Requests Archive, compiling and organizing over 2,300 rows of data. This repository served as the foundation for a dynamic Power BI dashboard, enabling real-time tracking and analysis of report usage by the Data Services department since 2019.• Played a key role in optimizing battery settings for more than 1,800 Crown and customer Infolink modules, specifically updating BHM and BDI configurations. These enhancements resulted in a notable 7% increase in overall customer battery health, enhancing operational efficiency and customer satisfaction.• Ensured accuracy and reliability of departmental business systems by meticulously updating over 7,000 customer records. Updates included critical information such as Customer Names, Addresses, and Customer Go-Live status, facilitating streamlined operations and improved data integrity.

New Bremen, Ohio, United States

• Contributed to a cohesive team environment in the Cylinder Cell Department, working alongside 10 team members to ensure efficient assembly line operations.• Took charge of overseeing the daily assembly of more than 300 individual parts essential for constructing cylinders used in Crown Lift Trucks. This involved meticulous attention to detail and adherence to quality standards throughout the manufacturing process.• Facilitated seamless daily operations by coordinating with team members to receive and organize deliveries of approximately 250 parts. These parts were meticulously sorted into categorized bins, optimizing workflow and ensuring readiness for assembly line usage.• Managed the integration of company software, specifically Crown360, to meticulously clock in and out nearly 50 daily part orders. This meticulous tracking ensured accurate inventory management and smooth workflow transitions, contributing to overall operational efficiency.

Master Of Business Administration - Mba, Data Analytics

Bachelor Of Science In Business Administration - Bsba, Information Systems And Business Analytics & Intelligence, Summa Cum Laude

High School Diploma