Summary
Overview
Work History
Education
Skills
Certification
Disclaimer
Timeline
Generic
Deepak Pandey

Deepak Pandey

Data Analyst – Power BI | SQL | Python | Tableau | Alteryx |
Saket, New Delhi

Summary

Results-driven Data Analyst with over 5 years of experience transforming raw data into actionable insights to support strategic business decisions. Proficient in tools like SQL, Power BI, Tableau, Excel, Python, and Alteryx, with a strong ability to analyze complex datasets, develop interactive dashboards, and deliver data-backed solutions across operations, customer experience, and sales domains.


Demonstrated success in building automated reporting systems, uncovering key trends, and driving performance improvements across industries including digital banking, automotive, and retail. Adept at collaborating with cross-functional teams, simplifying data for non-technical stakeholders, and contributing to data-driven growth.

Overview

9
9
years of professional experience
3
3
years of post-secondary education
3
3
Certifications

Work History

Sr. Associate- Operations (Data Analyst)

WNS Global services
09.2023 - Current
  • Designed and maintained automated Power BI and Tableau dashboards to track customer service KPIs like chat volume, response time, and CSAT, resulting in a 22% improvement in SLA adherence.
  • Used SQL (MS SQL Server) to extract and analyze over 100K+ customer interaction records weekly, identifying key drivers of low NPS scores and reducing escalation rates by 23%.
  • Implemented Python scripts (Pandas, NumPy) to clean and preprocess unstructured customer feedback data for sentiment analysis, enhancing insight quality.
  • Developed a quality score prediction model using logistic regression in Python, increasing accuracy of performance forecasting by 30%.
  • Collaborated with cross-functional teams (product, operations) to recommend data-backed improvements, leading to a 15% boost in first-contact resolution rate.

Customer Data Analyst

OLX Autos India Pvt. Ltd
12.2021 - 08.2023
  • Built customer lifecycle dashboards in Tableau and Power BI to visualize churn risk, average ticket resolution time, and campaign conversion — used across 5 regional sales teams.
  • Queried and segmented customer support data using advanced SQL joins, CTEs, and window functions to identify behavioral patterns and escalation trends.
  • Performed exploratory data analysis (EDA) and A/B test evaluations using Python (Pandas, NumPy, SciPy) to optimize chat funnel performance.
  • Used Alteryx for automated data wrangling and transformation, reducing monthly manual reporting tasks by 80%.
  • Contributed to a store expansion strategy project by using Tableau spatial maps and clustering (K-Means in Python) to determine optimal new showroom locations.

Data Support Executive

Bajaj Autos Ltd
01.2019 - 12.2021
  • Maintained and updated daily, weekly, and monthly sales reports using Microsoft Excel, including pivot tables, VLOOKUP, and charts for management review.
  • Collected and organized data from different branches and prepared performance summaries for regional teams.
  • Tracked inventory levels and stock movement using Excel-based templates to help reduce overstocking and shortages.
  • Prepared customer follow-up lists and lead reports to support the sales team in targeting potential buyers.
  • Worked with the MIS team to ensure timely submission of reports and accuracy of dealership performance data.
  • Supported regional managers during monthly reviews with basic dashboards and Excel visuals, improving visibility of branch performance.

Sales and Reporting Support

Shell India - Dealership
03.2018 - 12.2019
  • Maintained and updated daily sales reports and fuel stock records using Microsoft Excel, supporting decision-making for daily operations.
  • Assisted in preparing monthly performance summaries, including sales targets vs. achievements for regional review meetings.
  • Helped store managers with customer feedback collection and data entry for service quality improvement.
  • Organized and cleaned historical sales data for analysis and reporting, reducing manual errors in records.
  • Coordinated with the sales team to track leads and conversion rates, providing weekly updates on progress.
  • Supported implementation of local marketing campaigns by tracking engagement data and preparing simple visual reports.

Operations Assistant

Patel Transport Services
02.2017 - 12.2017
  • Handled daily record-keeping for incoming and outgoing goods using Excel and physical logbooks.
  • Assisted in preparing delivery schedules and tracking vehicle dispatches to ensure timely deliveries.
  • Helped maintain basic stock reports and updated order status for management reference.
  • Coordinated with drivers and warehouse staff to monitor delivery progress and resolve delays.
  • Supported store manager in preparing simple reports on transportation costs and inventory movement.
  • Managed filing and documentation for bills, receipts, and invoices to keep records organized.

Education

Bachelor of Computer Application- B.C.A -

Chhatrapati Shahu Ji Maharaj University
Kanpur, India
01.2013 - 01.2016

Skills

Data Analysis & Visualization

Certification

Managing a Global Team with Confidence - udemy Certified

Disclaimer

I hereby declare that the information provided in this resume is true and accurate to the best of my knowledge and belief. I understand that any false information may lead to disqualification or termination of employment. Deepak Pandey

Timeline

Sr. Associate- Operations (Data Analyst)

WNS Global services
09.2023 - Current

Customer Data Analyst

OLX Autos India Pvt. Ltd
12.2021 - 08.2023

Data Support Executive

Bajaj Autos Ltd
01.2019 - 12.2021

Sales and Reporting Support

Shell India - Dealership
03.2018 - 12.2019

Operations Assistant

Patel Transport Services
02.2017 - 12.2017

Bachelor of Computer Application- B.C.A -

Chhatrapati Shahu Ji Maharaj University
01.2013 - 01.2016

Similar Profiles

CREATE PROFILE
Deepak PandeyData Analyst – Power BI | SQL | Python | Tableau | Alteryx |