Business Analyst Resume

Experience

11/09 - present Confidential, New York, NY
Consultant / Business Analyst - Global Financial Risk Management: Credit

• Developed robust Workflow and Reporting software for the As-Agent team, using Access/VBA/SQL, SQL Server, Excel/VBA, and Outlook/VBA
• Developing and supporting Reporting software for the Municipal team, using Access/VBA/SQL
• Developing, automating, and generating various Reports, using Excel/VBA/SQL

10/09 - 11/09 Confidential, New York, NY
Consultant / VBA Developer
• Developed software for writing and editing research publications in accordance with the firm’s new branding, replacing an expensive vendor product, using Word/Excel/VBA
(Three-month contract, completed ahead of schedule; was offered long-term contract)

1/09 - 10/09 Confidential, New York, NY
Consultant / Reporting Analyst - Operational Risk: Equity Derivatives Reconciliation
• Developed robust software for Trade Break Reconciliation, using Excel/VBA/SQL, replacing a vendor product Merrill had unsuccessfully spent millions trying to integrate with their systems
• Developed, automated, and generated various Reports and Metrics to facilitate the Bank of America acquisition, using Excel/VBA/SQL and Cognos; Developed other tactical solutions
(Reason for leaving: Left to pursue other opportunities after completing all available projects)

4/08 - 1/09 Confidential, New York, NY
Consultant / Reporting & Data Quality Analyst - Prime Brokerage: Client Data Management
• Developed robust software to monitor and analyze Data Quality, using Excel/Access/VBA/SQL
• Developed software for Prime Brokerage Metrics Reporting, using Excel/Access/VBA/SQL
• Performed Time Spent Analysis and Forecasted Resource Utilization, using Excel/VBA
• Performed Referential Data queries and helped develop stored procedures, using Access/Sybase/SQL
• Developed Reports and performed Project Planning, using PowerPoint/VBA, Project, and Visio
(Reason for leaving: Company’s policies regarding consultants changed due to market downturn)

3/07 - 1/08 Confidential, San Francisco, CA
Consultant - Alternative Investment Company
• Modeled the firm’s Actively Managed Structured Product (CDO) for Funding Hedge Funds, using Monte Carlo simulation, Excel/VBA; Developed Client Presentation materials, using Excel
• Helped place capital with hedge funds, independent traders, and CTAs
(Reason for leaving: Company unable to raise capital after CDO market collapse)

1/05 - 11/06 Confidential, New York, NY
Execution Trader - $150m AUM Hedge Fund
• Executed position and short-term equities trades in the Biotech and Healthcare sectors
• Developed custom Technical Alerts and other trading and research tools, using Excel/VBA
(Reason for leaving: Fund had 60% draw-down)
Quantitative Analyst - $80m AUM Hedge Fund
• Designed and lead development of the fund’s Risk Management system, including VaR, Stress Testing, and tracking error optimization, using Excel/VBA, SQL Server, REDI+, Reuters, and Bloomberg
• Developed spreadsheets for Trade Break Reconciliation, Options Analysis, Equities Analysis, validating P&L, and Investor Presentations, using Excel/VBA, Reuters, Axys, and REDI+

11/03 - 12/04 Confidential, New York, NY
Assistant Trader - Subsidiary of $800m AUM Hedge Fund
• Executed position and intraday equities trades for a $10m diversified long/short portfolio
• Learned advanced technical analysis techniques and trading principles

3/02 - 9/03 Confidential, New York, NY
Quantitative Analyst - Technology Arm of Proprietary Broker-Dealer
• Developed and implemented long/short equities Trading Systems, using Excel/VBA
• Designed and lead development of tools for Risk Management and order management

Education

• BA in East Asian Studies
• Extensive coursework in Finance, Statistics, and Computer Science

Skills

MS Office: Excel/VBA, Access/VBA, Word/VBA, PowerPoint/VBA, Outlook/VBA, Project, Visio
Development: SQL Server, ADO, RAD, SDLC, DBArtisan, SourceSafe, Matlab, Cognos, S-PLUS, C++
Software: Bloomberg, Thompson Reuters, Capital IQ, REDI+, Recon, Frontier, Geneva, Axys, PerTrac
Statistics: Risk & Portfolio Management, Data & Factor Analysis, Regression, Datamining, Forecasting

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship