Yash Mehta
Mumbai
Summary
Analytical professional specializing in portfolio reconciliation and financial reporting. Enhanced operational efficiency through effective problem-solving and stakeholder management. Utilized SQL and Power BI to support month-end activities and drive continuous improvements. Streamlined reconciliation workflows, ensuring accurate NAV validation and contributing to financial accuracy.
Overview
1
1
Certification
4
4
years of professional experience
Work History
Analyst
BlackRock
Mumbai
01.2023 - 10.2025
- Utilized SQL, advanced Excel, and Power BI for data extraction, analysis, and dashboard reporting of operational metrics.
- Executed daily fund servicing and portfolio reconciliation, including cash and transaction reconciliations across custodians.
- Investigated reconciliation discrepancies through detailed analysis and coordination with custodians, ensuring timely resolution and maintaining accuracy.
- Supported month-end reporting activities, validating NAV and reconciling trial balances to ensure data integrity and compliance.
- Collaborated with operations and cross-functional teams to streamline reconciliation workflows, improving efficiency.
- Communicated reconciliation results and operational exceptions effectively to stakeholders and clients.
- Documented workflows and identified process gaps, facilitating continuous improvement initiatives to enhance operational effectiveness.
- Maintained compliance with operational risk and cybersecurity guidelines while managing sensitive financial data.
Equity Research Intern
Motilal Oswal
02.2022 - 05.2022
- Developed portfolio strategy aiming for 15–18% CAGR to enhance investment returns.
- Evaluated financial statements of banking sector companies to identify performance drivers and investment opportunities.
- Monitored market trends to extract insights on consumer preferences and behaviors, informing investment strategies. to identify shifts in consumer behavior. and macroeconomic impact.
Education
MBA - Finance
ICFAI Business School
Mumbai01-2023
B.Tech - Mechanical
ITM University
Vadodara01-2018
Skills
- Fund accounting
- Portfolio reconciliation
- NAV validation
- Financial reporting
- SQL proficiency
- Power BI expertise
- Advanced Excel skills
- Investment portfolio management
- Stakeholder management
- Client communication
Certification
- NISM Series VIII – Equity Derivatives
- Financial Modelling by Forevision
- Live Project with Finlatics on equity research
- Advanced Excel by Forevision
Timeline
Analyst
BlackRock
01.2023 - 10.2025
Equity Research Intern
Motilal Oswal
02.2022 - 05.2022
MBA - Finance
ICFAI Business School
B.Tech - Mechanical
ITM University