Harshit

HARSHIT KHOKHAWAT - •- SUMMARY I am a Senior Business Analyst with a relentless passion for transforming raw data into strategic goldmines. In the dynamic realm where business meets analytics, I am the alchemist who crafts insightful narratives from the intricate tapestry of information. WORK EXPERIENCE Oxane Partners (Senior Business Analyst) June 2023 - Present Spearheaded proactive portfolio monitoring and performance analytics for structured finance and secured lending instruments, including repo, reverse repo, collateral swaps, and OTC derivatives. Built and validated Borrowing Base and covenant models aligned with credit agreements to ensure accurate exposure tracking and risk compliance. Designed and implemented Python-based financial models for stress testing funding and liquidity needs, incorporating scenario and sensitivity analysis across asset classes. Automated reporting processes for asset-backed portfolios using SQL, Python, Excel VBA, and Alteryx, reducing manual effort and improving data accuracy. Developed Power BI dashboards (with DAX) to monitor bond liquidity, maturity profiles, haircut sensitivities, and funding concentration risks. Streamlined extraction and transformation of structured credit market data to support realtime analytics for margin calls, limit breaches, and covenant tracking. Collaborated with cross-functional teams (Product, Tech, Risk, and UI/UX) to deliver scalable reporting tools and support investment committee reviews. Supported ad hoc restructuring and ‘work-out’ analyses by organizing complex datasets, validating servicer-provided information, and identifying key risk metrics. Infosys Limited (Systems Engineer) Dec 2019 - Jul 2021 Worked on SAP ABAP and SAP MDG technology Managed client’s business partner, vendors, and financial master data using SAP MDG Daily monitored the flow of data from the client’s network to the SAP system Advest Capital(Intern) May 2022-Jun 2022 Calculated the inflow and outflow of mutual fund schemes which are AMFI registered using Python and SQL Researched on various operational performance indicators of the companies and industries and created reports. Also, made future predictions on IEX traded volume using time series algorithms. Formulated a method for monthly cement production using the index values given on office of economic affairs SKILLS Technical Skills - Power BI, SQL, Python, Alteryx Management Skills - Jira, Kanban Board, ppt Financial Skills - DCF model, Structured Finance