Arijit Guchhait

Client Overview: J&J MedTech

• Developed and optimized SQL queries, store procedures, views according to client's requirements, improved data quality to resolve performance bottlenecks in visualization, decreasing refreshing time by 20%
• Collaborated in team in developing and maintaining 25+ dashboards to visualize the KPIs for about 0.5M SKUs in multiple markets with active users of 150+
• Pioneered the integration of Azure ML models (XGBRegressor, Random Forest) with Power BI for predictive sales analytics, significantly enhancing the accuracy of sales forecasts by 35%
• Collaborated with data engineers to maintain data quality and row level security effectively across large team in dataflow
• Maintained comprehensive SQL scripts library in Git, increasing analysis consistency and reducing errors in visualizations

• Implemented a separate data warehouse architecture (medallion) which streamlined data storage and retrieval from ERP and CRM in structural manner
• Developed recursive CTEs, Complex Joins, Sub-query for deeper data analysis according to business requirements
• Enhanced data quality by creating data validation scripts in SQL, leading to a 10% decrease in data entry errors
• Deployed Power BI dashboards for weekly sales performance, inventory levels reports with Power BI, reducing stockouts by 22% and overstock by 18%

• Build MySQL database from scratch for sales and raw materials for analysis and informed decision
• Build optimization model in Excel with Solver, Joins multiple tables using XLOOKUP for supporting inventory planning and forecasting (ARIMA)
• Conducted A/B testing to evaluate the effectiveness of different marketing strategies of new launched products