Saqib Alam Ansari

Worked on different projects like Motor Renewal Analytics, Loss Ratio Analysis using Python, Powerbi and Excel. Understand domain and workflow of insurance company and data understanding by hovering Multiple Data Views extracted from SAP Hana which can be utilized in analysis and model building. Collaborated with team, suggested solutions in Data like Automation in Analysis, impurity and abnormality treatment. Comparing Financial Years, to make decisions for business for growing in future and areas of focus, either state-wise, product-wise, service-wise, tried to find out patterns by which we company can grow.

Worked on 6 different projects during internship in growth and performance perspectives. Applied ML techniques to analyse bureau data from 120,000 users, effectively reducing fraud risks. Engineered 1000+ features using NumPy, Pandas, regex from OTP, SMS, Payday, and Fintech data present in MySQL database to reduce risk by adding these features to existing machine learning model and measuring the impact of new features. Enhanced existing files by adding 600+ Entities and 4300+ Headers, facilitating better data organization. Developed a specialized ML model using data from 6000+ rejected/delinquent users to tailor credit offerings. Implemented multiple models to minimizing risk exposure effectively and ensuring robustness of model by selecting optimum set of model features using RFE, Stability Selection and Boruta algorithms with cross-validation.

Analysed $186.19M in Amazon sales data in Tableau for actionable insights with Data Preprocessing. Derived detailed sales insights by state, country, product, and time period. Identified top and worst performing products for strategic planning.