Prabhat Dalmia Email & Phone Number

San Francisco, CA, US

Archer is a commercial real estate startup providing software product solutions for real estate operators to do automated underwriting, market selection & deal sourcing. I lead all of technology development at Archer.

Sunnyvale, CA, US

• HealthTap is a virtual healthcare provider that provides 24/7 access to primary healthcare doctors, as well as serve millions of doctor curated Q&A on its website. I lead all the analytic development efforts for.
• Driving Data Democratization: Drove down cycle time for data requests from 2 weeks to less than a minute by delivering multiple self-serve dashboards, thus driving faster strategic & tactical decision making.
• Return on Investment (ROI) Model: Led the development of a comprehensive ROI model / case study that showed 388% savings on healthcare costs to the customers. The model links customer activity on HealthTap to the.
• Medical Operations Savings: Slashed doctor staffing costs by about 25% by identifying inefficiencies & issues in operations, and coming up with a plan to address those.
• Growth Marketing Attribution: Worked with Engineering & Product Mgmt to define Events, Pixels & A/B tests that can be used to do attribution as well as improve customer acquisition & funnel conversion (Google.
• Data Modeling: Driving data modeling requirements for the Engineering that makes sure that there is no data loss and any historical data can be reliably & accurately reproduced at any point in time.

San Jose, California, US

• Manage the devices and customer analytics business that helped answer various strategic & tactical questions for the company. I also led the development of various dashboards that helped monitor various KPI’s important.
• Customer Churn: Led the development of a model to determine customers who are likely to churn out, thus identifying a target to go after, and reduce churn. The model helped drive segmentation and sizing for various.
• Customer Lifetime Value: Led the development of a model to determine the lifetime value of customers and devices that helped business make informed decisions wrt customer acquisition costs vs lifetime value. This model.
• Financial Valuation: Conducted several financial valuation exercises using the churn and lifetime value work to value various partner deals, and determine if they would be profitable to Roku over the long run.
• Fraud Prevention: Studied web traffic and device activations data to identify sources of fraudulent behavior, implemented measures to counteract fraud, thus bringing down fraud and increasing customer satisfaction.
• KPI’s Dashboard: Led the development of a comprehensive set of Tableau dashboard that brought together a set of KPI’s important to business. This brought multiple sources of data into one view, and eased analysis of.

San Francisco, CA, US

• I led various data analytic projects for multiple departments that helped them analyze data with a new perspective, and improve their decision making & operations. I also led several data architecture & process.
• Cash Flow Management: Developed a model for the Treasury Department to forecast new money needed to fund new loans; Model used to manage cash flows as well as manage balance sheet growth (SQL, R, Tableau)
• Loan To Value (LTV) Analysis: Put together an analysis of the historical LTV through time of the FRB originated loans that helped communicate to Investors, the safety of the FRB originated loans even through Financial.
• Customer Households: Developed an graph based algorithm to aggregate related bank customers into logical households, and designate a head of the household; Used to get a holistic view of bank customers so that any.
• Recommendation Engine: Developed a recommendation engine to analyze all FRB customers and find potential relationships between them, that will be used to improve bank's household network, as well as help bank’s.
• Transaction Mining: Analyzed millions of ACH, Wire & Check transactions of various customers to figure out their counterparties, separate them into FRB vs. Non-FRB counterparties, and validate any claims of cross-sell

• At this family office, I worked as a sole analyst for my Portfolio Manager to develop an entire quantitative hedge fund from ground up, and also researched and traded an option selling strategy.
• Developed Long/Short Market Neutral Fundamental Quant US equity
• Researched and traded weekly Option Vol strategies
• Developed Multifactor Risk & Alpha model

• Cambria Investments is an Investment Management firm with several ETFs currently trading in the market. I worked as a sole analyst at the firm and researched a number of systematic quantitative investment strategies.
• Global Equity Model: Developed a systematic global equity strategy using cyclically adjusted P/E ratios (CAPE) for 40 different countries that produces more than 10% annualized outperformance with similar volatility.
• Global Bond Model: Developed a systematic global sovereign bond rotation model using more than 40 countries that produces more than 5% annualized outperformance compared to the equal weighted index; backtested back to.
• Multi-Asset Model: Developed model (in Excel/VBA) to backtest various asset allocation strategies using technical & fundamental factors; currently being used to manage asset allocation for GAA & GMOM ETF
• Value, Momentum & Timing Models: Developed several long/flat models using value, momentum & timing in several asset classes like REITs, Small Caps, MLPs etc that produce superior returns with reduced volatility and.
• Sector Rotation Model: Developed sector/industry rotation model using 39 fidelity funds that produces 6% annualized outperformance compared to S&P 500 for same target volatility and 1/3rd the drawdown; backtested back.

Los Angeles, CA, US

Los Angeles Capital Management is an Asset Management firm with AUM in excess of $20B. I worked as an intern for 3 months, and conducted research on News Sentiment (NLP) data as a new factor in a 30-factor model using MATLAB

Austin, Texas, US

- Developed several modules of Oracle BAM that is used to create real time dashboards to monitor business activity events. Ability to handle high frequency event data. - Developed several modules of the Oracle RFID product

Waltham, MA, US

- Managed end-to-end software projects at Fortune 500 clients like Shell, Gillette, Coca Cola, Target and Staples, helping clients get a better visibility into their supply chain- Developed several web based projects for various clients (Bose, Accion etc)

Mba, Finance, Strategy

Bachelor Of Technology (B.Tech.), Engineering