Created a single data set by combining different datasets from the data lake Transformed data into the appropriate form and performed necessary calculations Visualize the data for easy user consumption using the Dataiku tool

Created data visualization graphics, translating complex data sets into comprehensive visual representations Created data queries and reports using QlikView, SQL Server Management Studio, SSRS, and MS Excel Analyzed and optimized existing SQL queries, improving effectiveness by 20% Applied knowledge of data modeling and statistical analysis to note trends and draw conclusions

Evaluated data to ensure inventory control needs were consistently met by improving and developing inventory management dashboards by predicting sales Analyzed given data and applied predictive models like random forest, linear regression, KNN, XGBoost Provided reporting, analysis and insights about sales drivers and key revenue performance metrics to support corporate analytics Created dashboards based on sales forecasts, demand and product trends. Achieved 77% forecast accuracy compared to actual demand