HSBC
July 2018 - June 2019Data Analyst
• Data Mining or Data Extraction using highly complex and efficient SQL queries to pull underlying data required for further deep dive analysis
• Optimizing existing SQL codes to make them more efficient and less time consuming
• Created a segmentation model using k-means clustering to identify the various consumer segments and measure the product conversion rate among the various segments to identify the most profitable customer segment for a product
• Automated a Region wise Issue Tracker tool which generates a specific PPT for each region consisting of an in-depth status report
• Developed a Geography based Issue Resolution Performance Dashboard in Tableau highlighting the critical issues on a Map View at a monthly basis
• Evaluated performance benchmarks and established customer insights