Nayan Karpe
BUSINESS ANALYST | BUSINESS ANALYTICS | MIS REPORTING
Hire this person
Send a job offer directly to this candidate
About
MBA candidate in Business Analytics with hands-on experience in marketing analytics, ERP and CRM data management, MIS reporting, and business operations. Proficient in Advanced Excel, including VLOOKUP, HLOOKUP, XLOOKUP, and Pivot Tables, with working familiarity with Power BI, data cleaning, validation, and visualization. Experienced in preparing business reports, tracking customer leads, and analyzing sales and marketing trends to support data-informed decisions.
Familiar with SDLC, Agile methodology, BRD/FRD documentation, and business process analysis. Seeking an entry-level Business Analyst opportunity.
Experience
Business Analytics Executive - Sunlit Solar Distributor
(2025-09)
- Managed CRM data and tracked customer leads to support sales operations.
- Prepared MIS reports and analyzed sales and operational data using Advanced Excel.
- Used VLOOKUP, XLOOKUP, and Pivot Tables to organize and analyze business information.
- Coordinated with sales and banking teams to support documentation and loan processing.
- Maintained data accuracy through validation and regular reporting.
Marketing Analytics Intern - Alcon Electronic Pvt. Ltd.
(2025-05 - 2025-07)
- Analyzed ERP data to prepare business reports and actionable insights.
- Performed data cleaning and validation to support accurate reporting.
- Created MIS reports using Advanced Excel, including lookup functions and Pivot Tables.
- Assisted in identifying sales and marketing trends to support business decisions.
- Collaborated with team members and presented analytical findings to support marketing activities.
Education
MBA - Business Analytics - MVP’s Institute of Management Research and Technology (2024 - 2026)
Bachelor - Computer Science - NSC Science College, Nashik (2021 - 2024)
