Back to Developers
Jigisha Patel

Jigisha Patel

Data Analyst

Pune, Maharashtra Remote Full-time 5+ yrs exp 95 ยท Outstanding

About

Data Analyst with 6 month of internship experience turning raw operational, time-series, CRM, and marketing data into decisions using SQL, Power BI, Python, and statistical analysis. Proven track record cutting reporting time by 30-50% through data-quality automation, KPI dashboard design, and DAX-driven modeling. Skilled at spotting trends, outliers, and data-quality issues that others miss, and translating them into insights business stakeholders act on.

Skills & Expertise (40)

MySql Advanced
8.0/10
5
Years Exp
KPI Dashboards Advanced
8.0/10
5
Years Exp
Data Modeling Advanced
8.0/10
5
Years Exp
Power Query Advanced
8.0/10
5
Years Exp
DAX Advanced
8.0/10
5
Years Exp
Power BI Advanced
8.0/10
5
Years Exp
Python Advanced
8.0/10
5
Years Exp
Pandas Advanced
8.0/10
5
Years Exp
NumPy Advanced
8.0/10
5
Years Exp
Matplotlib Advanced
8.0/10
5
Years Exp
Advanced Excel Advanced
8.0/10
5
Years Exp
Pivot Tables Advanced
8.0/10
5
Years Exp
XLOOKUP Advanced
8.0/10
5
Years Exp
MIS Reporting Advanced
8.0/10
5
Years Exp
Report Automation Advanced
8.0/10
5
Years Exp
Data Validation Advanced
8.0/10
5
Years Exp
Data Cleaning Advanced
8.0/10
5
Years Exp
Aggregations Advanced
8.0/10
5
Years Exp
Window Functions Advanced
8.0/10
5
Years Exp
Subqueries Advanced
8.0/10
5
Years Exp
CTEs Advanced
8.0/10
5
Years Exp
Joins Advanced
8.0/10
5
Years Exp
SQL Advanced
8.0/10
5
Years Exp
Python (Pandas, NumPy, SciPy) Performance Optimization SQL/No-SQL databases Drill-Down Analysis Interactive Reports Confidence Intervals Hypothesis Testing Trend Analysis Percentiles Outlier Detection Correlation Variance Distribution analysis Descriptive Statistics Time-Series Analysis EDA SQL Server

Work Experience

Data Analyst

Mitroz Technologies

Apr 2026 - Present

Engineered SQL queries using CTEs, window functions, joins, subqueries, and aggregations to prepare datasets and calculate operational KPIs. Diagnosed data-quality issues in large MySQL time-series datasets using Python, Pandas, and NumPy - resolving missing records, duplicates, timestamp inconsistencies, and abnormal values. Applied descriptive statistics, variance, percentiles, correlation, and outlier analysis to surface patterns and variations in operational data. Built Power BI dashboards using DAX, Power Query, & data modeling for KPI, trend, threshold, operational performance analysis. Streamlined reporting workflows, achieving ~30% faster report loading and ~50% less manual effort.

Digital Marketing & Growth Analyst

Fidicon

Aug 2020 - May 2025

Analyzed campaign performance, website traffic, lead acquisition, conversion rates, and channel-level KPIs to identify trends and performance variations. Used Excel and statistical analysis to compare campaign performance, conversion patterns, & acquisition metrics across channels. Built recurring reports and dashboards to track marketing funnels, campaign outcomes, and business KPIs.

Education

M.Sc. Information Technology - Uka Tarsadia University

- 2020 ยท Afghanistan

B.Sc. Information Technology - Uka Tarsadia University

- 2018 ยท Afghanistan

Certifications

Data Analytics

CJC at Pune ยท 2026

Complete data analytics training covering Exel,SQL,PowerBI,Data Visualization gaining knowledge of data cleaning, data analytics, report preparation, dashboard creation to support data driven decision-making.

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 15/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 5/5
โœ… Verified 5/5
Total Score 95/100

Profile Overview

Member sinceOct 2026
Work ModeRemote
AvailabilityFull-time

Availability Details

Visa Status

Citizen

Relocation

Depends on Offer