Ratnesh Kumar Email & Phone Number

Gurugram, Hr, In

Gurugram, Haryana, India

At Shiprocket, I am responsible for building and maintaining scalable data infrastructure to support the company's analytics and decision-making processes. My role involves:- Designing and managing Batch/real-time data pipelines using Kafka to stream data and integrate with Debezium for capturing changes in database logs.- Implementing ETL processes on AWS EMR, processing data from Kafka and transforming it into Iceberg table formats, optimized with Parquet files.- Utilizing Trino for distributed querying and integrating it with Glue Catalog and Hive Metastore to ensure seamless access to structured and unstructured data.- Collaborating with teams to ensure efficient data ingestion and transformation for both internal analytics tools like Metabase and external platforms such as Snowflake, using AWS DMS for data migrations.- Driving performance improvements in querying and data storage while ensuring data consistency and reliability across multiple environments.Through my work, I ensure that Shiprocket’s data platform is optimized for performance, scalability, and analytics-driven insights.

Gurugram, Haryana, India

- Designed and managed data pipelines using Kafka for real-time streaming and ETL processes.- Developed data models to support analytics and decision-making, ensuring efficient data retrieval and accuracy.- Leveraged Trino to query data from multiple sources and optimize the performance of large datasets.- Utilized Kubernetes for deploying and managing containerized applications, improving the scalability and flexibility of the infrastructure.- Worked with Metabase for visualizing data, providing actionable insights to various stakeholders.- Integrated and maintained MongoDB for efficient NoSQL data storage and querying, handling high volumes of unstructured data.- Automated workflows using Airflow, ensuring data pipelines run smoothly with minimal downtime.- Applied Python extensively for data processing tasks, building custom scripts for transforming and cleaning large datasets.- Collaborated with teams to optimize SQL queries and enhance data retrieval times from relational databases.

Gurugram, Haryana, India

- Led the development of **RTO Prediction** models, enhancing the company’s ability to forecast Return to Origin (RTO) rates and minimize shipping costs by identifying potential failed deliveries before they occur.- Applied **Address Intelligence** techniques to improve delivery accuracy and optimize route planning, significantly reducing delivery errors and increasing first-attempt success rates.- Utilized machine learning algorithms to enhance the prediction accuracy of both RTO and Address Intelligence models, contributing to better decision-making in logistics and customer management.- Conducted in-depth **data profiling** and **user profiling**, leveraging data science techniques to understand user behaviors and create personalized engagement strategies.- Collaborated with cross-functional teams to incorporate **predictive modeling** insights into the product, enhancing operational efficiency and user experience.- Extensively utilized **Python** for data wrangling, model development, and automation, ensuring smooth processing and integration of data science initiatives into the product.- Delivered actionable insights through statistical analysis and machine learning, improving product performance and supporting business growth.

Gurugram, Haryana, India

- Managed reporting and dashboarding for sales, operations, and finance.- Conducted pincode-based cleaning and improvement through data modeling.- Handled order zone assignments based on geolocation, including city-to-city mapping.- Monitored client churn and growth.- Prepared Management Information System (MIS) reports and dashboards.

Gurugram, Haryana, India

- Designed dashboards and reports to monitor KPIs across operations, sales, and customer success, and conducted trend analysis to support strategic decisions.- Improved operational performance by optimizing delivery TAT, order fulfillment, and cost reduction.- Analyzed customer behavior to prevent fraud and increase prepaid order conversions.- Developed performance metrics for operations, category management, and customer service teams.- Designed incentive schemes to enhance seller performance and retention.- Supported product development and user experience enhancement through data-driven insights and app customizations.- Managed inventory optimization, predictive modeling for delivery time estimation, and tracked campaigns such as mystery buying and digital marketing efforts.- Enhanced data readability and accessibility to facilitate better decision-making.

Gurugram, Haryana, India

- Automated manual reporting processes, enhancing efficiency and accuracy.- Improved maintenance visibility and health through comprehensive data analysis.- Created and published maintenance-related reports for management.- Conducted data mining and analysis to drive insights and decision-making.- Analyzed asset breakdowns and optimized end-to-end cold chain operations.- Studied pilot driving behavior to enhance safety and performance.- Drafted Business Requirement Documents (BRDs) and logic for product development.- Increased uptime of IoT devices and prepared performance reports and dashboards for senior management.

Master Of Technology - Mtech, Process Control

Gate-2016

Bachelor Of Technology - Btech