Developer Oracle

Sivanadiyan Kumarappan Mobile : +1-732-***-****

Email : adcl6v@r.postjobfree.com

Note : I am working at client location. Email is the best way to contact me.

Technical Skill: Oracle SOA, Oracle Integration cloud, Oracle Service Bus, SOA Cloud Service, SOA Cs

Professional Summary

I have 12 years of Integration / Middleware platform experience in planning, architecting, designing, building integration solutions using Oracle Fusion Middleware products (Service Oriented Architecture SOA, Oracle Service Bus OSB), Oracle Managed File Transfer (MFT), Oracle Integration Cloud OIC, SOA Cloud Service and specialized in integrating On-premise and Cloud applications.

PaaS - I have 4 years of Oracle Integration Cloud (OIC) experience to integrate on premise and cloud applications like Salesforce, concur, Bloomberg.

SaaS – Integrated Salesforce, Bloomberg, concur, Fusion HCM using Oracle SOA 12c and OIC.

Integrated Oracle/Cloud/Enterprise/Business Applications using Oracle SOA suite 12C, Oracle Integration Cloud (OIC), OSB 12c, AIA Foundation Pack 11.6, Oracle Pre-Built Integration Pack (PIP- O2A, O2C, AABC, OPSM).

SOAP & REST API- Expertise in developing SOA Composites/Web Services using BPEL, XML, XSLT, XPATH, WSDL.

API Security - Experienced in Oracle Api Cloud Service, Oracle Api Gateway to secure Api’s with oAuth 2.0 security standards and used OWSM policies.

Experienced in Integrating On-Premise Oracle applications like Oracle E-Business R12 (ERP), Oracle Siebel CRM, Oracle Billing and Revenue Management (BRM) with Cloud SaaS applications like Salesforce, Concur, Bloomberg.

Migration - Experienced in migrating the SOA integration platform from SOA 10g to 11g and 11g to 12C.

Experienced in architecting ENTERPRISE DATA MASTER (MDM) to integrate and maintain a single source of data for entire enterprise.

Developed OPSM Pre-Built Integration Pack in Oracle India to integrate Oracle EBS & OPSM using Oracle SOA 11g, AIA 3.0.

Expertise in using Oracle Fusion Middleware 12c technologies like Oracle BPEL, Mediator, Oracle SOA, Orcle Service Bus, Oracle AIA FP 11.1.1.6.0, Oracle JDeveloper, Oracle WebLogic, XSD, XML, XSLT, WSDL, SOAP, REST.

Experienced in architecting & building the integration project to adapt new BILLING system.

Extensively Worked with business and functional team to understand the As-Is/New requirements and designed integration flows to integrate internal on-premise applications and(or) external cloud applications.

Expertise in using SOA technology adapters Such as SFDC, JMS, File, FTP, Database, Oracle Applications, AQ and BAM Adapter for integration.

Expertise with BPEL process Orchestration for integrating ERP applications, Databases, legacy applications, Flat Files Java Message Service (JMS) Queues, Oracle Advanced Queues (AQ), Oracle Resource Adapters.

Implemented Oracle Pre-Built Integration pack(PIP) - Order 2 Cash 11.2, AABC 11.2 PIP’s and build Custom-interface’s to integrate Siebel CRM with CBS Billing System, OSM system and other systems.

Developed interfaces (Inbound & Outbound) using SOA, AIA 3.0 and integrated CRM with various external systems (Order Execution System, Logistics Systems, Provisioning Systems, Address Management system, Trouble Ticket system, Loyalty System etc.).

Implemented common Error handling to handle fault(s) using fault policies and notify detailed error(s) using email notification mechanism.

Experienced in developing Test Plans and Test Case Scenarios.

Extensively supported QA, SIT, PERF, UAT and fixed the bugs and enhanced code based on CR.

Excellent understanding in Project Life Cycle, Software Development Life cycle (SDLC) with various development methodologies based on Agile, scrum.

Strong functional, technical, analytical skills with excellent documentation, presentation, communication & Leadership skills.

