Power BI Analyst - Data Analytics Specialist

ROHIT GUPTA

Power Bi Analyst Data Analyst

email: mailto:**********@*****.*** phone: tel:+91-739******* location: Noida, UP, India linkedin: https://linkedin.com/in/rohit-gupta-85392b128 EXPERIENCE

Power Bi Analyst Data Analyst

Smartest Software Solution

Date: Feb 2024 – Present Location: Noida, UP, India

• Worked with business stakeholders to gather requirements and under- stand business KPIs.

• Collected data from multiple sources and performed data cleaning and transformation using Power Query.

• Designed and developed optimized data models,to support analytical reporting.

• Created Power BI datasets and established relationships for accurate reporting.

• Developed interactive Power BI reports and dashboards Gateway data sources as per business requirements.

• Built DAX measures and calculated columns to generate actionable in- sights.

• Created business-focused Visualization using Matplotlib, Seaborn, and Power Bi to Support .

• Implemented Row-Level Security (RLS),to ensure data confidentiality and role-based access.

• Analyzed large datasets using Python (Pandas, NumPy) and SQL to identify business trends,performance gaps, and actionable insights. NOC Engineer

Tele Logix Communication Services Pvt Ltd (VI)

Date: Oct 2022 – Jan 2024 Location: Bhopal, Madhya Pradesh, India

• Possess hands-on knowledge of Change Request (CR) activities within the Transmission Department, including Node Insertion, Node Deletion, and Traffic Shifting.

• Performed Node Upload and Node Insertion activities on Huawei SDH Network Management System (NMS) .

• Integrated third-party services for KLM 1-to-1 configurationsto ensure seamless network integration and continuity.

• Coordinated and executed traffic shifting activities at BTS sites in col- laboration with the RAN department.

Web Developer Business Analyst-IT

M1 Logix Technologies

Date: Oct 2021 – Sep 2022 Location: Lucknow, Uttar Pradesh, India

• Possess hands-on knowledge of Designed, developed, and maintained internal company websites using HTML, CSS, and PHP

• Partnered with clients and internal stakeholders to gather business re- quirements and deliver customized web solutions aligned with objec- tives.

• Contributed to both front-end and back-end development, ensuring functionality, performance, and user experience.

• Collaborated with cross-functional teams and supported team members to ensure smooth development and timely delivery.

Junior Engineer

ABOUT ME

Data Analyst delivering actionable business

insights through data modeling,analysis,and

interactive dashboards using Power BI,

DAX, Power Query, Excel, SQL Server with

strong stakeholder reporting experience and

decision-driven outcomes.

STRENGTHS

Sql Server Power Bi Dax ETL

Excel Data Visualization

Data Modeling Python

Snowflake Schema Pandas Numpy

Relationships Drill-through Measures

Power Bi Service WorkSpace Management

Git Bi SSMS

LANGUAGES

English 4.5

Hindi 5

EDUCATION

B.Tech in Electronics and Communi-

cation Engineering (2017)

A.K.T.U

Master of Science-Micro Masters

PGP Program for DS and ML in IT (

2024)

Massachusetts Institute of Technology

CERTIFICATIONS

Microsoft SQL Server Certification

(ID: 31679-913167-228726)

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

link/?Yz1jdXMtOTEzMTY3JnU9MjI4Nz

I2JmV4dD0x

Intellipaat in Collaboration with MIT

Microsoft Power BI Certification

Sai India Tech Solutions (P) Ltd

Date: Sep 2018 – Jan 2020 Location: Delhi, Delhi, India

• Installed and commissioned BSC/TRC, RBSC, MSS, MGW, BLADE nodesand associated EPDU and ODF infrastructure.

• Performed exchange cabling activities in accordance with approved C- Module and network design references.

• Coordinated with cross-functional teams to ensure smooth integration and minimal service disruption.

Project Engineer

Edge Telecom Pvt Ltd

Date: Dec 2017 – Aug 2018 Location: Gurugram, Haryana, India

• Executed commissioning, punching, and labeling activities as part of end-to-end network deployment projects.

• Worked on multiple telecom projects to support network completion, activation, and operational readiness .

• Contributed to projects for major telecom clients including Bharti Airtel, Nokia, BSNL, and Vodafone.

PROJECTS

E-Commerce Sales Dashboard Power Bi, Dax,Visualization

• Designed and developed an interactive E-Commerce Sales Dashboard to track sales, profit, returns, and regional performance .

• Utilized Power Query for data cleaning, transformation, and modeling.

• Created custom KPIs and measures using DAX to support performance analysis and business decision-making.

Credit Card Performance Dashboard Power Bi,Dax,Power query

• Designed and developed a Comprehensive Credit Card Performance Dashboard to enable stakeholders to effectively monitor and analyze credit card operation.

• Tracked and visualized key performance metrics, including monthly rev- enue, fraud rate, and customer churn, to support data-driven decision- making.

Exploratory Data Analysis Python,Pandas,Numpy

• Performed Exploratory Data Analysis (EDA) using Python (Pandas, NumPy, Matplotlib, Seaborn)to identify patterns, trends, and anomalies.

• Executed data cleaning, preprocessing, and manipulation, to ensure accuracy and reliability of datasets.

• Developed analytical dashboards and visualizations, to present insights effectively.

Diwali Sales Analytics Project Python, Matplotlib, Seaborn,Pandas, Numpy

• Analyzed Diwali sales data using Python to uncover top-selling prod- ucts, high-spending customer segments, and region-wise sales trends.

• Performed data cleaning, preprocessing, and Exploratory Data Analysis

(EDA) to ensure accuracy and reliability of insights.

• Created meaningful visualizations using Matplotlib and Seaborn to identify customer purchasing behavior and seasonal demand patterns.

(ID: 31679-913421-228726)

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

link/?Yz1jdXMtOTEzNDIxJnU9MjI4NzI2

JmV4dD0x

Intellipaat in Collaboration with MIT

Data Science Certification

(ID: 31679-912380-228726)

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

link/?Yz1jdXMtOTEyMzgwJnU9MjI4NzI2

JmV4dD0x

Intellipaat in Collaboration with MIT

Machine Learning with Python: From

Linear Models to Deep Learning

(ID: 69838ae082fb493eafe39435e792b

432)

https://courses.edx.org/certificates/698

38ae082fb493eafe39435e792b432

Massachusetts Institute of Technology

Contact this candidate