Pratap Sarkhel

Pratap sarkhel

bookmark on deepenrich
location of Pratap SarkhelBengaluru, Karnataka, India
Followers of Pratap Sarkhel746 followers
  • Timeline

  • About me

    Supply Chain Analyst ll Alteryx ll SQL ll BI Analyst ll Driving Performance ll Streamlining Operations

  • Education

    • Techno india university

      2016 - 2019
      Bachelor of business administration - bba marketing 7.00
    • Indus business academy - iba, bangalore

      2019 - 2021
      Pgdm business analytics and marketing 8.12

      Activities and Societies: Member of placement committee Core member of communication club

  • Experience

    • Happiest minds technologies

      Jul 2020 - Mar 2021
      Market research intern

      • Utilized diverse research techniques and online or published data collection tools to amass key information or statistics, supporting business objectives.• Completed research, compiled data, and assisted in timely reporting.• Studied demographic data to determine optimal targets, competitor offerings, and tactics for persuasion.

    • Uipropitome tech - website development

      Aug 2021 - May 2022
      Data analyst

      • Developed data-informed solutions that helped clients improve their operational efficiency, optimize their marketing strategies, and better understand their customers.• Conducted thorough data analysis using statistical and data visualization techniques, such as scatter plots, histograms, and heat maps, to identify trends, patterns, and outliers in large data sets.• Collaborated with cross-functional teams to assess the potential risks and impacts of the breach on customers and the organization.• Built and maintained dashboards to track key performance indicators (KPIs) related to customer acquisition, retention, and revenue.Technologies Used:-SQL-Tableau-Excel Show less

    • Loadshare networks

      Jun 2022 - Aug 2024

      -Act as the main PoC for MIS reporting for two Major DB Tables ---Data gathering from multiple data sources, work on data cleansing, interpretation and finally visualization of the data for mid and senior management. ---Transform complex data into actionable and clear insights, identification of trends and generating business insights.---Produce monthly reports summarizing performance trends for CxO, validating and analyzing weekly, fortnightly, and monthly payment reports and work on identified enhancements.-Stakeholder Management for key business unit ---Act as a liaison between client and operations team in resolving client queries regarding shipment logistic pipeline.---End to End ownership and management of key DB Tables (Same-Day Delivery and Next-Day Delivery), identify gaps in the data flow and relations. Implement enhancement patches as and when required. -Manage Application Front-End based on managed databases ---Provide support to business users , business analysis on queries on the front-end dashboardTechnologies used:-SQL-ZOHO Analytics-Redash-Metabase-Excel Show less -Act as the main PoC for MIS reporting for two Major DB Tables ---Data gathering from multiple data sources, work on data cleansing, interpretation and finally visualization of the data for mid and senior management. ---Transform complex data into actionable and clear insights, identification of trends and generating business insights.---Produce monthly reports summarizing performance trends for CxO, validating and analyzing weekly, fortnightly, and monthly payment reports and work on identified enhancements.-Stakeholder Management for key business unit ---Act as a liaison between client and operations team in resolving client queries regarding shipment logistic pipeline.---End to End ownership and management of key DB Tables (Same-Day Delivery and Next-Day Delivery), identify gaps in the data flow and relations. Implement enhancement patches as and when required. -Manage Application Front-End based on managed databases ---Provide support to business users , business analysis on queries on the front-end dashboardTechnologies used:-SQL-ZOHO Analytics-Redash-Metabase-Excel Show less

      • Deputy Manager - Control Tower / Data Analyst

        Jan 2024 - Aug 2024
      • Assistant Manager - Control Tower / MIS Analyst / Data Analyst

        Jun 2022 - Dec 2023
    • Shadowfax

      Aug 2024 - now
      Assistant manager - control tower
  • Licenses & Certifications

    • Process data from dirty to clean

      Coursera
      May 2022
      View certificate certificate
    • Foundations: data, data, everywhere

      Coursera
      May 2022
      View certificate certificate
    • Analyze data to answer questions

      Coursera
      May 2022
      View certificate certificate
    • Prepare data for exploration

      Coursera
      May 2022
      View certificate certificate
    • Nivea blue certification

      Nivea india
      Nov 2020
    • Ask questions to make data-driven decisions

      Coursera
      May 2022
      View certificate certificate
    • Lean six sigma green belt certification

      Kpmg india
      Mar 2021
    • Share data through the art of visualization

      Coursera
      May 2022
      View certificate certificate
    • Capstone business simulation program

      Capsim management simulations, inc.
      Dec 2020
    • Data analysis with r programming

      Coursera
      May 2022
      View certificate certificate
  • Volunteer Experience

    • Volunteer

      Issued by NHRD Bangalore Chapter
      NHRD Bangalore ChapterAssociated with Pratap Sarkhel