May 2021 – May 2023 · 2 yrs

Sep 2019 – Dec 2020 · 1 yr 3 mos · Chennai, Tamil Nadu, India

Apr 2018 – Aug 2019 · 1 yr 4 mos · Hyderabad Area, India

• Financial Modelling:
• Tools Used- Excel, VBA, SQL Server
• 1. Develop underwriting model to arrive at the bidding price for the non-performing loan portfolios using the inputs from seller bank/advisor. Also preparing major strats/key return metrics at different levels and performing sensitivity analysis by varying the assumptions applied on liquidation value and time to liquidate.
• 2. Develop cash flow (Waterfall) model for securitizing a loan portfolio with expected net collections worth 300 MM based on the term sheets from different Investment banks including various triggers and cash sweep events and analyzing the key return metrics.
• Dashboard/Reports for Data Analysis:
• Tools Used- Tableau Desktop, SQL Server, Python (Pandas & Matplotlib)
• 1. Created a dashboard in Tableau to track the key performance metrics/trends of the our non performing loan portfolios.
• 2. Created stories in Tableau to provide insights to the Asset Managers prior to their MoM meetings with various servicers.
• 3. Created multiple ad hoc reports like one pagers, Exposure reports, performance reports for various consumers including EC/RC, Investors, Senior Management etc.
• Macro Analysis/ Surveillance:
• Data Sources Used- Bloomberg, Annual Reports
• 1. Tracking the performance of major banks in Spain and Italy especially in respect to their non-performing/ loan exposure.
• 2. Maintaining a pipeline of non-performing portfolio transactions (both primary and secondary) in the Euro region.
• Data Management and Automation:
• Tools Used- SQL Server, VBA, Python
• 1. Created multiple complex queries/views/stored procedures in SQL Server to import, export and manipulate data.
• 2. Automated multiple repetitive tasks using VBA, Python for the internal team and other teams as well.
• 3. Stream lined the process of data on-boarding and preparing Data Tapes for the sale processes by liaising with different stakeholders (Loan portfolio servicers, Asset Managers, Potential bidders)

Jun 2016 – May 2018 · 1 yr 11 mos · Hyderabad, Telangana, India

• 1. Recognized for top performance through fast-track promotion and internal movement from Fin Operations team to Fin Research team (ABS).
• 2. Ensured correct modeling of various financial products such as Asset Backed Securities, Credit derivatives, Repos, IR derivatives, Commodity futures & forwards, Options, loans (Term/Revolver) etc. and managing the complete life cycle of those products.
• 3.In-depth understanding of portfolio accounting and P&L generation. Experience in debugging complicated P&L queries with the help of accounting tool Geneva, a third party tool.
• 4.Experience in identifying and eliminating redundant processes,
• eliminating bottle necks and automating manual processes using my VBA & SQL Server skills. Created many macros which has led to an increase in the efficiency of the team.
• 5.Effective communication skills in terms of broker communication, documentation, preparation of project plans.
• 6. Involved in implementing the new set of directives given by EU regulators, MiFiD 2 specific to commodity derivative products.
• 7. Created a dashboard using my technical skills for the Senior Management to understand the potential risk areas & the overall progress of the team on a monthly basis

May 2015 – Jul 2015 · 2 mos · Mumbai Area, India

• Involved in tracking and analyzing the market profile charts of nifty futures there by generating recommendations for both intraday and long term trading.
• Maintained a daily record containing various parameters of market profile charts- nifty futures for long term trading.

Aug 2013 – Jun 2014 · 10 mos · Chennai Area, India

• 1. Involved in Defect Management in ALM tool & High end testing
• 2. Created a macro to automate the attendence tracking process of my team using Excel-VBA(Visual Basic Applicaitons)