Himansh Rajak

Data Specialist | Data Analytics | Python, SQL & Business Intelligence

B.S. Data Science • 2.5+ Years Experience

$207M Savings Identified
2,496 Hospitals Analyzed
3 Major Projects
2.5+ Years of Experience

About Me

Transforming data into actionable insights

Analytics professional dedicated to driving operational efficiency and financial impact through data-driven storytelling. I have successfully managed multi-million dollar project lifecycles , secured 90% federal subsidies for infrastructure deployments , and exceeded program enrollment targets by 109%.

With a multidisciplinary background that includes quality control in engineering and proposal coordination in telecom, I bring a unique perspective to data validation and integrity. I am an expert in identifying 'exceptions' and bottlenecks, helping teams move from reactive reporting to proactive strategy. My goal is to help organizations not just collect data, but master it to facilitate faster, smarter decision-making.

Featured Projects

End-to-end analytics solutions from database design to interactive dashboards

🏥 Hospital Readmission Analytics

Power BI DAX Healthcare CMS Data

Comprehensive analysis of 2,496 U.S. hospitals using CMS data to identify cost-saving opportunities and performance improvement strategies.

$207M
Savings Identified
2,496
Hospitals Analyzed
3
Dashboard Pages
15+
DAX Measures
Key Features
  • Geographic heat map showing state-level performance
  • Interactive scatter plots correlating satisfaction & readmissions
  • Financial ROI analysis with waterfall charts
  • Dynamic filtering and drill-through navigation

🗄️ Hospital Database Management System

SQL Database Design SQLite Healthcare

Normalized relational database with advanced SQL queries demonstrating database design, complex analytics, and healthcare data management.

10
Normalized Tables
237
Data Records
4
Complex Queries
3NF
Normalization
Key Features
  • Multi-table JOINs (up to 6 tables)
  • Window functions (RANK, LAG, LEAD)
  • CTEs for complex query organization
  • Patient, appointment, and billing analytics

📦 Supply Chain: The True Cost of Speed

Power BI DAX Supply Chain Cost Optimization

Comprehensive operational and financial analysis evaluating order profitability, delivery SLA performance, and expedited shipping margin erosion across global markets.

180K+
Orders Analyzed
4
Shipping Modes
3
Dashboard Pages
12+
DAX Measures
Key Features
  • Expedited shipping vs. net profit margin trade-off analysis
  • Scheduled vs. actual delivery variance tracking
  • Geographic & market late-delivery risk heatmaps
  • High-discount negative margin order identification

Technical Skills

Comprehensive toolkit for data analysis, visualization, and database management

Data Analysis & Visualization

  • Power BI (Advanced DAX)
  • Tableau
  • Python (Pandas, NumPy)
  • Excel (Advanced)

Database & SQL

  • SQL (PostgreSQL, MySQL, SQLite)
  • Database Design (3NF normalization)
  • Complex Queries (JOINs, CTEs, Window Functions)
  • Data Modeling

Machine Learning & Research

  • PyTorch & TensorFlow
  • CNN Architecture Design
  • Statistical Analysis
  • Research Methods

Healthcare Domain

  • CMS Data Analysis
  • Healthcare Metrics (Readmissions, Quality)
  • HIPAA Principles
  • Clinical Data Management

Get In Touch

Open to data analytics and related opportunities

📍

Location

Chesterfield, Missouri

🎯

Seeking

Data Analyst

Business Analyst

and Related Roles