Jay Vankawala

Business Intelligence Engineer

Egen•  January 2024 - Present•  Remote

Designed a Google Looker dashboard using LookML for a state agency for analyzing and reporting Customer Care AI chatbot data metrics such as total user requests, user sentiment, conversation topics, fulfilled requests, and escalations requests handling 10,000 conversations per week. Reduced automobile crashes by 15%, uncovering key crash hotspots and root causes by creating a Tableau dashboard for the client. Leveraged SQL and Tableau Prep to build data pipelines that cleaned, transformed, and integrated data from multiple sources.

Solutions Analyst

Egen•  July 2022 - January 2024•  Remote

Led a groundbreaking project in partnership with Google Cloud for the development of the vehicle maintenance dashboard for the Google Cloud Government Summit 2022 with estimated savings in time and costs to clients of up to 30%. Ideated and designed complex and innovative solutions leveraging expertise in technologies such as Google Cloud's Vision AI, VertexAI, DocAI, and Dialogflow CCAI to showcase the value of our solutions resulting in wins amounting to $1M. Developed and optimized resource plans, project timelines, Statements of Work (SOWs), and cost models in Excel reducing costs by up to 40% and increasing profits by 15% while ensuring successful project delivery within budget and timelines.

Equity Analyst

Meliora Fund, University of Rochester•  September 2021 - May 2022•  Rochester, New York

Recommended technology stocks using Time Series Forecasting in Excel for the school fund analyzing data from CapIQ and Bloomberg for stocks listed on NASDAQ generating 10% return. Created strategies with 60 days of backtesting for stocks using Python having a potential of generating 3-8% over same time period.

Summer Intern: Equity Research

R Wadiwala Securities Pvt. Ltd.•  April 2019 - May 2019•  Surat, India

Deployed a predictive valuation model using Microsoft Excel by analyzing historical financial statements of 30 Stocks to forecast 3–5-year target price of equities from various industries such as agriculture, lubricant, FMCG, and IT. Prepared stock investment recommendation reports exploiting discounted cash flow analysis along with technical analysis to identify patterns in charts and establish entry and exit prices resulting in a yearly return of 20% from the recommended stocks.