Chandra Shekar Mateti

Professional Experience:

• Around 6+ Years of extensive Hands-on experience as SQL/BI Developer in visualizing reports using Power BI, Database.
• Hands-on experience in creating powerful intuitive and interactive Reports and Dashboards using Power BI Desktop and Power BI Service.
• Hands-on experience in Publishing Reports to Power BI Services, Embedded Power BI reports into SharePoint Sites, and configured Power BI Workspaces. Experience in various states of Software Development Life Cycle (SDLC).
• Having good experience in developing, customizing, and supporting interactive dashboards and visualizations using Microsoft Power BI Desktop, Server, and Service technologies.
• Good experience in Data mash-up with Power BI’s Query Editor and M language functions. Microsoft Certified: Data Analyst Associate Official Microsoft.
• Used DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.
• Generate embedded Power BI reports on the customized website, application (with & without Row Level Security Utilize tools like Power Pivot, Power Query, Power View & Power Map Very good experience in writing DAX queries and coding for business scenarios.
• Experience in creating different KPIs, visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps, and Highlight tables. Good understanding of role organizations, row-level security- static as well as dynamic and data gateways for data refreshing. Good experience in publishing reports to Power BI service and setting up the necessary connections.
• Having very good experience in creating data models, adding calculations, creating hierarchies, and interactive visualizations. Good experience in creating calculated columns, measures, query editing, and advanced editing using power query and power pivot. Good experience in tabular modeling with power pivot.
• Extensively used power query for data mashup and data transformations.
• Very good experience in creating filters, Interactions, Maps, hierarchies, grouping and sorting, and parameterization.
• Involved in Trouble Shooting, Performance tuning of reports, and resolving issues within Power BI Reports and dashboards.
• Experienced in programming tasks-Stored Procedures, functions using U-SQL.
• Experience in BI Development and Deployment of SSIS packages from heterogeneous sources.
• Experienced in programming tasks-Stored Procedures, functions, triggers, and Cursors using SQL Server 2008 /2008R2 and 2012 with T-SQL.
• Excellent knowledge in Designing Database Objects like Tables, Constraints, Views, Indexes. Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, and Check, Unique, etc.) and Generating Complex Transaction SQL (T-SQL) Queries and Subqueries.
• Extensive experience in Installation, Configuration, and Updates of SQL Server.
• Expertise in generating parameterized reports, linked reports, sub-reports, matrix, and charts in SSRS 2008R2.
• Expert in creating subscriptions like data-driven subscriptions etc.

• SnowPro Core Certification the Data Platform from Snowflake, Issued on Feb 2021
• Microsoft Certified: DA-100: Analyzing and Visualizing Data with Power BI from Microsoft, Issued on May 2021
• Microsoft Certified: PL-900: Microsoft Power Platform Fundamentals from Microsoft, Issued on MARCH 2022.