Data Customer Service

Anand Kumar Singh

Stibo Technical Consultant

Email: adcnt9@r.postjobfree.com Cell: 347-***-****

Profile Summary:

Strong Functional and Technical knowledge on STIBO-STEP PIM System.

Over 5 years of experience on STIBO-STEP PIM and MDM development.

Real time experience in STEP Data Model, STEP workflow, STEP Business Rules using Java Script and STEP Portal configuration.

Expertise on STIBO STEP implementations for retail clients with good technical and functional knowledge on various MDM streams like print publishing, data quality and asset management.

Experience in Integration design such as STEP to SAP ECC, Third party systems, Multi-channel, reporting, etc. (Inbound/Outbound Integration End points)

Experienced supporting GDSN standards (GTIN, GLN, CIS, CIN, and CIC), Packaging hierarchy management, Product update status tracking, Preconfigured workflows to manage the full GDSN process: Register/Modify, Publish Product, Un-Publish Product, Re-Publish Product, Modify Packaging Links.

Strong experience in STEP Asset management system, Scene7 to STEP Integration

Strong experience in STIBO patches deployments, configuration movement between environments and STEP Extension API implementation.

Experienced in various Teradata utilities like Fast load, Multi load, BTEQ, and Teradata SQL Assistant.

Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

Passionate towards designing and working on data driven applications that address business with their data management challenges.

Technical Skills:

Java 8, J2EE, Spring, REST, JSON, Mongo, CI & CD (Jenkins, Automation tests, Artifactory), Source Control (Bitbucket, Git, Source Tree), Linux, Shell scripts, WINscp, Beyond Compare, Tomcat, Nagios, New Relic, Sumo logic, Junit, Test NG Eclipse, Maven, WinSCP, Informatica, Putty, STEP Trailblazer 8.3 and 9.1 by Stibo Systems.

Education:

Bachelor’s in information technology May 2014

Rajasthan Technological University GPA: 6.98

Master’s in Computer and Information Science January 2017

Cleveland State University GPA: 3.3

Work Experience:

Advance Auto Parts, North Carolina December 2019 - Present

PIM/MDM Technical consultant (Stibo STEP Trailblazer)

Responsibilities:

Migrated a large volume of data from the legacy system successfully all business units from STEP 5.2 to STEP 9.2.

Worked on all the STIBO’s patch deployments/STEP configuration move/ technical consultancy.

Configured Vendor portal for data authoring and Bulk import through smartsheets.

Agilent Technologies, Santa Clara, CA July 2018 – December 2019

PIM/MDM Technical consultant (Stibo STEP Trailblazer)

Responsibilities:

To work as a Technical Developer for client, translating the Business requirements into Technical Specifications.

To prioritize requirements and create conceptual prototypes and developed new Business rules and fine-tune existing rules for easy maintenance of PIM system.

Completed analysis and practicability study on PIM requirements against STIBO STEP Trailblazer 8.3 and migrated to STIBO STEP Trailblazer 9.1

Strategized and led the Data PUMP and Data Refresh activities.

To maintain a PIM system with ~2Lakh part numbers across 3 contexts and multiple countries.

To configure Asset Push queues and OIEPs for Image sync to downstream.

To create STEP workflows for item creation and maintenance and configured attributes, LOVs and business rules for various functionalities.

To work closely with client, customers and offshore team to determine planning, implementation and integration of system-oriented developments.

To create Classifications, Workflows, Attribute groups and work on User Privileges.

To work effectively on Integration Endpoints & WebUI (Portal) design.

To work on Requirements gathering, various data model design including logical, physical data model and play key role on solution architecture design.

To work on the Data Migration design and Integration design.

To develop in Custom tool creation using STEP WebUI services.

Involved in writing business rules and Testing of the requirements.

Involved in providing solutions for the Problem requests arising out of testing and handling releases/ PROD Live Issues as per sprint planning.

To work on all the STIBO’s patch deployments/STEP configuration move/ technical consultancy.

To migrate a large volume of data from the legacy system successfully for 20 business units.

To provide resolution for many critical integration issues.

To implement STEP PIM solution for more than 30 contexts (Multi country Roll out)

Designed the Multi country / Language/ Site dimensional points in STEP

To implement parallel processing that helped for Data Migration.

To work on Digital Merchandising where the products processed in PDM were visible on website

To configure Jenkins and automation suites that improvised the overall performance of system and reduced the manual testing efforts.

To configure Asset Push queues and OIEPs for Image sync to downstream.

To configure Entity Level References data management from multiple source systems

Boston Scientific, Marlborough, MA January 2018 – June 2018

MDM Solution Architect & Product Information Management

Responsibilities:

Developed logical and physical data model for customer and vendor master from large data sets available on different sources from local geographical are and then extending to global.

Analyzed and prepared hierarchy document for customer and vendor.

Developed data dictionary document for different schema available on both source and target system.

Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.

Created mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.

Involved in analysis and designing of rule matrix document which was then used for development purpose.

