Data Analyst Power Bi

Diligent BI developer/Data analyst experienced in developing, visualizing, analyzing and deploying

health data solutions with Power BI and Tableau to gather stakeholder feedback and improve process efficiency. Proficient in developing ETL solutions to Extract, Transform, and Load (ETL) data into SQL Server data warehouse.

Data Analyst, NumPy Ninja

Feb 2022 - Present

Visual Story-teller skilled at creating insightful representations from datasets for soliciting feedback from the stakeholders and incorporating the same to enhance efficacy of processes. 1.Proficient in design and development of dashboards, reports utilizing Tableau Visualizations using various chart.

3.Extensively used SQL for creating Tables, Views, SQL joins, indexing and writing complex SQL queries for data analysis

4.Strong Knowledge of Data Extraction, Transformation and Loading (ETL) from multiple sources in Data warehouse.

5. Developed dashboards, automated reports, and KPI score cards in Power BI Tool 6. Applied advanced Power BI features such as row-level security, bookmarks, selection panes, buttons, and tooltips, with expertise in data modeling, visualization, and application security. 7. Used Power query editor in Power BI, DAX functions to perform cleansing and processing of data. 8. 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% 9. Determined SIRS using advanced Tableau visualization feature and created a dashboard for the identified SIRS patients' using vitals - HR, temperature, Respiration and clinical parameters – HCT and WBC, thus helping the stakeholders to identify and monitor patients more susceptible to stages of Sepsis.

the further

10. Analyzed the role of demographic parameters with respect to sepsis which helped in inferring that patient’ in the higher age bracket (65+) especially males have a longer length of stay and are more vulnerable to sepsis as compared to females.

11. Identified the dominant biomarkers - WBC, Platelets, base Excess and lactate which plays a significant role in the incidence of Sepsis ELEVANT SKIL 12. Used python pandas / NumPy library for data cleaning, data wrangling and missing data analysis. 13. adopt Python visualization libraries (Matplotlib, Seaborn) to perform exploratory data analysis, uncovering key insights and trends within datasets. 14. Applied weighted hyperparameter feature for improving the data imbalance to 90 % and hence model performance by 70%.

15. Involved in the process of implementation JIRA Methodology using Scrum and Trello. PROFESSIONAL EXPERIENCE

PROFILE

LinkedIn

Tableau

SQL-Hackathon-Runnerup

Constraints-In-SQL

Normalisation

Professional Achievements

Got appreciation for writing an outstanding

blog on SQL Normalization

********.******@*****.***

Mar 2011 – Aug 2014 Agency collection manager

1.Used Microsoft Office to efficiently manage large datasets and perform complex calculations while monitoring collection calls to ensure compliance with industry standards, resolving conflicts, and organizing tasks effectively.

2.Actively managed bank customers with overdue payments, working diligently to settle accounts and clear defaulters, while also participating in audits with collection agencies to resolve issues and oversee marketing initiatives, gaining extensive exposure to the banking and financial sector. Project : Sepsis

1.Derived the creation of insightf u l data visualizations to engage business stakeholders, gather actionable feedback, and implement process improvements for greater efficiency. 2.Analyzed demographic factors in relation to sepsis, revealing that male patients aged 65+ have longer lengths of stay and are more vulnerable to sepsis compared to female patients, providing actionable insights for targeted care strategies.

3.Developed a KPI dashboard for ICU Sepsis patients, optimizing Length of Stay and throughput metrics using Tableau features like calculated fields, Level of Detail (LOD), filters, parameters, and sets, driving a 30% improvement in ICU operational efficiency

4.Leveraged advanced Tableau visualizations to determine SIRS, creating a dashboard for patients based on vitals (HR, temperature, respiration) and clinical parameters (PH, HCT, WBC, LACTATE, HCO3), enabling stakeholders to identify and monitor patients at higher risk of progressing to further stages of Sepsis. Project : Maternal Health

1.Imported Data from Postgres SQL Servers and written SQL Queries to extract data from Tables, Group,Order.

2.Used DDL DML commands to get desired result for analysis. Used SQL Commands, SQL Constraint CTE, Views and SQL Joins during development

3.Extensively used SQL for creating Tables, Views, SQL joins, indexing and writing complex SQL queries for data analysis

4.Experience in analyzing the Bl needs, interpreti ng business user requirements and translating them into insights in the form of Dashboards.

5.Developed advanced Power BI solutions by utilizing DAX for filtering and logical functions, creating customized charts and visuals, implementing bookmarks, buttons, and drill-throughs, applying implicit filters and custom columns, setting up row-level security, and managing scheduled refreshes to meet complex business requirements.

Tableau

PROFESSIONAL EXPERIENCE

PROFESSIONAL EXPERIENCE

PROFESSIONAL EXPERIENCE

ICICI BANK

Contact this candidate