A detail-oriented MIS and Accounts Executive with over 4 years of experience in data analysis, reporting, and financial management. Skilled in leveraging advanced Excel techniques (VBA, Macros, Pivot Tables) and Tally ERP-9 to streamline operations and deliver actionable insights. Proficient in SQL for process optimization and known for creating impactful management presentations. Committed to ensuring accuracy and efficiency in fast-paced work environments.
• Developed and automated daily, weekly, and monthly MIS reports using advanced Excel techniques (VBA, V-lookup, H-lookup, Pivot Tables, and Macros).
• Analyzed operational data to generate actionable insights for management.
• Created and maintained detailed MIS reports, ensuring timely communication with management.
• Performed reconciliation tasks including bank and sales accounts.
• Processed accounting transactions using Tally ERP-9, ensuring compliance with organizational standards.
• Handled accounts finalization and reconciliations for customers and suppliers.
• Maintained stock records and managed the booking of income and expense entries.
• Prepared insurance charts and ensured timely follow-ups.
Advanced Excel
VBA Programming
SQL Basics
Tally ERP-9
Reporting and Analysis