Mrudula Ashok Deore

Business Intelligence · DataScience · Web Development . mrudula3003@gmail.com

I am a gradudate student coming from a background of Business Analytics and Computer Engineering. My unique mix of skills and projects enable me to identify and understand business problems and solve them effectively and efficiently using programming languages and softwares.

Always seizing every opportunity that helps me grow both as a professional as well as an individual and also helps me contribute to my community is what drives me. This led me to be a part of several clubs and extra-curricular projects at both my undergraduate as well as my graduate university.To complete all challenges thrown at me and to make a significant contribution towards the society is my goal.

Experience

Graduate Research Assistant

Office of Information Technology - University of Texas Dallas
  • Analyzing bank transaction data to drive insights on spending patterns, implement customer segmentation and predicting customer default rate
Aug 2018 - Present

Technical Lab Analyst

Office of Information Technology - University of Texas Dallas
  • Reporting and analyzing user issues to improve customer experience by providing technical assistance and IT services for student and faculty
  • Created dashboard using Excel and Tableau to provide lab statistics and resource information to the team
May 2018 - Present

Student Web Developer

Big Data Club - University of Texas Dallas
  • Developed a full stack web application for the Big Data Club for events,member enrollment and online presence for the club
  • Technologies used : HTML5,CSS,JavaScript,PHP,MySQL,Google Analytics,Paypal API
Jan 2018 - Present

Business Intelligence Intern

Zensar Technologies,Pvt. Ltd
  • Gathered and analyzed clients’ business and functional feedback of system in support phase of SDLC
  • Interacted and communicated with colleagues and clients to solve issues related to the SAP-ERP system
  • Researched the Business Intelligence and conceptual framework to improve organizational key business processes
  • Technologies used : SAP-ERP, MSOffice
Jun 2015 - Jul 2015

Education

University of Texas, Dallas

Master of Science-Business Analytics

GPA: 3.67/4.0

  • Business Analytics with R
  • Applied Econometrics and Time Series
  • Marketing Predictive Analytics using SAS
  • Database Management Systems
  • Data Visualuzation

Aug 2017 - May 2019

Fr.CRCE, Mumbai University

Bachelor of Engineering- Computer Engineering

CGPA: 7.9/10.0

  • Data Structures & Algorithms
  • Data Warehousing and Mining
  • Artificial Intelligence
  • Web Technologies
  • Software Engineering

Aug 2012 - May 2016

Skills

Some of the Programming Languages & Tools I use
Highlights
  • Machine Learning & Predictive Analytics using Python,R and SAS
  • Data Analytics & Visualization using Tableau,Arc GIS,D3 and QlikView with integration using R
  • Data Modelling & Database Development projects in MySQL, Oracle and NOSQL
  • Interactive and Responsive Web Development using HTML,CSS,JS

Projects

Brand Strategy For Facial Tissues

Analysis of scanner data for targeting potential customers and brand strategy

  • Developed RFM model in SAS for segmenting customers to build look-alike models to target potential customers
  • Explored scanner data to track stores with highest sales and to build marketing strategies for the client company

Walmart weekly sale forecasting

Predicting weekly departmental sales of Walmart considering effects of holidays like Black Friday and Christmas

  • Analyzed historical data of 45 Walmart stores using Python to get insights on the effect of holidays on sales
  • Created a Random Forest model to predict the weekly departmental sales with F1 score of 0.615

Applied Econometrics and Statistics

Statistical Analysis and Impact of shall-issue law on crimes using R

  • Analyzed panel of dataset on shall-issues law of 23 years to solve data modelling issues like heteroskedasticity, collinearity and endogeneity
  • Implemented multiple regression models in R to find best fitting model using statistical techniques like Hypothesis testing and interaction variables

Predicting Customer Subscription in Banks using Support Vector Machines

Data Engineering, Feature Selection and Machine Learning using sckit,pandas,sklearn in Python

  • Examined Portuguese bank dataset using SVMs to predict customer retention rate for a short-term deposit or not based on user centric and demographic variables
  • Implemented feature selection, dimensionality reduction (PCA), imputation and cross validation in Python

Data Analytics and Visualization

Data Science using Tableau, QlikView,D3 and Arc GIS

  • Performed integrated analysis in R, Tableau using decision trees, K-means algorithm to visualize clusters
  • Created dashboard using multi maps and Arc GIS to pinpoint the different disasters affecting energy refineries in US
  • Constructed Trellis maps (QlikView) to track youth employment, income and expenditure trends over the years using Geospatial data

Predictive Analytics using SAS

Statistical Analysis

  • Implemented conjoint analysis model in SAS using Macro Functions on customer’s most preferred choice of detergent
  • Predicted the most preferred choice from different attributes of the product for each respondent using Logit rule
  • Analyzing Scanner Data to provide marketing strategies to brands by doing competitive analysis

SQL Experience

Database Modelling with MySQL,Oracle and Python

  • Created data-model(3NF) for housing prices dataset with over 13,000 records and designed a MySQL database
  • Manipulated data using SQL, Microsoft Excel and Python (mysql connector) to highlight top competitive prices
  • Experience in writing SQL queries and optimizing the queries in Oracle database and MySQL database

Integrating farmers with technology

Full Stack Web Application for my BE Final Year Project

  • Developed a MEAN stack application possibly reducing third-party intervention between farmers and Govt. by 75%
  • Designed the frontend and the backend implementing six fundamental features using technologies such as NoSQL database, JavaScript, Node server, Docker, Amazon AWS

Interests

Apart from using my programming skills in datascience and web development applications, I love to travel and paint whenever I have time to take a break from my coursework and projects.

When trapped within the four walls of my home, I follow a number of comic and animated movies and television shows, I love to draw and dance, and I spend a significant amount of my free time exploring the latest advancements in the business intelligence and data visualization world.Oh, did I mention my love for cats? Cats are AWESOME!

Extracurriculars & Organizations

  • Consulting Club,UTD - Corporate Relations Officer
  • Big Data Club,UTD - Officer
  • Euphoria Team,Fr.CRCE - Creative Head and Web Developer
  • Fr.CRCE - Student Web Developer

Awards & Certifications

  • R Programming A-Z™
  • Certificate for Analyzing and Visualizing Data with Excel