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) Grade:

Saint Brij Mohan Lal Senior Secondary School

Faridabad, Haryana, India
→
Senior Secondary Class 12th Commerce Grade:

Saint Brij Mohan Lal Senior Secondary School

Faridabad, Haryana, India
→
Senior Secondary Class 10th General Studies Grade:

Languages

English

Hindi

Certificates

Advanced Excel

OneRoadmap

Finding, Sorting, & Filtering Data in Microsoft Excel

Coursera

Creating a Budget with Microsoft Excel

Coursera

Create Simple Formulas in Excel Spreadsheet

Coursera

Business Analysis & Process Management

Coursera

Prompt Engineering Applications

Simplilearn

Microsoft 365 Copilot Chat

Microsoft

Learn Copilot Deployment with Strategy

Academy

Create Charts and Dashboards Using Microsoft Excel

Coursera

Advanced Tally Prime

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.