Harshit Agarwal

Experience

• 

  Tata Consultancy Services

  Jul 2017 - Jul 2019

  Assistant System Engineer

  • Worked in a team of 15 members for one of the Largest Banking clients to facilitate analytical and revenue needs• Implemented IBM Cognos TM1 to carry out collaborative planning, budgeting and forecasting solutions• Applied OLAP cubes and combined multiple data sources into a single data view to improve business performance• Built custom rules, calculation and dimensions to create cubes and views to enhance data loading processes• Created jobs on shell scripting and Control-M and scheduled the processes and jobs as per end user requirement Show less

• 

  Spears School of Business - Oklahoma State University

  Jan 2020 - May 2021

  • Worked under Professor Dr. Zackary Arens to study Survey data to conduct marketing research and generate KPIs.• Provided weekly updates to Program Director, Dr. Gautam Chakraborty to improve analysis and productivity.• Worked under Professor Miriam McGaugh to automate survey data for health department and research.• Identify problems, compare data from sources to draw conclusions, and make timely sound decision. Working as a Graduate Research Assistant for Love's Travel Stop on the behalf of Oklahoma State University.

  • Graduate Research Assistant

    Jan 2021 - May 2021

  • Graduate Research And Teaching Assistant

    Jan 2020 - May 2021
• 

  Love's Travel Stops

  Jun 2020 - Jan 2021

  • Analyzed 48 months non-subscription-based membership data on Snowflake DB and MS SQL Server • Created Customer Lifetime Value Model to build customer segmentation and membership profiling• Presented Executive Summary report and suggested future recommendations to the Senior Leadership.• Aimed at improving the quality and enhancing the features for all areas of business, including customer experience. • Forecasted models (ARIMA, TBATS) in R to predict a driver’s weekly transactions and built interactive dashboards

  • Graduate Research Assistant

    Jan 2020 - Jan 2021

  • Loyalty Analyst Intern

    Jun 2020 - Aug 2020
• 

  Power Costs, Inc. (PCI)

  Jun 2021 - Feb 2022

  Business Analyst
• 

  Tredence Inc.

  Feb 2022 - now

  • Associate Manager

    Feb 2023 - now

  • Analytics Consultant

    Feb 2022 - Feb 2023