Learn Data Skills
Beta
Ashvin Shukla

Ashvin Shukla

student

pace university

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Workbook

Introduction to Python

My New Workbook

Competition - Everyone Can Learn Python Scholarship

My Work

Take a look at my latest work.

course

Introduction to Python

DataLab

Introduction to Python

DataLab

Competition - Everyone Can Learn Python Scholarship

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Deepwes Technology | Jul 2021 - Jul 2022

Data Analyst

Project: 1 Market Research and Customer Segmentation for E-commerce Company called Crayve. Role : Data Analyst Description: In this project, the data analyst played a pivotal role in assisting an e-commerce company in understanding its customer base and optimizing its marketing strategies. The goal was to identify distinct customer segments, their purchasing behaviors, and preferences to tailor marketing efforts effectively. ● Data Collection and Cleaning: ● The data analyst collaborated with the company's IT team to gather relevant data from various sources, including sales transactions, website interactions, and customer surveys. Raw data was often messy and required thorough cleaning, which involved handling missing values, outliers, and inconsistencies. ● Exploratory Data Analysis (EDA): ● Once the data was cleaned and consolidated, the data analyst conducted exploratory data analysis to gain initial insights. This involved generating descriptive statistics, visualizations, and identifying patterns in customer behavior. EDA guided the team's direction and highlighted areas of interest. ● Customer Segmentation: ● Using advanced clustering techniques like k-means, the analyst segmented the customer base into distinct groups based on purchasing habits, frequency, monetary value, and product preferences. These segments provided a deeper understanding of the company's customer diversity and allowed for targeted marketing strategies. ● Insights Generation: ● The analyst interpreted the segmentation results, identifying key characteristics of each customer group. They uncovered that a particular segment consisted of bargain-focused shoppers who responded well to discount campaigns, while another segment preferred premium products and personalized shopping experiences. ● Strategy Recommendations: ● Based on insights from the segmentation, the analyst collaborated with the marketing team to formulate strategies tailored to each customer segment. This included designing customized email campaigns, product recommendations, and retargeting efforts to maximize engagement and conversions. ● Performance Monitoring: ● Post-implementation, the analyst monitored the performance of the new marketing strategies. They tracked metrics such as click-through rates, conversion rates, and revenue growth for each customer segment. Adjustments were made iteratively based on realtime data analysis. Project 2: Resource Optimization for a Hospital Management System Role: Data Analyst Description: In this project, the data analyst contributed to improving operational efficiency for a hospital chain by optimizing the allocation of healthcare resources across various departments. The aim was to streamline patient flow, reduce waiting times, and enhance overall patient satisfaction. ● Data Integration and Preparation: ● The analyst worked closely with hospital administrators and IT personnel to integrate data from electronic health records (EHR), patient admissions, and staff scheduling systems. Data preparation involved transforming raw data into a structured format suitable for analysis. ● Time-Series Analysis: ● Utilizing time-series analysis techniques, the analyst examined historical patient admission patterns, appointment scheduling, and resource utilization. By identifying peak admission hours and days, the team could anticipate resource demands accurately. ● Queue Analysis and Wait Time Reduction: ● The analyst analyzed patient queues at different departments to identify bottlenecks and waiting time disparities. They used queuing theory to optimize the allocation of medical personnel, equipment, and facilities to minimize patient waiting times. ● Predictive Modeling for Staffing: ● Employing predictive modeling, the analyst developed algorithms to forecast patient admission numbers, enabling the hospital to adjust staffing levels dynamically. This reduced overstaffing during off-peak hours and ensured adequate coverage during busy periods. ● Performance Metrics Dashboard: ● The analyst created a real-time dashboard that displayed key performance metrics, including patient wait times, average consultation durations, and resource utilization rates. This dashboard allowed hospital managers to make informed decisions promptly. ● Outcome Assessment: ● Post-implementation, the analyst assessed the impact of resource allocation changes on patient satisfaction and operational efficiency. They conducted surveys and analyzed patient feedback to validate the improvements achieved.
Show More

Shree Jee Enterprise | Jun 2020 - Jun 2021

Business Data Analyst

• Gathering business and technical requirement from stakeholders and converted in small JIRA stories to get it done. • Documenting the important information in Business capabilities document which serve as source of truth. • Collaborate with SME’s gather all the detailed information and document it understandable format for both technical and business folks. • Engage Product and Process Managers to support Enterprise analytical initiatives and take the decision best in interest • Translate stakeholder and product owners' requirements into analytical solutions and create reports on top of it.

Walking Dreamz Technologies | Sep 2016 - Jun 2019

Data Analyst

• Designed and tuned complex SQL queries and tested packages, stored procedures, triggers, views of databases, which increased computing speed and reducing the processing time by 30%. • Worked on ETL project and used batch processing to improve the performance. • Migrated traditional SQL ETL pipeline to PySpark pipeline to align with the clients’ requirements. • Created impactful dashboards using Tableau for a competitive pricing analysis project by analyzing the historical data and identifying KPIs that had a positive impact on the business. • Monitored customer reviews over time using Advanced Excel, SQL, and R to gauge trends and better predict reviews, which enhanced the branding of a client by 33%. • Provided data analysis support, such as summarizing A/B testing, visualizing B2C sales lead and opportunity, and preparing a dashboard for the management team. • Gathered business requirements from stakeholders and ensured they were implemented as specified in the requirements document and project management to serve 100% deliverable. • Served as Scrum Master and managed multiple projects, leading workflow analysis and ensuring the group continues to focus on overall performance and increased renewal rates and team productivity by up to 5.5% via analyzing data. • Collaborated with developers and product managers to seek out effective business solutions through improvements in information systems, data management, decision support systems, organizational procedures, and equipment.

My Education

Take a look at my formal education

MS IN INFOMATION SYSTEM in DATA SCIENCEPACE UNIVERSITY | 2024
Bachelor of Engineering in Civil EngineeringRajiv Gandhi Technical University | 2013

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free