Open to opportunities

Gaurav Prajapati

@gauravprajapati2

Message

Data Analyst with 5+ years of experience in data interpretation.

India

Message

What I'm looking for

I am looking for a role that offers opportunities for growth, collaboration, and innovation in data analytics.

As a seasoned Data Analyst with over 5 years of experience, I specialize in driving business solutions through meticulous data interpretation and analysis. My proficiency in statistical methods and analytics tools allows me to transform complex data into actionable insights, optimizing performance across various business operations. I have a proven track record of developing impactful dashboards and conducting in-depth analyses that support strategic decision-making.

In my current role as a Senior Data Analyst at Infosys Limited, I have successfully developed dashboards for Profit and Loss, assortment, pricing, and promotions for leading global companies. My expertise in tools like SQL, PowerBI, and Tableau has enabled me to reduce dashboard load times by 70% while providing valuable insights into marketing effectiveness and customer journeys. I am passionate about leveraging data to enhance operational efficiency and drive business growth.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Analyst

Current

Infosys Limited

Jan 2022 - Present (3 years 6 months)

As a Senior Data Analyst at Infosys, I developed dashboards for Profit and Loss, assortment, pricing, and promotions for major clients, including a global tobacco company and a leading toy and entertainment company. I utilized DAX for visualizations, conducted SQL analysis in Snowflake, and supported the rollout of new analytical reports.

Data Visualization DAX SQL Snowflake SSIS Power BI Data Analysis Data Management Marketing Analytics Dashboard Development

Marketing Scientist

Yum Brands

Oct 2021 - Jan 2022 (3 months)

In my role as a Marketing Scientist at Yum Brands, I evaluated marketing channel effectiveness and provided insights on ROI and sales. I assisted QSR clients with data-driven marketing strategies and budget allocation.

Marketing Analytics ROI Analysis Data Driven Channel Marketing

Senior Data Analyst

Aaj Enterprises

Mar 2019 - Oct 2021 (2 years 7 months)

At Aaj Enterprises, I improved workflow efficiency by 20% through data modeling and ERP integration for clients in warehousing and supply chain. I generated dashboards in Excel, Power BI, and Tableau, and implemented ABC analysis for inventory optimization.

Data Modeling ERP Integration Dashboard Development Power BI Tableau Excel

Education

Degrees, certifications, and relevant coursework

Gautam Buddha University

Integrated B Tech + MBA, Mechanical Engineering and Business Administration

2015 - 2019

Integrated B Tech in Mechanical Engineering and MBA in Operations & Marketing Management, focusing on the intersection of engineering principles and business strategies.