RAJ DEDHIA
Data Analyst
Chicago,Illinois
Summary
Dynamic Data Analyst skilled in handling extensive Big Data sets, proficient in SQL, Data Warehousing, and Data Mining. Experienced in utilizing Data Visualization tools such as Power BI & Tableau. Recognized for translating complex business questions into actionable insights, designing effective data-driven solutions, and adeptly communicating findings to stakeholders.
Education
Master of Science - Information Technology and Management
May 2025
Bachelor of Science - Information Technology
May 2022
Work History
Data Analyst Intern
Cosdec Alpha
05.2022 - 06.2022
- Led data analysis & statistical modeling initiatives, managing large datasets with 10K observations using Python, SQL & Excel
- Developed and maintained interactive dashboards using Tableau & Power Bl, enabling stakeholders to monitor KPIs and make data-driven decisions leading to a 15% improvement in operational efficiency
- Designed & implemented models for data warehouse, utilizing star and Snowflake schemas to meet business requirements
- Collaborated directly with the Managing Director, enhancing client relationships with USA-based firms in Web 3.0 and
- Metaverse domains through effective communication of complex data insights
- Communicated complex data to various stakeholders to help them meet their specific data needs & reporting demands
- Collaborated with cross-functional teams of 15+ data analyst, data scientist, and product owners delivering multiple projects
- Utilized JIRA to track progress, resulting in a 20% reduction in project delivery time & improved communication across teams.
Projects
USA CAR ACCIDENT ANALYSIS |
· Conducted Exploratory Data Analysis using R and Python of 7.7 Million records with 48 categories resulting 12 attributes for data Analysis through identifying trends and patterns.
· Built a dynamic linear regression model to analyze data and used subset selection to identify relevant attributes.
· Presented findings and recommendations in a report and presentation, achieved an academic score of 97/100 for the project.
STOCK MARKET REAL TIME DATA ENGINEERING PROJECT |
· Executed an end-to-end data engineering initiative, incorporating Python, AWS, Apache Kafka, Glue, Athena, and SQL, culminating in a robust data processing pipeline for real-time stock market data analysis.
· Achieved a streamlined and efficient system, showcasing proficiency in S3 for scalable data storage, Athena for SQL-based analysis, Glue Crawler for automated data cataloging, and Apache Kafka for real-time data stream processing, enhancing overall data accessibility and analysis capabilities.
INVENTORY MANAGEMENT SYSTEM |
· Built a smart Inventory Management System with Oracle Developer and PHP, demonstrating strong SQL skills. Simplified merchandise tracking and sales processes for enhanced efficiency.
OYO DASHBOARD ANALYSIS |
· Spearheaded the development of a dynamic Power BI dashboard, leading to a 25% improvement in real-time data analysis and aligning with key performance indices, resulting in a 20% boost in overall business understanding.
· Implemented critical hospitality metrics, including RevPAR, ADR and DBRN contributing to a remarkable 30% enhancement in operational performance insights and guiding strategic decisions for a 18% increase in revenue optimization.
Cricket T20 World Cup (2022) Data Analytics Project |
· Created dynamic and interactive visualizations and dashboards using Power BI to analyze and present Cricket data, enabling effective exploration and interpretation of key metrics for informed decision-making.
· Achieved a 98% data integrity rate through advanced web scraping techniques and detailed preprocessing, ensuring robust and reliable insights.
Skills
- Technologies :
- Data Analysis, Data Science, Machine Learning, Business Intelligence
- Languages : SQL (MySQL, Oracle), Python(NumPy, Pandas, Matplotlib, Scikit-learn, PyTorch ), R(Ggplot2, Dplyr), C, Java
- Tools : MS Excel, Power BI, Tableau, Looker, PyCharm, Jupyter Notebook, SAS, Visual Studio, Jira, AWS, Snowflake, Alteryx
- Professional : Communication skills, Collaboration, Time management, Detail-oriented, Hard worker, Team player, Quick learner
Work Preference
Work Type
Full TimeContract WorkInternshipWork Location
On-SiteRemoteHybridImportant To Me
Career advancementPersonal development programsTimeline
Data Analyst Intern - Cosdec Alpha
05.2022 - 06.2022
Illinois Institute of Technology - Master of Science, Information Technology and Management
University of Mumbai - Bachelor of Science, Information Technology
Similar Profiles
LAINEHILDE NDAPANDA MULUMENDULAINEHILDE NDAPANDA MULUMENDU
TRAINING & ASSESSMENT COORDINATOR at COSDEC TSUMEBTRAINING & ASSESSMENT COORDINATOR at COSDEC TSUMEB
Tweutulwa-Komwene ShikeshoTweutulwa-Komwene Shikesho
Training Coordinator/Assessment Coordinator at COSDEC-OTjiwarongoTraining Coordinator/Assessment Coordinator at COSDEC-OTjiwarongo
Evette Mason-FergusonEvette Mason-Ferguson
Volunteer at Alpha Kappa Alpha Sorority Inc, Xi Alpha OmegaVolunteer at Alpha Kappa Alpha Sorority Inc, Xi Alpha Omega