Power BI Developer with ETL & DAX

Professional Summary:

Over **+ years of IT experience with expertise in analysis, design, development and implementation of data marts using Power BI, ETL and RDBMS like Oracle 11g, MS SQL server.

Published Power BI Reports and Made Power BI Dashboards available in Web clients and mobile apps.

Strong ability to analyze user requirements, Business Requirement Specifications.

Expert in Data Preparation, Data Modeling and Data Blending.

Expertise in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Center.

Extensive experience with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.

Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints.

Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).

Expertise in Power BI Desktop, Power BI Service with Pro and Premium capacities

Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query.

experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI and Tableau

Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau.

Generated context filters and data source filters while handling large volume of data using Power BI.

Involved in creating Filters, quick filters, table calculations, calculated measures and parameters in Power BI.

Hands on experience with MSBI (SSIS) to extract, transform and load data into database.

Extensive experience in gathering business requirements and involved in developing projects.

Proactive team player with capability of handling responsibilities independently as well as in a team

Reporting Tools

Power BI Desktop (2.68), Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop 8.0/9.3 Tableau Server, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS).

ETL Tools

SQL Server Integration Services (SSIS). ServicesNow

Databases

Oracle 10g/11g, MS SQL server 2014/16, Teradata 15 and Snowflake cloud database, Azure SQL DB, data warehouse,AWS cloud,CMDB

Hadoop Ecosystem

HDFS, Hive

Operating System

Windows, UNIX

Languages

SQL, PL/SQL, T-SQL

Others

TOAD, Oracle SQL developer, MS Office, FTP, Control-M, Teradata View Point, Teradata SQL Assistant, Rally, JIRA, GitHub, JSON,

Professional Experience:

Humana Insurance, Dallas, Texas, Remote Jan 2026- Present

Data Analyst/Power BI Developer

Responsibilities:

Developed calculated columns and measures using DAX in Power BI.

Performed Data mapping to validate and customize Claims daily load into FACETS for transactions

Worked closely with various teams across the company to identify and solve business challenges.

Gathering and Analyzing requirements of clients, understand and convert them into database solutions

Import data from different data sources to create Power BI reports and Dashboards.

Implemented complex query techniques of passing Multi-Valued parameters and cascading in MDX.

Performed types of context like Row context, filter context and query context using Power BI Desktop

Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query.

Performed Query Folding using Power Query to filter data in the data source server.

Created different chart types and drill down reports using Power Bi Desktop (SSRS).

Worked with both live and import data into Power BI for creating reports.

Managed huge volume of data by creating weekly partitions in SSAS models.

Used different type of slicers available in Power BI for creating reports.

Creating many dashboards by pinning many visualizations in the workspace as per the insights provided.

Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.

Used Power BI Gateways to keep the dashboards and reports up to date.

Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements.

Experience in generating on-demand and scheduled reports for business analysis or management decision.

Used recently introduced Power BI to create self-service BI capabilities and use tabular models.

Creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Shared the created workspace across the organization using PowerBI Apps.

Responsible for creating Row-Level Security (RLS) based on the business requirements.

Created complex stored procedures and scripts in SQL Server.

Apple, Remote Oct 2023- Dec 2025

Data Analyst/Power BI Developer

Responsibilities:

Developed calculated columns and measures using DAX in Power BI.

Performed data mapping to validate and customize daily claims load into FACETS for transactions.

Worked closely with various teams across the company to identify and solve business challenges.

Imported data from different data sources to create Power BI reports and dashboards.

Developed reports, charts, and dashboards using Power BI Desktop and managed security on requirements.

Transformed, defined, and navigated data; performed merge and append queries using Power Query.

Implemented complex query techniques for passing multi-valued parameters and cascading in MDX.

Performed types of contexts such as row context, filter context, and query context using Power BI Desktop.

Executed transformations like pivoting, unpivoting, and splitting columns using Power Query.

Applied query folding using Power Query to filter data at the data source server.

Created various chart types and drill-down reports using Power BI Desktop (SSRS).

Worked with both live and imported data in Power BI to create reports.

Apple, Remote Mar 2020-Sep 2023

Data Analyst/Power BI Developer

Responsibilities:

Developed calculated columns and measures using DAX in Power BI

Used the tabular model cubes as the source in Power BI to visualize the data.

Created Power BI dashboard and generated reports.

Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.

Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.

Published Power BI Desktop to the cloud. I did gathering data

Working optimizing dashboards with focus on usability and performance.

Created interactive reports customized for the business using Power BI Desktop.

Installed and configured and maintained Power BI Report Server.

Worked process of combining data from multiple sources into a large, central repository.

Worked Data Modeler and all team within the organization to understand business processes.

Developed complex SQL queries to obtain complex data from tables.

Read source data from HDFS,Azure SQL DB, CSV, ORACLE 11g,SQL Server 2016. through Power BI.

Read different formats of Source data from hive like JSON, ORC, TXT.

Generated context filters and data source filters while handling large volume of data.

Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information,

Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.

Have used Z-order to overlap the reports on each other using Power BI.

Used Power BI, Power Pivot to develop data analysis prototype, and Power Map to visualize reports

Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.

Published Power BI Report and Made Power BI Dashboards available in Web clients.

Created multiple data model and used as a common data source for the reporting purpose.

Used Power BI Gateways to keep the dashboards and reports up to date.

In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD),

Created Row level security so based on role, the end user can view the data.

Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.

Hand on Experience in Unix to write basic commands, Moving files from HDFS to local and vice versa.

FUJITSU USA, NOVI MI Mar 2018- Feb 2020

Data Analyst/Power BI Developer

Responsibilities:

Collaborated with the project team to outline project requirements in JRD meetings

Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.

Developed data reconciliation SQL queries to validate the overall data migration.

Formulated DAX Expressions create Date to yearly columns in Tabular Models for Power BI.

Used recently introduced Power BI to create self-service BI capabilities and use tabular models.

Wrote DAX expressions to create new measures, calculations per business requirements.

Effectively used data blending, filters, actions, and hierarchies feature in Power BI.

Analyzed the data using Statistical features in Power BI to develop trend analysis.

Published developed dashboard, reports on the Power BI Services

Successfully integrated custom visuals based on business requirements in Power BI desktop.

Participated in the configuration of Power BI gateway to refresh datasets of Power BI reports and dashboards.

Created complicated reports such as parameter-based reports, graphical reports, excel reports, drill-down chart

Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, Bullets using Power BI.

Generated and scheduled on-demand reports for business analyses and management decisions with SSRS.

The process of combining data from multiple sources into a large, central repository

Oshkosh Truck Corp Jul 2016-Dec2017

Data Analyst/SQL BI Developer

Responsibilities:

Involved in gathering the user requirements.

Performed tasks like execute SQL task, data flow task, file system task for ETL process.

Worked Extensively on ETL process using SSIS package.

I did work the process of combining data from multiple sources into a large, central repository

Used all types of container tasks such as for loop, foreach loop and sequence container in SSIS.

Created Backend validations using Insert/ Update and Delete triggers.

Configured SSIS Packages using Environment Variables for Dynamic selection of Development and

Part of Relational Data Warehouse Designs and identified and created Facts and Dimensionstables.

Coordinated with DBA in creating and managing tables, indexes, triggers and privileges.

Designed production and sales dashboard for Sales and procurement departments using Power BI.

Using Microsoft Power BI for data visualization.

Created new measures and new calculated columns for reports and dashboard analysis.

Published reports and dashboards to the Power BI service.

Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter,

Edcuation : Bachelors from Bahauddin Zakariya University, Pakistan

Contact this candidate