Akash chavan

Data Analyst

Pune, India 1+ yrs exp 84 · Excellent

About

Data Analyst with 1+ year of experience at British Petroleum (BP), specializing in SQL driven data analysis, Power BI dashboard development, and automated reporting solutions. Proficient in designing interactive Power BI reports that reduced manual reporting time by ~50% and provided actionable insights for vendor compliance and performance. Skilled in writing and optimizing complex SQL queries to extract, clean, and validate large datasets from SAP ECC, ensuring ~95% accuracy during the migration of 10,000+ vendor records to SAP HANA. Experienced in leveraging DAX, Python (Pandas, scikit-learn), and Excel for exploratory data analysis, predictive modeling, and advanced reporting to support business decision-making.

Skills & Expertise (28)

Power BI Advanced

8.0/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Python Intermediate

6.5/10

Years Exp

Pandas Intermediate

6.0/10

Years Exp

Machine Learning Intermediate

6.0/10

Years Exp

NumPy Intermediate

5.5/10

Years Exp

Data Storytelling Intermediate

5.0/10

Years Exp

Cross-functional coordination Intermediate

5.0/10

Years Exp

stakeholder communication Intermediate

5.0/10

Years Exp

Git Intermediate

5.0/10

Years Exp

Jupyter Notebook Intermediate

5.0/10

Years Exp

Statistical Analysis Intermediate

5.0/10

Years Exp

Seaborn Intermediate

5.0/10

Years Exp

Matplotlib Intermediate

5.0/10

Years Exp

Random Forest Classification Regression EDA CNN LSTM scikit-learn SAP HANA ETL Predictive Modeling VLOOKUP PivotTables PowerPoint Microsoft Excel

Work Experience

Data Analyst

British Petroleum (BP)

Mar 2025 - Present

Collaborated with internal and external business stakeholders to gather requirements and translate them into technical reporting specifications for the Vendor Master Data team. Designed and delivered high-impact Power BI dashboards and reports, providing real-time insights into vendor compliance and performance that influenced strategic decision-making. Utilized expert-level SQL queries to extract, clean, and analyze structured and semi-structured data from SAP ECC, ensuring data accuracy across the organization. Collaborated with data engineering teams to consume curated datasets built on Azure (ADF, Databricks, ADLS Gen2, Blob Storage), validating transformations, applying business logic. Leveraged Microsoft Purview for data discovery and lineage analysis, enabling clear understanding of source to-report data flow, dataset ownership, and data definitions, which improved report accuracy, stakeholder trust, and compliance awareness.

Data Analyst Intern

MITAOE, Alandi Campus

Jul 2023 - Sep 2023

Built a machine learning pipeline to classify news articles as real or fake using NLP-based text analysis. Engineered features and applied preprocessing techniques to prepare large text datasets for modeling. Trained and evaluated Logistic Regression, SVM, and Random Forest models to optimize classification accuracy. Achieved reliable performance in detecting misinformation, demonstrating practical application of ML in text analytics.