Pankaj S.

I have experience of 20+ years of Accounting & Book keeping; Finalization till Net Profit; Budgeting from its preparation, periodic review and its tracking with actuals; Complete (India) Payroll Processing; Intercompany & Financial Reconciliations. I am expert in Excel Macros / VBA. I have developed various utilities with excel formulas & Macros Like Invoicing application, Dynamic Expense claim format, Automated Payroll sheets, Basic Management Information System (MIS), Projects Management Sheet etc. For development of such dynamic sheet, I have done data modeling & data flow design. Work Style & Strengths: • Thinks critically and “out of the box” – often appreciated by superiors. • Self-driven and proactive in setting up new systems and taking initiatives. • Honest, trustworthy, calm, well organized, and adaptive in team environments. • Quick learner – grasps complex tax, compliance, and tech subjects efficiently. • Prefers clear planning, role explanation, and aligning team with objectives. • Played Whistle-blower role as and when required. Managerial and Administrative Skills: • Team building, interdepartmental coordination, and employee mentorship. • Compliance, governance, and process optimization for daily operations. • Conflict resolution, communication improvement, and decision-making support. • Managed complete office & facility relocations with business continuity. • Developed and implemented clear systems for document tracking and asset tagging. Financial and Accounting Expertise: • Handled bookkeeping, accounts finalization, monthly closure, and audit preparation. • Handled Budgeting from data collection, budget preparation, periodic review, continuous tracking and control. • Created formats for TDS data, expense claim automation, and payroll reports. • Designed & implemented automated Excel tools for tax returns and reporting. • Ensured 100% compliance in tax returns: TDS, PF, GST, PT, LBT. • Designed detailed MIS & budgeting tools to support proactive planning. Noteworthy Achievements: • Developed fully automated expense claim format adopted across Asian branches. • Implemented payroll automation system with macros, reducing manual effort & time, increased accuracy. • Built structured systems for employee communication on payroll, taxes, PF, and rights. • Created a unique TDS data sheet/ format appreciated by auditors and adopted by them for their clients. • Designed a structured asset tagging system improving traceability and verification. • Proposed and implemented monthly book closure checklist improving accuracy. • Improved documentation systems with file tagging, indexing, and summarization. Technical & IT Skills: • Strong in Excel automation, Macros, MS Access, PowerPoint. • Handled responsibilities as IT support (layer 3) for 2.5 years. • Self-learned coding basics: Python, HTML, XML, VBA, C, PHP. • Skilled in setting up filing systems, process documentation, and reporting tools.