• Predicting the Fair Market Value of Foreign Exchange deals booked at SGTS based on historical data.

• Dataset of approx. 50 fields and 5000 records, Done Data Visualization (Used seaborn) and EDA (dataset.head, info, describe etc.) , identify missing values (Imputer), removed unwanted fields, Encoding Categorical fields, Scaling the data , Training & Testing.

Model selection based on k fold cross validation and grid search to find the best parameters and accuracy

Predicting if the Sony Sister companies would be defaulters based on Historical data.

· Data Visualization (Used seaborn) and EDA (dataset.head, info, describe etc.) , identify missing values (Imputer), removed unwanted fields, Encoding Categorical fields, Scaling the data,Training & Testing .

· Model selection based on k fold cross validation and grid search to find the best parameters and accuracy

· Measured accuracy using confusion matrix and classification report.

· Increased accuracy by 7 %( achieved accuracy of 88%) by tuning the hyper parameters.

POC : Sentiment analysis of amazon reviews on Sony products

· Data Cleaning using python library re to remove numbers, punctuations etc i.e. only keeping letters a-z

· Converted reviews into lowercase.

· Removed irrelevant in reviews stopwords(using nltk library) to prepare them for machine learning.

· Stemming the words using PorterStemmer to keep the root of the words .

· Created bag of words model using CountVectorizer.

· Applied classification model on this bag of words model .

· Measured accuracy using confusion matrix and classification report.

· Increased accuracy by 7 % by selecting model based on k fold cross validation and grid search to find the best parameters and accuracy.

Key Insights Generation And Suggesting Action Items to increase Sales in the Sales Regions .

Fetching Data from Multiple Sources and doing Adjustemnets to reflect Accurate sales And profitability .

Generating Insights out of the data using Excel Pivot Table .

Comparing Revenue and Profitability with Last Year and suggesting Action Items for Next Year to Increase Sales And Profiatbility .