MedStar Health

Lead the analytics community of practice and development of data fluency/engagement programs that enable associate upskilling & accelerate analytics ROI.

Enterprise Analytics Manager – Data Fluency & Lead of Community of Practice

Lead the establishment of an enterprise data fluency program, implemented core initiatives & managed the analytics community of practice.

Data Fluency Program Manager

Data Careers Summit

The Data Careers Summit helps individuals break into and move up in the data field. It's held twice per year, and you can learn more about it at DataCareersSummit.com

Co-Founder

-Launch sustainable data analytics programs for local organizations, supporting a range of functions including: sales, marketing, supply chain, operations and IoT
-SME to training platforms for data & strategy course content, and creator of 100+ data analytics and leadership tutorial videos
-Frequent speaker at industry events and podcast host/guest on topics related to data skills and strategy

Analytics Advisor, Consultant & Thought Leader

Wiiisdom

Technical Evangelist & Head of Internal Analytics

Product Manager (Wiiisdom Ops for Tableau)

The Master Lock Company

-Developed and maintained a roadmap of innovative, growth-oriented analytics projects across all functions.
-Launched modern analytics initiatives supporting marketing & digital marketing initiatives.
-Served in a leadership capacity on several initiatives intended to evangelize analytics and upskill data talent, including: analytics mentorship program, analytics council and company's quarterly "analyst day" (mentioned in WTA presentation).

Director, Strategy & Analytics

-Launched new selling tool leveraging diagnostic & predictive analytics; developed/drove processes that lead to business-case ROI being exceeded.
-Won "Game Changer" award for deployment of above project.
-Led data-driven presentations with top customers, leveraging data from customer-facing analytics program developed in prior role at company.

Director, Analytics

-Built and refined a predictive sales forecasting model with +/- 2% accuracy on a six-month basis.
-Launched a range of diagnostic analytics programs supporting company's sales, CRM, IoT, consulting, 8020 and daily huddle initiatives (selected for presentation at Tableau Conference 2019, link below).
-Launched a branded customer-facing analytics program (COMPASS) to deliver mutually beneficial insights to top customers.

Senior Manager, Business Analytics

-Launched an analytics program supporting the Commercial business unit and introduced/evangelized modern analytics tools (including data visualization) throughout company.
-Developed & implemented new forecasting processes that took business unit's forecast accuracy from worst to best in company (>200K unit impact)
-Created & led company's "Forecasting Best Practices Committee"

Manager, Business Analytics & Demand Planning

Harley-Davidson Motor Company

Developed new reporting and provided project management for system enhancements to support product development processes.

Data Analyst

Generac Power Systems

Provided data and financial analysis to channel VPs and sales leadership.

Sales Analyst & Consultant

Over my 12+ years in the data & analytics field, I've become a passionate promoter of the potential this field has to positively transform organizations and the careers of individuals.

In addition to my work as a practitioner in the field, I've frequently collaborated with others to help find ways to promote this potential, including the following:

I co-created and co-host the Data Careers Summit.  The mission of this event is to help individuals learn how to break into and move up in the analytics field. 

I created and co-host the Data Ideas Podcast to shine light on great work being done in the field, and the individuals that do it.

I frequently speak at industry events, on podcasts, during live courses, etc.

If you'd like to get in touch, please send me a PM!

Dustin Schimek

Federal Home Loan Bank of Topeka

•	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

Quantitative Analyst II - Market Risk Analysis

Esperanza Analytic Solutions LLC

•	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

Founder and Independent Data Scientist

Raza Development Fund

•	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

Investment Associate/Senior Analyst/Analyst

Grand Canyon University

•	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)

Adjunct Professor of Quantitative Methods

•	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)

Assistant Professor of Applied Mathematics

Arizona State University

•	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

Graduate Student/Mathematical Modeler/Teaching Associate

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

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 SKILLS
Advanced 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 PROJECTS

1.	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 Neurotransmission
https://repository.asu.edu/items/14832

RESEARCHGATE.NET
https://www.researchgate.net/profile/David_Tello

taplio

The Battle

Dustin Schimek

D. Tello, Ph.D., C.I.D.A.

Followers

Posts

Engagements

Likes

Ready to grow your LinkedIn presence?