Rajan Kumar
Aspiring Data Analyst
Greater Noida
Summary
Passionate Data Analyst with hands-on training in advanced Excel and Power Query. Experienced in sales and customer service, transitioning into the analytics and finance domain. Skilled in transforming raw data into meaningful insights using Excel-based tools. Highly motivated to contribute analytical skills in a dynamic corporate environment and deliver value through actionable insights.
Overview
2
2
years of professional experience
4
4
Certifications
2
2
Languages
Work History
Rotary Club Member
Lucknow University Chapter
07.2021 - 06.2022
- Contributed to 6+ donation drives and awareness campaigns, reaching 300+ beneficiaries.
- Managed logistics for education and hygiene events with 200+ attendees, improving outreach efficiency by 35%.
Sales Executive
India-MART InterMESH Ltd.
06.2020 - 12.2020
- Onboarded 50+ businesses via cold calls, increasing platform adoption by 25% within 6 months.
- Achieved a 30% lead-to-conversion rate through strategic follow-ups and personalized communication.
- Contributed to a 15% boost in weekly sales by initiating targeted outreach to local vendors.
- Built and maintained an Excel-based tracking system, reducing manual reporting by 40%.
Education
BBA - Business Administration
Lucknow University
Lucknow, India 04.2001 -
Mathematics
Bhagirathi Janaki Devi School
Basti 04.2001 -
High School - Mathematics
Bhagirathi Janaki Devi School
Basti01-2017
Skills
Advanced Excel (Formulas, PivotTables, XLOOKUP)
Power Query (Unpivot, Merge, Append, M language basics)
Financial Data Analysis & Reporting
Data Cleaning & Transformation
Dashboard & Visualization Creation
Discounted Cash Flow (DCF), LBO Valuation Basics
ChatGPT for Data Insights
Profit & Loss Account Analysis
KEY ACHIEVEMENTS
🔹 Optimized Conversion Time
Reduced lead conversion time by 15% through structured communication and Excel-based tracking improvements.
🔹 Increased Sales Target
Led outreach efforts that contributed to a 20% increase in sales within a quarter at IndiaMART.
🔹 Enhanced Lead Tracking
Implemented and managed an Excel lead tracking system, boosting team efficiency by 30% and reducing manual work.
🔹 Successful Event Coordination
Coordinated logistics for university charity and awareness events, with total attendance exceeding 500+ participants.
Certification
Microsoft Office Specialist, Completed, Basic to Intermediate Level, Delhi
Tools And Platforms
- Microsoft Excel
- Google Sheets
- PowerPoint
- WhatsApp Business
- Zoom
Timeline
Rotary Club Member
Lucknow University Chapter
07.2021 - 06.2022
Sales Executive
India-MART InterMESH Ltd.
06.2020 - 12.2020
BBA - Business Administration
Lucknow University
04.2001 -
Mathematics
Bhagirathi Janaki Devi School
04.2001 -
High School - Mathematics
Bhagirathi Janaki Devi School