Data Analyst Scientist

SAI KUMAR BYSANI

+1-475-***-**** *****************@*****.*** LinkedIn GitHub CT

EXPERIENCE:

The LEGO Group Hartford, CT

Data Scientist Sept 2022-Nov 2022

• Implemented a Machine Learning Model to predict sales, streamline supply chain, and enhance inventory planning, and achieved 93% R-squared.

• Designed and developed a model using RNN and CNN to forecast annual sales by incorporating external factors with 6% error for Sep 2022.

• Recognized a decrease in sales of kids' products by 13%, signaling a market shift towards adult products.

• Recognized growth opportunities by analyzing sales data, via advanced SQL queries and hypothesis testing methods (t-tests and ANOVA).

SKILLS and CERTIFICATIONS:

Data Analysis & Visualization Tools: Tableau, Power BI, MS-Excel, Hadoop, SAS, AWS, Snowflake Database Management Systems: MySQL, Oracle, PostgreSQL Programming Languages: Python (NumPy, Pandas, Scikit learn, SciPy, Matplotlib, TensorFlow, Pyomo), R, PySpark Project Management Tools: JIRA, Microsoft Project

Machine Learning Algorithms: Clustering, Regression, Classification, Deep Learning, Anomaly Detection, Supervised Learning, Unsupervised Learning, Natural Language Processing (NLP), Hypothesis Testing, Linear & Non-Linear Optimization Certifications: Tableau Desktop Specialist, JIRA Fundamentals EDUCATION:

University of Connecticut, School of Business GPA: 3.91/4.00 May 2023 Master of Science, Business Analytics and Project Management

• Relevant Coursework – Statistics, SQL, Big Data Analytics, Predictive Modelling, Data Mining, and Deep Learning. Achievements:

• Awarded 1st prize in Well4Tech’s Mini Health Hackathon.

• Facilitated professor in creating assignments/exams, and grading 40 students on DBMS (SQL), as Graduate Teaching Assistant during Spring 2023.

• Managed a 20% growth in club membership through organized events and workshops, as President of Data Analytics Club.

• Fostered students’ understanding in Statistics, Calculus, Algebra and Probability for 3 semesters, as an Undergrad Tutor. Amrita Vishwa Vidyapeetham India GPA: 8.85/10.00 July 2017 - Aug 2021 Bachelor of Technology, Electrical and Electronics Engineering - Honoured Distinction for excellence. ACADEMIC PROJECT EXPERIENCE:

Data Scientist Apr 2022 – Jun 2022

Customer Churn Analysis Competition: NESS Statathon by Travelers

• Reengineered XG Boost Model for Churn Prediction, resulting in 81% accuracy with an AUC of 0.69 from 66% and 0.60.

• Accomplished a potential 21% increase in revenue, by conducting a cost-benefit analysis, and presenting the same to senior stakeholders.

• Minimized customer churn by 10%, by recognizing key contributors to customer churn via data analysis and implementation of corrective actions with team.

• Awarded 3rd prize out of 150 competitors.

Financial Analyst Aug 2022 - Oct 2022

Portfolio Allocation Model Python, Power BI, MS-Excel

• Researched and scrapped stock data of 9 companies from 3 sectors, from Yahoo Finance for last 5 financial years.

• Discovered the most-favourable investments, by employing regression analysis and Monte-Carlo simulation to assess risk- return trade-off.

• Buy & Hold investment strategy gave the best ROI of 15%.

• Determined optimal portfolio allocation by performing a comprehensive risk and parameter analysis. Data Analyst Aug 2022 - Dec 2022

Impact of Airbnb on Housing Supply Python, Tableau, MySQL

• Spearheaded a project team of 5 and conducted an analysis to deliver data-driven recommendations, resulting in 100% project completion within timeline.

• Enabled granular data results by leveraging GeoPandas and ZCTA5 shapefiles to extract Zip Codes of listings.

• Created a scalable dashboard in Tableau, enabling users to assess 1.5M Airbnb listings risk from state level to zip codes.

Contact this candidate