Aditya Sharma
Data And Reporting Analyst
Beverly Hills,NSW
Summary
Detail-oriented Data and Reporting Analyst with a strong insurance industry background at Crawford & Company, starting as a Junior Data Analyst for CRD and Contractor Connection and advancing to Data and Reporting Analyst in the Third-Party Administration (TPA) division after delivering projects on time and earning a recommendation from the Head of CRD and CC. With a Master’s in Data Science and expertise in Tableau and MS SQL, I specialize in transforming complex data into actionable insights to drive operational efficiency, claims management, and strategic decision-making, eager to bring my analytical skills to your organization.
Overview
2
2
years of professional experience
7
7
years of post-secondary education
1
1
Language
Work History
DATA AND REPORTING ANALYST (Third Party Administration)
Crawford and Company
01.2024 - Current
- Company Overview: Crawford & Company is the world’s largest publicly listed claims management business, established in 1941
- With over 10,000 employees across 70 countries, the company specializes in loss adjusting, catastrophe response, third-party administration, and more
- Automated reporting processes by combining SQL tables and daily data extracts, saving leadership 5 hours/week in manual work
- Identified unpaid invoice amounts by analyzing financial data, collaborating with the reconciliation team to resolve discrepancies and ensure accurate billing, which resulted in reducing bad debt and improving financial accuracy for various clients
- Developed and maintained 35+ dashboards (SQL, Tableau, Excel) to track and visualize claim data, improving operational efficiency and enabling better decision-making across APAC teams
- Provided actionable insights for key account management, contributing to a 10% revenue increase by re-assessing portfolio renewals and improving forecasting
- Optimized SQL queries and procedures, ensuring accurate property claims data, enhancing reporting integrity for more informed decision-making
- Created detailed financial reports using Excel and Tableau, analyzing indemnity, expense, and excess payments for different claim types, providing strategic insights to management
- Created detailed financial reports using Excel, including IF-ELSE functions, Lookups, Pivots, Graphs, and Slicers to analyze indemnity, expense, and excess payments for different claim types, providing strategic insights to management
- Prepared Bordereaux for 36+ Lloyd’s clients, ensuring compliance with regulations and timely report delivery, enhancing client satisfaction
- Administered server/database management for comprehensive risk analysis, maintaining data integrity for accurate decision-making
- Crawford & Company is the world’s largest publicly listed claims management business, established in 1941
- With over 10,000 employees across 70 countries, the company specializes in loss adjusting, catastrophe response, third-party administration, and more
JUNIOR DATA ANALYST INTERN (Data and Analytics)
ITIC Systems
02.2023 - 07.2023
- Company Overview: ITIC Systems is a leading provider of innovative technology solutions based in Sydney, specializing in IT infrastructure, system integration, and managed services
- The company supports businesses across various industries with tailored solutions to enhance efficiency and drive digital transformation
- Collected, processed, and structured diverse datasets from over five sources, demonstrating strong data handling and integration skills
- Achieved a model accuracy of 79% after 30 epochs of training by effectively tuning hyperparameters, showcasing strong analytical and machine learning capabilities
- Contributed to the development of an in-house solution by researching data analysis tools and best practices, improving efficiency and user-friendliness to meet organizational needs
- Led weekly and monthly team assessments, providing actionable insights through thorough documentation and feedback to drive team performance improvements
- Utilized Python Seaborn and Matplotlib libraries to create insightful visualizations of reporting data, enabling data-driven decision-making and enhancing team understanding of key metrics
- ITIC Systems is a leading provider of innovative technology solutions based in Sydney, specializing in IT infrastructure, system integration, and managed services
- The company supports businesses across various industries with tailored solutions to enhance efficiency and drive digital transformation
Education
Master of Data Science - Specialization in Data Analytics and Project Management
Macquarie University
North Ryde, NSW 02.2021 - 07.2023
Bachelor of Science and Technology - undefined
GGSIPU University
02.2016 - 06.2020
Skills
SQL Data Analysis
Python Programming
VBA Automation
Database Structure Design
Database Oversight
Expert Microsoft Excel
Data-Driven Decision Making
Tableau Data Analysis
CRM Software Proficiency
Data Presentation
Comprehensive Stakeholder Reports
Bordereaux Management
Performance Metrics Evaluation
Analytical Problem Solving
Efficient Reporting Practices
Timeline
DATA AND REPORTING ANALYST (Third Party Administration)
Crawford and Company
01.2024 - Current
JUNIOR DATA ANALYST INTERN (Data and Analytics)
ITIC Systems
02.2023 - 07.2023
Master of Data Science - Specialization in Data Analytics and Project Management
Macquarie University
02.2021 - 07.2023
Bachelor of Science and Technology - undefined
GGSIPU University
02.2016 - 06.2020