Business Intelligence and ERP Analytics Leader

Mitcheal Davis

Business Analyst Reporting ETL Professional

********@*****.*** 574-***-****

Results-oriented business process professional with hands-on experience in leading multiple facets of business intelligence and analysis, quality assurance, digital marketing, customer relationship management, data analysis, and ERP management across various diverse sectors.

Qualifications Summary

●Proven success in creating and analyzing business intelligence platforms from Infor BI to Power BI, including processes, products, services, and systems to improve current procedures and provide profitable insights.

●Demonstrated ability in steering strategic planning and driving process improvement along with leveraging strong creative communication skills to ensure complete customer satisfaction.

●Instrumental in conducting on/offshore analysis, generating detailed reports, and collaborating with all levels of management to increase operational efficiency.

●Prudent in overseeing management of resources and delivering robust solutions to ensure resolution of complex issues and achievement of exceptional results.

●Articulate communicator and leader with talent of building strong relationships and team strength through mentorship, guidance, and support along with leading to ensure achievement of project requirements.

●Proven collaborative D365 experience with post migration support to give end users a favorable experience

Career Experience

Spartan Tool, Niles, MI Nov 2023 - Nov 2025 Business Analyst

As Business Analyst I lead most business process, reporting and other data initiatives. Working with D365 F&O and CE platforms to help maintain day to day functionality and spearhead improvements.

●Colab with various teams to analyze variances between forecasted and planned

●Facilitate Microsoft D365(F&O and CE) modifications, all support tickets, access and update testing and any other company needs to maintain ERP functionality

●Work within leadership team to help guide and implement process improvements

●Develop reports and dashboards in Power BI

American Tire Distributors, Huntersville, NC (Remote) Feb 2023-Jul 2023 Sr. Business Intelligence Analyst

Senior team member on BI initiatives for multiple departments. Creating innovative and informative dashboards using Power BI, Dax, extracting data from Oracle via Snowflake and Google Cloud.

●Work with stakeholders and data engineers to meet business reporting needs.

●Power BI Desktop to design modern reports and in-depth analysis of various business issues across different departments.

●SQL coding to query Snowflake, SQL Server and Google Cloud

Conn-Selmer Inc., Elkhart, IN Aug 2018 to Feb 2023 (Hybrid) Business Intelligence Engineer

Lead development of company's BI project, encompassing designing, creating, and implementing Power BI for both international and domestic use. Design reports and dashboards (Infor BI, Power BI). Create and preserve SQL Server data warehouse for usage in Infor BI and Power BI. DevOps for process management.

●Converted business intelligence platform from Infor BI to Power BI, Dax coding, educated workers, and launched new product as well as developed and monitored ETL process.

●Fulfilled requirement for two less servers and saved organization approximately $15K per year in maintenance expenditures by rewriting data queries and data cubes.

●Ground level participant in migration from Infor XA to Microsoft F&O, utilizing Synapse and Azure

●Worked with internal and external sources to manage tickets for ERP migration and SQL database requests, and reporting needs

●Use of DevOps for resource planning and project tracking

Lebermuth Company, South Bend, IN Aug 2016 to Aug 2018 Data/BI Analyst

Managed manufacturing context, including problem solving for laboratory, sales, buying, regulatory, and several production departments. Utilized Power Bi and SQL Server to oversee planning, development, and design of metrics/reports. Delivered support to numerous applications via data purification and modification for usage in web APIs. Collaborated with management to identify and priorities business and information needs. Deployed and maintained digital signs for corporate communication and KPI data.

●Analyzed data and delivered to end users via modeling, visualization by using Power Bi and Excel.

●Conducted detailed research in preparation for the company's entrance into California.

●Educated and mentored Power BI to sales, lab, accounting and executive teams to improve skills of members.

●Designed analytics package for delivering assistance to executive team in selection to establish third-party warehouse or company-owned warehouse.

The Tire Rack, South Bend, IN Jan 2011 to Feb 2016 Online Quality Assurance Analyst

Oversaw project flow and error reporting by utilizing Intuit QuickBase and JIRA software. Redeveloped new retail and mobile websites for major projects. Conducted on/offshore analysis for new site projects. Utilized VMware virtual environments for testing in many browsers. Cooperated with development, design, and marketing teams to evaluate advertisements and company-maintained website initiatives.

●Enhanced user experience by contributing in development and modification of systems.

●Performed several levels of testing, such as functional, regression, user acceptability, integration, and performance in Agile environment.

●Met deadlines by creating testing scripts for projects and communicating in collaborative setting on daily basis.

●Enabled mutual understanding of procedures and applications by serving as communicator among business and technical people.

The Tire Rack, South Bend, IN May 2006 to Jan 2011 Purchasing Support Agent

Directed product and coordination from order to delivery for six distribution facilities, as well as setting up product returns for warranty, defect, and shipping damage. Supported sales team with pre- and post-sale activities. Developed connections with vendors through daily interaction to follow shipments, discover product availability, address price concerns, and obtain new product information. Aligned statements, aided accounting with problems, and compiled reports for key stakeholders.

●Retained $10 to $15 million in annual purchases from several vendors.

●Resolved inquiries from a 100-person customer service/sales team about tracking merchandise, setting up drop shipments to clients, and sharing product expertise.

Additional Experience

The Tire Rack, South Bend, IN Receiving Mgr./ Product Specialist/Purchasing - (2000 to 2011)

Education

Master’s in Business Administration Concentration

Business Management, Capella University – 2020

Bachelor of Science in Business Concentration

Management Information Systems, Indiana University South Bend- 2015

Course highlights: SDLC process, Project management, Systems Analysis, Data Management, Systems Implementation.

Technical Skills

SQL Server, D365 (F&O/CE),Infor XA, Infor BI, DevOps, Power Bi, Power Platform, Visual Basic, SAP (multiple modules), MS Office Suite, Office 365, Visual Studios, VMware, Jira, QuickBase, DAX, Snowflake, Google Cloud, Synapse

Some exposure to: Azure (SQL), RPGLE, C++

Contact this candidate