Power Bi Data Analyst

KISLAY KUMAR JHA

*****************@*****.*** +91-859*******

linkedin.com/in/kislay-kumar-jha-7421b52a5 github.com/kislaykumarjha82

EDUCATIONAL BACKGROUND

Bachelor of Business Administration (BBA) – Business & Data Analytics

Delhi School of Professional Studies and Research, CGPA: 8.17

Class XII — 2022

Yuvashakti Model School, Final Score: 72%

Class X — 2020

Yuvashakti Model School, Final Score: 69%

SKILLS

BI & Visualization: Power BI, Tableau, Looker, QlikView, Excel, Google Sheets, Google Data Studio

Databases & SQL: MySQL, PostgreSQL, SQL Server, pgAdmin, Data Modeling, Query Optimization

Data Ops & Automation: Python (Pandas, NumPy, Matplotlib, SciPy), ETL, Automation, Data Cleaning

AI & Predictive Analytics: Machine Learning, Regression, Forecasting, Scenario Modeling, Generative AI

Digital Analytics: Google Analytics, SEO Analytics, Web/App Analytics, A/B & Multivariate Testing

Business Insight & Strategy: KPI, EDA, Business Analysis, Market Research, Growth Analytics

WORK EXPERIENCE

Data Analyst – Abros Sports International Pvt. Ltd.

Dec 2024 – Jun 2025 Hybrid Gurugram

Propelled sales growth and optimized operations by transforming multi-channel data into actionable

insights, driving smarter pricing strategies, high-impact promotions, and inventory planning.

Developed automated Power BI and Excel dashboards with ETL pipelines, delivering real-time KPI

visibility, improving reporting speed by 30%, and ensuring robust data integrity across business.

Analyzed flagship products, marketing campaigns, and competitor trends (e.g., HyperBeads & glow-in-the-

dark shoes), guiding targeted marketing and customer engagement to maximize ROI.

Streamlined KPI forecasting and executive reporting, enabling agile decision-making and strengthening

Abros Shoes position as a market leader in sports footwear.

Skills & Tools: Power BI, Excel, SQL, Python, Advanced Data Visualization, Interactive Dashboard

Development, KPI Measurement & Optimization, Strategic and Predictive Analytics, Business Intelligence,

Market & Competitor Research, Business Consulting, Growth Strategy, Data Governance & Quality Assurance,

Cross-Functional Stakeholder Collaboration, Complex Problem Solving.

E-commerce Data Analyst Intern – Amazon Retail Databases

Oct 2023 – Mar 2024 Remote Rohini

Processed and integrated 100k+ transactional and customer records using SQL, Python, Excel, and Google

Sheets, ensuring complete accuracy, consistency, and reliability across datasets.

Conducted in-depth analysis of customer behavior, purchase patterns, and product performance with SQL,

Python, Tableau, and Power BI, delivering actionable insights that improved sales, marketing, and lead

generation strategies.

Developed interactive dashboards in Power BI, Tableau, Excel, and Google Sheets to track KPIs, revenue

trends, customer segmentation, and regional performance for data-driven decision-making.

Implemented data validation, anomaly detection, and scenario modeling to enhance operational efficiency,

optimize campaign targeting, and identify new business growth opportunities.

COLLEGE PROJECTS

Power BI Dashboards & Automated Reporting

Developed enterprise-grade dashboards for top brands like Blinkit, Reliance, and Café Coffee Day,

integrating complex sales, temperature, and customer data. Automated KPI tracking and regional insights,

enabling leadership to drive strategic, data-driven decisions quickly.

Big Data Analytics & Operational Insights (MySQL, Python)

Handled 30M+ rows of workforce, payroll, sales, and inventory data to deliver forecasts and anomaly

detection. Optimized staffing, improved payroll accuracy, and identified cost-saving opportunities.

Customer Retention & Conversion Analysis (SQL, Excel)

Built advanced EDA pipelines and retention models for e-commerce platforms, revealing customer

segments and underperforming products, enhancing personalized marketing and boosting ROI.

Predictive Retail Analytics (Python, SQL)

Created models highlighting seasonality, revenue drivers, and operational bottlenecks to optimize inventory,

demand forecasting, and market strategies—improving profitability.

SQL Intelligence Solutions (Amazon, Netflix, Spotify, Library Management)

Designed and built scalable SQL-driven analytics platforms for major brands and management systems—

streamlining reporting, market analysis, and business intelligence.

Advanced Data Pipeline Automation (ETL, Python)

Built automated ETL pipelines that streamlined data extraction, transformation, and loading. Improved data

quality, sped up reporting, and enabled scalable, accurate analytics.

EXTRACURRICULAR ACTIVITIES

Led a student club, building skills in planning, coordination, and communication.

Organized sessions to boost logical thinking and problem-solving.

Collaborated with cross-functional teams, improving teamwork and adaptability.

Gained experience in analysis, decision-making, and clear communication.

Evaluated feedback to improve club activities, strengthening data-driven thinking and

leadership skills.

CERTIFICATIONS

• Master in Data Analysis and Analytics — Udemy

• Python for Data Analysis — Udemy

• NumPy, SciPy, Matplotlib & Pandas A–Z: Machine Learning — Udemy

• SQL for Data Science, Business Analysis & Data Management — Udemy

• Power BI Desktop Specialist (Advanced) — Udemy

• Generative AI, AI, and Data Analysis — Udemy

• Diploma in MS Excel — CTC Academy

• Digital Marketing — AMROZ Compo-Info Institute

HOBBIES

Exploring global cuisines and food culture.

High-intensity fitness training and endurance challenges.

Motorcycle riding and road exploration.

Creative video editing and digital storytelling.

Performing music and engaging in community events that foster connections.

Contact this candidate