Lloyd Foss Email and Phone Number

Sr Risk Manager Morgan Stanley (Institutional equity division)

Risk Management

OTC Derivatives ValuationValuation of Daily PnL for International Hedge fund Clients. Pricing of various derivative trades Like CDS, IRS, Equity Option, Equity Swap, Equity Variance Swap , Swaption , Cross Currency swap , Inflation Swap & FX OTC Option etc. Analyzing the Trade breaks between the GlobeOp valuation , Counter party valuation Justifying the valuation difference. Provide support to various client on their valuation query. Using third party vendor application like Bloomberg & Reuters to validate or cross check valuation.

Understanding Credit Appraisal policy of IDBI Bank for Macro Small and Medium Enterprise and Automating the Small loan sanction process using Excel VBA programming

• Experience in all aspects of data management methods and practices including data modeling, design of data schemas, data migration/transformation.• Define and manage multiple Database environments during development • Automation of database release process• Maintaining releases/Hot fixes using SVN• Writing SQL scripts for various database-monitoring activities.• Performance & Tuning at SQL, PL/SQL level (Oracle + SQL Server)• Enhance, optimize, and implement the physical Database design• Automate tasks using PL/SQL, T-SQL scripts, Query Analyzer, DTS, and Multi Server Administration.• Analyzing customer’s migration and software upgrade logs and provide Fixes.• Involved in writing database function, procedures, triggers etc. (Oracle +SQL server).• Monitoring of database objects (tablespaces, tables, indexes etc.) for fragmentation, space usage Capacity management, reporting and troubleshooting.• Provide on-going education in Database design and efficient SQL coding techniques to all other competency associates.• Technical procedures.• Software upgrades