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
Data exploration, cleaning, and transformation
KPI tracking and performance analysis
Interactive dashboards and visual storytelling using Power BI and Tableau
Cross-functional data presentation and reporting
Tools & Technologies
SQL (Joins, CTEs, Window Functions, Subqueries)
Power BI (DAX, Power Query, Scheduled Refresh)
Tableau (Calculated Fields, Filters, Spatial Maps)
Microsoft Excel (Pivot Tables, VLOOKUP, Charts, Data Validation)
Python (Pandas, NumPy, Matplotlib, Seaborn, basic ML)
Alteryx (Data prep, workflow automation)
Data Handling & Reporting
Report automation and KPI dashboards
Large dataset processing and segmentation
Basic statistical analysis and trend forecasting
Data storytelling for non-technical stakeholders
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