Todd Brannon

Software developer and data analyst creating web solutions, Excel and Access solutions, as well as providing data analytics.

πŸ‘‰ 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 - from web apps to custom spreadsheets to custom desktop databases

  • 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

  • VBA and Python programming to automate monthly reporting processes reducing errors and improving the cycle time SLA for refreshing monthly reports and analytics
  • Contributed to contract pricing tier optimization efforts via analytics across the supply chain division
  • Technical liaison between the Supply Chain Division and Clinical Resource Managers across 12 division healthcare facilities providing support for spend analytics, savings tracking, and contract tier optimization
🚧 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