Gauri Mayekar

Results-oriented Data Analyst with experience in Data Analysis, Business Intelligence, and Dashboard Development. Skilled in SQL, Python, Power BI, Tableau, Advanced Excel, and Generative AI, with expertise in Data Visualization, KPI Reporting, and data-driven decision-making.

Data Analyst - ADA Tech. Solutions India Private Limited - Pune

(2025-03 - 2026-06)

• Managed counsellor data within the Kylas CRM platform by creating user profiles and importing bulk Excel datasets, ensuring high data accuracy.
• Developed an interactive Power BI Dashboard to track counsellor performance, admission-based incentives, and KPIs.
• Published dashboards using Power BI Service, enabling real-time reporting and improving business intelligence.
• Collaborated with cross-functional teams to deliver actionable business insights and support data-driven decision-making.
• Analyzed Superstore sales and profit data using Tableau to identify profit trends and generate business insights.
• Developed interactive Tableau dashboards with geographic maps, filters, and KPIs to visualize regional performance and top-performing categories.
• Delivered data-driven insights that supported strategic planning, resource allocation, and business decision-making.
• Analyzed 100K+ e-commerce orders using SQL and Advanced Excel, identifying sales trends, customer behavior, and a 52.13% increase in November sales.
• Applied SQL Joins, Subqueries, and CTEs to analyze large datasets and generate actionable business insights.
• Conducted EDA and developed Excel reports using Pivot Tables and Pivot Charts, delivering data-driven recommendations for inventory planning, marketing strategies, and business decision-making.

Data Analyst Intern - Borgward Technology India Private Limited - Pune

(2023-06 - 2024-02)

• Analyzed extensive student datasets, identifying behavioral trends that increased student engagement by 12% and supported data-driven decision-making.
• Developed a data cleaning and data validation process that improved dataset accuracy by 25%, ensuring high-quality and reliable data analysis.
• Created and maintained interactive Tableau dashboards and reports, delivering data visualization and business insights that enhanced strategic planning effectiveness by 20%.

Bachelor of Information Technology - Information Technology - University of Mumbai (2023)

Diploma - Data Science and Machine Learning - Borgward Technology India Private Limited (2024)

Self-paced Course - Data Science & Machine Learning - Scaler