Brandon Wood

About Brandon Wood

Business and Market Analysis Professional with more than 20 years of experience in…

Experience

1. Market Analyst

   Affinitiv

   Sep 2017 — Present · Houston, TX, US

   Reporting to Director level of management, provided market valuation, financial analysis, and data analysis in the Automotive Industry.• Streamlined employee KPI regarding work volume with lightweight SQL database, Python scripting, and Excel reporting. • Created Python with Selenium web scraping program to track customer utilization of various products. • Created Python script for timing data analysis to implement a new KPI for employees and customers.• Created Macro enabled and VBA coded Excel files with interactive dashboards.• Created Power BI dashboard to analyze various aspects of bid data. • Awarded “Top Performer Award” in 2019 for most live appraisals for second year in a row. • Achieved more than live appraisals for FY 2020, an increase of 10% from the previous year.• Acquired $4.1M in inventory for the business unit P&L.• Routinely appraised more than $40MM in automotive inventory monthly.• Optimized Python programs to handle more than 30K records and $500MM in appraisals monthly. TECHNICAL SKILLS:• Data Analysis – Python, Power BI, SQLite with DB Browser, and Visual Studio Code.• Microsoft Excel (V-Lookup, Conditional Formatting, Statistical Formulas, Pivot Tables, Macros, VBA).• Microsoft Office 365 Suite - Word, PowerPoint, Outlook, Access, OneNote, OneDrive, and Teams.• GitHub and GitHub Desktop.• Entry level knowledge of SQL, SQL Server Management Studio (SSMS), and Microsoft Visual Studio.• Google Applications - Gmail, Calendar, Google Drive, Google Maps, Google Earth, Sheets, and Docs.• QuickBooks Desktop and QuickBooks Online. • Online ATS – Indeed and LinkedIn.• Data Entry -\"10 Key by touch.\"• Wide range of Automotive Cataloging and Appraisal Software.

Education

• University of Houston - Clear Lake

  Bachelor of Business Administration (B.B.A.), Business Administration and Management

  2005 — 2007

Skills

• Global Positioning System (Gps)
• Business Strategy
• Account Management
• Microsoft Office
• Team Leadership
• Teamwork
• Loss Prevention
• Gps Units
• Leadership
• Time Management
• Logistics
• Training
• Employee Training
• Business Analysis
• Profit
• P&L Management
• Quickbooks
• Cura 3d Slicing
• Inventory Management
• Customer Service
• Management
• Team Building
• Gps Navigation
• Financial Analysis
• Analysis
• Negotiation
• Scheduling
• Fritzing Pcb Designing
• Strategic Planning
• Supervisory Skills
• Freecad
• Gps Tracking
• Business Planning
• Gps Devices