Biswaranjan Rout

Results-driven Data Analyst with over 6 years of experience in managing and executing data migration projects, primarily for Whirlpool India. Skilled in utilizing tools like SQL, Power BI, Excel, and Google Sheets to ensure seamless end-to-end data migration, update databases in line with business requirements, and generate comprehensive reports. Experienced in analyzing and interpreting large and complex datasets and converting them into actionable insights to support business decisions. Recognized for delivering high-quality work in fast-paced and challenging environments.

Currently working as Data Analyst in Whirlpool India (Quess Corp Ltd) since March, 2018.

Project Title: EMEA Obsoletion
Duration: 06/2024 - Present
Tools Used: SQL, Excel, MobaXterm, Power BI

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 Power BI 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: WOW
Duration: 01/2023 - Present
Tools Used: Excel, MobaXterm

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.
• Provided ongoing support to the business, addressing needs and ensuring smooth operations.

Project Title: Daily Ticket Management

Duration: 01/2023 - Present

Tools Used: ServiceNow, SQL, MobaXterm

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.

Project Title: Windchill LifeCycle Update
Duration: 08/2022 - 12/2022
Tools Used: SQL, Excel, MobaXterm, Power BI

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 Power BI to effectively present data insights to the business.

Project Title: Lipetsk & Indesit Data Migration
Duration: 02/2020 - 07/2022
Tools Used: SQL, Excel, SAP, Windchilll

Roles & Responsibilities:

• Oversaw the complete BOM (Bill of Materials) data migration from SAP to Windchill.
• Collected and formatted data from business units to meet Windchill system specifications.
• Prepared inputs for parts, BOM, CAD, EEP files, Spare Parts, and Booklets, ensuring data 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: NAR Data Migration
Duration: 03/2018 - 01/2020
Tools Used: SQL, Excel, SAP, Windchill

Roles & Responsibilities:

• Spearheaded the comprehensive migration of BOM data from SAP to Windchill across 10 manufacturing plants, ensuring data integrity and alignment with operational workflows, achieving a seamless transition without operational downtime.
• Transformed raw data from 7 business units to align with Windchill system standards; this initiative decreased system onboarding time by 40% for new plants, enhancing overall implementation speed.
• 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.

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 Power BI 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.