Close

Nikita Shah

Data Analyst/Engineer (R, Python, SQL)

Download Resume

About Me

Hello! I am Nikita. Thanks for visiting my website. I am graduating from DePaul university with a Master's degree in Information Systems (major in Analytics-Driven Decision Making) in the March, 2021. I am interested in topics like data analysis, data mining, data visualization. I like using R, Python, SQL to dig up the data and identify, interpret trends and patterns.

During my previous internship I worked with ETL pipeline engineers to gather the output data from Oracle SQL and CSV outputs. From those outputs I carried-out analysis of user trends, user activities, preferences and provided context to sales and marketing teams to create new campaigns and follow-up projects based on the data analysis and user feedback.


During graduate classes and projects I have taken classes in R, Visual Studion (C#), SQL, SAP and Python.

Experience

DigiFlux IT Solutions

Data Engineer and DB Administrator (Intern)

  • Working with engineering team to create a distributed system to collect, process and store logs on user activity.
  • Deciding the storage methods for the data pipeline outputs.
  • Designing database schema for an new projects.
  • Taking care of database backup/restore, cloning and refreshing activities.
  • Monitoring SQL server and database performance and proactively address potential performance issues.
  • Providing solutions for database issues including capacity, redundancy, replication, and performance.
  • Performing and managing daily database maintenance, monitoring and performance tuning tasks/jobs with Python and SQL scripts.

Education

DePaul University

Sept 2019 - March 2021

Master of science in Information systems (Major: Analytics-Driven Decision Making)

Relevant Courses:

Temple University

May 2019

Bachelor of Science in Health Science

Projects

IBM HR Analytics Employee Attrition & Performance (with R)

Uncovering the factors that lead to employee attrition and explore important questions such as ‘show me a breakdown of distance from home by job role and attrition’ or ‘compare average monthly income by education and attrition’. This is a fictional data set created by IBM data scientists.

Reference

Self-serve Kiosk UI development for Dunkin’ (with C# and Visual Studio)

Creating UI forms for ordering food and beverages from Dunkin’ self-serve system and storing the order data in the database.

United Airlines - Ticket Booking System

The project contains a business plan, business rules based on ER Diagram, relational schema after transfer into script and creating data warehouse, ETL and star schema to get company detailed description.

Group Three - Blue Demon Safety Escort Service “Demonscort”

Developed a project plan for university’s escort service using all project management tools and concepts like project Charter, WBS, cost Estimation, risk and communication management by analyzing the business processes, data gathering, developing internal software using java.

Skills

Get in Touch