Capital Markets Research Analyst / Database Manager Resume

SUMMARY

Data analyst adept at automating reporting tasks and designing data visuals using VBA, SQL and Python. Six - year tenure with financial media firm publishing corporate debt research and building a data product from the ground up. Additional experience managing distressed loan pools during the financial crisis.
Clear, concise writing chops.
Data analysis - experienced at cleaning, aggregating and visualizing data sets
Loan and bond legal documentation - skilled at reviewing credit agreements and bond indentures
Technology skills -VBA, SQL, Python (pandas, bokeh)

PROFESSIONAL EXPERIENCE

Capital Markets Research Analyst / Database Manager

Confidential

Responsibilities:

Research and data analyst publishing insights on leveraged loans and high-yield bonds for a niche, online financial media outlet - skilled at delving into data and producing digestible interactive visuals
Expanded Confidential 's new-issue market coverage from a concept in 2011 to a standalone product in 2017, now encompassing every junk-rated corporate issue in North America ($921 billion of newly issued debt in 2017)
Built a searchable database and information feed to house private markets data collected by journalists, serving as business analyst to develop two generations of browser-accessible front-end interfaces
Four years of experience writing scripts in VBA and Python, cleaning data and automating reporting tasks
Provided business intelligence metrics and created dashboards for senior management - wrote content metric reporting tools in Python

Asset Securitization Analyst

Confidential

Responsibilities:

Analyst on Confidential desk - helped finalize structuring model in VBA and create marketing materials - priced bank's first CLO structure in North America
Focus laid in creating cash CLO structures - sizing tranche notionals and performance triggers to meet ratings agency criteria as well as investor needs for return; presented structure in risk control group meetings to gain approval for business
Tracked monthly performance of auto, trade and CDO/CLO securitizations purchased into group's ABCP conduit
Kept current RAROC measures for deals in conduit (ABS/CDO/CLO/Project Finance) for communications with risk control
Performed loan level credit analysis on pools of residential mortgages and corporate high yield debt, projected asset cash flows and cumulative default risks using structuring models
Created loan warehousing database in Excel and updated it for tracking, pricing, and reporting on loan positions
Provided analysis for hedging outstanding leveraged loan balances when credit markets soured in 2007

Human Resources - Training

Confidential

Responsibilities:

Created development programs for hotel staff including business writing, food & beverage service standards
Developed curriculums for the programs, conducted training and provided evaluation reports to management
Established annual staff speaking competition to give junior employees an opportunity to stand out to their supervisors