• Extracted and analyzed data around tickets raised for compliance and presented in automated dashboards• Did sentiment analysis using various advanced functions in excel to segment customer issues and required solutions• Automated the review of highlighting system flagged violations related to fraud and showed this in dynamic presentation• Collected detailed notes on investigation and other communication to adhere to legal requirements and enhance record keeping• Mined data and compiled detailed SOP’s to ensure that data mining adheres to legal requirements • Tools used extensively: Advanced Excel, SQL, Powerpoint and Tableau• Managed regular updates to senior management and weekly meetings to present data findings to various teams