Pune Division, Maharashtra, India
Data Analyst with 1.7+ years of hands-on experience translating complex datasets into actionable pricing strategies and business insights. Currently at Shipco IT, where I analyze and manage large-scale pricing data, automate reporting workflows using Excel VBA, and build Power Query pipelines that cut manual processing time significantly. During my internship at Ai Variant, I developed interactive Power BI dashboards and performed end-to-end SQL-based data extraction, cleaning, and visualization for cross-functional teams. I hold a Bachelor of Engineering and am certified in SQL (HackerRank) and Data Analytics (ExcelR). Core competencies: SQL · Microsoft Power BI · Advanced Excel & VBA · Power Query · Data Modeling · KPI Reporting · Statistical Analysis · Business Intelligence 📍 Based in Pune | Open to Data Analyst opportunities across India
●Analyze and manage pricing data for 500+ freight routes using Advanced Excel and Power Query, supporting weekly pricing strategy reviews across sales and operations teams ●Developed and deployed 3 automated VBA macros that reduced daily report generation time by ~60%, freeing up 8+ hours per week for value-added analysis ●Built Power Query ETL pipelines to ingest, clean, and standardize large datasets from multiple source systems, improving data accuracy for monthly pricing reports ● Collaborated with cross-functional stakeholders across sales, finance, and operations to translate pricing data into actionable business recommendations ● Identified pricing anomalies and data inconsistencies through root-cause analysis, preventing revenue leakage and improving data integrity
Query and extract data from databases using SQL, Develop interactive dashboards and reports using tools like Power BI, Advanced Excel, Macros, Power Query