Strong Project coordination skills to handle the project delivery and has extensive experience in managing a team.

Academic Credentials

Bachelor of Technology in Computer Science – B. Tech (CSE)

Shanmugha Arts, Science Technology and Research Academy

(SASTRA Deemed University), Thanjavur, Tamil Nadu, India.

Year of Graduation – 2005 with 6.89 / 10 (CGPA)

Technical Exposure

Languages - C, Java 2.0, Servlets 2.4, JSP 1.2, HTML, XML, JNDI, JDBC.

SOA / AIA Tech - Oracle SOA 12C, 11g (BPEL, Mediator, AIA 11.1.1.6), XML, XSD, XSLT, XQuery,

Oracle Service Bus (OSB) 12C, XPATH, Web Services, SOAP, REST, WSDL.

Apps Integrated - Oracle Siebel CRM, Oracle BRM, Oracle EBS, OSM (Fulfillment system)

Oracle Fusion HCM, MDM, OPSM, CBS billing, IBM Maximo, Jive.

Cloud Applications - Oracle Integrated Cloud (OIC), Salesforce, Bloomberg, Concur.

SOA Service Adapter - SFDC, JMS, DB, File, FTP, AQ, Apps, REST, Concur.

AIA Foundation Pack - AIA (11.1.1.5, 11.1.1.6).

Database - Oracle 12c, 11g.

Server - Oracle Weblogic 12C, 11g, SOA 12c, 11g.

IDE / Tools - Oracle JDeveloper 12C, 11g, SQL Developer, Soap UI 5.3.0, Tortoise SVN,

WinSCP 4.2.1, Putty, Eclipse 3.0, Bridge clarify.

User Story Tool - Version One, Jira v7.5.0

Code Repo Tools - GitHub, Tortoise SVN, Perforce, Project Locker.

Operating System - UNIX, LINUX, Windows NT, XP, Ms-Dos.

Architecture - MVC, Oracle Fusion 12C, 11g, Oracle AIA 2.5 & 3.0(BPEL, ABCS, Mediator).

Professional Experience

Working as a Programmer Analyst (SOA Developer) in Sunray Informatics, NJ from Sep 2014 to TILL DATE.

Worked as a SOA Developer in NetApp India Pvt Ltd, Bangalore from Jul 2013 to Sep 2014.

Worked as a Senior Associate in Cognizant Technology Solutions, Bangalore from May 2010 to Jun 2013.

oONSITE –T-Mobile, London (Sep 2011 to Mar 2012).

Worked as a Software Engineer in HCL Technologies, Chennai from Oct 2007 to May 2010.

oONSITE - ORACLE INDIA PVT LTD, Hyderabad (Jun 2009 to May 2010).

Projects

Digital Supply Chain (Procurement), Oracle EBS Integration (Finance) Apr’2017 to TILL DATE

Bechtel, Phoenix, AZ / Reston, VA Role: SOA Lead & Developer

Procurement Practice - The Scope of Digital Supply Chain project is to replace legacy procurement system (In-House java application) by replacing with Oracle-Procurement (Oracle EBS). Oracle SOA 12C, Oracle MFT and OIC has been used to integrate Oracle EBS, Oracle Transport Management (OTM), EDQ, EcoSys and Oracle Unifier. This type of systems integration allows completely electronic purchase order delivery, eliminating the use of or need for traditional PDF purchasing documentation entirely. Within the new system, the first ever B2B (business-to-business) transaction has taken place.

Finance Practice – Integrating PO, Rentals, Fixed Assets, Inventory Item, Receipts, AP Invoice, concur (List, List Items), Expenses, Forex Rate (Bloomberg) using Oracle SOA 12c and Oracle Integration Cloud (OIC).

Responsibilities:

Working with functional and business team to understand the As Is and New requirements.

Designing/Architecting integration flows to integrate Procurement and Finance portfolio applications which are on premise and cloud applications.

Integrating Cost Code flow with Oracle EBS/EcoSys, Forex Rate flow to integrate Oracle EBS/OTM/Unifier and scheduled ESS job to run every day automatically, AP Invoice flow to integrate Oracle EBS and Ecosys.

