SUMIT
New Delhi
Summary
Data-focused professional with 3+ years of accounting experience and practical training and internship experience in data analytics. Skilled in end-to-end data cleaning, ETL, statistical analysis and interactive dashboarding. Strong foundation in accounting operations, GST/TDS compliance and financial reconciliations - now transitioning into data analytics roles where I apply analytical techniques to business and financial datasets.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst Intern
AI Variant
05.2025 - 08.2025
- Performed data cleaning, transformation, and validation using Python (pandas), Power Query, and MySQL to prepare datasets for analysis.
- Conducted exploratory data analysis and statistical testing to identify patterns and actionable insights.
- Built interactive dashboards and visual reports in Power BI and Tableau to support stakeholder decisions.
- Automated routine ETL steps, prepared documentation, and collaborated with cross-functional teams.
- Tools: Python (Pandas), MySQL, Power BI, Tableau, Excel, Jupyter Notebook.
Accountant
Ashok Ram & Co. (CA Firm)
11.2021 - 04.2025
- Managed full-cycle bookkeeping using Tally Prime and Busy: sales, purchases, credit/debit notes, journals and branch accounting.
- Executed bank reconciliations and debtor/creditor reconciliations; maintained accounts payable and receivable.
- Performed GST compliance (GSTR-1, GSTR-3B), ITC reconciliation, and GSTR-2A/2B reconciliations; supported TDS processing and MSME registrations.
- Handled import bill-of-entry bookkeeping, stock journals and monthly closing activities.
- Tools: Tally Prime, Busy, Excel.
Education
Bachelor of Commerce (B.Com) -
Delhi University
01-2023
Skills
- Python
- MySQL
- Power BI
- Tableau
- Advanced Excel
- Jupyter Notebook
- Power Query
- Data Cleaning
- Data Visualization & Dashboarding
- Statistical Analysis
- Tally Prime
- Busy
- Bank Reconciliation
- Debtor and Creditor Reconciliation
- Accounts Payable/Receivable
- GST Returns (GSTR-3B, GSTR-1, GSTR-2A, GSTR-2B)
- ITC Reconciliation
- TDS Processing
- MSME Registrations
Projects
Amazon Sales Analysis - EDA & Dashboard, Performed end-to-end data preparation and exploratory data analysis using Python and MySQL; applied statistical tests and correlation analysis to evaluate relationships., Developed interactive dashboards in Power BI and Tableau to visualize sales trends, product and payment-method patterns, and time-based performance., data cleaning, feature engineering, hypothesis testing, visualization, dashboard storytelling Adventure Works Cycle - Sales & BI Dashboard, Conducted ETL and data modeling using MySQL and Power Query; created dashboards in Tableau and Power BI to present sales, product and demographic metrics across time and geography., SQL-based joins & aggregation, relationship building, cross-tool reporting, KPI monitoring
Certification
Data Analytics - ExcelR (Python, Advanced Excel, Power BI, Tableau, Statistics, MySQL)
Personal Information
Date of Birth: 04/24/02
Languages
French
First Language
Timeline
Data Analyst Intern
AI Variant
05.2025 - 08.2025
Accountant
Ashok Ram & Co. (CA Firm)
11.2021 - 04.2025
Bachelor of Commerce (B.Com) -
Delhi University