Siva Modem

Self-motivated Integration Architect with 7 years of experience in Data Warehouse Management using Informatica IICS, TALEND and Realtime Application integrations using Oracle OIC, SOA, OSB and MuleSoft Anypoint Platform. Effectively collaborates with multifunctional roles to pinpoint and exploit potential areas for development in all types of Organizational Data and Application integrations.

Project 1: IICS Data Integration (Enterprise Data Warehouse)

• Designed and implemented mappings using IICS.
• Integrated data from multiple sources in batch and near real time.
• Used mapping, MCT, task Flow, liner task Flow and Task-Sync Jobs.
• Well versed with SFDC, ServiceNow, CRM Dynamics integration and sync jobs.
• Conceptualization, Creation and tagging of data cataloguing from Data- profiling results.
• Installed and configured Linux secured agent register with IICS org.
• Used extensively transformations like Aggregator, expression, filter, lookup and joiner.
• Manage and drive data quality and integrity through checks and validations.
• collate data quality issues, drive remediation, and Manage reconciliation processes
• Coordinate and communicate with the offshore for resolving Production Issues/Disputes.
• Interacts Auditors for audit reporting and queries.
• Implementing adhoc data analysis requests from Analytics team.

Project 2: Realtime Application Integrations (Oracle ERP, Salesforce and Service Now)

• Understanding the functional requirements & Design Specifications
• Designing the technical Specification documents
• Developing the code with DB Adapters, Oracle Apps Adapter, REST API technologies and Query Parameters in OIC.
• Migrating On-prem SOA, OSB Integrations to OIC.
• Designing the canonical XML Schemas and doing transformations with XSLT.
• Worked on integrating cloud systems like Oracle ERP, Salesforce, Service-now and CRM Dynamics.
• Implemented Shell script to change file permissions and converting XML files.
• Used SVN as a version management tool.
• Design and implemented Fault Handling Services.
• Preparation of Unit Test Cases.

Project 3: Shared Data Services (MuleSoft) 

• Upgrade each OSB Application to MuleSoft application
• Replace the deprecated Data Mapper with Data Weave elements. Write Data Weave code to transform messages into the target formats.
• Replace other deprecated components like HTTP Transport and Message Properties with HTTP Connector and Variable elements.
• Using the server runtimes 4.3.0 in each application. Edit POM.XML files to reflect the new version.
• Replace MMC deployment plugin with Anypoint Runtime Manager plugin in POM.XML.
• Learned to use Anypoint Runtime Manager to handler application deployments and logging.
• Deployed upgraded template projects onto Anypoint Exchange for reuse.