Todd Brannon

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

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

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

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

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

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

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

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

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

November 2011

September 2021