Power BI Developer

| Tel: +91-9959461909 |  Email: [email protected]|

PROFESSIONAL SYNOPSIS

 Dedicated professional with 2+ years of IT experience which includes Power BI using SQL server.
 Experience in connecting with multiple data sources like SQL Server,Text,MySQL, Excel and to Power BI.
 Collaborate with data engineers and operation team to implement the ETL process & Collaborate with
Business Analysts to understand the key metrics.
 Hands on experience in creating interactive reports using both default charts & Custom charts Line Chart,
Pies, Word Cloud, Slicers Column chart, Heat Maps, Water Fall, Donut, Tree maps, Scroller etc.
 Extensively worked on performing the ETL (Extract, transformation & Load) Activities in Power Query.
 Extensively used transformations like Merge Queries, Append Queries, Pivoting the Column, Unpivoting
Columns, Adding Custom Columns, Splitting the Columns, Merging the Columns, etc.
 Extensive Experience in Data Modelling in Power Pivot Model.
 Extensively worked on Enhancing the Data Model by Creating New Columns, New Measure and New Tables using
DAX Expressions.
 Observing the different patterns by analyze Year on Year/ Month on month sales.
 Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date
Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New
Information.
 Created various measures and columns in Power BI Modeling using Data Analysis Expression (DAX)
 Have done sharing the report and created alerts to get alert mail, if the alert condition is satisfied.
 Create the Key Performance indicators(KPI) & Metrics to communicates the amount of progress made toward a
measurable goal.
 Hands-on experience in implementing row-level security (RLS), bookmarks, and parameters to restrict user
dataset, and publishing reports to Power BI Service and setting up necessary connections.
 Hands on Experience with Visual level, Page level, Report level and Drill Through filters for filtering the data in a
Report.
 Extensively worked on Power View for Presenting the Data in Graphical Format using Different Visualizations in
Power BI.
 Worked on On-Premise Data Gateway to Refresh and Schedule Refresh the Data in the Dataset.
 Knowledge on Database creation (DDL, DML, DCL) and constraints.
 Having experience with SQL Server and T-SQL in constructing database object models, Tables, Views, Stored
Procedures, Table Variables, CTE, Temp Tables, System Functions, User Defined Functions, Indexes,
Triggers and Dynamic SQL.
 Good in writing complex SQL queries using Joins, Sub Queries to retrieve data from the database.
 Good Knowledge on Creating packages in SSIS.
 Have good knowledge in Data ware house concepts like Dimension & fact tables, slowly changing
dimensions, OLAP & OLTP.
 Excellent Communication, Presentation, Interpersonal, Strong Troubleshooting and Organization Skills.
 A self-motivated, responsible and reliable team player with a set of strong technical skills and as well as Quick
learner and adaptive in nature.

EDUCATION

 Master of Technology Anantapur, India

 Operating Systems : Windows 11

WORK EXPERIENCE
 Worked as Sr Assoc−Application Developme in Sutherland Global Services Pvt Ltd, Bangalore from August 2021 to
March 2022.
 Worked as a Software engineer in Srinivasan Software Solutions Private Limited Tirupati from April-2015 to
Feb-2017.

PROJECT EXPOSURE

#Project-1
Client: : Northwell
Technology/Tools : MS SQL, Power BI
Role: : Power BI Developer
Team Size: : Five

Description:

Northwell Health is a comprehensive healthcare system based in New York. It's one of the largest and most prominent
health networks in the region, providing a wide range of services including medical care, research, and education. Northwell
operates a network of hospitals, outpatient facilities, and urgent care centers throughout New York State.

Responsibilities:
Gathered and integrated data from diverse sources, including SQL databases, Excel spreadsheets
ensuring data accuracy and consistency.
Created new columns, new measures and conditional columns using DAX
functions. Worked on all types of transformations that are available in Power
query editor.
Weekly presentation to the business users about the reports and their changes as required.
Scheduled Automatic refresh and scheduling refresh in power bi service.
Work on all types of transformations that are available in Power query editor like the Conditional Columns, Custom
Columns in Power BI.
Created measures using Data Analysis Expressions (DAX) query.
Created different filters like visual filters and page level filters and report level filters as per reporting
needs. Designed different types of reports like drill down, drill through from parent report to child
report.
Created Unit Testing document for every report by Operating Company.

#Project-2
Client: : Apollo Hospitals
Technology/Tools : SQL, Power BI & Excel
Role: : Power BI Developer
Team Size: : Five
 Description:
Apollo Hospitals is one of India's largest and most well-known healthcare chains, with a strong presence in
both the private and public sectors. the hospital network has grown to become a major player in the healthcare
industry, offering a wide range of medical services across numerous specialties.

Responsibilities:
Used various sources to pull data into Power BI such as SQL with Excel.
Created new columns, new measures and conditional columns using DAX functions.
Worked on Data harmonization in Power query editor.
Connecting to the business users about the reports and their changes as
required. Scheduled Automatic refresh and scheduling refresh in power bi
service.
Work on all types of transformations that are available in Power query editor like the Conditional Columns, Custom
Columns in Power BI.
Created measures using Data Analysis Expressions (DAX) query.
Implemented Row Level Security by defining various constraints for each defined ROLE.
Created different filters like visual filters and page level filters and report level filters as per reporting
needs. Worked on drilldown from summary report to detailed report.

#Project-3
Client: : NBTY
Technology/Tools : Power BI & Excel
Role: : Power BI Developer
Team Size: : Four

Description:
NBTY is a prominent American company that focuses on manufacturing and distributing dietary
supplements and wellness products. Based in the United States, NBTY is a leading player in the global
health and wellness industry. They produce a broad range of products, including vitamins,
herbal supplements, protein powders, and other nutritional items

Responsibilities:
Used various sources to pull data into Power BI such as Excel.
Created new columns, new measures and conditional columns using DAX
functions. Worked on all types of transformations that are available in Power
query editor.
Weekly presentation to the business users about the reports and their changes as required.
Scheduled Automatic refresh and scheduling refresh in power bi service.
Work on all types of transformations that are available in Power query editor like the Conditional Columns, Custom
Columns in Power BI.
Created measures using Data Analysis Expressions (DAX) query.
Implemented Row Level Security by defining various constraints for each defined ROLE.
Created different filters like visual filters and page level filters and report level filters as per reporting
needs. Designed different types of reports like drill down, drill through, And Sync Slicer.

DECLARATION
I hereby declare that the information furnished above is true to the best of my knowledge.