Hello!

I'm Pawan Pal



A Data Analyst

LinkedIn

Name: Pawan Pal

Job Role: Data Analyst

Experience: 1+ Year

Location: New Delhi, India

Skills

SQL 80%
PYTHON 70%
Microsoft PowerBI 90%
Statistical Analysis 90%
MS Excel 90%

ABOUT ME

Data Analyst with 1+ years of experience in business intelligence, SQL, and Power BI, skilled in transforming raw data into actionable insights. Developed dashboards tracking ₹10M+ in transactions and optimized reporting processes, reducing manual workload by 30%. Adept at cleaning and analyzing large datasets using SQL, Power Query, and DAX to drive data-driven decision-making. Passionate about solving business problems through automation, visualization, and predictive analytics.

  • Profile: Data Analytics
  • Domain: Hospitality, HR, Retail & Ecommerce
  • Education: Bachelor of Science (Mathematics)
  • Language: English, Hindi
  • BI Tools: Microsoft Power BI, Looker Studio
  • Other Skills: Excel & Statistics
  • Interest: Badminton, Travelling, Teaching

0 +   Projects completed

LinkedIn

RESUME

RESUME

"Results-driven Data Analyst with expertise in data analysis, business intelligence, and statistical analysis. Passionate about leveraging data-driven insights to optimize business strategies, improve decision-making, and drive operational efficiency. Skilled in analytical tools, reporting, and visualization to transform complex data into actionable insights."

PROFESSIONAL EXPERIENCE


Data Analyst (MIS)

Jan 2024 - Jan 2025
LUCKNOW, INDIA

  • Designed an annual sales and performance dashboard that tracked over 6+ sales agents, leading to a 15% improvement in sales performance

  • Developed an interactive Sales & Expense dashboard in Power BI that analyzed ₹500M+ in transactions, providing actionable insights that reduced expenses by 10%

  • Engineered a Looker Studio Sales Dashboard monitoring weekly & monthly sales trends across 3+ companies, improving forecasting accuracy by 20%

  • Delivered 10+ executive presentations, translating complex data into insights that influenced strategic decisions worth ₹5M+

  • Streamlined data processing using Google Sheets and Excel, reducing manual workload by 30%

  • Conducted market research to identify 3+ potential export countries, for business expansion strategies

  • Responded to and resolved 20+ ad-hoc queries per month, providing critical business intelligence support

  • Optimized data pipelines, reducing report generation time by 40%, leading to faster decision-making

  • Validated and improved data accuracy by 98% by implementing automated validation checks using Excel and Google Sheets

  • Collaborated with cross-functional teams, including sales and finance, to integrate data from multiple sources, improving overall reporting efficiency

CERTIFICATIONS


Data Analyst Bootcamp

Nov 2023 - Dec 2023
Instructor: Alex Freberg

  • SQL: Database querying and management using MySQL

  • Python: Data manipulation and analysis with Pandas

  • Power BI: Data transformation with Power Query, advanced analytics using DAX

  • Excel: Pivot tables, data cleaning, and automation techniques

Introduction to SQL

Feb 2024
BY SIMPLILEARN

  • MySQL and PostgreSQL

  • Joins, CTEs

  • Subquery, Triggers

  • If Condition, Rank

Python for Beginners

Feb 2024
By Simplilearn

  • Pandas, Matplotlib libraries

  • Dictionaries, If Else statements

  • Functions, Array

  • Jupyter Notebook, Python Variables

Excel Formulas and Functions

Jan 2024
BY SIMPLILEARN

  • Mathematical and Financial Functions

  • Advance Functions like Lookup etc.

  • Sumif, Countif Functions

  • Date and Time Function



EDUCATION


Oct 2020-Aug 2023

Bachelor of Science (Maths)

Lucknow University

Grade: First class distinction.

2018

Higher Secondary School

Lucknow Model Public Inter College

Grade: First class distinction.




Download Resume

PROJECTS

PROJECTS

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

Hospitality Data Analysis using Power BI

Analyzed hotel chain data using DAX and measures to identify gaps and increase business growth.

AtliQ Mart Promotions Analysis

Analyzed AtliQ Mart promotions, fulfilled ad-hoc requests using SQL, and created an interactive dashboard.

Electronics Store Sales Analysis using Python

Performed exploratory data analysis on sales data of an electronic store using Python to gain the insights and improve the sales of the store.


Checkout more Projects on


GitHub


"Data driven professional, committed to leveraging analytics to drive innovation, efficiency, and growth."


Contact

Contact Me

Below are the details to reach out to me!

Address

New Delhi, India

Contact Number

+91 7007398565

Email Address

pawanpal.inbox@gmail.com

Resume

Download Link




  • Find me on