Ajay Gautam

Sr MIS Executive

New Delhi $10/hr Hybrid Full-time 7+ yrs exp 86 · Excellent

About

I am a detail-oriented MIS Executive and Data Analyst with 7+ years of experience in data analysis, dashboard creation, reporting automation, and business intelligence. I specialize in converting complex data into meaningful insights that support smarter business decisions and operational efficiency. My expertise includes dashboard development, data visualization, reporting automation, inventory and project tracking, sales and margin analysis, and management reporting using advanced Excel tools and techniques. I am highly skilled in Pivot Tables, XLOOKUP, VLOOKUP, SUMIFS, data cleaning, slicers, charts, and automated reporting systems. I have strong analytical and problem-solving abilities with a focus on improving reporting accuracy, streamlining processes, and delivering actionable insights through data-driven solutions. I am passionate about leveraging MIS and analytics to drive business growth and operational performance. I hold an MBA in Finance & HR and continuously work towards enhancing my skills in data analytics, business intelligence, and process optimization.

Skills & Expertise (6)

Advanced MS Excel functions MIS Reporting & Dashboard Creation Data Analysis Tools: MS Excel (VLOOKUP, Pivot Tables, Charts) Report Automation Data Visualization and Reporting Advanced Excel (Pivot Tables, VLOOKUP, XLOOKUP)

Work Experience

Sr. MIS Executive

Quality International Services

FEB 2024 - Present

• Manage Various Customers Purchase Orders (PO) Data for Pending and Delivery details (Material, Payments & Ageing) by Creating dashboard. • Manage Sales and purchase Margin data analysis with easy-to-understand visual reports. • Create Projects data for analysis such as Margin, timeline and costing, pendency report. • Create Reports as per requirement by management. • Developed automated dashboards using advanced Excel functions (VLOOKUP, PIVOT TABLE, XLOOKUP, UNIQUE, FILTER, DROPDOWN, SUMIFS, COUNTIFS, TRIM, CONCATENATE, TEXT, CHARTS, SLICER) • Performed financial forecasting and profit/loss analysis to aid strategic planning. • Optimized inventory planning by forecasting material requirements and costing. • Delivered insights to management using data-driven reporting techniques.

MIS Executive

EAST INDIA TRANSPORT AGENCY

MAR 2022 - FEB 2024

• Designed vehicle cost tracking models and profitability dashboards. • Conducted GST 2A/2B reconciliation and managed GST tax payments. • Managed ERP-based trip sheet entry, driver audits, and vehicle hire balances. • Created standard vs. actual variance reports and improved daily reporting efficiency. • Prepared operational and detention reports to reduce logistics overheads.

ACCOUNT EXECUTIVE

MEGA CORPORATE SOLUTIONS LLP

AUG 2018 - FEB 2022

• Handled GST filing, E-Waybill generation, and compliance documentation. • Managed client accounts for share marketing and maintained financial records. • Performed daily voucher entries and bank reconciliations using Tally ERP 9. • Supported financial audits and reporting with external CA teams.