Data Analyst Power Bi

Kanika Khurana

Data Analyst

Morrisville, NC

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

kanika khurana LinkedIn

EDUCATION

• Masters in Information Technology,

USA (2022-23)

• MBA in IT & Finance, India, 2013-

2015

• B.Tech in Electronics

&Communication(2007-2011)

ACHIEVEMENTS

• Winner in Python Hackathon.

• Participated in SQL Hackathon.

CAREER OBJECTIVE

Actively seeking a Data Analyst role where I can apply my passion for transforming data into valuable insights. I aim to leverage my strong analytical skills in a dynamic and collaborative environment to contribute to organizational success and drive data- informed decision-making that positively impacts the bottom line. SUMMARY

• Detail-oriented, collaborative, and team player data analyst professional who can work under pressure with minimal supervision.

• Proficient in utilizing Tableau, Excel, SQL, Python to analyse, visualize, and communicate data effectively.

• With a keen understanding of healthcare, engineering, and retail industries, I excel in conducting thorough data analysis to extract meaningful patterns and trends.

• Experience in implementing trigger and email alert systems for identification and monitoring.

WORK EXPERIENCE

Data Analyst

Numpy Ninja Inc., Dover, Delaware Mar 24 – Present Project1: Maternal Health Analysis

Tool: Power BI, PostgreSQL

• Built a data pipeline to extract and analyze maternal ultrasound data, comparing visceral fat measurements with hospital outcomes.

• Identified a 30% increase in preeclampsia and gestational complications among women with a high Visceral Fat to Subcutaneous Fat ratio.

• Utilized complex PostgreSQL statements to extract, stage, and transform data for analysis.

• Modeled and analyzed data in Power BI using advanced DAX functions and custom charts.

• Created dashboards that established a statistically significant link between hospitalization, labor, and fetal outcomes and nutrition. Project2: Gestational Diabetics Analysis

Tool: Power BI, PostgreSQL

• Cleaned and transformed data using Power Query functions like conditional columns, replace, and split, achieving 90% data accuracy.

• Analyzed factors contributing to gestational diabetes (GDM), identifying 12.3% of study participants as GDM patients, with age and obesity as significant risk factors.

• Discovered that 66.2% of GDM patients had a BMI 25, and excessive weight gain during pregnancy increased the likelihood of cesarean sections.

• Reduced redundant columns to improve data efficiency and streamline analysis.

• Developed interactive visualizations and drill-through reports in Power BI by connecting and loading data from PostgreSQL.

• Utilized advanced analytics to deliver actionable insights on pregnancy health risks

SKILLS

• Tableau

• PowerBI

• PostgreSQL

• My SQL

• Python (Jupyter)

• Jira

• Slack

• GitHub

• Excel

PUBLICATION

• How to Choose the Right Chart for

Your Data in Tableau

• How to Make a Dendrogram Chart

in Tableau

HOBBY AND INTEREST

• Cooking

• Reading

• Photography

• Creativity

• Dancing

Project3: Diabetes Analysis

Tool: Power BI

• Analyzed 121 patients’ diabetes history and medical conditions based on cognitive scores.

• Converted business requirements into technical specifications.

• Applied ETL framework and cleaned data in Power Query.

• Designed multi-dimensional data models and connected data from multiple sources.

• Developed dynamic dashboards and reports in Power BI.

• Created documentation for charts, including parameters, groups, and techniques.

• Identified key performance indicators (KPIs) and ran DAX queries in Power BI.

• Familiar with SQL for data extraction and manipulation in Power BI. Project4: Sepsis Patient Data Analysis

Tool: Tableau, Python, Jira

• Analyzed clinical datasets to design a KPI dashboard for ICU Sepsis patients, focusing on biomarker analysis and improving ICU efficiency by 30%.

• Performed data cleaning and manipulation in Python/Excel.

• Created LOD calculations, parameters, and filters for biomarker analysis, including SIRS and SOFA score identification using Tableau.

• Incorporated clinical parameters (heart rate, temperature, respiration, PaCO2, WBC) for patient monitoring and sepsis prediction.

• Utilized advanced Tableau features like dual axis, control charts, and correlation charts.

• Developed a trigger and email alert system in Tableau for patient monitoring. Data Analyst

Flipkart, Bengaluru, India Mar 18 – Aug18

Tool: Tableau, Python, Jira

• Managed Data warehouse/Data marts for Flipkart's supply chain team.

• Produced weekly and monthly operational reports on warehouse capacity and utilization using Snowflake and BI tools.

• Conducted analysis using Tableau Desktop, Excel, and PowerPoint to assess demand and supply across various product categories.

• Developed use cases and proofs of concept (POCs) to optimize intake of critical products and balance demand and supply.

• Supported the warehouse business operations team by addressing ad-hoc data questions.

Data Analyst

Livpure Private Limited,Gurugram,India

Tool: Excel, SQL Mar 12-May 14

• Responsible for managing customers’ complaints related to LivPure Water Purifier Products.

• Generated Tableau reports on Incident metrics and customer satisfaction and present them to Regional Heads on a weekly/monthly basis.

• Trained Support agents on using the Incident management tool to update the customer logs and promote customer surveys.

• Managed customer incidents and support agent allocation to customer-reported incidents.

• Used the CRM tool to manage customer relationships, including customer leads and customer purchases.

Contact this candidate