Harshit Makkar

Associate Consultant

Delhi, India9 yrs 3 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Over 7 years of data science experience
Expert in machine learning and analytics
Proven track record in driving business insights

Stackforce AI infers this person is a Data Science expert with a strong focus on Fintech and Business Analytics.

Contact

Skills

Core Skills

Data ScienceMachine LearningBusiness AnalyticsData Analytics

Other Skills

A/B TestingClient RelationsCommercial AnalyticsConsultingCustomer SegmentationCustomer Segmentation StrategyData AnalysisData ManagementData VisualizationData WarehousingGitMicrosoft ExcelMicrosoft OfficePower BIProblem Solving

About

Data Scientist with more than seven years of experience digging business insights from structured and unstructured data, helping organizations discover crucial metrics and take sound data backed decisions. Post graduation in ML & AI and independent coursework in the field of data science has helped me hone my skills dealing with - • SQL - MySql, Postgresql • Python - Pandas, Numpy, Sklearn, Vectorized Computations, List Comprehension • Data Visualisation - PowerBI, Tableau, Google Studio • Machine Learning - Regression and Classification Algorithms, Boosting and Bagging Algorithms, Dimensionality Reduction, Gradient Descent, Unsupervised Clustering - Practical as well as Theoretical Understanding of the algorithms and the concepts. • Natural Language Processing - Lexical, Syntactic and Semantic Processing. Building a chatbot with Rasa. • Deep Learning - Neural Networks, Convolution Neural Networks, Recurrent Neural Networks.

Experience

Mastercard data & services

2 roles

Associate Managing Consultant

Promoted

Mar 2024 – Present · 2 yrs · Gurugram, Haryana, India

Commercial Analytics Lead | Embedded Analytics Project for a Leading UK Retailer
Led the Commercial Analytics workstream in a 6-month embedded project for a top UK retailer to identify opportunities for increasing credit penetration of their Financial Services products.
Supervised a team of three analysts to deliver key outcomes:
Analysed the ~20Mn customer base across various spend and demographic attributes to identify areas of opportunities and strengths.
Modelled different scenarios to optimise the Loyalty offerings - Identified an opportunity to save £2M annually.
Enhanced payment analytics by evaluating new payment methods like Clearpay and Interest Free Loans.
Developed live Power BI dashboards for automated reporting and real-time insights.
Improved the in-house analytics capability, enabling data-driven decision-making and strengthening the retailer’s analytics infrastructure.
This project highlighted my ability to lead teams, drive strategic initiatives, and deliver impactful results in a collaborative environment.

Commercial AnalyticsPower BIData AnalysisTeam ManagementData ScienceMachine Learning

Consultant - Data and Services

Aug 2022 – Feb 2024 · 1 yr 6 mos · Gurugram, Haryana, India

Worked on multiple Data Analytics Consulting Projects primarily focusing around Modelling (Travel and Retail based Spend Uplift Propensity Models), Rule based Segmentations, Issuer and Merchant Spend Metrics Benchmarking, Marketing Campaign Performance Analytics, Credit Risk.
Recent projects include:
∙ Analyzing the Credit Risk Profile of the Consumer and Small Business Portfolio of one of the largest bank of Canada.
∙ Conducting sophisticated Customer Segmentation for one of the largest real estate firms in Singapore, to uncover trade mix gaps, enhance differentiation among competitor retail malls, and drive increased customer footfall and spend.
∙ Conducting a comprehensive Customer Segmentation analysis for a leading Australian independent gas station retailer, evaluating spending patterns across their New, Existing, and Lapsed customer segments to take informed strategic decisions and address the declining market share.
∙ Developing Advanced Propensity Models and conducting Marketing Campaign Performance Analytics for one of the largest Bank in Vietnam.
∙ Market Landscaping for a Loyalty Program in Serbia. Analysing spend metrics of leading Serbian Issuers across the different spending attributes.
Achievements:
∙ Developed a Propensity Model for one of the largest bank of Vietnam. The model helped save ~40% in Marketing Spend. Impressed with the insightful deliverables, up-sold a 2 year long extension of the project.

