Portfolio - Pawan Kumar Yadav

About Me

Results-driven Data Analyst with over 2 years of experience in SQL, Power BI, Excel, and ETL processes. Skilled in creating interactive dashboards, analyzing trends, and delivering actionable insights to optimize operations.
Expertise in data cleansing, transformation, visualization, and root cause analysis to drive growth, streamline workflows, and enhance decision-making. Passionate about transforming data into strategic value to address business challenges.

Key Skills

Power BI

Excel

SQL

Python

My Projects

Power BI - Business Insights 360

Domain/Function: Business Intelligence and Data Analytics

Power BI - Netflix Analytics

Domain/Function: Entertainment and Media Analytics

Power BI - Blinkit Analytics

Domain/Function: E-Commerce and Retail Analytics

Excel - Sales Analytics

Domain/Function: Sales and Finance Analytics

SQL - Finance and Supply Chain Analytics

Domain/Function: Finance and Supply Chain Analytics

Python x Power BI - Revenue Insights in Hospitality Domain

Domain/Function: Hospitality Domain

My Experience

Data Analyst, Cognizant, Gurugram | Jul 2022 – Oct 2024

Collaborated with cross-functional teams to gather business requirements, design scalable data solutions, and deliver clean, curated datasets through robust pipelines, ensuring high data quality and accuracy.
Designed and deployed interactive Power BI dashboards, leveraging best practices in data visualization and storytelling to drive data-driven decision-making.
Optimized SQL queries and database performance, reducing query execution time by 25% and enhancing functionality by designing custom database objects such as tables, views, and triggers.
Conducted in-depth data analysis to address complex business challenges, identifying root causes and implementing solutions that increased team productivity and output by 18%.
Standardized and documented business reporting processes, streamlining operations and reducing report generation time by 30%, enabling faster decision-making and continuous process improvements.

Internship Trainee, Cognizant, Gurugram | Feb 2022 – Jul 2022

Inspected, cleaned, and transformed raw data, improving data accuracy by 20% and ensuring the data was aligned with business objectives, supporting downstream reporting and decision-making processes.
Optimized SQL queries for enhanced data processing speed, achieving a 20% increase in efficiency and streamlining the reporting workflow, leading to faster insights and more responsive decision-making.
Developed and visualized reports using charts and graphs to simplify complex data, increasing accessibility by 30% for non-technical stakeholders, ensuring data consistency, and resolving discrepancies that led to a 15% improvement in data quality.