Somil Gupta Email & Phone Number

Gurugram, Hr, In

Gurugram, Haryana, India

Leveraged Lending Credit Services

Gurugram, Haryana, India

Wholesale Lending | Commercial CreditWorked as Lead Assistant Manager in Commercial lending team.• Credit rating for public and private companies through financial modelling using Moody’s Risk Analyst ,and FIS Optimist tool for NAM, EMEA,APAC and AFRICA.• Preparing annual reviews which include various subheads: Vendor & Borrower Description, Capital Structure Report, Financial Statement and Ratio Analysis

Gurgaon, India

Analyzing & Spreading of Financial statements through Moody’s Risk Analyst, preparing capital structure & financial commentary on Income statement, balance sheet & cash flow. Credit rating for public and private companies through financial modeling – Moody’s for EMEA & APAC. Preparing Annual reviews which include various subheads: Vendor & Borrower Description, Capital Structure Report, Financial Statement and Ratio Analysis Monitoring and managing credit quality for existing customers. Evaluate credit capacity of prospective and existing customers by compiling financial information and interpreting financial trends

Gurgaon, India

Analyse the performance of a company through earning(financials releases like income statements, balance sheet, cash flow statement through company websites, SEC filings like 10Q,10k & 8K.Actively participating in resolving the client quires which had been forwarded to us and also do the root cause analysis for the errors and make necessary action to avoid the error further. Take responsibility for financial data quality, accuracy, timeliness and completeness with in the team.

Bengaluru Area, India

Analyse, reconcile, and calculate various ratios and real-time financial Key Performance Indicators (KPI) from Income Statement, Balance Sheet and Cash flow statement of companies in various segments which are listed on New York Stock Exchange, NASDAQ and Canada Stock Exchange.Monitoring and analyzing the estimates of various Investment Brokers and Process KPIs to apply in an accurate manner in the database using technical and financial knowledge to add valueConduct variance analysis to know the reason for variance between the actual/reported results and estimated data of different analysts and notify the clients about the same.Analyze IFRS & US GAAP based financial statements (e.g. 10-K, 10-Q, etc.).Provide financial news to Reuternews.com.Resolve requests and client queries within the given time frame and provide accurate financial data to the clientAct as a secondary source of knowledge on internal information, communicating with other departments and external departments in the resolution of queries on exchange data and historical data.Assist in the training of new joinersPoint of contact on all issues relating to real time and contributed data in Thomson one Analytics.Co-ordinate process tasks across different countries.Working as key player in the team to resolve the client queries & sharing the best practices of knowledge with team.Providing the close to 231 financial KPI data measures of all sectors to a client by analyzing detail financial statement.Active player in the KPI & Automation Project.Knowledge about the basic valuation concepts like DCF, EV/EBITDA, and P/E.

Bengaluru Area, India

Analyze the performance of a company through earning(financials releases like income statements, balance sheet, cash flow statement through company websites, SEC filings like 10Q,10k, 8K etc and providing the performance parameters such as EPS, FFO, Revenue, Operating profit, EBITDA, pretax profit and other operating metrics comparable to the market expectation(street consensus or estimates).To provide comparable actual financial results versus the estimates (street consensus) to the Reuters editorial news team for the hot listed and priority companies.Gathering data from primary and secondary sources analyzing data for insightProviding accurate data to the clients in the form of values, footnotes, guidance, and ratios and in the form of excel files.Updating the Actual of Dual listed companies which are traded in the NYSE and Toronto Stock Exchange as well as ADR Companies which are traded in NYSE and NASDAQ.Handling requests and responses from internal and external clients.Worked in US and Canada Market.Efficiently monitored effects of market news on the Earnings Estimates projections and ensured that a true picture of the same is reflected in the Thomson Reuters Consensus.Actively participating in resolving the client quires which had been forwarded to us and also do the root cause analysis for the errors and make necessary action to avoid the error further.

Pgpm, Finance, A+

Studied with finance specialization which covered the Risk management approaches, Capital Budgeting techniques, Corporate valuation.

Diploma, Diploma In Foreign Language ( French), A+

Bachelor Of Commerce, Commerce, A

Certificate In Financial Accounting, Financial Accounting, A+

Hsc, Commerce, A+