Saddam Ansari Email and Phone Number

Company: UnitedHealth Group Company(31st Jan 2022 till Now)Designation: Data Engineer Analyst / Power BI DeveloperProject Overview: (Migration from Excel, tableau to Power BI)UnitedHealth Group Incorporated is an US Based managed healthcare and insurance company and It offers health care products and insurance services. As a Data Engineer Analyst I was working on the healthcare and insurance related data and creating report in Power BI and share report with stack holder and product owner. - Created Reports and dashboard in Import connection from ODBC data sources.- I was fetching data from Hive data based and creating reports in power bi based on the userstory created by the product owner.- Good knowledge of DAX, calculated columns and measures in power BI.- Used Power BI and Power Query Editor to develop data analysis and used Power BI Charts and Power BI Maps to visualize reports.- Applied RLS and Page Level Security in many reports and given roles in Power BI Service.- Knowledge of Power BI tooltips, Context filter, report filter, page fiter,incremental Refresh in the report and dashboard- Use different types of DAX function related to Time intelligence, Hirarchies, Aggregate, Calculate, filters in Power Bi reports.- Give some insights on data apart from daily, weekly and monthly reports.- Responsible for Power BI Admin and monitoring the worskapces and capcities and tenant settings. Monitoring the dataset available in different workspaces and group.- Providing access to the workspaces capacities and datasets report as per the request by users and clients.- Monitoring the tenants setting and capacity usage.- Created stored procedures and SQL queries to pull data into Power BI Reports.- Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.- Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.

Project Overview: (Migration from Excel, Qlick Sense to other BI tools to Power BI)Our client is a US based agriculture client. They deals in Crop Protection and Seeds along with demand generation of their products. So it was a migration project from Excel Qliksense to Power BI. We basically pull their data from heterogenous sources and create Power BI reports and dashboards and publish it on the service. We created RLS and give necessary access to stake holders and end users.Project Overview: (Migration from Excel, Qlick sense to Power BI)Our client is a US based agriculture client. They deals in Crop Protection and Seeds along with demand generation of their products. So it was a migration project from Excel Qliksense to Power BI. We basically pull their data from hetrogenous sources and create Power BI reprts and dashboards and publish it on the service. We created RLS and give necesary access to stake holders and end users.- Good knowledge of DAX, calculated columns and measures in power BI.- Created Reports and dashboard in Import /Direct and Live connection based on the requirement and type of data sources.- Used Power BI and Power Query Editor to develop data analysis and used Power BI Charts and Power BI Maps to visualize reports.- Applied RLS in many reports and given roles in Power BI Service.- Knowledge of Power BI tooltips, Context filter, report filter, page fiter,incremental Refresh in the report and dashboard- Use different types of DAX function related to Time intelligence, Hirarchies, Aggregate, Calculate, filters in Power Bi reports.- Give some insights on data apart from daily, weekly and monthly reports.- Responsible for Power BI Admin and monitoring the worskapces and capcities and tenant settings. Monitoring the dataset available in different workspaces and group.- Providing access to the workspaces capacities and datasets report as per the request by users and clients.- Monitoring the tenants setting and capacity usage

• Involved in team meetings and project review.• Client interaction for better understanding.• Developed Power BI model as per requirement of client.• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.• Developed tabular queries for efficient analysis of report using in T-SQL • Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis

Developed Power BI reports and dashboards from multiple data sources using DAX Analysis. Work extensively on Ad-hoc requests made by internal and external stake holders. Applies different methods and SQL queries to extract useful data from database. Explored data in a variety of ways and across multiple visualizations using Power BI and MS Excel. Create insights from the historical data apart from daily, weekly and monthly reports. Involved in troubleshooting, resolving and escalating data related issues and validating data to improve data quality. Designed Power BI data visualizations utilizing maps, scatter plots, line chart, bar chart, pie charts, tree map, area chart etc. Involved in creation of dashboard and reports in Power BI. Deliver BAU's and Adhoc as per the requirement. Deliver Excel based daily, weekly and monthly reports. Check for performance tuning of bad running queries. Extensively used DAX in power BI for the creation of calculated colums, measures and tables.

• Involved in team meetings and project review.• Client interaction for better understanding.• Developed Power BI model as per requirement of client.• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.• Developed tabular queries for efficient analysis of report using in T-SQL • Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis

• Imported data from SQL Server DB, MS Excel , CSV, to Power BI to generate reports.• Created DAX Queries to generate computed columns in Power BI• Published Power BI Reports in Power BI Service and created PBI Dashboard using different reports tiles.• Explore data in a Variety of ways and across multiple visualizations using Power BI• Used Power BI Gateways to connect with On –Premises datasources SQL Server, Excel, SAP, Oracle ect. And created data source in Manage gateway in Power BI Service.• Installed and Configured Enterprise Gateway and Personal Gateway in Server Machine and Manage the data sources Power Bi Services.• Integrated custom visuals based on business requirement using power BI desktop.• Converting all operational excel report into Power BI Reports.