Bhardwaj Kapil

Developed and maintained MIS Reports, Dashboards & Automated Reports using Excel (VBA),
Google Sheets, and SQL.
• Generated Daily, Weekly, Monthly, and Quarterly MIS Reports for management.
• Created Performance Dashboards (KPI, SLA, Productivity, Target vs Achievement).
• Performed Data Analysis, Data Validation, and Data Cleansing for accurate reporting.
• Automated reports using VBA, Macros, and Google Apps Script, reducing manual effort.
• Delivered Business Insights & Data-driven Recommendations to senior management.
• Worked on tools like Excel, SQL, SAP CRM, Looker Studio for reporting & analytics.
• Managed end-to-end Accounts Payable & Receivable, including invoicing, collections, and vendor
payments.
• Performed Bank Reconciliation, Ledger Scrutiny, and Account Finalization on a monthly basis.
• Prepared Financial Statements, P&L Reports, and Variance Analysis for management review.
• Handled GST (GSTR-1, GSTR-3B), TDS Calculation & Compliance, including reconciliation and filing
support.
• Maintained Books of Accounts, Vouchers, and Financial Records as per statutory norms.
• Coordinated with Auditors and Tax Consultants for audits and compliance.
• Managed Billing Discrepancies, Payment Issues, and Credit Control efficiently.
• Managed PF, and ESIC challans and all activity.
• Supported Budgeting, Forecasting, and Financial Planning activities.
• Managed Procurement Cycle from requirement generation to purchase order (PO) closure.
• Created and processed Purchase Orders (PO) ensuring accuracy and timely approvals.
• Conducted Vendor Selection, Negotiation, and Rate Finalization to optimize cost.
• Handled Vendor Management & Coordination for timely delivery and payments.
• Ensured Inventory Coordination & Stock Availability as per business needs.
• Monitored Cost Optimization, Budget Control, and Purchase Planning.
• Verified Vendor Invoices and GRN (Goods Receipt) before payment processing.
• Maintained Purchase Records, MIS Reports, and Documentation.