Atul Prajapati

Operational Analyst

New Delhi, India 2+ yrs exp 85 · Excellent

About

Business Analytics professional with 2+ years of experience in data analysis, KPI tracking, and generating insights that drive client retention and operational performance. Skilled in SQL, Python, Power BI, and Excel with strong expertise in descriptive analytics, statistical analysis, and data storytelling. Proven ability to identify retention opportunities through analytical approaches, influence senior stakeholders, automate reporting pipelines, and deliver actionable recommendations that enable data-driven decisions. Experienced in cross-functional collaboration and solving data quality issues proactively.

Skills & Expertise (54)

Advanced Excel Advanced

8.0/10

Years Exp

Pivot Tables Advanced

8.0/10

Years Exp

VLOOKUP Advanced

8.0/10

Years Exp

Power BI Advanced

8.0/10

Years Exp

DAX Advanced

8.0/10

Years Exp

MySql Advanced

7.6/10

Years Exp

Window Functions Intermediate

7.5/10

Years Exp

Data Modeling Intermediate

7.5/10

Years Exp

Power Query Intermediate

7.5/10

Years Exp

SQL Intermediate

7.5/10

Years Exp

Joins Intermediate

7.5/10

Years Exp

CTEs Intermediate

7.5/10

Years Exp

Pandas Intermediate

7.5/10

Years Exp

Python Intermediate

7.5/10

Years Exp

RPA Intermediate

7.5/10

Years Exp

Data Storytelling Intermediate

7.0/10

Years Exp

Cohort Analysis Intermediate

7.0/10

Years Exp

Trend Analysis Intermediate

7.0/10

Years Exp

Descriptive Analytics Intermediate

7.0/10

Years Exp

Requirement gathering Intermediate

7.0/10

Years Exp

PowerPoint Intermediate

7.0/10

Years Exp

Data Warehousing Intermediate

6.5/10

Years Exp

Reporting Automation Intermediate

6.5/10

Years Exp

SharePoint Intermediate

6.5/10

Years Exp

Data Quality Management Intermediate

6.5/10

Years Exp

Data Validation Intermediate

6.5/10

Years Exp

Driver analysis Intermediate

6.5/10

Years Exp

correlation analysis Intermediate

6.5/10

Years Exp

Hypothesis Testing Intermediate

6.5/10

Years Exp

ETL Pipelines Intermediate

6.5/10

Years Exp

Automation Anywhere Intermediate

6.5/10

Years Exp

NumPy Intermediate

6.5/10

Years Exp

CSS JavaScript R Git GitHub Configuration Management SDLC Customization Techniques Snowflake MS Excel HTML ETL Processes Collaborative Analytical Thinking Problem Solving Process Improvement Data Structures Deep Learning Artificial Intelligence Big Data Analytics Data Analysis Data Visualization

Work Experience

Operational Analyst

NielsenIQ (NIQ)

Feb 2024 - Present

Delivered 50+ analytics and ETL initiatives using Python, Pandas, MySQL, enhancing reporting precision and supporting data-driven client decisions. Automated high-volume workflows with Python, reducing manual effort by 40% and accelerating operational productivity. Implemented Git-based version control and built reusable modular components to support scalable data integration pipelines. Collaborated with clients to refine data structures and resolve integrity issues, resulting in a 90% improvement in overall data consistency. Migrated core workflows to Azure Cloud Storage, optimizing pipeline throughput and improving processing performance by 30%. Created automated monitoring utilities using Python + SQL to detect anomalies, reduce defects, and maintain high data availability across global teams.