Siddhant Bajgoti

 Managed core banking operations, including client onboarding, transaction processing, and account servicing across 100+ accounts.  Prepared Excel-based MIS reports using PivotTables and VLOOKUP to support daily operations, variance tracking, and branch reporting.  Ensured full KYC/AML compliance across the client portfolio and supported 2 internal audits with zero escalations.  Handled 50+ monthly client queries and performed transaction reconciliation, maintaining accuracy in financial records.  Used Flex-cube and CRM systems for maintaining financial records, generating reports, and tracking client activity.

Performed comparative financial analysis of 5 finance-sector companies using profitability, liquidity, solvency, and valuation ratios, including ROE, ROA, Current Ratio, Debt-to-Equity, and P/E. Built a mock investment portfolio in Excel and tracked simulated performance against the Nifty 50 benchmark to evaluate investment decisions. Prepared financial summaries and ratio-based investment briefs with buy, hold, or sell recommendations.

Conducted working capital analysis and benchmarked performance against 5 FMCG peers — HUL, ITC, Britannia, Dabur, and Tata Consumer — to identify efficiency gaps in receivables and inventory management. Analysed key financial metrics, including inventory turnover, receivables days, and finance costs across 5 years of historical data to track operational trends. Reviewed annual reports and investor disclosures to derive insights on profitability, margin compression, and cash conversion cycles. Built Excel dashboards and reports to present working capital findings; outputs were used in the team's quarterly review process.