Krati Gupta

Detail-oriented Data Analyst with hands-on experience in Python, SQL, Power BI, and Advanced Excel, gained through data analyst internships focused on data cleaning, data transformation, exploratory data analysis (EDA), and dashboard development. Skilled in writing SQL queries, building Power BI dashboards for KPI reporting and business intelligence, and automating reporting workflows using Python. Strong analytical and problem-solving skills with a track record of translating raw data into actionable business insights.

Seeking an entry-level Data Analyst role to apply data analysis and visualization expertise in a business intelligence environment.

Data Analyst Intern at Neftic Technologies (2026-01 – 2026-06)

• Cleaned, transformed, and validated datasets using Python (Pandas), SQL, and Advanced Excel to improve data quality and reliability for downstream reporting.
• Developed interactive Power BI dashboards to track business performance, sales, and KPI metrics for stakeholder reporting.
• Wrote SQL queries involving joins, aggregations, and filtering to extract and report data from relational databases.
• Performed Exploratory Data Analysis (EDA) to identify trends, customer behavior patterns, and operational insights.
• Automated repetitive reporting tasks using Python, reducing manual reporting time and improving turnaround.
• Collaborated with cross-functional teams to gather business requirements and translate them into actionable data insights.
• Created reports and visualizations that supported data-driven business decision-making.

Data Analyst Intern at Data Analyst Mastery & Internship Program (2025-07 – 2025-09)

• Cleaned, transformed, and optimized large-scale datasets (5,000+ rows) using Advanced Excel and Python, improving data accuracy and usability.
• Wrote and executed complex SQL queries in MySQL Workbench for data extraction, aggregation, and reporting.
• Designed and developed interactive Power BI dashboards for e-commerce sales analysis, enabling insights into revenue trends and product performance.
• Performed EDA to identify patterns, anomalies, and actionable business insights.

Python Development Intern at Shadowfox (2025-03 – 2025-04)

• Automated data processing workflows using Python scripts, reducing manual effort by ~25%.
• Debugged and optimized existing codebases in collaboration with team members.
• Gained practical exposure to scripting, logic building, and data handling.

Bachelor of Technology (B.Tech) in Computer Science & Engineering – University Institute of Technology, RGPV Shivpuri (2022 – 2026)

Senior Secondary Education – Govt. Excellence School No. 1 (2022)