Rik Choudhury

Primary task: Equity research in enery and banking sectors: fundamental and technical analysis, sector analysis, time-series analysis, volatility modelling like ARMA, ARCH and GARCH, stock pricing forecasting in Excel. Secondary task: Portfolio management based on risk and profit sharing ratio, gained experience in supervisory role (CRO) involving problem solving and interpretation.

Automated data collecting in SQL from client's internal & external data sources; saving 8 hrs per week for data gathering. Boosted efficiency of weekly reports by 75% using VBA automation in Excel EDA, feature engineering and feature selection in Python and generating predictions. Identified 4 core business KPIs & visualised in Tableau; improved client's revenue by 21%.

Developed a software prototype for a BancoStato in transition from semi-manual system to online relational database with user-friendly GUI in JSF;estimated revenue increase by 32%. Interface interacts with Avaloq software as a middleware to push or pull documents. Developed a star schema to build relationships between entities. Modelled a prototype on basis of use cases. Creating & analysing various entity relationships & their correlations & assess the risk involved in MySQL.

Examined risk exposure of BPCL from financial statements when engaging in OTC securities and derivatives transactions with counterparty. Calculated probability of default & loss given default based on Merton’s model to evaluate the credit worthiness of the counterparty. Developed ways to managing counterparty credit risk. Extensively used Vlookup, VBA and pivot tables in Microsoft excel for calculations.

Compiling and analysing financial reports in Microsoft excel. Recommending portfolios and evaluating financial data and identifying economic trends. Performing multiple account reconciliations (cash and generals’ ledger). Produced budgets and quarterly forecasts, prepare financial models in MATLAB. Responsible for developed monthly actual vs budgets variance.

Thesis: A Comparative Analysis Of Credit Rating Model Used In Peer to Peer Lending. Advised by Prof. Kunal Saigal & Prof. Klöckner. Compiling and analysing financial reports. Review financial statement, complete cost and revenue analysis, and accomplish other basic financial reporting, including P& L, Gross margin, and profitability. Complete in-depth small business valuations monitoring and analysed financial data trends and prepare financial models Good understanding of IAS, IFRS and HBS.

Thesis: Optimizing capacity utilization of freight transport through corporate-humanitarian collaboration-a new perspective. Advised by Prof. Paulo Goncalves. *Developed an Integrated Information Management System (IIMS) which comprises of relational repository & OLAP to analyse requests and demands. *The software prototype is build using Microsoft SQL Server (RDBMS) & Visual basic (OLAP). *Studied Lean Six Sigma methodology

Hedging of Crude Oil by the application of derivatives & Productivity Optimisation of supply chain management of Refinery. *The objective of writing the thesis is to study and analyze the various derivative instruments available on the global financial market and to present practical examples for hedging crude oil price risks in accordance with broad-based hedging strategies *This thesis uses Microsoft excel and AMPL studio for calculations.