PRERNA PRAKASH
Business Analyst
Pune,Maharashtra
Summary
Detail-oriented Business Analyst with extensive experience in data analytics and operations, adept at leveraging analytical tools and methodologies to drive performance improvements and optimize business processes. Expertise in providing actionable insights, streamlining operations, and supporting strategic decision-making initiatives. Proficient in MS Excel, SQL, Power BI, and PowerPoint for comprehensive data-driven analysis and impactful presentations. Recognized as a strong communicator and problem solver, equipped with a keen analytical mindset to effectively tackle complex challenges.
Overview
4
4
Certifications
5
5
years of professional experience
Work History
Analyst II
Cozmo Logistics
02.2025 - Current
- Designed and implemented individual Power BI dashboards for G-9 Overall and ABY Packing, ensuring they effectively visualize key metrics and monitor overall performance.
- Developed a team management dashboard for top management to monitor and measure team deliverables, assess progress, and identify and address key challenge.
- Used SQL for data extraction and power query to automate data manipulation combined with auto refresh on dashboard, enabling real-time updates saving 45 mins daily.
- Analyzed complex datasets to inform strategic decision-making and enhance operational efficiency.
- Developed comprehensive reports that supported management in identifying trends and optimizing processes.
- Collaborated with cross-functional teams to streamline data collection and improve accuracy of insights.
- Utilized advanced analytical tools to conduct thorough evaluations, driving informed actions and outcomes.
- Presented findings to stakeholders, facilitating data-driven discussions and aligning project objectives.
- Mentored junior analysts, fostering skill development and enhancing team performance on data projects.
Business Analyst
Ecom Express
08.2022 - 11.2024
- Oversaw Pan India performance analysis for 3000+ delivery hubs, identifying key operational issues such as escalations, fake attempts and providing data-driven recommendations.
- Developed a Power BI dashboard for performance tracking of delivery executives covering more than 5000 executives, analyzing shipment allocation, customer matrix and probable per shipment costs.
- Created Management Reports at State and Zonal Level focusing on key matrices such as slippage, Return to Origin, Net Promoter Scores, Conversion and Cost Per Shipment.
- Analyzed complex data sets to identify trends, providing actionable insights for strategic decision-making.
- Collaborated with cross-functional teams to refine processes, enhancing operational efficiency and accuracy.
- Developed comprehensive reports to communicate findings, enabling stakeholders to understand data-driven recommendations.
- Utilized advanced analytical tools to assess business performance, supporting continuous improvement initiatives.
- Monitored key performance indicators, identifying opportunities for optimization within existing frameworks and processes.
- Supported project management efforts by tracking project timelines and deliverables, enhancing team accountability.
Business Analyst
Flipkart
08.2021 - 08.2022
- Collaborated with on ground teams to address process gaps, analysing the end-to-end seller pickup process to reduce the mixed bagging percentage from 28% to less than 10 %.
- Created Excel dashboard for hub level tracking of delivery executive's performance in real time and taking corrective action before the end of the day resulting in improved conversion and reduced fake.
- Conducted market research to inform business strategies, contributing to improved project outcomes and competitive positioning.
- Facilitated stakeholder workshops to gather requirements, ensuring alignment on project objectives and deliverables.
- Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.
- Developed high-quality documentation to support training efforts, helping employees fully understand new systems and procedures.
- Performed gap analysis between existing systems or processes and desired state, identifying areas for improvement or enhancement.
- Improved business processes by analyzing current practices and recommending optimization strategies.
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
Data Analyst Intern
Intello Transpo
05.2021 - 07.2021
- BI technologies (Excel & PowerBI) were used along with SQL to deliver real time data insights.
- Produced performance reports in Advanced Excel increasing the efficiency by 50%.
- Designed data flows which led in increasing data quality by 40% and reducing errors by 50%.
- Analyzed large datasets to identify trends, enhancing decision-making processes across departments.
- Developed and maintained dashboards using data visualization tools, improving reporting efficiency.
- Collaborated with cross-functional teams to gather requirements, ensuring data integrity and accuracy.
- Automated routine data collection processes, significantly reducing manual entry errors and saving time.
- Conducted data quality assessments, identifying discrepancies and implementing corrective actions to ensure reliability.
- Supported project teams by providing actionable insights derived from data analysis, fostering informed decisions.
- Engaged in data cleaning and preprocessing, preparing datasets for analysis and improving overall data quality.
- Presented analytical findings to stakeholders, translating complex data into easy-to-understand reports.
Education
Bachelor - Journalism and Mass Communication
Indian Institute of Mass Media and IT
05-2021
Skills
Team collaboration
Strong focus on accuracy
Strategic issue analysis
Effective Communication
Variance reporting
Stakeholder collaboration
Evidence-based decision making
Data analysis
Power BI data visualization
SQL data analysis
User-focused dashboard development
Data visualization
Performance assessment
Accomplishments
- Gladiator Award: Ecom Express, 2023
- Gladiator Award: Ecom Express, 2022
- Shining Star Award: Flipkart, 2021
Certification
Power BI (Beginner Level), LinkedIn, 2023
Timeline
Analyst II
Cozmo Logistics
02.2025 - Current
Business Analyst
Ecom Express
08.2022 - 11.2024
Business Analyst
Flipkart
08.2021 - 08.2022
Data Analyst Intern
Intello Transpo
05.2021 - 07.2021
Bachelor - Journalism and Mass Communication
Indian Institute of Mass Media and IT