Experience

  • Data Analyst Co-op

    at Metropolitan Transportation Authority

    June 2017 - December 2017

    New York

    Wi-Fi Data Usage Analysis * Identified Wi-Fi data abuse in MTA buses leading to a potential saving up to $10k per month * Implemented a real time usage tracking mechanism by fetching the transmitted Wi-Fi usage data from AWS queue, connecting it to PostgreSQL through Python, and analyzing the trends using Tableau dashboard * Designed daily and monthly KPI's for Wi-Fi usage and created an end to end workflow in Alteryx to report these metrics through Tableau dashboard Traffic Signal Priority Data Analysis * Improved transport time efficiency through root cause analysis for signal transmission delays by creating a real-time KPI monitoring system using Tableau as a front-end BI tool and Microsoft SQL Server 2016 as a back end database * Automated ETL process for daily transport data using R and generated and distributed executive reports using job scheduling

  • BI Consultant

    at Tata Consultancy Services

    August 2013 - October 2016

    Mumbai - Mahārāshtra

Education

  • Master of Science in Information System

    at New Jersey Institute of Technology

    2016 - 2017 (1 year) New Jersey

  • Bachelors in Computer Engineering

    at University of Mumbai

    2009 - 2013 (4 years) Mumbai - Mahārāshtra

Knowledge and keywords

Languages

  • English Native

Hives