D. Tello, Ph.D., C.I.D.A. Email and Phone Number
I am a cross-disciplinary, business-oriented, and problem-oriented applied mathematician (Ph.D. Arizona State University 2012) with expertise in computational and mathematical modeling, fixed-income modeling, and credit and financial modeling. I possess over six years of progressive experience in data analytics, quantitative development of market risk models, credit analysis, community development finance, financial underwriting, real estate finance, and risk analysis.CORE COMPETENCIES AND ACHIEVEMENTS• Stellar dealmaker and dynamic communicator: Negotiated multi-million commercial real estate investments, term refinances, and bridge and gap financing opportunities.• Writer/presenter of five technical reports: 15 invited scientific lectures/poster presentations in Chile, Peru, and the United States; and more than $100,000 in academic/travel funding.• Polished and confident speaker: Communicated effectively with well-designed materials the Nelson-Siegel-Svensson (NSS) model used to model non-parallel shocks on yield curves at the FHLB Topeka’s Market Risk Analysis Committee (MRAC)RELEVANT SKILLSAdvanced Microsoft Excel (Dynamic Arrays, XLookUp, IFS, Pivot Tables, Power Query), Batch Programming, Credit and Financial Analysis, Data Cleaning, Data Wrangling, Quantitative/Qualitative Data Analysis, Mathematical Modeling, Microsoft PowerPoint, Python Programming (GUI, Numpy, Pandas, Web Scraping), Research Investigation, Statistical Modeling, Statistical Analysis, and Visual Basic Application (VBA) Programming.EXAMPLES OF DATA SCIENCE/DATA ANALYTICS PROJECTS1. A Study of the City of Phoenix, AZ (https://www.linkedin.com/feed/update/urn:li:activity:6607212642736185344/)2. U.S. Hourly Weather Data and Weather Station Examination (https://www.linkedin.com/posts/tellodavid_pandas-part4-activity-6603615849213493249--_sU/)3. Is a 2020 recession inevitable? (https://www.linkedin.com/posts/tellodavid_is-a-2020-recession-inevitable-activity-6585982960867115008-U30t/)4. Building A Dynamic MxN Matrix in VBA (https://www.linkedin.com/feed/update/urn:li:activity:6857933592673304576/)5. Generating Strong Password Using VBA (https://www.linkedin.com/feed/update/urn:li:activity:6816686554552111104/)You can look at the Featured Section for more VBA and Python coding examples.Ph.D. Dissertation (ASU, May 2012)Title: A Mathematical Model of Dopamine Neurotransmissionhttps://repository.asu.edu/items/14832RESEARCHGATE.NEThttps://www.researchgate.net/profile/David_Tello
Federal Home Loan Bank Of Topeka
View-
Quantitative Analyst Ii - Market Risk AnalysisFederal Home Loan Bank Of Topeka Mar 2020 - PresentTopeka, 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
-
Founder And Independent Data ScientistEsperanza Analytic Solutions Llc Dec 2019 - Present• 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 -
Investment Associate/Senior Analyst/AnalystRaza Development Fund May 2016 - Aug 2019Phoenix, 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 -
Adjunct Professor Of Quantitative MethodsGrand Canyon University Jan 2015 - May 2016Phoenix, 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) -
Assistant Professor Of Applied MathematicsGrand Canyon University Aug 2012 - May 2016Phoenix, 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)
-
Graduate Student/Mathematical Modeler/Teaching AssociateArizona State University Jan 2005 - May 2012Tempe, 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
D. Tello, Ph.D., C.I.D.A. Education Details
-
Arizona State UniversityApplied Mathematics And Computational Neurosciences -
Grand Canyon UniversityMaster Of Business Administration (Mba) With Emphasis In Finance
-
University Of MichiganMathematics
-
University Of Illinois ChicagoMathematics
Frequently Asked Questions about D. Tello, Ph.D., C.I.D.A.
What company does D. Tello, Ph.D., C.I.D.A. work for?
D. Tello, Ph.D., C.I.D.A. works for Federal Home Loan Bank Of Topeka
What is D. Tello, Ph.D., C.I.D.A.'s role at the current company?
D. Tello, Ph.D., C.I.D.A.'s current role is Data Analysis | Data Analytics | Data Visualization | Quantitative Finance | Quant Developer | Python | Visual Basic Application | Advanced Excel (Dynamic Arrays, Pivot Tables, Power Query) | Research | Applied Math.
What schools did D. Tello, Ph.D., C.I.D.A. attend?
D. Tello, Ph.D., C.I.D.A. attended Arizona State University, Grand Canyon University, University Of Michigan, University Of Illinois Chicago.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial