09/14/2026 updated
100 % available
SAP Business One Consultant & Power BI / Business & Data Analyst
India
Only remote
B.C.A. (Bachelor of Computer Application), Saurashtra University, 2014About me
SAP B1 & Power BI Specialist with 9+ yrs experience delivering SQL/HANA, Crystal Reports, dashboards, and ERP setups for SMEs. I build custom Add-ons, web portals, and third-party integrations (DI/API, SDK, REST API), automate workflows, and fix DTW imports. Fast delivery. Clean results. Let's talk.
Query PerformanceApplication Programming Interfaces (APIs)Data AnalysisBusiness IntelligenceBusiness AnalysisBusiness ReportingSAP Crystal ReportsQuery LanguagesWeb PortalsMicrosoft Windows SDKSAP ERPQuery OptimizationMicrosoft Power BISAP ApplicationsSAP Business One
SAP Business One (SQL & HANA)
End-to-end SAP Business One implementations, customization, and post-go-live support across multiple industries. Expertise in UDFs, UDTs, Formatted Search, validations, approvals, authorizations, and SAP B1 SDK (DI API & UI API) for add-on development and REST API integration.
Power BI & Business Analytics
Setup and configuration of Power BI end-to-end for enterprise reporting, connecting to multiple data sources for real-time insights. Use of Power Query and DAX for data transformation and optimized data modelling, including Microsoft Fabric integration for advanced analytics and scalability.
SQL Server & Database Management
Design and execution of complex SQL/HANA queries, stored procedures, and query optimization. Experience with database backup, restore, and data migration using DTW for new implementations and upgrades.
Crystal Reports & SAP B1 Print Layout Designer (PLD)
Development of Crystal Reports and PLD layouts for tailored reporting solutions, including forms and structures for print layout designs.
Advanced Microsoft Excel
Building KPI-driven Excel dashboards connected to SAP B1, SQL, and Power BI data using Pivot Tables, Power Query, XLOOKUP, SUMIFS, and VBA macros to automate recurring reporting.
ERP & CRM Systems
Broad experience with ERP processes and CRM platforms including Salesforce administration, covering objects, fields, workflows, validation rules, process approvals, and email configuration.
Data Migration (DTW), Backup & Restore
Leading data migration projects using DTW along with database backup and restore procedures for new implementations and system upgrades.
Salesforce Administration
Creation of objects, fields, users, and core Salesforce configuration elements; generation of dashboards and reports; building validation rules, workflows, process approvals, and flows.
Data Quality & Reporting (Tableau, MySQL)
Preparation of grouped reports, charts, and drill-down reports in Tableau; design and development of graphical reports from existing data; manual report and data testing using Excel and MySQL Server.
End-to-end SAP Business One implementations, customization, and post-go-live support across multiple industries. Expertise in UDFs, UDTs, Formatted Search, validations, approvals, authorizations, and SAP B1 SDK (DI API & UI API) for add-on development and REST API integration.
Power BI & Business Analytics
Setup and configuration of Power BI end-to-end for enterprise reporting, connecting to multiple data sources for real-time insights. Use of Power Query and DAX for data transformation and optimized data modelling, including Microsoft Fabric integration for advanced analytics and scalability.
SQL Server & Database Management
Design and execution of complex SQL/HANA queries, stored procedures, and query optimization. Experience with database backup, restore, and data migration using DTW for new implementations and upgrades.
Crystal Reports & SAP B1 Print Layout Designer (PLD)
Development of Crystal Reports and PLD layouts for tailored reporting solutions, including forms and structures for print layout designs.
Advanced Microsoft Excel
Building KPI-driven Excel dashboards connected to SAP B1, SQL, and Power BI data using Pivot Tables, Power Query, XLOOKUP, SUMIFS, and VBA macros to automate recurring reporting.
ERP & CRM Systems
Broad experience with ERP processes and CRM platforms including Salesforce administration, covering objects, fields, workflows, validation rules, process approvals, and email configuration.
Data Migration (DTW), Backup & Restore
Leading data migration projects using DTW along with database backup and restore procedures for new implementations and system upgrades.
Salesforce Administration
Creation of objects, fields, users, and core Salesforce configuration elements; generation of dashboards and reports; building validation rules, workflows, process approvals, and flows.
Data Quality & Reporting (Tableau, MySQL)
Preparation of grouped reports, charts, and drill-down reports in Tableau; design and development of graphical reports from existing data; manual report and data testing using Excel and MySQL Server.
Experience
Professional experience5 - 10 years
Freelancer since2022
Languages
EnglishFluentHindiFluent
Project history
Delivered end-to-end SAP Business One implementations, customization, and post-go-live support. Customized SAP B1 using UDFs, UDTs, FMS, validations, approvals, and authorizations. Developed SAP B1 add-ons using SAP B1 SDK and REST API integrations. Designed Crystal Reports, PLD layouts, and complex SQL/HANA queries. Led data migration using DTW and managed database backup and restore. Set up and configured Power BI for enterprise reporting with Power Query, DAX, and Microsoft Fabric integration. Designed role-based, mobile-friendly dashboards and built KPI-driven Excel dashboards.
Handled SAP installations and upgradations. Provided technical support for SAP Business One, SQL Server setup, and HANA-related queries. Applied the full range of SAP B1 technical skills across core competencies.
Developed forms and structures for Print Layout Designs (PLD) and generated reports through PLD. Provided technical support for SAP Business One and SQL Server setup. Analyzed and customized Ledger, Sales, Purchase, Service, and other modules. Created alerts, reports, layouts, validations (SP), approvals, and UDFs. Worked across the Technical Support department and live client projects.
Certificates
Oracle Database Administration (OCP)
Oracle2016