AYUSH RAUT - Data Analyst - Infosys Ltd

Summary

Results-driven Data Analyst with nearly three years of experience delivering impactful business intelligence solutions at Infosys. Expertise in data cleaning, transformation, and visualization, complemented by a strong foundation in statistical and machine learning techniques to enhance decision-making processes. Proficient in Python, SQL, Power BI, Tableau, and Excel, enabling the conversion of complex datasets into actionable insights. Committed to driving measurable business impact through data-driven strategies and innovative problem-solving.

Overview

3

years of professional experience

Work History

Data Analyst

Infosys Ltd

Pune, India

01.2023 - Current

Developed and maintained interactive Power BI and Tableau dashboards to provide real-time insights, reducing manual reporting time by 40%.
Wrote and optimized SQL queries to extract, join, and transform large datasets from MySQL and SQL Server databases, ensuring accuracy and speed.
Conducted exploratory data analysis (EDA) to uncover trends in customer behavior, product performance, and regional sales using Pandas, NumPy, Matplotlib, Seaborn.
Applied regression analysis, A/B testing, and hypothesis testing to evaluate business strategies and campaign performance.
Built ML models (classification, clustering, regression) for customer segmentation, churn prediction, and demand forecasting using Scikit-learn and XGBoost.
Automated ETL processes using Python and Power Query, improving reporting efficiency and reducing data latency.
Collaborated with cross-functional teams to deliver tailored analytical solutions for strategic decision-making.
Delivered data-driven presentations to stakeholders and ensured compliance with data governance standards.
Used Agile and JIRA for sprint planning, task tracking, and project delivery.

Education

MBA - Business Analytics

Savitribai Phule Pune University

10.2023

BBA - Computer Applications

Brihan Maharashtra College of Commerce

08.2021

Skills

Programming: Python, SQL
Visualization: Power BI, Tableau
Libraries: Pandas, NumPy, Matplotlib, Seaborn, Plotly
Machine Learning: Scikit-learn, XGBoost, Classification, Clustering, Regression, Feature Engineering

Databases: MySQL, MS SQL Server, MongoDB
Statistical Tools: Excel, Hypothesis Testing, Regression, A/B Testing, Time Series
Platforms: AWS, JIRA
Soft Skills: Analytical Thinking, Problem-Solving, Communication, Team Collaboration, Adaptability

Timeline