Alu Raja

Data Analyst

Cognizant Technology Solutions India Pvt. Ltd

May 2022 - Present

Designed and maintained interactive Power BI dashboards and reports, integrating multiple data sources and leveraging advanced DAX calculations to track KPIs and enable real-time business insights. Extracted and analyzed large datasets using Microsoft SQL Server; wrote complex queries (JOINs, GROUP BY, subqueries) and optimized performance, improving report accuracy and speed. Developed robust data models (star schemas) and data warehousing solutions to support reporting; documented schema and data lineage to ensure consistency. Built automated Excel reports (PivotTables, XLOOKUP/VLOOKUP, conditional formatting) to supplement BI dashboards, reducing manual reporting by 50%. Implemented ETL processes and data cleansing workflows using Power Query and SQL (SSIS) to import, transform, and validate data from disparate sources, ensuring high data integrity. Partnered with business stakeholders to gather and document requirements, translating them into analytical solutions (reports, dashboards) that supported project objectives. Presented analytical findings and trends through clear visual reports and executive presentations, enabling leadership to make data-driven decisions (e.g., identifying a $2M savings opportunity via spend dashboard). Identified opportunities for automation and process enhancements (e.g., automating weekly reports) to increase efficiency by 20% and improve data quality. Created charts (line, bar, pie, scatter, map, funnel, cards, etc.) to convey insights; ensured visual best practices. Presented findings to technical and non-technical audiences through reports and presentations; highlighted KPIs and trends for leadership. Tracked project status and metrics; identified process improvements and automated reports to increase efficiency.