Prem Kumar

Business Analyst and Project Management fresher (BBA, 2024) with hands-on, self-driven experience in data analytics, process optimization, requirements gathering, and stakeholder reporting. Built an end-to-end Power BI sales dashboard on a 1,000-record, ₹5.12 Cr dataset, applying ETL, DAX, and KPI design to surface actionable business insights.

Google Project Management

Certified with applied experience in Agile/Scrum ceremonies, RAID and risk tracking, BRD-style requirements documentation, and cross-functional stakeholder communication. Skilled in Power BI, Advanced Excel, SQL fundamentals, and structured problem-solving (root-cause analysis, SWOT). Seeking an entry-level Business Analyst or Project Management role to apply data-driven decision-making and process improvement skills in a fast-paced team environment.

Business Analyst / BI Developer at TechyStore

Self-Directed Data Analytics Project

• Built a full ETL pipeline and interactive Power BI dashboard on a 1,000-row sales dataset spanning ₹5.12 Cr in revenue, 10 product categories, 28 states, and 3 sales channels — translating raw transactional data into a single-page executive reporting tool.
• Engineered 4 core DAX KPI measures (Total Sales, Quantity Sold, Transactions, Average Transaction Value) and structured the data model with proper dimension/measure classification and date hierarchy for time-intelligence reporting.
• Identified top-performing SKUs via clustered bar chart analysis — found that 3 products drove 32.5% of total revenue — enabling inventory prioritization recommendations.
• Uncovered seasonal demand patterns through trend analysis, flagging a 26% above-average revenue spike in December and identifying Tuesday/Friday as peak sales days to inform staffing and promotional scheduling.
• Analyzed payment and channel data to find a 77.5% digital payment adoption rate and a 6-point AOV gap between In-Store and Direct channels, surfacing recommendations for checkout strategy and channel resource allocation.
• Designed 4 interactive slicers and a month-range filter enabling self-service analytics for non-technical stakeholders without additional IT support.

Project Coordinator at Office Green

Process Optimization Capstone, Google PM Certificate

• Managed all 5 project lifecycle phases (initiation, planning, execution, monitoring, closure) for a simulated business expansion initiative, applying PMBOK-aligned governance and Agile sprint cycles.
• Defined project scope and KPIs to track operational performance across 3 cross-functional departments, and built Excel-based dashboards to monitor 20+ deliverables and on-time delivery rate.
• Led stakeholder analysis and weekly status reporting, improving visibility into task progress and reducing process redundancy through structured workflow redesign.

Business Analyst / Project Coordinator at Sauce & Spoon

Business Growth Strategy Capstone, Google PM Certificate

• Analyzed 6 months of sales and customer engagement data to identify 3 root-cause operational inefficiencies impacting revenue, using structured root-cause analysis and data storytelling.
• Modeled a 15% potential gross margin improvement through cost-reduction and supplier management strategies, presented as stakeholder-ready financial projections.
• Built 12-month financial projections and market analysis reports in Excel and PowerPoint, and presented findings to a simulated leadership panel, coordinating input across 4 teams.

Bachelor of Business Administration in BBA – Ilead, Kolkata (2020-01 – 2024-12)