Rutuja Agrawal

Experience

1. Data Analyst

   Numpy Ninja

   Mar 2024 — Present

   Worked with clinical dataset for designing a KPI dashboard (Length of stay, throughput etc.) for ICU Sepsis patients using Tableau calculated field, Level of Detail (include, exclude, fixed), filters, parameters, sets which will help to improve ICU operational efficiency by 30%-Determined SIRS using advanced Tableau visualization feature and created a dashboard for the identified SIRS patients\' using vitals - HR, temperature, Respiration and clinical parameters – PaCo2 and WBC, thus helping the stakeholders to identify and monitor patients more susceptible to the further stages of Sepsis-Used python pandas / numpy library for data cleaning, data wrangling and missing data analysis-Adept in Python visualization libraries like matlplotlib and seaborn for deriving insights through exploratory data analysis-Analyzed a large real-world healthcare dataset to identify patterns and risk factors related to gestational diabetes and maternal-infant health-Wrote and optimized over 80+ complex SQL queries, including window functions (RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD()) and aggregate functions to extract insights across visits and patient groups-Created custom metrics and derived fields like Mean Arterial Pressure (MAP), glucose averages, and BMI categories using CASE, width_bucket(), and conditional logic-Addressed data quality challenges by handling NULL values, missing visits, and incomplete records to ensure reliable trend analysis and avoid skewed results-Developed interactive Power BI dashboards to visualize motor and non-motor symptom trends, helping clinicians identify early progression patterns in Parkinson’s patients-Integrated and transformed clinical datasets using Power Query to clean, filter, and model patient visit-level data for time-based analysis-Implemented DAX measures and KPIs to track changes in tremor severity, medication response, and symptom onset across different stages of the disease.

Skills

• Project Management
• Team Leadership
• Engineering
• Market Research
• Business Analysis
• Competitive Analysis
• Microsoft Office