Manish kumar Tiwari

2 years of experience as an MIS Executive. Strong knowledge of Advanced Excel, Dashboard Creation, and Data Analysis. Expertise in VLOOKUP, HLOOKUP, Pivot Tables, Conditional Formatting, and MIS Reporting.

Experience in automating reports using VBA and Macros. Skilled in Google Sheets and Google Apps Script. Familiar with AI tools and ChatGPT for productivity and reporting support. Strong analytical, communication, and problem-solving skills.

MIS EXECUTIVE at Lex Providence (2024-05 – Present)

2 years of experience in handling MIS operations across various departments related to Student Loans, Institution Loans, and Business Loans. Worked at Lex Providence for Varthana Finance Pvt Ltd and Cholamandalam Investment and Finance Company Limited.

Responsibilities included preparing daily, weekly, and monthly MIS reports, maintaining loan data records, preparing and sending legal notices through Mail Merge, updating case statuses, coordinating with legal teams, and maintaining accurate data for management review and compliance purposes. Ensured timely reporting, data validation, and smooth MIS operations to support business decision-making and portfolio management. Proficient in preparing MIS reports using Advanced Excel.

• Created interactive dashboards for management reporting.
• Utilized AI tools and ChatGPT for report formatting, email drafting, and productivity improvement.
• Coordinated with departments to collect and analyze business data.

Bachelor of Arts in B.A. – Jai Narain Vyas University (Jodhpur, Rajasthan) (2021)

Advanced Diploma in Computer Applications in ADCA – Institute for Advance Computer Technology (Delhi) (2023)

Bachelor of Legislative Law in LL.B. – Chaudhary Charan Singh University (Meerut, Uttar Pradesh)