Summary - Doug Guthrie



Doug Guthrie6405 W. 45th Ave Wheat Ridge, CO 80033 (303)570-7872 douglas.p.guthrie@SummaryCreative and passionate Data Analytics professional with over 7 years of experience working in fast-paced positions involving the design, development, and maintenance of multi-faceted analytical projects and tools. Technical SkillsMicrosoft SQL Server Python SSIS Tableau Excel / AccessPostgreSQL Git JavaScript RExperienceManager, Data Analytics, AMG National Trust BankJan 2018 – PresentRedesigned analytical tool suite used in development of financial packages for clients utilizing Python, Django, MS SQL Server / PostgreSQL, and Bootstrap4 / jQuery (previous tool suite was linked MS Excel spreadsheets)Developed a relationship pricing model utilizing the software stack above that allows our bank to make profitable loans in a rising rate environment Senior Financial AnalystFeb 2016 – Dec 2017Created and maintained a data warehouse for banking data from the FDICUtilizing the data from the FDIC, successfully researched and presented to the bank’s Board of Directors justification for higher loan concentrations (contrary to regulator guidance) that enabled the bank to operate in more profitable termsPublished various Tableau dashboards to our internal server environment thereby increasing managements’ visibility to KPIs Financial Reporting Analyst, AMG National Trust BankJul 2013 – Jan 2016Redesigned the bank’s reporting function with the creation of a data warehouse in MS SQL Server as well as numerous ETL processes using SSISSuccessfully integrated a company’s ERP system with custom-built software as part of a fractional CFO agreement with a multi-million-dollar companyEducationMetropolitan State University of Denver – Denver, CO – Bachelor of Science in FinanceSumma Cum Laude (3.89 GPA)AdditionalInformationLinkedIn: in/douglas-guthrie-07994a48GitHub: : ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download