Rik Choudhury
Bis 2019, Financial Analyst, Capital
Berlin, Deutschland
Über mich
➢ Kompetent in der Entwicklung und Implementierung von 𝗱𝗮𝘁𝗮𝗯𝗮𝘀𝗲𝘀 und 𝗱𝗮𝘁𝗮 𝗰𝗼𝗹𝗹𝗲𝗰𝘁𝗶𝗼𝗻. ➢Sehr Rechen- und PC-fähig: besonders stark in 𝗘𝘅𝗰𝗲𝗹 & 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝗮𝗹. ➢ Gutes Wissen über 𝘀𝗰𝗵𝗲𝗱𝘂𝗹𝗲𝘀, 𝘀𝗰𝗲𝗻𝗮𝗿𝗶𝗼 𝗺𝗼𝗱𝗲𝗹𝗹𝗶𝗻𝗴 und 𝘀𝘁𝗼𝗿𝘆𝘁𝗲𝗹𝗹𝗶𝗻𝗴. ➢Erfahrung in der Arbeit mit 𝗧𝗮𝗯𝗹𝗲𝗮𝘂, 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 und anderen Reporting-Tools. ➢Fähigkeit, eine starke Zusammenarbeit mit allen relevanten Parteien zu entwickeln, und hat einen stark fokussierten Ansatz. ➢Proficient in developing and implementing 𝗱𝗮𝘁𝗮𝗯𝗮𝘀𝗲𝘀 and 𝗱𝗮𝘁𝗮 𝗰𝗼𝗹𝗹𝗲𝗰𝘁𝗶𝗼𝗻 systems. ➢Highly numerate and PC literate: particularly strong at 𝗘𝘅𝗰𝗲𝗹 & 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝗮𝗹 skills. ➢Good working knowledge of 𝘀𝗰𝗵𝗲𝗱𝘂𝗹𝗲𝘀, 𝘀𝗰𝗲𝗻𝗮𝗿𝗶𝗼 𝗺𝗼𝗱𝗲𝗹𝗹𝗶𝗻𝗴 and 𝘀𝘁𝗼𝗿𝘆𝘁𝗲𝗹𝗹𝗶𝗻𝗴. ➢Experience working with 𝗧𝗮𝗯𝗹𝗲𝗮𝘂, 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 aand other reporting tools. ➢Ability to develop strong working 𝗿𝗲𝗹𝗮𝘁𝗶𝗼𝗻𝘀𝗵𝗶𝗽𝘀 with all relevant parties and has a strong 𝘁𝗲𝗮𝗺 focused approach.
Werdegang
Berufserfahrung von Rik Choudhury
2 Jahre und 5 Monate, Sep. 2016 - Jan. 2019
Financial Analyst
Capital
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.
1 Jahr und 3 Monate, Feb. 2015 - Apr. 2016
Data Analyst
Infotech Ltd
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%.
1 Jahr und 2 Monate, Mai 2012 - Juni 2013
Business Analyst
Avaloq (B-Source SA)
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.
4 Monate, Mai 2011 - Aug. 2011
Risk Analyst
Bharat Petroleum Corporation of India
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.
3 Monate, März 2011 - Mai 2011
Finance Analyst
Indian Oil Corporation of India
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.
Ausbildung von Rik Choudhury
2 Jahre und 2 Monate, Apr. 2019 - Mai 2021
Finance,Accounting & Data Analysis
IU International University
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.
2 Jahre und 5 Monate, Sep. 2011 - Jan. 2014
Informatics,Management
Università della Svizzera Italiana
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
1 Jahr und 3 Monate, Apr. 2010 - Juni 2011
Finance, Risk Management & Financial Engg.
Jadavpur University
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.
Sprachen
Englisch
Fließend
Deutsch
Grundlagen
Italienisch
Grundlagen
Hindi
Muttersprache
Bengali
Muttersprache