Aalap Doshi

Work History

Business Intelligence Analyst

SMARTNEWS

12.2021 - Current

Developing ETL pipelines to extract and store information from our data warehouse Hive, Snowflake to create data models using Python in Airflow and DBT using complex SQL queries that reduce querying time by minutes Serve as an architect for DBT projects by building, maintaining, and optimize data models to DBT projects for a consistent user experience for stakeholders across the warehouse to be ingested in BI tools Writing Unit test to maintain the integrity of the meta data coming in through the data models Work cross functionally to accomplish all of the above! You'll work across Product, Engineering, Sales, Marketing, Partnerships, and with users of all skills and levels and training them on best practices to use these BI tools Document, templatize, automate and define a process around everything you do that is repeatable and set up for scale for ETL/ELT process Used Hive/Presto SQL to put data into tools like Tableau flow/LookML to develop data models to be put into Tableau/Looker to develop dashboards for monitoring the quarterly scorecards of the product to help increase customer adoption of Smartnews features by 5% Conduct in-depth analysis to uncover opportunities for improving Smartnews products by using variety of data sources, front end analytics tools and clickstream data aiding to increase CTR by 3% Create KPI's that better understand customer behavior and better understand the drivers of customer engagement and retention for different segments of users to drive increase adoption by 3% for these different segments

Data Analyst II

F5 NETWORKS

09.2019 - 11.2021

Providing data driven insights for F5 products based on customer and product data which aids executives make decisions impacting end consumer adoption to products Partnering with enginering, Sales ops, customer success teams and enablement teams to develop dashboards that are leveraged by leadership and stakeholders team to identify areas of improvement and develop quarterly scorecards to improve productivity and performance by 5% Owning the ETL/ELT process to create data models to be put into Snowflake to be further used into Looker and Tableau to be used by stakeholders to make data driven decisions Developing a holistic understanding of F5 products upgrades, its new features and infrastructure by manipulating and analyzing high dimensional data to achieve customer adoption of new upgraded product by 4%

Data Scientist (People Insights Analyst)

GE Digital

06.2018 - 01.2019

Working with cross functional teams by collecting data over 10 million points to perform data exploratory, regression analysis by looking into hiring talent to ensure company that company's workforce talent increases by 10% yearly Ensuring the significance of the data with the help of T-tests, Hypothesis tests, variance analysis, further built a logistic regression(87% accuracy) to understand attrition data assisted with charts of histograms, scatter plots with Matplotlib Collect data from structured SQL/unstructured sources, making Python scripts for extracting, merging, cleaning time series data to develop quarterly reports using Tableau Dashboards and visualizations which would track 10% growth

Overview

Work History

Business Intelligence Analyst

Data Analyst II

Data Scientist (People Insights Analyst)

Education

MS Information System -

Skills

Languages

Timeline

Similar Profiles

MEL PierceMEL Pierce

Sionylen Melga PierceSionylen Melga Pierce

Josephine LekupeJosephine Lekupe

Jennifer HallmanJennifer Hallman

Jessica Jenkins (Sandstrom)Jessica Jenkins (Sandstrom)