Brijesh Kumar

Experience

• 

  Delhi Technological University (Formerly DCE)

  Jun 2021 - Jul 2021

  Summer Research Intern
• 

  KPMG India

  Nov 2021 - Dec 2021

  Data Analytics Consulting Virtual Internship

  completed practical task modules in:Data Quality AssessmentData InsightsData Insights and Presentation

• 

  Spark Foundation

  Apr 2022 - May 2022

  Data Science & Business Analyst
• 

  Holisol Logistics

  Apr 2022 - now

  Business Analyst

  1. Produced Monthly Basis FC_Ops_PnL, OSCM_PnL, Quant_Data (B2B/B2C shipment per Unit), Its Variance and Summary Reports. 2. Design & Created Daily_FC_Ops_PnL Format for 33 Warehouse and automated their compilation on daily basis with help of Python Scripts & Build Dashboard in Power BI. 3. Analyzed Courier Big data (B2B/B2C) on monthly basis with help of Python and Its visualization in Power BI. 4. Design & Created Daily Dopex & Dtalk Report Format and Automated their compilation and Sended to the respective LOB Head by using Python script (Library used pandas, openpyxl, xlwings, Smtplib). 5. Analyzed the Pickup & shipping data to find the optimum No. Of Hub for minimizing the transportation cost and time. 6. Experienced in MIS – Working Knowledge of advance excel (Xlookup, Vlookup, Countifs, Sumifs, Sumproduct, Indexmatch, Conditional Formatting, Filter, Macro, Power Query,Google sheet, MIS Reports, PnL Reports).Top 5 key skills:Python, SQL, Power Bi, Tableau, Excel, Machine Learning, EDA, Data Analysis Show less