Vyjayanthi Kamath 202-***-**** adgu64@r.postjobfree.com

Philadelphia, PA linkedin.com/in/vjkamath

EXPERIENCE

Associate Data Analyst, IQ Solutions Jul 2020 – Present

• Designing analytical workflows and data pipelines to build monthly/quarterly performance reporting systems on KPIs for various public health government agencies like FDA, SAMHSA, NIH orgs, and CDC

• Using Tableau to blend disparate data sources like PostgreSQL, MS Access, Google Analytics, and Excel, and design compelling interactive dashboards and reports that track program impact and provide summary statistics for analytical questions

• Building complex visuals like 3-stage Sankey diagrams and circle migration maps with Tableau to visualise global migration of people

• Automating reporting using Google Big Query and Data Studio to visualise survey and web analytics data

• Monitoring re-launched website and tracking user experience using Google Tag Manager

• Building detailed, insightful, and interactive reports using advanced Excel

• Utilizing Google Analytics to track visitor flow, user behaviour, advertising, and marketing campaigns to make visual reports using Data Studio that support strategic decision making

• Developing various queries and views to blend and transform raw data sources and design Data Studio reports for web analytics

• Refining and optimizing Tableau dashboards to improve and automate reports

• Assisting Lead Data Analyst in collecting, analyzing and improving departmental research and evaluation protocols Junior Data Scientist, Center for Advanced Transportation Technology Laboratory Nov 2018 – May 2019

• Performed ETL operations, feature engineering and data engineering to wrangle data for modelling

• Queried and transformed data from different sources using PostgreSQL, SQL scripts, views, and stored procedures

• Utilised odbc and rpostgres packages to integrate data from PostgreSQL to R for statistical analyses

• Built clustering and regression models on 4 million Waze and DoTS data records; reduced processing time by 14 minutes

• Conducted impact analysis of 35-day government shutdown on highway networks in the DMV area; visualised congestions and bottlenecks using Tableau dashboards

• Recoded, validated, and debugged software components to calculate accurate speed and time measures

• Provided analytical support to solve transportation, safety, and security issues Market Research Analyst, Chargen Lifesciences LLP Mar 2018 – Aug 2018

• Worked with Managing Director to deliver go-to-market analysis, financial plans & provide operational strategies to international client

• Wrangled 15GB of structured and unstructured data; performed data cleaning & outlier analyses using Python & Excel macros

• Designed questionnaires and surveys to capture qualitative and quantitative data; presented key insights to upper management

• Led extensive online and off-site market research on $30M industry; increased response rate by 86% PROJECTS

Data Analytics and Viz: Building a Data Analytics System for University System of Maryland

• Built a data storage platform using Airtable with analytical and visualisation ad-hoc reporting components; improved run-time by 85%

• Cleaned data using R and designed 5 interactive Tableau dashboards to track health of department Data Science: Clustering, Classification, and Time Series Analysis for Grocery Stores

• Implemented k-means clustering, classified new stores using decision trees, random forest, and boosted models, forecasted sales using ARIMA and ETS Models

• Used Alteryx and Python for data cleaning, modelling, and feature engineering; used Tableau for cluster and spatial visualisation Data Science: Prediction Models for Host Loyalty and Price

• Built models to predict host loyalty and price for Airbnb listings using regression, random forests, decision trees, neural networks with

~83% accuracy

• Used R for data cleaning, manipulation, feature engineering and modelling; featured in professor’s tenure portfolio Statistics & Data Analytics: Hypothesis Testing for Multitasking Performance of 2 Genders

• Conducted hypothesis testing with Multivariate Analysis of Variance (MANOVA), effect size and power of test; concluded women outperform men for our sample

• Used dplyr, lubridate, and tidyverse packages in R and SPSS for data cleaning, manipulation, and modelling SKILLS

Languages: R, Python, SQL, BASH

Analytics: Inferential Statistics, Predictive Modelling, Regression, Supervised/Unsupervised Learning, Time Series Forecasting (ARIMA and ETS), A/B Testing, Hypothesis Testing

Tools: Tableau, Data Studio, Alteryx, MS PowerBI, QlikView, Looker, BigQuery, Salesforce, Google Analytics, PostgreSQL, MySQL, MS SQL, Excel (macros, Pivot, vlookups, Analysis ToolPak, Power Pivot, XLSTAT), Teradata, AWS, AWS EC3, Hadoop, SPSS, SAS EDUCATION

University of Maryland College Park, Master’s – Information Management May 2020

• Graduate Assistant – Assisting students with disabilities, using ClockWork & SQL to generate student metric reports

• Focus in Data Science & Analytics - GPA: 3.92/4

LEADERSHIP & ACHIEVEMENTS

• Nanodegree, Predictive Business Analytics – Udacity with Alteryx, Google Analytics/Tag Manager/Data Studio certified

• Data Science Researcher – CrowdDoing, for Medicinal Foods and Herbs for Stress, Sleep and Anxiety

• Student Scholar, Grace Hopper Celebration of Women in Computing

• Executive Board – Graduate Advisor, Delta Alpha Pi Honor Society for students with disabilities

Contact this candidate