Post Job Free

Resume

Sign in

Business Analyst Development

Location:
Knoxville, TN
Posted:
February 23, 2024

Contact this candidate

Resume:

David Bowman, MBA

Knoxville, TN

865-***-**** ad3u5j@r.postjobfree.com LinkedIn Profile

Summary

Dynamic and results-driven Business Analyst with more than 20 years of experience with enterprise-level projects in public and private sectors. Demonstrated knowledge in all areas of analysis. A details-oriented problem solver who is highly effective in team building and providing cross-functional support. A trusted, driven leader with a proven record of getting results.

Related Skill sets

•Tools/Software: MS Office (Excel, Access, PowerPoint, Word), R Studio, Google Analytics, Google Merchant Center, @Risk, PowerShell, JMP, SPSS, GAMS, Limdep, EazyStock, Acumatica (ERP), Tableau and Power BI.

•Industry Strengths: Business Analysis, Forecasting, Innovation, Implementation and Integration, Technical Writing, Stakeholder and Executive Engagement, Process Optimization and Improvement, Strategic Planning, Change Management, Risk Analysis, Simulations, Business Development.

Education

•Master of Business Administration (MBA), University of Tennessee, 3.98/4 GPA, MBA Class President Dec 2020

•Bachelor of Science in Economics, Tennessee Technological University 3.0 GPA (4.0 GPA in major) May 1992

Professional Work Experience

BB Industries, Knoxville, TN Jun 2021 - Jan 2024

Senior Business Analyst - Tasked with helping the company make better decisions through data. Cross-functionally worked with all departments and reported directly to the CFO. Frequently worked with senior leadership and presented findings to the C-Suite. BBI is a nationwide wholesale distributor with over 5000 products, 150 vendors and 40,000 customers.

•Created a suite of KPI reporting tools including sales and margins, On Time In Full, returns and back-order reports.

•Developed and performed a weekly gross-margin variance analysis.

•Developed a multivariate regression model to forecast state-level customer demand.

•Forecasted weekly demands for 10+ delivery vans. Saved the company $500k in misallocated inventory.

•During a period of volatile supply chain issues, implemented a statistics-based, lead time prediction tool.

•Using a monthly building permits database, created county-level customer demand maps.

•Created an algorithm to predict customer reorder times and recommend products using similar customer purchases.

•Oversaw the creation of a Customer Attrition model to predict if and when a customer would become lost.

•Oversaw the creation of a monthly web scraping program to gather competitor intelligence data.

•Designed and implemented a Customer Segmentation analysis.

•Worked with the VP of Sales to initiate “contract” pricing using distributions of prices paid by different customers.

•During an ERP transition, worked with the CFO to reconcile and update data over one million transactions.

•Maintained a database combining customers, vendors, inventory, transactions data from old and new ERP systems.

•Built geo-located territory maps for traveling salespeople.

•Merged van GPS data with customer longitude and latitude points to help optimize customer visits.

•Developed a statistics-based Strengths Weaknesses Opportunities Threats (SWOT) analysis for each sales associate.

•Analyzed available data and developed a process improvement plan for Google Ads sales.

•Managed BBI’s internship program.

MuCat Technologies, Knoxville, TN Jan 2021 - May 2021

Business Analyst (Consultant) - Performed a situational analysis for MuCat, a medium sized technical staffing firm.

•Using Mergent Intellect and other proprietary company databases, collected market intelligence on key competitors.

•Conducted a SWOT Analysis for MuCat. Presented the results to the C-Suite.

•Designed a plan to restructure the invoice and billing processes, reducing overall process time by over 90%.

Oak Ridge National Laboratory, Oak Ridge, TN Jan 2000 - Dec 2020

Senior Economic Analyst - As member of ORNL’s Energy Analysis Group, I investigated a broad range of topics related to energy systems and energy policy from the perspectives of market efficiency and energy security. Worked in a multidisciplinary team with a focus on forecasting and market analysis.

•Served as Project Lead for a U.S. Department of Energy (DOE) supported effort to forecast crude oil prices. Used Excel, R-Studio, PowerShell and Limdep (statistical software). Results were used by the U.S. government as auction reserve prices for U.S. SPR crude oil purchases and sales valued over one billion dollars.

•Using Access and Excel, created and maintained a database of over 1000 crude oil assays. Assays were collected, reconciled, and missing properties were estimated using petroleum industry standard methods.

•Using models created in-house and @Risk simulation software, performed the Benefit Cost Analysis for DOE’s Long-Term Strategic Review of the Strategic Petroleum Reserve. The report resulted in over $1B in capital expenditure.

•Using GAMS, forecasted future vehicle and energy markets for DOE and evaluated the effects of policy choices.

•Winner of Oak Ridge National Laboratory’s 2017 Significant Event Award.



Contact this candidate