My proficiency in Power BI, SSRS, and SQL enables me to create dashboards and visualizations tailored to drive business insights. I specialize in developing data visualizations, including BarCharts, PieCharts, LineCharts, and more, using Power BI’s query editor and Power Pivot for comprehensive data analysis and modeling.My role encompasses thorough requirement analysis and documentation, leveraging UML methodologies in MS Visio to craft detailed use cases and diagrams. I excel in designing and building interactive dashboards and reports, utilizing advanced Power BI features like action filters, parameters, calculated sets, and DAX queries. Experience includes writing SQL queries to extract and analyze critical data, including patient information, ensuring accurate and insightful reporting.I am adept at dataintegration and transformation, importing data from various sources such as SQL Server and Azure SQL Database, and setting up automated data refreshes through Power BI Gateways to maintain data accuracy and timeliness. Leading User Acceptance Testing (UAT) sessions, I document feedback, report bugs, and collaborate with development teams to resolve issues, supporting UAT and regression testing with BRD and FRD documentation.In stakeholder collaboration, I engage with end users, SMEs, and developers to gather and document business requirements and project objectives. My commitment to data governance and security is evident through my management of report access and data sharing using Power BI Apps and implementing robust access controls.andvisualization solutions while enhancing existing Power BI dashboards to meet evolving business needs. My advanced data manipulation skills include creating calculated columns, managing relationships, and refining data presentation with various filter levels. I explore data to uncover trends and insights, supporting strategic decision-making and driving continuous improvement aligned with organizational goals.

Created dynamic visualizations including Bar, Clustered Column, Waterfall, Gauge, Pie Charts, and Tree maps.Utilized Power BI gateway for real-time data updates from on-premise sources and implemented drill-down and drill-through reports based on hierarchy.Utilized Power Query to pivot and un-pivot data for cleansing and transformation.Secured reports using Row-Level Security (RLS) and DAX filters.Developed new calculations and KPIs, such as average product life and profit margins, using DAX in SSAS. Continuously analyzed existing KPIs, reports, and dashboards to identify and close gaps with stakeholder needs. Improved SQL queries to reduce procedure runtime from 5 minutes to 60 seconds.Created and optimized SSIS packages for daily ETL operations, incorporating error handling andslowly changing dimensions.Designed and deployed complex SSIS packages with tasks like Execute SQL, Bulk Insert, Data Flow, FTP, and Send Mail.Designed and built multidimensional cubes with star schema using SQL Server Analysis Services SSAS.Developed SSAS solutions with multiple dimensions, perspectives, hierarchies, measure groups, and KPI Configured Integration Runtime(IR)for data migration from on-premise to the cloud.Automated resource creation using PowerShell scripts.Worked with Azure Data Warehouse, leveraging PolyBase to load data from Azure Data Lake.Developed SSRS reports with complex T-SQL/P-SQL queries for joins, unions, aggregations, and expressions.Extracted and processed data from internal data warehouses and external sources like Salesforce and Teradata.Designed stored procedures, queries, and views to support SSRS reports.Developed and managed data integration and ETL solutions using SSIS, including deployment and performance optimization.Implemented event handlers, error handling, for SSIS packages.Wrote SQL queries, stored procedures, triggers, views, cursors, and user-defined functions.Participated in SIT, UAT testing, bug fixing, and created detailed tech documentation

• Data Gathering and Import: Gathered and imported data into SQL Server databases; created database objects like tables, user-defined functions, and cursors using DDL and DML statements.• Power BI Development: Extracted and transformed data from various data sources using Power BI Desktop and Power Query Editor; cleaned data with advanced Power Queries.• Report and Dashboard Design: Designed and developed reports and dashboards for analytics, including data modeling, report creation, and data investigation through Power BI.• Data Visualization and Interactivity: Developed rich visualizations such as Pie, Line, Bar, Donut, Bubble, and Stacked Bar Charts using Power BI; created interactive reports using Drill-Down, Drill-Through, and various filters (Visual Level, Page Level, Report Level).• DAX Functions and Performance Tuning: Used DAX functions like Table, Aggregation, and Date and Time functions for data analysis; performed troubleshooting and performance tuning of reports.• Publishing and Scheduling: Published reports to Power BI Services, set up necessary connection details, and scheduled data refreshes.• ETL Development with SSIS: Designed and developed ETL packages using SQL Server Integration Services (SSIS), involving data extraction, transformation, and loading; created multiple SQL jobs to automate SSIS package execution.• SSIS Tasks and Error Handling: Extensively used various SSIS tasks and transformations; implemented error handling, error logging, checkpoints, breakpoints, and configuration for SSIS packages.• Report Development with SSRS: Created detailed reports including Drill-Down, Drill-Through, Chart, and Sub Reports using SQL Server Reporting Services (SSRS).

• Database Triggers and Integrity: Developed database triggers to enforce data integrity and maintain referential integrity across multiple tables.• Process Design and Documentation: Designed process flow charts and office layouts using Visio to support business users and professionals.• SQL Development and Data Management: Created SQL reports and data extraction/loading scripts for multiple databases and schemas; developed complex SQL queries using joins and database links to fetch data from remote databases; formatted results into reports and maintained logs.• Performance Optimization: Optimized DTS package queries and stored procedures using SQL Profiler and Query Analyzer; involved in performance tuning and monitoring of T-SQL blocks.• ETL Process Management: Managed the entire ETL process, including data access, manipulation, analysis, interpretation, and presentation to stakeholders.• T-SQL and Reporting Services: Wrote T-SQL procedures to generate dynamic DML scripts; developed reports using SQL Server Reporting Services (SSRS).• Database Administration: Performed comprehensive database administration tasks including data modeling, backups, and recovery.