Krupa Patel

Experienced data analyst and data visualization specialist with a strong background in extracting valuable insights from complex datasets. Proficient in analyzing large volumes of data using Python, R, SQL, and Tableau to identify patterns, trends, and correlations. Skilled in data cleansing, transformation, and modeling techniques to ensure data accuracy. Effective communicator who can translate business requirements into actionable solutions and present findings through visually appealing dashboards and reports. Passionate about leveraging data-driven decision-making to drive business growth and optimize operations. Seeking opportunities to contribute expertise and make a meaningful impact

WebExecute InfoTech PVT. LTD.  | Data Analyst                                                                                 January 2020 – January 2021

• Conducted exploratory data analysis using Python pandas and NumPy packages on employee demographics to identify root causes of attrition rates and improve employee satisfaction.
• Visualized apparel sales data using Tableau, providing actionable insights that resulted in 20% efficiency enhancements.
• Analyzed user behavior on internal web applications by operating SQL queries, identifying opportunities for improvement and contributing to a 10% increase in monthly active users across all products.
• Developed and presented reports and dashboards to effectively communicate findings to stakeholders, utilizing Tableau and Excel for data organization.
• Generated and analyzed retention metrics using SQL, Python, or Tableau, producing reports and conducting analytics using modern data visualization tools.

Walmart Retails Analysis                                                                                                                                    April 2022 – June 2022                                                                                                             

• Developed, tested, and maintained Tableau functional reports to analyze business profits based on retail dataset, incorporating cross tabs, tooltips, box charts, geographic maps, bar charts, and bin charts.
• Enhanced dashboard views through advanced utilization of Tableau's features, including quick filters, parameters, and sets, improving user interactivity and enabling flexible control over variables for enhanced data analysis and actionable insights.
• Evaluated average profit per state and analyzed the age group of customers losing business using geographical maps and bar charts.

Statistical Analysis of Public Health Data                                                                                                                  March 2022 – June 2022

• Executed exploratory data analysis, handling missing values, visualized data using bar graphs, and line charts.
• Programmed python code for categorical data one-hot encoding and feature engineering for prediction models based on business question to evaluate performance.
• Built ensemble model using Linear Regression, Random Forest, Decision Tree and evaluated model performance.

Clinic Management System                                                                                                                                                 May 2018 – June 2018

• Developed, and executed data queries, presented information through reports, and visualized in tableau, designed data model solved 77%, patient record accessibility and appointment scheduling were both enhanced.

Pharma Medi                                                                                                                                                                     January 2017 – July 2017

• Implemented CodeIgniter PHP in a WAMP environment to enhance a new, reproducible software development technique, resulting in higher-quality product releases and a 27% reduction in errors.
• Managed relational database hosting using PhpMyAdmin and developed a website using the CodeIgniter framework. 
• Integrated a payment transfer gateway, significantly reducing data entry redundancy from the old website by up to 75%.