Jay Panchal profile photo 1 on Tal

Jay Panchal

Advanced Excel | Power BI | Data Analysis

Mumbai

2+ years of work experience

Kotak Life Insurance PVT Ltd
Dec 20255 mosApr 2026

Mumbai, Maharashtra, India

Working with group pricing models, data analysis, and actuarial evaluation in life insurance.
Adani Airport Holdings Ltd
Nov 20247 mosMay 2025

Mumbai, Maharashtra, India

Reduced‌ Manual Effort by 40% ‌ by‌ automating data workflows and optimizing resource allocation ‌ and ‌ task time from‌ 2h ‌ to almost‌ 0.5h [75% Improved].‌ Streamlined‌ reporting by integrating ‌ SAP‌ data into ‌ Power BI‌ via ‌ Excel automation‌ , significantly reducing manual effort and lowering the margin of ‌ Human Error‌ , resulting in a ‌ 50% ‌ improvement in data accuracy.‌ Applied ‌ structured data management practices using ‌ Formulae‌ , ‌ Power Query‌ , and ‌ Pivot Tables‌ in Excel and Power BI; standardised reporting formats led to significantly enhanced data accuracy across the system.‌ Developed and maintained ‌ 6‌ interactive ‌ UI/UX‌ Dashboards—‌ 3‌ based on ‌ Live Data ‌ using ‌ SAP‌ and 3 on manual data inputs—which provided end-to-end visibility across ‌ Capex/Opex‌ projects at the airport.‌ Created ‌ Executive-level‌ dashboards based on manual data for ‌ COO‌ to monitor ‌ Capex projects‌ , enabling strategic oversight and faster decision-making.‌
Mumbai International Airport Limited (CSMIA)
Aug 20242 mosSep 2024

Mumbai, Maharashtra, India

Jubilant Generics Limited
Nov 20234 mosFeb 2024

Mumbai, Maharashtra, India

Developed an UI/UX based Executive Sales Tracking Dashboard for tracking over 100+ pharmaceutical products targeting all over India accelerating performance analysis. Executed Data Cleaning in Excel and Structuring using Transform Data in Power BI reducing manual data work by 30%. Implemented different Visualizations and KPI’s enabling teams to access targeted insights focusing on Primary and Secondary sales at Headquarter, Regional and Zonal level for analyzing Targets, Milestones and Variances for all. Leveraged Drill-through functionality for precise data extraction, which reduced manual reporting from excel by 50% and accelerated decision-making.
Cosmos Committee
Jul 20221 yr 1 moJul 2023

I’m responsible for conducting academic event, workshops with academic experts.

Education

HSNC University, Mumbai

Bachelor of Science, Data Science

HSNC University, Mumbai

20223 yrs2025
KC College

Higher Education, Data science

KC College

20202 yrs2022

Join Jay and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Jay Panchal on Tal

Headline

Advanced Excel | Power BI | Data Analysis

About

Data Science Professional with experience in Business Analysis,Dashboard development, data structuring and analysis. Proven experience across diverse industries to transform complex data into visually appealing and actionable insights that support strategic decision-making. I excel in collaborative environments and am passionate about delivering practical, result oriented solutions to real-world challenges.

Location

Mumbai

Work experience

Actuarial Analyst at Kotak Life Insurance PVT Ltd, Dec 2025 - Apr 2026 · 5 mos, Mumbai, Maharashtra, India, Working with group pricing models, data analysis, and actuarial evaluation in life insurance.

Data Analyst at Adani Airport Holdings Ltd, Nov 2024 - May 2025 · 7 mos, Mumbai, Maharashtra, India, Reduced‌ Manual Effort by 40% ‌ by‌ automating data workflows and optimizing resource allocation ‌ and ‌ task time from‌ 2h ‌ to almost‌ 0.5h [75% Improved].‌ Streamlined‌ reporting by integrating ‌ SAP‌ data into ‌ Power BI‌ via ‌ Excel automation‌ , significantly reducing manual effort and lowering the margin of ‌ Human Error‌ , resulting in a ‌ 50% ‌ improvement in data accuracy.‌ Applied ‌ structured data management practices using ‌ Formulae‌ , ‌ Power Query‌ , and ‌ Pivot Tables‌ in Excel and Power BI; standardised reporting formats led to significantly enhanced data accuracy across the system.‌ Developed and maintained ‌ 6‌ interactive ‌ UI/UX‌ Dashboards—‌ 3‌ based on ‌ Live Data ‌ using ‌ SAP‌ and 3 on manual data inputs—which provided end-to-end visibility across ‌ Capex/Opex‌ projects at the airport.‌ Created ‌ Executive-level‌ dashboards based on manual data for ‌ COO‌ to monitor ‌ Capex projects‌ , enabling strategic oversight and faster decision-making.‌

Data Analyst at Mumbai International Airport Limited (CSMIA), Aug 2024 - Sep 2024 · 2 mos, Mumbai, Maharashtra, India

Power BI Developer at Jubilant Generics Limited, Nov 2023 - Feb 2024 · 4 mos, Mumbai, Maharashtra, India, Developed an UI/UX based Executive Sales Tracking Dashboard for tracking over 100+ pharmaceutical products targeting all over India accelerating performance analysis. Executed Data Cleaning in Excel and Structuring using Transform Data in Power BI reducing manual data work by 30%. Implemented different Visualizations and KPI’s enabling teams to access targeted insights focusing on Primary and Secondary sales at Headquarter, Regional and Zonal level for analyzing Targets, Milestones and Variances for all. Leveraged Drill-through functionality for precise data extraction, which reduced manual reporting from excel by 50% and accelerated decision-making.

Logistics Specialist at Cosmos Committee, Jul 2022 - Jul 2023 · 1 yr 1 mo, I’m responsible for conducting academic event, workshops with academic experts.

Education

Bachelor of Science, Data Science, HSNC University, Mumbai

Higher Education, Data science, KC College