PRIYANKA YADAV - Data Analyst

Summary

Data Analyst with 2.3 years of experience in translating complex datasets into actionable insights to drive business decisions. Proficient in SQL, Power BI, Tableau, and Excel , with hands-on expertise in data visualization, statistical analysis, and predictive modeling . Skilled at identifying trends, optimizing processes, and delivering accurate, data-driven solutions in collaboration with cross-functional teams.

Overview

3

years of professional experience

3

Certifications

2

Languages

Work History

Data Analyst

Malu Electrodes Pvt. Ltd.

07.2023 - 10.2025

Extracted, cleaned, and analyzed large-scale management and financial datasets using advanced SQL ( CTEs, subqueries, window functions, temp tables ), optimizing queries through indexing and execution plan analysis to improve performance.
Automated end-to-end MIS and analytical reporting pipelines using SQL-driven ETL logic and advanced Excel automation ( Power Query, PivotTables, macros ), reducing manual effort by ~30% and improving refresh efficiency.
Designed and maintained enterprise-grade Tableau dashboards leveraging LOD expressions, calculated fields, parameters, filters, actions , and performance best practices to track KPIs, trends, and financial metrics .
Built and optimized data models by defining joins, relationships, and aggregations to support scalable, high-performance reporting across multiple data sources.
Implemented robust data validation, reconciliation, and quality control frameworks , including anomaly detection and variance analysis , to ensure data accuracy and consistency .
Collaborated with cross-functional teams to translate business requirements into technical specifications, analytical datasets , and high-impact visualizations , supporting strategic decision-making .

Data Analyst Intern – Finance Domain

AI Variant

10.2022 - 07.2023

Analyzed financial datasets including revenue, expenses, and profitability metrics.
Prepared MIS and variance reports to support budgeting and performance analysis.
Developed Power BI dashboards to monitor key finance KPIs and business metrics.

Education

Bachelor of Commerce - Computer Applications

Dr. Ambedkar College of Study And Research Management

05-2019

Skills

Technical Tools: Power BI Tableau Excel SQL Python

Data-Focused Skills: Data Cleaning Data Validation

Analytical & Reporting Skills: Credit Risk Analysis Variance Analysis MIS Reporting Stakeholder Collaboration

Certification

Data Analytics – ExcelR

Projects

Credit Risk Scoring & Default Prediction

Built end-to-end credit risk modeling pipeline to estimate Probability of Default (PD) using borrower and credit bureau data.
Engineered risk-driven features and trained Logistic Regression & Tree-based models , reducing false positives by 15% .
Evaluated models using ROC-AUC, KS statistic, precision-recall , optimizing thresholds for risk-based decisioning .
Integrated PD with LGD & EAD for Expected Credit Loss (ECL) estimation and portfolio-level risk assessment.

Automated Financial Statement & Variance Analysis

Developed Actual vs. Budget dashboards in Power BI/Tableau , enabling real-time cost tracking and variance analysis across business units.
Conducted what-if and sensitivity analyses on COGS fluctuations , quantifying impacts on profitability and EBITDA to support strategic financial decision-making .

Insurance Loan Analysis

Developed interactive Tableau dashboards to analyze insurance loan portfolios across customer segments, income levels, credit history, and benefit categories .
Performed data extraction, transformation, and validation in Excel , ensuring accuracy, consistency, and reliability of datasets for Probability of Default (PD) and risk scoring.
Analyzed and visualized relationships between income, benefits, and credit history , supporting loan eligibility assessment, credit risk evaluation, and portfolio-level monitoring .

Timeline