Data Analyst Power Bi

RITESH

(Data Analyst) Email: ***********@*****.***

LinkedIn - http://www.linkedin.com/in/ritesh-43b965271 City: Bhilai

GitHub - https://github.com/Ritesh19092 Mobile: +91-626*******

PROFESSIONAL SUMMARY

Motivated and detail-oriented Data Analyst with a strong academic background in data analytics and visualization. Proficient in Python, SQL, Excel, Power BI, and Tableau, with hands-on experience in data cleaning, transformation, and building insightful dashboards. Skilled in exploratory data analysis, statistical techniques, and communicating insights through visual storytelling. Eager to apply analytical skills to solve real-world business problems and support data-driven decision-making in a professional environment.

SKILLS SUMMARY

●Languages: Python, SQL

●Core Skills: Data Analytics, Data Mapping Data Management, Data Visualization, Dashboards, Data Validation, Data

Processing, Data Manipulation, Data Cleaning, Data Validation & Testing, KPI Dashboards

●Frameworks: Pandas, NumPy, Seaborn, Matplotlib

●Tools: Power BI, Excel, PowerPoint, Tableau, MySQL,

●Platforms: Jupyter Notebook, SQL Server

●Soft Skills: Curiosity, Problem Solving, People Management, Critical Thinking, Analytical Thinking

WORK EXPERIENCE

DATA ANALYST INTERN LEARVISTA PVT. LTD. November 2023 to November 2024

Analysed 5000 + call center records, improving visibility into agent performance (81% answer rate, 73% issue resolution) and average response time (67.5 sec).

Worked with 17,500+ employee records in an HR dashboard to study diversity, tenure (avg. 7 yrs), and departmental attrition for strategic workforce insights.

Explored over $100M in healthcare claims data, identifying top cost categories and reducing unpaid claims by isolating top denial reasons (65% from 3 codes).

Delivered clean, interactive dashboards and reports, applying data cleaning, transformation, and visualization best practices.

TATA CONSULTANCY SERVICES – DATA VISUALIZATION SIMULATION (FORAGE) Sep 2024 to Oct 2024

Completed a simulation involving creating data visualizations for Tata Consultancy Services

Prepared questions for a meeting with client senior leadership

Created visuals for data analysis to help executives with effective decision making

DELOITTE AUSTRALIA – DATA ANALYTICS JOB SIMULATION (FORAGE) 1 to 28 Feb 2025

Completed a Deloitte job simulation involving data analysis and forensic technology

Created a data dashboard using Tableau

Used Excel to classify data and draw business conclusions

PwC SWITZERLAND – POWER BI JOB SIMULATION (FORAGE) Feb 2025 to March 2025

Completed a job simulation where I strengthened my Power Bi skills to better understand clients and their data visualization needs.

Demonstrated expertise in data visualization through the creation of Power BI dashboards that effectively conveyed KPIs, showcasing the ability to respond to client requests with well-designed solutions.

Strong communication skills reflected in the concise and informative email communication with engagement partners, delivering valuable insights and actionable suggestions based on data analysis.

Leveraged analytical problem-solving skills to examine HR data, particularly focusing on gender-related KPIs, and identified root causes for gender balance issues at the executive management level, highlighting a commitment to data-driven decision-making.

PROJECTS

Call Center Dashboard

Executed data reconciliations across ~5,000 transaction records, identifying mismatches and ensuring accuracy in daily reporting; escalated unresolved discrepancies to management. Utilized data cleaning and data manipulation techniques to prepare call logs and customer feedback data for analysis.

Designed Power BI dashboard with scheduled refresh, SLA monitoring (avg. speed of answer 67s, answer rate 81%), and forecasting features to support real-time performance tracking and management reviews.

Delivered data visualization through donut charts, bar charts, and gauges with interactive filters (by agent, topic, date) to support performance reviews.

Human Resource Analysis

Elicited and documented business rules affecting attrition; built process flow diagrams and scenarios to support functionality testing.

Conducted statistical analysis to uncover patterns in remote work adoption (74.97%) and termination risk (e.g., 0.16 in Auditing).

Used data cleaning and data transformation to ensure accuracy across demographic variables (gender, race, age).

Developed interactive Power BI dashboards with forecasting models and trend analysis to support workforce planning, scheduling, and compliance reporting

Analyzed and documented business rules impacting employee attrition; improved master data integrity for reporting.

Health Care Analysis

Processed and analysed over $100M in claims data using data analytics and data manipulation to identify cost drivers and coverage gaps.

Conducted statistical analysis to isolate 3 primary reason codes responsible for 65% of uncovered claim costs.

Cleaned and transformed data for visualization of procedure costs, encounter types, and city-wise medical expenses from 2012 to 2021.

Collaborated with stakeholders to define requirements, performed reconciliation/validation, and supported change management through process improvement insights.

Monitored financial transaction data, validated entries against source records, and resolved discrepancies to maintain reporting accuracy in compliance with control standards.

CERTIFICATES

Business Analyst and Data Analyst Certificate (IBM)

Integrated Business Analytics and Visualization (IBM)

EDUCATION

Hemchand Yadav Vishwavidyalaya Durg, India

Bachelor of Commerce Percent: 72%

Contact this candidate