Summary
Overview
Work History
Education
Skills
Extracurricularleadership
Timeline
Generic
SHASHWAT SINGH

SHASHWAT SINGH

Jaunpur

Summary

Dynamic Business Analyst with a proven track record at Genpact India Pvt Ltd, specializing in data analysis and financial forecasting. Leveraged MS Excel and SQL to enhance budget reporting processes, achieving streamlined operations. Excelled in problem-solving and consulting, contributing to significant sales and financial strategy improvements.

Overview

7
7
years of professional experience

Work History

Assistant Manager

Genpact India Pvt Ltd
Gurugram
06.2022 - Current
  • Company Overview: Currently working with American Waste Management, based in New Jersey, United States.
  • Preparing comprehensive individual monthly sales and budget reports from the invoices obtained through NetSuite, QlikView, Sage, Stui, and 10 different systems for the company's sales managers across North America.
  • Programming an automation code in VBA to streamline the process of extracting data from NetSuite and QlikView to the final report for the next financial year.
  • Performing data analysis to determine the QoQ trend of the payout that is given to individual salespeople as an incentive for each quarter.
  • Making cost incentive models for the leadership to evaluate various scenarios for the upcoming FY incentive plan.
  • Preparing a financial budget for the year 2025 based on the revenue generated by the recurring business, taking CPI inflation, and sales growth into consideration.
  • Comparing invoiced revenue with the financials every month to determine if they are aligning.

Financial Research Intern

Mangal Fincorp
Chennai
04.2021 - 05.2021
  • Inferred the overall functioning of the gold loan industry, its financing strategy, and interacted with existing and potential clients to understand their current needs and future prospects.
  • Prepared a business model based on the Hambrick Diamond, Porter's 5 Forces Analysis, SWOT Analysis, PEST Analysis, and other business strategic models.
  • Prepared financial model - projection/budgeting of yearly costs - income and expenses, and all related finance models and strategies that could help in achieving a goal of 500 crore AMU by 2025.

Mechanical Engineering Intern

TATA Marco Polo
Lucknow
12.2017 - 01.2018
  • Learned about different steps in the fabrication of a bus, including preparation and installation of the structure on the chassis, paneling, painting, trimming, and finally testing.
  • Installed bus roof, front, and rear skin during the paneling process.
  • Operated power tools, gauges, and testing equipment to analyze different bus components.

Education

Master of Business Administration -

IFMR Graduate School of Business
Sri City
07.2022

Bachelor of Technology - Mechanical Engineering

SRM Institute of Science & Technology
Chennai
05.2019

Skills

  • MS Excel
  • MS Office
  • Basic SQL
  • Visual Basic Application
  • Basic PowerBI
  • Budget assistance
  • Problem-solving
  • Recruiting and interviewing
  • Sales forecasting
  • Consulting

Extracurricularleadership

  • Participant, HUL LIME Season XII, Sri City, AP, India, 08/20, Identified a problem through research and analysis in case study released by Hindustan Unilever Limited LIME championship. Outlined a business proposal to address the problems in the case study.
  • Summer Intern, Clean India Mission, Jaunpur, UP, India, 06/18, 07/18, Organized awareness campaigns in rural regions to promote the mission goal of Reduce, Reuse and Recycle., Volunteered to construct compost pits, to encourage villagers for a proper solid waste management., Collaborated with local women association to increase awareness about proper menstrual hygiene among rural women and advocating for the use of sanitary products.
  • Undergraduate Volunteer, MILAN National Fest, Chennai, TN, India, 03/16, 04/16, Directed and supervised various educational and cultural events took place during Milan cultural fest in SRMIST., Coordinated with a team of students for organizing sports competitions and tournaments.
  • Sports Team Captain, SRM Institute of Science and Technology, Chennai, TN, India, 07/15, 05/19, Lead cricket team named Spartans to victory in multiple sports tournament throughout undergraduate studies., Represented university cricket team in inter-college tournaments.

Timeline

Assistant Manager

Genpact India Pvt Ltd
06.2022 - Current

Financial Research Intern

Mangal Fincorp
04.2021 - 05.2021

Mechanical Engineering Intern

TATA Marco Polo
12.2017 - 01.2018

Master of Business Administration -

IFMR Graduate School of Business

Bachelor of Technology - Mechanical Engineering

SRM Institute of Science & Technology
SHASHWAT SINGH