Harshit

I am a results-driven Senior Business Analyst with a strong foundation in structured finance, financial modeling, data analytics, and automation. I specialize in delivering end-to-end solutions that enhance portfolio performance monitoring, improve reporting workflows, and support strategic decision-making across structured credit and secured lending domains.

I spearheaded proactive portfolio monitoring and performance analytics for complex financial instruments including repo, reverse repo, collateral swaps, and OTC derivatives. I have built and validated Borrowing Base and covenant models aligned with credit agreements to ensure accurate exposure tracking and regulatory compliance. My expertise in Python enabled the creation of robust financial models to stress test funding and liquidity requirements through detailed scenario and sensitivity analyses.

I have also streamlined reporting for asset-backed portfolios by automating data pipelines using SQL, Python, Excel VBA, and Alteryx—significantly reducing manual workload and enhancing data reliability. My work in developing dynamic Power BI dashboards (leveraging DAX) has provided stakeholders with real-time insights into bond liquidity, maturity profiles, haircut sensitivities, and funding concentration risks.

One of my key achievements includes optimizing the extraction and transformation of structured credit market data to support real-time analytics for margin calls, limit breaches, and covenant monitoring. Collaborating closely with cross-functional teams—Product, Technology, Risk, and UI/UX—I have delivered scalable, intuitive reporting tools tailored for investment committee reviews and internal audit needs. I have also contributed to ad hoc restructuring and ‘work-out’ analyses by organizing complex datasets, validating servicer data, and identifying key risk metrics.

I worked as a Systems Engineer at Infosys where I handled SAP ABAP and SAP MDG technologies, managed business partner and financial master data, and ensured seamless data flow between client systems and SAP environments.

As an intern at Advest Capital, I used Python and SQL to analyze mutual fund flows and forecast power market volumes (IEX) using time-series models. I also conducted research on industrial performance indicators and formulated methods for tracking cement production using government index data.

I bring a well-rounded skill set with technical expertise in Power BI, SQL, Python, and Alteryx, and practical knowledge of financial concepts like DCF modeling and structured finance. My approach blends analytical precision with business acumen to solve complex financial challenges and deliver data-driven insights.