RAHUL MARAM
Bloomington
Summary
- Informatica MDM Developer and Data With 9 years of experience into Informatica MDM and Oracle SQL, PL/SQL, I have a strong background in Informatica MDM and worked on different version like 9.4, 10.4.3
- My expertise includes designing, developing, testing, and reviewing MDM solutions.
- I am skilled in creating mappings, trust and validation rules, match paths, match columns, and match rules.
- I have experience in the creation and maintenance of entity objects, hierarchies, entity types, and relationship objects using the Hierarchy tool to support Hierarchy Manager (HM) in MDM Hub implementations and Informatica Data Director (IDD).
- I possess hands-on experience in designing and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, custom queries, and packages.
- I have knowledge of implementing hierarchies, relationship types, packages, and profiles for effective hierarchy management in MDM Hub.
- Design and delivered the Supplier S360.
- Configuration of Active VOS workflows.
- I have designed, installed, and configured core components of Informatica / Siperian MDM Hub, including the MDM Hub Console, Cleanse Match Server and data modeling.
- Design and configure Informatica MDM components (like match/merge rules, hierarchies, survivorship rules, etc.) and P360 Product Mastering, Syndication, and Supplier Portal and worked as well as in S360, C360
- Ensure data governance policies are applied and maintained, facilitating data stewardship, metadata management, and regulatory compliance.
- Additionally, I have hands-on experience with C 360, S 360, P 360.
- My experience includes integrating various data sources such as Oracle, SQL Server, MS Access, flat files, and XML files.
- Analyze and optimize SQL queries for performance, ensuring efficient data retrieval and modification. Write complex SQL queries to retrieve, insert, update, and delete data in Oracle databases.
- Provided training to team members and conducted knowledge transfer to all team members.
- Collaborate with business analysts, data architects, and IT teams to define integration requirements
- Streamlining submissions to reduce processing time.
- Configure SaaS-based Informatica solutions for data integration, quality, and governance.
- Stibo Systems Master Data Management (MDM) platform, with responsibilities including designing data models, configuring workflows, defining business rules, integrating with other systems, and ensuring data quality across an organization
Overview
9
9
years of professional experience
Work History
Lead MDM Consultant
Wesco
07.2023 - Current
- The project is adopting an integrated approach to manage supplier details and implement new client requirements in S360
- The primary goal is to establish a Master Data framework for supplier information
- Key activities include worked as lead in the team and handled the team with their doubts
- Developing Search APIs
- Configured the data mappings and transformations necessary for supplier data ingestion into Supplier 360
- Collaborate with the developer to validate data loading and transformation results, ensuring alignment with business needs
- Implementing data governance and data quality policies
- Configure match and merge rules, survivorship rules, and workflows within Supplier 360
- Collaborate with business analysts to understand data requirements and create solutions accordingly
- Work closely with business stakeholders to define data requirements and align Supplier 360 configuration with business needs
- Perform data profiling, create reports, and provide insights to stakeholders for data-driven decision-making
- Writing test cases and conducting testing across various scenarios
- Configuring both static and dynamic lookups in IDD
- Maintain MDM system configurations and settings
- Configuration of Active VOS workflows
- Build processes for data cleansing, transformation, and loading
- Optimize ETL processes for performance and scalability
- Manage user access and security protocols
- Integration with PowerBI and Mule soft
Informatica MDM Developer
Abbott
04.2022 - 06.2023
- Provided support for Informatica MDM related to Abbott's Product analysis, hierarchy and cost planning
- Managed AutoSys jobs on a daily, monthly, and yearly basis
- Oversaw integration between MDM and other systems, such as CRM and Mulesoft
- Troubleshot and resolved data-related issues
- Served as a Product Analyst on projects to ensure the organization's data assets were accurate, accessible, and aligned with business requirements, enabling data-driven decision-making across the enterprise
- Ensured smooth data flow and synchronization
- Managed bulk data imports and exports through IDD
- Addressed errors and handled data refresh tickets
- Maintained configurations and settings for the MDM system
- Assisted with data validation and reconciliation efforts
- Design and configure Informatica MDM components (like match/merge rules, hierarchies, survivorship rules, etc.) and P360 Product Mastering, Syndication, and Supplier Portal
- Ensure data governance policies are applied and maintained, facilitating data stewardship, metadata management, and regulatory compliance
- Manage multiple projects concurrently, effectively setting priorities to support New Product Introduction (NPI) initiatives
- Oversee the implementation of Agile ECR, ECO, and MCO analysis programs
- Performed backups and restorations of MDM environments as needed
- Offered technical support to MDM users
- Developed solutions and submitted change requests for production issues
- Streamlining submissions to reduce processing time while ensuring data accuracy and integrity across entries
- Maintained schemas for the current and upcoming year
Informatica MDM Developer
Novartis
06.2021 - 03.2022
- The MDM Address Master is designed to manage customer location data for Healthcare Professionals (HCPs) and Health Care Organizations (HCOs) from various internal and external sources
- Its a life science project
- Source data is cleansed, standardized, and consolidated within MDM to deliver the most accurate version of each customer address
- The project's primary objective is to establish Master Data for the addresses of HCPs and HOS from multiple internal and external sources
- This is a multiyear project that encompasses several responsibilities
- Inception: Involves processing source files, applying data cleansing and rejection rules, and defining data transformation rules
- Address integration issues are addressed while optimizing data transfer processes
- Standardization & Validation: Standardizing source values, including Address Line 1, Address Line 2, City, State, Zip, etc
- Storage & Consolidation: Identifying similar or duplicate records from multiple sources and assessing source reliability to create and enhance golden profiles
- ETL processes for performance and scalability
- Worked on Active VOS flows
- Worked on different versions like 10.3, 10.4.3, 4.3
- Provisioning (Publishing): MDM provisions consolidated and source data to subscribed downstream systems, following data provisioning rules and architecture
- Other Processes: Several ad hoc and parallel processes run alongside these activities and C360 SaaS
- Provide training and documentation to end-users on Informatica SaaS tools and processes.
- Data integration through CDI process
- Configure SaaS-based Informatica solutions for data integration, quality, and governance.
- Design and delivered the C360
- Delivered the CDI process design with SG patterns
Data Management Analyst
Hsbc
03.2019 - 06.2021
- Worked on Informatica MDM related to Product analysis, hierarchy and cost planning
- Configured match rule set properties to enable searches according to business rules within MDM
- Created landing, staging, and base objects
- Developed data validation and trust settings
- Also, utilized Informatica MDM Hub to execute batch jobs
- Loaded data from Informatica MDM landing to staging
- Defined requirements for data matching, merging rules, and data stewardship workflows
- Designed data hierarchy management for Informatica MDM
- Executed jobs using Batch Viewer and Batch Group
- Created batch scripts using Informatica and Oracle APIs
- Used the Hierarchies tool to configure entity base objects, entity types, and relationship bases
- Worked with Active VOS configuration
- Implemented Agile ECR model
- Design and configure Informatica MDM components (like match/merge rules, hierarchies, survivorship rules, etc.) and P360 Product Mastering, Syndication, and Supplier Portal
- Managed critical applications within the production database
- Converting BOM configurations into system-ready states
- Ensure data governance policies are applied and maintained, facilitating data stewardship, metadata management, and regulatory compliance
- Stabilized the production environment and Identified major data quality issues in MDM production
- Enhanced the performance of Informatica and Oracle objects
- Demonstrated expertise in Informatica matching components
Process Associate
Google
07.2015 - 11.2018
- Consolidating customer master solutions and supporting various modules related to the customer master
- Integrating customer data across operating companies while preserving operational and process independence in separate customer master instances
- Streamlining data delivery from the customer master environment to dependent data marts
- Providing sector-level customer analytics
- Gathering requirements, defining the scope, understanding business logic, preparing design documents, implementing designs, and publishing data
- Enhancing data quality through match analysis, system performance analysis, and tuning by adjusting existing cleanse functions and match rules
- Conducting technical and functional reviews
- Designing the overall solution for the project
- Exploring administrative functions, including role creation and metadata validation
Education
Bachelor's - Computer Science
Jawaharlal Nehru Technological University
Oracle Database SQL Certified - undefined
Oracle
Skills
- API
- Autosys
- Configuration
- CRM
- Data Cleansing
- Data Integration
- Data Modeling
- Data Quality
- Data Validation
- Implementation
- ETL
- Excel
- Flat Files
- Informatica
- MDM
- C360
- P360
- S360
- Active VOS
- Match & Merge
- Provisioning Tool
- IDD
- Microsoft Office
- MS Access
- Mule soft
- Oracle
- Oracle Database
- PL SQL
- Performance Analysis
- Product Analysis
- Servicenow
- SQL, SQL Server
- XML
Timeline
Lead MDM Consultant
Wesco
07.2023 - Current
Informatica MDM Developer
Abbott
04.2022 - 06.2023
Informatica MDM Developer
Novartis
06.2021 - 03.2022
Data Management Analyst
Hsbc
03.2019 - 06.2021
Process Associate
Google
07.2015 - 11.2018
Oracle Database SQL Certified - undefined
Oracle
Bachelor's - Computer Science
Jawaharlal Nehru Technological University
Similar Profiles
NICHOLAS VARGANICHOLAS VARGA
Inventory Manager at WESCOInventory Manager at WESCO
Annalee Elias-BarelaAnnalee Elias-Barela
Shipping Clerk at WESCOShipping Clerk at WESCO
Jeremias Florentino-MartinezJeremias Florentino-Martinez
Senior Associate at WESCOSenior Associate at WESCO
Macy PetersonMacy Peterson
Cashier at WescoCashier at Wesco
Hafsa SuleimanHafsa Suleiman
Personal Care Assistant at Sunshine ResidentialPersonal Care Assistant at Sunshine Residential