Ajay

Data Analyst

West Sagarpur, New Delhi, Delhi 110046 2+ yrs exp 86 · Excellent

About

Data Analyst with 1+ year of experience in Advanced SQL (PostgreSQL), Power BI, and Python automation. Reduced reporting processing time by 97% and automated workflows saving 20+ hours weekly. Skilled in window functions (LEAD, LAG, RANK, DENSE_RANK, ROW_NUMBER), CTEs, KPI dashboard development, LLM-based data pipelines, and cohort analysis that drive customer retention and operational efficiency.

Skills & Expertise (25)

Advanced SQL Intermediate

7.5/10

Years Exp

Microsoft Power BI Intermediate

7.5/10

Years Exp

Python Intermediate

7.0/10

Years Exp

Pandas Intermediate

7.0/10

Years Exp

Excel Intermediate

7.0/10

Years Exp

Postgresql Intermediate

6.5/10

Years Exp

Google Sheets Intermediate

6.5/10

Years Exp

NumPy Intermediate

6.5/10

Years Exp

ETL Pipelines Intermediate

6.5/10

Years Exp

Google Analytics Intermediate

6.5/10

Years Exp

DAX Intermediate

6.0/10

Years Exp

Data Cleaning Intermediate

6.0/10

Years Exp

Seaborn Intermediate

6.0/10

Years Exp

CTEs Intermediate

6.0/10

Years Exp

Window Functions Intermediate

6.0/10

Years Exp

Cohort Analysis Intermediate

5.5/10

Years Exp

Salesforce CRM Intermediate

5.5/10

Years Exp

KPI Reporting Intermediate

5.5/10

Years Exp

Customer Retention Analysis Intermediate

5.5/10

Years Exp

Funnel Optimization Intermediate

5.0/10

Years Exp

Google Looker Studio Intermediate

5.0/10

Years Exp

BigQuery Intermediate

5.0/10

Years Exp

Zoho Analytics Intermediate

5.0/10

Years Exp

Workflow Automation Intermediate

5.0/10

Years Exp

Data Segmentation Intermediate

5.0/10

Years Exp

Work Experience

Data Analyst

Legistify

Jan 2025 - May 2026

Automated monthly and quarterly reporting workflows using Advanced SQL and Power BI, reducing processing time from 3 days to 2 hours and saving 20+ hours weekly. Developed LLM-based internal data scraper to streamline structured data extraction and eliminate manual collection processes. Designed client engagement segmentation model (Good, Critical, Low), enabling proactive retention strategies by Key Account Managers. Analyzed client login activity via Google Sheets to classify account health, providing actionable insights that helped decrease churn through data-driven engagement. Analysed user session continuity via Google Analytics event data, identifying UX friction points that led to feature improvements preventing user progress loss. Cleaned and structured 15,000+ user records for a 10-year flagship event using ROW_NUMBER for deduplication, categorising leads by priority and tracking conversion metrics. Developed automated email engagement tracking system generating structured summary reports and interaction metrics, improving visibility into outreach campaigns and enabling data-driven follow-up prioritisation.

Customer Care Executive – Specialized in Data and Reporting

CNX (Convergys)

Feb 2022 - Aug 2023

Managed high-volume chat and ticket operations using Salesforce CRM, maintaining 95% SLA adherence. Maintained daily operational performance reports tracking productivity, accuracy, and resolution metrics. Analysed recurring support patterns and provided process improvement feedback, reducing post-migration support tickets by 30%. Documented detailed case histories for AWS-based ticketing systems to support quality audits and compliance tracking.