Dasi Burri

Project Name :FPYCorp_Eng_Quality
Client : WEBTEC, USA.

Environment : Power BI, DAX, Tabular Model, SQL Server, QLIK VIEW and Denodo

Role : Report Developer.

PROJECT DESCRIPTION:

RESPONSIBILITIES:

❖ Responsible for defining the scope of the project, gathering business requirements, doing analysis and documents.

❖ Importing the data from data sources SQL server database, prepared the data as per user requirement.

❖ Created new columns, new measures and conditional columns using DAX functions.

❖ Created various Customized and interactive Reports and Dashboards in Power BI.

❖ Adept in developing, publishing and scheduling Power BI reports as per the business requirements.

❖ Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.

❖ Scheduled Automatic refresh and scheduling refresh in Power BI service.

❖ Weekly presentation to the business users about the reports and their changes as required.

❖ Worked on on-premises gateway to refresh the data sources.

❖ Created several Dashboards and Scorecards with Key Performance Indicators (KPI).

❖ Preparing the Power BI data model as per the requirement by having appropriate relationships.

❖ Created Power reports with Table, Matrix, Bar, Card, Gauge, Slicer's visualizations.

❖ Gathered the requirement changes from the business as per the business needs.

❖ Update the existing SQL Server view as per the business need.

❖ Extracted data from SQL Server into Power BI Dataflows.

❖ Updated the existing Pillar related dataset according to the use cases.

❖ Performing Unit and Integration testing, validation using excel and Queries.

❖ Promoted the View, Dataflow, Dataset and Report from Dev to UAT.

❖ Provided view access to the business users.

❖ Getting sign off approvals from business users.

❖ Updated Technical Spec's, change control document and code reviewed with Supporting team and client.

❖ Modified QlikView based on ENH request number like Adding extra

❖ columns, modify existing report logic, developed new sheet objects as

❖ per business needs.

❖ Performing Unit and Integration testing, validation using excel and

❖ Queries.

❖ Published QlikView reports to concern group.

❖ Published PBI reports to concern Workspace.

❖ Integrated PBI reports to SharePoint site.

• Project Name : Ethic and compliance
• Client :, Power BI, DAX, Tabular Model, Having experience on pulling data from sources to Power BI having experience on pulling data from different data sources to Power BI
• Cleansing activities using Power Query in the Power BI
• Creating Relationship b/w the tables using Modeling in Power BI
• Created calculated columns and calculated measures as per the business needs
• Created Time based Calculations like MTD, QTD, YTD based requirement
• Created Power BI reports and Dash Boards with various visualizations
• Having experience on creating Power BI Gateway and scheduling refreshing data as per requirement
• Sharing the Reports and Dash Boards to end user
• Have created staging tables, Dimension tables and Fact tables based on business requirement
• Created Relationships at database level and Tabular Model for custom dimension
• Create DAX queries as per the requirement
• Have done Unit Testing and solved issues, which are getting from End customers
• Design, create, and implement database systems based on the end user's requirements
• Impove application's performances
• Prepare documentations for database applications
• Memory management for database systems
• Develop database schemas, tables and dictionaries
• Fix any issues related to database performance and provide corrective measures
• Create complex functions, scripts, stored procedures and triggers to support application development
• Take regular database backup
• Test databases and perform bug fixes
• Develop best practices for database design and development activities
• Develop risk analytics reports, dashboards, and process configurations within SharePoint
• Involved directly in the technical build-out and/or support of SharePoint, databases, query tools, reporting tools, BI tools, etc
• That enable data capture, analysis, and/or data visualization
• Perform analysis and diagnosis of client issues
• Identify and solve problems using analysis, experience, and judgment
• Independently perform tasks with some guidance to execute a portion of the project scope
• Developing Star, snow flake and mixed modelling skills
• Working experience on MSBI tools (SSIS/SSRS/SSAS),informtica power canter
• Strong understanding of data modelling and ETL full, incremental and Change data capture loads
• Documentation of requirements and writing user stories and tasks in Agile Methodology

