Shubham Kumar Email & Phone Number

Gurugram, Haryana, India

Bengaluru Area, India

• Automating the process of segregating and cleaning revenue and cost data from the dump of transaction-level data and deriving monthly reports from it. Organizing these data and making a historical database using Excel and MS SQL server. This, in turn, made the whole process of forecasting more efficient and accurate.• Deriving P&L at the console, BU, and department level for the first time in the company.• Collaborating with different team heads and providing them an extensive analysis of department-level data to increase their team efficiency and help them in decision making.• Analysing revenue, payroll, travel, server cost & overall cost data and making various insightful reports for the decision makers and investors of the company using PowerBI and Excel.

Chennai

• Performed competitor’s analysis, market research, and landing page optimization for all the products of Naomi Home (a furniture brand) on e-commerce websites.• Revised, created, and implemented Amazon ad campaigns for a total daily budget of $1000+.• Strategized and created a comprehensive dashboard for analyzing Amazon ad campaigns using Power Query and Excel. Worked on creating a dashboard to track sales of Naomi Home across all e-commerce channels using SQL and Google data studio.

Iit Guwahati

Spirit is the annual sports festival of IIT Guwahati. Since its inception, Spirit has served as a great platform for budding sports enthusiasts and also recognizing great talents in different sporting events by taking a leap forward in redefining the spirit of sports. Spirit’17 has evolved as a biggest sports festival of Northeast India with the former Australian international cricketer, Brett Lee inaugurating the event as a Chief Guest.- Recruited and lead a 2-tier team of 20 students in order to organize events at Spirit 2017. The work involves planning and execution of events and introduction of new attractions inside the festival including some informal events.- Part of the decision making body for planning and allocating the budget for the festival.

Iit Guwahati

Alcheringa is by far the largest cultural festival of North-East India and since its inception has served as a pioneer of art and culture for the youth. With its spectacular events and competitions, Alcheringa attracts people from all over India. The festival enjoys the mammoth footfall of over 90,000 people and participation from over 450 colleges across India.- Managed on-field security, entry, exit and safety of over 90,000 general crowds; internal transport and safety of artists for 4 days during Alcheringa.- Coordinated and strategized deployment with CRPF Personnel, Assam State Police and Institute Security while leading Alcheringa Security Team to secure and diffuse any potential situations.

Iit Guwahati

- Part of team which was responsible for nationwide publicity, maintaining brand value of the festival and getting 3500+ participants in 70 different events and a footfall of 80000+ people during 3 days and 4 nights of the annual cultural extravaganza.- Responsible for contacting and inviting various institutes, crews and colleges from Northeastern states to participate in Alcheringa'17.- In the course of festival, was a part of team responsible for managing the hospitality of 1500+ participants.