Might be available
(Updated 2020-01-09)Data Scientist
Chicago, IL, USA
Native English
- MySQL
- R language
- Python
Skills (84)
QUANTITATIVE ANALYSIS
STATISTICAL ANALYSIS
KNOWLEDGE MANAGEMENT
MS SQL Server
Python
SUBJECT MATTER EXPERT
R Language
SQL QUERIES
Visual Basic
Excel
TRADING
QUANTITATIVE
DOCUMENTING
Programming
VISUALIZATION
SOFTWARE
PREDICTIVE MODELING
PREDICTIVE ANALYTICS
Risk Management
Oracle
STORED PROCEDURES
SQL
Data Analysis
SQL Server
MySQL
EXCHANGE
Analysis
DERIVATIVES
VBA
CREDIT
SQLite
PROGRAMMER
SECURITIES
DOCUMENTATION
CASH FLOW
PRICING
SYBASE
LIABILITY
Data Migration
Hadoop
BUSINESS REQUIREMENTS
XML
Implementation
QUALITY CONTROL
OOP
SPSS
LEARNING MANAGEMENT
SAS
SYSTEMS DEVELOPMENT
MARKETING ANALYSIS
MATPLOTLIB
MATLAB
SYSTEM DEVELOPMENT
Automation
INSTRUCTOR
Business Analysis
Design
FAS
NUMPY
OPERATIONS
NEURAL
REQUIREMENTS GATHERING
CLINICAL TRIALS
MONTE CARLO
TENSORFLOW
EXPERT SYSTEMS
FORECASTING
NEURAL NETWORKS
FEASIBILITY
OPEN SOURCE
Java
ESTIMATING
PROJECT PLANS
SYSTEMS SUPPORT
COMMERCIAL REAL ESTATE
WORKFLOW
Strategy
TEST PLANS
DB2
Objective C
REAL ESTATE LENDING
AUDIT
DECOMMISSIONING
CPR
Professional Experience
2017-09 - Present
• Assessed credit default swap pricing through predictive modeling methods (e.g. clustering/association model)
• Led requirements gathering and analysis in Agile environment for team members, and other stakeholders.
• Python-based machine learning using pandas, numpy, scikit-learn, boto (accessing Amazon AWS), and TensorFlow
• Performed Bayesian time series and econometric analysis of exogenous market variables, modeled in open source software.
• Developed statistical analysis system in R using components from the tidyverse environment (e.g. dplyr, ggplot, readr, broom). Managed code changes in git, and Jira.
Tools/languages used: R, Python, Spark, AWS, Azure, Excel, SQL Server, SSIS, SSRS,VBA
Client includes: large money-center bank, retail marketing survey firm
2017-05 - 2017-07
Tools/languages used: LaTeX, R, Sweave, Knitr
2009-11 - 2017-05
• Created stress scenarios and programming code for DFAST and CCAR regulatory stress tests for deposits, residential mortgages, and small business loans, saving the banking clients from regulatory fines often in the tens of thousands of dollars. Updated risk summary documents with test results.
• Lead small teams of analysts and developers
• Streamlined market risk procedures, saving time of back office operations, thus reducing staffing hourly needs. Functioned as subject matter expert for OTC interest rate derivatives structure for data migration project. Prototyped and validated Economic Capital, Value-at-Risk, capital adequacy, and credit risk models.
• Conducted business analysis and quantitative modeling of large-scale client/server application and databases saving clients up to $5 million in infrastructure costs.
• Managed and coded application development projects using C++ and Python for clinical trials, market research, and capital markets trading risk management systems.
• Coded global large scale data analysis application with cloud-based tools in Amazon AWS using MapReduce ("divide and conquer") software to produce deliverables in brief timeframes.
• Used Microsoft Azure Machine Learning Studio and Virtual Machines to produce predictive marketing models.
• Served on speaker panels as both a moderator and speaker on topics such as data science, quantitative finance, and information systems. Delivered customized in-depth training on financial concepts and risk management practices.
• Interacted closely with business users, analysts and developers. Wrote software for quantitative analysis of capital markets in statistical languages: MATLAB, R, Haskell, and Python.
• Performed Bayesian time series and econometric analysis of exogenous market variables, modeled in open source software.
Tools/languages used: MATLAB, R, Haskell, Python, matplotlib, numpy, scipy, pandas, scikit-learn Hadoop, MongoDB, Java, C++, Excel, Spark, SQL Server, SSIS, SSRS,VBA, C#, Amazon AWS, LaTeX, Oracle
Clients include: Defined Benefit Pension firms, money-center banks, trading firms, futures exchanges, power/energy quantitative consulting group, medical research institution, and life/P&C insurance company, and proprietary trading firms.
2014-09 - 2017-05
• Recognized as an approachable and experienced instructor combining theory and practice.
Courses taught: Principles of Finance, Information Resource Management, Financial Markets and Institutions, Finance for Decision Makers, Advanced Derivatives
2015-09 - 2016-05
• Text mining trading blotters using awk and Python tools.
• Enhanced the intraday price slope change analysis, useful for detecting insider trading.
• Performed ETL and data migration of unstructured big data sets.
• Maintained big data sets in Google Cloud, querying SQL and noSQL tables
Tools/languages used: R, Python, matplotlib, numpy, scipy, pandas, scikit-learn , SQLite, LaTeX, Markdown
2015-03 - 2015-09
2014-05 - 2014-10
• Revised automation system for OTC portfolio valuation system in Python.
• Advised senior managers of OTC collateral regulations and strategy.
• Conducted business analysis of workflow and data flow throughout the information chain.
• Advised on network and software implementation of data quality control.
• Managed small team of developers and mentored analysts to project objectives.
• Mentored junior staff in financial concepts such as credit downgrade risk, loss given default, and OTC collateral rules from the Federal Reserve Bank (FRB) and European Market Infrastructure Regulation (EMIR).
Tools/languages used: R, Python, C++, Excel, SQL Server, SSIS, SSRS,VBA, C#
2011-10 - 2013-12
• Wrote automation system for OTC portfolio collateral valuation system in Python from a system that originally existed as a multi-spreadsheet VBA automation risk measurement framework, reducing collateral preparation expense by greater than $800,000 annually.
• Assessed FICO credit scoring through predictive modeling methods (e.g. clustering/association model)
• Led requirements gathering and analysis in Agile environment for team members, and other stakeholders.
• Wrote queries and performed analysis on bank proprietary cloud server cluster ("Sandra")
• Eliminated performance bottlenecks and correct computational errors during its conversion to Python environment saving the bank from audit risks and continual recoding of calculations costing $500,000 annually.
• Mentored junior staff members and advised on both financial and technical issues. Mentored junior staff in financial concepts such as credit downgrade risk, loss given default, and OTC collateral rules from the Federal Reserve Bank (FRB).
• Conducted business analysis of workflow and data flow throughout the information chain.
• Consulted on network and software implementation of data quality control.
• Managed small team of developers and mentored analysts to project objectives.
Tools/languages used: R, Python, C++, Excel, SQL Server, SSIS, SSRS,VBA, C#
2008-05 - 2011-06
• Recognized as an approachable and experienced instructor combining theory and practice.
Courses taught: Structured Fixed Income Portfolios, Econometric Analysis, Financial Time Series Analysis
2008-09 - 2009-07
• Led analysis of cash flow at risk systems to extend to all business units having either an interest rate risk exposure or equity market exposure avoiding losses that formerly exceeded $2.5 million.
• Led requirements gathering and analysis in Agile environment for team members, and other stakeholders.
• Wrote complex SQL queries, joins, constraints, and stored procedures
• Assisted and led junior staff on marketing strategy and data process roadmaps.
• Created systems for tracking enterprise risk levels across various business units using multivariate model.
• Produced statistical analysis of energy holding company for senior management.
• Revised and validated PJM power hub market forecasting model using regime switching (peak/off-peak load) and seasonal ARIMA method.
Tools/languages used: Microsoft suite of tools (Excel, SQL Server, SSIS, SSRS), R, SAS, Python, C++, LaTeX, MATLAB
2003-11 - 2007-12
• Created and maintain 3 terabyte data warehouse of mortgage data.
• Managed transition and upgrades of financial analysis and reporting software packages saving the bank up to $250,000 annually in license fees.
• Wrote complex SQL queries, joins, constraints, and stored procedures
• Served as consultant and liaison internally, and to other groups within the organization on matters of computer science theory, risk modeling, and financial engineering using Value-at-Risk, Expected Shortfall, yield curve analysis, and various numerical methods for a $23 billion portfolio of loans.
• Directly managed and mentored interns and other junior staff members.
• Advised on and led projects in Economic Capital, Regulatory Capital (Basel II).
• Taught short courses in market, operational, and liquidity risk through statistical analysis saving the department $35,000 in annual training costs.
• Responsible for systems implementation and business analysis related to streamlining operations for ALM operations, especially related to mortgage-based products and their derivatives.
• Developed and interpreted sophisticated financial models and tools to measure analytics such as convexity, OAS, CPR, Economic Capital, and VaR.
• Led data mining project of methods in knowledge discovery and data visualization of risk-based analytics. Improved and maintained servicing and origination models using MIAC software in the QRM suite of Asset Liability and Servicing tools.
• Acted as the group's Disaster Recovery coordinator. Improved and maintained Business Continuity Plans.
Tools/languages used: QRM, MATLAB, Java, C++, R, VBA, LaTeX, SAS, Oracle, SQL Server
2002-07 - 2003-11
• Wrote procedures to price derivatives, created systems to measure and communicate market risk.
• Performed quantitative analysis of option volatility surfaces; calculated equity option risk measures ("greeks") and higher-order measures (e.g. vomma, vanna, color, charm, speed).
• Implemented Monte Carlo simulation methods to test trading strategies.
• Designed C++ class library for derivatives risk management and accessor libraries to MATLAB and SQL Server.
• Created GARCH risk model for FX swap trading client.
Tools/languages used: MATLAB, C++, Java, R, VBA, LaTeX, bash, SQL Server
Clients include: trading advisory company, hedge funds
2000-10 - 2002-07
• Worked in the derivatives middle office, one-on-one with traders, reconciled accounts, measured risk exposure of fixed-income and energy futures books of $12 billion.
• Led junior staff in meeting analysis deadlines, and taught short courses in middle office risk management.
• Wrote procedures to streamline derivatives processing, created systems to measure and communicate market risk, reducing staffing hourly requirements by $15,000 daily.
• Responsible for systems implementation and business analysis related to streamlining operations for equity, commodity, credit, and interest rate derivatives.
• Supported the unit by: coordinating with operations, systems support, and systems development teams.
• Completed project plans, test plans, training materials, operational procedures, and other documentation related to the systems project life cycle.
Tools/languages used: MATLAB, Objective C, Java, LaTeX, R, VBA, IBM DB2, Sybase
1998-05 - 2000-09
• Created software to track the profitability of commercial real estate portfolios.
• Led system development to measure Treasury Hedge Effectiveness (FAS 133) to avoid audit risk costing approximately $150,000.
• Supervised application development for multiple teams with Asset Backed Securities, MBS, treasury operations, derivatives, and leasing.
• Responsible for the measurement, quantification, and communication of all interest rate and foreign exchange risk. Integrated the front and back office to manage, account, analyze and value debt and derivatives portfolios, covering swaps, caps, FRAs, futures, options, foreign exchange spot and forwards, and bond forwards for derivative books approximately $800 million of notional value.
• Mentored junior staff in financial concepts such as mortgage-backed securities and foreign exchange.
• Led groups on my "Money Tour" campaign to show staff the operations at the Federal Reserve Bank, Chicago Stock Exchange, and the Chicago Board of Trade.
Tools/languages used: C++, VBA, Oracle, SQL Server
Academic Background
2024-11 - 2024-11
2024-11 - 2024-11
2024-11 - 2024-11