PowerBI Developer
Location : Jaipur, India
Experience : 5 Year
Rate: $18 / Hourly
Availability : Immediate
Work From : Any
Category : Information Technology & Services
Jagmohan – 4+ Years - PowerBI
Profile Summary
Having over 4 years of professional experience in IT industry, involved in ETL projects with
extensive usage of ETL & BI tools.
Strong knowledge of data warehousing methodologies, concept and implementation of star
schema, snowflake schema, fact & dimension.
Experience on developing the Star and Snowflake Schema (Data Integrity, Granularity, SCD
type 1 and Type 2, Normalization, Denormalizations, Staging Area, Source Layer, Extraction
Layer).
Good exposure on joins, window function such as Rank, Dense Rank, Row Number, Lead,
Lag and Indexing in SQL.
Extensive knowledge on SQL Server 2012.
Experience in creating aggregates, hierarchies, charts, filters, trend lines, calculated
measures in Power BI.
Experience with Bar Charts, Donut Charts, Waterfall Charts, Tree Maps, Stacked Bars, Filled
Maps, Highlight Tables, Heat Maps, Cross tab, Scatter Plots, Geographic Map, Pie Charts,
Cards and several custom conditional formatting reports in PowerBI.
Developed What-If analysis reports for business requirements in PowerBI.
Created Customized and interactive dashboards using multiple data sources.
Experience in developing the Dashboards with Drill down, Interactive filters, Report filters
in Power BI.
Developed Drill Down, Drill Through, Parameterized, Cascaded and Sub- Reports using
PowerBI.
Good experience in Tuning SQL queries.
Good knowledge of Python and R analytics language.
Scheduling the Reports Weekly and Monthly basis as per the Client Requirements and
providing security for reports.
Good understanding in python libraries like Numpy, Pandas, Matplotlib etc.
Experience with data Collibra data lineage tools to automatically map relationships.
Experience
Company Location Designation Duration
Confidential Vadodara Business Analyst 2021 - Present
Confidential Hyderabad Software Engineer 2019 - 2021
Qualifications & Skills
Technical Skills
Analytical Tool
PowerBI
Programming Language
Python
Database
Redshift,MySQL,MS SQL SERVER 2008R2/2012/2016
Projects
Project Astellas Pharma
Duration May 2021 - Present
Client Astellas Pharma
Development Environment Python,Redshift,SQL,AWS S3
Roles & Responsbility
Received data from client different location
like AWS S3, FTP.
Transfer the data from client location to
destination location.
Unload the data from Redshift to S3
location
After loading Applied QC check and share
the report to client.
Wrote query to enhance the QC report to
identified data profiles information.
Identified issues like column shifting,
length, extra delimiter and fixed it.
Worked with Excel pivot table.
Worked on automation to compare the
data from Redshift and manifest file.
Project Athena
Client AtLaq
Development Environment MySQL,PowerBI
Roles & Responsbility
Transformed raw data into valuable and
meaningful insights in the form of
appealing dashboards and reports.
Experienced with Power BI Data Modelling.
Gathered business requirements from users
and converted them to technical
specifications by building dashboards and
reports.
Developed Power BI reports and
dashboards from multiple data sources and
create reports.
Built Measures and Calculated columns
using DAX.
Created multiple cards on Total
Revenue,sales Qty,profit
Connect the data with database and
applied transformation.
Applied Filter in sales amount is whose
showing amount either 0 or negative value.
convert all currency into one currency and
added new column and make the amount
on based on currency values.
created stack bar chart and show revenue
generated by zone,market etc. added
bookmarks to navigate by market.
Project JEVAA
Client Jio
Company VotaryTech
Development Environment MySQL,PowerBI,Excel
Roles & Responsbility
Created KPI, Cards to show the
Energy consumption.
Created dashboard for Visualize the data
based on energy consumption Data and plot
bar chart to show each appliance.
Created Pie chart to show consumption for
each appliance’s energy device status.
Applied exploratory data analysis and fill
missing values on datasets, per-processed
data and remove duplicate data.
Analysis the data and fill missing values on
datasets, pre-processed data and remove
duplicate data.
Experience with Bar Charts, Donut Charts,
Waterfall Charts, Tree Maps, Stacked Bars,
Filled Maps, Highlight Tables, Heat Maps,
Cross tab, Scatter Plots, Geographic Map,
Pie Charts, and several custom conditional
formatting reports in PowerBI.
worked with Project Management tools such
as MS Office suite MS Project, MS
Outlook, MS PowerPoint.
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
