Summary
Overview
Work History
Education
Skills
Websites
Certification
Projects
Timeline
Generic

VIKAS KUMAR GUPTA

Lucknow

Summary

Having 6+ years of experience in Operations and MIS & Finance, using various tools such as Excel, SQL, and Google Sheet. Graduated in Mechanical Engineering from Bansal Institute of Engineering and Technology, Lucknow. Seeking full-time employment in analyst roles. I want to work in an environment where my knowledge reflects the growth of the company and enhances my knowledge, as well as experience.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Senior Executive (Finance)

Noon E-Commerce (Mynd Integration Solutions Pvt Ltd)
Gurgaon
03.2023 - Current
  • Negotiated contracts with vendors for goods and services at competitive prices.
  • Preparing reconciliation sheet using Excel, Goggle sheet & SQL for invoice booking.
  • Checking invoices like TRN no., Invoice no, PO no., Company address & so on before invoice booking.
  • Making Wallet Adjustment summary regarding any rebates or Credit note for any deduction before Vendor Payment.
  • Coordinated cross-functional teams to streamline processes and improve efficiencies for any vendor payment.
  • Solving the vendor queries regarding deduction in payments & provide proper deduction details to vendor by mails.
  • Knowledge of operations in all aspect of Administration & Facilities.

Operation Executive

Vanshika HR Services Pvt.Ltd.
Lucknow
11.2021 - 12.2022
  • Preparing MIS report of 75 City Electric Buses regarding their Running KM, Total income, route planning reports with the help of , Excel, basic SQL and Google Spreadsheets
  • Managed the daily operations of the organization, including staffing, budgeting, scheduling, and problem resolution
  • Handling 150 Manpower Queries (Duty Roaster, Ticket Checking ) in Lucknow City Transport Services Limited
  • Daily Preparing Passengers complains report of staff misbehavior by using Excel tool and basic SQL and everyday take feedback regarding issue of Ticket Machine
  • Maintained up-to-date records of all operational activities in accordance with company policies and procedures.
  • Knowledge of safety procedures & their implementations as per SOP & also tracking and maintaining records of all consumables- like Daily electrical consumption, service records of Facility equipment's.

Emergency Management Executive

GVK EMRI
Lucknow
08.2017 - 11.2021
  • Handling Vendor Queries mail box by calls and Mail
  • Preparing MIS report on daily basis like every Ambulances cases report, their SNR report, Response Time report and also fleet reports and Mobile apps report
  • Responsible for identifying and enhancing business relations with local vendors (Spare part dealers, workshops, tyres and batteries supplying agencies, fuel filling stations and agencies)
  • Preparing the duty roster, Scheduling of resources, Attendance, leave management and performance Management at ambulances and reviewing the audit observations and NCs closure and NC closure report to Quality team
  • Responsible for generating and implementing monthly calendar for ambulance visits, Inspections and record maintenance and also responsible for coordinating and executing regular training modules for EMTS and Pilots (Internal and External).
  • Keeping records of Diesel consumption and received & knowledge of store/inventory operation & responsible for service/maintenance of All equipment's (vehical maintenance & medical equipment )

Education

Bachlor Of Technology - Mechnical Engineering

Bansal Institute Of Engineering & Technology
Lucknow, India
10-2016

Intermediate - Mathematics

M.M.M Inter College
Bhatpar Rani, Deoria, India
06-2012

Highschool - Science

Prestige Tutorial Inter College
Deoria, India
06-2010

Skills

  • Microsoft Office
  • SQL
  • Google Sheet
  • Financial Acumen
  • Team building
  • Problem Solving
  • Strategic Planning
  • Process optimization
  • Vendor management
  • Team management

Certification

Best Employee, District Magistrate Santkabir Nagar, 2021

Projects

Mechanical Solar Power Hacksaw, Bansal Institute Of Engineering And Technology, 11/01/15, 01/31/16, The Mechanical Solar Power Hacksaw is a machine designed to harness solar energy for the purpose of driving a hacksaw blade to perform cutting operations. The device can be used in workshops or industries where manual cutting of materials can be automated to save labor, energy, and time. This project also focuses on renewable energy utilization by incorporating solar panels as the power source.

Timeline

Senior Executive (Finance)

Noon E-Commerce (Mynd Integration Solutions Pvt Ltd)
03.2023 - Current

Operation Executive

Vanshika HR Services Pvt.Ltd.
11.2021 - 12.2022

Emergency Management Executive

GVK EMRI
08.2017 - 11.2021

Bachlor Of Technology - Mechnical Engineering

Bansal Institute Of Engineering & Technology

Intermediate - Mathematics

M.M.M Inter College

Highschool - Science

Prestige Tutorial Inter College
VIKAS KUMAR GUPTA