Integrating Asset OnRent / OffRent, Fixed Assets, Inventory Item, Purchase Order, Receipts, Forex Rate with Oracle EBS R12 application with Human Workflow.

OIC - Integrating List, List Items, Employees (User), Expense between Oracle EBS and Concur cloud application.

Implemented Oracle MFT (Source, Transfer, Target) to transfer files between remote servers using Ftp, Sftp.

Working to integrate Bloomberg Cloud application to get & load Forex daily based on ESS (Scheduler) in SOA.

Developed the re-usable SOAP & REST services (SOA and OSB services) based on the Jira Story with re-try mechanism, Error Handling, Email Notification and Technical design document with flow & sequence diagrams.

Code Fix done in couple of production issue to enhance the process stability and increase the performance.

Please click here to know the Common Responsibilities and environments used in SOA Project

Salesforce Transformation Nov 2015 to Apr’2017

Rackspace, San Antonio, TX Role: SOA Developer & Lead

The Scope of the Sales MVP project is to integrate Current SFDC and new SFDC to synchronize Companies, Accounts, contacts, Account Contact Role, Opportunities, Quotes, Quote Lines, Deal Center, Opportunity Focus Area, Opportunity Team Member, Sales Support Portfolio, Opportunity Competitor, Opportunity Partner Role, Task, Event to help Enterprise Sales Reps can properly understand, sell, and market to customers and prospects. Also, it improves the ability to sell to Major Accounts and manage opportunities for Enterprise customers/prospects. Oracle SOA 12c & Oracle Integration Cloud (OIC) is used to integrate.

Responsibilities:

Worked with Enterprise Architecture team to understand the objects/flows to integrate between 2 Salesforce systems.

Architected and Designed the technical flow between current and new SFDC based on the Jira User Story with re-try mechanism, Error Handling, Email Notification and created FMW Wiki page (Technical design document) with flow & sequence diagrams.

Developed re-usable SOA/OSB Services to integrate a max of 100 (Company, Accounts, contacts, Account Contact Role, Opportunities, Quotes, Quote Line, Deal Center) in one Transactions as BULK SOAP Request using JMS adapter, SFDC Adapter, error handling mechanism with 3 re-try to reprocess, E-mail notification and config plans.

OIC - Developed re-usable Oracle Integration Cloud Services (OIC) to integrate Opportunity Focus Area, Opportunity Team Member, Sales Support Portfolio, Opportunity Competitor, Opportunity Partner Role, Task and Event.

Please click here to know the Common Responsibilities and environments used in SOA Project

Finance Transformation (EBS R12) Oct 2014 to Nov 2015

Sun Edison, Belmont, CA Role: SOA Developer & Lead

Scope: The Scope of the Finance Transformation project is to rollout Oracle EBS R12 as an enterprise finance application and my scope is to integrate the Oracle EBS R12, Oracle Fusion HCM, MDM (Custom application), IBM Maximo, SAM, Jive (Intranet Application), iCertis (Contract Management Application) using Oracle SOA 12C (Real Time Integration Layer).

ROLES AND RESPONSIBILITIES IN THE PROJECT

Worked with functional/Business team to understand the list of flows to integrate between all systems.

Prepared SOA/OSB Technical Design doc with sequence flows and blocks diagrams for all flows.

Designed & Developed re-usable SOA and OSB service to integrate all systems with error handling mechanism, E-mail notification mechanism and re-processing mechanism.

Oracle Outbound Master flows – Integrated Supplier, Item, Project, Customer and Employee to all boundary systems.

MDM to EBS flows – Integrated ChartofAccount, ChatofAccountHierarchy and Legal Entity

Maximo to EBS flows – Integrated Purchase Request, Purchase Order, PR & PO Status, Receipts, Invoice, Labor Hours, and Inventory Issue/Returns.

Integrated HCM with Jive/Spark cloud application to integrate employee data.

Integrated SAM with iCertis cloud application (Contract Management) to integrate project information’s data.

