Open to opportunities

Shashi Ranjan Kumar

@shashiranjankumar1

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

India

Message

What I'm looking for

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.

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

Work history, roles, and key accomplishments

Current

Software Engineer - Data Analyst

Current

BlueHim Solutions

Feb 2022 - Present (4 years 3 months)

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%.