Renusri V

• Experienced SQL and Power BI Developer with 3.7 years of expertise in designing and implementing data-driven solutions.
• Expertise in gathering and understanding requirements from end-users and stakeholders.
• Proficient in managing relationships with stakeholders and ensuring alignment on project goals and expectations.
• Utilized Power BI to build interactive and visually appealing dashboards and reports.
• Proficient in integrating data from multiple sources in Power BI, including SQL databases, Excel, and cloud services, for creating unified, insightful reports and dashboards.
• Transformed raw data into valuable and meaningful insights in the form of appealing dashboards and reports.
• Proficient in DAX for creating complex calculations and measures to drive insightful data analysis and reporting in Power BI.
• Implemented data models in Power BI, leveraging its capabilities for visualizations and data analysis.
• Developed and maintained scalable data models for Sales performance and healthcare analytics using SQL Server and Power BI.
• Developed visual reports, key performance indicators (KPI) scorecards, and dashboards using Power BI desktop.
• Experienced in using Power Query for data transformation and cleansing, enabling efficient data preparation and automation within Power BI reports.
• Created calculated columns and measures to enhance data models and enable complex analytics within Power BI.
• Implemented and managed Power BI gateways to ensure secure and efficient data refresh and connectivity between on-premises data sources and Power BI service.
• Published reports to Power BI Service, configured workspaces, and automated data refresh schedules.
• Implemented row-level security in Power BI workspaces depending on the type of access required. Maintained data refresh schedules of published datasets.
• Developed and optimized relational database designs and complex SQL queries for seamless data integration, reporting, and performance improvement, ensuring efficient data management across multiple systems.
• Integrated Power BI with SQL Server and other relational databases, automating data refresh and synchronization processes.
• Utilized advanced SQL Server join operations to efficiently combine and analyze data from multiple tables, enhancing data integrity and query performance in complex database environments. Used SQL Server for database design, indexing, and query optimization.
• Expertise in identifying, troubleshooting, and resolving data discrepancies in large datasets using SQL and Power BI.
• Wrote SQL queries, stored procedures, views, functions based on the requirements.
• Skilled in utilizing DDL commands for database structure management and DML commands for efficient data manipulation.
• Implemented and managed SQL constraints to ensure data integrity and enforce business rules across multiple database tables.
• Applied common table expressions (CTEs) to simplify complex queries and improve readability in data retrieval processes.
• Designed and optimized complex SQL Server views for data abstraction and performance improvement, enhancing query efficiency and simplifying data access for business users. Implemented database constraints to enforce data integrity and consistency across tables.
• Proficient in using the RANK function in SQL and DAX for dynamic data ranking, enabling advanced analytical insights and performance comparisons in reports. Capable of managing tasks and projects autonomously with minimal supervision.
• Applied SQL Server functions to manage NULL values for data integrity and accurate reporting, while using ranking functions to assign and analyze ranks within datasets for advanced data insights and comparative analysis.
• Skilled in creating and managing SQL views to simplify complex queries, enhance data security, and improve performance by presenting streamlined, reusable data sets.

Certificate for Business Intelligence using Power BI - Skill Notion