DHARMENDRA RATHAUR

Data Analyst

https://www.opentalent.in/dharmendra-rathaur

Data Analyst with less than a year in Data Analysis & Visualization using SQL, Python, Excel, and Po

Key Strengths

Demonstrated ability to manage and clean large datasets using SQL, Python (Pandas), and Excel.
Proficiency in creating interactive dashboards and visualizations with Power BI to present key performance indicators (KPIs).
Experience in conducting exploratory data analysis (EDA) to identify trends and patterns in transactional data.
Practical application of data analysis techniques in real-world scenarios (UPI transactions, sales data).
Strong foundation in SQL for data extraction and manipulation, including joins, aggregations, and subqueries.

Cultural & Operational Fit

Cultural Fit Analysis

The candidate's projects demonstrate a practical, hands-on approach to data analysis, aligning with a results-driven culture. The use of diverse tools (SQL, Python, Power BI, Excel) indicates adaptability and a willingness to learn. The projects are relevant to the target role of Data Analyst, showing a clear career focus. However, the lack of diverse project types beyond transactional/sales data analysis limits the assessment of broader cultural fit and adaptability to varied business contexts.

Soft Skills & Operational Fit

The candidate's project descriptions indicate an ability to translate raw data into actionable insights, which is crucial for a Data Analyst role. The focus on KPIs and business decision support suggests a results-oriented approach. However, without psychometric or English test scores, a comprehensive assessment of soft skills like logical reasoning, work attitude, stress handling, and team collaboration is not possible.

AI is analyzing your overall score…

Identifying your key strengths…

Evaluating your skill match against the job requirements…

Assessing your cultural and operational fit

About

Aspiring data analytics professional skilled in SQL, Python, Excel, and Power BI for data analysis and visualization. Leverages strong analytical and problem-solving abilities through hands-on experience in data analysis projects. Transforms raw data into actionable insights to support decision-making and is eager to contribute to organizational growth while enhancing technical expertise.

Top Skills

SQLPythonExcelPower BIData Cleaning

Education

Cambridge Institute of Technology

Bachelor of Engineering · Computer Science & Engineering

August 1, 2019 – June 30, 2023

Janta I C Bahrojpur Ganjdundwara Kasganj

Higher Secondary

June 1, 2016 – May 31, 2017

Janta H S S Bahrojpur Kasganj

Secondary

June 1, 2014 – May 31, 2015

Projects

Phone Pay: UPI- Transaction Data Analyst

June 1, 2025 – August 1, 2025

Managed and Cleaned Data: Analyzed and managed 20,000+ UPI transactions totaling $19.87M across 4 major cities using SQL, Python, and Power BI, establishing a comprehensive transaction analytics capability. Cleaned and transformed raw data with Python (Pandas) and SQL queries to ensure accuracy and consistency. Conducted exploratory data analysis (EDA) using Python and Excel to evaluate transaction volume, value, success rate, and failure rate. Created charts and visualizations in Excel and Python to identify trends and patterns. Developed an interactive Power BI dashboard to showcase key performance indicators (KPIs), including transaction trends, peak hours, and payment performance.

View Project

Flipkart: Sales Data Analyst

March 1, 2024 – May 1, 2024

Data Cleaning, Create Visual Dashboard. Analyzed Ola ride data using SQL to extract insights on trip volume, revenue, peak hours, and cancellation trends. Cleaned and structured raw datasets in Excel utilizing pivot tables, VLOOKUP/XLOOKUP, and conditional formatting. Developed interactive Power BI dashboards to visualize KPIs, including rides per city, driver performance, and customer demand. Created dynamic charts and graphs to identify peak booking times and high-demand locations. Delivered data-driven insights to support business decisions and enhance operational efficiency.

View Project

Key Strengths

Demonstrated ability to manage and clean large datasets using SQL, Python (Pandas), and Excel.
Proficiency in creating interactive dashboards and visualizations with Power BI to present key performance indicators (KPIs).
Experience in conducting exploratory data analysis (EDA) to identify trends and patterns in transactional data.
Practical application of data analysis techniques in real-world scenarios (UPI transactions, sales data).
Strong foundation in SQL for data extraction and manipulation, including joins, aggregations, and subqueries.

Cultural & Operational Fit

Cultural Fit Analysis

Soft Skills & Operational Fit

DHARMENDRA RATHAUR

Key Strengths

Cultural & Operational Fit

About

Top Skills

Skills

Education

Projects

Certifications

Key Strengths

Cultural & Operational Fit