Data Analyst with 2+ years in SQL, Power BI & Excel with 5 Years Background in E Commerce & Marketplace Analytics
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 2+ years of hands-on experience using SQL, Excel, and Power BI to convert raw data into actionable insights that improve growth, retention, and operational efficiency, backed by 5 years of experience across e-commerce marketplaces, B2B operations, and sales analytics, with a proven track record of delivering measurable business impact through customer analysis, KPI reporting, process optimisation, and data-driven decision-making in high-volume commercial environments.
Chhatrapati Shahu Ji Maharaj University, Kanpur
Bachelor of Arts · English Language, Philosophy & Sociology
August 1, 2018 – June 30, 2021
Era Sky Technologies Pvt. Ltd.
Team Leader – Data & Backend Operations
March 1, 2025 – Present
Kanpur, Uttar Pradesh, India
Era Sky Technologies Pvt. Ltd.
Data & Sales Operations Analyst
April 1, 2023 – February 1, 2025
Kanpur, Uttar Pradesh, India
JDK Services Pvt. Ltd.
E-Commerce Operations & Marketplace Analyst
April 1, 2021 – March 1, 2023
Kanpur, Uttar Pradesh, India
Customer Retention & Churn Risk Analysis
June 16, 2026 – Present
Business Problem: A global e-commerce platform was facing declining customer retention & rising churn, which was threatening long-term revenue growth. The objective was to identify key churn drivers and high-risk customer segments. Key Insights: Overall customer churn at 28.9% (nearly 1 in 3 customers). The active customer base has almost completely exhausted the LTV. The 18–24 age segment carried the highest risk of churn. Highly engaged customers churn at half the rate of the low engagement customers. Return rate and Customer support calls are 2 major friction factors contributing to churn. Customer acquisition had declined to 1/3 over the last two years. Outcome & Recommendations: Recommended an urgent targeted customer acquisition campaign for 25-45 age segment, re-engagement campaign for the 18–24 segment with personalisation and reward systems; proposed upsell strategies to shift low-spend customers (50% of revenue base) to medium-spend; flagged declining acquisition as a critical business risk requiring immediate attention.
View ProjectE-Commerce Sales Performance Analysis
June 16, 2026 – Present
Business Problem: An e-commerce business needed a comprehensive view of its sales performance to identify revenue drivers, understand customer value distribution, and quantify operational risk specifically around returns and portfolio fragmentation. Key Insights: Over-dependence on repeat customers contributing to 75% of the total revenue. The top 10 products contributed just 17% of revenue, indicating severe long-tail fragmentation. Returns eroded 8-9% of revenue, with two SKUs exceeding 50% return rates. Low-spend customers (under ₹5K) constitute 94% of customer base. Outcome & Recommendations: Recommended aggressive new customer acquisition strategy; seasonal marketing campaigns for Oct–Nov peak demand; targeted discount bundling for low-spend customers to migrate them to the medium-spend segment; and priority investigation of high-return SKUs.
View ProjectGoogle Data Analytics Professional Certificate (v2)
Google / Coursera
August 1, 2025 – Present
Basic to Advanced SQL
Skill Nation
February 1, 2025 – Present
Basic to Advanced Microsoft Excel
Skill Nation
November 1, 2024 – Present
Basic to Advanced Power BI
Skill Nation
May 1, 2024 – Present
Cultural Fit Analysis
The candidate's project diversity, focusing on customer retention, churn analysis, and sales performance, aligns well with a data-driven culture. Their experience in both B2B operations and e-commerce marketplaces shows adaptability to different business contexts. The breadth of skills (SQL, Excel, Power BI, Analytics) indicates a willingness to learn and apply various tools. However, the academic background in Arts rather than a quantitative field, while not a direct impediment, might suggest a non-traditional path into data analysis, which could be a cultural fit consideration depending on the team's background. The psychometric test score is below average, which could indicate potential challenges in cultural alignment related to work attitude or team collaboration.
Soft Skills & Operational Fit
The candidate demonstrates strong problem-solving skills, particularly in identifying and resolving data quality issues and optimizing operational workflows. Their experience in leading data operations and collaborating with developers for CRM architecture indicates good organizational and teamwork capabilities. The ability to translate complex data into clear business recommendations suggests effective communication and strategic thinking. The psychometric test score (282/500) suggests potential areas for development in logical reasoning, work attitude, stress handling, or team collaboration, which would require further investigation.