Talk to sales Try for Free
Sumit Pramanik

Sumit Pramanik

System Engineer

Followers of Sumit Pramanik1000 followers
location of Sumit PramanikMumbai, Maharashtra, India

Connect with Sumit Pramanik to Send Message

Connect

Connect with Sumit Pramanik to Send Message

Connect

  • Timeline

  • About me

    Assistant Vice President and Sector Head (Structured Finance Ratings) at ICRA (A Moody's investors service company)

  • Education

    • DAV Model

      -
      Higher Secondary Education Science

    • Asansol Engineering College

      2007 - 2011
      Bachelor of Technology (B.Tech.) Applied Electronics and Instrumentation

    • IIM Indore

      2012 - 2014
      PGP (MBA) General Management

      Activities and Societies: Creativity and Designing Team, Adapt- The advertisement event of IIM Indore

  • Experience

    • Tata Consultancy Services

      Dec 2011 - Jun 2012
      System Engineer

      Worked on Informatica and Cognos to o Perform data extraction, transformation and loading o Develop metadata modelso Create dashboards related to sales and supply chain management for one of the largest healthcare players of the world

    • Tata Consultancy Services

      Jun 2014 - Aug 2018
      Business Consultant, Global Consulting Practices- Business Analytics

      • Offshore lead- Financial modelling for a Telecom giant in Europe- Developed a Total Cost of Ownership (TCO) model for cloud infrastructure in eight worldwide locations- Designed a cloud infrastructure model to allow the user compare cost flows for fully owned, fully leased, and hybrid business models• Project lead- Financial modelling for a Telecom giant in South Africa– Onsite engagement, Johannesburg, South Africa- Developed strategic financial models calculating breakeven, NPV, net margins, WACC and DCF in MS Excel- Delivered Activity Based Costing (ABC) model for overhead expenditures- Created forecasting investment model to enable simulation of various business scenarios- Developed end to end financial model for Fibre To The Business/ Home business, reporting to the CFO- Carried out cost reconciliation for the business from its inception till date- Led a team of three business analysts and two business consultants- Served as the single point of contact for the client- Worked on cost modelling tool SAS OROS• Customer analytics, market basket and RFM analysis for a Retail customer- Market basket analysis using SPSS tool for one of the largest multi-brand retail chains of the USA- Developed RFM Analysis model facilitating customer segmentation using business analytics tool SPSS• Cost Modelling and Analytics- Developed service-based cost model for one of the largest telecom players of the world• Customer analytics for a large bank in the Middle East- Involved in modelling of campaign, channel and customer segmentation using SPSS tool• Product Manager- Healthcare Products and Platforms (Hospital Management ERP System)- Interacted with three clients to understand their business processes and requirements- Involved in data modelling and dimensional analysis for conceptualizing an analytical product platform for Healthcare Show less

    • India Ratings & Research - A Fitch Group Company

      Aug 2018 - Sept 2020
      Senior Financial Analyst

    • Acuité Ratings & Research Limited

      Sept 2020 - Jun 2023
      Associate Vice President

    • ICRA

      Jun 2023 - now
      Assistant Vice President

  • Licenses & Certifications

    • Cognos 10 metadata model developer

      IBM
      Jan 2012

    • Business Analytics and Decision Making

      Excelsior Education
      Aug 2013

    • Consultant Development Program

      Tata Consultancy Services
      Aug 2014

  • Honors & Awards

    • Awarded to Sumit Pramanik
      Business Plan published in Technosight, the Technology Management magazine of SJSOM IIT Bombay SJSOM, IIT Mumbai 2013 Developed a business plan for the insurance industry of India.
    • Awarded to Sumit Pramanik
      National Semi- Finalist in Pepsi Co Become Indra’s Adviser Contest. Was among 2 teams selected from campus Pepsi Co 2013 Developed business plan to increase Pepsi Co's market share and improve its brand image in the Out of Home Food sector
    • Awarded to Sumit Pramanik
      Winner, Philips Blueprint- North Zone. Was selected among top 8 teams for the National final Philips 2013 Developed a business plan to transform home lighting solutions.
    • Awarded to Sumit Pramanik
      Won First prize in Envision 2013, the IT Article Writing Competition of XIMB XIMB 2013 Wrote an article on Business Intelligence- The next level of business empowerment.
    • Awarded to Sumit Pramanik
      2 times winner of Rangoli competition organized by Culcom, the cultural committee of IIM Indore IIM Indore 2012
    • Awarded to Sumit Pramanik
      Awarded First prize in Eluminate, the Business Plan competition of NMIMS Mumbai NMIMS Mumbai 2012 Developed a business plan for the insurance industry of India.
    • Awarded to Sumit Pramanik
      Received Achievement Certificate from TCS for being among top three performers of the batch TCS 2012
    • Awarded to Sumit Pramanik
      Won 2nd prize in Veritas, the media & journalism competition organized by IIM Indore’s Media & PR Committee IIM Indore 2012 1st Round- Impromptu Public Speaking2nd Round- General Knowledge3rd Round- Group Discussion
    • Awarded to Sumit Pramanik
      Awarded 2nd prize in inter- school essay writing competition organized by Durgapur Steel Plant Durgapur Steel Plant 2006

  • Volunteer Experience

    • Tree plantation

      Issued by Indian Institute of Management, Indore
      Indian Institute of Management, IndoreAssociated with Sumit Pramanik