Welcome to my GitHub profile! I'm a Commercial Analyst with 5 years of experience in the Commercial domain, skilled in developing interactive dashboards, automating different workflows using AI, monitoring commercial business KPIs, and collaborating with cross-functional teams to drive data-driven decision-making.
- I'm exploring AI integrated Analytics, Automation workflows use cases in different domains such as Sales, Finance, Marketing, and Retail.
- I am working on building an end-to-end production-level dashboard from Extract, Transform, Load (ETL) data from different sources to an interactive dashboard.
- I'm expanding my AI knowledge and exploring different tools such as Claude Code, N8N, and many more to enhance the accuracy and quality of my Analytical projects.
- Supply Chain Analytics: https://github.com/abbas99-hub/Supply-Chain-Analytics
- Job Recommendation System: https://github.com/abbas99-hub/Job-Recommendation-System
- Predict HR Employee Joining using ML: https://github.com/abbas99-hub/Predict-HR-Employee-Joining-Company-Using-ML
- HR Job Salary Analytics Dashboard: https://app.powerbi.com/links/J5PBneu_XH?ctid=80422497-e632-410a-964a-2cee17aa1964&pbi_source=linkShare
-
Sales Planning Analyst at e& Etisalat: 11/2023-11/2026
- Built automated Power BI dashboards for senior leadership, enabling real-time tracking of sales performance, account growth, revenue trends, target achievement, and pipeline health.
- Analyzed commercial performance across 300+ enterprise customer accounts using Microsoft Dynamics CRM data to monitor pipeline revenue development and account growth opportunities.
- Designed and deployed automation workflows for recurring reporting tasks, cutting processing time by 40%.
- Partnered with Sales, Finance, and Business teams to evaluate commercial performance and flag business risks, contributing to a 20% improvement in customer revenue.
- Developed and maintained Power BI reporting solutions using SQL, DAX, and Power Query, incorporating data validation checks to improve consistency and reliability of recurring reports.
- Leveraged AI tools to accelerate recurring KPI analysis and anomaly investigation, using structured prompts and validated business metrics to improve the speed and consistency of analytical reporting.
-
Data Analyst at Peopleblox: 6/2022-6/2023
- Built and maintained data pipelines to extract, transform, and load data from various data sources like databases, spreadsheets, and APIs using Databricks, Google Cloud.
- Extracted insights from website clickstream data, resulting in a 30% improvement in decision-making.
- Delivered an A/B Testing tool to test the impact of different training programs on employee skills acquisition, job performance, and satisfaction. Techniques used: Hypothesis Testing, T-Test, Chi-Square Test, P-Value, Normal Distribution.
- Presented findings to optimize the website user experience and increased conversion rate by 15%, by creating an interactive dashboard.
- Performed cohort analysis for customer retention, which resulted in 40% of customers from Q1 remaining active after nine months.
- Tools used: Python, SQL, Power BI, VBA, Data Modeling, Descriptive Statistics, Alteryx, and MS Excel.
-
Data Analyst at Litmusblox: 8/2020-6/2022
- Developed and implemented a Job Recommendation System that increased candidate-job matching accuracy by 30%.
- Conducted A/B tests on different product features processes, resulting in a 12% increase in conversion rate.
- Presented insights from website clickstream data, resulting in a 30% improvement in decision-making..
- Developed a predictive model that accurately identified potential churn cases with an 85% accuracy rate .
- Identified critical company KPIs for revenue, customer acquisition, and customer satisfaction.
- Enhanced user insights, contributing to a 10% increase in personalized user experiences .
- Created pivot tables and charts to visualize KPIs, resulting in a reduction of manual reporting effort by 40%
- Tools used: AB Testing, Power Query, SQL, MS Excel, Clustering, Scikit-Learn, Machine Learning, TensorFlow.
- Check out my latest articles on Medium where I share insights and tutorials related to Commercial analytics, data science, and AI Automation workflows.
- LinkedIn: https://www.linkedin.com/in/abbas-behrainwala-1b669b183
- Medium: https://medium.com/@abbasbehrain95
- I'm always interested in connecting with BI professionals and researchers in the field of Analytics.
- Feel free to reach out if you have any questions, project ideas, or opportunities for collaboration!