Biswaranjan Rout

Results-driven Data Analyst with over 6 years of experience in managing and executing data migration projects, primarily for Whirlpool India. Proficient in utilizing tools like SQL, Tableau, Excel, and Google Sheets to ensure seamless end-to-end data migration, update databases in line with business requirements, and generate comprehensive reports. Adept at analyzing and interpreting large and complex datasets, particularly related to Bill of Materials (BOM) data, and transforming them into actionable insights to support business decisions. Recognized for delivering high-quality work in dynamic and fast-paced environments.

Currently working as Data Analyst in Whirlpool India (Quess Corp Ltd)

Project Title: NAR Data Migration
Duration: March 2018 - January 2020
Tools Used: SQL, Excel, SAP, Windchill

Roles & Responsibilities:

• Led the end-to-end BOM (Bill of Materials) data migration from SAP to Windchill across multiple plants, including Findlay, Greenville, Amana, Ramos, Supsa, Cleveland, Tulsa, Horizon, Celaya, Ottawa, and Whirlpool Plastics.
• Gathered data from business units and formatted it according to Windchill system requirements for each plant.
• Prepared inputs and coordinated with the development team to ensure accurate data loading into the system for all listed plants.
• Developed and executed various SQL queries to extract and validate data at different stages of the loading process across multiple locations.
• Performed complex data validation using advanced Excel techniques to ensure data integrity at various stages of the migration process.

Project Title: Indesit Data Migration

Duration: February 2020 - December 2020

Tools Used: SQL, Excel, SAP, Windchill

Roles & Responsibilities:

• Managed the end-to-end BOM (Bill of Materials) data migration from SAP to Windchill for the Indesit project.
• Gathered data from business units and formatted it according to Windchill system requirements.
• Prepared inputs for parts, CAD, EEP files, Spare Parts, and Booklets, ensuring data readiness for migration.
• Coordinated with the interface team to ensure smooth integration and alignment of data across different systems.
• Collaborated with the development team to accurately load data into the system.
• Developed and executed various SQL queries to extract and validate data at different stages of the migration process.
• Performed validation at multiple stages of data loading to ensure accuracy and consistency.
• Conducted post-loading analysis and generated reports for User Acceptance Testing (UAT) in alignment with business requirements.

Project Title: Lipetsk Data Migration
Duration: January 2021 - July 2022
Tools Used: SQL, Excel, SAP, Windchilll

Roles & Responsibilities:

• Oversaw the complete BOM (Bill of Materials) data migration from SAP to Windchill for the Indesit project.
• Collected and formatted data from business units to meet Windchill system specifications.
• Prepared and organized inputs ensuring readiness for migration.
• Worked closely with the interface team to facilitate seamless data integration across multiple systems.
• Collaborated with the development team to ensure precise data loading into the system.
• Designed and executed various SQL queries to retrieve and validate data throughout different stages of the migration.
• Conducted thorough validation checks at multiple stages of data loading to maintain accuracy and consistency.
• Performed post-loading analysis and created comprehensive reports for User Acceptance Testing (UAT) in line with business requirements.

Project Title: Windchill LifeCycle Update
Duration: August 2022 - December 2022
Tools Used: SQL, Excel, MobaXterm, Tableau

Roles & Responsibilities:

• Identified and updated lifecycle templates for each object in the Windchill systems.
• Performed data validation to categorize information by year and part type.
• Updated old and obsolete parts in accordance with business requirements.
• Utilized MobaXterm to execute existing utilities for updating lifecycle templates.
• Conducted post-update validation to ensure accuracy and compliance.
• Prepared pivot tables and charts in Tableau to effectively present data insights to the business.

Project Title: WOW
Duration: January 2023 - Present
Tools Used:  Excel, MobaXterm, ServiceNow

Roles & Responsibilities:

• Conducted validation of engineering parts and drawings to ensure data accuracy and integrity.
• Coordinated with business units to gather and understand specific requirements.
• Created and maintained connections between parts and CAD within the system.
• Updated equivalent links, ensuring correct associations between related components.
• Managed the loading of DT and Esi history in alignment with business requirements.
• Utilized MobaXterm for secure remote access and performed shell-level execution, employing scripting to automate and streamline system tasks.
• Developed and executed custom scripts to enhance data processing efficiency and reduce manual errors.
• Used ServiceNow as a ticketing tool to manage and track requests, incidents, and tasks, ensuring timely resolution and effective communication with stakeholders.
• Provided ongoing support to the business, addressing needs and ensuring smooth operations.

Project Title: EMEA Obsoletion
Duration: June 2024 - Present
Tools Used: SQL, Excel, MobaXterm, Tableau

Roles & Responsibilities:

• Led the effort to clean out EMEA-related objects from the system following Whirlpool’s sale of the EMEA business, including parts, users, and CAD data.
• Developed and executed multiple SQL queries to identify all EMEA-related parts.
• Conducted critical validation to identify and handle shared parts between EMEA and other regions.
• Created detailed analysis dashboards in Tableau to support business decision-making by visualizing data related to the obsoletion process.
• Utilized shell-level execution in MobaXterm to update the state of objects from released to canceled or phasing out, in alignment with business requirements.
• Performed comprehensive post-loading validation to ensure all updates were accurately applied and met business standards.

Project Title: Daily Ticket Management

Duration: January 2023 - Present 

Tools Used: ServiceNow, MobaXterm, Tableau

Roles & Responsibilities:

• Efficiently managed daily ServiceNow tickets related to part and item type conversions, ensuring timely resolution and accurate processing.
• Addressed and resolved requests and incidents pertaining to part conversions and item type adjustments, maintaining smooth operations.
• Collaborated with business units to understand requirements and provide solutions for part and item type issues.
• Leveraged MobaXterm for shell-level execution to automate repetitive tasks, improving efficiency in handling tickets.
• Conducted quarterly analysis of ticket data to measure and demonstrate efficiency improvements. Generated detailed reports showcasing ticket resolution times, recurring issues, and process enhancements.
• Presented quarterly reports to business stakeholders, highlighting improvements in efficiency and effectiveness, and providing actionable insights for ongoing process optimization.

Achievements:

• Successfully migrated complex data with a high accuracy rate, ensuring seamless transition and minimal disruption to ongoing business processes at all involved plants.
• Enhanced the efficiency of data validation processes through optimized SQL queries and advanced Excel techniques, reducing errors and improving overall data quality.
• Created comprehensive Tableau dashboards and visualizations for multiple projects, providing clear insights into complex data and facilitating informed business decisions.
• Received a STAR award in recognition of exceptional performance and significant contributions to the successful completion of the project.