ERP Data Analyst
-
• Healthcare Data Analytics
• Sales Revenue Intelligence
• HR Employee Attrition Analysis - Sales revenue and profit trend analysis
- Weekday vs. weekend sales comparison
- KPI tracking and top-selling product insights
- Store location and category performance analysis
- Employee attrition rate and demographic analysis
- Department vs. job role attrition comparison
- HR KPIs and high-risk employee identification
- Job satisfaction scoring and retention analysis
- 49% of encounters have NO insurance coverage
- 264% payer reimbursement gap
- 771 patients with 30-day readmission patterns
- 164% patient volume growth over the decade
- Analytics: CTR, segmentation, forecasting
- Data quality: fraud detection, outliers (IQR)
- Transformations: pivot tables, time series
- Data cleaning: missing values, normalization
- Real-time ATP calculation across warehouses
- Multi-warehouse allocation and delivery scheduling
- Customer-specific item restrictions by date range
- Sales validation at document save
- Daily sales summaries with AI trend analysis
- Automated Telegram reports
- Connected Vendor Customer Accounts
- Blocking payments when linked BP is overdue
Data Analysis & Database
Power BI: DAX, Data Modeling
Python: Pandas, Matplotlib
Database Design: ERD
Excel: Power Query
SQL Server
MySQL
ERP Implementation & Business Analysis
BPMN Modeling
Azure DevOps
Data Projects
Coding Challenges
Data Projects
Data Analysis and Business Intelligence
Sales Revenue Intelligence
Cross-platform analysis of Toy Store sales data using Power BI, Python, and Excel with interactive dashboards and business insights.
HR Employee Attrition Analysis
This project analyzes HR employee attrition data using Power BI with comprehensive dashboards and workforce insights.
Healthcare Data Analytics
SQL-based investigation of healthcare operations and revenue patterns for data-driven strategic decision-making and annual reporting.
Date Range Matching
Matched sales orders to active promotional periods based on date ranges [4-Tool Analysis]
Month-over-Month Calculations
Calculated the month-over-month change in coffee shop sales data [4-Tool Analysis]
Python pandas challenge
15 real-world business problems with NumPy and pandas across different industries.
SAP Business One
Enterprise Resource Planning (ERP) Projects
Available-to-Promise (ATP)
Delivery Schedule Management
SQL solution for tracking inventory availability in SAP Business One. Calculates Available-to-Promise quantities across warehouses to support order fulfillment decisions.
Sales Blocklist
Custom Sales Restriction Tool
SQL-based validation system for SAP Business One that blocks specific items from being sold to certain customers during defined time periods via transaction notifications.
Intelligent Sales Automation
n8n Workflow
Intelligent sales automation for SAP Business One that connects ERP data with AI models to generate insights with n8n, automated reports in Google Sheets, and real-time notifications via Telegram.
Customer Purchase History
Customer's top sales items with stock availability during order entry
Leveraging PCF for ERP Success
Cross-industry APQC framework for successful ERP implementations
Connected Business Partners
SQL-driven Connected BP management for SAP B1 with live balances, alerts, and payment validation to reduce financial risk and improve reconciliation workflows.