ABRAR AHMED KHAN

Project management and Business development for Insurance

• Business Development initiative - Worked with the Leadership team in discovering various problem spaces where AI & ML techniques will help in improving the precision as well as increasing the efficiency of the existing system
• Workers’ performance project - Worked as Senior consultant for operational excellence stream, helping in designing of KPIs, profiling and acquiring of data from 15 different sources (incl.key sources like claim center, servicenow, protect) in DB2 Data lake and creating data marts in AWS redshift (SQL) with a team of 5 developers and 2 BAs
• TMD Reporting project - Delivered an end to end project in Banking and wealth stream by helping them in creating the reporting layer and front-end dashboard in IBM Cognos for different TMDs
• Claim classification Initiative – Helped in development of machine learning models for classifying insurance claims based on various scenarios using NLP techniques which led to reduction in claims backlog by 13.8%
• T&M Project - Worked as a Delivery Lead for a team of 20 members (9 projects) by managing the delivery as well as maintaining the client relationship using tools like Jira

Streamlining DC operation reporting in Retail

• Historically all the different DCs for the second largest retailer in Australia had their own KPIs to monitor DC operations.
• Worked on KPI rationalization project i.e. Supply Chain Insight Transformation plan where we coordinated with all the DC manages and analysts to standardize the KPIs, data source and calculation methodology.
• Built code modules in Python (data ETL), Selenium was used for web scraping and metrics were visualized in Power Bi dashboard.
• Enabled Single source of truth providing Holistic visibility across DC Operations and Commercials, Aligned KPIs for consistent DC performance management.
• Cost Effectiveness due to Reduction from 8 DC + 1 Central FTE to 3 Central FTE (reduction of 6 FTE).

Business Consulting for Insurance Company

• Performance tool project - Worked as Lead BA for an Australian Insurance Company, helping them in requirement gathering and solution designing for a third party client using platforms like Confluence, AWS redshift (SQL) and MS Excel
• BICC Initiative project - Led a team of 7 BA’s in multiple stream project for discovering new project opportunities as well as profiling and mapping different data sources in pricing, operations , claim handling and workforce management spaces

VBA Automation for Retail Industry.

• Executed an end to end automation project in Supply Chain Reporting automation Project as a VBA developer
• Designed an automated module in creation of Financials reports and publishing PPT packs having summary on revenue of the week using VBA Excel and VBA power point
• Worked as a Lead BA for the central distribution team for analyzing all the data sources which captures data from distribution centres, creating ER diagrams on the sources tables used in ETL process.
• Rationalizing and development of key metrics measuring the performance of the DC and revenue utilized in all the running operations

Mu Sigma University Training Program

• Successfully completed Mu Sigma’s training program (MSU) and worked under multiple verticals to solve various business problems.
• Customer Churn in Telecom Industry - Successfully created an analytical framework to understand the major factors that affected the churning out of the customers to a telecom client and helped them in building the strategies to retain their customer base.
• Promotion and campaign management in Retail - Acquired comprehensive understanding of all the factors affecting the promotional campaign for a Retail chain client by finding the important factors affecting the effectiveness of the campaign and doing the clustering and applying lift analysis to the success rate of the campaign.
• Undergone a rigorous Hack-a-thon style program over 12 weeks to solve unique business problems every week in a trained environment using SQL, R, Python, Excel and R-Shiny.