Download PDF فارسی
Amirhossein Tonekaboni

Amirhossein Tonekaboni

SAP Business One Consultant & BI Analyst
Product Builder
SAP Business One Consultant, BI Analyst and Product Builder with 6+ years in ERP implementations and business analysis, specializing in manufacturing and supply chain systems. Skilled in Power BI, Excel, Crystal Reports, Python and SQL for reporting, visualization, analytics, and process optimization.
Profile
Experience
BI Analysis Data Analysis SAP Business One ERP Implementation
Focus
Supply Chain Manufacturing Business Analysis Process Improvement Product Development
Languages
Professional English IELTS Academic 7.5
Toolset
SAP Business OneSQL ServerHANA MySQLPostgreSQLPyQt6 PythonPower BIExcel BPMNDockerCrystal Reports
Education
Jan 2017
M.Sc. Industrial Engineering, Systems Optimization
Azad University
Research focus: supplier performance assessment using advanced analytics and optimization models.
Jul 2013
B.Sc. Industrial Engineering, Manufacturing
Azad University
Contact
Career & Selected Work▾
Work Experience
NOW May 2025 - Present
Freelance SAP Business One Consultant
Saphiran
  • Analyzed requirements and optimized workflows for pharmaceutical companies for SAP B1 implementation, training and translating client needs into technical specifications, ensuring regulatory compliance.
  • Performed data migration with DTW, led UAT, and delivered end-user training and support.
  • Built SQL based reports and Crystal Reports layouts, and used Python to automate data transfers between SAP B1 and Excel.
SAP B1DTWUATSQLHANACrystal ReportsPython
Jul 2023 - Mar 2025
Freelance SAP Business One Consultant
Amirkabir Borna
  • Configured SAP B1 modules for food industry client, optimizing workflows and reducing processing time.
  • Led User Acceptance Testing (UAT) and collaborated with stakeholders to streamline business processes.
  • Delivered training, conducted Business Blueprint meetings, and provided support to maximize system adoption.
SAP B1UATBPMNSQLHANA
Feb 2021 - Jul 2023
Enterprise Resource Planning Specialist
Golrang System, Golrang Industrial Group
  • Deployed and supported ERP solution across Golrang companies in manufacturing, chemical, food, and pharmaceutical sectors, covering Production, Planning, MRP, Maintenance, and Quality modules.
  • Trained 50+ users and collaborated with developers to gather requirements and design ERP solutions.
  • Analyzed manufacturing data using SQL to identify bottlenecks and optimize workflows across multiple sites.
Software ImplementationSQLSQL ProfilerBPMNUAT
Jul 2019 - Jan 2021
SAP Business One Specialist
Beta System, Mammut Industrial Group
  • Implemented, customized, and supported SAP Business One across manufacturing, insurance, and services, focusing on the Finance, Procurement, Warehousing, Production, and Sales modules.
  • Led system configuration, training sessions, and blueprint meetings to align solutions with organizational needs.
  • Managed data migration and developed SQL-based Crystal Reports for deployment.
  • Collaborated with development team on custom LIMS solution for food laboratory, from requirements gathering through testing and SAP B1 integration.
SAP B1DTWUATCrystal ReportsSQL
Products
AVAILABLE Desktop App
Check Entry
Check payments automation for SAP Business One
Batch posting of incoming checks (draft or final) with direct Shamsi-to-Gregorian date conversion via the SAP B1 Service Layer (HANA & SQL), with built-in validation and reporting. Landing page
PyQt6SAP B1Service LayerSQL
AVAILABLE Desktop App
ExcelAid
Shamsi & Gregorian date management, Reconciliation, Check due-date
Bilingual (Persian/English) desktop tool for managing Shamsi and Gregorian dates, convert, shift, and calculate date differences via Excel, with calendar, task management, reconciliation, and automatic check due-date checking, fully offline. Landing page
PyQt6OpenPyXLExcel
NOT YET PUBLIC Desktop App
Batch Transfer
Warehouse inventory transfer automation
Batch stock transfer posting (draft or final) with batch number to SAP Business One via the Service Layer (HANA & SQL), driven entirely from a single Excel file, cutting manual processing by hours per run and reducing entry errors.
PyQt6SAP B1Service LayerSQL
Data & BI Projects
Bank Customer Churn, ETL & BI Pipeline
Python, PostgreSQL, Docker, Metabase
Full pipeline from exploratory analysis to database integration and a deployed Metabase dashboard. View on GitHub
PythonDockerMetabasePostgreSQL
Healthcare Data Analytics
SQL-based hospital operations & revenue analysis
SQL-based investigation of healthcare operations and revenue patterns for data-driven strategic decision-making and annual reporting. View on GitHub
MySQL
Sales Revenue Intelligence
Power BI, Python & Excel sales dashboard
Cross-platform analysis of retail sales data using Power BI, Python, and Excel with interactive dashboards and business insights. View on GitHub
Power BIPythonExcel
HR Employee Attrition Analysis
Power BI workforce & attrition dashboard
Analyzes HR employee attrition data using Power BI, with comprehensive dashboards covering HR KPIs and high-risk employee identification. View on GitHub
Power BIExcelDAX
SAP B1 Projects & Community Contributions
AI-Powered Sales Automation, n8n
SAP B1 connected to AI-driven reporting
n8n workflow connecting SAP B1 Service Layer, Google Sheets, and AI to automate sales reporting: extracts sales orders, syncs them for tracking, and analyzes daily trends, delivering AI-generated summaries to Telegram without manual data entry or report generation. View on GitHub
SAP B1n8n
Advanced Available-to-Promise (ATP)
Delivery schedule management for SAP B1
SQL solution and training guide for tracking inventory availability across warehouses to support order fulfillment decisions, including a Power BI template for visualizing Advanced ATP results. View on GitHub
SAP B1SQL
Custom Sales Blocklist
SQL-based sales restriction system for SAP B1
Customer and date-specific transaction blocking with validation scripts.
SAP B1SQL
Connected Business Partners
SQL-driven connected BP management for SAP B1
SQL scripts surfacing linked vendor/customer AR and AP balances and net group financial position, plus transaction-notification logic that validates and warns on outgoing payments when a connected BP carries a significant overdue balance. View on GitHub
SAP B1SQL
Unlock Hidden Sales Insights
Customer purchase history with live stock availability
Formatted search query wired into the sales order form's Item No. field, surfacing each customer's recent sales items with stock levels and order status to speed up order entry. View on GitHub
SAP B1SQL
Cash Flow Analysis GUIDE
Configuration and reporting guide for SAP B1 cash flow tools
Practical guide covering Cash Account vs. Cash Flow Relevant flags, the Cash Flow Report and Forecast, the Cash Flow Statement, and direct vs. indirect reporting methods. SAP Community profile
SAP B1Reporting
Certifications
SQL & Databases
  • Advanced SQL for Data Engineers - 365 Data Science
  • Advanced MySQL for Data Analysis - Analyst Builder
  • Advanced MySQL for Marketing and Web Analytics - Maven Analytics
  • Snowflake SQL, Database Design - DataCamp
  • Advanced SQL Server Querying & Programming - Faratar Az Danesh
Python & Data Prep
  • Data Science in Python: Prep & EDA - Maven Analytics
  • Data Manipulation with pandas - DataCamp
  • Intermediate Python for Developers - DataCamp
Enterprise Resource Planning
  • Managing Logistics in SAP Business One - SAP Learning
  • Management and Production Planning Systems - Golrang Industrial Group
Business Intelligence
  • Microsoft Power BI Desktop for Business Intelligence - Analyst Builder
  • Data Modeling and DAX in Power BI - DataCamp