SAM to EBS flows - Integrated Projects and ProjectCostBudgeting flow.

All re-usable SOA services are developed using JMS/DB/Oracle Apps adapter, Fault policy with re-try and Email notification.

Please click here to know the Common Responsibilities and environments used in SOA Project

Enterprise Master Data Jul 2013 to Sep 2014

NetApp India Pvt Ltd, Bangalore, India Role: SOA Developer & Tech Lead

Scope: The Scope of the project is to develop a single ENTERPRISE MASTER database to establish a single Source of data and Oracle SOA (Real Time Integration Layer) will be used to integrate enterprise master database with all applications. My scope is to integrate SFDC, Oracle ERP R12(Quotes & Oppty), Oracle ERP R12(Fulfillment System), Agile, Next CRM, Entitlements, Master Data and HR systems by using oracle SOA 11g.

ROLES AND RESPONSIBILITIES IN THE PROJECT

Worked with architecture team in analyzing the current business applications and its integration layers in the production system, identified and prepared the list of business process & functions integrated with all systems.

Designed ENTERPRISE DATA MASTER Project to integrate the existing & new business process and its functions with sequence diagrams, flow diagrams.

Integrated Quote & Opportunity with EDM System by using DB & JMS Adapter with transaction rollback feasibility.

Developed re-usable SOA, OSB composites with transformation, fault handling, fault policy, File/Database/AQ/JMS Adapter.

Integrated Salesforce system with EDM.

Responsible for fixing production bugs and the issues by preparing RCA

Prepared Impact Analysis document, code fix, unit testing, DIT, SIT.

Parallel, worked in developing dynamic Manufacturing B2B simulator to simulate the various B2B Partner messages (3A4, 3A4c, 3B2, 3B11, 3B13).

Cleaned up all the Manufacturing domain related SOA services by removing the concrete wsdl and keeping the abstract wsdl’s to remove the deployment dependency.

Please click here to know the Common Responsibilities and environments used in SOA Project

Next Gen BSS Oct 2012 to Jun 2013

VIVA Telecom, Saudi (CTS) Role: SOA Developer & Tech Lead

Scope : The Scope of the project is to integrate CBS billing system and OSM(Fulfillment system) and to migrate entire middleware system from Oracle 10g to 11g.

To integrate this new systems O2C 11.2 & AABC 11.2 PIP is used to implement and newly build custom-interfaces to integrate Siebel CRM with CBS billing system, OSM system, Macalla Payment system, IVR, ASAP, Network system, other systems and migration of entire AS-IS system from 10g to 11g.

O2C 11.2 PIP has been used to integrate Product, Customer and Order flows between Siebel CRM and CBS billing system and AABC 11.2 has been used to integrate Acc balance, Invoice, Service Usage, Payment and Adjustment flows between all the above systems.

Custom Services has been developed by using AIA FP 11.1.1.6 to integrate SR, CUG, MNP, Work Order, Query/Enquiries modules with Siebel CRM, CBS, OSM and Network systems.

Migration - All integration flows between all applications are migrated from 10g to 11g.

ROLES AND RESPONSIBILITIES IN THE PROJECT

Implemented O2C 11.2 PIP by customizing Req/Prov ABCS services to integrate Customer flow between Siebel CRM and CBS billing system.

Implemented AABC 11.2 PIP by customizing all service transformations to enrich and used CAVS for testing.

Developed new SOA services to integrate Siebel CRM, CBS billing system, OSM system, Macalla Payment system, IVR, ASAP, Network system, other systems.

Migrated all SOA 10g services to 11g services and customized 11g SOA services as per new requirement with mappings, fault handling and fault policies

Interacted with design leads to come up with integration flows for all modules with current business scenarios.

Worked in designing the flows between all systems and prepared Technical design doc with sequence diagrams, source and target system mappings.

Developed re-usable SOA services using File Adapter, Database Adapter, AQ Adapter and JMS Adapter.

Unit testing and code review of all services developed by team members.

Supported for SIT and UAT and responsible for bug fixing.

Please click here to know the Common Responsibilities and environments used in SOA Project

