Swapnil Chauhan

Master's

Engineering and Technology Management

ZoomInfo

Data Analyst II

- Wrote complex Snowflake SQL queries (Window, UDF, subqueries, temp table) for audience targeting project by analyzing - Built Tableau dashboard for SaaS client in collaboration w/ GTM, Customer Success & Account Managers to measure 7 KPIs & presented the analysis and recommendation to team to eliminate ad hoc requests ( 2 days of work - Developed data pipeline (ETL) for launch of personal employment and education data product using Python, Snowflake by - Created daily B2B customer data cleaning process by developing Python scripts to extract parameters at scale and evaluating - Created self-service Tableau dashboard for sales and data solutions team by understanding operational needs for KPIs - Developed robust analytical framework to assess customer performance and engagement with platform using SQL, Salesforce and Tableau for Sales and Customer Success teams, improving customer engagement with platform by 18 - Automated the week-on-week data count change report to AWS S3 for 2 data points by creating PySpark notebook in Databricks, resulting in monitoring of data driven recommendations and minimized time to access data by 35