Financial Business Analyst - MCube Financial, LLC
(2024-01 - 2025-04)
- Worked on the CMBS process analyzing USA-based multifamily real estate properties for investment banking clients by reviewing rent rolls, income statements, amortization schedules, and financial documents to assess property performance, cash flow, and investment risk.
- Developed dashboards to monitor KPIs including occupancy %, vacancy %, total rental income, average market rent, actual rent, unit mix (1BHK/2BHK/3BHK/4BHK), and property performance trends for USA based Commercial real Estate property, supported CMBS.
- Built analytical reports using Excel and Power BI to support operational and financial decision-making.
- Performed NOI calculations, income-expense analysis, and financial forecasting for U.S. multifamily portfolios.
- Analyzed appraisal reports, operating statements, and valuation documents to identify risks and business opportunities.
- Performed variance analysis on rent roll and NOI; coordinated with clients to resolve discrepancies and obtain updated appraisal reports.
- Performed NOI, LTV, CAP Rate, Interest Coverage Ratio, EMI and other debt metric calculations.
- Evaluated LIHTC tax credits, borrower metrics and CMBS portfolios.
- Performed primary and secondary research and generated business insights.
- Collaborated with cross-functional teams to improve reporting efficiency and reduce turnaround time.
- Delivered actionable business insights supporting strategic decisions.
Marketing Analyst - Aleph INDIA
(2021-11 - 2022-02)
- Researched and analyzed manufacturers data from the BIS platform to identify organizations requiring ISI/ISO certifications and mandatory registrations.
- Conducted requirement analysis with clients, explained certification procedures, and prepared quotations, Word/PPT documentation, and process guides for 10+ certification schemes.
- Acted as a liaison between marketing and operations teams, ensuring client needs were accurately translated into operational actions (registration, testing, or lab setup).
- Guided operations teams in classifying products under appropriate certification schemes, ensuring accurate compliance handling.
- Took follow-ups with existing clients for certification renewals, contributing to client retention and repeat business.
- Monitored regulatory updates on the MEITY's website, ensuring business operations remained compliant with government requirements.
- Coordinated certification workflows across departments, ensuring on-time registration and testing.
Marketing & Operations Manager - Krishnakala Housing Pvt. Ltd
(2019-06 - 2021-05)
- Conducted market research (competitor analysis, customer demand trends, pricing studies) to guide business strategies.
- Managed and mentored a team of 5–8 professionals, improving workflow efficiency and client servicing.
- Collected and analyzed field-level housing data to generate insights for project positioning and execution.
- Streamlined project execution processes, improving turnaround and client satisfaction.
Summer Internship (Wealthpreneur) - Bajaj Capital Ltd.
(2023-05 - 2023-11)
- Conducted in-depth research and comparative analysis of multiple financial products and investment schemes offered by institutions including HDFC Bank and Axis Bank, evaluating performance trends and investment suitability.
- Performed mutual fund and investment analysis using key financial metrics such as Alpha, Beta, Total Return, Risk-Adjusted Returns, and other performance indicators to support investment recommendations and client advisory processes.
- Analyzed customer requirements, behavioral patterns, and investment preferences to align suitable financial products with client objectives, improving recommendation accuracy.
- Conducted risk assessment, forecasting, and trend analysis to evaluate investment performance and support data-driven decision-making.
- Designed and executed customer insight surveys, generating actionable insights related to user preferences, product adoption, and service satisfaction levels.
- Utilized Excel (Advanced Excel, Pivot Tables, VLOOKUP/XLOOKUP, Dashboards, Charts, Data Validation, Financial Modeling) and Power BI to create visual reports, dashboards, and performance tracking models for investment and ratio analysis.
- Developed charts and analytical dashboards to monitor financial KPIs, compare fund performance, and present insights effectively to stakeholders and management.
- Conducted forecasting and variance analysis to identify investment trends, performance gaps, and potential risks associated with financial products.
- Onboarded clients onto Bajaj Capital's digital investment platform, driving adoption of financial products and improving customer engagement.
- Collaborated with managers to analyze recommended investment schemes and provide insights supporting client-focused investment strategies.
- Applied structured need analysis techniques to gather, evaluate, and interpret customer requirements for improved operational and investment decision-making.
- Generated operational and financial insights from survey and investment data to enhance workflow efficiency and service alignment.
Associate Teacher - GLBIMR
- Mentored junior students in basic accounting, ratio analysis, corporate finance, financial analysis, and credit & banking concepts, while providing guidance on academic projects and analytical problem-solving.
- Assisted in developing foundational understanding of financial statements and business analysis techniques.
Summer Intern - Public Work Department, Lucknow
(2011-07 - 2011-08)
