Hello! I'm Shruti
A data interpreter, business analyst and information manager with a proven history of turning large data sets into progressive ideas through the creation of summarized analysis, clear, compelling infographics, maps, data visualizations, interactive media and product designs
​
Shruti Mehta
Business Data Analyst | Business Intelligence Analyst | ETL Developer | Business Analyst | Kaggler
​
Expertise - Predictive Analytics, Data Management, Data transformation, Database design and modeling, Business Intelligence, Data Visualization, Collection, Storage and Retrieval
EDUCATION
Northeastern University
MS, Information Systems; GPA: 3.71
My coursework is a perfect balance between theory and practice, which provides us with a basic foundation to advance our information technology skills in a way that keeps up and, better yet, exceeds the necessarily fast pace of this progressive field.
Coursework:
• Application Engineering Development
• Data Management and Database design
• Data Analysis using Python
• Advances in Data Sciences and Architecture
• Business Analysis and Information Engineering
• Data warehouse and Business Intelligence
• Big-Data Systems and Intelligence Analytics
• Introduction to Info Tech Auditing
2016-2018
Master's Degree
2010-2014
Bachelor's Degree
University of Petroleum and Energy Studies
B.Tech, Computer Science
Coursework:
• Storage Systems
• Computer System Architecture
• Database Management Systems
​
​
EXPERIENCE
SKILLS
Machine Learning- Logistic Regression,
PROJECTS
​
-
Graduate Teaching Assistant for 2 courses Data Management and Database Design and Big Data Systems and Intelligence Analytics
-
Mentored students for building ML models, code debugging, conducted boot camps and graded assignments for 200 students
-
Facilitated the professor by helping him in designing the coursework and assignments
August 2017-Present
Graduate Teaching Assistant
May 2017-September 2017
Data Analyst Intern
A CDN service provider headquartered in Tempe, Arizona
​
-
Performed ETL (Python, SQL) on raw real-time log files using API’s of Splunk, OpenTSDB, SQLite for parsing through data sources
-
Performed data wrangling, cleaning and munging in python for analyzing the patterns in the server recovery time and built prediction model for analyzing recovery time of cloud storage server
-
Enhanced customer experience by embedding interactive visualizations in web portal using Flask framework and Bokeh thereby increasing customers’ view by 20%
-
Developed self-service dashboards using Tableau to demonstrate server load across multiple data centers
-
Forecasted network traffic patterns on time series data and presented in daily meetings
-
Spearheaded data retrieval and management for business requirement analysis in agile environment; tracked project development status using JIRA
-
Served as a peer facilitator and provided support to deploy Tableau Server for the organization
Transactions Filtering: Fraud Analytics
-
Extracted bank transactions from database, performed feature engineering and utilized Logistic Regression model to predict transactions as authentic or fraudulent. Further investigated the authenticity of fraudulent transactions using Confusion Matrix
-
Designed schema for database modeling in SQL Server; trained a team of 20 and supported in creation of queries and reports
​​
CRM: Retail, CPG and Logistics
-
Analyzed customer trend over 5 million data points and performed data cleaning, exploratory analysis, feature engineering and utilized unsupervised learning using K-means Clustering. Demonstrated high revenue generating zones in Europe and proposed recommendations for business expansion in collaboration with marketing team
-
Performed EDA on flow of products in the European market and formulated reports and dashboards in Tableau that suggested improvised marketing strategies; leading to 34% growth in customer acquisition
July 2014-June 2016
Data Analyst
LEADERSHIP ACTIVITIES
Scholar, Young Scholar's Conference at Brown University, October 2017
Contributor, Lead 360, Northeastern University, December 2016
PHOTO GALLERY
Public Speaker and Leader, Toastmasters International, 2015 - Present
CONTACT
​
Feel free to reach out to me
Have a look at my resume
Contact me if you are interested in knowing more about me?
