Rohit Vats

Results-driven Data Analyst with 4+ years of experience in SQL, Python, Power BI, and enterprise analytics, delivering data-driven insights and scalable reporting solutions across retail, telecom, and enterprise BI environments. Proven expertise in dashboard development, KPI reporting, exploratory data analysis, data transformation, and workflow automation. Experienced in analyzing large datasets, optimizing reporting processes, and building interactive dashboards that improved operational efficiency and business decision-making.

Strong background in SQL analytics, Python-based analysis, Power BI reporting, and stakeholder management.

Data Analyst at Impetus Via Advayan Technologies (2025-09 – 2026-03)

• Led migration of enterprise Tableau and MicroStrategy reports to Power BI, improving reporting consistency, dashboard usability, and KPI standardization.
• Built scalable reporting datasets supporting self-service analytics and standardized business reporting across multiple teams.
• Developed interactive Power BI dashboards enabling business stakeholders to monitor operational and performance KPIs in real time.
• Created advanced DAX calculations and optimized reporting logic, improving dashboard responsiveness and reducing refresh delays.
• Performed data validation, reconciliation, and quality checks ensuring high reporting accuracy across enterprise datasets.
• Collaborated with cross-functional stakeholders to gather business requirements and deliver data-driven analytical solutions.
• Collaborated with reporting teams to maintain secure and accurate access to business reporting datasets.
• Supported reporting documentation and data validation initiatives to improve reporting reliability and consistency.

Data Analyst at Infinite Analytics (2025-03 – 2025-08)

• Developed and maintained 10+ interactive Power BI dashboards delivering automated insights for retail and real-estate clients.
• Built centralized reporting datasets integrating 500k+ rows/month from marketing platforms using automated ETL workflows.
• Performed exploratory data analysis, statistical analysis, and trend analysis using Python to identify customer behavior patterns, campaign effectiveness, and revenue growth opportunities.
• Reduced manual reporting effort by 40% through automation and optimized data preparation workflows.
• Designed KPI reporting layers enabling standardized business reporting and performance tracking across multiple clients.
• Ensured data accuracy and consistency across multiple sources including Meta Ads, Google Ads, and HubSpot.
• Created executive dashboards and visual reports supporting strategic decision-making and operational planning.

Associate Software Engineer at Tech Mahindra Ltd (2021-11 – 2025-02)

• Developed ETL workflows using SQL and Python to prepare analytical datasets for reporting and dashboard development.
• Automated recurring reporting processes improving operational efficiency and data availability.
• Supported enterprise data migration projects ensuring data validation and reconciliation across systems.
• Built datasets supporting business intelligence reporting and dashboard visualization.
• Applied data quality checks and validation rules to maintain reporting reliability.
• Collaborated with cross-functional stakeholders to translate business requirements into analytical solutions.

Bachelor's Of Engineering – National Power Training Institute (2020)