Sudhir Dharmsika

Sudhir dharmsika

bookmark on deepenrich
location of Sudhir DharmsikaMumbai, Maharashtra, India
Phone number of Sudhir Dharmsika+91 xxxx xxxxx
Followers of Sudhir Dharmsika1000 followers
  • Timeline

    Oct 2013 - May 2015

    Assistant System Engineer

    Tata Consultancy Services
    May 2016 - Jul 2016

    Research Intern

    State Bank of India
    Apr 2017 - Jul 2019

    Senior Research Analyst

    Sutherland
    Jul 2019 - May 2020

    Project Analyst

    AthenasOwl
    Jun 2020 - Feb 2022

    Data Analyst

    Johnson & Johnson
    Current Company
    Feb 2022 - now

    Assistant Manager - Analytics

    Colgate-Palmolive
  • About me

    Assistant Manager| Data and Tech Lead at Colgate Palmolive |Ex J&J

  • Education

    • K j somaiya institute of management

      2015 - 2017
      Master of business administration (m.b.a.) marketing
  • Experience

    • Tata consultancy services

      Oct 2013 - May 2015
      Assistant system engineer

      Single point of contact between the Client and the organisation for the Sales Monitoring Team.Involved in working on Electronic Data Interchange ,Server Administration and Cloning.Beside this also worked on Data Analysis ,OTC Balancing ,Scheduling Jobs,Maintaining and Inspecting Partition Data Set, Freight Balancing

    • State bank of india

      May 2016 - Jul 2016
      Research intern

      Conducted a Market Research Project to " Find the Strategies to attract Corporate Clients to Corporate Salary Package".I was involved in Pre-Sales activities,Pitching high end Clients, In my internship also acquainted with elementary idea about Interest Subsidy Management,Cross Selling,Online Customer Acquisition

    • Sutherland

      Apr 2017 - Jul 2019
      Senior research analyst

      Managing end-to-end projects right from the kick-off of study, scoping, de-coding client needs, developing study plan, fieldwork, regular monitoring of progress and sharing updates, troubleshooting any issues, delivering final results- Identifying the best sources of data, extracting information from the sources, including paid databases, publications from analyst reports and from company reports and websites- Conducting primary research with players in the market for the industry under study. During my role in Sutherland, I have conducted on an average of 8 to 10 interviews with C-level executives and key personnel for every project- Conducting in-depth market studies, feasibility studies, industry analysis, SWOT analysis formulating go-to market strategies, formulating re-structuring processes, opportunity assessment and financial studies- Identification and compilation of relevant market-data, summarisation of trends from analysis of news articles, deal sourcing activities (building target universe for a given industry and financial parameters)- Questionnaire Design, Expert Interviews (CxO), Survey Analysis- Supporting a client’s business development with preparation of meeting briefs, Bios, pitch suggestions, and other ad- hoc requests- Assisting a client in scheduling one to one meeting for business development along with maintaining MIS reports for various Business Development (BD) managers and giving suggestions for improvement on a timely basis- Contributing to the analytical approach, mentoring others, and helping drive innovation and internal improvements- Skills: Analytical approach, Data Management, Reporting, Data modeling, Time series & Forecasting etc- Tool Expertise: SQL, Tableau, PowerBI, GSuite, GCP,MS-Excel 2010, MS-PowerPoint, Ms-Access, JIRA Show less

    • Athenasowl

      Jul 2019 - May 2020
      Project analyst

      - Working for the leading TV broadcasting studio in India- Helping them analyse their audience by doing segmentation of their viewers' universe. Also worked on predicting the TV rating points expected to be garnered by the channel across shows & telecast slots- Analysed data to generate insights for fictional and non-fictional shows based on various parameters- Created various dashboards using Tableau for large data sets to have better visualisation- Coordinated with internal product team, curation team, sales team etc. to deliver projects- End-to-end project planning and execution which includes allocating resources for the projects- Kept track of entire project cost (cloud cost, data storage cost, resources cost) and optimized the operational cost Show less

    • Johnson & johnson

      Jun 2020 - Feb 2022
      Data analyst

      - Project Management pertaining to Supply Chain, Inventory Management, Portfolio Optimization, Demand Planning and Cost Reduction- Working and managing data transformation, process automations, creating and deploying various machine learning models - Linear Regression, Logistic Regression, Gradient Boost, evaluating the models, interpreting results and insight generation with the help of Tableau & Power BI- Supporting stabled and ad hoc reporting, building simulation models, automated reporting process using Alteryx and Python- Collaborating with internal teams for resolving and tracking issues relating to the project’s delivery Show less

    • Colgate-palmolive

      Feb 2022 - now
      Assistant manager - analytics

      ➢ Evaluated business opportunities and challenges by synthesizing insights from various data sources including Nielsen, Point of sales(POS) data, Kantar Household Panel Data, Ecommerce Vendor data – Profitero, Google Analytics, Similar Web.➢ Integrated diverse datasets from CMI and Marketing to develop a comprehensive understanding of market dynamics and consumer behavior, enabling strategic decision-making➢ Led the Europe Analytics team on critical business inquiries encompassing granular deep-dives, price elasticity, trade margin, promotion analysis, assortment analysis, new product development, innovation etc.➢ Led and worked with team proficient in utilizing SQL, Python, R, statistical, and visualization tools (Tableau, Power BI , Looker,Sigma, DOMO) to extract, manipulate, analyze, interpret, and visualize data trends and patterns➢ Mentored team in their professional growth, providing guidance and support to align with their individual growth timelines➢ Applied advanced technical skills to efficiently manage and analyze vast datasets, ensuring accuracy and reliability in insights generation with continuous learning➢ Maintained accountability for the quality and timeliness of deliverables, consistently exceeding expectations and contributing to the achievement of organizational goals➢ Conducted comprehensive analysis of the category, market dynamics, competitive landscape, and emerging trends to uncover strategic opportunities for category and brand growth➢ Worked on other project which required Clustering, application of web scrapping, text mining, sentimental analysis, trend and time series forecasting Show less

  • Licenses & Certifications