Shushnak Singh S

Project –Supply Chain Analytics

Support US based Manufacturing company to Develop & Automate Inventory optimization model for different brands and and product line, Performing EDA on data inputs to build effective Inventory optimization model.

• Exploratory Data Analysis on Lead Time, Demand forecast, Revenue, and Sales data to build data pipeline for Inventory optimization.
• Formulated the calculation of Min & Max inventory levels by integrating forecast error(MAPE) that resulted in Reduction of inventory levels and holding cost by 60% and 40%. Automation of end to end process resulted in saving 50 man hours.
• Enhanced functionality to calculate and automate Safety stock by cutting down manual interventions by Using SAS Macros and SAS scheduler. This helped business to reduce process time from 120 man hours to 8 man hours for quarterly report.
• Develop and automate quarterly Product Classification (ABC) Model. By Forecasting revenue and sales.
• Enhanced the program performance using SAS VIYA and CAS server coding, resulted in overall reduction of 40% process time.
• Inventory optimization using SAS Proc MIRP for Weekly SS Days and SS Stat cases by SKU, Plant and RDC Combination.
• Supporting team in building Power BI Dashboard for SS Model and Integration of Power App to Override ABC Class.

Design credit risk data model for assessing customer risk appetite to loan applications process to approvals and bookings . Prepare risk parameters to approve loan processing into booking and account performance tracking. Provide loan portfolio level risk MIS reporting and help business to strategize marketing strategy and risk mitigations at portfolio level

Account Origination

• Reports Access loan application data and map it to customer master, bureau master, macroeconomics data, internal behavior data towards gathering risk associate parameters and help business to identify each secured and unsecured loan portfolio level business insights to access risk underlying to approval process
• Manage daily, weekly, and monthly business snapshots on account origination reporting on Number of loan application received, approved, booked, and cancelled by # and %
• Report applications on exception base approved by # and %
• Prepare MIS on loan application by customer segment, score bucket, risk segment gone through received, booked, cancelled, and declined
• Executed overall data integration , cleansing , manipulation , aggregation , data model designing and process improvement for reporting and visualization within credit risk analytics platform from application (origination) facility file to decision file and account performance in SQL, VBA, SAS, and Python
• Streamlines excel base reporting to advanced data visualization applications like Tableau and Power BI within more insightful and storytelling KPI dashboards. Overall business impact 30%-man hours reduction

Account Performance Reports

• Develop complex data model designing in SQL & SAS for connecting customer analytics support through the journey from origination to current account performance analysis
• Prepare periodic performance for each portfolio level number of active customer base and their balances , Risk weighted assets, Delinquency by (#) and ($) group by (0-29,30-59,60-90,90+, CO), new origination and new balance, average loan per account from history to current, roll rate analysis for current to x and x+2, prepare good vs bad rate customer. knowledge on Probability at default (PD), Exposure at default (EAD) and Loss Given Default (LGD)
• Make vintage analysis and prepare each delinquent account performance form current to x+1 to x+2 and so on. Develop portfolio level insights to be analysis and presented in Retail dashboard
• Segment credit card customer based on usage and revenue to track their performance over time. timely trigger behavior and work on customer retention strategy for Credit Card Portfolio
• Provide oversight to line of business and its risk controls ensuring consistency and compliance with risk management framework and policies