May 2024 – Present · 1 yr 11 mos · Hyderabad, Telangana, India · On-site

• Part of a 7-member team handling the strategy of Special Situation Analysis, working on Arbitrage Situations and Hedging opportunities in the Mergers and Acquisitions space
• Key member of the Consumer Financial Modelling team tracking over 100 companies using intrinsic valuation to develop forecast and discounting models alongside tracking alternative micro-data for targeted firms
• Leading personnel in the insights group tracking webcasts, earnings calls, and other conference calls to build inferences based on financial outlooks, macro-level policy changes, management dynamics and other key metrics
• Significant Achievements
• o Curated merger overlap analysis, analysed DOJ, FTC request patterns across 5 years, evaluated M&A prospects across 11 GICS industries for 300+ companies.
• o Tracked over 200 S-1/F-1 applications and their amendments; analysed the US consumer prices movements across indices based on 5 years+ data from over 30 companies for macro-level strategies.
• o Maintained and constructed over 50 detailed financial models for an industry specific strategy alongside developing projections, working on peer comps and absolute valuations.
• o Designed over 3 trend analysis trackers based on collective data of 30+ States, interpreted store-level data for over 50 companies, studied over 75 metrics across 4 industry specific analysis
• o Interpreted valuable data insights from over 120 company earnings calls and webinars

May 2023 – Jun 2023 · 1 mo · Hyderabad, Telangana, India · On-site

• o Developed an excel based model with 29 customized ratios like CAR, Rollover composition, Swap coverage across 4 categories; detailed analysis of the bank failures.
• o Curated a regression, correlation, abnormal return model to find relation between U.S, Japanese, Chinese & European Indices in financial turmoil with data points of 12+ years.
• o Studied the brewing CREM crisis in west with 2 relevant macroeconomic trends, with linking the effect of the regional banks and estimate of possible defaults.
• o Designed a two-scenario based 5-year financial prediction model for 2 banks at high-risk susceptibility driven by possible liquidity strains; analysing NIM, COC, profitability.