ngCRM (Next Generation CRM) May 2010 to Sep 2012

T-Mobile, UK (CTS) Role: SOA Developer & Tech Lead

Scope : The scope of the project is to integrate the ngCRM - Siebel CRM(8.1.1.3) with various external systems or legacy or other NG-IT systems by using Oracle fusion Middleware 11g and AIA 3.0 foundation pack.

This project has been designed & developed in the concept of KERNEL & LOCALIZATION approach.

KERNEL : The kernel contains three core products that deliver the CRM functionality: Oracle Siebel as core CRM system, numerous integration services, an order execution engine (OE) for CRM-triggered order-management.

Localization : Once the kernel has been released. Country specific business requirements will be customized on top of Kernel (Siebel CRM, AIA Integration Services and Order Execution Engine). Localization is implemented for Hungary, Macedonia, Czech Republic, Slovakia and UK.

ROLES AND RESPONSIBILITIES IN THE PROJECT

Worked with architecture team to understand the flows to be integrated in the kernel and localization.

Created Technical Design document based on functional design document with Sequence diagrams.

Developed integration services (Inbound & Outbound) using SOA, AIA 3.0 with AIA Error Handling Framework, CAVS Simulator and integrated Siebel CRM (8.1.1.3) with various external systems (Order Execution System, Logistics Systems, Provisioning Systems, Address Management system, Trouble Ticket system, Loyalty System, legacy systems, NG-IT Systems etc).

Developed integration services with file, JMS adaptor to integrate Siebel CRM with Document Management System.

CAVS has been enabled for all AIA services, configured simulator to provide the response.

Schematron (.sch) has been used to validate the incoming payloads.

Responsible for Unit testing, SIT UAT and bug fixing and huge deployment done using script.

Localization – Worked as a TECH LEAD from UK (ONSITE) for customizing UK specific requirements on-top-of KERNEL code and supported for SIT & UAT & Prod rollout.

Oracle Fusion Middle ware 11.1.1.4, AIA 3.0, SOA Backplane (SOA BP) is used.

Please click here to know the Common Responsibilities and environments used in SOA Project

OPSM Integration (Oracle Pedigree and Serialization Manager) Apr 2008 to Apr 2010

Oracle India (HCL) Role: SOA Developer

Scope : The scope of the product (OPSM PIP - Advanced Shipment Notice and Return receipts) is to integrate Oracle E-Business Suite with OPSM thru oracle fusion middleware (Application Integration Architecture).

The first integration between OPSM and Oracle E-Business Suites will be designed to address the primary use cases around synchronization of product and lot information, Advance shipment notice and Return Receipts.

Oracle Pedigree and Serialization Manager (OPSM) is an edge application designed to address drug package serialization capabilities. The system will manage the creation of globally unique serials and will capture information about the serials and serial transactions that will provide a foundation for serialized item verification. It requires integration with the transactional systems that manage business processes relevant to serialization and serialized item tracking. Those processes are Manufacturing, Packaging, Shipping, Receiving, and Returns.

Training Attended: SOA 11g, AIA, JDev trainings have been given by ORACLE UNIVERSITY.

Responsibilities:

Based on Functional doc, Prepared the Technical Design Document with sequence flow diagram, details of ABCS, EBS and transformations for the ADVANCES SHIPMENT NOTICE & RETURN RECEIPTS PIP.

Integrated Oracle EBs and OPSM with synchronization of product and lot information, Advance shipment notice and Return Receipts.

Developed the composites for producing & consuming messages using JMS queue & Adapter.

Developed Requestor ABCS with transformation from ABM to EBM, EBS and Provider ABCS with transformation from EBM to ABM.

Demoed the fixed functionality to product owner and business users and stake holders.

Unit Tested Web Services using SOAP UI, BPEL Console, Test Suites and Documentation.

Responsible for unit testing, involved in integration testing, QA Testing and Supported UAT and bug fixing.

Oracle Fusion Middleware 11g, AIA 3.0 is used.

One Bill / Customer Focused Billing (BSS) Oct 2007 to Mar 2008

