Informatica Mdm Data Management
Resume:
Pathri Narayanan Vijayakumar
Experience Summary:
1.15+ years of experience across industries delivering high-quality solutions and ensuring seamless operation throughout the software development lifecycle. Strong experience in Data management, ETL, Informatica MDM and Java.
2.Proven track record across organizations like Levi Strauss & Co, Walmart.com, Mercury Insurance, CBOE, and Blue Shield of California.
3. During this tenure he has worked on various areas -
Lead the design and implementation of Informatica MDM solutions to support master data management initiatives across the organization. Skilled in analyzing business requirements, designing ETL workflows, and optimizing performance for large-scale data environments. Proficient in SQL, database management, and troubleshooting to ensure data accuracy and integrity. Administration, Testing, Support and resolve issues related to ETL processes, data integration, and workflow orchestration.
Application developer in Java/ J2EE environment (Core Java, JSP, Java Servlets, XML, Java Beans, JDBC, JavaScript, HTML, Struts, Spring, MVC architecture, Hibernate), Oracle PL/SQL including requirements gathering, Design, Coding, Deployment, Debugging and Maintenance and support phases.
Skills:
ETL Tools
Informatica PowerCenter 10.4, Informatica MDM, Riversand MDM, MDM Informatica Data Director (IDD), MDM Hub Console.
Programming Languages
Java, J2EE, Struts, Spring, Hibernate, REST Web Services
Databases & Tools
Oracle, PL/SQL Developer, DB Visualizer, Teradata SQL Assistant 15.0, Cassandra, DataStax, Kafka, Spark, MS SQL Server Management Studio, XML, XSD, REST APIs, SOLR.
Other Utilities
Tomcat 5.7, Web Logic 8.1, Net Beans 4.1, Eclipse 3.1, IntelliJ 9.0.3, Accurev
Reporting – Tableau
Analytics Tool – IBM Tealeaf
Scripting - UNIX shell scripting
Web Debugging Proxy Tool - Charles
Log tools – Splunk
Incident/Problem Management Tools - JIRA, Remedy, Confluence, Service Now
Cloud management and application lifecycle management platform – Oneops
Incident Management Platform - PagerDuty, Xmatters
Version Control tool -SVN, VSS, GitHub
Utilities- MS-Office
Project Summary:
Levi Strauss & Co. – MDM Steady State (Current) Position: MDM Lead Engineer
Company - Cognizant
Project Summary:
MDM (Master Data Management) oversees product and location master data, collecting it from multiple sources. It employs match and merge logic, data quality checks, and data massaging before sending qualified data to downstream systems through middleware’s such as Message Queue (MQ), GIS, SAP PI/PO.
PIM (Product Information Management) and ELM (Enterprise Location Management) applications are constructed on the Riversand platform. The PIM system aids Levi's vendors in devising packaging plans and generating PO/ASN for item shipments. Meanwhile, the ELM system is responsible for managing all location master data for Levi's stores, enabling business users to modify critical attribute values and provision role-based access to business users.
Roles and Responsibilities:
Collaborate with business stakeholders to understand data requirements and translate them into MDM solutions in Product and Location domains.
Involved in design and development of the MDM layers such as InfaRawStage, Staging, Landing and BO, etc.
Developed data quality rules and workflows to cleanse, standardize, and enrich master data within the MDM solution.
Responsible for creating and monitoring Master data management and designing and developing ETL solutions using Informatica MDM.
Responsible for complete ownership of Rejects Reconciliation automation and Validation for product and location master data, proactively to sync the data by utilizing SQL (Table/View) skills.
Leading project and coordinating with offshore teams to ensure technical delivery of business requirements and business SME needs, including creating mapping and mapplets configuration.
Streamlining end-to-end product data flow from PLM to MDM to SAP-S4 to e-commerce sites (B2B, B2C), including anticipating future data needs and implementing solutions within the Informatica MDM and ETL layers.
Implementing data objects and integrating data shared across multiple source and target systems (Table/view/Flat File, etc.)
Involved in design/development of addition of attributes thro’ enhancement requests confirming Governance and coordinated with SAP BI Teams - HANA/S4/SAS teams to complete the integration testing.
Facilitating SIT/UAT phases and collaborating with dependent teams for testing data flow in lower environments such as QA/Dev/Sand Box/Preprod for the Levi’s Solar Releases 1.0,1.5 and 2.0 for various workflow changes and the enhancement requests from Business users.
Utilizing Riversand Tool for bulk uploading product data and provisioning access through Role-Based Access Control (RBAC) in ELM and handling the data configuration through MDM IDD and Hub Console tools.
Creating and maintaining data dictionaries, analyzing business requirements for integration and implementation, and serving as a liaison between stakeholders.
Addressing production critical issues, involved in code reviews, creating Change Requests (CRs) and participating in CAB meetings for the production deployment changes along with required release management teams and stake holders.
Expertise in handling product data, including ad-hoc triggering of urgent products to downstream systems and managing daily delta/full feed for downstream users.
Configure and support Informatica PC jobs and scheduled daily jobs to manage inbound and outbound data, including delta feeds to downstream systems.
Technical skills: Informatica PC, Informatica MDM, Riversand, MS SQL, MDM IDD, MDM Hub Console, Oracle SQL Developer, Linux
Walmart Labs – Cart and Checkout (CXO) Position: Lead Developer
Company - Cognizant
Cart and Checkout (CXO) is one of the key project in Walmart global ecommerce which manages CXO customer interaction pages supporting USGM (General merchandise), USGR (Grocery), Marketplace, VUDU and Photo business. This project is primarily responsible to implement, maintain and enhance CXO core functionalities like creating new cart, Add/update/remove items.
Roles and Responsibilities:
Involved in design and development of Cart and Checkout Front End screens using Java, J2EE, Spring, Hibernate, and SOA for product enhancements.
Developed custom Dashboards for Cart and Checkout Funnels, aiding in error detection and monitoring.
Implemented Splunk Enterprise for real-time data correlation, customized dashboards, and reports.
Acted as a liaison between various teams, promptly resolving production issues using SQL, PL/SQL, and UNIX shell scripting.
Monitored CXO metrics through Splunk dashboards and Grafana graphs, ensuring SLAs were maintained.
Conducted stress tests on scalability and managed compute capacities during peak periods.
Leveraged Tealeaf to analyze customer navigation and debug issues, focusing on session capture details.
Technical skills: Oracle PL/SQL Developer 8.0, Postman,Splunk, IBM Tealeaf, Spring, Hibernate, Java, J2EE, React, Node JS, Oneops, Restful web service.
Walmart Labs – LIMO Position: Product Support Engineer
Company - Cognizant
LIMO (Logistics Item Master Offerings) is a resource tier in the item catalog that manages item data related to supply chain and works at an offer and offer-ship-node level. It owns fulfillment and supply chain driven program eligibilities, e-commerce, and store supply chain attributes at offer-ship-node level. The vision for LIMO is to be a self-service resource tier for supply chain item attributes.
Roles and Responsibilities:
Diligently monitored sweep jobs, bootstrap batches, and rules triggered by the Business team, ensuring daily validation of rules.
Efficiently addressed JIRA/INC tickets concerning LIMO and GBAS system issues within SLA timelines.
Acted as a bridge between product managers, development, DevOps, and other dependent teams such as SOLAR, Cassandra, Kafka, SITI, IQS, and ISO, resolving critical production issues promptly.
Provided assistance to dependent teams like Data ops and OAR on Stage, Teflon, and Prod environment issues.
Managed CRQ support by creating production change requests, obtaining necessary approvals, and monitoring dashboards to prevent spikes in errors/issues during execution.
Proactively monitored 11 key ingestion metrics in LIMO daily to mitigate major downtime risks.
Played an active role in supporting the MVP Glass project, particularly in monitoring bootstrap batches and resolving related issues.
Supported various applications including Item Catalog, Item-Store Catalog, Item-Node Catalog, Expert, Royale, Tuatara, Item Read, and GBAS.
Offered extended hours and weekend support to ensure 24/7 desk coverage, especially during peak periods.
Led offshore support teams, coordinating daily delivery and work allocations effectively.
Technical skills: Oracle PL/SQL Developer 8.0, Splunk, IBM Tealeaf, Spring, Hibernate, Java, J2EE, React, Node JS, Oneops, Restful web service.
Walmart Labs - Canada Marketplace (CAMP) Position: Production Support Engineer
Company - Cognizant
Canada Marketplace (CAMP) -- Walmart Canada is planning to expand the Business and provide more variety of products to their customers Online. In order to achieve the target, they are introducing the Marketplace Program. This program helps to onboard Marketplace sellers across the Canada onto Walmart platform and allow them to seller their products online at Walmart for competitive prices and improve the customer experience online. The scope of the project is to onboard ~300 Marketplace Sellers in every year and increase the Catalog size to ~3 Million SKUs.
Roles and responsibilities:
Successfully integrated MP Sellers into Walmart's technology platform, supporting ongoing connectivity and addressing issues related to Item Management, Catalog Management, and Order Management/Payment systems.
Engaged in daily Scrum discussions with Walmart Canada Business Analysts and Technical Experts to enhance understanding of new features/modules entering Production.
Analyzed data issues concerning item setup, particularly focusing on Base Variant and Category changes, and streamlined processes for both Excel uploading and APIs.
Utilized REST Web Service with XML and XSD for debugging item setup errors.
Provided mentorship and training to technical support staff on technical and procedural matters.
Monitored and documented all client communications, processing requests, and documenting changes.
Developed and tested resolution plans for technical issues, communicating needs to customers and supervisors.
Generated daily reports such as live sellers on sites, Launch Readiness, Transaction Readiness Report, Seller Launch Statistics, and SKU Launch Analysis from platforms like Salesforce and ATOM.
Compiled and prepared logs from Salesforce Reports for Integration Engineers' follow-up efforts on Seller Accounts.
Conducted Onboarding Webinars for marketplace sellers, outlining item and variant setup using Full Item Spec and Seller Center's user interface, and registration procedures.
Technical skills: Mango DB, Oracle PL/SQL Developer 8.0, XML,XSD, REST Web Services, Cassandra, DBeaver 3.7.2,Datastax,SOLR
Walmart Labs - RCT- Partner Operations Position: Production Support Engineer
Company – Cognizant
Partner Operations primarily focuses the issues identified in various areas such as Order, Refund, Item Setup, Mapping and Attribution, Payments, Item Pricing, inventory, etc. These areas of issues are mainly raised by US Marketplace sellers, Channel Advisors, Business Operation team or internal teams, Category Managers, etc. We provide the production support for the Marketplace Sellers and Supplier (DSV) (Drop Ship Vendors) by resolving issues within the SLA, fix defects, perform minor enhancements, prevent issues and provide continuous improvement to the system.
Roles and responsibilities:
He is responsible for the Operational, Business Support and Development activities for Market place Integration Project.
He is understanding the Business/Functional Requirements and provide the support by means of solutions for the Production issues through the data analysis or escalating the problems with the onsite/offshore Development teams.
To provide the solution for the production issues by applying the patch fixes and code and bug fixes through analysis, debugging the code and logging frameworks.
He is responsible for generating the various Pie or Bar charts and graphical reports through the Java /J2EE technologies and Data Analytics tools such as Tea Leaf, Endeca and some specific search Engine tools which are widely used in the market. He is analyzing and providing the solution for the Business Support tickets in Remedy and Incident Management System.
Technical skills: Teradata 15.00, PL/SQL Developer 8.0, XML, XSD, API, Cassandra, DataStax, SOLR
Mercury Insurance - AL3 Download and ePresentment Position: Java Support Engineer
Company - Cognizant
Technical Skills: Java 2.0, Clear Case 7.0, IBM Rational Software Architect 7.5,Ultra Edit, XML Pro, WebSphere Application Server 7.0,XML,XSD,Hudson,DB Visualizer 8.0,Hudson 3.1
CBOE - CBOE ITG Driver & Tool Position: Java Developer
Company - Cognizant
Technical Skills: Java 2.0, Clear Case 7.0, Eclipse 3.0, JAD, UNIX Shell Scripts, Remedy System
Blue Shield of California - CDM (Common Data Model) Position: Java Developer
Company - Cognizant
Technical Skills - Java 2.0, Java Beans, Servlet 2.4, JSP 2.0, EJB 2.1, JDBC, Hibernate 3.1, Struts 1.2
ACS - Alaska MMIS Release Position: System Analyst Company - Cognizant
Technical Skills: Java 2.0, Java Beans, Servlet 2.4, JSP 2.0, EJB 2.1, JDBC, Hibernate 3.1
Orbitz Worldwide - Individual Marketing – Customer Relationship Management
Position: Agile Engineer/Production Support Company - Cognizant
Technical Skills: Core Java, JSP, Java Servlets, Oracle 9i, Web Logic, Accurev, IntelliJ, DB Visualizer.
MetLife Insurance - Service Request Director (SRD) Position: Production Support Engineer
Company - Cognizant
Technical Skills: Web Methods Developer 7.1, Web Application
Sun Micro Systems - VIDT (Velocity Identity Deployment Tool) Position: Software Developer/Agile Engineer
Company - Wipro
Technical Skills: Oracle 8i,Java,JSP, Java Beans, Java Servlets, JavaScript, Identity management, JDBC, HTML,XML, XSLT, Ant, Eclipse, Velocity Template Language(VTL),Sun IdM, Identity Management. Apache Tomcat 5.5.
Target Corporation - RFID - Data Analytics Position: Software Developer
Company - Wipro
Technical Skills: DB2 9.5, SQL Server 2000, JSP,Java Servlets, Java Web Server, JavaScript, Tomcat Web Server, JDBC, HTML, Eclipse, CEWolf 1.1(Chart Generation Tool),Oracle 8.0
Sysbiz Technologies - US Oncology Position: Software Developer
Technical Skills: Oracle 9i, JSP, Java Servlets, JavaScript, Struts, Web Logic, JDBC, Java, Eclipse, Web logic Server 8.1, Windows XP, Citrix 78768.
GoldScape Solutions – Mco Medi Aids Position: Programmer
Technical Skills: Oracle 8.x, J2EE, JSP, Java Servlets, JavaScript, Tomcat Web Server, JDBC, Java, Net Beans 4.1.
Certifications/Courses:
No
Certification
1
Oracle Autonomous Database Cloud
2
Oracle Cloud Infrastructure Foundations
3
One Ops Level -I and II
4
Java Enterprise Edition 5 Web Services Developer Certified Professional Exam
5
Sun Certified Web Component Developer (SCWCD)
6
Sun Certified Java Programmer (SCJP) (SCJP 1.4)
7
Informatica Core: Data Integration, Informatica Core: Data Quality, Informatica Core: Cloud Integration
8
Riversand MDM for Implementation Consultant - Syndigo University
Contact this candidate