David Roloff

• Led the monthly and quarterly review of Safety, Sensing & Industrial Components (SIC) business inventory reserves.
• Analyzed slow-moving, excess, and obsolete (F&O) inventory data, providing actionable recommendations to Finance department for inventory management improvements.
• Maintained and enhanced productivity and inventory dashboards, facilitating real-time tracking and decision-making.
• Interpreted trends and presented clear, concise summaries to facilitate strategic decision-making.
• Collaborated with Finance, Product Management, Operations, and Sourcing to validate data and ensure alignment on inventory priorities.

• Reconciled financial books for six stores in Milwaukee by processing daily A/P and A/R.
• Automated financial reporting from Acumatica data using Power BI to enhance reporting efficiency.
• Documented current and future procedures by creating cross-functional process maps with MS Visio.
• Proposed re-engineered solutions to manage incorporating new and existing technologies.

• Spearheaded data conversion project for Play Monster, managing migration from SQL 2000 and SAP to NetSuite through analysis, scrubbing, and mapping of legacy data.
• Collaborated with cross-functional teams to develop and optimize business process flows, facilitating seamless integration of daily operations into NetSuite platform.
• Developed detailed process maps using MS Visio, transforming workflows into NetSuite-compatible structures, enhancing operational efficiency.
• Executed data scrubbing and validation processes, preparing legacy data tables for migration into NetSuite templates to ensure accuracy and data integrity.
• Designed and deployed real-time reporting dashboards using Power BI, DAX Logic, and Excel Power Query, providing actionable insights throughout the project.

• Engineered dynamic Power BI reports and dashboards to automate daily functions across multiple departments, thereby enhancing operational efficiency.
• Built and implemented scorecards, calendars, gauges, and interactive graphs to deliver real-time insights and support data-driven decision-making.
• Leveraged DAX functionality and Excel Power Query to develop comprehensive data models that provided actionable insights for management and employees.
• Utilized advanced Excel Power Query skills to automate financial reporting processes, minimizing manual effort and enhancing accuracy.
• Collaborated with cross-functional teams to tailor Power BI reports, ensuring data visualization aligned with business objectives and departmental needs.

• Verified quality of gameday baseballs, confirming compliance with standards post-preparation by Milwaukee Brewers clubhouse tech and storage in MLB-approved humidor.
• Monitored clubhouse and bullpens for unauthorized electronic equipment usage by players, coaches, and staff to uphold MLB regulations.
• Observed stadium cameras to ensure proper feed and investigated any unauthorized cameras or camera usage throughout the venue.
• Coordinated with a 3rd party Authenticator, the Milwaukee Brewers ballboy, and MLB Umpires to maintain an adequate quantity of approved gameday baseballs.
• Assisted game umpires with pregame procedures, handling Gameday Baseballs, Lineup Cards, and Rosin Bags to ensure readiness.

Delivered critical data-driven insights that refined business processes and optimized resource allocation, enhancing overall operational performance.

• Analyzed and mapped cross-functional production processes through detailed flowcharts, identifying key areas for operational enhancement and facilitating interdepartmental coordination.
• Optimized inventory management by applying Lean Six-Sigma principles to SKUs for Just-In-Time delivery of custom-made products.
• Projected future sales, established annual budgets, and set measurable KPIs to drive organizational growth and ensure financial alignment with project goals.
• Contributed to launch of LUSH Homes project aimed at constructing affordable, environmentally friendly housing for lower-income families, aligning with Lange Bros Woodwork's long-term vision.

• Formulated mission and vision statements to align employee efforts with organizational goals.
• Prepared annual budgets and financial statements for fiscal year business operations.
• Re-engineered processes for enhanced efficiency and negotiated sales contracts for reduced pricing at scale.
• Converted tax designation from LLC to 501c3, enhancing fundraising capabilities and community support.
• Established referral sources throughout the community, fostering ongoing partnerships and resource sharing.
• Recruited, trained, and managed volunteers for various projects and outings.

• Executed ERP/NetSuite activities, including business requirements gathering, system design, workflow analysis, setup, and configuration, aligning systems with client objectives.
• Managed data mapping and conversion from ERP systems such as SAP, ensuring accurate transfer of critical business information into new ERP environments.
• Developed custom reports and dashboards to provide actionable insights and enhance client decision-making.
• Participated in process engineering and solution design, optimizing workflows to enhance system efficiency and support business goals.
• Provided direct training and ongoing support to end-users, facilitating successful system adoption and continuous improvement.

• Streamlined overall operations, significantly reducing labor hours and operational costs, which improved profit margins.
• Led cross-functional teams to identify inefficiencies and recommend strategic changes that improved the organization's project delivery and operational effectiveness.
• Developed process maps for each department, optimizing workflows and aligning strategic objectives to restructure the business.
• Documented and validated operational procedures to ensure accuracy and efficiency before departmental implementation.
• Partnered with ownership, providing project updates and insights to inform business decisions and improve project outcomes.

• Managed a team of 7 direct reports, ensuring high performance and successful execution of a full spectrum of corporate actions and financial services for a diverse client portfolio.
• Enhanced departmental operations by automating 90% of daily processes and communications through a customized MS SharePoint site, resulting in improved team productivity.
• Leveraged SQL expertise to automate key organizational processes, driving efficiency gains and reducing manual tasks across the department.
• Collaborated with cross-functional teams to integrate automated workflows, resulting in improved accuracy and accelerated turnaround times for corporate actions processing.
• Implemented strategic process enhancements that improved operational efficiency and elevated client service levels in alignment with company goals.

• Automated daily transactions using SQL, optimizing the reconciliation of 300,000 accounts.
• Led implementation of Albridge performance platform, streamlining operations and increasing data accuracy.
• Reconciled General Ledger accounts for over 300 accounts daily, ensuring accuracy in trading and performance metrics.
• Directed 8-member Manager-in-Training team, improving daily reconciliation outcomes.
• Trained team members in reconciliation and automation tools, enhancing team skillset and operational effectiveness.

• Supervised a team in conducting thorough performance reconciliations, ensuring accuracy and compliance with regulatory standards, which resulted in a 15% reduction in discrepancies over six months.
• Developed and implemented streamlined processes for data analysis and reconciliation, improving efficiency by 25% and enhancing reporting accuracy.
• Collaborated with cross-functional teams to identify and resolve performance-related issues, enhancing operational efficiency and increasing team productivity.
• Trained and mentored junior staff on reconciliation procedures and best practices, promoting continuous improvement and knowledge sharing.
• Utilized advanced analytical tools to generate reports and insights, supporting informed decision-making and strategic planning initiatives.