Skip to content
View Prakaran-SSharma's full-sized avatar
🎯
Focusing
🎯
Focusing
5 followers · 18 following

Achievements

Achievement: Pull SharkAchievement: Quickdraw

Achievements

Achievement: Pull SharkAchievement: Quickdraw

Block or report Prakaran-SSharma

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Prakaran-SSharma/README.md

👋 Hi, I'm Prakaran Kumar Sharma

📊 Data Analyst | SQL Server | Power BI | Python | Business Intelligence

I'm a Data Analyst (Reporting & Analytics) with 6+ years of overall experience, including 4+ years specializing in SQL Server, Power BI, and Business Intelligence.

I enjoy transforming raw data into meaningful insights that help businesses make informed decisions. My experience spans the complete analytics lifecycle—from gathering business requirements and writing optimized SQL queries to building scalable Power BI dashboards and presenting actionable insights to stakeholders across HR, Finance, Recruitment, and Operations.

🚀 What I Do

✔️ Build interactive Power BI dashboards for business performance monitoring.

✔️ Develop optimized SQL solutions using Joins, CTEs, Window Functions, Views, and Stored Procedures.

✔️ Design scalable Star Schema data models for high-performance reporting.

✔️ Use Python (Core), Pandas & NumPy for data cleaning, automation, and exploratory data analysis.

✔️ Automate reporting processes to reduce manual effort and improve data accuracy.

✔️ Collaborate with stakeholders to convert business requirements into KPI-driven analytics solutions.

🛠️ Tech Stack

💾 SQL & Databases

SQL Server PostgreSQL

Skills

  • SQL Server
  • PostgreSQL
  • Advanced SQL
  • Joins
  • CTEs
  • Window Functions
  • Views
  • Stored Procedures
  • Query Optimization
  • Indexing

📊 Business Intelligence

Power BI

Skills

  • Power BI
  • DAX
  • Power Query
  • Data Modeling
  • Star Schema
  • KPI Dashboards
  • Row-Level Security (RLS)
  • Incremental Refresh

🐍 Python & Data Analytics

Python

Skills

  • Python (Core)
  • Pandas
  • NumPy
  • Data Cleaning
  • Data Manipulation
  • Exploratory Data Analysis (EDA)
  • File Handling
  • Automation

📈 Reporting & Analytics

  • Advanced Excel
  • Pivot Tables
  • Power Pivot
  • XLOOKUP
  • INDEX-MATCH
  • Dashboard Design
  • Insight Storytelling

⚙️ Tools & IDEs

  • Power BI Desktop
  • SQL Server Management Studio (SSMS)
  • pgAdmin 4
  • Jupyter Notebook
  • Visual Studio Code
  • Git
  • GitHub
  • Microsoft Excel

📂 Featured Projects

📌 SQL Interview Practice (100+ SQL Questions)

📌 Recruitment Analytics Dashboard (SQL Server + Power BI)

📌 HR Data Cleaning with Pandas

📌 Exploratory Data Analysis

📌 NumPy for Data Analytics

🌱 Currently Learning

  • Advanced SQL Optimization
  • Python for Data Analytics
  • Pandas & NumPy
  • Statistics for Data Analytics
  • End-to-End Data Analytics Projects

🎯 Career Goal

To become a well-rounded Data Analyst by combining strong SQL, Power BI, and Python skills to build scalable analytics solutions that help organizations make faster and smarter business decisions.

📫 Connect with Me

📧 Email: PrakaranK6@gmail.com

💼 LinkedIn: https://linkedin.com/in/prakaran-kumar-sharma

💻 GitHub: https://github.com/Prakaran-SSharma

Popular repositories Loading

  1. SQL-Interview-Practice-100-Questions SQL-Interview-Practice-100-Questions Public

    Master SQL for Data Analytics with 100+ interview questions, SQL Server examples, Joins, CTEs, Window Functions, Views, Stored Procedures, and business scenarios. A comprehensive SQL interview prep…

    1

  2. HR-Dashboard HR-Dashboard Public

    HR Dashboard developed in Power BI, designed to provide a comprehensive overview of key human resource metrics for decision-makers and HR professionals. It showcases employee demographics, job role…

  3. SQL-Functions- SQL-Functions- Public

    SQL- what are SQL Functions ?

  4. Retail-Sales-data----SQL-Beginner-Project Retail-Sales-data----SQL-Beginner-Project Public

    📊 Project Overview – Retail Sales Analysis The Retail Sales Analysis Project demonstrates the practical use of SQL in analyzing transactional data from a retail business. By leveraging SQL queries,…

    TSQL

  5. Recruitment-Finance-Tracker-SQL-Architecture-for-IT-Consulting Recruitment-Finance-Tracker-SQL-Architecture-for-IT-Consulting Public

    SQL-based recruitment finance system replacing Excel workflows. Includes normalized schema, views, and stored procedures for billing, vendor payouts, candidate tracking, and compliance. Built in SS…

    TSQL

  6. Prakaran-SSharma Prakaran-SSharma Public

    Hello World! This is Prakaran Kumar Sharma | 🔍 Data Analyst | Power BI & SQL Specialist | Data Storyteller | Vendor & Recruitment Analytics | Vendor Intelligence & KPI Dashboards | Turning Data int…