Power Bi Developer

CAREER OBJECTIVE

Seeking a challenging role in the field of Business Visualization as Power BI developer, where my expertise, technical, logical and Analytical skills can help in the mutual growth and success of the Organization. PROFESSIONAL SYNOPSIS

A growth-oriented professional, total experience of 7+ years in which 3.5 years as non-IT and 4+ years in IT experience in developing various reports and data visualization.

4+ years of experience in Power BI, SQL and 1.5 years in ADF and Used to work closely with senior management to solve critical issues.

6 months of experience in Power Apps, Power Automate and SSIS

Expertise in Data Analysis, Data Cleansing, Transformation using ETL tools Power Query, and Azure Data Factory (ADF).

Good at creating different visualizations using Slicers, Lines, Pie, Infographic, Sankey, Ribbon, Maps, Scatter, Tornado, Radar charts, Heat Maps, Waterfall, Donut, Tree maps, Gauge, Funnel, etc.

Experience in Creating Power BI reports, Row Level Security (RLS), Publishing the report into Power BI Service, Creating Data flows, Dashboard, Mobile View, Complete Application, Managing Alerts, Scheduling refresh, Deployment Pipeline as per the business requirements.

Imported data from multiple data sources into Power BI from various databases like SQL Server, Oracle Server, Excel, CSV, Folder, XML, JSON, SharePoint List, Azure Cloud Services etc.

Experience in working with Azure services such as – Azure Storage, Azure Lake Storage, Azure SQL Database, and Azure Data Factory.

Able to create measures, attributes, hierarchies and relationships in Power BI.

Hands on experience on SQL.

Good knowledge of DAX Functions and Data Modeling.

Having experience in Power BI Services as creating Dashboards, Schedule Refresh, Alerts, etc.

Performed data cleaning including transforming variables and dealing with missing values and ensured data quality, consistency, integrity using ADF.

Design end-to-end solutions that improve collaboration, productivity, and knowledge sharing using power apps.

Hands-on experience with Power Apps and Power Platform technical solutions. `

Interact with the customer daily.

Worked in different Domains like Sales, Retail, Healthcare, Finance, Banking and Manufacturing. PROFESSIONAL SKILLS

ETL Tools : Power Query Editor, ADF, Power Apps, Power Atomate, SSIS

Dev Tools : MySQL workbench, MS Excel, Oracle, SSMS

Business Analytics Tool : Power BI Desktop

CERTIFICATION

Microsoft Certified: Power BI Data Analyst Associate (PL-300) – Microsoft, Jan 2025 WORK EXPERIENCE

Worked as a Senior Software Engineer and Power BI Developer in Stridely Solutions Pvt Ltd from July 2023 to 30th April 2025.

Worked as a Software Engineer and Power BI Developer in Datamatics Technosoft Limited from Aug 2017 to July 2023.

JAYANT KUMAR

Phone: +91-821*******

E-mail: ***********@*****.***

Project 1: Siding Inventory

Client : Cornerstone Building Brands USA Manufacture Technology/Tools : Power BI Desktop. Oracle Database, SharePoint Role : Power BI Developer

Team Size 5

Process : Agile

Duration : 6 months

Description:

Cornerstone Building Brands is a premier exterior building solutions provider committed to creating value for our customers and our communities. With unrelenting customer focus and strong emphasis on quality and performance, our products and solutions serve both the residential and commercial markets across North America. Responsibilities:

Connect to different Data sources from Power BI like Database as SQL or Oracle, flat files, Excel, Dataflows, SharePoint, Semantic Models.

Implemented star, snowflake schemas in data modelling and data cleaning using Power query Editor.

Gathered data using Import mode.

Implemented DAX (Data Analysis Expressions) functions for calculated columns and measures.

Experience in Custom visuals and Groups creation.

Reported EDA analysis in Power BI and RLS and worked on Power BI services.

Handled End to End process to deliver the project.

Publish Power BI Reports and created scheduling reports using Data Gateway.

Experience in creating different visualizations like Slicer, Column, Line, Bar, Histograms, Scatter, Water, Bullet, Heat maps, Tree maps, KPIs, Card, Table & Matrix.

Develop various types of complex reports like Filter, Drill Down, Drill through Reports.

Responsible for providing the securities for reports/dashboards by assigning Roles.

Experience in creating Joins, Sub-Queries, CTE, Windows Function, Stored Procedures and Views.

Interact with clients directly to get requirements.

Performed data cleaning including transforming variables and dealing with missing value and ensured data quality, consistency, integrity using ADF

Develop and maintain standardized reports, dashboards and portals utilizing the business intelligence platform’s software developer tools.

Project 2: Shelter Engineering

Client : Cornerstone Building Brands USA Manufacture Technology/Tools : Power BI Desktop, SQL Database (SSMS), Oracle Database and SSIS Role : Data Analyst

Team Size 6

Process : Agile

Duration : 7 months

Responsibilities:

Connect to Oracle Database sources and SQL Database destination through SSIS packages

Implemented the coding as an Incremental Load of last 13 months of data, last 1 hour of data, Last 1 month of data as per client needs.

Gathered data into SQL server (SSMS) from Orace server.

Deployed the packages into SQL Server and scheduled the job on Full Load as well as an Incremental Load.

Tested the Data with the Oracle server & SQL server (which are newly loaded).

Implemented the SQL server database into Power BI Desktop by changing their data source.

Reported EDA analysis in Power BI and RLS and worked on Power BI services.

Handled End to end process to deliver the project. PROJECT EXPOSURE

PERSONAL DETAILS

PROCLAMATION

Publish Power BI Reports and created scheduling reports using Data Gateway.

Experience in creating different visualizations like Line, Bar, Histograms, Scatter, Water, Bullet, Heat maps, Tree maps, KPIs.

Develop various types of complex reports like Drill Down, Drill through Reports.

Responsible for providing the securities for reports/dashboards by assigning roles.

Experience in creating Joins, Union, Sub-Queries, Stored Procedures and Views.

Interact with clients directly to get requirements.

Performed data cleaning including transforming variables and dealing with missing value and ensured data quality, consistency, integrity using ADF

Develop and maintain standardized reports, dashboards and portals utilizing the business intelligence platform's software developer tools.

B.Tech [CSE] (P.T.U) - K.C. College of Engg. & IT, Kariam, Nawanshahar, Punjab

Intermediate (B.S.E.B) - S.N.S. College, Hajipur, Vaishali, Bihar

High School (C.B.S.E) - Secondary D.P.S., Shahid Bhagat Singh Clny, Gaya, Bihar INTERPERSONAL SKILLS

.

Willingness to learn

Flexible working in all conditions

Co-operative and Team player

.

Gender / Marital Status : Male / Married

Date of birth : 21-12-1993

Nationality : Indian

Languages Known : English and Hindi

.

I hereby declare that the above-mentioned information is correct, and I bear the responsibility of the correctness of the above- mentioned.

Jayant Kumar

EDUCATIONAL QUALIFICATIONS

Contact this candidate