Arpit Khandekar

Countries GDP_Analysis has been done based on the three factors:
1) GDP QoQ(Quarter on Quarter)
2) Employment Rate
3) Inflation Rate
Country Filters are used to select GDP for any particular country.

• Used various statistical analysis tools to build the best model to predict the value of a given Boston houses.
• Evaluate the model performance on both training and testing data using RMSE and R2 score.

• Using ARIMA time series analysis method for forecasting, we predicted future values based on the previously observed values.
• Validated our forecasts using MSE and RMSE to compare the predicted value and observed value.
• Compared couple of category sales by using forecasting tool Prophet to analyze time series that display patterns on different time scales such as yearly, weekly and daily.

• Found top customers for the retailer using the RFM segmentation technique which uses past data to divide customers into groups.
• For this analysis, we have taken Basket Market Data Retail sales data. We fill find top customers for this retailer.

• Prepared reports that interpret customer behavior, market opportunities, competitors, and marketing channels and sources.
• Implemented KNN, Navie bayes, Decision Tree and SVM classification algorithms and K means, Hierarchical clustering algorithms using Python which can be helped for analyzing and executing new services, markets and advertising opportunities.
• Identified key metrics and performance indicators using Feature selection and reduction technique.

• Validate 5 Million user’s data using Tableau tool to understand user behavior and determined the customer spending trend.
• Analyzed the results and interpreted the conclusion which can help customers to control unnecessary expenses by 20%.

• Used Pentaho Data Integration/Kettle to design all ETL processes to extract data from various sources including external files,
cleanse and then load the data into the target data warehouse.
• Created transformation that involves configuring the following steps: Table input, Table output, Text file output, CSV file input,
Insert/Update, add constants, Filter, Value Mapper, Stream Lookup, Sort rows, Database Lookup, Set Environment variables.
• Worked on complex ETL transformation… Show more

• Used Pentaho Data Integration/Kettle to design all ETL processes to extract data from various sources including external files,
cleanse and then load the data into the target data warehouse.
• Created transformation that involves configuring the following steps: Table input, Table output, Text file output, CSV file input,
Insert/Update, add constants, Filter, Value Mapper, Stream Lookup, Sort rows, Database Lookup, Set Environment variables.
• Worked on complex ETL transformation and jobs including processing data from Excel to MYSQL database.
• Performed optimization of SQL queries, which reduced the delay and facilitated after reports generation.
• Troubleshoot issues with failed ETL processes. Show less

• Analyze the percentages of visa applications certified, withdrawn or denied.
• Discovered trend to find important factors influencing H1B denials and build a predictive model.
• Performed hypothesis testing to check salaries of Electronics Engineer and Agricultural Engineer are similar or not.
• Performed data cleaning on data set to build a logistic regression model.
• Compared the models based on AIC value, McFadden’s R square value for training data sets.

• Interpreted data from primary and secondary sources using statistical techniques and provide ongoing reports.
• Successfully interpreted data to draw conclusions for managerial action and strategy.
• Extracted, compiled and tracked data, and analyzed data to generate reports.
• Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis.
• Created Stored Procedures, Functions, Packages and Triggers using SQL.
• Planned, designed and… Show more

• Interpreted data from primary and secondary sources using statistical techniques and provide ongoing reports.
• Successfully interpreted data to draw conclusions for managerial action and strategy.
• Extracted, compiled and tracked data, and analyzed data to generate reports.
• Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis.
• Created Stored Procedures, Functions, Packages and Triggers using SQL.
• Planned, designed and developed database SQL statements for the data, populating in the banking software.
• Developed a Macro Automation tool which tracked overall downtime of project, which increases productivity of team by 20%
• Drafted and Maintained business requirements and align them with functional and technical requirements.
• Developed a Macro automation tool which generates the Scenarios, which reduces manual efforts significantly by 9 hrs.
• Managed a team of 19 members and performed Risk Identification, Mitigation & Reporting directly to Project leads Show less