M Jayachandra

Skilled Business Intelligence (BI) Developer with 6.5+ years of strong experience in Power BI and Qlik Sense, with a proven track record of building scalable, interactive dashboards, and driving business insights through data. Extensive experience in Power BI, including: Designing data models using star and snowflake schemas for optimal performance. Developing complex DAX measures for KPIs, YoY comparisons, dynamic titles, cumulative totals, and time intelligence calculations. Creating custom visuals, drill-through, bookmarks, tooltip pages, and navigation buttons for user-friendly report interactivity. Using Power Query Editor for robust data transformation (M language), merging, appending, and shaping data from multiple sources. Implementing Row-Level Security (RLS) to control data access based on user roles. Publishing reports to Power BI Service, configuring scheduled refreshes, and managing datasets, dataflows, and workspaces. Integrating Power BI with Excel, SharePoint, SQL Server, Web APIs, and cloud sources like Azure Data Lake, Azure SQL DB. Monitoring and troubleshooting dashboards using Power BI Gateway, usage metrics, and performance analyzer for optimization. Led and executed migration projects from Qlik Sense to Power BI, which included: Rebuilding Qlik dashboards using equivalent DAX logic, visual layout, and user interactivity. Translating Qlik set analysis and scripting logic into Power BI DAX and Power Query. Ensuring functional and visual parity between the Qlik and Power BI reports while enhancing performance and user experience. Hands-on expertise in Qlik Sense, including Scripting, Set Analysis, Master Items, Section Access, and associative data modeling. Proficient in BI project lifecycle: requirement gathering, data modeling, dashboard development, QA testing, deployment, and support. Strong communication and collaboration skills, working with business stakeholders, analysts, and engineering teams to deliver actionable insights. Recognized for delivering performance-optimized dashboards, adhering to best practices in data visualization, governance, and security. Strong hands-on experience with DAX functions to create calculated columns, measures, and tables for building dynamic dashboards. Proficient in using CALCULATE(), the most powerful DAX function, to modify filter context for dynamic analytics. Debugging and optimizing DAX queries using Performance Analyzer and understanding query plan logic.

• Sales Performance Dashboard (Power BI & Qlik Sense)
• Built a comprehensive sales dashboard tracking revenue, growth, and KPIs across regions.
• Used DAX measures and Qlik expressions to create advanced calculations.
• Financial Reporting & Forecasting
• Developed automated financial reports integrating Excel, SQL, and Power BI.
• Enhanced forecasting capabilities using time series analysis in Power BI.