Summary
Overview
Work History
Education
Skills
Websites
Certification
Projects
Timeline
Generic

JUWAIRIYA KHAN

Hoffman Estates,IL

Summary

Data Analyst with 1+ years of experience specializing in data visualization, business intelligence, and predictive analytics. Proficient in SQL, Power BI, and Tableau, with a proven track record of leveraging data to optimize operational performance and inform strategic decisions. Notable achievements include developing KPI dashboards that improved efficiency by 20% and creating customer segmentation models that boosted conversion rates by 15%. Committed to turning raw data into actionable insights to drive organizational success.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Data Analyst

Benda Infotech
12.2023 - Current
  • Enhanced data quality by integrating and cleaning datasets from multiple sources using MySQL queries and ETL pipelines, reducing inconsistencies by 25%
  • Developed predictive models using Python and R with 90% accuracy, forecasting market trends and enabling data-driven strategic planning for a 10% increase in efficiency
  • Designed and deployed interactive dashboards in Power BI and Tableau to visualize key operational metrics, leading to a 20% improvement in workflow efficiency across departments

Data Analyst

AI VARIANT
05.2023 - 10.2023
  • Created KPI dashboards in Tableau and Power BI to monitor key operational metrics, enabling real-time decision-making and improving operational performance by 15%
  • Engineered customer segmentation models leveraging MySQL queries and advanced Excel functions, resulting in a 15% increase in targeted marketing conversion rates through enhanced audience insights

Education

MBA - Human Resource Management

Osmania University
Hyderabad, India
05.2019

B Com - Accounts and Finance

Osmania University
Hyderabad, India
05.2017

Skills

  • Data analysis and visualization
  • Business Intelligence
  • Predictive and Statistical Modeling
  • Descriptive Analytics
  • ETL and Data Cleaning
  • Data-Driven Decision Making
  • Cross-Functional Coordination

IT SKILLS

  • Programming Languages: Python (Pandas, NumPy, Matplotlib, Seaborn), R
  • Databases: MySQL, PostgreSQL
  • Microsoft Office (Word, PowerPoint)
  • Data Processing and ETL: Advanced Excel (Pivot tables, VLOOKUP, Macros), SAS
  • Analytics Techniques: Statistical Analysis, A/B Testing, Hypothesis Testing, Regression Modeling
  • Data Visualization Tools: Power BI, Tableau

Certification

  • Certificate of Advanced Studies in Data Analysis and Business Analysis, 01/24, Specialized in advanced data modeling, business intelligence, and data visualization techniques.
  • Certificate of Internship Project in Data Analysis, 12/23 - 03/24, Focused on real-world data analysis scenarios, including KPI reporting and predictive modeling for business applications.
  • Power BI 'Dashboard in a Day' Certification by Microsoft, 12/23, Mastered the creation of interactive dashboards to visualize complex datasets and improve data-driven decision-making.

Projects

British Airways Review Analysis using Tableau:

  • Conducted a comprehensive analysis of over 10,000 customer reviews to identify key drivers of satisfaction related to cabin service, entertainment, and food quality.
  • Segmented customer feedback by traveler type, seat class, aircraft type, and geographic region using Tableau visualizations, uncovering actionable insights to target service improvements.
  • Recommended strategic enhancements that improved customer satisfaction metrics by 10% and informed executive decision-making. Tools: Excel, MySQL, Tableau, Statistical Analysis, PowerPoint

Patient and Disease Data Analysis using Python: 

  • Analyzed a dataset of 50,000+ patient records using Python libraries (Pandas, NumPy) to uncover trends in disease prevalence and geographic distribution.
  • Developed visualizations with Matplotlib and Seaborn to highlight correlations between demographics and disease impacts, supporting evidence-based policy recommendations.
  • Improved analysis efficiency by automating data cleaning and preprocessing workflows, reducing manual effort by 30%. Tools: Python (Pandas, NumPy, Matplotlib, Seaborn), Excel

Statistical Analysis HR Analytics Insights using Power BI: 

  • Designed and implemented interactive dashboards in Power BI to analyze HR metrics, including attendance patterns and remote work trends, across a workforce of 5,000+.
  • Identified a 15% increase in sick leave occurrences during peak seasonal periods, enabling targeted wellness initiatives. Tools: Power BI, Excel, Statistical Analysis

Timeline

Data Analyst

Benda Infotech
12.2023 - Current

Data Analyst

AI VARIANT
05.2023 - 10.2023

MBA - Human Resource Management

Osmania University

B Com - Accounts and Finance

Osmania University
JUWAIRIYA KHAN