Rohit Saraswat

Data Analyst and Power BI Developer with experience in data analysis, data visualization, data transformation, reporting, dashboard development, and data modeling. Skilled in Power BI, Power Query, Advanced Excel, SQL Server, Python, Pandas, and NumPy. Experienced in preparing multi-source data, building interactive dashboards, creating data models, identifying trends, and delivering actionable insights for business and operational decision-making.

POWER BI DEVELOPER - GrowingSeed Technologies Pvt. Ltd.

(2023-12 - 2024-05)

• Collected, cleaned, transformed, and prepared raw data using Power Query for analysis and reporting.
• Developed interactive Power BI dashboards and reports for business data and key metrics.
• Designed data models and established relationships between datasets for efficient reporting.
• Connected Power BI with Excel and SQL Server data sources.
• Created data-driven visualizations to identify trends and support actionable insights.
• Published reports to Power BI Service and configured scheduled data refreshes.

ANALYST - Mcgeeks Mechatronics Pvt. Ltd.

(2019-09 - 2021-04)

• Used Advanced Excel functions including VLOOKUP, INDEX-MATCH, and Pivot Tables to clean, process, and analyze raw data.
• Performed calculations, forecasting, and trend analysis using Excel formulas.
• Designed interactive dashboards using charts, slicers, and conditional formatting.
• Applied data validation and consistency checks to improve data accuracy.
• Established relationships between datasets and optimized data models for reporting performance.
• Cleaned, merged, and transformed data from multiple sources before visualization.
• Developed Power BI dashboards and published reports to Power BI Service with scheduled refreshes.

M.Sc. - Mathematics - Dr. Bhimrao Ambedkar University, Agra (2017)

B.Sc. - Science - Dr. Bhimrao Ambedkar University, Agra (2015)

HSC - Gandhi Inter College, Mathura (2011)

SSC - K. R. Inter College, Mathura (2009)