Sahil Bansal

About Sahil Bansal

I am a Chartered Accountant (ICAI, May 2022) with hands-on experience across infrastructure credit appraisal, direct tax advisory, and finance automation – targeting mid-to-senior roles in PE, IB, M&A, credit, or FP & A. At HDFC Bank\'s Infrastructure Finance Group, I worked on credit appraisal for roads and urban infrastructure sector lending – conducting financial statement analysis, ratio analysis, and sensitivity modelling, reviewing borrower credit profiles, covenant structures, and security packages, and contributing to credit notes and credit committee presentations. At Infosys (Direct Tax practice), I built a Python-based ITR JSON automation tool adopted by the entire Direct Tax team – eliminating ~17 hours of manual work per filing batch. I also developed 5 custom VBA macro tools for tax computation and validation, and handle complex Direct Tax advisory covering ITR, TDS, advance tax, and withholding obligations. I have also completed CA Monk\'s AI for Finance Level 2 – covering Python scripting, n8n workflow automation, and Tally API integration. I hold a Master Diploma in Investment Banking & Financial Analysis (Boston Institute of Analytics, 2026) – covering DCF, LBO, M&A modelling, accretion/dilution, and financial analytics with Python. I actively manage an equity and derivatives portfolio, combining fundamental analysis (DCF, peer comps) with technical chart reading. What I bring to a finance role: Infrastructure credit appraisal – financial modelling, covenant review, credit committee work (HDFC Bank IFG) IB / valuation – DCF, LBO, M&A, accretion/dilution modelling (BIA Diploma + self-directed equity research) Finance automation – Python and VBA tools built and deployed at team scale (Infosys) Tax & regulatory depth – Direct Tax, Ind AS 109, ECL provisioning, SARFAESI, IBC Markets fluency – equity + derivatives portfolio on Zerodha; technical + fundamental analysis Open to: PE / IB / M&A / Credit / FP & A / Finance Analytics | Delhi-NCR · Mumbai · Bengaluru · Pune · Hyderabad

Experience

1. Associate Consultant

   Infosys

   Feb 2025 — Present · Bengaluru, IN

   Built a Python-based ITR JSON automation tool replicating the full ITR Excel Utility click-cycle (Calculate Tax → Generate JSON → auto-save with naming convention) — adopted by the entire Direct Tax team, eliminating ~17 hours of manual effort per filing batch.Developed 5 custom VBA macro tools for Direct Tax computation and validation workflows, including Excel-to-Word compliance document automation and date-wise stock data alignment — reducing quarterly reporting time by several hours.Advanced Excel: debugged and resolved complex surcharge formula errors using LET() and LAMBDA() functions in live client tax computation sheets.Direct Tax advisory: ITR preparation and filing, TDS compliance, advance tax computation, and withholding obligation review for corporate clients.

Education

• Institute of Chartered Accountants of India

  Chartered Accountant

• Indira Gandhi National Open University

  BCOM-A&F, Accounting and Finance

• Boston Institute of Analytics

  Master Diploma, Investment Banking & Financial Analysis