# Shashi Ranjan Kumar

Shashi Ranjan Kumar is a remote worker on Himalayas, Software Engineer - Data Analyst at BlueHim Solutions, based in India.

Source: https://himalayas.app/@shashiranjankumar1

```text
Data Analyst and SQL Developer transforming complex datasets into actionable insights with optimized T-SQL and Power BI.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | India |
| Authorized to work in | India |
| Job categories | Data Analyst, SQL Developer, Power BI Report Developer, Data Engineer, Data Analytics Specialist, Data Analyst |
| Skills | Excel, Microsoft SQL Server, MySQL, T SQL, Stored Procedures, Views, Triggers, User Defined Functions, Indexing, Query Optimization, Power BI, DAX, Data Modeling, Dashboard Design, KPI Tracking, ETL Processes, Report Automation, Data Quality Management, Python, Database Modeling, SQL, Data Cleaning, Performance Optimization |

## What I'm looking for

```text
I’m looking to build scalable, automated analytics that turn messy data into real-time KPI dashboards, fast ETL pipelines, and well-tuned SQL—partnering closely with stakeholders to deliver measurable business impact.
```

## About

```text
I’m a Data Analyst and SQL Developer with 4+ years of experience transforming complex datasets into actionable business insights. I specialize in T-SQL query optimization and end-to-end ETL pipeline design, so teams get reliable data faster.

In my current role, I designed and optimized 50+ complex T-SQL queries, stored procedures, views, and triggers in Microsoft SQL Server, reducing average query execution time by ~30%. I also architected and deployed 10+ interactive Power BI dashboards tracking key business KPIs, cutting manual reporting effort by over 40%.

I focus on scalable data infrastructure and measurable impact: I built advanced Power BI data models using DAX to improve performance, led database performance tuning across MySQL and SQL Server, and implemented data cleansing and validation frameworks that reduced report discrepancies by ~25%. I enjoy partnering with stakeholders to translate ambiguous reporting needs into precise, automated analytics solutions.
```

## Experience

### Software Engineer - Data Analyst (current)

BlueHim Solutions. Feb 2022 - Present

```text
Designed and optimized 50+ complex T-SQL queries, stored procedures, views, and triggers in SQL Server, reducing average query execution time by ~30%. Architected 10+ interactive Power BI dashboards and built automated ETL workflows, cutting weekly manual reporting time by 10+ hours and reducing report load times by up to 35%.
```

Skills: T-SQL, Microsoft-SQL-Server, Power-BI, DAX, ETL, Stored-Procedures, Data-Modeling, Query-Optimization, Indexing, Data-Quality-Management

## Education

### Noida Institute of Engineering & Technology

Bachelor of Technology, Electrical, Electronics & Communications Engineering. 2013 - 2017

```text
Bachelor of Technology in Electrical, Electronics & Communications Engineering from 2013 to 2017.
```

## Tech stack

- MySQL
- Microsoft SQL Server
- Gmail
- Microsoft Excel
- SQL

To contact Shashi Ranjan, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Rohan Peter Dabre](https://himalayas.app/@rohanpeterdabre): Data Analyst, ViewAnalytics
- [Anusha Sainath](https://himalayas.app/@anushasainath): Senior SQL Developer, GTRTek
- [Nikita Thorat](https://himalayas.app/@nikitathorat): Data Analyst, Subtle Solutions
- [Pavan Kumar](https://himalayas.app/@pavankumar28): SQL Developer, Dalvkot IT
- [prasanth kancharana](https://himalayas.app/@prasanthkancharana): Data Analyst & BI Developer, Sutherland Global Services
- [Sairam Konakanchi](https://himalayas.app/@sairamkonakanchi): Data Analyst, Self Employed
- [Harsha Vardhan](https://himalayas.app/@harshavardhan8): Data Analyst Intern, Full Stack Academy
- [Mansi Somani](https://himalayas.app/@mansisomani): BI Engineering Analyst, Accenture
- [saurabh chauhan](https://himalayas.app/@saurabhchauhan3): Associate Consultant, KPMG
- [Vishnu Saravanan](https://himalayas.app/@vishnusaravanan): Data Analyst, ACSASS
