Data analyst with over 2 years of experience in automating reporting workflows and creating KPI dashboards. Proficient in SQL and Power BI, leading to enhanced operational efficiency and informed decision-making in insurance and banking sectors. Additionally, possesses 4 years of experience in operational and insurance analytics.
o Analyzed underwriting claims and policy lifecycle data to generate actionable insights in the Canadian P&C insurance environment.
o Queried structured insurance data from Guidewire PolicyCenter and ClaimCenter using SQL to evaluate premium trends and operational KPIs.
o Built and maintained dashboards in Power BI, translating stakeholder requirements into measurable KPIs across teams.
o Automated reporting workflows using Python and R, reducing turnaround time by fifty percent and enhancing data reliability.
Automated recurring reports with SQL and cron jobs, enhancing reporting process and saving time for stakeholders.
Developed KPI dashboards and unified sales scorecards with SQL and Excel, providing a centralized reporting tool for informed decision-making.
Conducted data investigations and ad hoc analyses using SQL Server and Visual Studio, ensuring compliance with evolving bank policies.
o Analyzed large datasets to identify trends and insights for banking operations.
o Utilized Excel and SQL to manipulate data and generate actionable recommendations.
o Translated raw data into meaningful information using statistical techniques.
o Leveraged SQL queries to extract, transform and load data into databases.
o Produced monthly reports with advanced Excel spreadsheet functions. Enhanced efficiency by streamlining processes and implementing automation tools for routine tasks.
o Coordinated workflow scheduling, data entry, and accuracy verification for large data projects, ensuring timely delivery and high-quality outputs.
o Compiled and verified data accuracy prior to input; updated client correspondence files and database information to ensure comprehensive record-keeping.
o Completed data entry tasks with accuracy and efficiency.
o Corrected data entry errors to prevent duplication or data degradation.
Maintained data entry logs to track data entry activities.
o Organized, sorted, and checked input data against original documents.
o Managed documents by organizing forms, making photocopies, filing records, preparing correspondence, and creating reports.
o Sorted documents and maintained an organized filing process.
o Compiled and verified accuracy and sorting information to prepare source data for computer entry.