Data Analyst - Intern
CurrentData Analyst - Health Insurance – Chennai December 2023 - April 2024• Leveraged SQL queries to extract and manipulate health insurance claims data from relational databases foranalysis and reporting purposes.• Applied Statistical analysis is Python using libraries such as Pandas, Numpy and Matplotlib to identify trends,patterns and anomalies in health insurance data & eliminate duplicate entries from the database ofbusinesses 90% accuracy.• Fetch the data’s from Datawarehouse using Snowflake and connect into Power BI for generating reports.• Used Power BI drill through and slicer features to enable stakeholders to analyze health insurance data atdifferent levels of granularity.• In DAX function, analyzed the last period of growth of the company using by Time Intelligence Function, DateFunctions and Coming up with solutions to business problems using data-driven approaches.Data Analyst - Swiggy Restaurant – Chennai May 2023 – December 2023• Handled more than 1000 restaurants data across India.• Analyzed this data using MySQL database and performed ETL to remove outliers, clean up bad records,normalize revenue number to standard format using Python (Pandas) in Jupyter notebook along with otherstatistical techniques.• For more analyzing, used Excel, pivot tables, figured out best restaurants in India cuisine based on reviews.• Used Power BI to build various BI dashboards and reports to show the growth in different restaurants basedon the sales, profits and how customers preferences have changed over a period of 5 years.
