Pragya Joshi

Business Analyst | Data Analytics Specialist

Delhi, IN.

About

Results-driven Business Analyst with 1 year of experience at E-Sutra Technologies, adept at leveraging SQL, Power BI, and Excel to transform complex data into actionable business insights. Proven ability to enhance data quality and reporting accuracy by 40-50%, streamline cross-functional workflows, and accelerate feature rollouts. Eager to apply strong analytical skills and project coordination expertise to drive strategic decisions and optimize operations in a dynamic environment.

Work

E-Sutra Technologies

|

Business Analyst Intern

Delhi, Delhi, India

→

Summary

Currently serving as a Business Analyst Intern, responsible for translating business needs into technical specifications and actionable insights. This role involves extensive data analysis, dashboard development, and cross-functional collaboration to optimize product development and operational efficiency.

Highlights

Documented business requirements through stakeholder interviews and market research, aligning system specifications with business goals and reducing iteration cycles.

Developed interactive dashboards using Power BI and Excel to monitor product usage, user engagement, and key business metrics, enhancing stakeholder visibility by 50%.

Authored and optimized complex SQL queries to extract, analyze, and validate data for reporting, improving data integrity by 40% for both routine and ad-hoc business needs.

Translated product requirements into actionable user stories and workflows within Jira, streamlining cross-team collaboration across design, development, and QA teams.

Maintained and prioritized product backlogs, significantly improving delivery predictability and boosting stakeholder satisfaction.

Collaborated in Agile ceremonies, including sprint planning and retrospectives, to track KPIs, resolve blockers, and accelerate feature rollout.

Created wireframes and product roadmaps with UI/UX designers, ensuring the development of user-centric and scalable solutions.

Synokem Lifesciences

|

Analyst Intern

Haridwar, Uttarakhand, India

→

Summary

Contributed as an Analyst Intern, focusing on critical data collection, validation, and analysis to support quality control and production metrics. This role involved developing standardized reporting tools to facilitate informed decision-making for batch releases.

Highlights

Collected, validated, and analyzed large datasets of quality control and stability data using Excel and lab-generated reports, ensuring data accuracy for critical decisions.

Developed standardized Excel templates for tracking test results, expiry trends, and production metrics, directly supporting efficient batch release decisions.

Volunteer

DataKit Economic Opportunity Volunteer

|

Datakind

→

Volunteered with an online community to analyze socioeconomic and financial inclusion datasets from various countries, contributing to data-driven insights and visualizations.

Highlights

Analyzed datasets related to socioeconomic and financial inclusion problems across different countries, leveraging data analysis and visualization techniques.

Contributed to understanding complex global challenges by transforming raw data into meaningful insights for community impact.

Education

Gurukul Kangri University

Haridwar, Uttarakhand, India
→
Master of Science Science Grade: CGPA: 8.5/10

Certificates

SQL Bootcamp

Datanaalystduo

Programming for Everybody (Getting Started with Python)

Coursera

SQL Course Beginners Guide

freecodecamp

Power BI Essential Training

LinkedIn Learning

Excel Managing and Analyzing Data

LinkedIn Learning

Skills

Competencies

Agile Methodologies, SDLC, Requirement Gathering, User Stories, Cross-functional Collaboration, Project Management, Stakeholder Management.

Programming Languages

SQL (EDA, Data Cleaning, Data Extraction, Query Optimization), Python (Basic Scripting).

Tools & Platforms

Power BI (Data Visualization, Dashboard Development), Jira, Lucidchart, Notion, CRM, MS Excel (Aggregate, Count, Dashboard, Power Query, Pivot Tables), Tableau (Inferred from Data Visualization skills).

Data Analysis

Exploratory Data Analysis (EDA), Data Cleaning, Data Validation, Statistical Analysis, KPI Tracking, Performance Analysis, Customer Behavior Analysis, Product Performance Analysis.

Projects

HR Analytics Project

→

Summary

Developed an HR analytics solution to track attrition-related KPIs and provide data-driven policy recommendations.

Sales Performance Analysis

→

Summary

Analyzed regional sales data to assess product performance and identify risk-prone customer segments.

Retail Sales Data Analysis

→

Summary

Conducted a detailed analysis of retail sales data to understand customer behavior, product performance, and sales trends.