Prachi Holkar Email & Phone Number

United States

• Developed Power BI dashboard by extracting and integrating data from multiple sources for analysis of course pricing, leading to recommendations for redefinition of pricing strategies aimed at optimizing future revenue generation.• Conducted ad-hoc analysis using SQL to generate reports on language and geographic diversity.• Analyzed survey data using qualitative and quantitative methods to derive insights on webinar.

• Designed Google Analytics reports & dashboards providing actionable business insights of registration and participation rates of healthcare professionals, leading to a 73% increase in conversion from registrants to participants for webinars.• Facilitated the Nursing Activity Reporting System (NARS) accreditation by generating online/ enduring participation metrics through Learning Management System (LMS) reports, enabling effective tracking of nursing education activities and enhancing overall accreditation outcomes.• Engaged with Learning & Development and Research teams to create course surveys capturing insights on webinar topics, participant satisfaction rate, and speaker evaluations to improve future training.

• Created Power BI dashboard to visualize small business activity and storefront registry data from the Dept. of Finance, uncovering key trends enabling the team to deliver targeted advice hence, enhancing small business engagement by 15%.• Performed research for the Small Business Team to ensure the team remained informed of policy changes & utilized Canva to create informational pamphlets for small business owners.

Navi Mumbai

• Led a team to create innovative Google Analytics dashboards and reports to replace an Excel-based performance monitoring system, achieving a remarkable 46% increase in product delivery efficiency.• Developed SQL queries by creating complex joins, and eliminating redundant subqueries, reducing data retrieval time by 26%, and enabling faster, more accurate generation of product usage reports for enterprise clients.• Leveraged advanced Excel functions, including pivot tables, VLOOKUP, XLOOKUP, and charts, to interpret data and analyze quarterly deliverables, ensuring a thorough team performance evaluation.• Delivered 30+ bug-free enterprise projects by gathering requirements, creating functional specifications, and collaborating with Marketing, UI/UX, Product, and Business teams to meet customer-centric needs on time.

Mumbai, Maharashtra, India

• Developed and enhanced test cases to ensure comprehensive and effective manual testing, optimizing success rates.• Collaborated with senior analysts in test planning, defect identification, and resolution support, contributing to bug-free product delivery through testing and analysis.

Master'S Degree, Information Systems

Bachelor Of Technology - Btech, Computer Science