Summary
Overview
Work History
Education
Skills
Websites
Languages
Projects
Timeline
Generic
Kajal Mishra

Kajal Mishra

Lucknow

Summary

Experienced Data Engineer with 2+ years of tenure at Tranzita Systems, collaborating on projects with global companies like Procter Gamble (PG). Power BI Developer in data infrastructure, adept at leading projects utilizing Python, Pandas,SQL, Power BI, and Azure Function Apps. Expertise includes Excel automation with Pandas and developing Power BI dashboards enriched with KPIs. Pursuing collaborative team roles to deliver impactful solutions,enhance efficiency, and apply expertise in dynamic data-driven environments..

Overview

3
3
years of professional experience

Work History

Software Development Engineer

Tranzita Systems
Lucknow
04.2022 - Current
  • Collaborated with global industry leaders, including Procter Gamble (PG)
  • Led projects across diverse domains such as supply chain management, manufacturing, issue tracking, ticketing systems, surveys, feedback, and CRM
  • Played a key role in optimizing operations and improving overall process efficiency
  • Enhanced seamless data management across various business functions
  • Addressed unique challenges, driving growth and innovation within key areas

Project Contributor

Procter and Gamble
Mumbai
04.2023 - 08.2024
  • I automated Excel file generation as part of On-Shelf Availability (OSA) initiatives using Python, SQL, Pandas, and Azure Function Apps
  • This streamlined process ensured accurate Root Cause Analysis (RCA) calculations, significantly enhancing the efficiency of the supply chain
  • The automation also enabled seamless forecasting of business losses and identification of potential risks
  • By integrating advanced data analytics and automation, I helped ensure robust decision-making and risk mitigation across operations
  • The technologies used included Python, Pandas, Azure Data Factory, Function Apps, Power BI, SQL, and advanced Excel techniques

Project Contributor

Procter and Gamble
Hyderabad
01.2023 - 04.2023
  • Streamlined Product Integration and Approval Process: The introduction of the PCODE dashboard replaced the manual Excel and email-based processes, allowing for seamless integration of new products into the company's offerings and automating the approval workflow, enhancing overall efficiency
  • Flexible Product Modification with Approval: PCODE enables easy updates to existing product details, including attributes like name, price, weight, and category, while ensuring that all changes are subject to an approval process, maintaining data accuracy and consistency

Project Contributor

Procter and Gamble
Mumbai
10.2022 - 04.2023
  • The aim of this application is to offer a unified platform for all PG employees, allowing them to submit requests to their respective HRSS (Human Resources Shared Services) departments
  • This platform is intended to facilitate effective communication of employees' individual requirements or inquiries to HRSS, with the primary objective of achieving positive responses and outcomes
  • The application is strategically designed to cater to employees in 71 different countries, covering diverse HRSS departments

Project Contributor

Procter and Gamble
Hyderabad
05.2022 - 09.2022
  • Automation of Maintenance Processes: Auto TECO automates job tickets, labor confirmation, and maintenance order completion, reducing paperwork and manpower needs
  • Efficient SAP Integration: The application stores all task records in SAP, ensuring compliance with record retention, using RPA, Power Apps, SharePoint, and Power Automate

Education

B.Tech - Computer Science

AKTU
06.2022

Diploma - Computer Science

BTEUP
06.2019

Skills

  • Python
  • Pandas
  • SQL
  • Data Bricks
  • Azure Data Factory
  • Function App
  • PowerBI
  • Power Apps
  • Power Automation
  • Sharepoint
  • Advanced Excel

Languages

  • English
  • Hindi

Projects

On-Shelf Availability (OSA) Automation

Duration: April 2023 – August 2024

  • Automated Excel file generation for OSA initiatives using Python, SQL, Pandas, and Azure Function Apps, streamlining the process of Root Cause Analysis (RCA).
  • Enabled accurate business loss forecasting and potential risk identification through integrated data analytics and automation.
  • Improved supply chain efficiency by ensuring precise RCA calculations, facilitating robust decision-making and risk mitigation.
  • Technologies Used: Python, Pandas, SQL, Azure Data Factory, Function Apps, Power BI, Advanced Excel.
MOC E2E Transformation

Duration: October 2022 – April 2023

  • Developed a unified platform for 71 countries, enabling employees to submit requests and communicate effectively with HR Shared Services (HRSS).
  • Enhanced HRSS responsiveness and resolution by streamlining employee queries and requirements through the platform.
  • Focused on improving global HRSS communication efficiency and employee satisfaction.
PCODE Automation

Duration: January 2023 – April 2023

  • Designed and deployed a dashboard to replace manual Excel-based workflows, automating the approval process for integrating new products into the company's offerings.
  • Facilitated easy updates to product attributes (e.g., name, price, weight, category) while maintaining data integrity through an approval-based workflow.
  • Significantly enhanced operational efficiency by digitizing and streamlining product modification processes.
Auto TECO

Duration: May 2022 – September 2022

  • Automated maintenance processes, including job ticket management, labor confirmation, and maintenance order completion, reducing manpower and paperwork.
  • Ensured compliance with record retention policies by storing task records directly in SAP through integration with RPA, Power Apps, SharePoint, and Power Automate.
  • Streamlined maintenance workflows to enhance operational efficiency and minimize manual intervention.
Key Technologies and Tools:

Python, SQL, Pandas, Azure Function Apps, Azure Data Factory, Power BI, SAP, RPA, Power Apps, SharePoint, Power Automate, Advanced Excel.

Timeline

Project Contributor

Procter and Gamble
04.2023 - 08.2024

Project Contributor

Procter and Gamble
01.2023 - 04.2023

Project Contributor

Procter and Gamble
10.2022 - 04.2023

Project Contributor

Procter and Gamble
05.2022 - 09.2022

Software Development Engineer

Tranzita Systems
04.2022 - Current

B.Tech - Computer Science

AKTU

Diploma - Computer Science

BTEUP
Kajal Mishra