Shashank

Data Analyst

Geniecredit Consultant Pvt Ltd

Aug 2023 - Present

Clients Supported: Tata Consultancy Services, Wipro Pvt Ltd, RMSI Pvt Ltd. Built automated Power BI dashboards and Excel reports for sales performance tracking, increasing reporting speed and accuracy by 15%. Extracted, cleaned, and transformed large multi-source datasets using SQL and Power Query to improve consistency and reliability. Developed optimized SQL queries that reduced data retrieval and processing time by 30%. Conducted statistical and trend analysis to support quarterly planning and sales strategy decisions. Collaborated with business teams to define requirements, ensure data quality and maintain scalable documentation. Analyzed HR datasets using SQL and Python to identify gender representation, pay gaps and department-wise workforce patterns. Automated HR reporting workflows using stored procedures, reducing manual processing time by 40%. Designed interactive Power BI dashboards to visualize diversity, compensation trends and workforce distribution. Cleaned, validated, and standardized HR datasets to ensure high accuracy for leadership reporting. Partnered with HR managers to translate insights into actionable recommendations for equity and workforce planning. Developed a Power BI dashboard to analyze profit performance across regions, states and cities with granular drill-downs. Identified top and bottom 10 cities using DAX-based calculated fields, KPI indicators and trend measures. Built maps, treemaps, and time-series visualizations to support strategic profit improvement discussions. Applied structured business analysis to clarify objectives, stakeholder expectations and reporting requirements. Delivered insights that guided operational decisions and contributed to targeted regional profitability gains.