Prediction of total goals (Above/under 2.5) of football matches using machine learning algorithms• Implemented logistic regression, Neural Network, Decision Tree and Support vector machine to predict the total goals of the football matches with the help of historical betting odds from various betting companies such as Pinnacle, Bet365, etc., • Applied Feature Engineering to create new variables and found that the newly engineered features are statistically highly correlated with the Target variable.

Credit Risk Modelling | SQL Server, SAS, Python, HDFS, Tableau• Built statistical models using Python to predict overdrawn credit card customers, delinquent accounts, and transaction patterns.• Strategized the bank’s lending decisions by developing Credit Risk Models to predict defaulting customers across payment cycles and developed a Shadow Rating model (statistical model combining PD, LGD, EAD) to rank borrowers on a given set of parameters.• Improved the model efficiency by more than 50 % of previous model and captured credible customers with a recall value of 83 %• Worked on various finances/sales events and created integrated view for monthly, quarterly, annual bookings/billings/backlog and revenue using Tableau DesktopTarget Marketing | SQL Server, Python, Tableau• Reduced market spends by 11 % by optimizing credit card marketing initiatives using Propensity Models and Segmentation.• Generated and provided the Marketing team with the list of targets for campaign purpose to reach out to the potential customers for subscribing the term deposit • Designed high performance dashboards to visualize performance metrics of Capital One credit cards against competing brands in the market.• Creating ad hoc reports upon Clients requests from SQL server• Blended data from multiple databases into one report by selecting primary keys from each database for data validation

Time Series Forecasting on Car & body parts Sales | Oracle, Python, HDFS• Implemented an ARIMA & LSTM time series forecasting model in Python to forecast the car and body parts sales across multiple locations. • Data was fetched from HDFS using HIVE in R and results were stored in Oracle database.• Checked for the Seasonality, trends, stationarity and identified optimal parameters by plotting ACF and PACF plots.• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers• Perform data/systems analysis to determine best BI solution (reports, dashboards, scorecards, data cubes) using Tableau

Driver Behaviour & Fuel Economy Improvement Tool | Oracle, SAS, Sqoop, HDFS, Scala, Spotfire, ArcMaps• Involved in building Dashboards using parameters, sets, groups and calculations• Understanding of Tableau features like calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.• Developed a data pipeline for analysing the significant factors affecting fuel economy by capturing driver behaviour information.• Clustered route-related data including distance, elevation, traffic intensity, and interstate /city /highway miles using K-Means Clustering.• Built a predictive model on the clusters using Scala to identify the significant behaviour attributes affecting the fuel economy by analysing the driver trip information data stored in HDFS.• Developed interactive dashboards and reports to visualize driver behaviour impact on Fuel Economy and Driver’s performance over time. • The tool saved around 1.3 Million Dollars companywide in the last 8 months.Freight Inspection Tool | Oracle, SAS, Sqoop, HDFS, Hive, PySpark, Spotfire• Developed a data pipeline for predicting shipments needed to be reweighed for a profitable revenue change.• Developed predictive model with 81 % precision by feature engineering key shipments attributes.• Designed dashboards to report revenue potential of incoming shipments and profitability of the reweighed shipments.Reporting | Oracle, SAS, Python, Spotfire, Tableau • Publishing customized interactive reports and dashboards, report scheduling using Tableau server.• Wrote multiple Python scripts, SAS Stored Process and SQL queries catering to ad-hoc reporting requirements of Freight Transportation, Safety and Legal teams.