Power Bi Analyst

Language

Expertise

Experience

POWER BI ANALYST

Results-driven Power BI Analyst with 6 month+

year of hands-on experience in designing

interactive dashboards, transforming complex

data into actionable insights, and working with

tools like DAX, Power Query, SQL Server, and

Excel. Previously worked in Telecom with over 4

+ years of technical experience. Recently

completed a PGP in Data Science & Machine

Learning from MIT (via Intellipaat). Adept at

building business intelligence solutions for e-

commerce, education, and finance domains.

About Me

+91-073********

**********@*****.***

Parewanarayanpur, Kunda

Pratapgarh, Uttar Pradesh,

India, 229413

.

.

.

.

.

.

Developed and maintained internal Company Websites using HTML/CSS/PHP. Collaborated with Clients to gather requirements & deliver Custom Web solutions .

SMARTEST SOFTWARE SOLUTION

Greater Noida - India

1_Jan_2025 - Current

Power Bi Analyst

t

Designing Data Models building reports, Creating Dashboard and ensuring data Accuracy and Performance .

Determining the relevant data sources and how to Connect to them . Designing the data model to and Structure the data for efficient analysis and reporting.

Building interactive reports and Dashboards using visualizations like charts, graphs, maps and table.

TELE LOGIX COMMUNICATION SERVICES PVT LTD (VI)

Hyderabad- India

1_Oct_2022 - Dec_2024

NOC ENGINEER

Thoroughly testing the reports and dashboards to ensure accuracy, functionality and performance .

P ublishing the reports and dashboards to the power bi Service for users to access and interact with.

. Have a Knowledge of all CR Activities of Transmission, t Such as Node deletion,Node Insertion & T.S. I perform activity of Node Upload, Insertion,KLM 1 to 1,Software

Upgrade and Node Deletion activity on NMS (Huawei SDH).

.

. The Traffic Shifting of the RAN Department is Learning and all the activities. English

Hindi

SAI INDIA TECH SOLUTIONS (P) LIMITED

Delhi - India

Sep_2018-Nov_2019

JUNIOR ENGINEER

.

KAMGARO PVT LTD

Lucknow- India

.

.

Installation of BSC/TRC, RBSC,MSS,MGW,BLADE nodes & EPDU ODF, doing the cabling of exchange by reference to C-module. Doing activities like -: E- GEM Magazine expansion, NWI-E card expension, GARP-2 Card expansion, STM Card expansion. Supporting while testing of MSC, BLADE, BSC/TRC,HLR andRBSC. Responsible to expansions of switch.

ROHIT

GUPTA

Deployment : Power Bi Service

(Publishing, Workspace Management,

scheduling Refreshes) .

Tools & Tech : Power BI, DAX, Power

Query, SQL Server,Excel, HTML,CSS.

Data Modeling : Star/Snowflake Schema,

Relationships,Measures, Calculated, Columns .

Visualization : Line Charts, Bar Graphs,KPI

Cards,Slicers,Drill-through

BUSINESS ANALYST-IT & Web Developer

Feb_2022 - Sep_2022

1_Feb_2022 - Sep_2022

Education

Project

Licences & Certifications

2024

Master of Science - MITX

Micro Masters PGP Program

for DS & ML (C.S).

MASSACHUINSTITUTE OF

TECHNOLOGYSETTS, with

Intellipaat, Banglore .

2017

B.TECH D egree (EC)

S.I.E.T, PRAYAGRAJ, U.P, INDIA

. Microsoft SQL Server Certificate ID 31679-

913***-******

https://lms.intellipaat.com/certificate-link/?

Yz1jdXMtOTEzMTY3JnU9MjI4NzI2JmV4dD0x

. Power BI Course Certificate ID

31679-913421-228726

https://lms.intellipaat.com/certificate-link/?

Yz1jdXMtOTEyMzgwJnU9MjI4NzI2JmV4dD0x

EDGE TELECOM PVT LTD

Gurugram - India

Dec_2017 - Aug_ 2018

PROJECT ENGINEER

I have done the work Commissioning,Punching & Labeling . I have worked on the Project to Complete the Network Capstone Dashboard

E-Commerce Sales Dashboard

Credit Card Performance Dashboard

University Admission Analysis Dashboard

Objective - DataTransformations,Advanced

USE Case - Design a dashboard to analyze the trend of admissions into state universities & Design a dashboard to analyze the trend of admissions into state universities.

. Integrated slicers and bookmarks to enable department-level drill downs. Linkedin Profile Aanlytics Dashboard in Power Bi

Objective - ToDevelopaComprehensiveCredit carddashboard that provides real-time insights into key performance metrics and trends, enabling stakeholders to monitor and analyze credit card Operations effectively.

. Highlighted key metrics : Monthly Revenue, Fraud rate,and Customer Churn.

. Created an Interactive dashboard to track sales, Profit,returns & regional performance .

.UsedPowerqueryfordatacleani ngandDAXforcustom KPIs. Created a KPI-based marketing dashboard with drill-down and filters. DAX used for CPC/CTR/Conversion metrics .

Designed custom visuals to help marketing teams make data-driven decisions.

UseCase: : Q&AfeatureofPower BI

.

.

Contact this candidate