Data Analyst• Expertise in data mining by using various technologies like MS -Power BI, SQL Server, MS Excel (Advance Excel and VBA)• Excellence in BI reporting solutions through Microsoft Power BI as well as in Data Extraction and Power Query for Data Transformation.• Excellence in performing analysis of large data sets with the purpose of gathering business insights and facilitating the management in decision-making process.• Skilled in converting existing excel reporting into Power BI Dashboards i.e. SLA & AHT Dashboard, Quality Dashboard, Attrition Report, HC Report, Shrinkage Report, Avaya CMS Reporting (SLA Metrics Reporting), and others.• Know-how in development and automation on RPA tools like Automation Anywhere 10.2 and UiPath.• Strategized/ developed Star & SnowFlake Data Model in PowerBI desktop; created Gateway Services to plan the data refreshing on daily, weekly, half- hourly or hourly basis.• Experience in Workspace Management with Refresh schedule, Data Export CSV file, managing user roles, Permissions, Licensing, capacity, Assign Roles and Row level Security with proper access. • Experience in SQL with Transform Raw Data into Clean Data Pipelines, subqueries, nested Queries, various join types (INNER, OUTER, LEFT, RIGHT, FULL, CROSS JOIN, Common table expressions, used control flow statements (IF/ELSE), CASE statements, UNION AND UNION ALL.• Good Experience in DAX Language with Filter Functions, Aggregation Functions, Date and Time Functions, Logical Functions, Time intelligence functions, Row Context and Filter Context.• Good Experience in Advance Excel reporting & Dashboards.• Expertise in reporting Automation & VBA, Macros, custom functions .