Developed and implemented several custom Fiori apps on-premise.

Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.

Involved with business users to get Business requirements and analysis of the source systems data.

Prepared ETL design specification documents with information on implementation of business logic.

Create and modify customer master data to update data standards order to be updated in SAP for customer service department.

Extract, cleanse, standardize, validate, research, and remove duplicate customer records from excel spreadsheets.

Create and modify customer master data to update data standard to update in Power BI for customer service department.

Barneys New York - Luxury Department Store Company January 2017 – December 2017

Stibo Technical consultant

Responsibilities:

Completed analysis and practicability study on PIM requirements against STIBO STEP Trailblazer 8.3 tool capabilities.

Led Migration of about 1 million source product data including, Super Styles, Styles and SKUs of each category such as Men, Women, Kids, etc.

Configured multiple integration end points for each source including Pricing, Inventory, etc., applied business rules on approval for validation and republished bulk products from collections.

Created, exported and imported products for analyzing and reporting purpose.

Planned categories such as distribution center, google classifications and other important.

Organized mapping of the source file for migration and saved it in export and import configuration.

Detailed analysis and feasibility study on PIM requirements versus STIBO STEP tool capabilities.

Led Migration of about 1 million source product data including, Super Styles, Styles and SKUs of each category such as Men, Women, Kids, etc.

Configured multiple integration end points for each source including Pricing, Inventory, etc., applied business rules on approval for validation and republished bulk products from Collections.

Complete design of Product Hierarchies/Taxonomies, Product attributes, cross sell / up sell relationships, inheritance and overriding rules, business rules.

Explanation of Data Migration, Data publish strategy and maintained the schema file for inbound and outbound integration.

Planned Item Creation and Enrichment, Item maintenance workflows with defined data governance rules.

Developed Event processor, Business Rules as per the business requirement in STIBO STEP workbench.

Developed Match codes and Matching Algorithms and integrate it within the event processor.

Developed References, golden records and silver records using javascript for business rules and event processors, Taxonomies, Primary Product Hierarchies and build collections in STIBO STEP workbench.

Designed the workflows and trigger the events based on the validation rules.

Managed the extensive development of the business rules for multiple nodes in Javascript.

To drive the cross-selling of STIBO-STEP Solutions, designs for complementary products, supportand services.

Designed of Inbound/Outbound Integration end points.

Configuration of Vendor portal for data authoring and Bulk import through smartsheets.

Creation of Test Specifications/Testing Strategy documents.

System Integration and Performance Testing MDM Tool: STIBO STEP Trailblazer V8.3, Oracle ecommerce solutions, Demandware, FileZilla, etc.

Direct Supply, Milwaukee, WI November 2014 – May 2015

Stibo Technical consultant

Responsibilities:

Managed the group including MDM engineers, QA, Business Analysts and Integration.

Designed the work processes, create Match codes and Matching Algorithms, and Portals.

Configured Vendor gateway for information writing and Bulk import through smartsheets.

Designed question composes and structures and Inbound and Outbound Integration endpoints.

Implemented Agile Methodology and work intimately with Scrum ace making stories and assignments.

Managed and take part in runs, direct run audit, reviews and business customer demo.

Involved in Integration Testing of PIM Components with Upstream and downstream applications.

Designed the workflows and trigger the events based on the validation rules.

Managed the extensive development of the business rules for multiple nodes in Javascript.

To drive the cross-selling of STIBO-STEP Solutions, designs for complementary products, support and services.

Managed the development of standard portals applications and practice Agile principles.

Designed object types and structures and Inbound and Outbound Integration endpoints.

Implemented Agile Methodology and work closely with Scrum master creating stories and tasks.

Imported and Exported objects from development to Stage, QA and Production environment.

Provided contribution to creating and altering Stibo configuration to address customer issues and created business to help these adjustments.

Interacting with business users, brand managers on daily basis to understand and clarify their issues related to Stibo.

Led Release Management activities for the Stibo implementation serving as a liaison between internal technical team and the external vendors and provided 24/7 support for code migration activities and closely monitored both Repository and Non-Repository level migrations.

Accenture, Bangalore, India May 2013 to December 2014

Software Programmer

Client: Marks and Spencer (M&S)

Marks and Spencer (M&S) is the one of the famous retailers in UK. M&S has decided to replace the existing ecommerce application with the new own platform application. The STIBO-STEP system has been implemented successfully to provide the product details to front end application as well as order management system. I have successfully undertaken the role of Solution Designer and worked directly with the clients and various vendors. Acquired the necessary functional and business knowledge within short time and used them successfully in data modelling, data migration and integration.

Responsibilities:

Involved in Requirements gathering, Various data model design including logical, physical data model

Involved in the Data Migration design, Business Rules implementation and Integration design

Involved in Coding and Testing of the requirements.

Migrated a large volume of data from the legacy system successfully.

Provided guidance to developers and testers of STIBO STEP PIM application on Quality Control Aspects Involved in Integration Testing of PIM Components with Upstream and downstream applications.

Contact this candidate