Prabhat Dalmia

Prabhat Dalmia Email and Phone Number

Managing Director, Data & Technology at Archer @ Archer
Prabhat Dalmia's Location
San Francisco Bay Area, United States, United States
Prabhat Dalmia's Contact Details
About Prabhat Dalmia

• Hands-on professional with 20+ years of diverse set of experiences in Data Science and Analytics, Predictive Modelling, Machine Learning, Data Architecture, Professional Services / Consulting & Software Development• Strong understanding of Business as well as Technology with the ability to transform an unstructured business problem to actionable recommendations to drive broader organization level goals• Strengths include Problem Solving, Communication, Prioritization, Team Building, Hiring • Experience working with multiple cross-functional departments including Finance, Product, Marketing, Operations, Sales, Investor Relations, Customer Support• Tools: SQL, Tableau, R, Python, Google Analytics, Amplitude, Big Data, Hadoop, AWS, Java, Excel/VBA• MBA from UCLA Anderson; Engineer from IIT Kanpur• Keywords: data scientist , data science, data analyst, business analyst, big data , business intelligence , statistical , nosql , mapreduce , hadoop , forecasting , collaboration , demand planning , segmentation , website analytics , data analytics , demand forecast models , funnel conversion , dashboard , kpi , nps , engineering , growth initiatives , ad hoc analysis , google analytics , qlikview , periscope , omniture , macroeconomics , economic , team building , haver , datastream , management analytics , data visualisation , predictive modelling , spss , ssis, CFA, Thomson QA, IDC, Factset, Compustat, Bloomberg, Spiderrock, Global Financial Data, OptionMetrics, Excel VBA

Prabhat Dalmia's Current Company Details
Archer

Archer

View
Managing Director, Data & Technology at Archer
Prabhat Dalmia Work Experience Details
  • Archer
    Managing Director, Data & Technology
    Archer Mar 2021 - Present
    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.
  • Healthtap
    Director Of Analytics
    Healthtap 2018 - Jul 2020
    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 external as well as internal stakeholders. • 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 insurance claims data, and calculates savings by determining hospital visits avoided due to use of HealthTap. • 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 Analytics, Amplitude, Optimize, Facebook ads, Google ads)• 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.• Reports Standardization: Led a project to move away from multiple customer specific reports to a set of 4 standard reports that can be packaged out of the box, driving down significant development & maintenance time to onboard & support a new customer.• Tools: SQL, Tableau, R, Python, Google Analytics, Amplitude
  • Roku Inc.
    Data Science & Analytics Leader For Devices
    Roku Inc. 2017 - 2018
    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 to business.• 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 initiatives including Upgrade Your Roku Campaign, and Enhanced Initial Onboarding, all geared towards retaining customers & reducing churn. • 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 helped in valuing and negotiating various partner deals.• 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 various slices of data; became a goto dashboard to answer various device/account questions. • Channel Recommendation Engine: Led the development of a recommendation engine that suggested new channels based on customer viewing history on the lines of “Customers who watched Channel X also watched following Channels”. Model used to make recommendations to customers and increase customer satisfaction and retention.
  • First Republic Bank
    Director, Data Science & Analytics
    First Republic Bank 2015 - 2016
    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 improvement projects that impact bank wide operations & financial reporting.• 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 Crisis• 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 cross-sell can be better targeted• 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 salesforce save valuable time in making those linkages• 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
  • Summer Road, Llc.
    Sr Data/Quant Research Analyst
    Summer Road, Llc. 2014 - 2015
    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
    Data/Quant Research Analyst
    Cambria Investments 2011 - 2014
    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 across asset classes, and geographies that formed the basis for a number of publications, and Cambria sponsored ETFs in the market.• 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 and half the drawdown compared to the MSCI ACWI Index; backtested back to 1980; low turnover• 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 1900• 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 drawdown.• 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 to 1991.• Shareholder Yield: Researched shareholder yield strategy on US, Developed & Emerging markets using Factset (with Factset Fundamentals) & Clarifi (with Compustat) which is being used for Cambria ETFs SYLD & FYLD• 13F Filings: Developed a program to download & extract holdings from the 13F hedge fund filings from SEC Edgar; analyzed this data to come up with stock picking ideas based on fund filings
  • Los Angeles Capital Management
    Research Associate Intern
    Los Angeles Capital Management Aug 2011 - Oct 2011
    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
  • Oracle Corporation
    Software Architect
    Oracle Corporation 2006 - 2011
    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
  • Oatsystems Inc
    Solutions Architect, Professional Services
    Oatsystems Inc 2002 - 2006
    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)

Prabhat Dalmia Skills

Financial Modeling Fixed Income Portfolio Management Vba Java Investments R Quantitative Finance Bloomberg Equities Trading Capital Markets Strategy Software Development Financial Markets Management Sql Analysis Derivatives Investment Management Big Data Analytics Data Scientist Business Intelligence Statistical Data Analysis Statistical Modeling Statistical Tools Nosql Mapreduce Hadoop Forecasting Trend Forecasting Demand Forecasting Economic Forecasting Strategic Forecasting Pricing Strategy Cross Team Collaboration Demand Planning Segmentation Customer Segmentation Strategy Website Analytics Kpi Dashboards Net Promoter Score Ad Hoc Reporting Google Analytics Qlikview Omniture Team Building

Prabhat Dalmia Education Details

  • Ucla Anderson School Of Management
    Ucla Anderson School Of Management
    Strategy
  • Indian Institute Of Technology, Kanpur
    Indian Institute Of Technology, Kanpur
    Engineering

Frequently Asked Questions about Prabhat Dalmia

What company does Prabhat Dalmia work for?

Prabhat Dalmia works for Archer

What is Prabhat Dalmia's role at the current company?

Prabhat Dalmia's current role is Managing Director, Data & Technology at Archer.

What is Prabhat Dalmia's email address?

Prabhat Dalmia's email address is pr****@****tap.com

What schools did Prabhat Dalmia attend?

Prabhat Dalmia attended Ucla Anderson School Of Management, Indian Institute Of Technology, Kanpur.

What skills is Prabhat Dalmia known for?

Prabhat Dalmia has skills like Financial Modeling, Fixed Income, Portfolio Management, Vba, Java, Investments, R, Quantitative Finance, Bloomberg, Equities, Trading, Capital Markets.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.