Rajanshuman Pradhan

Associate Data Analyst

Bengaluru, Karnataka 2+ yrs exp 85 · Excellent

About

Associate Data Analyst with 2+ years of hands-on experience in Power BI and SQL — building business intelligence solutions, interactive dashboards, and data visualisation tools that connect data to actionable insights. Strong proficiency in SQL for data management, manipulation, and normalization of structured datasets; experienced with Snowflake as a cloud data platform and Tableau for data visualisation. Proven ability to perform analysis, recognize trends and patterns, develop segmentation models, and present data-driven recommendations to stakeholders. Comfortable working in ambiguity, managing data across multiple sources, and ensuring data quality throughout the BI development lifecycle. Solid verbal and written English communication skills.

Skills & Expertise (36)

Power BI Advanced

8.2/10

Years Exp

Data visualisation Advanced

7.8/10

Years Exp

SQL Intermediate

7.5/10

Years Exp

Trend Analysis Intermediate

7.0/10

Years Exp

Data Normalization Intermediate

7.0/10

Years Exp

Data Management Intermediate

7.0/10

Years Exp

Snowflake Intermediate

6.5/10

Years Exp

Data Integrity Validation Intermediate

6.5/10

Years Exp

Segmentation Intermediate

6.5/10

Years Exp

Reconciliation Intermediate

6.5/10

Years Exp

Quality assurance Intermediate

6.5/10

Years Exp

Complex Joins Intermediate

6.5/10

Years Exp

CTEs Intermediate

6.0/10

Years Exp

Stored Procedures Intermediate

6.0/10

Years Exp

Window Functions Intermediate

6.0/10

Years Exp

DAX Intermediate

6.0/10

Years Exp

Schema Design Intermediate

5.5/10

Years Exp

Python Intermediate

5.5/10

Years Exp

Automation Intermediate

5.0/10

Years Exp

Collections Intermediate

5.0/10

Years Exp

File Handling Intermediate

5.0/10

Years Exp

Exception Handling Intermediate

5.0/10

Years Exp

Data Structures Intermediate

5.0/10

Years Exp

OOP Intermediate

5.0/10

Years Exp

Scripting Intermediate

5.0/10

Years Exp

Generative AI Beginner

4.5/10

LLMs Beginner

4.5/10

Prompt Engineering Beginner

4.5/10

AI-assisted testing Beginner

4.5/10

AI-Assisted Test Case Generation Beginner

4.5/10

AI-assisted automation Beginner

4.5/10

Normalization manipulation RLS Power Query Core Java

Work Experience

Associate Data Analyst — Business Intelligence & Reporting

Tech Mahindra — Telefonica Project

Mar 2024 - Apr 2026

Built business intelligence solutions and models using Power BI — designed interactive dashboards, KPI scorecards, executive reports, and data visualisation tools; applied DAX measures (time intelligence, CALCULATE, RANKX, SWITCH), Power Query transformations, and row-level security to deliver accurate, high-performance BI solutions for business stakeholders. Connected dots across structured datasets using SQL — wrote complex queries (joins, CTEs, window functions, subqueries, stored procedures) against Snowflake for data management, manipulation, and normalization; performed analysis to recognize patterns, distinguish trends, and surface actionable insights from large, structured operational datasets. Performed analysis, interpreted results, and developed actionable insights and recommendations — built segmentation models, decision-aid tools, and data visualisations using Power BI and Tableau; presented findings clearly to business stakeholders and worked effectively in ambiguous, evolving requirements with strong verbal and written English communication. Ensured data quality through rigorous normalization operations, reconciliation checks, null handling, and business rule validation across all BI outputs — maintained data quality standards and resolved inconsistencies before publishing dashboards and reports to business users. Created BI tools and models including dashboards, segmentation views, and business case analyses; collaborated with cross-functional teams to translate business questions into analytical solutions — worked Monday–Friday in dynamic, stakeholder-facing delivery environment — recognised twice with the Pat on the Back award.

Data Analyst Trainee

OUPP

Sep 2023 - Mar 2024

Built Power BI dashboards and BI solutions on Snowflake data — applied SQL for data extraction, manipulation, and normalization; performed trend analysis and pattern recognition to generate business insights, reducing report delivery time by 25%. Ensured data quality across structured datasets; developed data visualisations and presented analytical findings to business stakeholders with clear written and verbal communication.