Summary





Over 6 years of strong experience in business analysis role covering financial and product control. Excellent excel skills with knowledge of macros, pivot table and vlookup functions. Sound technical skills with experience in MS-Access, excel-VBA, Visio, SAP BW and SQL Completed MBA in Finance and CFA Level 1 and acquired sound knowledge in bonds, Muni, futures, FRAs, options, FX, swaps and P and L concepts like NPV, MTM, funding and cost of carry


Employment

April, 2008 -  April, 2009
Business Analyst

Developed and documented business rules and requirements together with business users and partnered with different groups to provide value-added strategic guidance for business solutions
Assisted in development of UAT user acceptance testing, scenarios, scripts and system testing
Managed a variety of technical tools to query, extract and manipulate data from various relational data sources Oracle, SQL, Access, Excel, programming and development, validation and edit checks

Managed and drove projects for data migration to improve methods and systems and facilitating methods and system improvement in other functions
Maintained business application programs from user instructions or formal functional specifications

Provided timely feedback on any risk related issues and updated project managers on the status of project completion
Utilized analysis tools like business objects and Excel Macros, charts, Pivot tables for building MIS reports and developing presentations MS Powerpoint

June, 2005 -  June, 2008
Analyst

Booked FX and Interest rate derivatives like Munis, Swaps and Options in the front office system
Defined business/system requirements by facilitating user meetings and interviewing users, developing use cases and researching and resolving issues
Worked extensively on project for preparation of trade confirmations as per ISDA terms and exchange related post-trade processing
Worked with the IT team on a systems conversion project aimed at system upgrade, automation and implementation which shortened the P and L generating time

Assembled and emailed updates to developers and end users. Documented the final user training guide
Interpreted internal and external auditor s requirements and translated them into application by creating flow charts of the transaction life cycle of different products front to end procedures using MS-Visio. Covered all the key operational controls and documented the testing
Created forward analysis tool that uses live prices of bonds to build the implied forward term structure curve, implied carry and reconciled with Bloomberg

January, 2004 -  January, 2005
Business Analyst

Structured a new project at Moody s by creating a recovery model database on defaulted companies
Participated in business analysis, project planning and management by documenting and maintaining plans, managing issue logs and preparing project documentation
Analyzed existing processes and recommended solutions to improve the process
Created and managed financial models to classify and analyze various classes of bond defaults according to seniority and security and assessed the value of these securities

Education

Skills

MS-Access, Excel-VBA, Visio, Bloomberg, Business Objects, Oracle, SAP BW and SQL



Miscellaneous

Monitored debt principal, interest payments, cash flow and debt/equity ratio to determine company s credit rating. Established a correlation between the ratings of a company and its probability of default
Bachelors of Commerce in Accounting 04/2001
University of Bombay, Bombay, India
Sydenham College of Commerce and Economics