Param Barot

Data Analyst with 1+ year of hands-on experience in data analysis, business intelligence, financial reporting, sales analytics, and MIS reporting. Skilled in SQL, Power BI, DAX, Power Query, Python, Advanced Excel, data cleaning, data transformation, and data visualization. Experienced in extracting and analyzing data from SAP, Ornate, and Bitrix24 CRM, developing interactive Power BI dashboards, streamlining management reporting, and translating complex datasets into actionable business insights for senior stakeholders.

Strong in KPI analysis, trend analysis, variance analysis, and root cause analysis, with experience supporting data-driven decision-making and coordinating cross-functional project activities.

Data Analyst & Project Coordinator (PMD) - Harit Zaveri / RBZ Jewelers - Ahmedabad, India

(2025-12)

• Analyze sales, financial, operational, procurement, and project data to generate actionable insights and support data-driven decision-making for senior management.
• Extract and analyze jeweler sales and inventory data from Ornate to evaluate product and category performance, sold and unsold inventory, and long-pending stock.
• Extract and analyze purchase order, expense, and financial data from SAP to prepare management reports and business insights for the CMO, CFO, and Strategic General Manager.
• Develop and maintain MIS reports by transforming raw sales, financial, operational, and project data into structured, management-ready reports.
• Perform KPI analysis, trend analysis, and variance analysis to identify performance patterns, business gaps, and areas requiring management attention.
• Use Power BI and Advanced Excel to analyze, visualize, and present business data through interactive dashboards and decision-ready reports.
• Consolidate data from multiple business sources to support financial reporting, sales analysis, inventory monitoring, and operational performance tracking.
• Coordinate retail-store projects by monitoring timelines, deliverables, dependencies, procurement activities, and cross-functional tasks to support effective project execution.
• Analyze BOQs, project costs, and procurement requirements to support cost estimation, budget monitoring, procurement coordination, and project planning.
• Generate and process Purchase Orders (POs) and coordinate procurement activities within the Project Management Department.

Data Analyst / Research Analyst Intern - ID Talents - Ahmedabad, India

(2025-05 - 2025-12)

• Developed Power BI dashboards and analytical reports to present KPIs, trends, performance indicators, and actionable business insights to the General Manager and Director.
• Performed data cleaning, validation, reconciliation, and transformation using Advanced Excel, VLOOKUP, Pivot Tables, and structured data-processing techniques to maintain data accuracy and consistency.
• Analyzed multi-source datasets to identify trends, patterns, business opportunities, and performance indicators supporting data-driven decision-making.
• Prepared recurring management reports and business insights by consolidating CRM, Excel, and research data into clear and decision-ready formats.
• Conducted company, contact, and organizational research to support lead generation, prospect identification, and accurate business data management.
• Validated and maintained prospect and company information collected from multiple sources, ensuring reliable and organized datasets for business development activities.

Master of Computer Applications - MCA - Indus University (2027)

Bachelor of Computer Applications - BCA - Indus University (2022 - 2025)