Mumbai, Maharashtra, India
• Landscaped the Indian renewable energy sector & studied funding structure of the major companies • Recommended 4 companies which might issue masala/dollar bonds; 1 company approached by team • Analysed credit strengths of companies and Identified various structures used to raise foreign debt • Calculated the pricing levels for a recommended company's bond using comparable and secondary bonds • Studied the various factors that would lead to development of the corporate debt market in India
• Catered to Core, Legal Entity, Independent Commission on Banking and other internal and external reporting requirements of various franchises of RBS like Corporate & Institutional Banking (CIB), Personal & Business Banking (PBB) and Commercial & Private Banking (CPB) by using various tools like Hyperion Planning, Hyperion Essbase, Financial Data Quality Management (FDQM) • Took complete ownership and development of an automated feed for User Entitlement Review(UER) exercise of RBS for Hyperion platform (budgeting and forecasting tool) impacting user access of around 1000 users • Instrumental in automating FDSF (Firm Data Submission Framework) reports catering to PRA (Prudential Regulation Authority) stress reporting requirements. • Reduced output time of high-frequency data feeds by 10%
• Selected from campus for 8 weeks internship with RBS • Received Pre Placement offer (PPO) after completion of the internship • Automated the release process of the Structured Note pricing and publishing application of RBS to seamlessly introduce new features in the application and achieve full regression automation