Piyusha Pawar

o Collected and merged data for flights and weather conditions in the USA and created a data structure to handle missing values as a part of data preprocessing.
o Extracted, transformed and pre-processed (ETL) data to remove unwanted and redundant values from original data.
o Implemented classification, clustering, decision trees to find patterns like months with highest delay, best day of week to fly out, busiest airport.
o Gained experience in pulling large datasets, performing data… Show more

o Collected and merged data for flights and weather conditions in the USA and created a data structure to handle missing values as a part of data preprocessing.
o Extracted, transformed and pre-processed (ETL) data to remove unwanted and redundant values from original data.
o Implemented classification, clustering, decision trees to find patterns like months with highest delay, best day of week to fly out, busiest airport.
o Gained experience in pulling large datasets, performing data manipulation using advance function. Show less

o Designed and implemented a Normalized relational database for a school bus and created workflow diagrams.
o Implemented features like bus route utilization rate, alert generation, computing gap time, driver schedule using Oracle PL/SQL procedures, functions, triggers, sequences and indexes. Used indexing and Normalization techniques on certain columns to increase the querying speed.

Requirement gathering and detail study of the existing rental management system was done. And new system solution was designed which satisfied the customer as well as the management office requirement. In this project I worked on use cases, process and logic models, data models, feasibility analysis, functional and non-functional requirements. Worked on SDLC processes and methodologies.

Literature survey on the existing papers related to the topic and proposed few alternative solutions and a system design to ensure security, privacy. And also handled sparse reviews, fake reviews and biased reviews.

Web-based Helpdesk is a platform which is rapidly growing with today customers needs which are overcoming the faults and inefficiency of handling the telephonic calls for the complaints. Our project helps users to submit their complaints and queries regarding the electronic and home appliances purchased. Customer satisfaction is the major concern for developing this web based platform which analysis customers sentiments along with the relationship of the customer with the company and helps to… Show more

Web-based Helpdesk is a platform which is rapidly growing with today customers needs which are overcoming the faults and inefficiency of handling the telephonic calls for the complaints. Our project helps users to submit their complaints and queries regarding the electronic and home appliances purchased. Customer satisfaction is the major concern for developing this web based platform which analysis customers sentiments along with the relationship of the customer with the company and helps to generate priority levels to resolve the complaint depending upon the negation. Once the complaint is registered in the database, automatic tokens are generated and conveyed to the customer through a text message and email for further tracking of the complaint. Natural language processing technologies are used for parsing, tokenizing, stemming and filtering the content of the complaint. The output is fed to the algorithm where the strength of the sentence is calculated. The intensity of negation is calculated, which helps prioritize the complaint automatically for the service provider to resolve the complaint.
Event Extraction and Sentiment Analysis in Helpdesk’s is designed using MySQL workbench, Java, HTML, CSS, JSP, XAMPP, Eclipse. Show less

o Project goal was to identify patients seen in the emergency department with allergic reaction, determine if they had an order for epinephrine, and if they had a follow up outpatient visit after their emergency department visit.
o It enhanced my ability to build a cohort of patients and calculate some metrics related to that cohort using MS Excel- working with large datasets, utilizing vLookups and advanced formulas, using and interpreting pivot tables, filtering and formatting.

In this project I worked on the analysis of the datasets which were converted into desired format and data analysis was done using Weka tools and that data was studied in detail to draw conclusions.

This project is about understanding the issues related to data quality, data analysis, and building predictive models.
Dataset : Medicaid Dataset.
Data Quality : Data Quality tool kit ( Finding defects and rectifying them using SQL queries ).
Data Analysis : Using R language.

Explored RapidMiner to facilitate Data Mining.
This project includes selection of a tool or emerging technology, obtaining evaluation copy, and explanation of key functionality and demo of the tool.

To analyze a company and compare to another company of similar size in the same industry.
Analysis of balance sheet, income statement, and statement of cash flows.

I studied an existing paper ‘Ubiquitous Computing By Matthew West’ in which detail study about the history of ubiquitous computing and an examination of current research developments. Advancing battery technology, wireless protocols (Bluetooth, IEEE 802.11, and LTE), applications, current examples, and social implications.

In this project, developed a website for our college cultural festival with backend connectivity.
Technologies used are PHPmyadmin as a backend and HTML, CSS, JavaScript, PHP for frontend development.