Dhiraj Karamchandani
Ahmedabad
Summary
Accountant with hands-on experience at Bankai Informatics Private Limited & Textiles Firm, now transitioning into Data Analysis. Skilled in SQL, Excel, Power BI, and Python, with a strong foundation in financial data analysis, reporting, and business insights.
Overview
4
4
years of professional experience
2025
2025
years of post-secondary education
Work History
Accountant
Bankai Informatics Private Limited
Ahmedabad
07.2024 - Current
- Processed invoices and payments using accounting software systems.
- Maintained accurate financial records and documentation for audits.
- Assisted in preparing monthly financial reports for management review.
- Supported budgeting processes by analyzing expense trends and variances.
- Handled payroll processing and employee expense reimbursements efficiently.
- Provided support during external audits by gathering required documentation.
Accountant
Himanshu Textiles
Ahmedabad
09.2021 - 07.2024
- Maintained accurate financial records and documentation for audits.
- Reconciled bank statements with internal accounting records regularly.
- Provided support during external audits by gathering required documentation.
- Created journal entries accurately and timely for month end close processes.
- Reported on financial results including balance sheets, income statements, cash flow statements.
- Monitored cash flows and prepared weekly cash projections.
- Assisted in the preparation of tax returns by gathering necessary information from clients and maintaining organized files with documents related to taxes.
Education
Data Analytics - Data Analytics
Tops Institute
05.2025 - 01.2026
Bachelor of Commerce - Accounting And Finance
Gujarat University
Ahmedabad, India 04.2021 - 03.2024
Mahatma Gandhi High School
Ahmedabad, IndiaSkills
- Data analysis
- Financial reporting
- Microsoft Excel
- Budgeting support
- Data visualization
- Financial analysis
- Python programming
- Good Hands in MySQL Databases
- Advanced Excel (Pivot Charts, Diagrams & Query Languages)
- Advanced Statistics
Languages
Sindhi
First Language
Gujarati
Proficient (C2)
C2
Hindi
Advanced (C1)
C1
English
Proficient (C2)
C2
Power BI Projects
- Blinkit Sales & Operations Analysis (Power BI)
- Built interactive dashboards to analyze sales performance, delivery efficiency, customer demand, and category-wise trends
- Used Power Query for data cleaning and transformation
- Designed DAX measures for KPIs such as revenue growth, order volume, average order value, and delivery time insights
• IPL Data Analysis Dashboard (Power BI)
- Developed a dynamic dashboard to analyze team performance, player statistics, match outcomes, and venue-based trends
- Implemented DAX calculations for win percentage, top scorers, and season-wise comparisons
- Enabled user-driven insights using slicers and drill-through features
Excel Projects
- Ferns & Petals Sales Analysis (Advanced Excel)
- Performed end-to-end sales analysis using Pivot Tables, Pivot Charts, Power Query, and advanced formulas
- Analyzed revenue trends, product performance, regional sales, and customer behavior
- Delivered actionable insights to improve seasonal and occasion-based sales strategies
• Loan Banking Analysis (Advanced Excel)
- Analyzed loan portfolio data to identify risk patterns, repayment behavior, and customer segmentation
- Supported data-driven decisions for loan approval and risk assessment
SQL/MySQL Project
- Coffee Shop Sales Data Analysis (MySQL)
- Designed and analyzed a relational database for transactional sales data
- Wrote complex SQL queries, including joins, subqueries, CTEs, window functions, views, and stored procedures
- Extracted insights on revenue trends, best-selling products, store-wise performance, and time-based sales patterns
Python (Data Analysis & Automation)
- Data Cleaning, Web Scraping & Analysis (Python)
- Worked on complex Python programs involving data cleaning, transformation, and validation
- Implemented web scraping techniques to extract structured data from websites
- Applied Python core concepts, NumPy, and Pandas for data manipulation, analysis, and automation tasks
Skills Used in Projects
- Technical Skills Used Across ProjectsPower BI | DAX | SQL (MySQL) | Excel (Advanced) | Python | Pandas | NumPy | Web Scraping | Data Cleaning | Data Visualization | Business Insights
Timeline
Data Analytics - Data Analytics
Tops Institute
05.2025 - 01.2026
Accountant
Bankai Informatics Private Limited
07.2024 - Current
Accountant
Himanshu Textiles
09.2021 - 07.2024
Bachelor of Commerce - Accounting And Finance
Gujarat University
04.2021 - 03.2024
Mahatma Gandhi High School