Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic

Jenish Bhanawat

Data Analyst
Bengaluru

Summary

Dedicated graduate skilled in business analysis, data analysis, visualization, and problem-solving, driving informed decisions and business success.

Overview

4
4
years of post-secondary education
4
4
Certifications

Work History

Quantitative Analyst

Home.LLC
04.2024 - Current
  • Spearheaded the migration of business intelligence dashboards and datasets from Mode BI Tool to AWS QuickSight for a key client, ensuring a seamless transition and maintaining data integrity.
  • Dataset Creation: Developed complex SQL queries to recreate datasets in AWS QuickSight, including transforming parameters from Mode into static fields and dimensions for use as filters in QuickSight dashboards.
  • SQL Optimization: Analyzed and refactored intricate SQL queries, including those with lengthy Common Table Expressions (CTEs), to meet QuickSight’s query structure requirements.
  • Dashboard Development: Designed and implemented dashboards in AWS QuickSight that mirror the functionality and appearance of existing Mode dashboards, ensuring consistency in data visualization and user experience.
  • Data Validation: Conducted rigorous testing to ensure that data and visualizations in QuickSight accurately reflected those in Mode, achieving a high level of precision and reliability.

Education

B.Tech - Computer Science

Jaypee Institute of Information Technology
Noida
08.2019 - 05.2023

Skills

SQL- Commands, data types, Constraints and Joins

Tableau - Basic Charts and formatting, Filters, Calculations, Custom Charts, Dashboards

AWS Quicksight - Basic Charts and formatting, Filters, Calculations, Custom Charts, Dashboards

Python - Variables, Data types, Data structures, Loops, functions

R language - Data types, Data structures, Loops, Dplyr packages, Visualizations

Advance Excel - Logical Functions, Text functions, VLOOKUP, Data handling, Data visualization

Agile Methodology

Strong Problem Solving & communication skills

Microsoft Office: PowerPoint & Word

Certification

Data Analytics/Business Analytics by ExcelR

Projects

Data Analyst with Proficiency in Tableau, SQL, Power BI, and MS Excel

Experienced Data Analyst skilled in translating complex datasets into actionable insights. Notable projects include:

My portfolio, including project links, provides a concise showcase of my skills and their impact. 

https://drive.google.com/drive/folders/12d2ZVHkXs8qqANsfcuKqsizDfQA0EFV8?usp=sharing

Timeline

Quantitative Analyst

Home.LLC
04.2024 - Current

Data Analytics/Business Analytics by ExcelR

10-2023

Business Analysis Fundamentals - ECBA, CCBA, CBAP endorsed by Udemy

09-2023

Google Data Analytics by Coursera

04-2023

Data Analytics on Cricket by Mad About Sports

09-2022

B.Tech - Computer Science

Jaypee Institute of Information Technology
08.2019 - 05.2023
Jenish BhanawatData Analyst