Prantik Dutta

• Collaborated with Business Analysts and Data Architects to translate business requirements into technical implementations for Informatica MDM P360.
• Monitored item data flow from SAP MDM to Informatica P360, addressing job failures.
• Troubleshot and resolved issues in Data Integration between ETL processes and P360 applications.
• Optimized P360 mappings and data quality rules to enhance performance and efficiency.
• Designed and developed enhancements in P360 application using SQL Server to fulfill business needs.
• Migrated Informatica MDM P360 application from version 8.1 to 10.1, improving system functionality.
• Performed root cause analysis for critical issues in collaboration with cross-functional teams.
• Guided offshore team on existing P360 issues while explaining technical functionalities of current and upcoming enhancements.

• Collaborated with THD application and business stakeholders to analyze Hybris PIM system functionalities and prepared a Business Requirement Document.
• Defined end-to-end application architecture with solution architects, utilizing Informatica P360 as a core PIM solution.
• Created a Requirement Traceability Matrix to consolidate all project requirements in one document.
• Worked with developers to establish Data Modeling strategies using P360.
• Led development and configuration of workflows and business rules leveraging Informatica P360 capabilities.
• Coordinated with the migration team to transfer data from the legacy Hybris PIM system to P360.
• Directed technical workstream and liaised with offshore team to clarify business requirements.
• Facilitated multiple user training sessions to ensure business team proficiency in the new Informatica P360 PIM application.

• Provide technology inputs and technical leadership for the design, development, and delivery of products and services.
• Lead the technical implementation, and function as a point of escalation for resolving technical matters.
• Manage the team for the '24 x 7 Support & Maintenance System,' and provide a quick response for P1 and P2 incidents whenever needed.
• Create new users and new attributes in the application.
• Export data feeds from the application as per user requirements by using complex search queries in Workbench.
• Maintaining the SaaS Portal of the STEP tool, used in the project, and upgrading STEP based on the availability of the latest patching images.
• Work with business users to get the new requirements, analyze those requirements, and create new JIRA tickets with function analysis comments.
• Take the enhancement requests from the JIRA board, and complete the development, along with testing and implementation.
• Manual testing of the new features implemented by the Dev team every month. Report any issues to ensure that no existing features are impacted by the new releases.
• Identify and assign roles to team members, set project goals, and ensure optimum utilization of resources, including infrastructure and manpower.
• Preparing Test Case Documents, Test Case Logs, and Test Case Summary Reports.
• Monitoring various workflows and taking quick action in case any item is stuck in the workflow.
• JavaScript enhancement in the case of any business rule change.
• Debug data issues and fix those in STEP (both Workbench and WEBUI).
• Perform bulk upload and generate a large data feed using Export/OIEP for users.
• Monitoring MQ for incoming and outgoing messages.
• Preparing System Understanding Documents and Support Process Handbook for the project. Also, provide KT to the new members in the team.
• Also, performance testing was done whenever any application slowness or performance issue was reported.
• Prepare and present the weekly status report and monthly status report to the customer.

• Provide technology inputs and technical leadership for the design, development, and delivery of products and services.
• Lead the technical implementation and function as a point of escalation for resolving technical matters.
• Manage the team for the '24 x 7 Support & Maintenance system,' and provide a quick response for P1 and P2 incidents whenever needed.
• Create new users and new attributes in the application.
• Identify and assign roles to team members, set project goals, and ensure optimum utilization of resources, including infrastructure and manpower.
• Export data feeds from the application as per user requirements by using complex search queries in Workbench.
• Maintained UNIX servers across four environments, such as Production, Perf, QA, and Development, for the PIM application.
• Decommission old Linux boxes, add new servers to the application and test the application completely to validate the migration.
• Manual testing of the new features implemented by the Dev team every month ensures that no existing features are impacted by the new releases.
• Preparing Test Case Documents, Test Case Logs, and Test Case Summary Reports.
• Monitoring various workflows and taking quick action in case any item is stuck in the workflow.
• JavaScript enhancement in the case of any business rule change.
• Debug data issues and fix those in STEP (both Workbench and WEBUI).
• Perform bulk upload and generate a large data feed using Export/OIEP for users.
• Monitoring MQ for incoming and outgoing messages.
• Preparing System Understanding Documents and Support Process Handbook for the project.
• Provide technical and functional knowledge transfer to the new members of the team.
• Also, performance testing was done whenever any application slowness or performance issue was reported.
• Prepare and present the weekly status report and monthly status report to the customer.
• Also involved in an RFP activity for Customers’ Europe Business, where MDM implementation was planned to be done on the Informatica P360 Platform. Working with business users to understand the requirements and function analysis of those requirements to place them in the P360 platform was the main activity.

• Designed catalogs, specifications, and hierarchy for comprehensive data management using STIBO STEP, and IBM PIM.
• Created item attributes and attribute groups according to requirements.
• Managed 24/7 support and maintenance, ensuring rapid response for P1 and P2 tickets.
• Maintained UNIX servers across production, QA, and development environments for the PIM application.
• Performed master data corrections in PIM based on user requirements.
• Monitored workflows, taking immediate action on items stalled in the process.
• Conducted manual testing and regression testing of functionalities across environments.
• Prepared system understanding documents and weekly status reports for stakeholders.

• Cataloged specifications and hierarchy designs according to updated requirements using IBM PIM.
• Created item attributes per defined specifications.
• Oversaw 24/7 support and maintenance systems, delivering quick responses for critical tickets.
• Administered user creation in the IBM PIM application while assigning relevant roles.
• Resolved data corruption issues within basic database tables of PIM.
• Maintained UNIX servers in four distinct environments: Production, QA, DR, and Development for optimal performance of PIM applications.
• Conducted master data corrections in PIM based on user requests, along with managing jobs related to SKU creation and updates through reports and imports.
• Designed WPC scripts tailored to project objectives, focusing on data correction and information gathering.

Provided analytical support to key clients such as 3M and Staples by gathering requirements.
Executed effort estimations, development, unit testing, and deployments utilizing Endeca Workbench and IBM PIM.
Coordinated with offshore teams to ensure timely delivery of project milestones.