Data AnalyticsCustomer SegmentationMachine LearningPythonSQLTableau+1

Paytm

2 roles

Junior Manager

May 2022 – Aug 2022 · 3 mos

∙ PG Cost Prediction - Understood the various financial variables which have an impact on Payment Gateway cost such as Mode of Payment, Merchant type - Small/Big, EMI Type - Bank/Brand/Full Swipe, Merchant Category etc. Devised a model which could predict the PG cost with an accuracy% of 98.6%
∙ Validating the declining battery efficiency of Soundbox - Derived a KPI which could measure the battery efficiency of a Soundbox. Validated that indeed one type of Soundbox broadcasted substantially less transactions as compared to the other.

Data AnalysisBusiness AnalyticsProblem SolvingData Science

Team Lead - Business Review

Aug 2021 – May 2022 · 9 mos

∙ Monitoring the key financial indicators of the Paytm's Offline Payments Business.
∙ Doing Root Cause Analysis in cases of aberrations and suggesting ways to resolve those.
∙ Automating Reports and Dashboards to deliver key insights to CXOs and VPs on a daily, weekly and monthly basis.
Achievements:
∙ Introduced Python to analyze Rent Collection Data which earlier could not be analyzed using the vanilla tools like SQL and Excel due to sheer size of the dataset - Unearthed rent defaulting merchants and segmented them based on their "days past due" and relevant payment metrics.

Data AnalyticsBusiness AnalyticsReporting & Analysis

Denave

Senior Data Analyst

Aug 2020 – Aug 2021 · 1 yr · India

I worked as a Senior Data Analyst on Google Play Card Retail Analytics project in close liaison with the Google team in California. I was responsible for Cleaning, Analyzing and Visualizing key insights from the Google Play Card’s Merchandising Data.
Achievements:
∙ Automated the data processing pipeline using Python leading to a 50% reduction in processing time and highly improved data quality.

Data VisualizationData ManagementPythonConsultingData AnalyticsData Science

Stanza living

Data Analyst

Sep 2019 – Aug 2020 · 11 mos · Greater Delhi Area

I worked as the sole Data Analyst for the Sales & Sales Ops. department at Stanza Living. I was responsible for making automated live reports and dashboards for all the stakeholders - teams on the ground, Managers, VPs and CXOs. I utilized Google App Scripts, Google APIs, Python and Tableau to make automated and notification driven reports and dashboards.
Achievements:
Identified and resolved leakage of revenue from cash collections worth ~ 90 Lakhs.
Worked with multiple departments to streamline the Property Acquisition Process. The turnaround time improved by 50%
Spearheaded the Customer Retention Module single handedly. Achieved 80% customer retention.

Data AnalyticsBusiness AnalyticsPythonTableau

Career break

Personal goal pursuit

May 2017 – Aug 2019 · 2 yrs 3 mos · Delhi, India

Prepared for UPSC Civil Services Exam.

Acadview

2 roles

Project Manager

Promoted

Oct 2016 – Apr 2017 · 6 mos · New Delhi Area, India

Led an Ed-Tech pilot project end to end successfully. Dealt with both technical and managerial requirements. The role involved -
Complete Scheduling and Requirement Analysis. Budgeting and Cost Control.
Managed ~10 instructors and ~250 students simultaneously both online and on site.
Cross - Coordinated Sales team, Tech team and the instructors.
Strategizing team roles and responsibilities - both technical and sales.
Achievements:
Course completion rate more than 90%
Awarded a bonus for leading an Ed-tech pilot project end to end successfully.

Software Engineer

Jul 2016 – Sep 2016 · 2 mos · New Delhi Area, India

Wrote Scripts in Python to digitize the College Marksheets. Set up Acadview’s Result Management System in the School of Planning and Architecture, Delhi.