NIKHIL SANWAL

Experience

• 

  I3 Consulting Private Ltd.

  Jan 2015 - Jul 2017

  Responsible for deploying PMO at client location to collect and update their weekly data and apply various Inventory, Account Receivable and Account Payable Analysis to optimize the working capital.My responsibility was to collect data consolidate it using Macros in VBA in Excel to update the weekly data and then build an Excel Dashboard representing various trends and then recommend actions.Built a dashboard for Inventory management to help the client analyze the inventory and helped the client order products based on the forecasted figures. Show less

  • Senior Analyst

    Oct 2016 - Jul 2017

  • Analyst

    Jul 2015 - Sept 2016

  • Analyst Intern

    Jan 2015 - Jul 2015
• 

  State Bank of India

  Dec 2017 - Jun 2019

  Probationary Officer

  • Performed daily branch administration operations, sourced new business, handled customer interactions, queries & complaints• Handled the advances portfolio in the Retail, and SME business segments to achieve 110 % of the allocated budgets at Rs. 4.00 Cr • Promoted 3 new products of the bank & generated revenue of Rs. 60 lakhs for SBI Mutual Fund & Rs. 10 lakhs for SBI Life Insurance • Assisted in successful completion of Risk Focused Internal Audit aiding branch up-gradation from BB to AA Show less

• 

  ConSIG, SJMSOM, IIT Bombay

  Nov 2019 - Apr 2021

  Core Member

  • Hosted 11 Consulting industry stalwarts at ConSIG Continuum–2020 rolling seminar series• Authored, designed the 1st edition of the Consulting Casebook–2020, SJMSOM, IIT Bombay• Mentored 115 juniors, prepared them by conducting consulting sessions & mock interviews

• 

  Accenture

  Apr 2020 - Jun 2020

  Summer Intern

  • Worked on all 3 aspects of Consulting: Client Deliverables, Business Development and Building Key Strategic Assets for the firm• Analyzed the entire value chain of a leading CPG firm to identify 40 IX.O Lean Manufacturing solutions enabling reliable operations and reduced manufacturing costs.• Charted end-to-end passenger journey for a major Indian International airport & proposed 18 IoT offerings• Formulated a strategic IX.O Maturity Assessment Toolkit for the CPG Industry having a set of 45 questions Show less

• 

  Dare2Compete

  Jul 2020 - May 2021

  Chief Igniter - D2C Igniters Club, SJMSOM, IIT Bombay

  • Promoted talent globally across 10000 institutes & 1 Mn students by heading a team of 5• Assisted in organizing 32 intra & inter college events by utilizing inventory of INR 3 Lakhs

• 

  PricewaterhouseCoopers - Service Delivery Center (PwC SDC)

  Jun 2021 - now

  • Drafted and developed TSA Schedule of Services with ~250TSAs; rTSAs across 17 functions for a leading IPS manufacturing firm• Developed TSA Costing Model, mapping assessment costs to arrive at stranded costs• Interacted with client to identify and map key closing requirements to respective functional separation work-plans ensuring on-time close• Used automation's in Smartsheet to created functional & executive reporting dashboards; TSA exit trackers & Funds Flow Summary by identifying key metrics enabling to monitor progress across work-streams• Managed AR/NEB remittance & TR settlement; TSA Billing & Management process by creating automation workflows to automate & make the entire process hassle-free• Involved in creating SMO Kickoff materials; SMO weekly decks & functional 1:1 round robin agendas for meetings with the functional leads & executive management Show less

  • Senior Associate

    Jun 2023 - now

  • Experienced Associate

    Jun 2021 - Jun 2023