Python Developer

BRANDON C. HOFFMAN

*********.******@*****.*** https://github.com/branhoff 773-***-****

TECHNICAL SKILLS

• Programming Languages: Python JavaScript Java C++ SQL

• Tools: AWS Django O Notation Numpy Pandas Matplot OOP Docker Algorithms React Angular CSS Flask Openpyxl Git Data Science Algorithms Data Structures WORK EXPERIENCE

Python Developer Contractor – Transfer Pricing Accounting; Amazon; Seattle, WA June 2020 - Current

• Engineered an application to recursively navigate shared network folders and return relative folder sizes for inputted hierarchy depth

• Worked on creating the Docker containers and to integrate Python 3 with Python 2 legacy code in backend for TP team’s agreement automation calculation tool

• Planned, deployed, monitored, and maintained Amazon AWS cloud infrastructure consisting of multiple S3 buckets to Transfer Pricing Archive from outdated Amazon Drive infrastructure

• Optimized SQL queries with newer statements that utilize table indexes and adhere to SQL best practices

• Developed a solution to refresh monthly, inconsistently formatted accounting calculation files. Developed test plans, test scenarios and test cases to automate quality and accuracy automation of journal entry upload process

• Built Levenshtein distance string scorer application to compare non-identical strings to allow for non-communicative databases to integrate data points within Pandas DataFrame

Sr. Financial Analyst; Python Dev – Global Asset Management; Bank of Montreal; Chicago, IL August 2017 – June 2020

• Conduct data regression analysis in Python for a variety of investment factors utilizing Pandas and Numpy

• Wrote Python programs/scripts to automate tasks for client service team and global investment teams: o Constructed automated equity attribution consolidation script to combine 400 excel files into 10-15 excel workbooks categorized by strategy name. Shortened a manual multi-day process to a scheduled Python application that runs in less than 5 minutes on a monthly basis

o Saved the firm $140,000 by automating the monthly strategy commentary in house rather than purchasing and outsourcing a vendor solution by pulling from Factset API and transforming data within Pandas DataFrame o Automated quarterly request script for BMO GAM’s Multi-Asset Strategy Team to send requests automatically and track and log responses to limit human error of inbox management o Updated BMO GAM’s Short Duration Investment Team’s holdings dashboard to pull from InvestorTools API into xlsx files then transform data with Pandas

o Developed BMO GAM’s Investment Equity Team to build an automated attribution aggregator which shortened a 7-hour process into a 11-minute process

Consultant – Project Controller Practice; Deloitte Consulting; Chicago, IL May 2015 - June 2017

• Budgeted and tracked the profitability for 14 projects for Eli Lilly exceeding $22 million dollars in revenue by utilizing SQL and Python Database Management

• Drove and managed all financial processes and systems to allow Deloitte partners to sell work to clients unimpeded by cash flow or profitability concerns

• Implemented client Invoice tracking system to compile and clarify complicated client invoicing system so any Deloitte resource can easily invoice when necessary. Average collections period was reduced from an average of 66 days to 63 days in my tenure Accountant – Victory Church; Acworth, GA Jun 2014 - April 2015

• Day to Day management of $900,000 in assets composed of leadership and duties regarding accounts payable, accounts receivable, budgeting and forecasting, and all bookkeeping duties SIDE PROJECTS

• Open Source Python Class: Developed Jupyter notebooks of exercises and explanations to learn Python and Computer Science concepts

• Stardew Valley Optimization: Stardew Valley is an ingenious little “farming simulator” among many other things. In order to calculate the most profitable outcome in the game, I wrote an object oriented program that calculates compound return of crops

• VWAP vs SMAP Research Project: Data science project in beta that means to see of a Volume Weighted Average Price model is more predicative in stock trading than a Simple Moving Average Price model EDUCATION

Bachelor of Science in Computer Science; Oregon State University; Corvallis, Oregon – expected graduation: Spring 2021 Bachelor of Business Administration in Finance, Evangel University; Springfield, MO

Contact this candidate