Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

Kumar Akshit

San Jose,CA

Summary

Prudent Business Intelligence Analyst with 7 years providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Associate Manager

Marriott Tredence
10.2022 - Current
  • Interactive Loyalty Program Dashboard : Developed an interactive Power BI dashboard that provided real-time insights into loyalty program performance, resulting in a 30% reduction in time spent on manual reporting.
  • KPI Tracking and Member Engagement Analysis : Implemented dynamic KPI visualizations on the loyalty dashboard, leading to a 20% improvement in monitoring efficiency and a 25% increase in member engagement.
  • Segmented Performance Views : Created dashboard filters to view loyalty program performance by member segments, leading to targeted marketing efforts and achieving a 35% increase in redemption rates among high-value members.
  • Real-time Data Refresh : Configured automated data refresh every hour, ensuring the loyalty program dashboard was up-to-date, resulting in timely decision-making and improved program responsiveness.

Associate Manager

Retail Tredence
03.2022 - 10.2022
  • Created forecasting model for spoilage reduction by understanding current model and pain points from stakeholders and business
  • Reduction in spoilage for grab and go products for Casey's directly resulting in reduction of OPEX cost by 10%
  • Analyzed sales data by product category, identifying top-performing items that contributed to 40% of total revenue and supporting strategic decision-making for product assortment.
  • Conducted monthly sales trend analysis, identifying 12% increase in revenue during holiday season, enabling Client to optimize inventory and maximize profits.
  • Ranked "grab and go" products based on sales performance and profitability, enabling data-driven decisions for product promotions and assortment adjustments.
  • Near real time alerting for Fraudulent cases to minimize losses by 5%.

Senior Data Analyst

Gigamon
06.2019 - 03.2022
  • Lead Generation Analysis : Utilized data analytics to evaluate lead generation campaigns and identify the most effective channels for acquiring high-quality B2B leads, contributing to increased sales opportunities and revenue growth.
  • Sales Funnel Optimization : Analyzed the B2B sales funnel, identifying bottlenecks and opportunities for improvement, leading to optimized lead conversion rates and streamlined sales processes.
  • Customer Lifetime Value (CLV) Analysis : Calculated CLV for B2B customers, providing critical information for strategic decision-making, customer retention efforts, and prioritizing high-value accounts.
  • B2B Customer Segmentation : Conducted granular segmentation analysis to understand B2B customer behavior, needs, and pain points, enabling targeted marketing campaigns and more personalized messaging.
  • Identified High-Value Accounts : Utilized data-driven ABM insights to identify and prioritize high-value accounts, resulting in a 20% increase in revenue from key target customers.
  • Improved Email Campaign Performance by 20% : Conducted A/B testing on email campaigns, resulting in a 20% improvement in open rates and click-through rates, driving higher engagement and conversions.
  • End-to-End Funnel Tracking : Analyzed B2B marketing funnel stages from lead acquisition to customer conversion, identifying conversion rates and drop-off points to optimize the funnel flow.
  • Sales Funnel Funnel Visualization : Created visual representations of the sales funnel to track progress and conversions at each stage, facilitating quick identification of areas requiring immediate attention.

Data Analyst

Deloitte
09.2018 - 06.2019
  • Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required
  • Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges
  • Analyzing the root cause and doing the root cause analysis
  • Coming up with solutions to avoid failures in future
  • Utilize various tools to evaluate performance and implement remedies to improve performance, including tuning database parameters and SQL statements
  • Creating daily reports using excel and tableau
  • Gathering data from database and presenting it in a tabular or matrix form onthe job performance and reasons for failure.

Data Reporting Analyst

SAP, Wipro
12.2013 - 04.2016
  • Collected, cleansed, checked for data integrity and provided modeling and analyses of structured and unstructured data used for major business initiatives
  • Reduced time and labor by 50% and increased accuracy by 90% for daily dashboard report by automating it
  • Carefully analyzed all the batch jobs and their reasons for failure and came up with solutions to prevent it and automated all daily batch jobs hence saving 70% of time
  • Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables and VLOOKUP
  • Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information
  • Analyzed data on Tableau and Power BI to determine what interfaces and areas are in red zone and need more focus in order to reduce errors and optimize batch jobs reports and generated KPI's along with dashboards to present the results to higher management
  • Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging, and working with package config files.

Education

Master Of Science - Information Technology and Management

The University of Texas At Dallas
Richardson, TX
05.2018

Bachelor of Science - Computer Science

SRM University
Chennai ,TN
05.2013

Skills

  • Data Analysis
  • Data Visualization
  • SQL
  • Excel
  • Business Intelligence Tools : Tableau , Power BI
  • Data Cleaning and Preprocessing
  • Data Warehousing
  • Data Storytelling
  • Data Storytelling
  • Python
  • Problem-Solving Skills
  • Communication Skills
  • Project Management

Accomplishments

  • Received Professional Excellence Awards from WIPRO for quickly understanding the business needs and willingness to learn and implementing the same
  • Recognized by client for reducing the SLA breeches by 15%
  • ACADEMIC PROJECT
  • IMDB Movie Ratings Predictions: Achieved 20% additional gross return by predicting & identifying key factors of IMDB movies database
  • Devised Decision Trees, Neural Networks, Random Forests to classify & results optimal combination for highest return
  • Telecom Customer Behavior Modeling: Reduced customer attrition by 10% by identifying metrics leading to customer discontinuation and switching
  • Gradient boosting & Logistic models were developed to predict the potential customer segments likely to churn.

Certification

  • Tableau Desktop Certified, Tableau - May 2023

Timeline

Associate Manager

Marriott Tredence
10.2022 - Current

Associate Manager

Retail Tredence
03.2022 - 10.2022

Senior Data Analyst

Gigamon
06.2019 - 03.2022

Data Analyst

Deloitte
09.2018 - 06.2019

Data Reporting Analyst

SAP, Wipro
12.2013 - 04.2016

Master Of Science - Information Technology and Management

The University of Texas At Dallas

Bachelor of Science - Computer Science

SRM University

Similar Profiles

CREATE PROFILE
Kumar Akshit