• AMENA new page Secondary Analytics
• Client, Power BI, DAX, Tabular Model, The world's largest research based American multinational food company
• PepsiCo Inc
• Discovers, develops, manufactures, and market's their products across the world
• BI project is an initiative to bring about a step change in the process of data gathering secondary sales data, analysis and reporting in order better inform the decision-making process by the business
• RESPONSIBILITIES:
• Having experience on pulling data from sources to Power BI having experience on pulling data from different data sources to Power BI
• Cleansing activities using Power Query in the Power BI
• Creating Relationship b/w the tables using Modeling in Power BI
• Created calculated columns and calculated measures as per the business needs
• Created Time based Calculations like MTD, QTD, YTD based requirement
• Created Power BI reports and Dash Boards with various visualizations
• Having experience on creating Power BI Gateway and scheduling refreshing data as per requirement
• Sharing the Reports and Dash Boards to end user
• Have created staging tables, Dimension tables and Fact tables based on business requirement
• Created Relationships at database level and Tabular Model for custom dimension
• Create DAX queries as per the requirement
• Have done Unit Testing and solved issues, which are getting from End customers
• Design, create, and implement database systems based on the end user's requirements
• Impove application's performances
• Prepare documentations for database applications
• Memory management for database systems
• Develop database schemas, tables and dictionaries
• Fix any issues related to database performance and provide corrective measures
• Create complex functions, scripts, stored procedures and triggers to support application development
• Take regular database backup
• Test databases and perform bug fixes
• Develop best practices for database design and development activities
• Develop risk analytics reports, dashboards, and process configurations within SharePoint
• Involved directly in the technical build-out and/or support of SharePoint, databases, query tools, reporting tools, BI tools, etc
• That enable data capture, analysis, and/or data visualization
• Perform analysis and diagnosis of client issues
• Identify and solve problems using analysis, experience, and judgment
• Independently perform tasks with some guidance to execute a portion of the project scope
• Developing Star, snow flake and mixed modelling skills
• Working experience on MSBI tools (SSIS/SSRS/SSAS),informtica power canter
• Strong understanding of data modelling and ETL full, incremental and Change data capture loads
• Documentation of requirements and writing user stories and tasks in Agile Methodology
• Different domain understanding like healthcare, Banking, Retail …etc

• Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets.
• Tested methodology with writing and execution of test plans, debugging and testing scripts and tools.
• Coordinated deployments of new software, feature updates and fixes.
• Tested functional compliance of company products.
• PNC Bank is a Pittsburgh -based financial services corporation
• In the U.S., PNC is the fifth largest bank by number of branch offices, sixth largest by deposits, eighth largest by total assets, and fourth largest in number of ATMs
• Accenture provides its high-performance services to PNC Bank
• RESPONSIBILITIES:
• Involved discussion with business users and provide technical guidance for Power BI Desktop and Power BI Service
• Extracting the data and placed into Power BI desktop
• Created Filters and apply conditional formatting based on user requirement
• Created Slicer and measures and columns in Power BI Desktop
• Created different types of reports in Power BI Desktop Pinning reports to the Dashboards as per the requirements
• Created scheduling and sharing the reports & Dashboards using Data Gateway
• Creating Content packs and sharing reports and Dashboards
• Generating reports using DAX time intelligence functions and other kind of DAX functions
• Involved in Creating Hierarchies and giving the relationship between attributes to decrease processing time
• Involved in creating relationships between dimensions and measure groups as per business requirement
• Create Visuals and Reports in Power BI Desktop and publish into Power BI Service
• Create Reports Using Custom Visuals
• Create Reports and Dash Boards in Power BI
• Create Reports in Power BI Desktop as per requirement
• Generating reports using DAX time intelligence functions and other kind of DAX functions
• Creating Content packs and Sharing reports and Dashboards
• Scheduling using Gateway
• Create a Tabular Model Project, process the Project and Deployed into SQL Server Analysis
• Connecting Live and extract data from SQL SERVER Tabular Model into Power BI desktop
• Design, create, and implement database systems based on the end user's requirements
• Impove application's performances
• Prepare documentations for database applications
• Memory management for database systems
• Develop database schemas, tables and dictionaries
• Fix any issues related to database performance and provide corrective measures
• Create complex functions, scripts, stored procedures and triggers to support application development
• Take regular database backup
• Test databases and perform bug fixes
• Develop best practices for database design and development activities
• Develop risk analytics reports, dashboards, and process configurations within SharePoint
• Involved directly in the technical build-out and/or support of SharePoint, databases, query tools, reporting tools, BI tools, etc
• That enable data capture, analysis, and/or data visualization
• Perform analysis and diagnosis of client issues
• Developing Star, snow flake and mixed modelling skills
• Working experience on MSBI tools (SSIS/SSRS/SSAS),informtica power canter
• Strong understanding of data modelling and ETL full, incremental and Change data capture loads
• Documentation of requirements and writing user stories and tasks in Agile Methodology

• Project Name : business analytics service (health care Domain)
• Client : Sanmed healthcare
• Environment : business analytics, power bi and SharePoint