Rajat Malik

Data Analyst

Gurugram, Haryana, India6 yrs 6 mos experience

Most Likely To Switch

Key Highlights

Expert in data analytics with 4.5 years of experience.
Proven track record in banking credit risk and retail market analytics.
Skilled in Python, SQL, and data visualization tools.

Stackforce AI infers this person is a Data Analyst with expertise in Retail and Financial Technology.

Contact

Skills

Core Skills

Data AnalysisData VisualizationFinancial Technology

Other Skills

Apache SupersetData ModelingForecastingData-Driven InsightsData ManipulationTableauSQLBig Data AnalyticsPython (Programming Language)Reporting & AnalysisMicrosoft ExcelKey Performance IndicatorsSkilled Multi-taskerRelational DatabasesAnalytical Techniques

About

I got around 4.5 years of experience in the data analytics domain with industry expertise in banking credit risk and retail market analytics. My highest qualification is B.Tech. In banking credit risk analytics I take care of credit risk analysis about the customer journey getting business insights and reporting about account origination, account performance collections and recovery. I have been using the programming language SAS SQL Python towards accessing managing and manipulating data for designing business insights .For reporting and visualization I'm using excel tableau and Power BI. Before this I have been working the retail marketing analytics domain where my role and responsibility was towards at the customer transaction data, identify the customer analytics vs product analytics and making different strategies toward retaining customers engaging customers and enhancing customer user behavior for more profitability. To do this day-to-day activity using DBMS programming SAS SQL and for visualization Excel and tableau.

Experience

6 yrs 6 mos

Total Experience

1 yr 7 mos

Average Tenure

2 yrs 11 mos

Current Experience

Blinkit

Data Analyst

Jul 2023 – Present · 2 yrs 11 mos · Gurugram, Haryana, India · On-site

Improved picker training programs to optimize performance under strict
timelines and behavioral picking practices through identification of aisle
and racks reducing picker ramp-up time from 30 to 10 days
Implemented audit processes in Darkstore, enhancing item visibility by
understanding high-risk locations in each zone and reducing PNA and
improving inventory resolution from 10% to 2%
Evolved regression-based order picking time prediction model, optimiz-
ing picking manpower costs by 12% across the supply chain leveraged
diverse data trends for accurate time estimation, enhancing operational
eﬃciency
Established a visibility framework to track order cancellations and identify
root causes, enabling actionable insights at both dark store and city levels.
Successfully reduced the cancellation rate by addressing key pain points
and surge-related issues from 2% to 1.3%
Developed a performance scoring framework for customer service agents
based on multiple parameters, leading to improved operational eﬃciency
and targeted coaching
Established new processes and metrics to monitor pharma operations
by understanding workflows, identifying data anomalies, and improv-
ing tracking of doctor assignments to orders. Built a tracking system for
Airtel SIM and open-box deliveries by resolving data gaps across stake-
holders, improving customer experience and reducing complaints and
order-related requests by 40%
Analyzed chargeback order data to uncover insights that helped minimize
chargebacks, saving 50 lakhs in potential losses.
Created RCA dashboard for AHT and CSAT, uncovering performance gaps
across vendors and dispositions, and identifying high-impact complaint
types—resulting in a 5% improvement in CSAT score
Developed ETL solutions to generate diverse metrics for Tableau and Superset visualization tools.
Implemented improved methods for evaluating flaws in inventory sanitization processes during pickings and putaways.

Apache SupersetData ModelingForecastingData-Driven InsightsData ManipulationTableau+6

Affine

Data Analyst

Jul 2022 – May 2023 · 10 mos · Bengaluru · Hybrid

Determining the incremental impact on user engagement by running statistical significance tests (z-tests, t-tests, 2-tailed t-tests) on marketing experiment outcomes such as Monthly Active Users, Conversions and Usage.
Performing Exploratory Data Analysis to identify a correlation between the Usage and the seat size of assorted products, a strategic campaign built from the insights led to a 20% increase from trial to paid conversions.
Creating Delivery Health reports to measure the user engagement with the launched campaigns.
Conducted A/B testing and other experiments to improve campaign performance, resulting in a 20% increase in email open rates.
Developed and maintained dashboards and reports to track campaign performance and communicate insights to stakeholders, resulting in improved alignment and decision-making across teams.
Collaborated with cross-functional teams, including product, design, and content, to develop and execute campaigns that aligned with brand messaging and business goals.
Stayed up to date with industry trends, best practices, and emerging technologies in campaign marketing and analytics, resulting in more effective campaigns and improved ROI.
Communicated campaign performance and recommendations to senior leadership and other stakeholders in a clear and concise manner.
Monitored campaign performance and adjusted tactics to optimize performance, resulting in a 25% increase in click-through rates.
Analyzed campaign data to identify trends, insights, and opportunities for improvement, resulting in a 15% increase in conversion rates.

Microsoft ExcelKey Performance IndicatorsData VisualizationSkilled Multi-taskerRelational DatabasesAnalytical Techniques+35

Ntt data

Associate

Dec 2020 – Jun 2022 · 1 yr 6 mos · Noida

SAS (Software)Financial TechnologyAnalytical TechniquesInterpersonal SkillsForecastingMicrosoft Office+20

Tech mahindra

Associate

Sep 2019 – Dec 2020 · 1 yr 3 mos · Noida, Uttar Pradesh, India

Microsoft OfficeCommunicationSQL

Central public works department, india

Intern

Jun 2017 – Jul 2017 · 1 mo · Dehradun, Uttarakhand, India

Maintain contractor relationship with core focus on customer interaction & engineering guidance
Manage day to day operations and smooth functioning of the branch with as look through officer for authorization of engineering guidelines.
Entrusted with smooth operations by handling deputation responsibility allotted on various occasion to multiple branches in Dehradun region.

Ferrocon

Intern

Jun 2016 – Jul 2016 · 1 mo · Dehradun

Backend design support for manufacturing of RCC spun pipes, manholes cover & hand pump base ,concrete tiles.
Provided repair solutions for challenges faced by the manufacturing plant due to tooling errors during fabrication
Handled up gradation and migration of System Guidelines and Procedures to new file system to meet client requirements
Addressed clients during ODC visits, showcasing new structural design analysis projects and training projects for new recruits.