Daniel Carr Email & Phone Number

Fortress Investment Group:•Lead business analyst and report developer for Credit Group trading analysis application. Created reports using SQL Reporting Services and Dundas Charts. Also created underlying stored procedures using SQL Server 2005 •Developed ISDA/Legal database to be used to manage Swap contracts. Applications developed using Sharepoint and MS Access•Business Analyst for project to move time-series and historical data to SQL Server 2005. Data was previously available through Fame interface. Successfully migrated to Thomson/QA Direct and Global Insight. Also created views, stored procedures and functions off QA Direct and Global Insight databases. Created reports using SQL Reporting Services and Dundas Charts•Developed Invoice Management application using MS Access and SQL Reporting Services•Used SQL Server Integration Services to automate the import and export of trading information to various Prime Brokers•Designed OTC Back Office automation services through the use of T-Zero and DTCC (Mark-It)•Created ‘Short Stock Ban’ analysis tool used to comply with new SEC shorting restrictions.Blackstone:•Developed automated P+L Reporting and Analytics system using VB.NET, Infragistics, Crystal Reports, and SQL Server 2005•Created real-time reporting application in VB.NET and Crystal Report which links to client’s Portfolio Accounting System (VPM) using the VPM API•Developed real-time analytics tool which allows users to enter price/volatility/technical trigger amounts for specific securities. The application connects to Bloomberg real-time using BB API and continuously checks if the trigger amounts have been met and notifies user if they have been met

•Developed automated P+L Reporting system using VB.NET and SQL Server 2005•Created a mutual fund holdings analysis and reporting tool using VB.NET (WinForms), SQL Server 2005, Crystal Reports and Bloomberg API. Tool offers hedging recommendations based on portfolio changes and company exposure. Also allows graphical grouping, drill-down and analysis at several levels such as currency, index, security type and industry•Developed idea and application for a universal dynamic reporting tool. Created using VB.NET (WinForms) and SQL Server 2005. Tool allows the results of any in-line SQL or stored procedure to be displayed in a DataGrid or Excel Spreadsheet. Drop-down boxes and labels are created dynamically. Application may access SQL Server, Oracle or DB2•Designed Index Referential application using VB.NET, SQL Server 2005, MS Excel and Bloomberg API. Application extracts prices from Bloomberg and associates one or more securities with a given SG ID. Beta calculations and various data quality checks are performed on the data prior to it being used for hedging•Created Security application which allows any .NET object to be easily secured

•Created P/L Decomposition tool using ASP.NET, C#, ASP 3.0, VB 6.0, Crystal Reports and SQL Server 2000. Process (which is required by FSA) analyzes trades and decomposes P/L into several components: Theta, Interest Rates, Credit Spreads, Basis (MTM Price-Theoretical Price), Intraday Trading, Funding and Net Accrued Interest. Advanced reporting allows user to view P/L changes of variable date ranges with different groupings. •Developed technical architecture (using Oracle 8.1.6, SQL Server 2000, VB 6.0 and ASP 3.0) and business specs for Total Return Swap Analysis tool. Created packages, functions and stored procedures which analyze a client’s current reference assets and return a ‘pass’ or ‘fail’ result determining if the newly selected bond, term loan or revolver would fit into their portfolio. Tests occur at industry and borrower level to verify bank is not overexposed. This will automate all trade decision making for Total Return Swaps, First Loss Swaps and Second Loss Swaps. Prototype built in Visual Basic 6.0, SQL Server 2000, ASP 3.0 and Crystal Reports 9.0. Managed team of 3 developers and 1 business analyst.•Developed web-based IPV (Independent Price Verification) application for Credit Derivatives Middle Office. Automated processes which had previously required 4 business days per month to complete. Shortened process to 15 minutes by using SQL Server functions and stored procedures. Program uses Bloomberg dll to gather asset-swap and z-score data for CDS pricing. Technologies used were ASP.NET, C#, Visual Basic 6.0, and SQL Server 2000.

•Designed and built several applications for Asset Securitization and Portfolio Management which forecast principal prepayments for a portfolio of (RMBS) residential mortgage-backed securities. Based on the PSA standard prepayment benchmark. Developed in SQL Server 2000, Visual Basic 6.0 (ADO), Access 97 and Excel 97. Also created an add-in which performed performance analysis and comparison of different tranches.•Conceptualized a Fixed Income global reporting tool which consolidated multiple reporting applications into one reporting application. Application allows users to generate customized reports from various data sources (SQL Server, Oracle, Access). Managed team of 3 developers and 1 business analyst. Technologies used include Classic ASP, Visual Basic 6.0 (ADO), SQL Server 2000 and Crystal Reports 8.0. Tool allowed advanced performance analysis at several levels through drill-down capability.•Created a ‘Portfolio Tracker’ application for Equities Trading. Database stores traders’ holdings and connects dynamically to Bloomberg. Constantly updates and displays ‘biggest movers’ in portfolio.•Analyzed workflow of Security Operations’ manual reconciliation process. Proposed an automated process using Access 97. Application was successfully developed and has functioned for over 3 years without minimal human interaction

•Created financial and statistical models for Business Banking Group using Excel/VBA. Analyzed demographic data to identify most profitable ‘target groups’. Sales increased by 21%. Senior management used models to decide when and where to place television advertisements•Converted New Account Opening Database from Access 97 to Visual Basic 6.0 and SQL Server 2000 to support/coincide with a regional advertising campaign. New database was accessed by more than 75 concurrent users in two Call Centers•Created the first Lockbox Database System which generated revenue of $80,000 per year. This relational database was used as a model for several other databases throughout the bank and was designed using Access 97 and Visual Basic 5.0• Developed First Fax Reporting which decreased error-tracking time from 4.8 minutes (per error) to less than 10 seconds (per error)•Streamlined and wrote procedures for the account opening processes (ADP, ZBA, ACH, Sweep To Line) which decreased average setup time from 8.5 days to 2.25 days

• Taught Economics, Statistics and Database Design at Lesotho Agricultural College• Led twelve seminars attended by more than 500 farmers on alternatives to bartering•Wrote (and translated) a four-part informational radio drama which taught basic business skills to small business owners. This program was broadcast to listeners throughout Lesotho and parts of South Africa

Bachelor Of Science (Bs), Finance, General

Education record