Back to Developers
Prashant Kumar

Prashant Kumar

Business Analyst

Bangalore, India
85
Profile Score

About

Results-driven Business Analyst with 3+ years of experience in data analytics, operations support, business performance analytics and retention analytics within fast-paced environments. Proficiency in SQL, Excel, Power BI, and Google Sheets for data validation, reporting automation, dashboard creation, and process optimization. Proven track record of improving operational efficiency by 30–40% through data quality initiatives, reporting automation, and cross‑functional collaboration. PGDM graduate specializing in Business Analytics with strong stakeholder communication and problem‑solving skills.

Skills & Expertise (21)

Excel Advanced
8.5/10
4
Years Exp
Power BI Intermediate
7.8/10
1.5
Years Exp
Google Sheets Intermediate
7.4/10
2
Years Exp
SQL Intermediate
7.1/10
3
Years Exp
Python Intermediate
6.5/10
1
Years Exp
A/B testing Reporting Automation Dashboard Development Process Optimization Requirement gathering Stakeholder Management Root Cause Analysis KPI Tracking Data Validation Conditional Formatting HLOOKUP VLOOKUP Power Query Jira Pivot Tables Looker Studio

Work Experience

Accounts Analyst

Greet Technologies Pvt. Ltd.

Sep 2020 - Jan 2022

Managed end-to-end procure-to-pay (P2P) operations including invoice reconciliation, vendor onboarding, and issue resolution for 50+ vendors. Conducted Excel-based financial reconciliations to monitor performance metrics and identify discrepancies, achieving 98% accuracy rate. Streamlined vendor onboarding processes and enhanced communication protocols, reducing onboarding time by 20% and improving stakeholder satisfaction.

Growth Analyst Intern

Xtra Ordinary

Jun 2025 - Dec 2025

Analyzed customer behavior, product, and campaign datasets across marketing channels to generate actionable insights that improved conversion rates by 15% and customer retention by 12%. Built automated Excel and Google Sheets dashboards tracking 20+ operational and campaign KPIs, reducing manual reporting effort by 25% and improving data accessibility for stakeholders. Collaborated with marketing, product, and sales teams to streamline reporting workflows and integrate multiple platform datasets into a unified reporting framework.

Specialist - Business Analytics

Andor Tech

Jan 2022 - Jul 2023

Executed data-driven customer segmentation and engagement campaigns analyzing 100K+ records using SQL and Excel, resulting in 20% improvement in campaign targeting accuracy. Designed and deployed Power BI dashboards providing business performance and campaign performance analytics on process efficiency, reducing operational bottlenecks by 25% and improving customer satisfaction scores. Automated reporting workflows using Power Query and Python scripts, reducing manual effort by 30% and improving data delivery speed by 40%. Conducted comprehensive data validation and reconciliation across CRM and ERP systems, ensuring 100% data integrity and accuracy in business reporting.

Business Analyst Intern

IFortis Worldwide

Feb 2025 - May 2025

Performed data collection, data cleaning, and data management activities, ensuring data accuracy and consistency. Developed and maintained Excel-based reports, stakeholder dashboards, and trackers using VLOOKUP, HLOOKUP, Pivot Tables to support operational decision-making. Coordinated with cross-functional teams to gather, verify, and update operational data, ensuring reporting accuracy and consistency across business functions.

Education

Post Graduate Diploma in Management (PGDM) - Business Analytics - Jagdish Sheth School of Management (JAGSoM)

2023 - 2025 · Afghanistan

Bachelor of Business Administration - Marketing & Finance - Don Bosco Institute of Management Studies, Bangalore University

2017 - 2020 · Afghanistan

Certifications

Fundamentals of Business Analysis

Starweaver, Coursera · 2024

SQL for Data Analysis

LinkedIn Learning · 2024

Data Analysis and Visualization with Power BI

Microsoft, Coursera · 2024

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceFeb 2026

Availability Details

Visa Status

Citizen

Relocation

Depends on Offer

Skills (21)

Excel Power BI Google Sheets SQL Python A/B testing Reporting Automation Dashboard Development Process Optimization Requirement gathering +11 more