Professional Summary:
5+ Yrs of Experienced Power Developer with expert level hands on Power BI, Power Apps and Microsoft SQL Server 2019.
Worked on DAX expressions like Text, Date and Time, Aggregate, Logical and Mathematical functions etc.
Comfortable in working with filters/calculated columns/measures/relationships and transformations under “Edit Query Window” section.
Used various data sources to pull data into Power BI such as SQL Server, One Drive for Business etc.
Worked with Import and Direct-Query connectivity modes in Power BI.
Integrate Power BI Reports and dashboards into PowerApps.
Understanding PowerApps formulas and development methods.
Use multiple OOTB Connectors with PowerApps and preferably for creating Canvas apps and Model Driven Apps.
Having knowledge on creating variables such as Contextual and Global in Power Apps.
Created Site maps in Model driven apps- That means creating Areas, Groups, Sub areas.
Involved in writing business rules for displaying values based on the logics supplied in Model driven app.
Experience on creating collections for applying formulas to show the data in table format in Power Apps.
Adding different type of visuals and dashboards to the Model Driven app
Good working knowledge on querying in T-SQL, SQL Server and Query optimization.
Experience in taking Database backups and restoring them, also created jobs for regular backups and monitoring the performance.
Experience on writing DDL/DML/DCL commands using SQL Server Management Studio.