Projects using SQL in AhmedabadProjects using SQL in AhmedabadCrystal Reports Suite for SAP B1 HANA | BP Ledger & Financial Reports
Developed a complete set of Crystal Reports for a SAP Business One HANA environment, connected directly through SAP Crystal Reports and HANA Studio. This BP (Business Partner) Ledger Report shows a running-balance statement with opening balance, transaction-level detail (date, document number, narration, debit/credit), and an auto-calculated running total the kind of report finance teams rely on for balance confirmations and reconciliation.
What the report package includes (visible across the open tabs):
BP Ledger Report : running-balance statement with opening balance carried forward, per-transaction debit/credit, and a live running total, filterable by date range
Ledger Report – Party-wise : the same ledger logic segmented by business partner, for multi-party reconciliation
Ledger Report : a general-purpose ledger view
Stock Statement : inventory position reporting
Purchase Order report : procurement-side documentation
Technical approach:
Built and queried directly against SAP B1 HANA using HANA Studio and native Crystal Reports connectivity, not a flattened export
Running totals calculated natively in Crystal Reports (Running Total Fields) so balances stay accurate as new transactions are added, with no manual re-calculation
Parameterized date-range filtering (Balance Confirmation From/To) so the same report serves any period without rebuilding
Clean, print-ready formatting suitable for sending directly to a customer or vendor for balance confirmation
Why this matters to a client:
A BP ledger with a running balance sounds simple, but getting the running total to calculate correctly against opening balances, filtered date ranges, and grouped by party takes real Crystal Reports and HANA query experience. This is a day-to-day report almost every SAP B1 finance team needs, and I can build the full set ledger, stock, purchase, and party-wise views as one connected package rather than one-off reports.
#CrystalReports #SAPHANA #HANAStudio #SAPBusinessOne #FinancialReporting #LedgerReports #RunningBalance #Accounting #BusinessConsulting #FinancePlanning #FinanceAnalysis #DataModeling All-in-One Developer Tools Platform
Technologies: React, NodeJs, Advanced Package, Render, Vercel
Status: ✅ Live on Two Cloud Platforms
Tools Built: 30+ Developer Utilities
## The Challenge ##
Developers and teams waste 1-2 hours per week switching between dozens of scattered online tools for basic tasks like formatting JSON responses, converting data formats (Base64, URL encoding), generating passwords and UUIDs, hashing data for security, converting images, and counting words or analyzing text.
The problems with existing solutions are significant. Data gets sent to third-party servers, creating security risks. Ads and pop-ups slow down workflow. Multiple subscription fees cost $10-50/month per tool. UI/UX remains inconsistent across different websites. And there is no customization for team-specific needs.
## The Solution ##
I built a comprehensive, all-in-one Developer Tools Platform that consolidates 30+ essential utilities into a single, secure, fast, and free platform.
1. Code Formatting Tools
- The platform includes JSON Prettify and Validator for formatting and validating JSON with syntax highlighting, HTML Prettify for cleaning up messy HTML code, CSS Minify for compressing stylesheets, and CSS Prettify for beautifying CSS code.
2. Data Conversion Tools
- Users can encode and decode URLs for safe web use, convert text and files to Base64 and back (essential for HTTP Auth and JWT), convert JSON data to CSV format for spreadsheet compatibility, and convert CSV data back to JSON format.
3. Security Tools
- The platform generates MD5 hashes for data integrity checks, SHA-256 hashes (the industry standard for security), and SHA-512 hashes for enhanced security requirements.
4. Random Data Tools
- Developers can generate secure, random passwords with customizable strength, create unique UUIDs for database records, and generate random numbers within specified ranges.
5. Utilities
- The suite includes a word counter for content planning, a timestamp converter for transforming Unix timestamps into readable dates, and a lorem ipsum generator for design mockups.
6. Database Query Validator
- Users can validate the query and check the verify the results across testing database. SAP Business One (HANA) Native Dashboards & KPIs
Built native SAP Business One HANA dashboards directly inside the SAP B1 client real-time KPI widgets running on live HANA data, with no separate BI tool required. This gives users instant visual insight the moment they log into SAP B1, right on their home screen.
What the dashboard delivers:
Customer-wise sales KPI : a ranked table of top customers by total sales amount, pulled live from SAP B1 sales data
Year-over-year comparison chart : Current FY vs. Previous FY vs. Prev-of-Previous FY, broken down by month, so trend analysis is available without exporting to Excel
Monthly sales bifurcation : a bar chart tracking total sales amount by month across the fiscal year for quick pattern spotting
Item-group-wise Sales Order totals : both a pie chart (proportional share by item group) and a horizontal bar chart (absolute SO totals), giving two views of the same data for different reporting needs
Purchase order tracking widget : a live count of "My Purchase Orders Not Received," turning a report that used to require manual checking into an always-visible alert
Built entirely on HANA calculation views : meaning the dashboards refresh against live transactional data with strong performance, not batch-refreshed extracts
Why this matters to a client:
Most SAP B1 users only see this kind of visibility if they buy and connect a separate BI tool. I build the same KPI/dashboard experience natively inside SAP B1 using HANA views and the built-in dashboard framework so there's no extra license, no separate login, and no data-sync lag. It's the fastest way for a SAP B1 HANA client to get real-time visual reporting without adding another system.
Suggested tags: SAP Business One SAP HANA HANA Calculation Views KPI Dashboard Native Dashboard Development Sales Analytics
One-line hook for the service card (under 100 chars):
Native SAP B1 HANA dashboards - real-time KPIs with no separate BI tool needed.
One more thing worth doing now that you have 4 solid samples (ELN/pharma, manufacturing job card, Power BI sales dashboard, also work with different industries, and this HANA dashboard): they span your 3 services nicely, this one and the Power BI one go under Service 1 (Reporting & Power BI Dashboards), and it's worth explicitly adding "native HANA dashboard development" to that service's tags/description too, since it's a distinct enough skill that clients may search for it specifically. The platform is a modern, interactive Gujarati language learning solution tailored for beginners and young learners, designed to deliver a clear and engaging learning journey. It follows a structured, phase-based approach that ensures users build a strong foundation before progressing to more advanced concepts in a natural and intuitive way.
The learning experience begins with auditory understanding and vowel recognition, then moves into reading and writing through consonant mastery and tracing practice. As users progress, the platform introduces real-world communication through daily phrases, vocabulary building, and interactive matching exercises. The final phase focuses on contextual understanding and cultural connection, using image-based learning and sentence construction to help learners apply their knowledge in practical scenarios.
The entire experience is enhanced with gamified elements, a visually appealing and intuitive interface, and activity-driven modules that keep users engaged throughout their journey. By combining structured education with interactive design, the platform offers a scalable and effective digital learning solution that can be further extended with features such as progress tracking, AI assistance, and personalized learning paths.
Notably, the complete platform was designed and developed within just three days to meet a fast-paced client requirement, demonstrating both agility and the ability to deliver high-quality solutions under tight timelines. 
