Summary
Overview
Work History
Education
Skills
Certification
LANGUAGES KNOWN
Timeline
Generic
AKSHAT AGARWAL

AKSHAT AGARWAL

Bhiwadi,Rajasthan

Summary

Experienced with data manipulation, statistical analysis, and data visualization. Utilizes advanced analytical techniques to uncover trends and inform business strategies. Track record of employing critical thinking skills to solve complex problems and deliver meaningful insights.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Data Analyst

Citymall
09.2023 - Current
    • Developed a real-time CM1 tracker for Lifestyle Marketplace, delivering actionable insights to drive CM1 improvement from -6% to 10%.
    • Designed and implemented a real-time out-of-stock tracker for Lifestyle Marketplace, reducing GMV loss from 6% to 3% , optimizing inventory management, and enhancing revenue growth.
    • Developed a comprehensive business metrics and KPI dashboard using SQL and Google Sheets , enabling CXOs to monitor business health and drive data-informed strategic decisions effectively.
    • Automated product sales reporting using Python , generating and sending mailers that empowered teams to make informed, data-driven product-level decisions efficiently.
    • Spearheaded pricing strategy for 100,000+ products , optimizing margins and conversions while ensuring competitiveness against market competitors.
    • Developed a comprehensive pricing dashboard , enabling performance tracking across price ranges and reducing analysis time by 80% , driving faster, data-driven decision-making for the team.

Quant Intern

Index Management and Analytics, Morningstar, Inc.
07.2022 - 12.2022
    • Collaborated with the Associate Director of Indexes Morningstar to manage and update large datasets using SQL and Excel
    • Prepared a country reclassification report for29 Frontier market countries, as the firm is eying to enter those type of indexes
    • Automated Quality Assessment Checks for Bond Indexes using Python, enhanced the functionalities and also scalability

Summer Intern

Social And Environmental Analysis, iCare Foundation
05.2021 - 07.2021
    • Researched on identifying the social issues in Mexico and its economic impact, comparing the same with neighbours
    • Carried out environmental research to identify ecological problems in Mexico compared to neighbours, reported the same
    • Developed an awareness campaign for500+ primary school students in the target country, to enhance the living conditions

Education

B.E. (Hons.) - Chemical Engineering

Birla Institute of Technology And Science, Pilani
Hyderabad, India
03-2023

Skills

  • Python3, SQL Programming, Microsoft Excel, GitHub, Airflow, Google Sheets

Certification

  • Intermediate SQL - Data Camp: Learned about constructing advanced queries, sorting and grouping query data, Implemented techniques to work with text in databases, regular expressions.
  • Python Data Structures - Coursera: Discovered basics of procedural programming in python and essential libraries, Used of built-in data structures to perform increasingly complex data analysis.

LANGUAGES KNOWN

Hindi, English

Timeline

Data Analyst

Citymall
09.2023 - Current

Quant Intern

Index Management and Analytics, Morningstar, Inc.
07.2022 - 12.2022

Summer Intern

Social And Environmental Analysis, iCare Foundation
05.2021 - 07.2021

B.E. (Hons.) - Chemical Engineering

Birla Institute of Technology And Science, Pilani

Similar Profiles

CREATE PROFILE
AKSHAT AGARWAL