Sql Server Manager

Ryan Michael Shuell

**-** **** ******, **** Island City, NY, 11101: C: 917-***-**** E: **********@*****.***

SUMMARY:

Over 10 years of experience working with large scale data analytics projects, ranging from issue identification to remediation, all with a focus on capital markets, credit risk, market risk, operational risk, business risk, and risk & regulation

Over 10 years of experience designing and delivering process improvement solutions, including big data analytics, business intelligence, data management, and data quality & governance

Over 10 years of experience automating countless processes using C#.NET, VB.NET, SQL Server, Access, Excel, VBA, R, and Python

Possess excellent technical, listening, documentation, communication skills, and great team management skills

Possess a strong customer focus and proactively broaden and deepen countless client relationships

Well versed with Data architecture and IT infrastructure, with a focus on completeness, timeliness, completeness, comprehensiveness, clarity and usefulness of all data sets (BCBS 239 and Regulation 165(d))

PROFESSIONAL EXPERIENCE:

12/16 – Current Citi, Manager of Process Improvements

Developing automation scripts to help the Citi credit card marketing controls team standardize multiple business processes, to dramatically reducing the time to complete work streams, and completely eliminate errors in reporting

Documenting clear and robust operating procedures for all solutions and underlying technical design decisions

3/15 – 11/16 PricewaterhouseCoopers, Manager

Developed pricing tools to calculate discounted cash flows (DCF) for over 6,400 bonds, based on credit spreads, cash flows, and rates, while accounting for different LIBORs, asset classes, currencies, tenors, and fixed/floating properties of bonds

Developed SQL Server database which aggregated dozens of Excel files to produce reports for BCBS 239 & Reg. 165(d), for the largest banks in the world

Managed teams of 10-12 people to conduct comprehensive model validation, for stress testing (DFAST), and capital planning (CCAR)

Led the development of advanced business analytics and data mining solutions on over a dozen client projects

2/13 – 3/15 S&P Capital IQ, NYC, Quant

Designed and implemented investment screens, strategy simulations, factor backtests, and portfolio optimization processes

Managed analytic projects, which led to ability to capitalize on opportunities to cross-sell and up-sell to clients

Developed and implemented new product initiatives, and managed custom data solutions from concept to execution/delivery, across different channels and geographic markets

Led multiple engagements in the BI space in terms of solution, architecture, and final delivery to bother internal and external groups

Independent Consultant New York, NY (November 2006 – February 2013)

HSBC, VanEck Global, Deutsche Bank, Blackstone, Yahoo!, Ambridge Partners, and JP Morgan

Developed MS Access databases to run ETL processes (taking data from raw form, to user-friendly form, for financial reporting purposes and financial modeling purposes)

Created underlying analytics to feed reports for probability of default (PD), exposure at default (EAD), and loss given default (LGD), for credit risk calculations

Used SQL Server to develop a library of dynamic queries for financial performance reports, trading-related reports, time series reports, dashboards, KPIs, and various other types of BI reports

Developed stored procedures and user defined functions to construct, and rapidly test/iterate exploratory analyses that revealed profit insights and opportunities

Developed VBA code (both Excel and MS Access) for the purpose of automating financial reporting to the General Ledger and Profit & Loss (P&L) reconciliation and creating financial reporting and variances on a monthly basis

Automated the process of checking out and checking in hundreds of Excel files into a SharePoint site, to facilitate asset management processes

Developed an optimized risk models to automatically calculate risk exposures for financial transactions.

Used VBA to program six Access databases for cash management, securities trading, asset value reporting, and pricing of all insurance sales deals

TECHNOLOGIES:

Microsoft Office 2010 & 2013, including Word, PowerPoint, Excel, Access, Outlook, MS Project, MS SharePoint, Oracle Crystal Ball (Fusion Edition), as well as Windows 7, and Windows 8

Advanced knowledge of VBA, RAD, Visual Basic, VB.NET, ASP.NET, C#.NET, MS SQL Server Management Studio, SQL, Transact-SQL, and Stored Procedures (SProcs). Working knowledge of SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), HTML, & XML, R, and Python

EDUCATION:

Completed all reading requirements for CFA, FRM, & CAIA

MBA, Finance, Johns Hopkins University, Baltimore and Washington, D.C.

CLU & ChFC, Chartered Life Underwriter & Chartered Financial Consultant

American College, Bryn Mawr, PA

BA, Psychology, University of Connecticut, Storrs, CT

Contact this candidate