Summary
Overview
Work History
Education
Skills
Projects
Timeline
Hi, I’m

JAY PATEL

Data Analyst
visnagar,Gujarat
JAY PATEL

Summary

As a skilled data analyst with one and a half years of experience in gathering, analytics, and visualizing data, which providing insights and recommendations that drive business growth. My skill proficient in Excel, MySQL, PowerBI, and Python allows me to extract and manipulate data, and my excellent problem-solving and communication skills enable me to present complex information in a clear manner with team environment. Looking for a financial and business analysis role that can utilize my skills and knowledge to drive business.

In my study, I have used various data-related tools and technologies, including SQL, Excel, and PowerBI, to extract, clean, and transform data and create informative visualizations and reports. I have also worked closely with cross-functional teams to understand business objectives and provide data-driven insights that inform decision-making and drive business growth.

I hold a Master's Degree in applied data science and have completed many courses in data analysis, MySQL, PowerBI, and statistics. In addition, I am proficient in Python and R and have obtained several industry certifications, including a certification in Data Science from Coursera.

As a data analyst, I'm excited to take on a new challenge and use my skills and experience to help your organization.

Overview

3
years of professional experience

Work History

Apnahome Ltd
London, United Kingdom

Data Analyst
12.2021 - 01.2023

Job overview

  • As a Data Analyst from December 2021 to January 2023, I utilized my skills in MySQL, Excel, PowerBI, Data Analytics, and data visualization to support the data needs of the organization which saved many hours in a day of manual reporting work. My responsibilities included:

    · Ensuring regular data backups, exports, and imports
    · Tracking key data to gain valuable insights
    · Utilizing a BI dashboard to track product records and storage capacity
    · Analyzing and monitoring an online selling database portal to improve efficiency
    · Conducting statistical monitoring and analysis of trends
    · Generating daily start and end parameter reports
    · Tracking product supply chain inventory systems in the warehouse
    · Analyzing upcoming products, including average price, market area, and selling quantity.

Viiorr Pvt Ltd
visnagar, Gujarat

Website Developer
10.2019 - 01.2021

Job overview

  • Developed and maintained an invoice and inventory management system using the Laravel PHP framework
  • My responsibility is to create a database design for the system and manage all database tasks
  • • Supporting development, maintaining, and updating web portals as well as websites
    • Assisting in the deployment and development of websites
    • writing codes for web-based solutions
    • creating new web-based tools
    • resolving the complaints of customers and responding to their suggestions to improve the products
    • developing documentation for user manuals
    • technical documentation
    • selecting techniques and methods for creating solutions using different tools and programming
    languages

Education

University of Essex

Mater of Sciences from Applied Data Science

University Overview

Sankalchand Patel College of Engineering

Bachelor of Engineering from Computer Engineering

University Overview

Swami Sachchidanand Polytechnic College of Engineering

Diploma from Engineering [Computer Engineering

University Overview

Skills

  • PowerBI Dashboarding
  • Use Cases
  • Process Mapping
  • Defect Tracking
  • Data Quality Assurance Processes
  • SQL
  • Python
  • Data Science
  • Exploratory Data Analysis
  • R Markdown
  • Business Analytics
  • Statistics
  • Microsoft Excel
  • VBA Macro
  • Excel Automation
  • R (Programming Language)
  • KPIs Dashboarding
  • Data Warehousing
  • Microsoft SQL Server
  • Tableau

Projects

Projects

 

  • Telecom Providers Business Inside using PowerBI

Examine pre-5G and post-5G financial statements with KPIs results, user bases by area, and market valuations of several telecommunications businesses shown on the BI dashboard for easy tracking and evaluated critical data

User may explore data in more depth with Dax function, filters, macros, and slicers, and the dashboard is kept up to date with the most recent data through automated data refreshing and alerting systems

  • Business Inside Using MySQL with Python EDA

Using Matplotlib, KPIs were produced and cleaned up using Pandas, and NumPy with clear statistics in Python

Store procedures, common table expression, and dataset views to facilitate better data retrieval and analysis, and establish a daily data analytics report using database events, triggers, and indexes to guarantee data integrity and optimize tasks

  • Amazon Seller Excel Workbook with Macro

Sorting and filtering their product data using macros, calculating the weight and dimensions of each product, it is help to expedite the shipping process

It is working faster, and consolidating related data files into a single document for clearer analysis, which helps to read by many shipping companies.

Timeline

Data Analyst
Apnahome Ltd
12.2021 - 01.2023
Website Developer
Viiorr Pvt Ltd
10.2019 - 01.2021
University of Essex
Mater of Sciences from Applied Data Science
Sankalchand Patel College of Engineering
Bachelor of Engineering from Computer Engineering
Swami Sachchidanand Polytechnic College of Engineering
Diploma from Engineering [Computer Engineering
JAY PATELData Analyst