British Telecom, UK (HCL) Role: SOA Developer and Production Support Engineer

Scope: The scope of the project is to provide one bill (consolidated bill) for a CFB customer.

Integrate bills from BT’s unit billing systems to generate one consolidated bill for corporate and high-end customers.

Bills produced by the source billing systems (CSS, PCB-IS, Geneva – Brecon, DISE etc.,), for source accounts that are to be consolidated by CFB and provide the one bill/invoice to the CFB customers. Product order handling is done primarily in Customer Manager Server (CM). Once Invoices are successfully dispatched the details of the Invoices are sent to the Accounts Receivable System (RADAR) and Payments for the CFB invoices will be received at RADAR.

Got the complete knowledge from existing vendor, documented & transferred the knowledge to my team members.

Responsibilities:

Involved in the coding of Manual Input module and Post Invoice Processing (PIP) module in the CFB application, unit testing and prepares the detailed process documentation.

Application support - Solving the issues faced by the application users in UK business hours.

Production support – Monitoring & fixing the issues for the batch & online jobs.

Coordinating with Onsite Team to solve the issues rise in UK business hours.

Worked as one of the leads for a shift in 24*7*365 support system for CFB.

Generating the monthly report (BB4B) to know no of customers in CFB, revenues, etc.

Common Responsibilities in SOA Project

Requirement - Worked with functional team, Business Team, Architecture Team to understand the project requirements and come up with over all integration design flows between all systems with sequence/Flow/Block diagrams.

Design - Prepared Integration functional and Technical Design Documents.

Data Mapping - Identified the list of elements/Data needs to be mapped for each and every Integration flows.

Development - Developed re-usable SOA composites with JMS, File, FTP, DB, Cloud(Salesforce), AQ Adapters.

Oracle Pre-Built Integration Pack (PIP) - Implemented Order2Cash (O2C) 11.2 PIP, AgentAssistedBillingCare (AABC) by customizing EBF, Requestor and Provider ABCS services to integrate Customer flow between Siebel CRM and CBS billing system.

CAVS (Simulator) - Extensively used CAVS to simulate the target application response and used heavily for web service testing.

Created JMS Queues, JMS/DB JNDI, JMS/DB Outbound Conn pool in weblogic server manually and thru Jenkins also.

Created XSD, WSDL, Custom EBO, EBM to add more elements as per business requirement.

MDS (Metadata Data Store) - Extensively used MDS to store re-usable artifacts (XSD, WSDL, XSLT, DVM, XREF).

Extensively used XSLT Transformations to enhance and map complex mappings as per Target application formats.

XSLT template created for Complex transformation.

Developed Requestor ABCS with transformation from ABM to EBM, EBS and Provider ABCS with transformation from EBM to ABM with complex BPEL, XSLT mapping, DVM (With qualifier column), XREF, Fault/Error Handling with Email notification and re-processing mechanism.

Developed SOA configuration plans to support deployments to multiple UPPER SOA environments.

Responsible for Unit Testing, End-to-End Testing and Wiki Documentation.

Responsible for creating deployment document to move the code to UPPER Environments.

Responsible for fixing the bugs and code update as part of CR process.

Testing - Performed Unit/E2E Testing and supported UAT, Production Release and fixing issues.

Tested the Web Services using SOAP UI, BPEL Console and Test Suites.

Deployment - Prepared rollout document with pre-Deployment, deployment and rollback instructions.

Responsible to provide KT to colleagues in my team.

Prepared Production rollout document with pre-Deployment, deployment and rollback instructions.

Environments & Tools Used in SOA Project:

Oracle fusion middleware 12C, 11g (Weblogic Server, SOA Suite, Web Services, Oracle 11g database, Oracle Enterprise Manager 11g), AIA FP 11.6 (BPEL, ABCS, and Mediator), OSB, OracleB2B, DB/File/JMS Adaptor, Java and UNIX. Oracle JDeveloper 12C, 11g, Perforce, WinScp, HP ALM 11.0, HP QC 10.0.

Resume Last Updated on Feb-2020

Contact this candidate