Pravallika Dheshidi
Summary
Detail-oriented Data Analyst with prior experience as an Environment Build Engineer in the financial services domain. Strong expertise in SQL, PostgreSQL, Tableau, Power BI, and Python for data cleaning, transformation, and visualization. Experienced in analyzing healthcare datasets, building KPI dashboards, and delivering actionable insights to stakeholders. Expertise at improving data quality, optimizing processes, and translating business requirements into data-driven solutions.
Overview
3
3
years of professional experience
Work History
Data Analyst
NumPy Ninja
07.2025 - Current
- Designed and developed KPI dashboards for ICU Sepsis patients using Tableau tracking key metrics such as Length of Stay (LOS), patient throughput, and mortality trends, contributing to improved ICU operational efficiency.
- Built dynamic dashboards using advanced Tableau features including Calculated Fields, Level of Detail (INCLUDE, EXCLUDE, FIXED), Parameters, Filters, and Sets.
- Identified and visualized SIRS (Systemic Inflammatory Response Syndrome) patients using vital signs (HR, Temperature, Respiration) and clinical parameters (PaCO₂, WBC) to support early risk detection.
- Analyzed demographic patterns revealing that patients aged 65+ (especially males) had longer hospital stays and increased sepsis vulnerability, informing targeted clinical interventions.
- Conducted biomarker analysis to identify key indicators (WBC, Platelets, Base Excess, Lactate), enabling clinicians to prioritize monitoring efforts effectively.
- Used advanced visualization techniques including Dual Axis charts, Control Charts, Pareto Charts, Correlation Plots, Heatmaps, Box Plots, and Scatter Plots to derive actionable insights.
- Utilized SQL and PostgreSQL for data extraction, transformation, and validation of clinical datasets.
- Designed and implemented data pipeline for Glycemic Variability dataset using PostgreSQL with joins, window functions, and triggers, structuring raw clinical data for real-time insights.
- Performed data cleaning, transformation, and missing value analysis using Python (Pandas, NumPy).
- Led maternal health data analytics project to improve maternal and newborn outcomes.
- Working with a dataset containing 100+ variables covering maternal demographics, pregnancy complications, delivery methods, and newborn outcomes.
- Designed and implemented a PostgreSQL staging schema to ingest and structure raw CSV data.
- Performed extensive data cleaning including handling missing values, correcting formatting issues, datatype conversions, and normalization.
- Developed interactive Power BI dashboards visualizing maternal risk indicators, delivery complications, and newborn health trends, enhancing informed decision-making.
- Conducted trend and correlation analysis to identify relationships between maternal conditions and birth outcomes.
- Ensured data quality and integrity through validation checks and transformation logic.
Environment Build Engineer
Northern Trust
Chicago, USA
11.2022 - 03.2024
- Configured and managed development and testing environments for financial applications and data workflows, ensuring stability and reliability.
- Configured and managed development and testing environments for financial applications and data workflows, enhancing stability and reliability.
- Supported CI/CD pipelines, validating data accuracy throughout build and deployment cycles to ensure successful releases.
- Monitored system logs and analyzed performance data to identify root causes of issues and improve system reliability.
- Collaborated with cross-functional teams (developers, QA, operations) to resolve data discrepancies, ensuring data integrity during releases.
- Utilized PostgreSQL to perform data validation, run complex SQL queries, and troubleshoot data inconsistencies.
- Identified inefficiencies and implemented automation solutions, contributing to process improvements and streamlining operations.
- Northern Trust is a leading global financial services company specializing in wealth management, asset servicing, asset management, and banking solutions.
Education
Bachelor’s degree - Electronics and Communications Engineering
JNTU
Hyderabad,India01.2011
Skills
- Data visualization
- Tableau
- Power BI
- SQL queries
- PostgreSQL
- Python
- Excel
- Git
Publications
- Https://www.numpyninjaacademy.com/post/using-healthcare-data-to-predict-sepsis-early
- Https://www.numpyninjaacademy.com/post/using-postgresql-user-defined-functions-udfs-for-clinical-analytics-1
Timeline
Data Analyst
NumPy Ninja
07.2025 - Current
Environment Build Engineer
Northern Trust
11.2022 - 03.2024
Bachelor’s degree - Electronics and Communications Engineering
JNTU