Rehaan Merchant

NextSteps Ventures

• Helped with due diligence for a variety of land acquisitions, MFA deals, and commercial development deals focused mainly on the Texas market but spanning over the continental United States.
• Attended meetings and interacted with capital market professionals, deal sponsors, asset managers, property managers, and investors.
• Analyzed Pro Forma and financial models for multiple Commercial Real Estate Deals.
• Built dynamic Pro Forma models with native error checks using MS Excel.
• Developed robust models for Cash Flow Analysis, Commercial Real Estate Valuations, Investment Acquisition Analysis, and Asset Management using ARGUS Enterprise.

Alkami Technologies

• Developed a dynamic valuation metric dashboard using data from AWS CloudWatch.
• Created a full stack APM platform with multi-level visibility and observability using New Relic
• Integrated AI algorithms to optimize infrastructure costs
• Optimized infrastructure bottlenecks by using full stack tracing
• Redesigned Java Melody in New Relic using dynamic attribute-based filtering
• Decreased Mean-Time-To-Close with AI Anomaly alerting and Slack workflows

Way2Advanced Tutoring

• Founded an outlet to spread knowledge and promote growth, teaching over 25 students in 15+ subjects.
• Helped students to increase SAT and ACT scores by 143 points and 5 points, respectively. Average performance in school increased by an average of 10% or one letter grade.

• Created an Investor Commitment Management Portal and process for Investment Clubs and Syndication organizations.
• Organized raw data consisting of investor information, soft and hard commitment amounts, and transfer details.
• Effectively cut process time by 50% and reduced clerical errors by 95% by employing automated backend checks and validation.
• Process has been used in over 18 capital syndication deals to raise over $20 million

• Compiled Property Level Data, Inflation Assumptions, Operating Expenses, Non-Operating Expenses, Capital Expenditure, Tenant and Leasing Information, Leasing Assumptions, Acquisition Data, Debt Financing Data.
• Analyzed data to create Executive Summary Report, Cash Flow Report, Resale Matrix Report, IRR Matrix Report, Present Value Report, and Assumptions Report.

• Researched current investment tracking software options for crowdfunding and investment clubs. Proposed novel idea to bridge current market gap, cater to target audience, and analyze future growth and barriers to entry.
• Proposed a cloud-based solution that was cost-efficient, secure, fault-tolerant, and highly available.
• Main services used were DynamoDB, SNS, SQS, EC2, and triggered Lamba functions integrated with a Cognito login directory
• IAM roles allowed sponsors and admins to manage investment opportunities and link them to automated workflows.
• Created a business process model using Lucid Charts, thereby automating manual processes, improving interactions between investors, admins, and sponsors, and reducing the potential for error

• Placed among top 5 of 20 teams.
• Provided quantitative analysis on real estate trends using data such as CAP Rate, NOI, Rent Rate, and Vacancy Rate in various real estate asset classes sourced from Bloomberg Terminal, CoStar, CapitalIQ and used data visualization and analytics tools such as Tableau, Python, and Lucid Chart to present our financial analysis.
• Presentation consisted of Tableau charts to quantify our inferences, data dashboards, and a swim lane prototype of the solution.

• Networked with top Commercial Real Estate Professionals from the DFW area through various events

• Led LinkedIn and resume professional development workshop for over 50 participants. Taught tips on SEO optimizations, ATS optimization, and effective communication