Summary
Overview
Work History
Education
Skills
Timeline
Generic
JAY PATEL

JAY PATEL

Data Analyst
London, United Kingdom

Summary

As a skilled data analyst with one year experience in gathering, analyzing, 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.

Overview

2
2
years of professional experience

Work History

Data Analyst

Apnahome Ltd
12.2021 - 01.2023
  • Utilized tools and technologies such as PowerBI, SQL, and Excel to manipulate, analyze, and visualize business KIPs results (monthly revenue, sales) which saved many hours in a day of manual reporting work
  • Conducted market research and analyzed product data to inform price and market values.

Website Developer

Viiorr Pvt Ltd
10.2019 - 01.2021
  • 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
  • IoT Development Internship Worked on Internet of Things, Computer Vision, and Cloud Computing technologies
  • We solve a problem using advanced sensing technologies to automate waste management processes, improving efficiency, and reducing manual labor
  • PROJECT
  • 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 in Python
  • Store procedures, common table expression, and dataset views to facilitate better data retrieval and analysis, and establish a daily 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.

Education

Mater of Sciences - Applied Data Science

University of Essex
Dec 2022

Bachelor of Engineering - Computer Engineering

Sankalchand Patel College of Engineering
May 2019

Diploma - Engineering [Computer Engineering

Swami Sachchidanand Polytechnic College of Engineering
May 2016

Skills

  • PowerBI Dashboarding
  • Microsoft Power BI
  • MySQL
  • Python Programming
  • Exploratory Data Analysis
  • R Markdown
  • Business Analytics
  • Microsoft Excel VBA Macro
  • Excel Automation
  • KPIs Dashboarding
  • Data Warehousing
  • Microsoft SQL Server
  • Write Reports
  • Database Management

Timeline

Data Analyst

Apnahome Ltd
12.2021 - 01.2023

Website Developer

Viiorr Pvt Ltd
10.2019 - 01.2021

Mater of Sciences - Applied Data Science

University of Essex

Bachelor of Engineering - Computer Engineering

Sankalchand Patel College of Engineering

Diploma - Engineering [Computer Engineering

Swami Sachchidanand Polytechnic College of Engineering

Similar Profiles

CREATE PROFILE
JAY PATELData Analyst