Yash Wanve
Business Intelligence Analyst
New York,NY
Summary
Prudent Business Intelligence Analyst with 4 years providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.
Overview
7
7
years of professional experience
2
2
years of post-secondary education
3
3
Certifications
Work History
Business Intelligence Analyst
Chainalysis Inc.
06.2022 - Current
- Analyze customer revenue data to understand the top drivers of growth while also highlighting the headwinds faced by certain segments and providing recommendations around diversifying efforts around certain cohorts in a segment to ensure continuous new business
- Implemented an automation system based on product usage model to flag accounts that may churn due to low usage based on the current trends
- The account teams are notified 6 months into an active contract which provides them 6 months to engage with the customer and mitigate churn
- The model has captured 72% of the churn actuals since implemented
- Created data driven automation systems to enable customer success to upsell and retain customers based on their usage
- The system has detected over $8M of churn and enabled the support team to upsell over $3M to the organization's top customers
- Actively collaborate with leaders from Finance, Revenue and GTM to provide data driven solutions to enable their team's day-to-day functioning which made the teams efficient by 35%
- Developed a model to calculate true NRR by removing late renewals from the dataset to highlight key segments that are impacting the net revenue retention and the extent of the impact
- Created forecasting model to assess the ARR growth for the next 2 years based on historical pipeline conversion data across multiple regions
Business Intelligence Analyst
BestRX
09.2021 - 06.2022
- Created high value reports by gathering data from various sources and visualizing them which enabled an easy overview of the stream of incoming and outgoing Rxs with their respective stages which reduced the user's execution time by 20%
- Involved in extensive data validation using SQL queries and back-end testing
- Lead monthly analytics meetings to share insights related to revenue and location analytics
Business Intelligence Analyst/QA Automation Engineer
12t Wonder LLC
01.2020 - 09.2021
- Created high value reports using various data streams to assist the infrastructure group to analyze the usage of expensive equipment against man hours per facility per day
- Analyzed average throughput requirement for the application and simulated load testing using JMeter in the development environments
- Deployed and tested latest code changes across multiple environments by creating Jenkins jobs that would run SOAPUI and Jmeter tests
- Prepared data models and technical design specifications pertinent to applications/functions being developed
Analyst Intern
Lucy Labs Cryptofinance
06.2018 - 08.2018
- Downloaded data using Twitter and Reddit APIs and stored the data in a SQL database and computed a sentiment index for various crypto currencies
- Superimposed the generated sentiment on Google search score and daily close price and checked if the sentiment is a leading or lagging indicator to the price change and the correlation of the index to change in price
- Performed extensive research on the correlation of price between various tokens within an ecosystem
Education
Master of Science - Information Systems, Business Intelligence & Analytics
Stevens Institute of Technology
Hoboken, NJ 08.2017 - 05.2019
Bachelor of Engineering - Electronics
University of Mumbai
Skills
SQL programming
Data visualization
Data analysis
Business analysis
Data dashboard design
Advanced Excel
Certification
AWS DevOps Engineer
Technicalskills
SQL,Git, Tableau, Python, DBT, AWS, Agile
Timeline
Business Intelligence Analyst
Chainalysis Inc.
06.2022 - Current
Business Intelligence Analyst
BestRX
09.2021 - 06.2022
Business Intelligence Analyst/QA Automation Engineer
12t Wonder LLC
01.2020 - 09.2021
Analyst Intern
Lucy Labs Cryptofinance
06.2018 - 08.2018
Master of Science - Information Systems, Business Intelligence & Analytics
Stevens Institute of Technology
08.2017 - 05.2019
Bachelor of Engineering - Electronics
University of Mumbai