Sumit Jayswal

About Sumit Jayswal

Currently working with M3M India Pvt Ltd. Skilled in Operations Management, Analytical…

Experience

1. Manager Business Analytics

   M3M India Private Limited

   May 2023 — Present · Gurugram, IN

   Prepare daily reports for Brand Managers, including Outdoor and Indoor reports, PR & NFA reports, and coordinate with the purchase team for PO finalizations. Provide daily updates on PR/NFA and PO pending statuses, sharing reports with Brand Managers and HODs for action.• Generate Digital Marketing Expense reports, Lead Status reports, and Budget vs. Spend analysis. Prepare CPL and CPQL reports and share them with Marketing Heads, Sales Heads, and management on a daily basis using data from the SFDC platform. Regularly review media plan performance to assess campaign results by project.• Analyse Smart Task reports to evaluate Brand Manager Performance on a daily basis.• Track project-wise expenses for ongoing and upcoming initiatives, coordinating with the digital team for integration and timely reporting.• Prepare PO/WO reports, analyse them against budget allocations, and track actual vs. spend, evaluating the percentage of project budget allocation.• Compile and reconcile Invoice and Expense reports against the actual budget and expenses to ensure accuracy and alignment.• Prepare Budget vs. Actual reports, coordinating with Finance for head wise expense reconciliation and reallocating expenses as needed in collaboration with the purchase team.• Maintain a Digital Asset report, tracking registration and renewal logs based on expiry dates and new requests.Prepare Presales Reports and coordinate with the CRM team to track the status of each lead, ensuring accurate classification of qualified and non-qualified leads.

Education

• Sikkim Manipal University - Distance Education

  MCA - Master of Computer Applications, Data Modeling/Warehousing and Database Administration

  2014 — 2018

• Bhupendra Narayan Mandal University, Madhepura

  Bachelor’s Degree, B.A History (Hons)

  2007 — 2011

Skills

• Project Planning
• Visual Basic for Applications (Vba)
• Flash Animation
• Management
• Analytical Skills
• Team Management
• Customer Relationship Management (Crm)
• Pagemaker
• Operations Management
• Vendor Management
• Data Analysis
• Management Information Systems (Mis)