D. Tello, Ph.D., C.I.D.A. Email & Phone Number

Topeka, Kansas, Us

• Spearheaded the modeling and implementation of an advanced spreadsheet for market risk valuation purposes (duration, value at risk, key rate duration, Nelson Siegel slope, Performance Attribution, and others) through Advanced Excel functions, Batchcal (i.e., Polypaths windows batch script), and VBA programming• Oversaw monthly stress testing of non-parallel shocks on yield curves by gathering yield curve data from Bloomberg and executing VBA macros that included the use of SOLVER• Developed a LIBOR-SOFR calculator to calculate the gain/loss of market value of LIBOR swaps using VBA and batch script for Capital Market’s Department• Converted a MATLAB code (VaR bell curve analysis) to VBA code and saved MATLAB license fee• Reduced swap valuation process processing time from three weeks to three days by automating several complex structures using VBA programming and advanced Excel functions

• Built three projects: (i) A study of the city of Phoenix, AZ, (ii) U.S. hourly weather data and weather station examination, and (iii) Is a 2020 recession inevitable• Used Python’s pandas to classify the compiled ten-years hourly weather data by state and city, and perform an exploratory data analysis (EDA) on the city of Phoenix, AZ and created visualizations to determine, if on average, temperatures in Phoenix are getting hotter over time• Implemented a Python script to automate the web scrapping, opening, local organizing, concatenating, and wrangling of monthly zip files containing hourly weather observation for all stations in the U.S. into a CSV containing a single year of clean data from National Oceanic and Atmospheric Administration (NOAA)• Devised a 63.6GB CSV file containing over ten-years of hourly yearly data merged with the U.S. weather station data from NOAA by using pandas and Python’s algorithm• Built a Python script to web-scrapped the daily constant maturity treasury (CMT) rates from the U.S. Department of the Treasure website using beautiful-soup, pandas, and request packages• Performed data wrangling with python’s pandas on CMT rates, U.S. real gross domestic product, real personal income, and unemployment rate data from the Federal Reserve Bank of St. Louis• Implemented a time-series analysis and created visualizations to study the leading indicators of U.S. recessions since 1981 to establish patterns leading to causation

Phoenix, Az, Us

• Generated/Co-Authored nine Credit Approval Request and Recommendation for more than $19 million by writing reports and oral presentations to RDF’s Managerial Committee• Achieved more than $43 million of recommended financial structures of potential loan investments through 15 letters of intent • Helped the Chief Investment Officer secure targeted customers for possible expansion in the Chicago Pilsen/Little Village market• Composed spreadsheets to help calculate amortization table, maximum loan amount, and repayment schedule with an interest reserve• Illustrated a spreadsheet to assists with the calculations of ratios for Liquidity, Coverage, Leverage, and Operating Management• Assembled a spreadsheet to evaluate the Uniform Credit Analysis Cash Flow via information from the Balance Sheet and Income Statement

Phoenix, Az, Us

• Delivered lectures that emphasize model development in business emphasizing quantitative/qualitative analysis via Microsoft PowerPoint• Developed Microsoft Excel spreadsheet to demonstrate simple linear regression models concept using FORECAST, CORREL, RSQ, VLOOKUP, and FDIST functions• Prepared a Microsoft Excel spreadsheet to describe multiple regression models concept using CORREL, COUNTA, VLOOKUP, FDIST, LINEST, and TDIST functions• Developed Microsoft Excel spreadsheets to visualize optimization and Monte-Carlo simulation concepts, and modeling application using solver• Developed a spreadsheet to teach Time Series Forecasting Models (moving averages, exponential smoothing, trend projections, and seasonal variations)

Phoenix, Az, Us

• Built a new master-level course in Applied Nonlinear Dynamics (MAT 552) based on Strogatz’s: "Nonlinear Dynamics and Chaos: With Applications to Physics, Biology, Chemistry, and Engineering" textbook• Served as course coordinator for six undergraduate mathematics courses• Served as subject matter expert for the design/re-design of seven undergraduate mathematics courses• Supervised/mentored instructional assistants, adjuncts and dual enrollment high school teachers • Pioneered the use of Microsoft Excel as a substitute for using graphing calculators in business, mathematics, and statistics courses. Findings were presented (with C. Petersdinh) at the 21st Century STEM: Integrate to Innovate Conference on January 2016 in Phoenix, AZ. • Delivered lectures that emphasize model development and its quantitative/qualitative analysis in business, mathematics, and statistics via Microsoft PowerPoint• Participated in the reconstruction of a university-wide mathematics placement exam for science and non-science track majors• Taught master level Applied Nonlinear Dynamics (MAT 552) and Probability Theory (STA 525) course• Taught several undergraduate mathematics courses ranging from pre-algebra to Calculus and Analytic Geometry II• Taught between 250 and 340 students per semester in large lecture halls settings• Awarded two ($1,000) priority research grant from the Center for Innovation in Research and Teaching (declined due to career change)

Tempe, Az, Us

• Conducted research on the biochemical processes of neurons using sensitivity analysis and numerical studies via MATLAB simulations on a system of differential equations• Tested peer-reviewed published computational and mathematical neural models and models of neurotransmission using ordinary differential equations and MATLAB simulations• Evaluated existing research trends in Computational and Mathematical Neuroscience• Achieved Ph.D. level passed (90%+) on Ph.D. Comprehensives in Mathematical Physiology and Stochastic Biology• Received Ph.D. level passed (90%+) on Ph.D. Qualifiers in Mathematical Biology, Mathematical Neuroscience, Probability and Mathematical Statistics• Performed multiple teaching duties as assigned by the School of Mathematical and Statistical Sciences

Ph.D. Applied Mathematics For The Life And Social Sciences, Applied Mathematics And Computational Neurosciences

Master Of Business Administration (Mba) With Emphasis In Finance

Master Of Science (Ms), Mathematics

Bachelor Of Science (Bs), Mathematics