
Sundaram A
Power BI Developer : HR Analyst : Tableau Developer : Visual expert
Skills

Bekijk mijn diensten

Portfolio
Werkervaring
Senior people analyst
Nielsen • Fulltime
May 2020 - Present • 6 yrs
Advanced Power BI Dashboard Development: Designed and deployed static and dynamic Power BI dashboards, incorporating advanced DAX calculations and Row-Level Security (RLS) for intricate hierarchical access control. End-to-End Data Pipeline Management: Built robust data pipelines using Data Flows and Microsoft Fabric, ensuring seamless data extraction, transformation, and loading for reporting and analysis. Automated Reporting & Data Integration: Automated key reporting processes by connecting Power BI (UDF ,TMDL) to diverse data sources, including Web APIs (e.g., ATS tools for recruitment) and Snowflake, significantly reducing manual effort. Data Modeling & Query Optimization: Developed efficient data models utilizing Star and Snowflake schemas and optimized data retrieval through complex SQL queries to enhance dashboard performance. Stakeholder Collaboration & Insight Delivery: Partnered with stakeholders to understand reporting needs, translate requirements into actionable Power BI solutions, and deliver impactful data-driven insights. Emerging Technologies & Cloud Reporting: Gained foundational experience with Microsoft Fabric and utilized AWS QuickSight for various reporting automation initiatives. Connected Data through WEB API to Power BI to automate the reports .Maintained reports using Multiple data Sources ,Automated Mail scheduled through Power BI . Worked on both Import and Direct queries and Complex DAX and relationships for better data refresh rates.