Debasmita Sur Dam Email and Phone Number

# Leading PGLS team of 10 which include different skills like SOA, ODI, OSB and PL/SQL from offshore.# Attaining approval, track, update and report to management.# Ensuring business solutions are commensurate with goals as well as priorities.# Identifying and interpreting customer requirements mainly for solution as well as services.# Preparing resource plan.# Solution design and development of complex integrations involving Oracle ERP, Legacy systems etc. using Oracle SOA and Oracle AIA and ODI.# Solution design (creating the technical design and mapping documents) the integrations in SOA Suite 11g, develop PoCs to check the feasibility of the Technical designs.# Design a common Error Handling mechanism of the BPEL processes involved in the integration.# Technical Feasibility analysis, Design and Develop the Interface prototype and complex integrations pertaining to Oracle Fusion Middleware.# Develop a deployment script which could migrate and deploy all the SOA composite artifacts into different environments.# Design and development of interface and conversion program pertaining to Oracle Apps.# Provide support for all the custom components which have gone into testing environment.# Provide support in configuration issues in E Business suite for production like Form customization, personalization, creating DFF, values sets, lookups etc for various custom components.# Creating customized oracle XML Publisher’s reports and registers the report in E-Business Suite as concurrent programs to the relevant request groups.# Preparation of Technical design documents for enhancements.# Tuning the performance of conversion, extension and reports code.# Quality review of code and documents of other team members.

# Issues to be communicated to the business and followed up till the fix.# Provide support for all the custom components which have gone into production# Developing and testing customized inbound/outbound interface program to handle the Issues in Integration by using oe_order_pub API.# Developing various custom PL/SQL programs: Custom Drop ship form and program (This is used to search the sales order line, which has to be drop shipped and Associate the line with an existing open purchase order. After that cancel the existing line and create a new line with source as EXTERNAL).# Development of various custom PL/SQL package to generate report in Excel format (Forecasting inventory balance report, inventory control report etc) and forms (Gains Repline Tool, Global Area).# Attaching the concurrent programs and reports to the relevant request groups.# Provide support in configuration issues in E Business suite for production like creating value sets, lookups etc for various custom components.# Any new functional requirement from the business is Tested, Verified and Reported before they are passed into Global Production.# Provide technical support during Assembly Testing, Integration Testing and User Acceptance Testing phases of enhancements and resolve them within a specific timeframe.# Writing Technical Design specification for the Functional design of custom components.# Technical and functional review of codes so that they meet the requirements.

# Issues to be communicated to the business and followed up till the fix.# Developing and testing integration interface program to transfer the data from Regional Instance to Global Instance through API, like: hr_employee_api,hr_person_api,hr_assignment_api,hr_assignment_extra_info_api,hr_person_address_api,hr_contract_api,hr_contact_api,hr_contact_rel_api,Per_Qualifications_Api, hr_maintain_proposal_api, hr_ex_employee_api, hr_periods_of_service_api etc.# Data Migration from Global Instance to Regional Instance.# As per user requirement to add extra logic to the Business APIs like ‘create_employee’ using User Hooks.# Provide support for all the custom components which have gone into production.# Provide support in configuration issues in E Business suite for production like creating DFF, values sets , lookups etc for various custom components.# Any new functional requirement from the business is Tested, Verified and Reported before they are passed into Global Production.# Provide technical support during Assembly Testing, Integration Testing and User Acceptance Testing phases of enhancements and resolve them within a specific timeframe.# Writing Technical Design specification for the Functional design of custom components.# Technical and functional review of codes so that they meet the requirements.