8329843490-6AA84F?style=flat&logo=allocine&logoColor=white){kind=icon}
Welcome to my GitHub profile! I am a Data Analyst with a passion for turning data into actionable insights. I am skilled in PowerBI, SQL (MySQL & PostgreSQL), Python (Libs: Numpy, Pandas, Matplotlib, Seaborn, Plotly), Excel, Alteryx & Statistics, and thrive on the challenge of diving deep into data to uncover trends and insights that drive business success.
My journey into data analysis began while working for 3.5 yrs as a SAP UI5 Frontend Developer at Accenture, where I discovered my innate abilities in this field. There, I not only developed apps but also analyzed the data they generated, honing my analytical skills & helping my clients with crucial, data-driven business decisions.
Holding a Bachelor's degree in Electronics & Telecommunication, I bring a unique perspective to data analysis, blending technical proficiency with analytical acumen. This combined with my practical experience in data analysis and nack for user friendly design, positions me uniquely to help organizations leverage their data for strategic business advantage.
Explore my Git repositories to see how I can contribute to your team’s success and reach out to me for opportunities, collaboration, feedback or just to say Hi!
| Power BI | MySQL | PostgreSQL | Alteryx | Excel | Statistics |
|---|---|---|---|---|---|
 |
 |
 |
 |
 |
 |
| Python 3 | Jupyter | NumPy | Pandas | Matplotlib | Seaborn | Plotly |
|---|---|---|---|---|---|---|
 |
 |
 |
 |
 |
 |
 |
| DevOps | AppInsights | JS | SAPUI5 |
|---|---|---|---|
 |
 |
 |
 |
In this project I conducted Exploratory Data Analysis (EDA) on Adidas US Sales data for FY 2020-21, focusing on Retailer Performance, Regional Sales Distribution, and Channel-specific Trends. Using MySQL for data cleaning & ETL, Python for EDA, and Power BI for dashboarding, the project uncovers key insights to identify growth opportunities and optimize strategies to drive operational profitability.
In this project I conducted Supply Chain Analysis for AtliQ Mart, monitoring KPIs like On-Time %, In-Full %, On-Time & In-Full %, Line Fill Rate %, Volume Fill Rate % and Average Days of Delayed Delivery using Power BI. The report created provides insights across cities, product categories and customers, enabling performance tracking, trend analysis, and optimization of supply chain efficiency.
In this project I implemented meticulous ETL process on AtliQ Hardware's 1.8 million transaction records from FY 2019 to FY 2022 and crafted a multi-view report for comprehensive analysis across 5 critical business domains: Finance, Sales, Marketing, Supply Chain, and Executive using Power BI. By integrating key business metrics such as Net Sales, COGS, Gross Margin %, Net Profit % and Forecast Accuracy % the report offers a holistic view of AtliQ's performance.
In this project I implemented Customer Cohort Analysis on fictional Ecommerce dataset for 2017 using Acquisition Cohorts based on first transaction date using Alteryx Designer. Gained actionable insights related to Customer Churn, Product engagement and other relevant business metrics.
Consumer Goods Ad-Hoc Analysis
In this project I navigate through the core of HR Analytics, the art of deriving actionable insights from employee attrition data for 1470 employees using Microsoft Power BI. It involves identifying attrition patterns across parameters like Employee Demographics, Turnover & Wellbeing and providing data-backed insights and recommendations that breathe life into our employee retention strategies.
AtliQHardware: Sales & Finance Performance Analysis
Wholesale Store Orders Data ETL
This project involves analysis of US Regional Sales data for 2019 to optimize sales strategies by identifying top-selling products, revenue distribution & key metrics trends like average order value using Microsoft Power BI. This analysis was done as part of my Internship assignment at MeriSKILL June 2024.
