Research Assistant Analyst

Aishwary Gawande

Highly enthusiastic analytics professional with 7 months of experience with

multiple stakeholders from retail and education industry. Sourcing business with core proficiency in Machine learning, Data engineering & BI. Hold’s a Master's degree in IT Analytics & a professional AWS cloud certification. Technologies

Techniques

Git

Azure

AWS

Google Cloud

Experience

• Research Assistant Analyst (Rutgers University, NJ) (Feb 2021 - Present)

- Automated ETL process by raw data ingestion from flat files, HTTP using control flow activities, parameters and variables with Scheduled Triggers

- Used Data flow, HdInsight in Azure for transformation thus creating production ready pipelines.

- Queried database using advanced SQL queries in SQL Server Management Studio

(SSMS) to validate the data loaded into target tables

- Designed and maintain Tableau dashboard which analyzes the impact of COVID-19 globally, using the calculated metrics and parameters

- Made extensive use of advance analysis actions, container swap, parameters and calculations to eliminate the use of hardcoding and the manual sorting

• Operation Research Analyst (SportsId, GA) (June2020 - Aug2020)

- Created an analytics framework to address customer attrition problem that helped to identify customers were at the risk of churning out of their system

- Recommended products with market-basket analysis techniques which lead to increase in sales by 17%

- Implemented complex procedures in SQL to create data models and increase the efficiency of dashboards by 65%

- Developed the Data Visualization in Tableau to provide visual insights for business ******@*******.***

+1-862-***-****

New Jersey, Harrison, USA

https://www.linkedin.com/in/agawande2210/

SQL

Python

Linux

Tableau

C

R

Excel

Docker

Power BI

C++

Linear

Regression

Clustering

KNN

Ridge

Lasso

Naive Bayes

SVM

Random

forest

XGBoost

Logistic

Regression

K-means

K-modes

Hierarchical

DBSCAN

RNN

Hypothesis

testing

Time series

NLP

Certifications

AWS CCP/CLF C-01

Tableau Desktop Specialist

Python for Data Science

Intermediate SQL

Platforms

Academic Projects (Source code @http://github.com/aishwary2210)

• Querying Employee Database

- Performed Data Modeling by inspecting the flat files and creating the ERD of the table.

- Created Table Schema for each of the flat files. Specified data types, foreign key, primary key and other constraints.

- Performed Data Analysis using joins, CTE’s and windows functions on employee database

• US-Mexico Border Crossing Trend

- Analyzed highly complex time series data and applied ARIMA, Holts Linear/Winter Additive, Multiplicative, Naive, Seasonal Naive, Average & Drift Data modeling techniques

- Evaluated the models on the basis of ME, RMSE, MAE, MPE, MAPE, MASE tests. Holt’s Winter Multiplicative was concluded as best model

• Suicide Analysis

- Performed PCA on the countries with variables population, gdp_per_capita, suicide to study its effects in 1986 and 2015 and Analysis of One way variance (ANOVA) for other variables

- Achieved model accuracy with Multiple Linear Regression giving R-square 0.91

• Music Recommender System

- Performed descriptive and diagnostic analysis using the data fetched from the Spotify API and performed data preprocessing

- Applied Principal Component Analysis (PCA)to reduce the dimensionality to avoid features giving the redundant value & to avoid overfitting the model

- Compared the models accuracy with Logistic Regression, Gaussian Naïve Bayes, Decision Tree, KNN & achieved the best accuracy of 89% with Random Forest Classifier

• Project Management

- Designed detailed project charter defining project goals, governance structure, budgets, risk and stakeholder management

- Prepared and implemented the Word Break Down Structure (WBS) and Gantt chart for controlled and monitor scope of work

Education

Rutgers University

(MS in IT& Analytics) (3.78/4.00)

Coursework :

- Analytics Business Intelligence

- Statistics & Machine Learning

- Management Innovation Tech

- Business Data Management

- Software Development

- Business Forecasting

- Project Management

- Multivariate Analysis

- Business Analytics

Contact this candidate