• Worked on both Agile and Waterfall methodologies, depending on the length and timelines of the projects.• Implemented and followed Agile development methodology within the cross-functional team and acted as a liaison between the business user group and the technical team.• Developed predictive models using Python (Pandas, NumPy &Sklearn) to predict possibility of equipment failure.• Generated various capacity planning reports (graphical) using Python packages like Seaborn, Matplotlib, SciPy.• Performed Data Analysis and Data profiling using complex SQL on various source systems including SQL Server.• Built, published customized interactive reports, dashboards and scheduled reports using Tableau.• Worked with data investigation, discovery, and mapping tools to scan every single data record from many sources.• Developed business process models in Waterfall to document existing and future business processes.• Imported the claims data into Python using Pandaslibraries and performed various data analysis.• Created the Business metric KPI (Key Performance Indicator) to evaluate factors for different modules.• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.• Monitored, triaged, tracked and resolved issues with the Excel Power BIreports.• Prepared the data rules spreadsheet using MS Excel to update allowed values, findings, and profiling result.• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.

• Extracted 10+ usable features related to product price and crawled 10G+ competitor price by web scraping in Python.• Conducted market analysis on 30 + SKU performance in Europe in 12 months based on 50+ metrics e.g., ROI, market share.• Forecasted the product demands for next quarter by using time series analysis including Arima, Holt-winters.• Built the linear regression model in identifying the relationship between supply and demands in order to optimize the stock capacity, doubled the efficiency of orders fulfilment. • Explored new products with new procurement channels according to relevant marketing analysis, improved customer retention rate by 15% via efficient marketing promotion activities.• Developed dashboard report automation system to create 3 market reports weekly with ERP system, saved 30% of the reporting time.