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
Similar Profiles
Ayushi SharmaAyushi Sharma
Emerging Architect at Shell India Markets Pvt LtdEmerging Architect at Shell India Markets Pvt Ltd
BHANU SHARMABHANU SHARMA
Senior Software Engineer at Q2 SoftwareSenior Software Engineer at Q2 Software
Ritu A. MullurRitu A. Mullur
Project Coordinator (PMO) at Persistent SystemsProject Coordinator (PMO) at Persistent Systems
Mehzabein SayyadMehzabein Sayyad
Senior Executive at Sobha LimitedSenior Executive at Sobha Limited
Mallela Dasari ChakradharMallela Dasari Chakradhar
Quantitative Analyst at Dolat CapitalQuantitative Analyst at Dolat Capital