Data Analyst with 1+ years in SQL, Python & Power BI
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Performance-driven Data Analyst with 1+ years of experience delivering actionable business intelligence. Expert in SQL, Python, and Power BI, automating data workflows to improve operational efficiency by 20%. Specialized in ETL processes and advanced DAX to provide real-time KPI tracking and high-impact storytelling for stakeholders.
Ajay Kumar Garg Engineering College
B.Tech · Information Technology
August 1, 2020 – June 30, 2024
Vijatshi Software Pvt Ltd
Data Analyst
December 1, 2024 – March 1, 2026
Noida, Uttar Pradesh, India
Sales Performance & Revenue Analytics Dashboard
December 1, 2025 – January 1, 2026
• Architected ETL pipelines and sales dashboards to track conversions, reducing revenue leakage by 12%. • Implemented funnel and KPI visualizations to evaluate conversion efficiency and identify specific revenue leaks. • Enabled real-time visibility into sales performance and revenue realization to accelerate data-driven decision-making.
Insurance Performance & Renewal Analytics
October 1, 2025 – November 1, 2025
• Developed interactive SQL and Pandas dashboards for real-time sales tracking and automated data transformation. • Engineered DAX-driven renewal tracking that identified 1.8 Cr+ in lapsed premiums, increasing lead conversion. • Visualized YoY premium growth and financial trends to facilitate executive-level strategic planning and forecasting.
Car Rental Operations & Revenue Tracker
June 1, 2025 – September 1, 2025
• Built fleet utilization trackers to optimize resource allocation, improving asset uptime by 15%. • Applied Advanced DAX to detect churn risks, providing managers with 98% accurate predictive insights. • Analyzed asset profitability to identify underperforming units, saving 5L+ in annual maintenance costs.
Website Engagement & Content Dashboard
April 1, 2025 – May 1, 2025
• Designed a web traffic dashboard using SQL Direct Query to monitor user activity and document downloads in real time. • Configured systematized data refreshes in Power BI Service, ensuring 100% up-to-date and accurate reporting for stakeholders. • Delivered engagement insights that helped the content team prioritize high-traffic categories and drive content optimization.
Academic Performance & Attendance Dashboard
February 1, 2025 – March 1, 2025
• Spearheaded interactive dashboards using Web Connectors to monitor student performance and batch attendance trends. • Integrated real-time data from web sources via DAX and KPIs, enabling educators to track dynamic academic patterns. • Computerized data refresh cycles to provide up-to-date insights, supporting data-driven decision making for batch planning.
Cultural Fit Analysis
The candidate's projects cover diverse domains such as sales, insurance, car rental, website engagement, and academic performance, indicating adaptability and a broad interest in applying data analysis across various business contexts. The single professional experience as a Data Analyst aligns directly with the target role. The academic projects, while extensive, are all recent and overlap significantly with the professional experience, suggesting a focused career path. The breadth of tools (Tableau, Power BI, Jupyter, Databricks) and methodologies (Data Storytelling, KPI Reporting, Automation) points to a versatile individual who could integrate well into data-driven teams. However, the lack of non-academic or open-source contributions limits the assessment of broader cultural engagement.
Soft Skills & Operational Fit
The candidate's project descriptions highlight a results-oriented approach, focusing on quantifiable improvements (e.g., 'reducing revenue leakage by 12%', 'improving asset uptime by 15%'). This indicates a strong operational fit for roles requiring impact-driven analysis. The emphasis on 'real-time visibility' and 'data-driven decision-making' suggests a proactive and business-centric mindset. However, without specific assessment scores for communication or psychometric tests, a deeper evaluation of soft skills like teamwork, stress handling, or direct communication clarity is not possible.