Hello!

I'm Vikas Pandey



My works

Name: Vikas Pandey

Job Role: Data Analyst

Experience: Real Time Analyst (Jan-2025)

Address: Bijwasan, New Delhi, India

Skills

SQL 90%
MICROSOFT EXCEL 90%
PYTHON 70%
Data Visualization 90%
Statistical Analysis 85%
MICROSOFT POWER BI 70%

About

About Me

Data Analyst with hands-on experience in transforming raw operational data into actionable insights and automated reporting solutions. Currently working as a Real Time Analyst at Telus Digital, driving workforce optimization through data analysis, dashboarding, and process automation.
Skilled in data cleaning, transformation, and visualization using Power BI, SQL (PostgreSQL), and Advanced Excel. Proven track record of building automated reporting systems using Google Apps Script, reducing manual effort by 60% and enabling real-time decision-making.
Strong experience in stakeholder collaboration, translating business requirements into data models, dashboards, and performance insights. Adept at analyzing key metrics such as SLA, AHT, adherence, and occupancy to improve operational efficiency.
Focused on delivering scalable data solutions, optimizing reporting workflows, and driving data-backed decision-making in fast-paced environments.

  • Profile: Data Analystics & Business Analytics
  • Domain: Retail, Ecommerce, BFSI & Technology
  • Education: Bachelor of Science
  • Language: English, Hindi
  • BI Tools: Microsoft Power BI
  • Programming Languages: Python, libraries: Numpy, Pandas, Matplotlib and Seaborn
  • Interest: Volleyball, Cycling, Travelling

0 +   Projects completed

LinkedIn

About

About

Data Analyst with hands-on experience in transforming raw operational data into actionable insights and automated reporting solutions. Currently working as a Real Time Analyst at Telus Digital, driving workforce optimization through data analysis, dashboarding, and process automation.
Skilled in data cleaning, transformation, and visualization using Power BI, SQL (PostgreSQL), and Advanced Excel. Proven track record of building automated reporting systems using Google Apps Script, reducing manual effort by 60% and enabling real-time decision-making.
Strong experience in stakeholder collaboration, translating business requirements into data models, dashboards, and performance insights. Adept at analyzing key metrics such as SLA, AHT, adherence, and occupancy to improve operational efficiency.
Focused on delivering scalable data solutions, optimizing reporting workflows, and driving data-backed decision-making in fast-paced environments.

Experience


Real Time Analyst (Workforce Management)

Telus Digital | Jan 2025 - Present

  • Recognized as Employee of the Quarter for exceptional performance, innovative problemsolving, and outstanding contribution to workforce optimization initiatives.
  • Engineered automation solutions using Google Apps Script, reducing manual reporting efforts by 60% and enabling real-time data accessibility for leadership decision-making.
  • Monitor and optimize workforce performance in real-time, proactively identifying staffing gaps, adherence deviations, and service level threats across multiple queues to consistently achieve 95%+ SLA targets.
  • Serve as strategic communication hub between operations, scheduling, and leadership teams, orchestrating rapid resolution of intraday performance issues and minimizing service disruptions.
  • Execute dynamic intraday management, implementing same-day schedule adjustments for breaks, training, and coaching sessions to maintain optimal coverage while balancing billable hours and agent productivity.
  • Drive data-driven decision-making through comprehensive analysis of adherence, occupancy, shrinkage, AHT, and absenteeism metrics, delivering actionable insights that enhance operational efficiency.
  • Documentation & Analysis: Maintain detailed records and conduct in-depth analysis to support strategic planning.
  • Champion process innovation, introducing creative solutions and best practices that improved team productivity and supported strategic workforce planning initiatives.
  • Deliver real-time operational intelligence by monitoring AUX activities, hold times, and aftercall work patterns, ensuring compliance with account-specific playbooks and performance standards.


Education


2021-2024

Bachelor of Science

Deen Dayal Upadhyaya College
(University of Delhi)

Grade: First class distinction.

2018-2020

Higher Secondary School

Govt. Co-Ed. Sr. Sec. School

Grade: First class distinction.

Download Resume

Projects

Projects

Below are the sample Data Analytics projects on SQL, Excel, Python & Power BI.

Customer Performance analysis using Power BI

Built a dynamic Power BI dashboard with 20+ DAX measures to analyze customer demographics, revenue, and behavior, enabling data-driven segmentation and actionable insights for marketing and business strategy.

Music Sales Data Analysis using SQL

Conducted an in-depth analysis of sales data for a real-world distributor of various vehicle types. Utilized Excel to visualize data trends and generate reports that provided actionable insights for sales strategies.

Swiggy Instamart: Grocery Store Analysis using Excel

Conducted an in-depth analysis of sales data for a real-world distributor of various grocery types. Utilized Excel to visualize KPI, data trends and generate reports that provided actionable insights for sales strategies.

Minerals and Energy Resources analysis using Power BI

Used real world data of SEEA framework from OECD Data Explorer for creating a report page of the resorces founded till 2023 and provide detailed actionable insights using Microsoft Power BI and Excel.


Python Chatbot for Task Automation

Created a Python-based chatbot designed to automate daily tasks, enhancing productivity. Implemented natural language processing techniques to improve user interaction and task execution.

Customer Churn Analysis usig SQL

Identify patterns that lead to customer churn and provide actionable insights to reduce it.

0 Achievements
0 Projects

More projects on Github

I love to solve business problems & uncover hidden data stories


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Bijwasan, New Delhi, India

Contact Number

+91 8285718959

Email Address

vp587221@gmail

Download Resume

Resume Link



Have a Question? Click Here


  • Find me on