Chirag Seervi
Portfolio

Data Analyst skilled in SQL, Python, Excel, Power BI, Tableau
@Chirag Seervi.

Experience

Freelance Data Analyst

Various Clients Remote Dec 2023 - May 2024

• Worked with the clients data for a call center and created multiple dashboards for trends analysis in Power BI.
• Developed complex DAX calculations that improved churn prediction accuracy by 17%, leading to targeted retention strategies and significantly enhancing customer engagement metrics.
• Conducted in-depth sales analysis on various marketing datasets in MS Excel, identifying key trends that led to a 15% increase in conversion rates; developed a comprehensive dashboard that visualizes these insights for stakeholders.
• Created macros for VBA and automating hectic task of sorting and searching the desired values saving 10 hours per week of manual reporting work.

Data Associate

@ Salesken|Bangalore October 2022 - October 2023

• Discovered crucial correlations which helped optimizing hyper-parameters for key summarization model eventually resulting in improvising ML models performance from 91% to 95%.
• Created dynamic dashboards using Tableau which summarizes and visualizes NLP models performance.
• Extracting, pre-processing and managing the datasets using SQL Queries for 5-6 NLP models and finding the best one.
• Worked in a multi team environment creating 6 hyper parameters for the future use cases, finding data inconsistencies utilizing python and Excel enhancing model accuracy by 4% for future assess-ments.

Projects

Sales Analysis

Analyzed sales data to address real-world sales challenges, achieving a 12% increase in data accuracy through cleaning and augmentation, and providing actionable insights to answer key business questions using Python.

Stock Price Prediction

Using the tensorflow libraries and its functions have implemented a Deep learning model to predict the price of Google stock with 95% accuracy using Python’s Tensorflow module.

HR Analytics Dashboard

Created an aesthetically pleasing HR Analytics dashboard in Power BI using company data, incorporating both dark and light modes to enhance visual appeal, resulting in a 18% increase in user engagement and a 15% improvement in data accessibility.

SQL Project

Utilized SQL to analyze Apple App Store data, answering real-life questions such as identifying the top 10 best apps on various parameters and determining user engagement trends, leading to a 8% increase in data-driven decision-making efficiency.

Calorie Tracker App

Developed a calorie tracker app using Python and the Google Gemini Pro Vision model, allowing users to upload images and receive calorie and nutritional information for over 100 food items. The app's front end was built with Streamlit, ensuring a user-friendly interface and seamless interaction.

Data Professionals Survey

Utilized data from a Data Professionals survey to create an engaging Power BI dashboard, analyzing key aspects such as average salary of 50900K, job satisfaction ratings of 5.74/10, and trends in employment across various roles.