Boston, Massachusetts, United States
2K followers 500+ connections

Join to view profile

About

I am a Data enthusiast with experience concentrating in Data Solutions, Analytics and…

Activity

Join now to see all activity

Experience & Education

  • ZS

View Harshad’s full experience

See their title, tenure and more.

or

By clicking Continue to join or sign in, you agree to LinkedIn’s User Agreement, Privacy Policy, and Cookie Policy.

Licenses & Certifications

Courses

  • Advanced Database Management Systems

    INFO7275

  • Application Engineering and Development

    INFO5100

  • Big Data Engineering with Scala Functional Programming

    CSYE7200

  • Data Science engineering methods and tools with Machine Learning

    INFO6105

  • Data Structures

    CSE205

  • Data Warehouse and Business Intelligence

    INFO7370

  • Java Programming

    CSE406

  • Object Oriented Programming

    CSE202

Projects

  • Bitcoin Data Persistence & Price Prediction

    -

    Technology: Scala, Spark, Zeppelin, Kafka, MySQL
    • Used Bitstamp rest API to fetch cryptocurrency exchange data (USD/BTC) and stored in Spark Parquet format
    • Developed Kafka streaming for real time data collection and used it in Zeppelin for visualization with spark SQL query
    • Built ARIMA machine learning model using SparkML to forecast Bitcoin price for the next 15 days based on persisted data

  • Amazon Product Recommender & Sentiment Analysis

    -

    Technology: Python, NumPy, Pandas, Matplotlib
    • Build a machine learning model on Amazon’s products data to perform product recommendation and user sentiment analysis
    • Performed data preparation, data cleaning using TF-IDF & WordCloud vectorization to train the model effectively
    • Implemented KNN algorithm for product recommendation and Logistic Regression & Naïve Bayes for sentiment analysis

  • Retail e-commerce Data Warehouse & BI

    -

    Technology: Oracle, PostgreSQL, Talend, Tableau, Power BI
    • Designed dimensions & measures data modeling for data warehouse and developed data integrations using Talend
    • Implemented DI control jobs to analyze data processing time, which helped in improving job efficiency by 35%
    • Developed dashboard and report in Power BI & Tableau for sales analysis, promotion analysis and reject analysis

  • OpenPaymentsData (Healthcare and drug industry financial data)

    -

    Technology: Tableau, MS-Excel, and SQL Server
    • Analyzed relationship between large data sets of dimensions and measures for different kind of medical payments
    • Generated trend analysis charts on physicians and their payments from manufacturers over date and time
    • Published business dashboard of the above data analysis and business oriented reporting using Tableau

  • AdventureWorksDW Visualization

    -

    Technology: Tableau, Power BI, Talend, ER Studio, and SQL Server
    • Converted relational model into dimensional relationship in ER studio and generated sub models for data analysis
    • Created data visualizations in Tableau and Power BI. Performed trend analysis on generated data
    • Integrated data from relational database to dimensional database using Talend tool

  • E-Commerce Database Management

    -

    Technology: MySQL
    • Modeled entity relationship architecture and implemented forward and reverse engineering feature
    • Applied normalization over tables to avoid anomalies and to keep data well organized
    • Implemented triggers, sub-routines, indexes and views for optimized database and better data results

  • Global Vaccination Solutions

    -

    Technology: Java, db4o
    • Developed swing application to analyze infant mortality data and supply vaccination and doctor needs globally
    • Incorporated email API for user interaction, JFreeChart library for pictorial representation of mortality data
    • Followed enterprise object model design with singleton object approach and used db4o for data persistence

  • InfoVore - An Android mobile app

    -

    It was my undergraduate final year project. We build this project with a team of 5 people. It was an Android mobile application that features news feeds and articles from all over the globe. All this informations was being parsed and fetched from over 30 websites and their various APIs & RSS feeds and then put together inside the application pages based on its category like Sports, Politics, Fashion etc. Apart from the news updates the app also had additional features like weather forecast…

    It was my undergraduate final year project. We build this project with a team of 5 people. It was an Android mobile application that features news feeds and articles from all over the globe. All this informations was being parsed and fetched from over 30 websites and their various APIs & RSS feeds and then put together inside the application pages based on its category like Sports, Politics, Fashion etc. Apart from the news updates the app also had additional features like weather forecast, astrology and sharing news content to your Facebook account.

    Other creators

Recommendations received

More activity by Harshad

View Harshad’s full profile

  • See who you know in common
  • Get introduced
  • Contact Harshad directly
Join to view full profile

Other similar profiles

Explore collaborative articles

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

Explore More

Others named Harshad Jaju

Add new skills with these courses