Brett Lorek Email & Phone Number

Morton Grove, Illinois, United States

𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐥𝐢𝐭𝐢𝐞𝐬As a seasoned leader in IT, I currently direct the ERP development team, Level II / III support team, QA Testing team, and Analytics team while ensuring quality and exceeding expectations. I use my expertise in developing and implementing strategies that drive efficiency, productivity, and growth. With a strong focus on analytics and automation, I have been able to identify patterns, generate insights, and optimize processes throughout the organization.• Direct the ERP Development Manager to deliver application and infrastructure solutions while ensuring design, development, and quality meet expectations that align with the business’ strategic initiatives. • Lead the Support Desk (level II-III) and QA team by mentoring the manager on best practices with a dedicated focus on team communications, prioritization, and SLA monitoring/analysis.• Identify, prioritize, and lead project management for automation opportunities to reduce manual workload throughout the organization.

8338 Austin Ave, Morton Grove Illinois 60053

𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐥𝐢𝐭𝐢𝐞𝐬Responsible for prioritizing and leading analytics solutions throughout the organization with a focus on cost saving insights related to production spend, inventory management, and financial analysis. • Direct Analytics department to identify and generate business insights. • Sprint planning, backlog grooming, and scrum leading Analytics Projects𝐊𝐞𝐲 𝐀𝐜𝐡𝐢𝐞𝐯𝐞𝐦𝐞𝐧𝐭𝐬𝐒𝐮𝐩𝐩𝐨𝐫𝐭 𝐃𝐞𝐬𝐤 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬•Implemented Analytics around support desk intake to identify patterns and trends. Utilizing the trends/patterns the business was able to develop targeted training to reduce submitted tickets.•Spear headed automated Support Desk reporting to increase visibility business managers that include SLA status and issue status.𝐄𝐧𝐭𝐞𝐫𝐩𝐫𝐢𝐬𝐞 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐨𝐧 𝐒𝐨𝐥𝐮𝐭𝐢𝐨𝐧𝐬•Utilizing Microsoft Power set (Power Apps & Power Automate), developed a fully automated PTO tracking solution that included submissions forms, approval routing, and end user reporting.•Utilizing Jira automation and Jira Service Management, developed portals for Project request/initiation for departments to reduce admin work for departments outside the IT ecosphere.

8338 Austin Ave, Morton Grove Illinois 60053

𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐥𝐢𝐭𝐢𝐞𝐬Continue to be the lead advocate for analytics and the importance throughout the organization.Strategize with Senior stakeholders on how the department's analytical skills can further support the business by identify sources of truth, accurate and measurable KPIs, and actionable insights. Implemented a management solution that focused on how projects were identified and prioritized, data validation strategies to support analysis, development process to meet objectives, end-user testing, and all other components for a full development cycle. Utilize my business analysis skills to identify and create solutions within the organization, that modernize and automated existing process across the enterprise to optimize resource allocation.𝐊𝐞𝐲 𝐀𝐜𝐡𝐢𝐞𝐯𝐞𝐦𝐞𝐧𝐭𝐬𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐌𝐚𝐧𝐚𝐠𝐞𝐦𝐞𝐧𝐭 𝐒𝐨𝐥𝐮𝐭𝐢𝐨𝐧•Identified on opportunity to better manage resources, improve estimating capabilities, and reduce development time switching to Jira.•Generated and presented fit-gap analysis, cost benefit analysis, and future resource skill analysis to C-Suite•Lead and developed customized Jira solution to fit business need •Increased estimate accuracy, improved stakeholder visibility, reduce development time, and increase ability for resource allocation𝐒𝐭𝐚𝐧𝐝𝐚𝐫𝐝𝐢𝐳𝐞 𝐑𝐞𝐩𝐨𝐫𝐭𝐢𝐧𝐠 𝐂𝐚𝐭𝐚𝐥𝐨𝐠•Developed a standard and uniform reporting catalog across the business•Provided accurate KPIs and actionable insights to internal and external stakeholders•Reporting and Analysis is fully automated, easily accessible/digestible, and shift staff time from generating reporting to utilizing data

8338 Austin Ave, Morton Grove Illinois 60053

𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐥𝐢𝐭𝐢𝐞𝐬Tasked with identifying and implementing a reporting software infrastructure by gather requirements throughout the business, performing a gap fit analysis, and presented back to the business.Implemented a Business Intelligence (BI) tool, Tableau, as well as develop and administer Tableau Server which grew to 200+ users logging in 5k+ views a month.𝐊𝐞𝐲 𝐀𝐜𝐡𝐢𝐞𝐯𝐞𝐦𝐞𝐧𝐭𝐬𝐈𝐎𝐓 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬•Develop a solution that would provide clients with visibility into which POS made it to the market, where the POS was distributed, and measure crowd interaction. •Utilizing multiple IOT vendors, data was gathered via API and consolidated in a SQL Server database•Create a uniform data model, generated analysis via Python, and visualized to stakeholders through Tableau•Insights reduce POS Spend and via A/B testing custom target marketing implemented𝐈𝐧𝐯𝐞𝐧𝐭𝐨𝐫𝐲 𝐌𝐚𝐧𝐚𝐠𝐞𝐦𝐞𝐧𝐭•Developed a uniform inventory management solution that is fully automated utilizing modern the methodology•Utilizing different forecasting models (Time Series & Moving Average) suggested reorder amounts are provided to end users. The forecasting models results are evaluated and then dynamically chosen on a SKU level.•Implemented across the business reducing inventory levels, driving down cost for clients, while meeting KPIs•Reduced wasteful over production spend and reduce time to identify replenishment rates

8338 Austin Ave, Morton Grove Illinois 60053

8338 Austin Ave, Morton Grove Illinois 60053

8338 Austin Ave, Morton Grove Illinois 60053