Steven Graefe Email & Phone Number

West Des Moines, Ia, Us

Westerville, Ohio, United States

Arlington, Va

US Treasury. - Developed and managed SAS scripts used to value portfolios of loans and warrants acquired under the CARES act writing import steps and SQL merges as an initial ETL process.SBA - Developed a stratified random sample of loans for the Paycheck Protection Program across risk categories using SAS procedures. Created detailed documentation for methodology and process description. Imported data using SAS.FNMA - Created an open standard Python implementation of a Knowledge Graph collecting object-relational data together from structured and unstructured sources. Created end user specific results highlighting control violations in a Model Risk Management System. Transformed RDF data for a cloud-based implementation on an AWS instance.Fulton Financial Corporation - Consolidated bank affiliate data from Oracle sources to MS SQL Server utilizing SSIS ETL processes. Simplified client’s existing processes by writing execution scripts in PowerShell. Updated SSIS reporting services for Special Assets.

Chicago

• Managed group projects, collaborating within the team and dividing responsibilities.• Produced daily executive-level performance analytics of intraday trading results including critical breakouts of exchange volume, using software such as SAS and R.• Developed new market quality reports and associated statistics to evaluate quoting performance of exchange participants.• Implemented new database structures and services to distribute recurring and on-demand reports.• Optimized existing processes using both macro and low-level techniques.• Programmatically created high quality visualizations to effectively communicate performance over time.• Solved performance issues associated with handling high-dimensional data via query tuning plans using Oracle specific hints and reliable SQL methods.• Optimized Fee schedules for trading permit holders using statistical methods.• Coordinated processes within complex enterprise-level automated scheduling systems.• Fulfilled both internal and external requests for data within exchange self-regulatory framework.• Installed group wiki and led best practices for process documentation and database descriptions.

Chicago

Built portfolios and structured data sets. Utilized quantitative, research, and problem solving skills to analyze historic stock, mutual fund, treasury and index databases.Developed methodology for market indexes by creating benchmarks and back-testing historic index performance.Sold data to commercial and academic clients. Provided statistics and portfolios from client specifications.Created recurring update processes for custom products, from initial planning with clients to finished deliverables using a variety of computing environments and statistical packages for major clients.Increased the visibility of the department by providing data and analysis for major news media organizations resulting in new sales leads.Negotiated specifications for data agreements and permits with consideration for intellectual property concerns.Collaborated in a multifunctional team to follow up on sales leads and license violations.Developed integrity checks for data quality issues from client feedback and research.Reviewed academic research papers for emerging data quality concerns and marketable uses of financial data. Published news feeds reporting on reviewed academic texts.Provided technical support to clients for software, programming, and data quality related issues through remote assistance and training sessions.Identified and managed product defects and other Quality Assurance issues.Wrote documentation and descriptive articles for common software configuration issues, data quality concerns and programming considerations.

Master Of Business Administration (Mba), Finance; Statistics

Bachelor Of Science (Bs), Finance, Information Systems