Mayank J
The star rating is a representation of the overall rating, calculated as the mean of the client satisfaction rating, the average client interview rating, and internal interview scores.
The client satisfaction rating is the weighted average of client ratings, with weights based on reviewed work hours. When no client rating exists, the approval fraction (approved vs. reviewed work hours) determines it.
If the client satisfaction rating exceeds the overall rating, it becomes the star rating. In the absence of client ratings, if the average client interview rating is higher than the overall rating, it becomes the star rating. If no data is available, the star rating defaults to the internal interview score.
The client satisfaction rating is the weighted average of client ratings, with weights based on reviewed work hours. When no client rating exists, the approval fraction (approved vs. reviewed work hours) determines it.
If the client satisfaction rating exceeds the overall rating, it becomes the star rating. In the absence of client ratings, if the average client interview rating is higher than the overall rating, it becomes the star rating. If no data is available, the star rating defaults to the internal interview score.
Data Analyst Preferred Title
$15.00 /hr $ 20.0K /yr Hourly Rate and Yearly Salary
Overview
Basic Summary
LD Talent History - Average Count of Messages/Day 0.3
- Project Completion Rate 2/4
- Interview Acceptance Rate 4/6
- Timezone Overlap 14h PST, 14h UTC
- Software Engineering Process 3.0/5
- Design Practice 3.0/5
- Design Theory 3.0/5
- Technical Breadth 4.0/5
- Logical Thinking 4.0/5
- Technical Strength 4.0/5
- System Design 3.0/5
- Productivity and Responsiveness 3.0/5
- Teamwork 3.0/5
- Agile Development Process 3.0/5
- Intellectual Merit 4.0/5
- English Communication 3.0/5
- Documentation 3.0/5
- Desktop Windows
- Phone Android
- Tablet Android Tablet
- Member Since Sep 04, 2023
- Profile Last Updated Oct 23, 2023
- Last Activity March 21, 2024, 6:22 a.m. UTC
- Location India
Profile Summary
Data analyst with a strong background in statistical analysis, data visualization, and programming. Proficient in Excel, SQL, and Python, with a keen eye for detail and a passion for data-driven decision-making. Skilled in data collection, cleaning, and manipulation, with experience working on real-world projects and collaborating with senior analysts. Effective communicator with strong presentation skills, able to clearly convey complex findings to both technical and non-technical stakeholders.
Skills
Total Experience: 1+ years
Data Analytics (4E, 2Y, 1C)
4 experiences, across 2 years, with 1 courseExcel (3E, 2Y, 1C)
3 experiences, across 2 years, with 1 courseTableau (3E, 2Y, 1C)
3 experiences, across 2 years, with 1 coursePython (4E, 2Y, 1C)
4 experiences, across 2 years, with 1 coursePandas (3E, 2Y, 1C)
3 experiences, across 2 years, with 1 coursePower BI (2E, 2Y, 1C)
2 experiences, across 2 years, with 1 courseSQL (1C)
1 courseMySQL (1C)
1 courseAutomation
Analysis
Strategic Leadership
Beautifulsoup
Browser automation
Python Requests
Python Selenium
Machine learning (1C)
1 courseData Science (1C)
1 coursePlotly (1C)
1 coursescikit-learn
Matplotlib (1C)
1 courseR for Statistics (1C)
1 courseData visualization
Microsoft Excel
Data mining (1C)
1 courseGit (1C)
1 courseRegex (1C)
1 courseNumpy (1C)
1 courseJupyter (1C)
1 coursePyTorch (1C)
1 course
Weekly Availability
Timezone Overlap with 06 - 21 per Week: 14h PST, 14h UTC
Day
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
UTC
19 - 21
19 - 21
19 - 21
19 - 21
19 - 21
19 - 21
19 - 21
PST
12 - 14
12 - 14
12 - 14
12 - 14
12 - 14
12 - 14
12 - 14
Vetting
- Interview Data
- Software Engineering Process
- Design Practice
- Design Theory
- Technical Breadth
- Logical Thinking
- Technical Strength
- System Design
- Productivity and Responsiveness
- Teamwork
- Agile Development Process
- Intellectual Merit
- English Communication
- Documentation
Experience
Data Analyst
Employment
Sep 2023 - Oct 2023
Prozo Retail Network Company
Project: RCA on Loss of BuyBox
- Led RCA initiatives to identify reasons behind the loss of BuyBox status, such as out-of-stock, inactive listing, or price incompetence by leveraging Excel, Python, Analysis, Data Analytics.
- Resulting 15% increase in BuyBox ownership through implementing corrective actions based on RCA report and Strategic Leadership.
data analyst
Employment
Aug 2023 - Sep 2023
Prozo Retail Network Company
Project: Ecommerce Sales reporting automation
- Increased sales reporting efficiency by implementing Browser automation for data collection from 7+ marketplaces using Pandas, Python Requests, Python Selenium, Beautifulsoup, Openpyxl etc.
- Resulting 80% reduction in manual effort, facilitating decision-making and sales optimization.
Data Analyst
Employment
Jul 2023 - Aug 2023
Prozo Retail Network Company
Project: Inventory reporting automation
- Produced daily inventory reports for 30+ warehouses by implementing data automation using Advance Excel, Power Query, Python, Pandas, MimeText library, Power BI, Tableau, etc.
- Reduced reporting time by 50%, ensuring accurate and up-to-date information for inventory management.
Data Scientist
Course Project
Jan 2023 - Feb 2023
Scaler Academy Company
Finance Industry
Project: Loan Approval Prediction | Machine Learning Model
- In this Data science project, I built the Machine Learning model to automate the loan eligibility process based on customer detail like income, loan amount, credit history, and other variables.
- Using Scikit-learn and Plotly I performed Data preprocessing, Feature engineering, Decision tree, Random forest classifier, and Logistic regression algorithms I achieved a maximum of 83% accuracy.
Data Analyst
Course Project
Nov 2022 - Dec 2022
Scaler Academy Company
Healthcare Industry
Project: Hospitalization Charges | Statistical Data Analysis
- Using Python libraries Pandas, Numpy, Scipy, Matplotlib, and Seaborn I performed the EDA, Data preprocessing, Data visualization, and Statistical analysis. R for statistics, and Data analytics.
- By conducting Hypothesis testing I found that variables like viral load, smoking, and severity levels are significant in predicting the reason for the hospitalization charges.
Data Analyst
Course Project
Sep 2022 - Oct 2022
Scaler Academy Company
Ecommerce Industry
Project: Ecommerce Sales Trend | Exploratory Data Analysis
- Using Microsoft Excel and Google Sheets, I created pivot tables and charts to uncover critical insights that can help in business decisions making.
- I made dashboards on Tableau and Power BI to visualize the store’s sales performance and profitability over the past years across regions, segments, and categories for Data analytics.
Data Analyst
Course Project
Jul 2022 - Aug 2022
Scaler Academy Company
Ecommerce Industry
Project: Vehicle Inventory Control | Business Problem Solving
- I performed a series of SQL queries in MySQL to extract data from databases, manipulate the data, perform calculations on the data, and developed data visualization plots and dashboards on Tableau.
- I answered business questions about product performance, priority products for restocking, customer purchasing behavior, sales team performance, budget for new customer acquisition by Data analytics.
Qualifications
Education
Riga Technical University
Feb 2016 - Jun 2019
BS (Mechanical Engineering)
Courses
Scaler Academy