Academic Projects
• Data Mart Design and Reporting Solution on Chicago Crimes (Senior Capstone Project), January 2018—April 2018
▪ Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data from flat files into data mart.
▪ Prepared the complete data mapping for all the migrated jobs using SSIS and data dictionary for the data mart.
▪ Built interactive reports, dashboards, and visualizations using Tableau.
• Yoga & More Relational Database, Database Design/Admin Coursework, February 2017—April 2017
▪ Converted business requirements into an ERD model and applied nominalization rules to create a relational schema.
▪ Prepared a physical model (data dictionary) to create database using SQL Server 2012.
▪ Created advance queries, views, stored procedures, and built reports using SSRS and Report Builder.
• Social Media Analytics, Applied Data Science Coursework, March 2017—April 2017
▪ Prepared a report for a real-time sentiment analysis on a soccer event using Twitter streaming API in Python.