PRATHAM – DATA ANALYST & EXCEL AUTOMATION SPECIALIST
I help businesses automate reports, build interactive dashboards & streamline HR/MIS operations using Excel, Power BI & SQL.
I specialize in creating automated Excel tools, interactive dashboards, data cleaning systems, and solving reporting challenges for growing companies.
Book a Free Consultation
Core Expertise
HR Data Management
Expert in managing employee data, HRMS administration, and maintaining data integrity across systems.
Reporting Automation
Streamline reporting processes using Excel automation, reducing manual effort by 30%.
Performance Monitoring
Track and analyze employee performance metrics to drive productivity improvements.
Attrition Analysis
Monitor employee exits and identify trends for strategic HR decision-making.
Technical Skills Arsenal
Excel & Data Analysis
  • VLOOKUP, HLOOKUP, XLOOKUP
  • Pivot Tables & INDEX-MATCH
  • IF/IFS, SUMIF Functions
  • Conditional Formatting
  • Data Cleaning & Validation
  • Report Automation
SQL & Databases
  • Query Writing & Joins
  • Filtering & Aggregate Functions
  • Data Extraction for Reporting
Power BI & Visualization
  • Dashboard Creation
  • Data Visualization
  • KPI Tracking
  • HR Performance Dashboards
HR-MIS Tools
  • Attendance Management Systems
  • Attrition & Manpower Analysis
  • Employee Record Management
  • MS Office & Google Workspace
Professional Certifications
1
Data Analyst Course
Status: Ongoing – Expected Completion 2025
Advanced Excel, SQL, Power BI, Data Visualization, Statistics for Data Analysis
2
Advanced Excel for HR Analytics
Status: Completed 2024
HR Dashboards, Pivot Tables, VLOOKUP/XLOOKUP, Index-Match, MIS Reporting
Excel Project Showcase
Smart HR Attendance Tracker – Excel Automation
Automated attendance management system with daily tracking, filters, and summary analytics. Tracks employee attendance patterns and generates insights for HR decision-making.
Benefits
  • Auto-refresh pivot updates
  • Zero Errors
  • Real-Time Insights
  • Fast Daily Reporting
  • Automated Reporting

Key Features
  • Auto-calculates Present, Absent, Half Day, Week-Off & Holidays
  • No manual counting required
  • Saves 80% reporting time
  • Multi-location attendance tracking
LEFT REPORT – Division Wise Analysis Dashboard
A comprehensive dashboard that highlights employee attrition across all divisions, showcasing fresher vs experienced left data, settlement status, and tenure-wise trends to support quick and effective HR decision-making.
Benefits
  • Quick & clear decision making
  • High attrition divisions identify hoti hain
  • Settlement performance track hota hai
  • Employee retention insights milte hain
  • Professional, clean & presentation-ready dashboard
Key Features
  • Total Left ka complete summary
  • Division-wise Fresher vs Experienced left
  • Settlement Status (Within TAT / Above TAT / In-Process)
  • Tenure-wise Left Analysis
  • Interactive Filters (Month, Division, Year)
  • Auto-updating charts & tables
HR Analyst at Express Roadways
sTILL WORKING | Delhi, India
Supported HR team with data-driven insights, reporting automation, and employee performance analytics for 500+ employees.
15%
Productivity Boost
Improved productivity through performance data analysis and action plans
30%
Time Saved
Reduced report preparation time through Excel automation
1000+
Employees Analyzed
Attendance and performance data analyzed for workforce insights
Key Achievements at Express Roadways
Performance Analysis
Analyzed attendance and performance data, identifying low-performance cases and recommending action plans.
Report Automation
Automated HR reports using Pivot Tables, VLOOKUP, and INDEX-MATCH functions.
Custom Dashboards
Designed Excel and Power BI dashboards enabling faster management decision-making.
Risk & Audit Analyst Experience
Sohan Lal Commodity Management | May 2023 – Aug 2024
Oversaw risk audits, compliance reporting, and billing accuracy while serving as SPOC for third-party auditors.
100%
Compliance Rate
Verified 200+ audit reports ensuring full compliance with policies
40%
Response Time Reduction
Implemented query resolution system for auditors
Financial Oversight
Handled billing and payment verification for ₹50M+ annual transactions, minimizing discrepancies and delays.
Process Improvement
Conducted risk analysis on audit findings, recommending improvements that strengthened internal controls.
Educational Background
1
Bachelor of Computer Applications (BCA)
International Institute of Management, Media & IT
Delhi | Aug 2021 – Aug 2024
2
Intermediate (12th)
Govt. Co-ed Sarvodaya Vidyalaya
Delhi | Apr 2020 – Apr 2021
Let's Connect
Ready to bring data-driven insights and HR analytics expertise to your organization. With proven experience in automating reports, building dashboards, and driving performance improvements, I'm passionate about transforming data into actionable business intelligence.
📱 Phone
+91-9354211057
Made with