Todd Brannon

Experienced data analyst and software developer providing data analytics and full stack software solutions.

๐Ÿ‘‰ todd@toddbrannon.com

Skills & Qualifications

Tech stack

JavaScript
Python
NodeJS
Express
React
Next JS
MySQL
MongoDB
SQL Server
Microsoft Excel
Microsoft Access
VBA
Power Query
PowerBI

Work History

๐Ÿšง SOFTWARE SOLUTIONS & ANALYTICS CONSULTANT | TruSponse.com | Keller, TX

4/2020 - Present

Providing software and analytics solutions for small to medium sized businesses across industries like Financial Services & Investment Advisory, Marketing Consulting, Commercial Leasing & Financing, and Manufacturing.

  • Web Development
  • Microsoft Excel and Access development & consulting
  • Fractional Analyst services
๐Ÿšง BUSINESS ANALYST | Wieck Media | Plano, TX

4/2022 - 1/2023

Managed the SDLC for newsroom website designs, redesigns, and ongoing site maintenance

  • Successfully sourced the IT security consultant to lead Wieckโ€™s ISO 27001 initiative
  • Sourced and screened top-tier contractor candidates resulting in successful software developer hires and consultant engagements
  • Led project scoping and requirements gathering for software development projects
  • Performed discovery, surveys, and stakeholder interviews
  • Developed project phase road maps, documentation & timelines
๐Ÿšง WEB DEVELOPER | Splunk | Remote

9/2021 - 1/2023

Part-time contract role supporting the director of eLearning for various development projects

  • Developed ad-hoc internal solutions to assist instructors with prerequisite course validation for student enrollments in upcoming courses
  • Developed scripts to fetch API data
  • Planned and tested an application that would send an email that contains a direct link to download PDF learning materials from an AWS S3 bucket, requiring an IAM user be created for the python software limiting the permissions to read-only
  • Generated access keys with the required permissions for the application to access AWS S3 buckets
๐Ÿšง TECHNICAL ANALYST (VBA Developer) | AutoNation | Irving, TX

1/2020 - 4/2022

Developed & supported custom applications and self-serve reports for various accounting teams at the AutoNation Shared Services Center using Excel, Access, SQL, VBA, and PowerBI

  • Developed enterprise database application to auto post all in-balance after sale transactions across all dealerships and reduce the need for specialists to review only those transactions that remained out of balance
  • Developed custom desktop database application for the team that processes third party collections, allowing them to eliminate their spreadsheet based workflow
  • Performed and automated ETL operations using SQL and VBA knowledge to create and refresh data tables for use in custom desktop database applications, Power BI reports and dashboards, as well as automated Excel reports
๐Ÿšง SOURCING MANAGER | UT Southwestern Medical Center | Dallas, TX

1/2020 - 12/2019

Managed team of 3 sourcing specialists covering clinical categories

  • Leveraged the GPO contracts to improve supply chain savings
  • Developed sourcing strategies for clinical portion of over $1B in supply spend across acute, ambulatory, clinical lab and research facilities for the system
  • Coached team on leveraging data analytics to develop sourcing strategies
๐Ÿšง ANALYST - SUPPLY CHAIN CONTRACTS | HCA Healthcare | Coppell, TX

6/2015 - 8/2019

Managed analytics and reporting for the North Texas Supply Chain Office

  • Managed analytics and reporting for the North Texas Supply Chain Office.
  • Developed VBA and Python scripts to automate monthly reporting, reducing errors and improving report refresh cycle time.
  • Contributed to contract pricing tier optimization through comprehensive supply chain analytics.
  • Acted as the technical liaison between the Supply Chain Division and Clinical Resource Managers across 12 healthcare facilities, providing support for spend analytics, savings tracking, and contract tier optimization.
  • Over 4 years of experience in managing monthly cost savings tracking reports, enhancing processes using VBA and Python to transform raw data into final report formats efficiently.
๐Ÿšง REPORTING ANALYST | Crossroads Group | Keller, TX

6/2014 - 5/2015

  • Managed client accounts for a small patient satisfaction and experience survey measurement firm
  • Managed distributed team of telephone surveyors to meet monthly and quarterly deadlines and goals for health facility survey projects
๐Ÿšง BID ANALYST - NATIONAL CONTRACTS | Novation | Irving, TX

12/2012 - 4/2014

Provided financial and non-financial analysis for contract bids across all busines units including medical/surgical, capital equipment, physician preference and purchased services categories

  • Supported all phases of contract proposal process through RFI, RFP, BAFO, and final award with product cross reference, pricing analysis, and final scorecard
  • Performed financial analysis of vendor pricing proposals using weighted averages based on historical product usage
๐Ÿšง CLINICAL ANALYST | Novation | Irving, TX

10/2009 - 12/2012

Contributed clinical product expertise as a part of a team of former clinicians

  • Supported MDM efforts with data normalization, classification, and categorization for medical and surgical products
  • Contributed to the development of enterprise product cross reference of over 400 product categories to support contracting business operations

Education

๐ŸŽ“ BA in Business Economics | Ashford University | Clinton, IA

November 2011

Certifications

โœ… Six Sigma Green Belt | Dallas College | Dallas, TX

September 2021

Projects & Accomplishments

๐Ÿ† Built an Order Management system for a gaging, inspection, and metrology company
  • Developed the REST API using Express JS
  • Data stored to MongoDB
  • EJS templating language to render the application using Bootstrap to make it mobile responsive
  • Include user authentication
๐Ÿ† Built a custom Excel spreadsheet report and Access database for private investment and advisory services firm
  • Automation of raw file processing using Python, Power Query, and VBA
  • Final report output accomplished using SQL queries to the database, complex formulas, conditional formatting, and VBA to run the process
๐Ÿ† Developed a web app to store prospects/leads with full CRUD features
  • Developed the REST API using Express JS
  • Data stored to MongoDB
  • EJS templating language to render the application using Bootstrap to make it mobile responsive
  • Include user authentication
๐Ÿ† Built a custom client intake tool in Microsoft Excel
  • Created a dependent dropdown using Data Validation
  • Formulas added for dynamic calculations and passing values from one spreadsheet to another
  • Used VBA to program the feature to save forms as PDF and attach to Outlook email

Additional Project Screenshots