Harsh Rana

Harsh Rana

Data Analyst
India
Gujarati, Hindi, English

About Me

Results-driven Data Analyst with 2+ years of hands-on experience in SQL, Power BI, Python, and ETL processes. Skilled in transforming complex datasets into meaningful insights that support business growth and operational…

Experience

Data Analyst

Rimble, Inc · California, USA
Jan 2025 - Dec 2025 · 11 months

Spearheaded 5,000+ records in internal databases with 99% accuracy, ensuring reliable data for reporting. Cleaned and validated large datasets, identifying duplicates and missing values to improve data quality by 40%. Architected Excel and Power BI to analyze patterns and trends, streamlining workflows and enhancing decision-making.

Associate Data Analyst

TechGynt Infotech Private Limited · Vadodara, India
Jul 2023 - Dec 2023 · 5 months

Designed dashboards for sales monitoring, saving 3+ hours weekly in reporting and boosting efficiency. Optimized datasets with SQL and Excel, generating 5+ reports that increased operational efficiency by 15%. Automated data validation and cleansing, reducing discrepancies by 30% and speeding up analysis by 15%.

Associate Data Analyst

TechGynt Infotech Private Limited, Mehemdabad, Gujarat

Created a documentation system that streamlined data engineering and improved team training for 5 members.
Analyzed complex datasets using SQL and Excel, delivering 5+ detailed reports that improved cross-functional decision making by 20%.
Automated data processes to improve efficiency, leading to better real-time BI analytics performance.
Implemented data validation and cleansing, reducing discrepancies by 30% and improving decision-making speed by 15%.

PROJECTS

Amazon Sales Report Analysis

Duration : 31-Dec-2024 - 30-Jan-2025

Provided insights on customer segmentation and sales, leading to a 12% improvement in targeted marketing. Established data transformation framework with Power Query, improving data quality and boosting accuracy by 15%.

HR Performance and Employee Retention Dashboard

Duration : 30-Nov-2024 - 30-Dec-2024

Created dashboards with KPI tracking, identifying factors like work-life balance, and boosting job satisfaction by 20%. Applied data modeling to refine HR decisions across 7+ departments, resulting in a 25% reduction in turnover rates.

Banking Performance Dashboard with Figma and Power BI

TechGynt Infotech Private Limited · https://hrdare.my.canva.site/harsh-portfolio
Duration : 31-Jul-2024 - 16-Dec-2024

Designed a customizable dashboard to track 8 key performance indicators, elevating stakeholder engagement by 50%. Converted Figma prototypes into Power BI dashboards, processing 10K+ data points for customer support.

Certifications

Data Analysis and Visualization with Power BI

Microsoft Learning and Coursera · Hyderabad, India · 2025

Python Core and Advance

Durga Software Solution Hyderabad · Hyderabad, India · 2024

SQL Server

Durga Software Solution Hyderabad · Hyderabad, India · 2024

Skills

Data Analysis Professional Information Systems Management Data Mining Microsoft Excel Python Structured Query Language (SQL) Problem Solving Data Analysis Communication Dashboards MSSQL Data Visualization Data Analysis Skills Power BI Tableau Data Analysis and Reporting Data Analytics SQL Server Integration Services (SSIS) ETL Tools Figma Business Intelligence Tools Data Cleaning Reporting Data Validation Data Cleansing Data Extraction Data Integration Effective communication Strategic Thinking Cross-Functional Collaboration Survey Data Analysis KPI Tracking Competitor Benchmarking MS Word Artificial intelligence
Report this Profile?