Abhishek Khanra

Sales Performance/Analytics (Mar-June 2024)

• Presented sales KPIs through BANS, Sparkline, and diverse chart types in dashboards.
• Created calculated fields, buttons, and parameters for generating metrics, and customizable filtering.
• Cleaned data using Power Query; performed advanced DAX calculations for key metrics, including variance.
• Developed interactive dashboards featuring dynamic plots, slicers, and customized tooltips to enhance user experience.
• Built seven model types using linear, decision tree, and ensemble techniques, based on feature selection methods.
• Estimated customer acquisition cost with the XGBoost Regressor model, achieving a 56 test MSE with an 8% variation.
• Conducted K-Prototype clustering to segment customers into two groups based on discount preferences.
• Recommended optimized promotion periods, considering store types, promotional strategies, media channels, and locations.

Sports Data (Oct-Dec 2023)

• Analyzed the FIFA 2018 dataset to plot graphs of skill moves based on players' preferred foot.
• Developed dashboards and storyboards to examine position-wise average wages and player values, recommending signings for high value-to-wage ratio positions.
• Interpreted the IPL Match Bidding dataset to identify relationships among entities.
• Calculated bids, wins, losses, and MVPs of bidders using SQL techniques, including joins and sub-queries.

Factors impacting voluntary attrition in IT (Nov '22–Apr '23)

• Designed a questionnaire with open- and closed-ended questions to assess factors influencing voluntary attrition.
• Applied Multinomial Logistic Regression via SPSS to predict potential voluntary attrition based on independent variables.
• Identified key independent variables impacting attrition rates, and proposed strategies for reduction.

Understanding Leadership and Organizational Culture (Apr-May 2018)

• Conducted the OCAI assessment at Hindustan Petroleum Corporation Limited to evaluate organizational culture and recommend improvements.

Tata Data Visualization: Empowering Business with Effective Insights, Job Simulation on Forage (March 2025)

• Created data visualizations (map, bar, line) to analyze trends of revenue generated and quantity sold in retail stores, and recommended locations for potential expansion for a TCS client.

BCG Data Science Job Simulation on Forage (March 2025).

• Conducted feature engineering, exploratory data analysis, and optimized the random forest model to predict customer churn, and suggested discounts for high-value customers to lower the rate for a BCG client.

• Served as the point of contact for internal and external stakeholders in the Lucknow Zone, overseeing 96 branches and 1,500 employees.
• Processed over 25 major cases related to fraud, POSH, non-vigilance, and suspension.
• Represented the bank in three conciliation proceedings at the Regional Labor Commissioner's Office.
• Reduced the case load from 40 to 25 through informed conversations regarding complaints and disciplinary merits.
• Handled employee relations matters, ensuring compliance with labor laws and organizational policies.
• Cultivated relationships with employee unions, facilitating effective communication during negotiations.

• Successfully managed three comprehensive off-campus training programs, achieving zero voluntary or involuntary departures among 150 new joiners.
• Oversaw logistics and coordination for instructor-led sessions, impacting over 500 employees from start to finish.
• Delivered over 50 onboarding training packages through the Learning Management System, addressing participant inquiries effectively.
• Generated regular induction and lateral training reports, maintaining up-to-date master training records.
• Ensured the accuracy of the master training database for seamless reporting and compliance with organizational standards.
• Streamlined communication among trainers, participants, and stakeholders, to enhance feedback collection processes.

• Acquired knowledge of leadership styles, organizational culture models, and components.
• Recommended Malcolm Baldrige criteria for performance excellence, along with PCMM, and OCAI for leadership and culture transformation.