SHIVANI LAAD

*** ****** ***, ****** ****, NJ ****6 551-***-**** ac33z0@r.postjobfree.com linkedin.com/in/shivani-laad

OBJECTIVES: Seeking a data analyst position to analyze business data, identify and improve business opportunities using my exceptional technical & analytical skills

EDUCATION:

Masters in Computer Engineering, Stevens Institute of Technology, NJ, Dec 2017 GPA: 3.9/4

Bachelor of Engineering, Computer Engineering, University of Pune, May 2016 GPA: 3.5/4

SKILLS:

Databases: MongoDB, MySQL Languages: R, HTML, Python, C, SQL, Java, JavaScript

Operating Systems: Linux, Windows Others: Excel, Unix, Visio, SAS, SSIS, JIRA, Tableau

Machine Learning: Decision Tree, Linear Regression, KNN, Random Forest, K-Means

PROFESSIONAL EXPERIENCE:

Data Analyst - Crowded, NY Aug 2017 - Dec 2017

Interacted with data analysts and developers to gain better understanding of client requirements

Enhanced the R model to fetch candidate profiles from iCIMS database based on various parameters

Developed the R model to replace in-house tool to segregate most professional candidates based on pictures

Writing complex SQL queries, functions and macros to extract desired data from MySQL databases

Maintained meeting notes and presented weekly status reports on agile projects using Trello and JIRA

Performed excel data cleansing and transformation to develop ad-hoc reports in Tableau using JIRA data

Data Analyst - Credit Suisse, NY May 2017 - Aug 2017

Extract financial data and news from yahoo to perform sentiment analysis on the ticker performance

Developed an R Shiny application to visualize ticker performance and implemented logistic regression, random forest, KNN machine learning algorithms to fetch sentiment highlights for each ticker

Performed model evaluation of various machine learning algorithms using cross validation in python

Performed data analysis with various analytical tools, such as Python, Microsoft Excel and SAS

Wrote python scripts to list active Bloomberg user accounts and updated target excel based repository

Developed python scripts to extract server status from log files and report various KPIs in Tableau

SQL Data Analyst – Stevens Institute of Technology, NY Jan 2017 - Apr 2017

Created DDL and DML scripts, Stored Procedures, Triggers, Functions, Indexes, Views for applications

Enhanced SQL and database performance using indexing, partitioning and optimizing complex joins

Generated complex excel chart and reports on events, recruitment and billing data using SQL results

ACADEMIC PROJECT:

Amazon Product Top Reviewer – R Shiny, Machine learning. Aug 2016 – Apr 2017

Scrapped Amazon’s website for a particular product and categorized it using concept of sentiment analysis

Implemented Random Forest and Naïve Bayes machine learning algorithms to predict the top reviewer

Data Integration and BI System for Retail GAP store – Microsoft SSIS, Tableau Aug 2016 – Apr 2017

Implemented dimension model using star schema for sales transaction module as per DWH best practice.

Integrate data from source system to target DWH performing ETL operations using SSIS tool.

RESEARCH & PUBLICATIONS

Presented Research titled "Review and Analysis of Content Based Image Retrieval" at Pune Institute of Computer Technology

Contact this candidate