SHUBHAM

Commerce Graduate | Financial Accounting & Data Analysis Specialist
Faridabad, IN.

About

Highly analytical Commerce graduate with a robust foundation in financial accounting, data analysis, and business process management. Proven expertise in Tally Prime for comprehensive accounting operations and advanced Excel for data visualization, dashboard creation, and VBA automation. Adept at leveraging AI tools, including Microsoft Copilot, to drive productivity, enhance accuracy, and inform decision-making in financial reporting and business intelligence, as demonstrated through a self-developed 22-sheet business analysis system.

Education

Manav Rachna International Institute of Research & Studies
Faridabad, Haryana, India

Bachelor

Commerce (Honours)

Saint Brij Mohan Lal Senior Secondary School
Faridabad, Haryana, India

Senior Secondary Class 12th

Commerce

Saint Brij Mohan Lal Senior Secondary School
Faridabad, Haryana, India

Senior Secondary Class 10th

General Studies

Languages

English
Hindi

Certificates

Advanced Excel

Issued By

OneRoadmap

Finding, Sorting, & Filtering Data in Microsoft Excel

Issued By

Coursera

Creating a Budget with Microsoft Excel

Issued By

Coursera

Create Simple Formulas in Excel Spreadsheet

Issued By

Coursera

Business Analysis & Process Management

Issued By

Coursera

Prompt Engineering Applications

Issued By

Simplilearn

Microsoft 365 Copilot Chat

Issued By

Microsoft

Learn Copilot Deployment with Strategy

Issued By

Academy

Create Charts and Dashboards Using Microsoft Excel

Issued By

Coursera

Advanced Tally Prime

Issued By

Logics Computer Institute

Skills

Financial Accounting & Reporting

Tally Prime, Ledger Setup, GST/IGST Compliance, Multi-Company Accounting, Inventory Management, Stock Control, Voucher Processing (Purchase, Sales, Payment, Receipt, Journal, Contra, Credit/Debit Notes), P&L Statements, Balance Sheets, Cash Flow Analysis, Statutory Compliance, Tax Management, Regulatory Reporting, Audit Documentation.

Data Analysis & Business Intelligence

Advanced Excel (XLOOKUP, VLOOKUP, SWITCH, SEQUENCE, PMT, IFERROR, SUMIF), Statistical Functions, Interactive Dashboards, Charts, Pivot Tables, Data Visualization, Multi-Chart Analysis, Trend Identification, Data Validation, Conditional Formatting, Worksheet Organization.

Process Automation & AI Integration

VBA Programming, Macro Development, Automation Solutions, Microsoft Copilot, AI-Powered Solutions, Error Checking, Formula Optimization, Data Integrity Verification, Automated Reporting, Business Process Analysis, Process Flow Diagrams, Workflow Optimization, Productivity Enhancement.

Interests

Hobbies

Data Visualization, Dashboard Creation, Cycling.

Projects

Excel Business Intelligence Workbook

Summary

Designed a comprehensive 22-sheet business analysis system for complete operational tracking and reporting, leveraging advanced Excel capabilities.