Download PDF فارسی
Amirhossein Tonekaboni

Amirhossein Tonekaboni

SAP Business One Consultant & BI Analyst
Product Developer
SAP Business One Consultant, BI Analyst and Product Developer with 5+ 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
Implementation and process integration for a pharmaceutical holding, covering configuration, business process modeling, and end-user support, with technical specs kept aligned to regulatory compliance. Released the Check Entry application to automate batch posting of received checks between SAP B1 and Excel, cutting manual processing by hours per run and reducing entry errors.
SAP B1PythonBPMNSQLHANACrystal Reports
Jul 2023 - Mar 2025
Freelance SAP Business One Consultant
Amirkabir Borna
Configured SAP B1 modules for a food industry client, optimizing workflows and reducing processing time. Led User Acceptance Testing and collaborated with stakeholders to streamline business processes, then delivered training and Business Blueprint sessions to maximize system adoption.
SAP B1UATSQLHANA
Feb 2021 - Jul 2023
Enterprise Resource Planning Specialist
Golrang System, Golrang Industrial Group
Deployed and supported ERP across manufacturing, chemical, food, and pharmaceutical sites, covering Production, Planning, MRP, Maintenance, and Quality modules. Trained 50+ users, collaborated with developers on requirements and solution design, and used SQL and Crystal Reports to identify production bottlenecks and streamline reporting.
SAP B1SQL
Jul 2019 - Jan 2021
SAP Business One Specialist
Beta System, Mammut Industrial Group
Implemented and supported SAP B1 across manufacturing, insurance, and service sectors, focused on Accounting, Procurement, Warehousing, Production, and Sales modules. Automated workflows, managed data migration, developed SQL-based Crystal Reports, and partnered with the dev team on a custom LIMS solution for a food laboratory, from requirements through SAP B1 integration.
SAP B1Crystal 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
NOT YET PUBLIC Desktop App
ExcelAid
Shamsi & Gregorian date management
Bilingual (Persian/English) desktop tool for managing Shamsi and Gregorian dates, convert, shift, and calculate date differences via Excel, with calendar, task management and auto 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. Landing page
PyQt6SAP B1Service LayerSQL
Data & BI Projects
BUILD 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
BUILD 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
BUILD 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
BUILD 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
BUILD 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
BUILD 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
BUILD Custom Sales Blocklist
SQL-based sales restriction system for SAP B1
Customer and date-specific transaction blocking with validation scripts.
SAP B1SQL
BUILD 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
BUILD 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
GUIDE Cash Flow Analysis
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