Kavya M Email & Phone Number

Canada

Ontario, Canada

➢ Experienced Power BI Developer with a strong background in designing and implementing interactive dashboards and data visualizations, translating complex data into clear, actionable insights. ➢ Responsible for gathering requirements, coordinating efforts to design the data warehouse and data analytics solutions. ➢ Designed and developed interactive reports and dashboards using Power BI and Tableau, effectively visualizing KPIs and business metrics to meet stakeholder requirements ➢ Collaborated with Data Stewards and Data Curation Engineers to prepare data for visualization, ensuring high-quality, accurate reporting by validating and cleansing datasets ➢ Interpreted complex data models and developed queries in SQL and Spark SQL to pull and aggregate data, enabling actionable insights and efficient reporting ➢ Monitored and maintained reporting systems to ensure data accuracy, completeness, and timeliness, proactively identifying and addressing any discrepancies in the reports ➢ Utilized curated data to build dashboards, aligning with organizational goals and reporting requirements to enhance decision-making processes ➢ Applied UI/UX best practices in dashboard design, enhancing user experience and engagement by ensuring clear and intuitive data visualization ➢ Engaged with business stakeholders to gather feedback and iteratively improve visualizations and metrics, ensuring reports align with business needs and goals ➢ Conducted exploratory data analysis to uncover patterns, trends, and insights, aiding in business decision-making and identifying opportunities for optimization ➢ Applied version control techniques to track and manage changes to reporting systems, ensuring consistency and traceability in all dashboard and report development efforts

Hyderabad, Telangana, India

➢Used Oracle, SQL Server, Excel, Azure Synapse as Data sources and prepping data (SQL) at the background to create reports suggested users about visualizations, colors, themes and following best practices to make a dashboard look the best.➢Monitoring and identifying problem queries by using third party tool ignite. Query optimization for SQL server.➢Responsible for all QA, staging and production releases. Well versed with Time Intelligence functions for creating reports based on Historical Data such as YTD, MTD, Previous Year etc.➢Wrote Advanced Calculations in DAX and Power Query to support the Dashboard requirements.➢Worked on Identifying Slow running Stored Procedures and tuning them using Performance tuning techniques and optimizing the queries by Identifying bottlenecks.➢Setup and monitoring SQL server mirroring and replications➢Using SQL queries, test and validate database tables in relational databases, as well as execute Data Validation and Data Integration.➢Generated snapshot reports based on the statistical analysis of the change data from various time frame using SSRS.➢Experienced in generating report elements for consolidated financial statements for the annual report using claims and under writing data.➢Generated various reports like parameterized reports, bar graphs using stored procedures in SSRS.➢Involved in creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.