dishtisoni

Patient 360 Data Model Optimization - ZS: Implemented a Power BI and SQL-driven Patient 360 Snowflake model—enhancing data accuracy and enabling strategic KPI tracking and performance analysis. HCP Data Visualization Strategy: Designed a structured approach to transform healthcare provider datasets into Power BI dashboards using advanced SQL queries, strengthening data accessibility and decision-making. Assisted in the development of a CI project tracking tool and communication framework, contributing to a 30% improvement in reporting efficiency and increased engagement across 10+ cross-functional teams. Supported process documentation efforts and ICP training rollout, helping achieve a 90% documentation target and onboard 60+ team members with a 95% training satisfaction rate.

PostgreSQL Skills Development: Mentored 35 students in PostgreSQL, improving class performance by 15% and student confidence by 20% through hands-on learning and project reviews. Curriculum Support & Assessment: Reinforced comprehension of IT strategy principles by grading article-based assignments and offering actionable feedback.

Lean Process Optimization: Supported data cleaning and documentation efforts to apply Lean principles, contributing to a 30% reduction in lead time through streamlined processes. Business Intelligence (BI) Automation for Property & Casualty (P&C) Reports: Assisted in automating Power BI dashboards using Power Query, improving reporting efficiency and accuracy for Property and Casualty Loss Run analytics. Business Process Model and Notation (BPMN) & Data Mapping Visualization: Created process integration flows and data mappings using Microsoft Visio, enhancing workflow transparency across underwriting teams.

Assisted in ETL Development: Supported the development of SQL Server Integration Services (SSIS) packages to extract data from Online Transaction Processing (OLTP) systems and load it into Online Analytical Processing (OLAP) data warehouses. Contributed to Data Pipeline Optimization: Helped identify performance issues in ETL processes, contributing to a 25% reduction in runtime by applying tuning recommendations. Supported Full SDLC: Participated in various stages including design, development, testing, and deployment of business intelligence solutions under the guidance of senior team members. Helped Automate Manual Reporting Tasks: Contributed to automating recurring reporting processes, resulting in 40% time savings and enhanced report consistency.