Priya Suman

Background

About Priya Suman

Hello, thank you for visiting my LinkedIn. My name is Priya Suman, Analyst at Dell International Services India Pvt Ltd Hyderabad (from January 2022 - Present), I have listed below my day at work : · ·Designed and developed advanced Power BI dashboards with DAX measures, calculated columns, and Power Query (M) transformations to drive decision-making across product and sales teams in AMER, EMEA, and APJ regions. · Performed data modeling, schema design, and relationship building to support robust, scalable BI solutions using star/snowflake models and fact-dimension structures. · Collaborated with product managers, sales representatives, and regional leads to gather and refine reporting requirements, aligning analytics initiatives with broader business goals. · Automated and streamlined reporting workflows using ETL processes, SQL, Power Query, and Excel, ensuring clean, reliable, and consistent data across pipelines. · Built and optimized SQL queries to extract, transform, and analyze large datasets from relational databases to support ad-hoc analysis and regular performance tracking. · Utilized Excel (pivot tables, charts, VLOOKUP/XLOOKUP, arrays) to generate interim reports and troubleshoot data before visualization or transformation. · Implemented solutions using Power Platform tools (Power BI, Power Automate) to automate reporting, enhance productivity, and reduce manual intervention. · Supported ongoing improvements to BI infrastructure, including knowledge of SSAS concepts such as cube design, dimensions, and KPIs. · Resolved 30+ tickets weekly related to POC mapping, warranty delays, and data discrepancies by performing root cause analysis and delivering actionable insights. Achievement: Automated 40% of the SKU Product Offering Code (POC) assignment process, reducing task completion time from 5 days to 3.5 days and increasing operational efficiency.