Fall'23 Internship Experience at Cap Hill Brands

I am excited to share my experience as a Data and Product Analyst intern at Cap Hill Brands . During my 16-week internship, I was fortunate enough to engage with diverse teams within the organization, work with leaders, and delve deep into the fascinating ecommerce industry.

Within my internship at Cap Hill Brands , I was involved in three main initiatives. The first revolved around conducting profitability analysis, where I crafted contribution margin reports. This entailed diving into Amazon's data reports, collaborating closely with finance teams, and understanding various data sources. The second initiative centered on addressing excess inventory by generating daily reports utilizing competitor pricing and impression share data. These reports supported stakeholders in making informed decisions, contributing to strategic planning and optimization.

A significant takeaway from these projects was gaining insights into financial as well as pricing aspect of ecommerce domain. I actively participated in the meetings to understand and dive deeper into the use case. Also, I gained valuable hands-on experience working on different databases such as Snowflake, PostgreSQL, Metabase and Clickhouse. I was able to leverage python and excel to analyze and automate the report generation. Moreover, I am thankful for the constant support and guidance in project from Nand Kishore Rajput .

Lastly, as a product analyst I collaborated with product designer and clients to get feedback on the product features, getting new ideas and enhancing the product for better user experience. This experience was enriching for me as someone who is intriguing to pursue product management in future. Special mention to Shubhankar Sawant and Michelle Ferrall Gratton for guiding me.

The most valuable experience that I got through this internship was the opportunity to work again in the ecommerce domain and learning new aspects of it. Also, working on the product enhancement and meeting with the clients was an enriching experience. I am grateful to Vineet Gorhe for giving me this opportunity to be part of the team. Overall, this internship experience has provided me with lot of learning opportunities, and I am excited to be able to contribute more in the upcoming semester.

Lastly, I would like to express my gratitude to our program director Bill Hefley, Ph.D., COP, CMBE , Program Manager Fatima Raad at The University of Texas at Dallas, and Sarang Fegde for their unwavering support in shaping my career trajectory.

#UTDMSBA #UTD #JSOM #hirejsom #CapHillBrands #Amazonads #Demandhelm

?