Projects

Provider Data Repository (Healthcare)

Created a data repository from the patient’s point of view
Developed a centralized data warehouse and successfully migrated to Azure SQL Server for further analysis
Designed Logical and Physical data models with Fact-Dimensional modelling and hierarchies
Designed and implement the SSIS ETL workflows and mappings for optimal performance
Build visually appealing and interactive dashboards in Tableau Desktop with search capabilities

Let Me Drive You! (Mobile based user application)

Analyzed market needs by conducting 15+ customer surveys
Created 10+ wireframe mockups with 25+ interactions for website and phone application using Balsmiq

Auto Insurance Database

Created the database from scratch with over 20 entities, 10 stored procedures and 20 database functions
Build optimized SQL queries to perform various CRUD operations on the database while ensuring the consistency of the data

Walmart Sales Forecasting

Cleaned data and merged datasets with over 500K records to apply different models in R
Developed prediction models using Multiple Linear Regression, Decision Trees, Logistic Regression, KNN Classification and used cross validation to deduce the most accurate model

Utilization of facilities at Marino Center

Collaborate with managers and understand requirements
Gathered the raw data to develop a database in SQL Server
Data Visualization utilizing R and other charts and diagrams
Predicted the number of patrons using different facilities on the basis of the data collected using linear regression model in R
Built reports in Tableau which helped management take informed decisions

3 Degree of Freedom Motion Based Car Simulator

Designed and manufactured components and then assembled them
Data acquisition of roll, pitch and yaw values by Arduino board and MPU 6050 sensor
Interfaced Arduino with LabView to operate linear actuators

Google Sites

Report abuse