Back to Developers
pardhu devalla

pardhu devalla

Data Analyst

Vijayawada, AP 1+ yrs exp 87 · Excellent

About

Certified Data Analyst and MBA in Finance & Business Analytics with 1+ year of experience at S&P Global specializing in SQL-based data extraction, Power BI dashboard development, data visualization, data cleaning, and Advanced Excel reporting. Proven ability to transform large, complex datasets from 7,000+ sources into clean, structured, insight-ready outputs through rigorous data cleaning and ETL processes. Adept at building interactive dashboards and data visualization reports in Power BI and Tableau that enable stakeholders to monitor KPIs and make data-driven decisions. Strong finance domain expertise spanning ESG analysis, investment risk, and financial reporting. Certified by SEBI (NISM), Zerodha Varsity, and 365 Financial Analyst. Immediate joiner; open to relocate.

Skills & Expertise (24)

Power BI Intermediate
7.5/10
1
Years Exp
Data Visualization Intermediate
7.5/10
1
Years Exp
Data Cleaning Intermediate
7.5/10
1
Years Exp
Excel Intermediate
7.5/10
1
Years Exp
Power Query Intermediate
7.5/10
1
Years Exp
XLOOKUP Intermediate
7.5/10
1
Years Exp
VLOOKUP Intermediate
7.5/10
1
Years Exp
Pivot Tables Intermediate
7.5/10
1
Years Exp
SQL Intermediate
7.3/10
1
Years Exp
Python Intermediate
6.8/10
1
Years Exp
Tableau Intermediate
6.8/10
1
Years Exp
Pandas Intermediate
6.5/10
1
Years Exp
NumPy Intermediate
6.5/10
1
Years Exp
Data Modeling Intermediate
6.0/10
1
Years Exp
Advanced Formulas Intermediate
6.0/10
1
Years Exp
Macros Intermediate
6.0/10
1
Years Exp
KPI Reporting Intermediate
6.0/10
1
Years Exp
Derivatives Intermediate
6.0/10
1
Years Exp
Portfolio Management Intermediate
6.0/10
1
Years Exp
Financial Modeling Intermediate
6.0/10
1
Years Exp
Reporting Automation Intermediate
6.0/10
1
Years Exp
Statistical Analysis Intermediate
6.0/10
1
Years Exp
R Studio Dashboard Development

Work Experience

Data Analyst — Apprenticeship

S&P Global

May 2025 - May 2026

Performed comprehensive data cleaning and preprocessing on ESG and financial datasets from 7,000+ sources using SQL and Python — removing duplicates, handling nulls, standardizing formats, and validating data integrity to produce analysis-ready datasets. Built and maintained end-to-end Power BI dashboard development solutions — designing interactive KPI dashboards and MIS reports that tracked financial and ESG performance trends for cross-functional stakeholders. Delivered compelling data visualization reports in Power BI and Tableau — translating complex financial and ESG datasets into clear visual narratives that enabled non-technical stakeholders to make informed investment decisions. Authored and optimized advanced SQL queries to extract, join, and aggregate structured data from large relational databases — feeding clean outputs directly into dashboard development and reporting pipelines. Leveraged Advanced Excel (Pivot Tables, Power Query, VLOOKUP/XLOOKUP) for ad-hoc analysis, data cleaning, and supplementary reporting — supporting financial analytics and investment risk assessment workflows. Automated data-sourcing workflows using AI-driven tools to eliminate manual data cleaning steps — reducing report turnaround by 99% while maintaining 98% accuracy across all KPI reporting and data visualization outputs. Collaborated cross-functionally with analytics, operations, and finance teams to define dashboard development requirements, validate data visualization outputs, and align SQL-driven data pipelines with business reporting standards.

Finance Intern

Finance Box Pvt Ltd

May 2024 - Jul 2024

Conducted data cleaning, transformation, and ad-hoc analysis on financial market datasets using Advanced Excel and SQL — ensuring data accuracy for financial modeling (DCF, scenario analysis) and investment reporting. Built structured financial reports and data visualization summaries using Advanced Excel (Pivot Tables, charts, Power Query) — presenting KPI findings and investment insights to senior stakeholders. Performed market research and competitive analysis, translating raw financial data into decision-ready outputs through rigorous data cleaning, Excel-based modeling, and SQL querying. Analyzed risk factors and market data in equities and financial products, applying derivatives and risk management concepts — supporting portfolio management decisions with clean, validated data visualization outputs.

Education

MBA — Finance & Business Analytics - KL University

2023 - 2025 · Afghanistan

B.Tech — Civil Engineering - KL University

2017 - 2021 · Afghanistan

Certifications

Certified Data Analyst

ExcelR · 2025

Financial Modelling in Decision Making

Alison · 2025

ESG Management

Udemy · 2025

Leadership & Team Effectiveness

NPTEL · 2025

SEBI Investor Certification

NISM · 2024

Investment Banking

365 Financial Analyst · 2024

Varsity Certified

Zerodha · 2024

Project Management

NPTEL · 2024

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 7/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 87/100

Profile Overview

Member sinceMay 2026