Summary
Overview
Work History
Education
Skills
Languages
Websites
Affiliations
Timeline
Generic

Rahul Prasad

Nalanda

Summary

Results-oriented Senior Analyst, Data Engineering with expertise of 3+years in data engineering and supply chain planning. Proven track record of leveraging data-driven insights to optimize supply chain operations and drive business success. Adept at designing and implementing robust data pipelines, developing analytical models, and collaborating with cross-functional teams to align data strategies with organizational goals. Strong problem-solving skills and a commitment to continuous learning, enabling the delivery of innovative solutions in a dynamic and fast-paced environment.

Overview

3
3
years of professional experience

Work History

Senior Analyst, Data Engineering

Dell Technology
Bengaluru
07.2022 - Current
  • Transform supply chain operations by leveraging data-driven insights to optimize planning and forecasting processes.
  • Unravel complex supply chain challenges and pave the way for efficient and agile decision-making.
  • Possess a deep understanding of supply chain systems, processes, and data sources, enabling to design and implement robust data pipelines that capture, cleanse, and transform relevant data sets.
  • Responsibility for the availability and accuracy of data required for effective supply chain planning.
  • Contribute to developing and maintaining data models, algorithms, and analytical tools that drive forecasting, demand planning, inventory optimization, and logistics management.
  • Extracting meaningful insights from vast and complex data sets empowers stakeholders to make informed decisions and mitigate risks across the supply chain.
  • Mentored and trained junior analysts on data engineering best practices, enhancing team efficiency and fostering a data-driven culture within the organization.
  • Designed and implemented interactive dashboards using Tableau, enabling stakeholders to visualize and monitor supply chain performance metrics in real-time.

Projects:-

APJ Scorecard

  • Results-driven supply chain professional with a proven track record in optimizing inventory management,manufacturing backlog,customer backlog,intransit and Estimated time of Arrival
  • Handling ad-hoc requests in a business environment by responding quickly and efficiently to unplanned tasks.
  • Taken the responsibility to feed data outside the organization to platforms like E2open and PBS.
  • Regular monitoring of automated processes is crucial to ensure smooth operation and data accuracy. It helps identify issues promptly, maintain data integrity, and optimize duplicate efforts.
  • Smart Selection Inventory Migration: -
  • Taken overall responsibility for migration is a significant and challenging task to migrate to new data source i.e Dell Data Lake.
  • Clearly define the scope of the migration. Understand what is being migrated, from where, and to where. Identify key stakeholders and their expectations.
  • Follow a comprehensive migration plan that outlines the tasks, timelines, dependencies, and responsibilities. Include a contingency plan for unexpected issues.
  • Conduct thorough testing of the migration process in DDL environment. Validating the migrated system and data meets the required standards.

APJ/DAO Predictive Aging

  • Predictive analytics using On hand data, Backlog data, Forecast, Incoming Supply data to identify the likelihood of future outcomes based on historical data and , statistical algorithms.
  • Build and Automated the process with a zero-touch approach using a batch script that involves creating a script that executes a series of predefined tasks without requiring manual intervention.
  • Handling ad-hoc requests in a business environment by responding quickly and efficiently to unplanned tasks.
  • Regular monitoring of automated processes is crucial to ensure smooth operation and data accuracy. It helps identify issues promptly, maintain data integrity, and optimize duplicate efforts.

US/ Canada Custom Fulfillment Services

  • Specialized and tailored order processing, packaging, and shipping solutions designed to meet the unique requirements of individual businesses or industries.
  • These services aim to enhance efficiency, reduce costs, and provide a personalized experience for both businesses and their customers.
  • Build and automated the process with the help of FG1 inventory , extended order data and GCSFM data set in Dell data lake.
  • Enable thoughtSpot that significantly enhance our organization's ability to analyze and gain insights from data.
  • Defined data models within ThoughtSpot to structure and organize the data for analysis. Created relationships between different tables or data sources and created a variety of visualizations such as charts, graphs, and dashboards to represent data insights as Global view of US/Canada.

Data Engineer/Analyst

Copious Software
Pune
08.2020 - 06.2022
  • Collect data from various sources like Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses and turn into coherent, visually immersive, and interactive insights through PowerBi.
  • Create sophisticated layouts containing charts, images, subreports, crosstabs and much more by accessing data through JDBC, TableModels, JavaBeans, XML, Hibernate, CSV, and custom sources, then publish your reports as PDF, RTF, XML, XLS, CSV, HTML, XHTML, text, DOCX, or OpenOffice .
  • Extract, transform, load (ETL) copying data from one or more sources into a destination system which represents the data differently from the sources or in a different context than the sources.
  • Provided beneficial professional support to colleagues on any hardware and/or software related issues.

Projects:-

Insight for Velaa.io(In house Project)

  • Data Modelling which aggregate value of Billing vs non Billing hours.
  • PostgreSQL Query building to import data.
  • Dax Implementation for dynamic change of date in X-axis.

Operational Dashboard PowerBI- Kaelo Simply Healthcare

  • Data Modelling on the basis of client requirement
  • SQL Query building to import data
  • DAX implementation for custom date field
  • Data Refresh Scheduling
  • Gateway Setup for connection establishment

Work Impact & Mental Risk Report

  • Create the JRXML file, which is an XML document that contains the definition of the report layout .
  • Build PostgreSQL Query to fetch data from pg Admin server and JRXML is compiled in a binary object called a Jasper file (*.jasper). This compilation is done for performance reasons.
  • Data from the application is filled in the compiled report and we can export the Jasper print file created in any format using JasperExportManagerreate

Education

B.E - Computer Science And Engineering

Birla Institute of Technology, Mesra
Ranchi
07-2020

Skills

  • Supply Chain Planning
  • SQL
  • Postgresql
  • MySQL
  • Python
  • PowerBi
  • Airflow
  • SSIS
  • ETL
  • Data Modeling
  • ThoughtSpot

Languages

Hindi
First Language
English
Proficient (C2)
C2

Affiliations

Global Volunteer-AIESEC

  • Worked on project Lesson For Nepal 4th Goal of Sustainable development(SDG4).
  • Promoting digital education in collaboration with SDG Fund in convering partnership between UN Agencies and governments .

Timeline

Senior Analyst, Data Engineering

Dell Technology
07.2022 - Current

Data Engineer/Analyst

Copious Software
08.2020 - 06.2022

B.E - Computer Science And Engineering

Birla Institute of Technology, Mesra
Rahul Prasad