NIRAV MAKWANA
Surendranager, Gujarat
+91 6354209220 # [email protected] ï niravmakwana14 § github.com/Nirav140204
Education
Saurashtra University May. 2021 – May 2024
Bachelor of Commerce Rajkot, Gujarat
Relevant Coursework
• Financial Modeling • Risk management • Artificial Intelligence • Management consulting
• valuation • merger acqusition • Investment Strategic • data analytics
Experience
CITIBANK May 2020 – August 2020
INVESTMENT BANKING ANALYST Mumbai, india
• Built a 5-year financial model for BestBuy,improving forecasting accuracy by 15.
• Conducted comparative financial analysis for Best Buy 3 competitors, enhancing strategic positioning by 20 .
• Identified key competitive advantages, securing 2 new client partnerships.
• Developed a company profile investor pitch deck, increasing stakeholder engagement by 70 .
TATA GROUP May 2019 – August 2019
DATA ANALYST INTERNSHIP Mumbai, india
• Designed a customer segmentation model, increasing retention rates by 10.
• Built a predictive financial model for demand forecasting, optimizing inventory costs.
• Analyzed churn data, implementing strategies that improved client lifetime value.
FIDELITY INTERNATIONAL May 2019 – August 2019
INVESTMENT MANAGEMENT Mumbai, india
• Conducted performance analysis for the Europe Focus Fund, enhancing returns by 15.
• Built portfolio optimization models, improving the Sharpe Ratio risk-adjusted returns.
• Executed SWOT analysis on Tesla, influencing investor sentiment positively by 20.
Projects
MERGERS AND ACQUISITION VALUATION | Python, Selenium, Google Cloud Console January 2021
• Accomplished MA valuation analysis, increasing deal pricing accuracy by 20 using DCF and comparable models .
• Developed integrated valuation frameworks, improving precision by 15 through scenario analysis .
• Streamlined data aggregation, reducing turnaround time by 25 with automation..
• Integrated market benchmarks, enhancing comparability and reliability by 12.
• Delivered recommendations, optimizing transaction pricing and increasing shareholder valueby 10 .
CREDIT RISK ASSESSMENT FOR RETAIL BANKS | Java, Android Studio November 2020
• Accomplished a comprehensive credit risk evaluation, increasing risk identification accuracy by 20 using statistical
analysis .
• Developed predictive models, improving default forecasting by 15 through machine learning techniques.
• Streamlined risk assessment processes, reducing evaluation time by 25 with automation.
INVESTMENT RISK MANAGEMENT | Java, Eclipse, JavaFX October 2020
• Calculated monthly returns, standard deviation, and beta to assess portfolio risk exposure.
• Implemented the Treynor Ratio and Value at Risk (VaR) to measure risk-adjusted returns and potential portfolio losses.
• Visualized risk metrics using data-driven graphs and statistical analysis for better investment decision-making.
Technical Skills
Financial Tools: Excel (Advanced), PowerPoint, Bloomberg Terminal, Capital IQ, FactSet
Data Analysis: Python (pandas, NumPy, matplotlib), R, SQL, Excel VBA
Valuation Modeling: DCF, LBO, Merger Models, Comparable Company Analysis, Sensitivity Analysis
Databases Platforms: PitchBook, Preqin, Refinitiv, Morningstar Direct
Reporting Automation: Power BI, Tableau, Excel Macros, Google Sheets Automation
Leadership / Extracurricular
Saurashtr University Spring 2020 – Present
President University Name
• Founded a university finance club with 100+ members; organized workshops on valuation, MA, and financial modeling.
• Initiated a FinTech newsletter for 500+ readers, summarizing trends in PE, VC, and markets with actionable insights.
• Headed deal sourcing team in college VC club; analyzed 20+ startup decks and presented 5 investment memos to mock
IC panel.