Participated in the team business requirements gathering and analyze, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.Developed and published dynamic and complex Financial and Sales Reports in Power BI via Azure cloud.Used DAX to create complex measure and calculated columns.Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.Used bookmarks feature which enables the ease to jump to respective report tabs with one click.

Expertise in writing complex DAX functions in Power Bl and Power Pivot.Automated Power Query refresh using power shell script and windows task scheduler.Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc...Installed and configured Enterprise gateway and Personal gateway in Power bi service.Created Workspace and content packs for business users to view the developed reports.Scheduled Automatic refresh and scheduling refresh in power bi service.Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model.

Participated in the team business requirements gathering and analyze, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.Developed and published dynamic and complex Financial and Sales Reports in Power BI via Azure cloud.Used DAX to create complex measure and calculated columns.Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.Used bookmarks feature which enables the ease to jump to respective report tabs with one click.

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systemsParticipated in the SCRUM meetings and provided the updates and successfully delivered the taskedCreated and updated database objects like Complex Stored Procedures, Joins, User Defined functions, etc. for business logicCreated views to facilitate easy user interface implementation, and Triggers on them to facilitate consistent data entry into the Database