Ashish

Data Analyst

Cognizant Technology Solutions

Jun 2023 - Present

Developed interactive dashboards using Power BI and Tableau, enabling business leaders to monitor KPIs and performance metrics in real time. Wrote complex SQL queries involving Joins, CTEs, Window Functions, Views, Stored Procedures, and Aggregations to analyze large datasets. Automated recurring business reports using SQL, Excel, and Power BI, reducing manual reporting efforts by 40%. Performed data extraction, cleansing, validation, and transformation from multiple data sources. Conducted exploratory data analysis (EDA) using Python (Pandas & NumPy) to identify trends, anomalies, and business opportunities. Collaborated with business stakeholders to gather reporting requirements and convert them into analytical dashboards. Designed KPI dashboards for sales, revenue, customer performance, and operational metrics. Improved SQL query performance and optimized database reporting processes. Prepared weekly, monthly, quarterly, and ad-hoc reports for senior management. Supported business decision-making through data-driven insights and trend analysis. Maintained data quality and ensured reporting accuracy across multiple business functions. Supported business teams with analytical insights for forecasting, budgeting, and operational planning. Ensured data governance, data validation, and reporting accuracy across enterprise reporting systems.