Data Analyst with 1+ years in ETL, Data Cleaning & Dashboard Development
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Data Analyst with experience in building ETL pipelines, data cleaning, automation, and dashboard reporting. Skilled in Python (Pandas, NumPy), SQL, Excel, and BI tools (Power BI, Tableau). Adept at KPI tracking, anomaly detection, and delivering data-driven insights to support business decision-making.
Punjabi University
Master of Computer Applications
August 1, 2022 – June 30, 2024
Arya College (Affiliated to P.U.)
Bachelor of Computer Applications
August 1, 2019 – June 30, 2022
Lovely Professional University
Data Analyst
November 1, 2025 – Present
Jalandhar, Punjab, India
Ernst & Young (EY)
Data Analyst
December 1, 2024 – February 28, 2025
Noida, Uttar Pradesh, India
Superstore Sales Dashboard
February 1, 2026 – February 28, 2026
Built an interactive dashboard to analyze sales, profit, and regional performance. Implemented drill-down features across categories and shipping modes. Automated data refresh using SQL integration for real-time insights. Designed KPI tracking and YoY trend analysis dashboards.
META Ads Performance Dashboard
November 1, 2025 – June 30, 2026
Developed an interactive Power BI dashboard to track Meta Ads performance (CTR, CPC, conversions, ROI). Performed ETL processes including data extraction, cleaning, and transformation using Python and SQL. Created DAX-based KPIs to evaluate campaign performance and marketing effectiveness. Identified underperforming campaigns and recommended optimization strategies. Analyzed audience data to uncover high-performing segments for targeted marketing. Delivered actionable insights through dynamic dashboards and visual reports.
Cultural Fit Analysis
The candidate's experience across two different organizations (EY and Lovely Professional University) and personal projects demonstrates adaptability and a breadth of exposure to different data analysis challenges. The use of various tools like Power BI, SQL, Python, and Alteryx suggests a willingness to learn and apply new technologies. The project diversity, from marketing performance to sales and university administration, indicates a broad interest in applying data analysis skills across different domains, which aligns well with roles requiring versatile data professionals.
Soft Skills & Operational Fit
The candidate's project descriptions and experience indicate a focus on delivering actionable insights and automating processes, suggesting a results-oriented approach. The ability to work with diverse datasets and tools implies adaptability. However, without specific behavioral assessment data, a deeper analysis of soft skills like teamwork, problem-solving under pressure, or communication style is not possible.