Biswaranjan Rout

Results-driven Data Analyst with Whirlpool(Quess Corp Ltd), skilled in data visualization and interpretation. Developed impactful Power BI dashboards and automated data validation processes, enhancing accuracy and efficiency. Proficient in SQL, and advanced Excel functions, I excel in cross-functional collaboration to drive digital transformation initiatives.

Project Title: Daily Ticket Management

Duration: 01/2023 - Present 

Tools: SQL, Excel, Jira

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.
• Created, managed, and tracked user stories and tasks in Jira to document data requirements, assign ownership, and ensure timely resolution of business and technical issues.

Project Title: WOW

Duration: 09/2023 - 05/2025

Tools: SQL, Excel, Windchill

Roles & Responsibilities:

• Coordinated with business units to gather and understand specific requirements.
• Created and maintained connections between parts and CAD within the system as per business requirements.
• Updated equivalent links, ensuring correct associations between related components.
• Managed the loading of DT and Esi history in alignment with business requirements.
• Performed pre and post loading validation using advanced SQL queries .

Project Title: EMEA Obsoletion

Duration: 02/2023 - 08/2023 

Tools:  SQL, Excel

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.
• 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.
• Designed and developed an interactive dashboard to visualize EMEA part obsoleting metrics, enabling business teams to track progress, identify shared parts, and make data-driven decisions effectively.

Project Title: Windchill Part Lifecycle Analysis

Duration: 06/2022 - 01/2023 

Tools: SQL, Excel, Windchill

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.
• Conducted post-update validation to ensure accuracy and compliance.

Project Title: ⁠CAD Data Migration

Duration: 08/2021 - 05/2022 

Tools: SQL, Excel, Windchill,

Roles & Responsibilities:

• Migrated metadata of CAD drawings and linked documents from legacy platforms to Windchill.
• Ensured relationships between parent-child components were maintained.
• Developed a status tracker and audit reports to validate successful uploads.

Project Title: ⁠BOM Data Migration (SAP to Windchill)

Duration: 03/2018 - 07/2021

Tools: SQL, Excel, SAP, Windchill

Roles & Responsibilities:

• Migrated and validated Bill of Materials from SAP to Windchill for 15+ plants.
• Wrote logic to identify missing parts, obsolete items, and duplication.
• Extracted various reports using SQL to perform pre and post-migration validation and to create exception reports.