Martin Bauer Email & Phone Number

Livonia, Michigan, United States

Detroit Metropolitan Area

Goals: Develop and implement business intelligence solutions in order to form company and project strategies and drive data-driven decisions for business stakeholders• Built an equipment management dashboard using historic project data in order to track spend and usage and drive efficient capital allocation for future projects• Analyzed sales and costs associated to labor, materials, equipment and subcontractors to improve operational efficiencies• Created a man-hour report that integrates project data from various sources and analyzes financial metrics such as: Gross Profit per man-hour, Sales Revenue, COGS, etc. broken down by multiple parameters such as: Month-Year, Department, Account Rep, Complexity, etc.• Presented interactive reports to Operations Managers and shared how they can utilize the reports to measure financial and operational performance• Identified savings opportunities by creating a procurement report that highlights spending trends across variables such as: time, department, product, and geography

Detroit Metropolitan Area

• Built PowerBI dashboards that visualize data related to digital marketing, customer engagement, and website traffic and provide reporting and insights for key business stakeholders• Translated business requirements into technical specifications, outlining timelines for project milestones • Utilized DAX queries and functions within Power BI for advanced data manipulation• Communicated insights to business stakeholders geared to improve marketing strategies and planning• Created and enhanced a dynamic PowerBI dashboard that functions as a makeshift CRM tool to keep track of client website enrollment• Obtained extensive training in PowerBI including: Data Modeling, PowerQuery, and DAX functions

• Collaborated with data science team to track inventory shipments from the supplier to several warehouses and communicated results to the client• Analyzed data regarding the factors that affect inventory levels in a Supply Chain through EDA and statistical analysis• Gathered insights from multiple delivery teams on how industries were responding to the impact of COVID-19; findings include: increased focus on digital retailing, limiting asset and inventory waste, and cost savings initiatives• Learned how to analyze data and find insights using tools such as: Microsoft Excel, SQL, and R* COVID Layoff

Greater Detroit Area

• Prepared financial statements for month end close process and identified improvement areas in audit prep• Utilized Excel functions like VLOOKUP and INDEX/MATCH to automate SG&A reports and reduce reporting time for the Finance team• Communicated to upper management on cost reduction strategies and increased efficiency in reporting and analysis