Claims Data Analyst
Current• Developed Qlik Sense dashboard from raw dataset to automate weekly report and display key data trends• Completed enhancements to Qlik dashboards in production environment utilized by claims handlers and supervisors• Tested enhancements to Qlik dashboards to ensure updates were accurate and data was as expected• Reconciled data between quarterly reports to determine possible data inconsistencies and investigated any inconsistencies using SQL database tables and Qlik Sense dashboards• Expanded skillset by learning VBA and Power Query in Excel, and data manipulation techniques in R• Collaborated with team members to improve monthly data run process by reorganizing and updating SQL queries for improved efficiency• Converted multiple SQL queries and other monthly manual Excel processes to R codes• Built SQL queries to investigate issues in database tables and determine solutions• Utilized VBA and Power Query to extract data from SQL database into Excel, and produce a Microsoft Word report• Ran data for monthly data process, maintaining organized tracking and clear communication of process and updates