Rajani Dubey

Results-driven Business Analyst with experience in dashboard development, KPI reporting, financial analysis, MIS reporting, and business process optimization. Skilled in Power BI, Advanced Excel, data visualization, and transforming complex datasets into actionable business insights. Experienced in analyzing operational and financial performance for U.S.-based multifamily real estate portfolios (CMBS) and supporting strategic decision-making through data-driven reporting.

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)

PGDM - Business Analytics and Finance - G.L. Bajaj Institute of Management & Research (2022 - 2024)

B-tech - Electrical & Electronics Engineering - Krishna Institute of Engineering & Technology (KIET) (2013 - 2016)